【正文】 頁(yè)面。如圖 42所示，此模塊提供了用戶信息的錄入功能，首先在將用戶注冊(cè)信息添加到數(shù)據(jù)庫(kù)的應(yīng)用中時(shí)，調(diào)用了存儲(chǔ)過(guò)程。若想發(fā)布項(xiàng)目信息，首要條件是用戶已經(jīng)成為系統(tǒng)會(huì)員，然后可以添加要競(jìng)拍的項(xiàng)目，并編輯以添加項(xiàng)目的信息。 (3)在投標(biāo)中需要包含對(duì)每個(gè)項(xiàng)目的出價(jià)的信息。 表 51 系統(tǒng)數(shù)據(jù)表的簡(jiǎn)要描述 表 52 用戶信息表 (Person) 字段名 數(shù)據(jù)類型 長(zhǎng)度 允許為空 是否為主鍵 說(shuō)明 PersonID bigint 8 否 是 唯一標(biāo)識(shí) FamilyName varchar 255 否 登錄名 GivenName varchar 255 否 真實(shí)名 EmailAddress varchar 255 否 郵箱地址 Password varchar 255 否 密碼 StreetAddress1 varchar 255 否 單位地址 StreetAddress2 varchar 255 是 地址 City varchar 255 是 城市 State varchar 255 是 狀態(tài) PostalCode varchar 10 是 郵政編碼 Country varchar 255 是 所屬國(guó)家 Active char 1 是 行為 LastLogin datetime 8 是 最后登錄時(shí)間 表 描述 Person 包含系統(tǒng)中所有注冊(cè)用戶的資料 Item 包含待售或以售項(xiàng)目的信息 Bid 包含每個(gè) Item出價(jià)的信息 Sale 包含每項(xiàng)銷售的信息，包括被出價(jià)的項(xiàng)目和出價(jià)者 Id Seller 包含 Person出售的項(xiàng)目信息 表 53 Seller表 字段名 數(shù)據(jù)類型 長(zhǎng)度 是否允許為 空 是否為主鍵 說(shuō)明 ID bigint 8 是 唯一標(biāo)識(shí) PersonID bigint 8 用戶 ID ItemsListed int 4 所列項(xiàng)目 ItemsActive int 4 活躍項(xiàng)目 LastActivity datetime 8 最后一項(xiàng)活動(dòng) 表 54 Item表 字段名 數(shù)據(jù)類型 長(zhǎng)度 是否允許為空 是否為主鍵 說(shuō)明 ItemID bigint 8 是 唯一標(biāo)識(shí) ItemName varchar 500 項(xiàng)目名稱 Description varchar 1000 是 項(xiàng)目描述 AskingPrice money 8 要求價(jià)格 NotifyPrice money 8 是 通報(bào)價(jià)格 SellerID bigint 8 賣方 ID ListingDate datetime 8 上部時(shí)間 ExpirationDate datetime 8 到期 ItemStatus varchar 10 狀態(tài) 表 55 Bid表 字段名 數(shù)據(jù)類型 長(zhǎng)度 是否允許為空 是否為主鍵 說(shuō)明 BidID bigint 8 是 唯一標(biāo)識(shí) ItemID bigint 8 項(xiàng)目 ID BidderID bigint 8 投標(biāo)者 ID Timestamp datetime 8 時(shí)間戳 BidAmount money 8 投標(biāo)金額 BidChange money 8 變更 表 56 sale表 字段名 數(shù)據(jù)類型 長(zhǎng)度 是否允許為空 是否為主鍵 說(shuō)明 SaleID bigint 8 是 唯一標(biāo)識(shí) ItemID bigint 8 項(xiàng)目 ID WinningBid money 8 中標(biāo) BuyerID bigint 8 買家 ID sellerApproval char 1 賣方審批 BuyerAcceptance char 1 買方驗(yàn)收 Completiondate Datetime 8 竣工日期 創(chuàng)建表的腳本文件 數(shù)據(jù)表在創(chuàng)建完畢后，前面已經(jīng)介紹了所有表數(shù)據(jù)表的結(jié)構(gòu)、內(nèi)容及各表之間的關(guān)系，還要生成 SQL腳本文件。 表 57 存儲(chǔ)過(guò)程表 存 儲(chǔ) 過(guò) 程 描 述 sp_bid_isp 添加一條用戶的競(jìng)價(jià) sp_Get_Bid_Details 獲取某件項(xiàng)目所有競(jìng)價(jià)的詳細(xì)信息 sp_item_dsp 刪除某件項(xiàng)目 sp_get_highest_bid 獲取某件項(xiàng)目的最高競(jìng)價(jià) sp_item_isp 添加一件項(xiàng)目 sp_item_sel 返回某用戶的項(xiàng)目 sp_item_usp 更新某件項(xiàng)目信息 sp_items_for_sale 返回所有可以競(jìng)價(jià)的項(xiàng)目 sp_login 處理用戶登錄事件 sp_my_winning_bids 返回某用戶當(dāng)前競(jìng)標(biāo)于領(lǐng)先地位的所有項(xiàng)目 sp_person_isp 添加一個(gè)用戶信 息 sp_person_sel 通過(guò)用戶名即郵件地址來(lái)查詢一個(gè)用戶 sp_person_sel_by_id 查詢某條競(jìng)標(biāo)信息的競(jìng)標(biāo)者信息 sp_person_usp 更新用戶信息 sp_sale_plete 完成某個(gè)項(xiàng)目的交易 sp_sale_isp 為某個(gè)項(xiàng)目增加一次成功的交易記錄 6 系統(tǒng)總體實(shí)現(xiàn) 本系統(tǒng)使用 Pagelet控件技術(shù)編寫了 件。database=bids。在首頁(yè)面單擊“注冊(cè)”鏈接進(jìn)入該頁(yè)面，此頁(yè)面不僅可以讓用戶注冊(cè)添加個(gè)人用戶信息，同時(shí)它也是修改注冊(cè)信息的界面。 obj = new ()。 = 。 } else { Process = ADD。 [].Value = 。 } else if( 1) { = Update Failed! + strStatus。 [PersonID].Value = ()。 //通過(guò) Tools類中的 :public static bool IsLoggedIn()方法 ,并用該方法去判斷用戶是否已經(jīng)登錄。 { objItemList = new ()。 結(jié) 論 本文主要分析了實(shí)現(xiàn)招投標(biāo)系統(tǒng)的主要方法，并對(duì)招投標(biāo)的主要功能做了描述。例如：許多數(shù)字項(xiàng)字段沒(méi)有驗(yàn)證；當(dāng)編輯用戶信息時(shí)，必須強(qiáng)制輸入密碼，確保密碼匹配等等。 [7] 李明剛 , 肖建． ASP． NET Web 站點(diǎn)高級(jí)編程范例 [M]．北京：清華大學(xué)出版社， 2021。 關(guān)于學(xué)位論文使用權(quán)和研究成果知識(shí)產(chǎn)權(quán)的說(shuō)明： 本人完全了解成都信息工程學(xué)院有關(guān)保管使用學(xué)位論文的規(guī)定，其中包括： （ 1）學(xué)校有權(quán)保管并向有關(guān)部門遞交學(xué)位論文的原件與復(fù)印件。s really a pleasure now and then to bee a mere nothing, especially when a man is as highly placed as I am. And then to think that we all, even with patent lacquer, are nothing more than insects of a moment on that anthill the earth, though we may be insects with stars and garters, places and offices! One feels quite a novice beside these venerable millionyearold boulders. On last New Year39。 but a ccording to die French proverb。 omnium, quae cHxerat jeceratque, arte quadam ostentator: for that proceeds not of vanity, but of natural magnanimity, and discretion: and in som e persons is not only ely, but gracious. For excusations, cessions, modesty itself well governed, are but arts of ostentation. And amongst those arts there is none better, than that which Plinius Secundus speaketh of。 and the slaves of their own vaunts. LastIndexNext And now having spoken of assaults, let us sum up all acts ofviolence under a single law, which shall be as follows:No one shallta ke or carry away any of his neighbour39。 but he who did must have supposed one of threethingseither that they did not exist,which is the first possibility,or secondly, that, if they did, they took no care of man, orthirdly, that they were easily appeased and turned aside from theirpurpose, by sacrifices and prayers. Cleinias. What shall we say or do to these persons? Athenian Stranger. My good friend, let us first hear the jests whichI suspect that they in their superiority will utter against us. Cle. What jests? Ath. They will make some irreverent speech of this sort:O inhabitants of A thens, and Sparta, and Cnosus, they will reply, inthat you spea k truly。 and others that they are turned from their course bygifts. Now we have a right to claim , as you yourself allowed, in thematter of laws, that before you are hard upon us and threaten us,you should argue with us and convince usyou should f irst attempt toteach and persuade us that there are Gods by reasonable evidences, andalso that they are too good to be unrighteous, or to be propitiated,or turned from the ir course by gifts. For when we hear such thingssaid of them by those who are esteemed to be the best of poets, andorators, and prophets, and priests, and by innumerable others, thethoughts of most of us are not set upon abstaining from unrighteousacts, but upon doing them and atoning for them. When lawgivers prof essthat they are gentle and not stern, we think that they should f irst ofall use persuasion to us, and show us the existence of Gods, if not ina better manner than other men, at any rate in a truer。s without the consent of theowner。s self hath any perfection. For saith Pliny very wittily。 there are some