酒店收入分析與管理畢業(yè)設(shè)計(論文)

大連交通大學(xué)信息工程學(xué)院2012屆本科生畢業(yè)設(shè)計（論文）外文翻譯13-大連交通大學(xué)信息工程學(xué)院畢業(yè)設(shè)計(論文)任務(wù)書題目易陽酒店收入分析與管理任務(wù)及要求：1.設(shè)計（研究）內(nèi)容和要求任務(wù)：1.調(diào)查基于易陽酒店收入分析與管理，完成實習(xí)報告，字?jǐn)?shù)不少于3000，第三周交給指導(dǎo)老師。2.結(jié)合自己實習(xí)情況安排進(jìn)度，填寫進(jìn)度計劃表，第二周完成后交給指導(dǎo)老師簽字，并嚴(yán)格執(zhí)行。3.按照軟件工程思想，獨立完成系統(tǒng)的設(shè)計和程序開發(fā)，完成代碼估計2000行左右。4.用C#實現(xiàn)易陽酒店收入分析與管理系統(tǒng)。5.程序簡潔，算法可行，運行情況良好。要求：1.每周和指導(dǎo)老師至少見面溝通一次，回報課題進(jìn)展情況，接受老師詢問。2.接到任務(wù)書后，查閱與題目及專業(yè)相關(guān)的外文資料進(jìn)行翻譯，要求不少于10000個外文字符，譯出漢字不得少于3000，于第四周交給指導(dǎo)老師審閱。3.畢業(yè)設(shè)計第13周完成畢業(yè)論文的裝訂，并由指導(dǎo)老師評閱。論文要求12000字以上，包括綜述、系統(tǒng)總體設(shè)計、系統(tǒng)實現(xiàn)、性能分析、結(jié)論等。4.教學(xué)第13周通過中軟及教研室組織進(jìn)行軟件驗收，驗收時要提供軟件使用說明書。5.于第13周提出畢業(yè)答辯申請并簽字。6.第14周答辯，要求制作PPT2.原始依據(jù)通過大學(xué)幾年的學(xué)習(xí)，已經(jīng)學(xué)習(xí)了諸如軟件工程、數(shù)據(jù)庫原理及應(yīng)用、數(shù)據(jù)結(jié)構(gòu)、C++、VisualBasic、JAVA等多門程序設(shè)計語言和網(wǎng)絡(luò)等基礎(chǔ)知識和專業(yè)知識，學(xué)生有能力而且可以獨立完成小中型項目的設(shè)計與開發(fā)。學(xué)?，F(xiàn)有設(shè)備和環(huán)境可以提供給學(xué)生實習(xí)和上機，而且具有專業(yè)老師可以指導(dǎo)學(xué)生。3.參考文獻(xiàn)[1]天極網(wǎng)新技術(shù)研究室.C#完全入門.人民郵電出版社,2001.6.[2]SanjeevRohilla等著,陳君等譯.C#專業(yè)項目實例開發(fā).中國水利水電出版社，2003.5.[3]啟明工作室編著.ASP.NET網(wǎng)絡(luò)應(yīng)用系統(tǒng)開發(fā)與實例.人民郵電出版社,2005.7.[4]王華杰,李律松,孫一波等編著.C#數(shù)據(jù)庫開發(fā)技術(shù).清華大學(xué)出版社,2003.2.[5]Winemiller,J.Roff.softwareempolderandapplication.Yaleuniversitypublishing[6]A.RussellJones著,高春蓉等譯.C#從入門到精通.電子工業(yè)出版,2002.1.[7]ScottWorley著,王文龍,劉湘寧譯.C#技術(shù)內(nèi)幕.人民郵電出版社,2002.4.[8]RussBasiura等著,楊浩譯.ASP.NETWeb服務(wù)高級編程.清華大學(xué)出版社,2003.2.[9]AngshumanChakraborti等著,唐云深,趙世華等譯.NETFramework專業(yè)項目實例開發(fā)..中國水利水電出版社,2003.6.[10]ScottAllen等著.C#數(shù)據(jù)庫入門.郝啟堂,張哲峰譯.清華大學(xué)出版社，2003.2.[11]微軟公司著.NET框架1.1類庫參考手冊.清華大學(xué)出版社,2004.1.教研室主任簽字：2012年3月26日大連交通大學(xué)信息工程學(xué)院畢業(yè)設(shè)計(論文)進(jìn)度計劃與考核表學(xué)生姓名張曉曈專業(yè)班級軟件工程08-3班指導(dǎo)教師王建何丹丹本課題其他人員無題目易陽酒店收入分析與管理日期計劃完成內(nèi)容完成情況指導(dǎo)老師檢查簽字第1周實習(xí)調(diào)研，查閱課題相關(guān)外文資料第2周了解行業(yè)狀況、查閱文獻(xiàn)資料，閱讀資料，撰寫調(diào)研報告第3周完成10000字符或3000漢字以上的外文翻譯資料，準(zhǔn)備資料，學(xué)習(xí)C#技術(shù)第4周進(jìn)行需求分析第5周進(jìn)行概要設(shè)計第6周進(jìn)行概要設(shè)計,基本框架完成，提交畢業(yè)論文提綱第7周完成后臺數(shù)據(jù)庫的設(shè)計并編碼，完成部分論文第8周完成前臺界面的設(shè)計并編碼，完成部分論文第9周繼續(xù)編碼并進(jìn)行測試，繼續(xù)編寫畢業(yè)設(shè)計論文第10周繼續(xù)進(jìn)行程序測試，繼續(xù)編寫畢業(yè)設(shè)計論文第11周整理資料、文檔、圖表等，修改畢業(yè)設(shè)計論文第12周完成畢業(yè)設(shè)計論文，打印，按要求裝訂第13周軟件驗收和準(zhǔn)備畢業(yè)設(shè)計答辯第14周畢業(yè)設(shè)計答辯及成績評定指導(dǎo)教師簽字：年月日注：“計劃完成內(nèi)容”由學(xué)生本人認(rèn)真填寫，其它由指導(dǎo)教師考核時填寫。大連交通大學(xué)信息工程學(xué)院畢業(yè)設(shè)計(論文)外文翻譯學(xué)生姓名張曉曈專業(yè)班級軟件工程08-3班指導(dǎo)教師王建何丹丹職稱高工講師所在單位信息科學(xué)系軟件工程教研室教研室主任劉瑞杰完成日期2012年4月13日ThedevelopmentofASP.NETThepredecessoroftheASP.NETASP,atIIS2(WindowsNT3.51)wasfirstintroduced,atthattimetogetherwithADO1launch,inIIS3(WindowsNT4)carryforward,intoaserversideapplicationpopulardevelopmenttools,MicrosoftalsospecificallytailoredforitsVisualInterDevdevelopmenttools,from1994to2000,ASPtechnologyhasbecomethepromotionofMicrosoftWindowsNT4platformisoneofthekeytechnologies,tensofthousandsofASPwebsitealsoisthetimetostartlikebambooshootsafteraspringrain"appearedontheinternet.It'ssimpleandhighlycustomizableability,isalsooneofthereasonsitcanriseabruptlyquickly.However,theshortcomingsofASPgraduallyemerged:Italytypeprogramdevelopmentmethod,makethemaintenancedifficultyisincreasedalot,especiallylarge-scaleASPapplications.TheliteraltranslationoftypeVBScriptorJScriptlanguage,letefficiencysomewhatlimited.Ductilitybecauseitsinfrastructureexpansionandrestriction,althoughCOMelementisavailable,butthedevelopmentofsomespecialfunctions(likefileupload):notfromthebuilt-insupport,needtoseekthethirdpartysoftwaredeveloperselement.In1997,MicrosoftstartedaimingattheshortcomingofASP(especiallyItalytypeprogramdevelopmentmethod)isreadytobeginanewprojecttodevelop,thenASP.NETmainleaderScottGuthriejustgraduatedfromDukeUniversity,heandIISteamMarkAndersmanagersworktogetherfortwomonths,todevelopthenextgenerationofASPprototypein1997,theprototypewasdevelopedatChristmas,andgivenaname:XSP,theprototypeusingJavalanguage.ButsoonhewasincorporatedatthattimeisstillinthedevelopmentofCLRplatform,ScottGuthrieafterwardsthatthetransplanttechnologytotheCLRplatform,ithasverybigrisk(hugerisk),buttheXSPteamisinthedevelopmentandapplicationofCLRfirstteam.InordertoportingXSPtoCLR,XSPteamwilltheXSPkernelprogramentirelyinClanguagetowrite#(intheinterioroftheprojectcodenameis"ProjectCool",butatthetimeofthepublicisconfidential),andrenamedasASP+,ASPtechnology'ssuccessor,andwillalsoprovideasimpletransfermethodtoASPdevelopers.ThefirstversionofBetaASP+anditsapplicationinPDC2000byBillGatesKeynotedebut,speaker(namelythekeytechnicaloverview),fromFujitsudisplayusingCOBOLlanguagewritteninASP+applications,anddeclaredthatitcanusetheVisualBasic.NET,C,PerlandPython#language(bothdevelopedbyActiveStateinterworkingtoolsupport)todevelop.Inthesecondquarterof2000,Microsoftofficiallypromoted.NETstrategy,ASP+alsologicalrenamedASP.NET,afterfouryearsofdevelopment,thefirstversionoftheASP.NETinJanuary5,2002debut(andNETFramework1),ScottGuthriehasbecomeaproductmanagerinASP.NET(nowhasdevelopedanumberofMicrosoftproducts,likeASP.NETAJAXandMicrosoftSilverlight).ThelatestversionoftheASP.NET4andNETFramework4inVS2010platformapplication.EditorthisparagraphofworldclasstoolsupportASP.netframeworkcanbeusedMicrosoft(R)company'snewproductdevelopmentenvironmentfordevelopingVisualS,WYSIWYG(WhatYouSeeIsWhatYouGetWYSIWYGeditorforincome).ThesearetheonlyASP.netpowerfulsoftwaretosupportasmallpart.Editorthisparagraphispowerfulandadaptive.BecausetheASP.netisbasedongenerallanguagecompilerrunningprograms,soit'spowerfulandadaptability,canmakeitrunintheWebapplicationsoftwaredevelopersalmostalloftheplatform(theauthoruntilnowonlyknowthatitcanbeusedonlyonaWindows2000/2003Server/VISTA/7).Universallanguageofbasicdatabase,messagemechanism,datainterfaceprocessingcanbeseamlesslyintegratedintotheASP.netWebapplication.ASP.netandlanguage-independent(languageindependent),so,youcanchooseamostsuitableforyourlanguagetowriteyourprogram,oryourprogramwithmanylanguagestowrite,nowalreadysupportC#(C++andJavacombined),VB,Jscript,C++,F++.Inthefuture,suchavarietyofprogramminglanguageabilitytoworktoprotectyounowbasedonCOM+developmentprogram,beabletocompletetransfertoASP.net.ASP.NETisgenerallydividedintotwoprogramminglanguages,VB.NETandC#,C#isrelativelycommon,asisNETuniquelanguage,VB.NETisusedVBprogramming,suitableforthepreviousVBprogrammers,ifthenewcontact.NET,nootherdevelopmentlanguageexperience,suggestions#canlearnC.EditorthisparagraphissimpleandeasytolearnASP.nettorunsomecommontaskssuchasformsubmitclientauthentication,distributedsystemandsiteconfigurationbecomesverysimple.Forexample,theASP.netpageframeworkallowsyoutobuildyourownuserinterface,whichdiffersfromthecommonVB-Likeinterface.EditorthisparagraphofefficientmanagementASP.netusesacharacterbased,hierarchicalconfigurationsystem,makeyourserverenvironmentandapplicationsettingsmoresimple.Becausetheconfigurationinformationisstoredinasimpletext,thenewsettingsmaynotneedtostartalocaladministratortoolscanbeachieved.Thisisreferredtoasthe"ZeroLocalAdministration"philosophythatAbasedonapplicationdevelopmentofmorespecific,andfast.AASP.netapplicationonaserversysteminstallationrequiresonlyasimplecopyofthenecessarydocuments,doesnotrequireasystemreboot,everythingissosimple.MultiprocessorenvironmentthereliabilityofASP.nethasbeendeliberatelydesignedtobecomeacanbeusedformultipleprocessordevelopmenttools,itisinamultiprocessorenvironmentwithspecialseamlessconnectiontechnology,willgreatlyincreasetheoperationspeed.EvenifyourcurrentASP.netapplicationsoftwareforaprocessordevelopment,futuremultiprocessoroperationdoesnotrequireanychangecanimprovetheireffectiveness,butnowASPcannotdothis.CustomandexpansibilityofASP.netdesignedforwebdeveloperscanintheirowncodetheirowndefinitionof"plug-in"module.Withthisoriginalcontainsdifferent,ASP.netcanaddtheirowndefinitionsofanycomponent.Webapplicationdevelopmenthasneverbeensosimple.SafetybasedonWindowsauthenticationtechnologyandeachapplicationconfiguration,youcanensurethatyourprogramisabsolutelysafe.ASP.NETsyntaxislargelycompatiblewithASP,atthesametime,italsoprovidesanewprogrammingmodelandstructure,cangeneratethescalabilityandstabilitybetterapplication,andtoprovidebettersecurityprotection.CanbeadoptedinexistingASPapplicationsgraduallyaddASP.NETfunction,toenhancethefunctionalityofASPapplications.ASP.NETisacompiled,basedonthe.NETenvironment,basedontheuniversallanguageofprogramrunningonaserver.Theprogramontheserver'sfirstruncompilethanASPinstantinterpretationprocedure,thefasterthespeedalot.Butcanbeusedwithany.NETcompatiblelanguages(includingVisualBasic.NET,C#andJScript.NET.)authoringapplication.Inaddition,anyASP.NETapplicationcanusethe.NETFramework.Developerscaneasilyobtaintheadvantageofthesetechniques,includinghostingthecommonlanguageruntimeenvironment,typesafety,inheritanceandsoon.ASP.NETcanseamlesslywiththeWYSIWYGHTMLeditorandotherprogrammingtools(includingMicrosoftVisualStudio.NET)worktogether.ThisnotonlymadetheWebdevelopmentmoreconvenient,butalsocanprovidethetoolsmustprovidealloftheadvantages,includingthedevelopmentofpersonnelcanbeusedtosettheservercontrolsontotheWebpageGUIandfullyintegrateddebuggingsupport.WhencreatingtheASP.NETapplication,developerscanuseWebformorXMLWebservices,orsotheythinkfitanycombinationof.Eachfunctioncanbethesamestructuralsupport,allowsyoutousetheauthenticationscheme,cachefrequentlyuseddata,ortotheapplicationconfigurationforcustom.Ifyouneverdevelopedawebsiteprogram,soitisnotsuitableforyou,youshouldatleastmastersomesimpleHTMLlanguageandWebdevelopmentterms(butIbelieveifthereareinterestedcanquicklygraspthe).Youdon'tneedpreviousexperienceinthedevelopmentofASP(ofcourseexperiencedbetter),butyoumustunderstandtheinteractiveWebprogrammingconcepts,includingforms,scripts,anddatainterfaceconcept,ifyouhavetheseconditions,thenyoucanbeintheAworldbegantosoartogreatheights.EditorthisparagraphIISIISInternetInformationServices(Internetinformationservices)IISisWindows2000bindingfreecomponentIISandWindowsNT4optionalcomponentsofthisoptionalcomponentscanbedownloadedthroughtheInternetPWSsmaller-buthasintegratedfunctionofIISPWSunderWindows95/98installationCDfindASP.netActiveServerPage(notjustthenextversionofASP),andisbasedonagenerallanguageprogramstructure,canbeusedforaWebservertoestablishapowerfulWebapplication.ASP.netprovidesmanymorethantheWebdevelopmentmodepowerfuladvantage.EditorthisparagraphprocessingarchitectureASP.NETruntimearchitectureisdividedintoseveralstages:theIISandWebservermessageflowstage.InASP.NETwebpageinmessageassignment.InASP.NETwebpagemessageprocessingin.EditorthisparagraphofWebservermessageflowstageWhenloading(hosting)ASP.NETWebserverreceivestheHTTPrequest,HTTPlisteningprocedure(HTTPListener)willrequiretoURLthespecifiedwebapplicationsworkflow(WorkerProcess),theworkingflowofASP.NETprocessor(aspnet_isapi.dll,ifIIS5istheaspnet_wp.exe)willparsetheURL,andtheactivationintheintheSystem.Web.HostingnamespaceISAPIRuntime(dependingonversion)object,receivestheHTTPrequest,andcalltheHttpRuntime,runHttpRuntime.ProcessRequest(),ProcessRequest(HttpApplicationFactory)inuseintheestablishmentofnewHttpApplication(orthespecifiedIHttpHandlerprocessor),andthenassignedtothePageProcessRequest()orIHttpHandlerProcessRequest()method,afterrunning,andthenbacktotheISAPIRuntime,andaspnet_isapi.dll,finallyhandedovertotheHTTPListenerbacktotheenduser,becauseruntheprogramasasmoothoperationofpipeline,andisthereforecalledtheHTTPPipelineMode.InsidetheASP.NETHTTPprocessor:ISAPIRuntime:aspnet_isapi.dllcall,initializeHttpWorkerRequestobject(fromversionIISdecidedtoinitializeversion).HttpRuntime:requestqueue(RequestQueue),calledHttpWorkerRequestProcessRequest()method,andthefollow-upprocessing.HttpWorkerRequest:HttpApplication,HttpRequest,HttpResponseandotherobjectsbasedonHTTPobject,andwillberequiredtotransfertotheobjectstobeprocessed(andcallittheProcessRequest()method).IHttpHandlerandIHttpAsyncHandler:responsibleforhandlingtheHTTPrequirementsoftheunit,byProcessRequest()todispatchandoperationrequirements.ASP.NETwebpageintheeventintheprogramwhentheHttpWorkerRequestcallASP.NETwebpage(System.Web.UInamespaceclassPage)Page.ProcessRequest()method,itwillinturncausePageinvariousevents,andatthesametimecallsinthePageallcontrolsrelatedevents,theorder:PreInitevent:runintheinitializationwork,intheASP.NET2,todynamicallyadjustthemasterpage(MasterPage),themes(Theme),intheeventofadjustment.TheInitevent:initializationwork.TheInitCompletedevent.謝辭經(jīng)過這幾個月的忙碌和工作，本次畢業(yè)設(shè)計已經(jīng)接近尾聲，作為一個畢業(yè)生的畢業(yè)設(shè)計，由于經(jīng)驗的匱乏，難免有許多考慮不周全的地方，如果沒有導(dǎo)師的督促指導(dǎo)，以及一起工作的同學(xué)們的支持，想要完成這個設(shè)計，遇到的問題是難以想象的。在論文即將結(jié)尾階段，我要感謝我的畢設(shè)指導(dǎo)老師，從接受課題到現(xiàn)在完成畢業(yè)設(shè)計論文，老師給予我精心的指導(dǎo)和熱情的幫助，尤其在課題設(shè)計的前期準(zhǔn)備階段和本人的數(shù)據(jù)庫的設(shè)計階段，老師提出許多寶貴的設(shè)計意見。在最后的測試修改階段老師在百忙之中抽出時間為我提供了必要的幫助，這樣使我得以順利的完成畢業(yè)設(shè)計開發(fā)工作。在此謹(jǐn)向幫助過我的所有老師們致以最誠摯的謝意。

最后，祝福所有關(guān)心和幫助過我的老師和同學(xué)，愿你們身體健康，前程似錦。PAGE參考文獻(xiàn)[1]天極網(wǎng)新技術(shù)研究室.C#完全入門.人民郵電出版社,2001.6.[2]SanjeevRohilla等著,陳君等譯.C#專業(yè)項目實例開發(fā).中國水利水電出版社，2003.5.[3]啟明工作室編著.ASP.NET網(wǎng)絡(luò)應(yīng)用系統(tǒng)開發(fā)與實例.人民郵電出版社,2005.7.[4]王華杰,李律松,孫一波等編著.C#數(shù)據(jù)庫開發(fā)技術(shù).清華大學(xué)出版社,2003.2.[5]Winemiller,J.Roff.softwareempolderandapplication.Yaleuniversitypublishing[6]A.RussellJones著,高春蓉等譯.C#從入門到精通.電子工業(yè)出版,2002.1.[7]ScottWorley著,王文龍,劉湘寧譯.C#技術(shù)內(nèi)幕.人民郵電出版社,2002.4.[8]RussBasiura等著,楊浩譯.ASP.NETWeb服務(wù)高級編程.清華大學(xué)出版社,2003.2.[9]AngshumanChakraborti等著,唐云深,趙世華等譯.NETFramework專業(yè)項目實例開發(fā)..中國水利水電出版社,2003.6.[10]ScottAllen等著.C#數(shù)據(jù)庫入門.郝啟堂,張哲峰譯.清華大學(xué)出版社，2003.2.[11]微軟公司著.NET框架1.1類庫參考手冊.清華大學(xué)出版社,2004.1.附錄usingSystem;usingSystem.Collections.Generic;usingSystem.Text;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Configuration;namespaceHotelManager.SqlHelper{publicclassCustomerHelper{staticstringstrconn=ConfigurationManager.ConnectionStrings["conn"].ConnectionString;publicstaticDataSetHelperSelect(stringstr){DataSetds=newDataSet();using(SqlConnectionconn=newSqlConnection(strconn)){conn.Open();SqlDataAdapterda=newSqlDataAdapter(str,conn);da.Fill(ds);}returnds;}publicstaticSqlDataReaderHelperSelectID(stringstr,SqlParameterp){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);cmd.Parameters.Add(p);SqlDataReaderdr=cmd.ExecuteReader();returndr;}publicstaticstringHelperSelectmain(stringstr,SqlParameterp){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);cmd.Parameters.Add(p);stringdr=Convert.ToString(cmd.ExecuteScalar());returndr;}//找回密碼publicstaticSqlDataReaderHelperSelectID(stringstr,paramsSqlParameter[]p){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);foreach(SqlParameterfinp){cmd.Parameters.Add(f);}SqlDataReaderdr=cmd.ExecuteReader();returndr;}//查詢總數(shù)publicstaticintHelperSelectID(stringstr){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);intcount=Convert.ToInt32(cmd.ExecuteScalar());returncount;}publicstaticDataSetHelperSelectType(stringstr,SqlParameterp){SqlConnectionconn=newSqlConnection(strconn);conn.Open();DataSetds=newDataSet();SqlDataAdapterda=newSqlDataAdapter();SqlCommandcmd=newSqlCommand(str,conn);cmd.Parameters.Add(p);da.SelectCommand=cmd;da.Fill(ds);returnds;}publicstaticDataSetHelperSelectRoonID(stringstr,SqlParameterp){SqlConnectionconn=newSqlConnection(strconn);conn.Open();DataSetds=newDataSet();SqlDataAdapterda=newSqlDataAdapter();SqlCommandcmd=newSqlCommand(str,conn);cmd.Parameters.Add(p);da.SelectCommand=cmd;da.Fill(ds);returnds;}publicstaticDataSetHelperSelect(stringstrbd,paramsSqlParameter[]p){DataSetds=newDataSet();using(SqlConnectionconn=newSqlConnection(strconn)){conn.Open();SqlDataAdapterda=newSqlDataAdapter();da.SelectCommand=newSqlCommand(strbd,conn);foreach(SqlParameterfinp){da.SelectCommand.Parameters.Add(f);}da.Fill(ds);}returnds;}publicstaticboolHelperInsert(stringstr,paramsSqlParameter[]p){using(SqlConnectionconn=newSqlConnection(strconn)){conn.Open();SqlCommandcmd=newSqlCommand(str,conn);foreach(SqlParameterfinp){cmd.Parameters.Add(f);}inti=cmd.ExecuteNonQuery();if(i>0)returntrue;returnfalse;}}publicstaticSqlDataReaderHelperLogin(stringstr,paramsSqlParameter[]p){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);foreach(SqlParameterfinp){cmd.Parameters.Add(f);}returncmd.ExecuteReader();}publicstaticboolHelperUpdate(stringstr,paramsSqlParameter[]p){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);foreach(SqlParameterfinp){cmd.Parameters.Add(f);}intid=cmd.ExecuteNonQuery();if(id>0)returntrue;returnfalse;}//查詢房間類型publicstaticSqlDataReaderHelperSelectAllType(stringstr){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);returncmd.ExecuteReader();}//相同名字publicstaticboolHelperSelectLogin(stringstr,SqlParameterp){SqlConnectionconn=newSqlConnection(strconn);conn.Open();SqlCommandcmd=newSqlCommand(str,conn);cmd.Paramete