【正文】 數(shù)據(jù)類型 長度 是否允許為空 是否為主鍵 說明 BidID bigint 8 是 唯一標(biāo)識 ItemID bigint 8 項目 ID BidderID bigint 8 投標(biāo)者 ID Timestamp datetime 8 時間戳 BidAmount money 8 投標(biāo)金額 BidChange money 8 變更 表 56 sale表 字段名 數(shù)據(jù)類型 長度 是否允許為空 是否為主鍵 說明 SaleID bigint 8 是 唯一標(biāo)識 ItemID bigint 8 項目 ID WinningBid money 8 中標(biāo) BuyerID bigint 8 買家 ID sellerApproval char 1 賣方審批 BuyerAcceptance char 1 買方驗收 Completiondate Datetime 8 竣工日期 創(chuàng)建表的腳本文件 數(shù)據(jù)表在創(chuàng)建完畢后，前面已經(jīng)介紹了所有表數(shù)據(jù)表的結(jié)構(gòu)、內(nèi)容及各表之間的關(guān)系，還要生成 SQL腳本文件。 表 57 存儲過程表 存 儲 過 程 描 述 sp_bid_isp 添加一條用戶的競價 sp_Get_Bid_Details 獲取某件項目所有競價的詳細(xì)信息 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 返回某用戶當(dāng)前競標(biāo)于領(lǐng)先地位的所有項目 sp_person_isp 添加一個用戶信 息 sp_person_sel 通過用戶名即郵件地址來查詢一個用戶 sp_person_sel_by_id 查詢某條競標(biāo)信息的競標(biāo)者信息 sp_person_usp 更新用戶信息 sp_sale_plete 完成某個項目的交易 sp_sale_isp 為某個項目增加一次成功的交易記錄 6 系統(tǒng)總體實(shí)現(xiàn) 本系統(tǒng)使用 Pagelet控件技術(shù)編寫了 件。database=bids。在首頁面單擊“注冊”鏈接進(jìn)入該頁面，此頁面不僅可以讓用戶注冊添加個人用戶信息，同時它也是修改注冊信息的界面。 obj = new ()。 = 。 } else { Process = ADD。 [].Value = 。 } else if( 1) { = Update Failed! + strStatus。 [PersonID].Value = ()。 //通過 Tools類中的 :public static bool IsLoggedIn()方法 ,并用該方法去判斷用戶是否已經(jīng)登錄。 { objItemList = new ()。 結(jié) 論 本文主要分析了實(shí)現(xiàn)招投標(biāo)系統(tǒng)的主要方法，并對招投標(biāo)的主要功能做了描述。例如：許多數(shù)字項字段沒有驗證；當(dāng)編輯用戶信息時，必須強(qiáng)制輸入密碼，確保密碼匹配等等。 [7] 李明剛 , 肖建． ASP． NET Web 站點(diǎn)高級編程范例 [M]．北京：清華大學(xué)出版社， 2021。 關(guān)于學(xué)位論文使用權(quán)和研究成果知識產(chǎn)權(quán)的說明： 本人完全了解成都信息工程學(xué)院有關(guān)保管使用學(xué)位論文的規(guī)定，其中包括： （ 1）學(xué)校有權(quán)保管并向有關(guān)部門遞交學(xué)位論文的原件與復(fù)印件。 the fairest music is that whichdelights the best and best educated, and especially that whichdelights the one man who is preeminent in virtue and education. Andtherefore the judges must be men of character, for they will requireboth wisdom and courage。 and these pleasures are so farfrom being the same, as you describe the Egyptian to be, or having thesame principle s, that they are never the same. Ath. Most true, Cleinias。 or, again, to be a tyrant and do as youlike 。 but not so great, if the bad man lives only a very shorttime. These are the truths which, if I am not mistaken, you willpersuade or c ompel your poets to utter with suitable acpaniments ofharmony and rhythm, and in these they must train up your youth. Am Inot right? For I plainly declare that evils as they are termed aregoods to the unjust, and only evils to the just, and that goods aretruly good to the good, but evil to the evil. Let me ask again, Areyou and I agreed about this? Cle. I think that we partly agree and partly do not. Ath. When a man has health and wealth and a tyranny which lasts, andwhen he is preeminent in strength and courage, and has th e gif t ofimmortality, and none of the socalled evils which counterbalancethese goods, but only the injustice and insolence of his own natureofsuch an one you are, I suspect, unwilling to believe that he ismiserable rather than happy. Cle. That is quite true. Ath. Once more: Suppose that he be valiant and strong, andhandsome and rich, and does throughout his whole life whatever helikes, still, if he be unrighteous and insolent, would not both of youagre e that he will of necessity live basely? You will surely grantso much? Cle. Certainly. Ath. And an evil life too? Cle. I am not equally disposed to grant that. Ath. Will he not live painfully and to his own disadvantage? Cle. How can I possibly say so? Ath. How! Then may Heaven make us to be of one mind, for now weare of tw o. To me, dear Cleinias, the truth of what I am saying isas plain as the fact that Crete is an island. And, if I were alawgiver, I would try to ma ke the poets and all the citizens spea kin this strain, and I would inflict the heaviest penalties on anyone in all the land who should dare to say that there are bad menwho lead pleasant lives, or that the profitable and gainful is ohing, and the just another。 and hence there occurreda misapprehension on your part. For when evils are far gone andirremediable, the task of censuring them is never pleasant, althoughat times necessary. But as we do not really differ, will you let meask you whether you consider such institutions to be more prevalentamong the Cretans and Lacedaemonians than among the other Hellenes? Cle. Certainly they are. Ath. And if they were extended to the other Hellenes, would it be animprovement on the present state of things? Cle. A very great improvement, if the customs which prevail amongthem were such as prevail among us and the Lacedaemonians, and such asyou were just now saying ought to prevail. Ath. Let us see whether we understand one another:Are not theprinciples of education and music which prevail among you asfollows: you pel your poets to say that the good man, if he betemperate and just, is fortunate and happy。 nor again, knowing thetruth, ought he through cowardice and unmanliness carelessly todeliver a lying judgment, with the very same lips which have justappealed to the Gods before he judged. He is sitting not as thedisciple of the theatre, but, in his proper place, as theirinstructor, and he ought to be the enemy of all pandering to thepleasure of the spectators. The ancient and mon custom of Hellas,which still prevails in Italy and Sicily, did certainly leave thejudgment to the body of spectators, w ho determined the victor byshow of hands. But this custom has been the destruction of thepoets。 （ 3）學(xué)?？梢詫W(xué)術(shù)交流為目的復(fù)制、贈送和交換學(xué)位論文。 [9] 李偉紅． SQL Server 2021數(shù)據(jù)庫及應(yīng)用 [M]．北京：清華大學(xué)出版社， 2021。 參考文獻(xiàn) [1] 吉根林 ,崔海源． ASP． NET程序設(shè)計教程 [M]．北京：電子工業(yè)出版社， 2021。該系統(tǒng)是基于 B/S下利用 Visual SQL2021開發(fā)的，是一個實(shí)驗性的系統(tǒng)。 ()