【正文】 頁面。如圖 42所示，此模塊提供了用戶信息的錄入功能，首先在將用戶注冊信息添加到數(shù)據(jù)庫的應用中時，調(diào)用了存儲過程。若想發(fā)布項目信息，首要條件是用戶已經(jīng)成為系統(tǒng)會員，然后可以添加要競拍的項目，并編輯以添加項目的信息。 (3)在投標中需要包含對每個項目的出價的信息。 表 51 系統(tǒng)數(shù)據(jù)表的簡要描述 表 52 用戶信息表 (Person) 字段名 數(shù)據(jù)類型 長度 允許為空 是否為主鍵 說明 PersonID bigint 8 否 是 唯一標識 FamilyName varchar 255 否 登錄名 GivenName varchar 255 否 真實名 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 是 所屬國家 Active char 1 是 行為 LastLogin datetime 8 是 最后登錄時間 表 描述 Person 包含系統(tǒng)中所有注冊用戶的資料 Item 包含待售或以售項目的信息 Bid 包含每個 Item出價的信息 Sale 包含每項銷售的信息，包括被出價的項目和出價者 Id Seller 包含 Person出售的項目信息 表 53 Seller表 字段名 數(shù)據(jù)類型 長度 是否允許為 空 是否為主鍵 說明 ID bigint 8 是 唯一標識 PersonID bigint 8 用戶 ID ItemsListed int 4 所列項目 ItemsActive int 4 活躍項目 LastActivity datetime 8 最后一項活動 表 54 Item表 字段名 數(shù)據(jù)類型 長度 是否允許為空 是否為主鍵 說明 ItemID bigint 8 是 唯一標識 ItemName varchar 500 項目名稱 Description varchar 1000 是 項目描述 AskingPrice money 8 要求價格 NotifyPrice money 8 是 通報價格 SellerID bigint 8 賣方 ID ListingDate datetime 8 上部時間 ExpirationDate datetime 8 到期 ItemStatus varchar 10 狀態(tài) 表 55 Bid表 字段名 數(shù)據(jù)類型 長度 是否允許為空 是否為主鍵 說明 BidID bigint 8 是 唯一標識 ItemID bigint 8 項目 ID BidderID bigint 8 投標者 ID Timestamp datetime 8 時間戳 BidAmount money 8 投標金額 BidChange money 8 變更 表 56 sale表 字段名 數(shù)據(jù)類型 長度 是否允許為空 是否為主鍵 說明 SaleID bigint 8 是 唯一標識 ItemID bigint 8 項目 ID WinningBid money 8 中標 BuyerID bigint 8 買家 ID sellerApproval char 1 賣方審批 BuyerAcceptance char 1 買方驗收 Completiondate Datetime 8 竣工日期 創(chuàng)建表的腳本文件 數(shù)據(jù)表在創(chuàng)建完畢后，前面已經(jīng)介紹了所有表數(shù)據(jù)表的結構、內(nèi)容及各表之間的關系，還要生成 SQL腳本文件。 表 57 存儲過程表 存 儲 過 程 描 述 sp_bid_isp 添加一條用戶的競價 sp_Get_Bid_Details 獲取某件項目所有競價的詳細信息 sp_item_dsp 刪除某件項目 sp_get_highest_bid 獲取某件項目的最高競價 sp_item_isp 添加一件項目 sp_item_sel 返回某用戶的項目 sp_item_usp 更新某件項目信息 sp_items_for_sale 返回所有可以競價的項目 sp_login 處理用戶登錄事件 sp_my_winning_bids 返回某用戶當前競標于領先地位的所有項目 sp_person_isp 添加一個用戶信 息 sp_person_sel 通過用戶名即郵件地址來查詢一個用戶 sp_person_sel_by_id 查詢某條競標信息的競標者信息 sp_person_usp 更新用戶信息 sp_sale_plete 完成某個項目的交易 sp_sale_isp 為某個項目增加一次成功的交易記錄 6 系統(tǒng)總體實現(xiàn) 本系統(tǒng)使用 Pagelet控件技術編寫了 件。database=bids。在首頁面單擊“注冊”鏈接進入該頁面，此頁面不僅可以讓用戶注冊添加個人用戶信息，同時它也是修改注冊信息的界面。 obj = new ()。 = 。 } else { Process = ADD。 [].Value = 。 } else if( 1) { = Update Failed! + strStatus。 [PersonID].Value = ()。 //通過 Tools類中的 :public static bool IsLoggedIn()方法 ,并用該方法去判斷用戶是否已經(jīng)登錄。 { objItemList = new ()。 結 論 本文主要分析了實現(xiàn)招投標系統(tǒng)的主要方法，并對招投標的主要功能做了描述。例如：許多數(shù)字項字段沒有驗證；當編輯用戶信息時，必須強制輸入密碼，確保密碼匹配等等。 [7] 李明剛 , 肖建． ASP． NET Web 站點高級編程范例 [M]．北京：清華大學出版社， 2021。 關于學位論文使用權和研究成果知識產(chǎn)權的說明： 本人完全了解成都信息工程學院有關保管使用學位論文的規(guī)定，其中包括： （ 1）學校有權保管并向有關部門遞交學位論文的原件與復印件。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