C餐饮管理完整 .docx

《C餐饮管理完整 .docx》由会员分享，可在线阅读，更多相关《C餐饮管理完整 .docx（30页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、精品名师归纳总结运算机应用软件课程设计报告2021-12-25工程名称餐饮治理系统班级学号姓名指导老师完成日期目录一、需求分析 21.1 数据需求 21.2 总体设计 21.3 流程图 3二、总体设计 32.1 登录窗体的设计 32.2 注册用户界面设计 32.3 主窗体设计 32.4 基础信息 42.4.1 基础信息 -桌台信息 42.4.2 基础信息 职工信息 42.5 帮忙工具 42.6 系统爱护 42.6.1 系统爱护 权限治理 42.6.2 系统爱护 添加用户 42.7 系统设置 52.7.1 系统设置 修改密码 52.7.2 系统设置 锁定系统 52.8 帮忙 52.9 快捷菜单

2、52.9.1 开台 52.9.2 点 加菜 52.9.3 消费查询 55.9.4 结账 5三、详细设计 63.1 登录部分代码 63.2 主界面的代码 8可编辑资料 - - - 欢迎下载精品名师归纳总结餐饮治理系统基础信息帮忙工具系统爱护系统设置帮忙退出3.3 职工信息查询代码 123.4 桌台信息查询代码 153.5 帮忙工具 153.6 修改密码、添加用户、注册用户功能代码153.7 桌台基本信息（双击桌台图标后）代码183.8 开台部分代码 183.9 结账部分代码 203.10 点 加菜部分代码 223.11 消费查询部分代码 273.12 用户权限治理代码 27 四、单元测试与组装测

3、试 29 五、总结 29六、参考文献 30一、需求分析随着餐饮业的不断进展，餐饮治理系统的内容对于决策者和治理者来说都特殊重要。本系统主要包括桌台显示、消费查询。人事档案及权限等几大部 分，具有良好的用户接口，使用便利，具有完善的查询，对爱护系统起到帮忙决策的作用，能准时、便利、灵动的进行查询、修改、删除等爱护性操作。餐饮治理系统有足够的储备容量，中意酒店每日营业的变动，另外，对于操作用户有确定的治理，并对用户的权限有确定的设置超级治理员拥有全部权限。经理除了系统爱护外，其他操纵都可以，一般用户只能实现帮忙工具的使用权限。1.1 数据需求Tb_food-储备食品的Tb_foodtype-储备食

4、品的类别Tb_Waiter储备全部职员信息Tb_User-储备治理用户信息Tb_Room-储备餐厅桌台信息Tb_GuestFood储备消费信息1.2 总体设计可编辑资料 - - - 欢迎下载精品名师归纳总结桌职日计记权添修锁关退台员历算事限加改定于出信信器本管用密系系息息开台理户码统统桌台点 加菜单天总营业额的查询1.3 流程图消 费 查结账二、总体设计2.1 登录窗体的设计用户信息 ER 图用户信息Tb_User点击登录进入主窗体，点击注册账号就进入注册用户界面2.2 注册用户界面设计系统编号ID用 户名Username用户 权限power用户密码UserPwd默认注册的用户类型只能是一般用

5、户2.3 主窗体设计可编辑资料 - - - 欢迎下载精品名师归纳总结2.4 基础信息2.4.1 基础信息 -桌台信息可实现添加加、修 改有增加、删除、查询 桌台信息的功能双击图标是桌台基本信息双击桌台图标显2.4.2 基础信息 职工信息2.5 帮忙工具2.5.1 帮忙工具 日历2.5.2 帮忙工具 运算器2.5.3 帮忙工具 记事本2.6 系统爱护2.6.1 系统爱护 权限治理2.6.2 系统爱护 添加用户可编辑资料 - - - 欢迎下载精品名师归纳总结2.7 系统设置2.7.1 系统设置 修改密码2.7.2 系统设置 锁定系统2.8 帮忙2.9 快捷菜单2.9.1 开台2.9.2 点 加菜2

6、.9.3 消费查询5.9.4 结账可编辑资料 - - - 欢迎下载精品名师归纳总结三、详细设计3.1 登录部分代码namespace MyCyMS/登陆界面public partial class frmLogin :Formpublic int m=0。public frmLoginInitializeComponent。private void frmLogin_Load_1object sender, EventArgs e/ System.Windows.Forms.Control.Top.get。txtName.Focus。private void txtPwd_KeyPressob

7、ject sender, KeyPressEventArgs eif e.KeyChar = 13btnSubmit_Clicksender, e。/点击登录按钮private void btnSubmit_Clickobject sender, EventArgs eif txtName.Text = MessageBox.Show请输入用户名 , 警告, MessageBoxButtons.OK, MessageBoxIcon.Warning。elseSqlConnection conn = BaseClass.BaseClass.CyCon。conn.Open。SqlCommand cm

8、d = new SqlCommandselect count* from tb_User whereUserName= + txtName.Text + and UserPwd= + txtPwd.Text + , conn。int i = Convert.ToInt32cmd.ExecuteScalar。if i 0可编辑资料 - - - 欢迎下载精品名师归纳总结cmd = new SqlCommandselect * from tb_User where UserName= + txtName.Text + , conn。SqlDataReader sdr = cmd.ExecuteRea

9、der。sdr.Read。string UserPower = sdrpower.ToString.Trim。conn.Close。frmMain main = new frmMain。main.power = UserPower。/ 记录登录用户的权限main.Names = txtName.Text。/ 用户名/frmChangePwd.n/ main.Times = DateTime.Now.ToShortDateString。/ 只输出日期main.Times = DateTime.Now.ToString。/ 记录登录时间main.Show。this.Hide。elsem+。if m

10、 = 3btnSubmit.Enabled = false。MessageBox.Show密码错误 3次，请退出 . 。elseMessageBox.Show用户名或密码错误 。private void btConcel_Clickobject sender, EventArgs eApplication.Exit。/点击注册账号 .i=2 表示这册用户界面private void button2_Clickobject sender, EventArgs efrmChangePwd a = new frmChangePwd。a.i = 2。a.ShowDialog。/假如点击用户名文本框 ,

11、 里面的文本清空 , 用户即可输出用户名private void txtName_Clickobject sender, EventArgs etxtName.Text = 。可编辑资料 - - - 欢迎下载精品名师归纳总结3.2 主界面的代码namespace MyCyMSpublic partial class frmMain : Formpublic frmMainInitializeComponent。public SqlDataReader sdr。public string powerpublic string Names。public string Times。private v

12、oid frmMain_Loadobject sender, EventArgs eswitch powercase 0: toolStripStatusLabel12.Text = 超级治理员 。 break 。case 1: toolStripStatusLabel12.Text = 经理 。 break 。case 2: toolStripStatusLabel12.Text = 一般用户 。 break 。toolStripStatusLabel15.Text = Names。toolStripStatusLabel14.Text = Times。if power = 2系统爱护 To

13、olStripMenuItem1.Enabled = false。基础信息 ToolStripMenuItem1.Enabled = false。if power = 1系统爱护 ToolStripMenuItem1.Enabled = false。private void AddItemsstring rztif rzt = 使用 lvDesk.Items.AddsdrRoomName.ToString, 1。else可编辑资料 - - - 欢迎下载精品名师归纳总结lvDesk.Items.AddsdrRoomName.ToString, 0。private void开台ToolStripM

14、enuItem_Clickobject sender, EventArgs eif lvDesk.SelectedItems.Count .= 0string names = lvDesk.SelectedItems0.SubItems0.Text。frmOpen openroom = new frmOpen。openroom.name = names。openroom.ShowDialog。elseMessageBox.Show请选择桌台 。private void点加菜 ToolStripMenuItem_Clickobject sender, EventArgs eif lvDesk.S

15、electedItems.Count .= 0string names = lvDesk.SelectedItems0.SubItems0.Text。frmJZD dc = new frmJZD。dc.RName = names。dc.ShowDialog。elseMessageBox.Show请选择桌台 。private void结账ToolStripMenuItem_Clickobject sender, EventArgs eif lvDesk.SelectedItems.Count .= 0string names = lvDesk.SelectedItems0.SubItems0.T

16、ext。frmPayOff payoff = new frmPayOff。payoff.RName = names。payoff.ShowDialog。elseMessageBox.Show请选择桌台 。private void frmMain_Activatedobject sender, EventArgs e可编辑资料 - - - 欢迎下载精品名师归纳总结lvDesk.Items.Clear。SqlConnection conn = BaseClass.BaseClass.CyCon。conn.Open。SqlCommand cmd = new SqlCommandselect * fr

17、om tb_Room, conn。sdr = cmd.ExecuteReader。while sdr.Readstring zt = sdrRoomZT.ToString.Trim。AddItemszt。conn.Close。private void消费查询 ToolStripMenuItem_Clickobject sender, EventArgs eif lvDesk.SelectedItems.Count .= 0string names = lvDesk.SelectedItems0.SubItems0.Text。frmSerch serch = new frmSerch。serch

18、.RName = names。serch.ShowDialog。elseMessageBox.Show请选择桌台 。private void lvDesk_DoubleClickobject sender, EventArgs efrmDetatles details = new frmDetatles。details.TableName = lvDesk.SelectedItems0.SubItems0.Text。details.ShowDialog。private void lvDesk_Clickobject sender, EventArgs estring names = lvDes

19、k.SelectedItems0.SubItems0.Text。SqlConnection conn = BaseClass.BaseClass.CyCon。conn.Open。SqlCommand cmd = new SqlCommandselect * from tb_Room where RoomName= + names+ , conn。SqlDataReader sdr = cmd.ExecuteReader。sdr.Read。string zt = sdrRoomZT.ToString.Trim。sdr.Close。if zt = 使用可编辑资料 - - - 欢迎下载精品名师归纳总

20、结this.contextMenuStrip1.Items0.Enabled = false。this.contextMenuStrip1.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.contextMenuSt

21、rip1.Items1.Enabled = false。this.contextMenuStrip1.Items3.Enabled = false。this.contextMenuStrip1.Items5.Enabled = false。this.contextMenuStrip1.Items6.Enabled = false。conn.Close。private void添加用户 ToolStripMenuItem1_Clickobject sender, EventArgs efrmChangePwd pwd = new frmChangePwd。/pwd.names = Names。p

22、wd.i = 1。pwd.ShowDialog。private void退出ToolStripMenuItem1_Clickobject sender, EventArgs eif MessageBox.Show确定退出本系统吗？ , 提示, MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation = DialogResult.OKApplication.Exit。private void帮忙ToolStripMenuItem1_Clickobject sender, EventArgs efrmAbout ab = new frmAbou

23、t。ab.ShowDialog。private void锁定系统 ToolStripMenuItem1_Clickobject sender, EventArgs efrmLock m = new frmLock。m.ShowDialog。private void权限治理 ToolStripMenuItem1_Clickobject sender, EventArgs eusermanager power = new usermanager。power.ShowDialog。可编辑资料 - - - 欢迎下载精品名师归纳总结private void日历ToolStripMenuItem1_Cli

24、ckobject sender, EventArgs efrmCalender calender = new frmCalender。calender.ShowDialog。private void运算器 ToolStripMenuItem1_Clickobject sender, EventArgs eSystem.Diagnostics.Process.Startcalc.exe。private void记事本 ToolStripMenuItem1_Clickobject sender, EventArgs eSystem.Diagnostics.Process.Startnotepad.

25、exe。private void桌台信息 ToolStripMenuItem1_Clickobject sender, EventArgs efrmDesk desk = new frmDesk。desk.ShowDialog。private void职员信息 ToolStripMenuItem1_Clickobject sender, EventArgs efrmUser users = new frmUser。users.ShowDialog。3.3 职工信息查询代码namespace MyCyMSpublic partial class frmUser : Formpublic frmU

26、serInitializeComponent。private void btQuery_Clickobject sender, EventArgs eBindData。private void BindDataSqlConnection conn = BaseClass.BaseClass.CyCon。SqlDataAdapter sda = new SqlDataAdapterselect ID,WaiterName姓名,CardNum 身份证号 ,WaiterNum服务员编号 ,Sex 性别,Age 年龄,Tell电话号码 from tb_Waiter order by ID ,conn

27、。可编辑资料 - - - 欢迎下载精品名师归纳总结DataSet ds = new DataSet。sda.Fillds。dataGridView1.DataSource = ds.Tables0。/修改按钮private void button1_Clickobject sender, EventArgs ebtReWrite.Enabled = false。btSave.Enabled = true。btConcle.Enabled = true。txtname.Enabled = false。txtAge.Enabled = true。txtIDcard.Enabled = true。t

28、xtWaiterNum.Enabled = true。txtTel.Enabled = true。cbSex.Enabled = true。private void btExit_Clickobject sender, EventArgs ethis.Close。private void btReWrite_Clickobject sender, EventArgs etxtname.Text = 。txtAge.Text = 。txtIDcard.Text = 。txtTel.Text = 。txtWaiterNum.Text = 。txtname.Enabled = true。txtAge

29、.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_Clickobject sender, EventArgs eSqlConnection conn = BaseClass.BaseClass.CyCon。conn.Open。SqlComm

30、and cmd = new SqlCommanddelete from tb_Waiter where ID= + dataGridView1.SelectedCells0.Value.ToString + , conn。cmd.ExecuteNonQuery。conn.Close。可编辑资料 - - - 欢迎下载精品名师归纳总结BindData。private void btSave_Clickobject sender, EventArgs eSqlConnection conn = BaseClass.BaseClass.CyCon。conn.Open。SqlCommand cmd =

31、new SqlCommandselect count* from tb_Waiter where WaiterName= + txtname.Text + , conn。int i = Convert.ToInt32cmd.ExecuteScalar。if i 0cmd = new SqlCommandupdate tb_Waiter set WaiterName= + txtname.Text + ,CardNum= + txtIDcard.Text + ,WaiterNum= + txtWaiterNum.Text + ,Sex= + cbSex.SelectedItem.ToString

32、 + ,Age= + txtAge.Text + ,Tell= + txtTel.Text + where ID= + dataGridView1.SelectedCells0.Value.ToString + , conn。cmd.ExecuteNonQuery。conn.Close。 BindData。btReWrite.Enabled = true。btChange.Enabled = false。btSave.Enabled = false。btQuery.Enabled = true。btConcle.Enabled = false。btDelete.Enabled = false。

33、btExit.Enabled = true。txtname.Enabled = false。elsecmd = new SqlCommandinsert into tb_WaiterWaiterName,CardNum,WaiterNum,Sex,Age,Tell values + txtname.Text + , + txtIDcard.Text + , + txtWaiterNum.Text + , + cbSex.SelectedItem.ToString + , +txtAge.Text + , + txtTel.Text + , conn。cmd.ExecuteNonQuery。co

34、nn.Close。BindData。btChange.Enabled = true。btReWrite.Enabled = true。btSave.Enabled = false。btQuery.Enabled = true。btConcle.Enabled = false。btDelete.Enabled = true。btExit.Enabled = true。txtname.Enabled = false。txtname.Enabled = false。可编辑资料 - - - 欢迎下载精品名师归纳总结private void frmUser_Loadobject sender, Even

35、tArgs ecbSex.SelectedIndex = 0。private void dataGridView1_CellClickobject sender, DataGridViewCellEventArgs e可编辑资料 - - - 欢迎下载精品名师归纳总结trytxtname.Text = dataGridView1.SelectedCells1.Value.ToString。txtIDcard.Text = dataGridView1.SelectedCells2.Value.ToString。txtWaiterNum.Text = dataGridView1.SelectedCe

36、lls3.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 errMess

37、ageBox.Show不能单击单元格 + err.ToString, 错误！ 。3.4 桌台信息查询代码与职工信息查询相像3.5 帮忙工具调用系统的日历，运算器、记事本功能3.6 修改密码、添加用户、注册用户功能代码这三部分共用一个界面，用代码把握不同部分的显示namespace MyCyMSpublic partial class frmChangePwd : Formstring connectionstring = server=20210226-2024。uid=sa 。pwd=123。database=db_MrCy 。connect timeout=30。可编辑资料 - - - 欢

38、迎下载精品名师归纳总结public SqlCommand cmd = new SqlCommand。public string dataTableName = tb_User。public frmChangePwdInitializeComponent。public string names。public int i。private void btSave_Clickobject sender, EventArgs eSqlConnection conn = new SqlConnectionconnectionstring。cmd.CommandType = CommandType.Text

39、。cmd.Connection = conn。string sql = update tb_User set UserPwd= + txtPwd1.Text.ToString。sql = sql + where username= + txtUserName.Text.ToString + 。cmd.CommandText = sql。if txtPwd1.Text = txtPwd2.Texttryconn.Open。if MessageBox.Show的确要修改该记录吗？ , 提示,MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation = DialogResult.OKint n = cmd.ExecuteNonQuery。MessageBox.Show修改用户密码成功！