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

鄭州科技學(xué)院C#課程設(shè)計(jì)設(shè)計(jì)(論文)題目：餐飲管理系統(tǒng)所在院：信息工程學(xué)院專業(yè)班級(jí)：10計(jì)算機(jī)科學(xué)與技術(shù)2班學(xué)生姓名：簡奇學(xué)號(hào)：201015048指導(dǎo)教師：王玉萍2013年1月8日

目錄第一部分引言…………2……………………3……………4第二部分需求分析……………………4………………5………………5………………5第三部分總體設(shè)計(jì)……………………6………………6……………7第四部分核心代碼實(shí)現(xiàn)……………7……………………7………11日歷模塊實(shí)現(xiàn)……………………20……………………22第五部分結(jié)束語……………………29…………30…………31第六部分參考文獻(xiàn)……………31第一部分引言1.1課題意義近年來，隨著人民的生活水平的不斷提高，餐飲業(yè)的消費(fèi)持續(xù)增長，競爭愈來愈激烈。然而，傳統(tǒng)餐飲企業(yè)的日常運(yùn)作還是靠人工管理，從原材料入庫到客人點(diǎn)單，再到結(jié)賬基本上由人工完成記錄，這樣做不僅耗費(fèi)人力資源而且容易導(dǎo)致記錄丟失或重復(fù)等錯(cuò)誤，造成管理水平低下。酒店作為傳統(tǒng)的餐飲企業(yè)也存在這些問題，進(jìn)貨，庫存有人工管理，客人點(diǎn)單需服務(wù)員記錄并送至廚房，客人結(jié)賬由手工記錄，人力耗費(fèi)大，客人等待時(shí)間長，管理效率低下，這就迫切需要標(biāo)準(zhǔn)的、高效率的計(jì)算機(jī)管理方式引導(dǎo)其發(fā)展,通過計(jì)算機(jī)管理該企業(yè)的日常運(yùn)作，給管理者以決策參考的模型，來不斷完善管理水平，提高工作效率。改革開放二十多年來，我國餐飲業(yè)發(fā)展迅猛，日新月異，各種風(fēng)味特色，各種經(jīng)營形式，各種組織結(jié)構(gòu)的餐飲企業(yè)星羅棋布，但“競爭激烈，生意難作”也成了餐飲業(yè)的“流行脖。更新經(jīng)營方式，拓展大眾市場，建全餐飲業(yè)的“軟硬”件設(shè)施，發(fā)展餐飲信息渠道是我國餐飲業(yè)應(yīng)探索的主旋律。所以，社會(huì)化，科學(xué)化，集錦化21世紀(jì)的發(fā)展方向。當(dāng)今世界已進(jìn)入了在計(jì)算機(jī)信息管理領(lǐng)域中激烈競爭的時(shí)代，應(yīng)用計(jì)算機(jī)已經(jīng)變得十分普遍了，如同我們離不開的自行車、汽車一樣。我們應(yīng)該承認(rèn)，誰掌握的知識(shí)多，信息量大，信息處理速度快，批量大，誰的效率就高，誰就能夠在各種競爭中立于不敗之地。隨著科學(xué)技術(shù)的不斷提高,計(jì)算機(jī)科學(xué)日漸成熟,其強(qiáng)大的功能已為人們深刻認(rèn)識(shí),它已進(jìn)入人類社會(huì)的各個(gè)領(lǐng)域并發(fā)揮著越來越重要的作用。越來越多的管理人員意識(shí)到信息管理的重要性。所以說科學(xué)化是二十一世紀(jì)餐飲業(yè)的主流目前，國內(nèi)的餐飲管理系統(tǒng)幾種情況是:中國的軟件系統(tǒng)大多源自管理信息系統(tǒng)(MIS)，從部門業(yè)務(wù)需求的角度出發(fā)設(shè)計(jì)。管理信息系統(tǒng)設(shè)計(jì)的初衷是服務(wù)于學(xué)校內(nèi)絕大多數(shù)的業(yè)務(wù)操作人員，將業(yè)務(wù)操作人員的重復(fù)性勞動(dòng)予以初場戶動(dòng)化，即從管理理論抽象出理想化的業(yè)務(wù)管理模式，在基于該業(yè)務(wù)模式的摹礎(chǔ)上實(shí)現(xiàn)低層次的數(shù)據(jù)處理或業(yè)務(wù)流程電子化。管理信息系統(tǒng)的設(shè)計(jì)，是根據(jù)中小型學(xué)校業(yè)務(wù)單元的需求來編寫的，一般無法滿足多體制、多元化、多董組織結(jié)構(gòu)的大型學(xué)校數(shù)據(jù)處理需求。與國外同類應(yīng)用系統(tǒng)及解決方案相比較，目前中國的管理軟件還有一些缺憾:第一，很多是從管理信息系統(tǒng)演變而來，雖然目前國內(nèi)的管理軟件已將模塊功能擴(kuò)展至學(xué)校管理或人才資本管理相關(guān)的整個(gè)業(yè)務(wù)領(lǐng)域，但系統(tǒng)在整體性、前瞻性和集成性方面仍有欠缺。1.2課題內(nèi)容本課題是設(shè)計(jì)一個(gè)基于C#的餐飲管理系統(tǒng)。本系統(tǒng)屬于小型的餐飲管理系統(tǒng)，可以有效地對(duì)中小型餐廳消費(fèi)進(jìn)行管理，本系統(tǒng)應(yīng)達(dá)到以下目標(biāo)：系統(tǒng)采用人機(jī)交互的方式，界面美觀友好，信息查詢靈活、方便，數(shù)據(jù)存儲(chǔ)安全可靠。實(shí)現(xiàn)對(duì)餐廳顧客開臺(tái)、點(diǎn)菜/加菜、賬目查詢和結(jié)賬等操作。對(duì)用戶輸入的數(shù)據(jù)，進(jìn)行嚴(yán)格的數(shù)據(jù)檢驗(yàn)，盡可能的避免人為錯(cuò)誤。實(shí)現(xiàn)對(duì)消費(fèi)賬目自動(dòng)結(jié)算。實(shí)現(xiàn)對(duì)消費(fèi)的歷史記錄進(jìn)行查詢，支持模糊查詢。系統(tǒng)應(yīng)最大限度地實(shí)現(xiàn)易維護(hù)性和易操作性。第二部分需求分析作為餐飲管理系統(tǒng)，首先需要具有餐飲管理員可以運(yùn)用系統(tǒng)來進(jìn)行登記的功能。在進(jìn)行登記后，餐飲管理員就可以登錄了，在登錄以后可以對(duì)現(xiàn)有的信息的查看、修改等。由于餐飲管理系統(tǒng)是信息管理系統(tǒng),利用計(jì)算機(jī)網(wǎng)絡(luò)的巨大潛在力量、數(shù)據(jù)信息的理念，從而減少人、物及財(cái)?shù)确矫嫔系南模瓿珊侠淼馁Y源分配。其開發(fā)的功能主要包括：本課題是設(shè)計(jì)一個(gè)基于.NET的餐飲管理系統(tǒng)。確的餐飲管理依據(jù)與輔助決策數(shù)據(jù)。 2.2系統(tǒng)結(jié)構(gòu)根據(jù)以上對(duì)餐飲管理系統(tǒng)的功能需求分析?，F(xiàn)對(duì)餐飲管理系統(tǒng)分析。不管是管理員還是普通餐飲管理員登錄系統(tǒng)都要進(jìn)行正確的判斷后，才能登入到系統(tǒng)，登錄活動(dòng)圖如圖4-2所示：第三部分總體設(shè)計(jì)餐飲管理系統(tǒng)餐飲管理系統(tǒng)基礎(chǔ)信息輔助系統(tǒng)維護(hù)系統(tǒng)幫助退出桌臺(tái)信息職員信息日歷計(jì)算器記事本權(quán)限管理系統(tǒng)備份系統(tǒng)恢復(fù)口令設(shè)置鎖定系統(tǒng)關(guān)于退出系統(tǒng)是否登陸是否登陸基本主窗體是否管理員基本登陸輔助工具退出幫助系統(tǒng)維護(hù)基礎(chǔ)信息系統(tǒng)設(shè)置第四部分核心代碼實(shí)現(xiàn)4．1登錄模塊實(shí)現(xiàn)usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Linq;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceMrCy{publicpartialclassfrmLogin:Form{publicfrmLogin(){InitializeComponent();}privatevoidForm1_Load(objectsender,EventArgse){txtName.Focus();}privatevoidtxtPwd_KeyPress(objectsender,KeyPressEventArgse){if(e.KeyChar==13){btnSubmit_Click(sender,e);}}privatevoidbtnSubmit_Click(objectsender,EventArgse){if(txtName.Text==""){MessageBox.Show("請輸入用戶名","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);}else{if(txtPwd.Text==""){MessageBox.Show("請輸入密碼","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);}else{SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();SqlCommandcmd=newSqlCommand("select*fromtb_UserwhereUserName='"+txtName.Text+"'andUserPwd='"+txtPwd.Text+"'",conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();if(sdr.HasRows){sdr.Close();cmd=newSqlCommand("select*fromtb_UserwhereUserName='"+txtName.Text+"'",conn);SqlDataReadersdr1=cmd.ExecuteReader();sdr1.Read();stringUserPower=sdr1["power"].ToString().Trim();conn.Close();frmMainmain=newfrmMain();main.power=UserPower;main.Names=txtName.Text;main.Times=DateTime.Now.ToShortDateString();main.Show();this.Hide();}else{MessageBox.Show("用戶名或密碼錯(cuò)誤");}}}}privatevoidbtnConcel_Click(objectsender,EventArgse){if(MessageBox.Show("確定退出系統(tǒng)嗎？","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Asterisk)==DialogResult.OK){Application.Exit();}}}}登陸界面如圖usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Linq;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceMrCy{publicpartialclassfrmMain:Form{publicfrmMain(){InitializeComponent();}publicSqlDataReadersdr;publicstringpower;publicstringNames;publicstringTimes;privatevoidfrmMain_Load(objectsender,EventArgse){switch(power){case"0":toolStripStatusLabel13.Text="超級(jí)管理員";break;case"1":toolStripStatusLabel13.Text="經(jīng)理";break;case"2":toolStripStatusLabel13.Text="一般用戶";break;}toolStripStatusLabel10.Text=Names;toolStripStatusLabel16.Text=Times;if(power=="2"){系統(tǒng)維護(hù)SToolStripMenuItem.Enabled=false;基礎(chǔ)信息MToolStripMenuItem.Enabled=false;}if(power=="1"){系統(tǒng)維護(hù)SToolStripMenuItem.Enabled=false;}}privatevoidAddItems(stringrzt){if(rzt=="使用"){lvDesk.Items.Add(sdr["RoomName"].ToString(),1);}else{lvDesk.Items.Add(sdr["RoomName"].ToString(),0);}}privatevoid開臺(tái)ToolStripMenuItem_Click(objectsender,EventArgse){if(lvDesk.SelectedItems.Count!=0){stringnames=lvDesk.SelectedItems[0].SubItems[0].Text;frmOpenopenroom=newfrmOpen();=names;openroom.ShowDialog();}else{MessageBox.Show("請選擇桌臺(tái)");}}privatevoidfrmMain_Activated(objectsender,EventArgse){lvDesk.Items.Clear();SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();SqlCommandcmd=newSqlCommand("select*fromtb_Room",conn);sdr=cmd.ExecuteReader();while(sdr.Read()){stringzt=sdr["RoomZT"].ToString().Trim();AddItems(zt);}conn.Close();}privatevoid點(diǎn)菜ToolStripMenuItem_Click(objectsender,EventArgse){if(lvDesk.SelectedItems.Count!=0){stringnames=lvDesk.SelectedItems[0].SubItems[0].Text;frmDCdc=newfrmDC();dc.RName=names;dc.ShowDialog();}else{MessageBox.Show("請選擇桌臺(tái)");}}privatevoid消費(fèi)查詢ToolStripMenuItem_Click(objectsender,EventArgse){if(lvDesk.SelectedItems.Count!=0){stringnames=lvDesk.SelectedItems[0].SubItems[0].Text;frmSerchserch=newfrmSerch();serch.RName=names;serch.ShowDialog();}else{MessageBox.Show("請選擇桌臺(tái)");}}privatevoid結(jié)賬ToolStripMenuItem_Click(objectsender,EventArgse){if(lvDesk.SelectedItems.Count!=0){stringnames=lvDesk.SelectedItems[0].SubItems[0].Text;frmJZjz=newfrmJZ();jz.Rname=names;jz.ShowDialog();}else{MessageBox.Show("請選擇桌臺(tái)");}}privatevoidlvDesk_DoubleClick(objectsender,EventArgse){frmDetailsdetails=newfrmDetails();details.TableName=lvDesk.SelectedItems[0].SubItems[0].Text;details.ShowDialog();}privatevoidlvDesk_Click(objectsender,EventArgse){stringnames=lvDesk.SelectedItems[0].SubItems[0].Text;SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();SqlCommandcmd=newSqlCommand("select*fromtb_RoomwhereRoomName='"+names+"'",conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();stringzt=sdr["RoomZT"].ToString().Trim();sdr.Close();if(zt=="使用"){this.contextMenuStrip1.Items[0].Enabled=false;this.contextMenuStrip1.Items[1].Enabled=true;this.contextMenuStrip1.Items[3].Enabled=true;this.contextMenuStrip1.Items[5].Enabled=true;this.contextMenuStrip1.Items[6].Enabled=true;}if(zt=="待用"){this.contextMenuStrip1.Items[0].Enabled=true;this.contextMenuStrip1.Items[1].Enabled=false;this.contextMenuStrip1.Items[3].Enabled=false;thisms[5].Enabled=false;this.contextMenuStrip1.Items[6].Enabled=false;}conn.Close();}privatevoid取消開臺(tái)toolStripMenuItem_Click(objectsender,EventArgse){ifdItems.Count!=0){stringnames=lvDesk.SelectedItems[0].SubItems[0].Text;SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();SqlCommandcmd=newSqlCommand("updatetb_RoomsetRoomZT='待用',Num=0whereRoomName='"+names+"'",conn);cmd.ExecuteNonQuery();cmd=newSqlCommand("deletefromtb_GuestFoodwherezhuotai='"+names+"'",conn);cmd.ExecuteNonQuery();conn.Close();frmMain_Activated(sender,e);}else{MessageBox.Show("請選擇桌臺(tái)");}}privatevoid桌臺(tái)信息ToolStripMenuItem1_Click(objectsender,EventArgse){frmDeskdesk=newfrmDesk();desk.ShowDialog();}privatevoid職員信息ToolStripMenuItem1_Click(objectsender,EventArgse){frmUserusers=newfrmUser();users.ShowDialog();}privatevoid日歷ToolStripMenuItem1_Click(objectsender,EventArgse){frmCalendercalender=newfrmCalender();calender.ShowDialog();}privatevoid記事本ToolStripMenuItem1_Click(objectsender,EventArgse){System.Diagnostics.Process.Start("notepad.exe");}privatevoid計(jì)算器ToolStripMenuItem1_Click(objectsender,EventArgse){System.Diagnostics.Process.Start("calc.exe");}privatevoid權(quán)限管理ToolStripMenuItem1_Click(objectsender,EventArgse){frmQxGlqx=newfrmQxGl();qx.ShowDialog();}privatevoid系統(tǒng)備份ToolStripMenuItem1_Click(objectsender,EventArgse){frmBFbf=newfrmBF();bf.ShowDialog();}privatevoid系統(tǒng)恢復(fù)ToolStripMenuItem1_Click(objectsender,EventArgse){sdr.Close();sdr.Dispose();frmHFhf=newfrmHF();hf.ShowDialog();}privatevoid口令設(shè)置ToolStripMenuItem1_Click(objectsender,EventArgse){frmPwdpwd=newfrmPwd();s=Names;pwd.ShowDialog();}privatevoid鎖定系統(tǒng)ToolStripMenuItem1_Click(objectsender,EventArgse){frmLocklocksystem=newfrmLock();locksystem.Owner=this;locksystem.ShowDialog();}privatevoid關(guān)于ToolStripMenuItem1_Click(objectsender,EventArgse){AboutBox1ab=newAboutBox1();ab.ShowDialog();}privatevoid退出系統(tǒng)ToolStripMenuItem1_Click(objectsender,EventArgse){if(MessageBox.Show("確定退出本系統(tǒng)嗎？","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Exclamation)==DialogResult.OK){Application.Exit();}}privatevoid系統(tǒng)維護(hù)SToolStripMenuItem_Click(objectsender,EventArgse){}privatevoidlvDesk_SelectedIndexChanged(objectsender,EventArgse){}privatevoidcontextMenuStrip1_Opening(objectsender,CancelEventArgse){}privatevoidcontextMenuStrip1_Opened(objectsender,EventArgse){}}}主框架運(yùn)行實(shí)現(xiàn)

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Linq;usingSystem.Windows.Forms;namespaceMrCy{publicpartialclassfrmCalender:Form{publicfrmCalender(){InitializeComponent();}privatevoidfrmCalender_Load(objectsender,EventArgse){}}}運(yùn)行界面如下圖usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Linq;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceMrCy{publicpartialclassfrmDC:Form{publicfrmDC(){InitializeComponent();}publicstringRName;privatevoidfrmDC_Load(objectsender,EventArgse){this.Text=RName+"點(diǎn)/加菜";TreeNodenewnode1=tvFood.Nodes.Add("鍋底");TreeNodenewnode2=tvFood.Nodes.Add("配菜");TreeNodenewnode3=tvFood.Nodes.Add("煙酒");TreeNodenewnode4=tvFood.Nodes.Add("主食");SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();SqlCommandcmd=newSqlCommand("select*fromtb_foodwherefoodty='1'",conn);SqlDataReadersdr=cmd.ExecuteReader();while(sdr.Read()){newnode1.Nodes.Add(sdr[3].ToString().Trim());}sdr.Close();cmd=newSqlCommand("select*fromtb_foodwherefoodty='2'",conn);sdr=cmd.ExecuteReader();while(sdr.Read()){newnode2.Nodes.Add(sdr[3].ToString().Trim());}sdr.Close();cmd=newSqlCommand("select*fromtb_foodwherefoodty='3'",conn);sdr=cmd.ExecuteReader();while(sdr.Read()){newnode3.Nodes.Add(sdr[3].ToString().Trim());}sdr.Close();cmd=newSqlCommand("select*fromtb_foodwherefoodty='4'",conn);sdr=cmd.ExecuteReader();while(sdr.Read()){newnode4.Nodes.Add(sdr[3].ToString().Trim());}sdr.Close();cmd=newSqlCommand("select*fromtb_Waiter",conn);sdr=cmd.ExecuteReader();while(sdr.Read()){cbWaiter.Items.Add(sdr["WaiterName"].ToString().Trim());}cbWaiter.SelectedIndex=0;sdr.Close();cmd=newSqlCommand("selectRoomZTfromtb_RoomwhereRoomName='"+RName+"'",conn);stringzt=Convert.ToString(cmd.ExecuteScalar());if(zt.Trim()=="待用"){groupBox1.Enabled=false;groupBox2.Enabled=false;groupBox3.Enabled=false;groupBox4.Enabled=false;}conn.Close();GetData();tvFood.ExpandAll();}privatevoidtreeView1_DoubleClick(objectsender,EventArgse){stringfoodname=tvFood.SelectedNode.Text;if(foodname=="鍋底"||foodname=="配菜"||foodname=="煙酒"||foodname=="主食"){}else{SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();SqlCommandcmd=newSqlCommand("select*fromtb_foodwherefoodname='"+foodname+"'",conn);SqlDataReadersdr=cmd.ExecuteReader();sdr.Read();txtNum.Text=sdr["foodnum"].ToString().Trim();txtName.Text=foodname;txtprice.Text=sdr["foodprice"].ToString().Trim();conn.Close();if(txtpnum.Text==""){MessageBox.Show("數(shù)量不能為空");return;}else{txtallprice.Text=Convert.ToString(Convert.ToInt32(txtprice.Text)*Convert.ToInt32(txtpnum.Text));}}}privatevoidtxtpnum_TextChanged(objectsender,EventArgse){if(txtpnum.Text==""){MessageBox.Show("數(shù)量不能為空");return;}else{if(Convert.ToInt32(txtpnum.Text)<1){MessageBox.Show("不能為小于的數(shù)字");return;}else{txtallprice.Text=Convert.ToString(Convert.ToInt32(txtprice.Text)*Convert.ToInt32(txtpnum.Text));}}}privatevoidGetData(){SqlConnectionconn=BaseClass.DBConn.CyCon();SqlDataAdaptersda=newSqlDataAdapter("selectfoodname,foodsum,foodallprice,waitername,beizhu,zhuotai,datatime,IDfromtb_GuestFoodwherezhuotai='"+RName+"'orderbyIDdesc",conn);DataSetds=newDataSet();sda.Fill(ds);dgvFoods.DataSource=ds.Tables[0];}privatevoidtxtpnum_KeyPress(objectsender,KeyPressEventArgse){if((e.KeyChar!=8&&!char.IsDigit(e.KeyChar))&&e.KeyChar!=13){MessageBox.Show("請輸入數(shù)字");e.Handled=true;}}privatevoidbtnDelete_Click(objectsender,EventArgse){if(dgvFoods.SelectedRows.Count>0){//stringnames=dgvFoods.SelectedCells[0].Value.ToString();intintID=Convert.ToInt32(dgvFoods.CurrentRow.Cells[7].Value);SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();//SqlCommandcmd=newSqlCommand("deletefromtb_GuestFoodwherefoodname='"+names+"'andzhuotai='"+RName+"'",conn);SqlCommandcmd=newSqlCommand("deletefromtb_GuestFoodwhereID='"+intID+"'",conn);cmd.ExecuteNonQuery();conn.Close();GetData();}}privatevoidbtnSave_Click(objectsender,EventArgse){if(txtName.Text==""||txtNum.Text==""||txtprice.Text==""){MessageBox.Show("請將選擇菜系");return;}else{if(txtpnum.Text==""){MessageBox.Show("數(shù)量不能為空");return;}else{if(Convert.ToInt32(txtpnum.Text)<=0){MessageBox.Show("請輸入消費(fèi)數(shù)量");return;}else{SqlConnectionconn=BaseClass.DBConn.CyCon();conn.Open();SqlCommandcmd=newSqlCommand("insertintotb_GuestFood(foodnum,foodname,foodsum,foodallprice,waitername,beizhu,zhuotai,datatime)values('"+txtNum.Text.Trim()+"','"+txtName.Text.Trim()+"','"+txtpnum.Text.Trim()+"','"+Convert.ToDecimal(txtallprice.Text.Trim())+"','"+cbWaiter.SelectedItem.ToString()+"','"+txtbz.Text.Trim()+"','"+RName+"','"+DateTime.Now.ToString()+"')",conn);cmd.ExecuteNonQuery();conn.Close();GetData();}}}}privatevoidbtnExit_Click(objectsender,EventArgse){this.Close();}privatevoidgroupBox2_