web專(zhuān)周實(shí)驗(yàn)報(bào)告

一、項(xiàng)目要 (一)項(xiàng)目名稱(chēng) (二)功能說(shuō)明 二、項(xiàng)目開(kāi)發(fā)環(huán) 三、數(shù)據(jù)庫(kù)設(shè) 四、項(xiàng)目功能結(jié)構(gòu) 五、設(shè)計(jì)與實(shí) (一)分析問(wèn) (二)設(shè)計(jì)思 (三)功能實(shí) (四)算法、技巧及調(diào) 六、總 七、參考文 一、項(xiàng)目要目名稱(chēng)能說(shuō)明查看、修改記錄，原二、項(xiàng)目開(kāi)發(fā)環(huán)SQLserver2012；（1）館基本信息表（2）基本信息表用戶基本信息表公告/動(dòng)態(tài)表處罰原因 三、項(xiàng)目功能結(jié)構(gòu)四、設(shè)計(jì)與實(shí)F組長(zhǎng)：，負(fù)責(zé)：AJAX,數(shù)據(jù)庫(kù)，三層結(jié)構(gòu)編組員：夏冬霖，負(fù)責(zé)：CSS，資源(一 分析問(wèn)看不清時(shí)更新處理（用重新載入的方法(二 設(shè)計(jì)思方法，生成id。(三 功能實(shí)館信 功能的運(yùn)行效果圖、流程圖、代碼及注釋? 開(kāi)館時(shí)"古忠掃區(qū)總序苦岱陪甘吁；蒼慧 忠肚掌岊謚干盡窯志飛罷點(diǎn)昂巴總早·publicpublicclass{{館館簡(jiǎn)privatestring privatestringLib_Curator;//館長(zhǎng)致i否 privatetingLib_Opentime;//開(kāi)館時(shí)i否

ngLib_Distribtion;//館藏分 privatestring privatestringLib_Rule;//圖管會(huì)章是是privatestringLib_History;//歷史沿privatestringBorrow_Rule;//借還規(guī)則privatestringLib是User;//新用戶館培訓(xùn)privatestringLib_Work;//部門(mén)職public{}stringlib_tle,stringlib_rule,stringlib_work,stringlib_history,stringborrow_rule,string{Lib_Summry=lib_summry;Lib_Curator=lib_curator;Lib_Opentime=lib_opentime;Lib_Tle=lib_tle;Lib_Rule=lib_rule;Lib_Work=lib_work;Lib_History=lib_history;Borrow_Rule=borrow_rule;Lib_NewUser=}publicstring{get{returnLib_Summry;}set{Lib_Summry=value;}publicstring{get{returnLib_Curator;}set{Lib_Curator=value;}publicstring{get{returnLib_Opentime;}set{Lib_Opentime=value;}publicstring{get{returnLib_Distribtion;}set{Lib_Distribtion=value;}publicstring{get{returnLib_Tle;}set{Lib_Tle=value;}publicpublicstring{{getget{returnLib_Rule;setset{Lib_Rule=value;}}publicpublicstring{{getget{returnLib_Work;setset{Lib_Work=value;}}publicpublicstring{{getget{returnLib_History;setset{Lib_History=value;}}publicpublicstring{{get{returnLib_NewUser;get{returnLib_NewUser;set{Lib_NewUser=value;}publicstring{get{returnBorrow_Rule;set{Borrow_Rule=value;}}}publicclass{publicintEditLibrary(Library{stringsql=ibrarylibrary.Lib_summry,library.Lib_summry,library.Lib_curator,library.Lib_opentime,library.Lib_tle,library.Lib_rule,library.Lib_work,library.Lib_history,returnreturn}}publicpublicLibraryFindLibrary(Library{{stringstringsql=string.Format("select*fromLibrarySqlDataReaderSqlDataReadersdr=SqlHelper.ExecuteReader{{librarylibrary=newLibrary(sdr.GetString(0),sdr.GetString(1),sdr.GetString(3),sdr.GetString(3),sdr.GetString(4),sdr.GetString(6),sdr.GetString(6),sdr.GetString(7),sdr.GetString(8),}}returnreturnlibrary}}}}公 功能的運(yùn)行效果圖、流程圖、代碼及注釋publicclass{{privateprivateintNews_ID;/privatestringNews_Kind;//類(lèi)型（公告活動(dòng)privateDateTimeNews_Time;//發(fā)布日privatestringNews_Summry;//內(nèi)privatestringNews_Author;//發(fā)布privatestringNews_Name;//通知publicpublic{{publicpublicNews_base(intnews_id,stringnews_kind,stringnews_summry,DateTimenews_author,stringnews_author,string{{News_IDNews_ID=News_KindNews_Kind=News_TimeNews_Time=News_SummryNews_Summry=News_AuthorNews_Author=News_Name=}publicint{get{News_Name=}publicint{get{returnNews_ID;set{News_ID=value;}publicstring{get{returnNews_Kind;set{News_Kind=value;}publicDateTime{get{returnNews_Time;setset{News_Time=value;}}publicpublicstring{get{{get{returnNews_Summry;set{News_Summry=value;}publicpublicstring{{getget{returnNews_Author;setset{News_Author=value;}}publicpublicstring{{getget{returnNews_Name;setset{News_Name=value;}}}}publicclass{publicintAddNews(News_base{stringsql=string.Format("insertintonews.News_id,news.News_kind,news.News_summry,news.News_time,news.News_author,news.News_name);return}publicintDeleteNews(int{stringsql=string.Format("deleteNews_basewhereNews_ID='{0}'",news_id);returnSqlHelper.ExecuteNonQuery(sql);}publicintEditNews(News_base{stringsql=string.Format("updateNews_basesetnews.News_kind,news.News_summry,news.News_time,news.News_author,news.News_name,news.News_id);return}publicIList<News_base>FindNews(string{IList<News_base>list=newstringsql=string.Format("select*fromNews_basewhereNews_Kind='{0}'",newskind);DataTabledt=SqlHelper.ExecuteQuery(sql);if(dt!={News_basenews=foreach(DataRowrowin{newsnews=newnews.News_idnews.News_id=Int32.Parse(row["News_ID"].ToStringnews.News_kindnews.News_kind=news.News_summrynews.News_summry=news.News_timenews.News_time=news.News_authornews.News_author=news.News_namenews.News_name=}}}}returnreturn}public}publicNews_basefindNews(string{{News_baseNews_basestringstringsql=string.Format("select*fromNews_basewhereNews_Name='{0}'",SqlDataReadersdr=if{news=newSqlDataReadersdr=if{news=newNews_base(sdr.GetInt32(0),sdr.GetString(1),sdr.GetString(2),sdr.GetString(4),sdr.GetString}return}publicIList<News_base>{IList<News_base>list=newstringsql=string.Format("select*fromDataTabledt=if(dt!={News_basenews=foreachforeach(DataRowrowin{{newsnews=newnews.News_id=news.News_id=news.News_kind=news.News_summry=news.News_time=news.News_authornews.News_author=news.News_namenews.News_name=}}}}returnreturn}}}3.管 功能的運(yùn)行效果圖、流程圖、代碼及注釋記記publicclass privateintUser_ID;//用 privateUser_baseUser;//用 privatedecimalMoney;//處罰金 privateDateTimeTime;//繳費(fèi)日 privatestringAdmin;//辦理 private privateint privateint 書(shū) privatePunish_Reason 原 privateBook_baseBook;//書(shū) public //構(gòu)造函數(shù)調(diào)用 User=new Book=new Reason=new publicPunish(intUser_id,decimalmoney,DateTimetime,stringadmin,intnum,string_reason,{{UserUser=newBookBook=newReasonReason=newMoneyMoney=TimeTime=AdminAdmin=NumNum=Book_IDBook_ID=User.User_id=Reason.idReason.id=Reason.reasonReason.reason=Book.Book_idBook.Book_id=}publicUser_base{get{returnUser;}publicUser_base{get{returnUser;set{User=value;}publicPunish_Reason{get{returnReason;set{Reason=value;}publicBook_base{get{returnBook;set{Book=value;}publicpublicdecimal{{getget{returnMoney;setset{Money=value;}}publicpublicDateTime{{getget{returnTime;setset{Time=value;}}publicpublicstring{{getget{returnAdmin;setset{Admin=value;}}publicpublicint{{getget{returnUser_ID;setset{User_ID=value;}}publicpublicint{{getget{returnNum;setset{Num=value;}}publicpublicint{{get{returnBook_ID;set{Book_ID=get{returnBook_ID;set{Book_ID=value;}}publicclass{publicintAddPunish(Punish{stringsql=string.Format("insertinto return}public DeletePunish(Punish{stringsql=string.Format("deletePunishwhereUser_ID='{0}'",returnreturn}}publicpublicintEditPunish(Punish{string{stringsql=string.Format("updatePunishMoney='{0}',Time='{1}',Admin='{2}',Num='{3}',Book_ID='{4}'Money='{0}',Time='{1}',Admin='{2}',Num='{3}',Book_ID='{4}'wherepunish.money,punish.money,punish.time,punish.admin,punish.num,punish.Book_id,punish.User_idreturnreturn}}publicPunishFindPunish(int{Punishpunish=stringsql=string.Format("selecta.User_ID,b.ID,c.Book_ID,d.*fromUser_basea,Punish_Reasonb,Book_basec,Punishdwherea.User_ID=d.User_IDandb.ID=d.Numandc.Book_ID=d.Book_IDandd.User_ID",userid);SqlDataReadersdr=SqlHelper.ExecuteReader(sql);if(sdr.Read()){sdr.GetInt32(4),sdr.GetString(5),sdr.GetInt32(6));}}publicIList<Punish>FindPunishs(int{IList<Punish>list=newListstringsql=string.Format("selecta.User_ID,b.*,c.Book_ID,d.*fromUser_basea,Punish_Reasonb,Book_basec,Punishdwherea.User_ID=d.User_IDandb.ID=d.Numandc.Book_ID=d.Book_ID");DataTabledt=SqlHelper.ExecuteQuery(sql);if(dt!=null){Punishpunish=foreach(DataRowrowin{punish=newpunish.user.User_id=Int32.Parse(row["User_ID"].ToString());punish.money=decimal.Parse(row["Money"].ToString());punish.time=DateTime.Parse(row["Time"].ToString());punish.admin=row["Admin"].ToString();punish.reason.reason=row["Reason"].ToString();punish.book.Book_id=Int32.Parse(row["Book_ID"].ToString());}}return}} 原 publicclass privateintprivatestring原publicpublic{{publicpublicPunish_Reason(intid,string{{IDID=ReasonReason=}public}publicint{{getget{retu