餐飲管理系統(tǒng)課程設(shè)計(jì)

1、計(jì)算機(jī)應(yīng)用軟件課程設(shè)計(jì)報(bào)告計(jì)算機(jī)應(yīng)用軟件課程設(shè)計(jì)報(bào)告項(xiàng)目名稱 餐飲管理系統(tǒng) 班級(jí)學(xué)號(hào) 姓 名 指導(dǎo)老師 完成日期 2011-12-25 目錄一、需求分析21.1數(shù)據(jù)需求21.2總體設(shè)計(jì)21.3流程圖2二、總體設(shè)計(jì)22.1登錄窗體的設(shè)計(jì)22.2注冊(cè)用戶界面設(shè)計(jì)22.3主窗體設(shè)計(jì)22.4基礎(chǔ)信息22.4.1基礎(chǔ)信息-桌臺(tái)信息22.4.2基礎(chǔ)信息職工信息22.5輔助工具22.6 系統(tǒng)維護(hù)22.6.1系統(tǒng)維護(hù)權(quán)限管理22.6.2系統(tǒng)維護(hù)添加用戶22.7系統(tǒng)設(shè)置22.7.1系統(tǒng)設(shè)置修改密碼22.7.2系統(tǒng)設(shè)置鎖定系統(tǒng)22.8幫助22.9快捷菜單22.9.1開臺(tái)22.9.2點(diǎn)加菜22.9.3消費(fèi)查詢25.

2、9.4結(jié)賬2三、詳細(xì)設(shè)計(jì)23.1登錄部分代碼23.2主界面的代碼23.3職工信息查詢代碼23.4桌臺(tái)信息查詢代碼23.5輔助工具23.6修改密碼、添加用戶、注冊(cè)用戶功能代碼23.7桌臺(tái)基本信息（雙擊桌臺(tái)圖標(biāo)后）代碼23.8開臺(tái)部分代碼23.9結(jié)賬部分代碼23.10點(diǎn)加菜部分代碼23.11消費(fèi)查詢部分代碼23.12用戶權(quán)限管理代碼2四、單元測(cè)試與組裝測(cè)試2五、總結(jié)2六、參考文獻(xiàn)2一、需求分析隨著餐飲業(yè)的不斷發(fā)展，餐飲管理系統(tǒng)的內(nèi)容對(duì)于決策者和管理者來(lái)說(shuō)都非常重要。本系統(tǒng)主要包括桌臺(tái)顯示、消費(fèi)查詢。人事檔案及權(quán)限等幾大部分，具有良好的用戶接口，使用方便，具有完善的查詢，對(duì)維護(hù)系統(tǒng)起到輔助決策的作用

3、，能及時(shí)、方便、靈動(dòng)地進(jìn)行查詢、修改、刪除等維護(hù)性操作。餐飲管理系統(tǒng)有足夠的存儲(chǔ)容量，滿足酒店每日營(yíng)業(yè)的變動(dòng)，另外，對(duì)于操作用戶有一定的管理，并對(duì)用戶的權(quán)限有一定的設(shè)置超級(jí)管理員擁有所有權(quán)限。經(jīng)理除了系統(tǒng)維護(hù)外，其他操縱都可以，普通用戶只能實(shí)現(xiàn)輔助工具的使用權(quán)限。1.1數(shù)據(jù)需求tb_food-存儲(chǔ)食品的tb_foodtype-存儲(chǔ)食品的類別tb_waiter-存儲(chǔ)所有職員信息tb_user-存儲(chǔ)管理用戶信息tb_room-存儲(chǔ)餐廳桌臺(tái)信息tb_guestfood-存儲(chǔ)消費(fèi)信息1.2總體設(shè)計(jì)餐飲管理系統(tǒng)輔助工具系統(tǒng)維護(hù)基礎(chǔ)信息幫助系統(tǒng)設(shè)置退出添加用戶鎖定系統(tǒng)修改密碼權(quán)限管理記事本計(jì)算器日歷職員信

4、息桌臺(tái)信息退出系統(tǒng)關(guān)于結(jié)賬消費(fèi)查詢點(diǎn)加菜開臺(tái)單天總營(yíng)業(yè)額的查詢桌臺(tái)1.3流程圖二、總體設(shè)計(jì)2.1登錄窗體的設(shè)計(jì)用戶信息tb_user系統(tǒng)編號(hào)id用戶名username用戶權(quán)限power用戶密碼userpwd用戶信息er圖點(diǎn)擊登錄進(jìn)入主窗體，點(diǎn)擊注冊(cè)賬號(hào)則進(jìn)入注冊(cè)用戶界面2.2注冊(cè)用戶界面設(shè)計(jì)默認(rèn)注冊(cè)的用戶類型只能是一般用戶2.3主窗體設(shè)計(jì)2.4基礎(chǔ)信息2.4.1基礎(chǔ)信息-桌臺(tái)信息可實(shí)現(xiàn)添加加、修改有增加、刪除、查詢 桌臺(tái)信息的功能雙擊圖標(biāo)是桌臺(tái)基本信息雙擊桌臺(tái)圖標(biāo)顯2.4.2基礎(chǔ)信息職工信息2.5輔助工具2.5.1輔助工具日歷2.5.2輔助工具計(jì)算器2.5.3輔助工具記事本2.6 系統(tǒng)維護(hù)2.

5、6.1系統(tǒng)維護(hù)權(quán)限管理2.6.2系統(tǒng)維護(hù)添加用戶2.7系統(tǒng)設(shè)置2.7.1系統(tǒng)設(shè)置修改密碼2.7.2系統(tǒng)設(shè)置鎖定系統(tǒng)2.8幫助2.9快捷菜單2.9.1開臺(tái)2.9.2點(diǎn)加菜2.9.3消費(fèi)查詢5.9.4結(jié)賬三、詳細(xì)設(shè)計(jì)3.1登錄部分代碼namespace mycyms /登陸界面 public partial class frmlogin :form public int m=0; public frmlogin() initializecomponent(); private void frmlogin_load_1(object sender, eventargs e) / system.win

6、dows.forms.control.top.get; txtname.focus(); private void txtpwd_keypress(object sender, keypresseventargs e) if (e.keychar = 13) btnsubmit_click(sender, e); /點(diǎn)擊登錄按鈕 private void btnsubmit_click(object sender, eventargs e) if (txtname.text = ) messagebox.show(請(qǐng)輸入用戶名, 警告, messageboxbuttons.ok, messag

7、eboxicon.warning); else sqlconnection conn = baseclass.baseclass.cycon(); conn.open(); sqlcommand cmd = new sqlcommand(select count(*) from tb_user where username= + txtname.text + and userpwd= + txtpwd.text + , conn); int i = convert.toint32(cmd.executescalar(); if (i 0) cmd = new sqlcommand(select

8、 * from tb_user where username= + txtname.text + , conn); sqldatareader sdr = cmd.executereader(); sdr.read(); string userpower = sdrpower.tostring().trim(); conn.close(); frmmain main = new frmmain(); main.power = userpower;/記錄登錄用戶的權(quán)限 main.names = txtname.text;/用戶名 /frmchangepwd.n / main.times = da

9、tetime.now.toshortdatestring();/只輸出日期 main.times = datetime.now.tostring();/記錄登錄時(shí)間 main.show(); this.hide(); else m+; if (m = 3) btnsubmit.enabled = false; messagebox.show(密碼錯(cuò)誤3次，請(qǐng)退出!); else messagebox.show(用戶名或密碼錯(cuò)誤); private void btconcel_click(object sender, eventargs e) application.exit(); /點(diǎn)擊注冊(cè)賬

10、號(hào).i=2表示這冊(cè)用戶界面 private void button2_click(object sender, eventargs e) frmchangepwd a = new frmchangepwd(); a.i = 2; a.showdialog(); / 如果點(diǎn)擊用戶名文本框,里面的文本清空,用戶即可輸出用戶名 private void txtname_click(object sender, eventargs e) txtname.text = ; 3.2主界面的代碼namespace mycyms public partial class frmmain : form publ

11、ic frmmain() initializecomponent(); public sqldatareader sdr; public string power; public string names; public string times; private void frmmain_load(object sender, eventargs e) switch (power) case 0: toolstripstatuslabel12.text = 超級(jí)管理員; break; case 1: toolstripstatuslabel12.text = 經(jīng)理; break; case

12、2: toolstripstatuslabel12.text = 一般用戶; break; toolstripstatuslabel15.text = names; toolstripstatuslabel14.text = times; if (power = 2) 系統(tǒng)維護(hù)toolstripmenuitem1.enabled = false; 基礎(chǔ)信息toolstripmenuitem1.enabled = false; if (power = 1) 系統(tǒng)維護(hù)toolstripmenuitem1.enabled = false; private void additems(string r

13、zt) if (rzt = 使用) lvdesk.items.add(sdrroomname.tostring(), 1); else lvdesk.items.add(sdrroomname.tostring(), 0); private void 開臺(tái)toolstripmenuitem_click(object sender, eventargs e) if (lvdesk.selecteditems.count != 0) string names = lvdesk.selecteditems0.subitems0.text; frmopen openroom = new frmopen

14、(); = names; openroom.showdialog(); else messagebox.show(請(qǐng)選擇桌臺(tái)); private void 點(diǎn)加菜toolstripmenuitem_click(object sender, eventargs e) if (lvdesk.selecteditems.count != 0) string names = lvdesk.selecteditems0.subitems0.text; frmjzd dc = new frmjzd(); dc.rname = names; dc.showdialog(); el

15、se messagebox.show(請(qǐng)選擇桌臺(tái)); private void 結(jié)賬toolstripmenuitem_click(object sender, eventargs e) if (lvdesk.selecteditems.count != 0) string names = lvdesk.selecteditems0.subitems0.text; frmpayoff payoff = new frmpayoff(); payoff.rname = names; payoff.showdialog(); else messagebox.show(請(qǐng)選擇桌臺(tái)); private

16、void frmmain_activated(object sender, eventargs e) lvdesk.items.clear(); sqlconnection conn = baseclass.baseclass.cycon(); conn.open(); sqlcommand cmd = new sqlcommand(select * from tb_room, conn); sdr = cmd.executereader(); while (sdr.read() string zt = sdrroomzt.tostring().trim(); additems(zt); co

17、nn.close(); private void 消費(fèi)查詢toolstripmenuitem_click(object sender, eventargs e) if (lvdesk.selecteditems.count != 0) string names = lvdesk.selecteditems0.subitems0.text; frmserch serch = new frmserch(); serch.rname = names; serch.showdialog(); else messagebox.show(請(qǐng)選擇桌臺(tái)); private void lvdesk_double

18、click(object sender, eventargs e) frmdetatles details = new frmdetatles(); details.tablename = lvdesk.selecteditems0.subitems0.text; details.showdialog(); private void lvdesk_click(object sender, eventargs e) string names = lvdesk.selecteditems0.subitems0.text; sqlconnection conn = baseclass.basecla

19、ss.cycon(); conn.open(); sqlcommand cmd = new sqlcommand(select * from tb_room where roomname= + names + , conn); sqldatareader sdr = cmd.executereader(); sdr.read(); string zt = sdrroomzt.tostring().trim(); sdr.close(); if (zt = 使用) this.contextmenustrip1.items0.enabled = false; this.contextmenustr

20、ip1.items1.enabled = true; this.contextmenustrip1.items3.enabled = true; this.contextmenustrip1.items5.enabled = true; this.contextmenustrip1.items6.enabled = true; if (zt = 待用) this.contextmenustrip1.items0.enabled = true; this.contextmenustrip1.items1.enabled = false; this.contextmenustrip1.items3

21、.enabled = false; this.contextmenustrip1.items5.enabled = false; this.contextmenustrip1.items6.enabled = false; conn.close(); private void 添加用戶toolstripmenuitem1_click(object sender, eventargs e) frmchangepwd pwd = new frmchangepwd(); /s = names; pwd.i = 1; pwd.showdialog(); private void 退出t

22、oolstripmenuitem1_click(object sender, eventargs e) if (messagebox.show(確定退出本系統(tǒng)嗎？, 提示, messageboxbuttons.okcancel, messageboxicon.exclamation) = dialogresult.ok) application.exit(); private void 幫助toolstripmenuitem1_click(object sender, eventargs e) frmabout ab = new frmabout(); ab.showdialog(); pri

23、vate void 鎖定系統(tǒng)toolstripmenuitem1_click(object sender, eventargs e) frmlock m = new frmlock(); m.showdialog(); private void 權(quán)限管理toolstripmenuitem1_click(object sender, eventargs e) usermanager power = new usermanager(); power.showdialog(); private void 日歷toolstripmenuitem1_click(object sender, eventa

24、rgs e) frmcalender calender = new frmcalender(); calender.showdialog(); private void 計(jì)算器toolstripmenuitem1_click(object sender, eventargs e) system.diagnostics.process.start(calc.exe); private void 記事本toolstripmenuitem1_click(object sender, eventargs e) system.diagnostics.process.start(notepad.exe);

25、 private void 桌臺(tái)信息toolstripmenuitem1_click(object sender, eventargs e) frmdesk desk = new frmdesk(); desk.showdialog(); private void 職員信息toolstripmenuitem1_click(object sender, eventargs e) frmuser users = new frmuser(); users.showdialog(); 3.3職工信息查詢代碼namespace mycyms public partial class frmuser :

26、form public frmuser() initializecomponent(); private void btquery_click(object sender, eventargs e) binddata(); private void binddata() sqlconnection conn = baseclass.baseclass.cycon(); sqldataadapter sda = new sqldataadapter(select id,waitername 姓名,cardnum 身份證號(hào),waiternum 服務(wù)員編號(hào),sex 性別,age 年齡,tell 電話

27、號(hào)碼 from tb_waiter order by id , conn); dataset ds = new dataset(); sda.fill(ds); datagridview1.datasource = ds.tables0; /修改按鈕 private void button1_click(object sender, eventargs e) btrewrite.enabled = false; btsave.enabled = true; btconcle.enabled = true; txtname.enabled = false; txtage.enabled = tr

28、ue; txtidcard.enabled = true; txtwaiternum.enabled = true; txttel.enabled = true; cbsex.enabled = true; private void btexit_click(object sender, eventargs e) this.close(); private void btrewrite_click(object sender, eventargs e) txtname.text = ; txtage.text = ; txtidcard.text = ; txttel.text = ; txt

29、waiternum.text = ; txtname.enabled = true; txtage.enabled = true; txtidcard.enabled = true; txtwaiternum.enabled = true; txttel.enabled = true; cbsex.enabled = true; btchange.enabled = false; btdelete.enabled = true; btsave.enabled = true; private void btdelete_click(object sender, eventargs e) sqlc

30、onnection conn = baseclass.baseclass.cycon(); conn.open(); sqlcommand cmd = new sqlcommand(delete from tb_waiter where id= + datagridview1.selectedcells0.value.tostring() + , conn); cmd.executenonquery(); conn.close(); binddata(); private void btsave_click(object sender, eventargs e) sqlconnection c

31、onn = baseclass.baseclass.cycon(); conn.open(); sqlcommand cmd = new sqlcommand(select count(*) from tb_waiter where waitername= + txtname.text + , conn); int i = convert.toint32(cmd.executescalar(); if (i 0) cmd = new sqlcommand(update tb_waiter set waitername= + txtname.text + ,cardnum= + txtidcar

32、d.text + ,waiternum= + txtwaiternum.text + ,sex= + cbsex.selecteditem.tostring() + ,age= + txtage.text + ,tell= + txttel.text + where id= + datagridview1.selectedcells0.value.tostring() + , conn); cmd.executenonquery(); conn.close(); binddata(); btrewrite.enabled = true; btchange.enabled = false; bt

33、save.enabled = false; btquery.enabled = true; btconcle.enabled = false; btdelete.enabled = false; btexit.enabled = true; txtname.enabled = false; else cmd = new sqlcommand(insert into tb_waiter(waitername,cardnum,waiternum,sex,age,tell) values( + txtname.text + , + txtidcard.text + , + txtwaiternum.

34、text + , + cbsex.selecteditem.tostring() + , + txtage.text + , + txttel.text + ), conn); cmd.executenonquery(); conn.close(); binddata(); btchange.enabled = true; btrewrite.enabled = true; btsave.enabled = false; btquery.enabled = true; btconcle.enabled = false; btdelete.enabled = true; btexit.enabl

35、ed = true; txtname.enabled = false; txtname.enabled = false; private void frmuser_load(object sender, eventargs e) cbsex.selectedindex = 0; private void datagridview1_cellclick(object sender, datagridviewcelleventargs e) try txtname.text = datagridview1.selectedcells1.value.tostring(); txtidcard.tex

36、t = datagridview1.selectedcells2.value.tostring(); txtwaiternum.text = datagridview1.selectedcells3.value.tostring(); cbsex.selecteditem = datagridview1.selectedcells4.value.tostring().trim(); txtage.text = datagridview1.selectedcells5.value.tostring(); txttel.text = datagridview1.selectedcells6.value.tostring(); btchange.enabled = true; btdelete.enabled = true; catch (exception err)