餐饮管理系统代码.doc

1、餐饮管理系统代码1 using System;2using System.Collections.Generic;3using System.ComponentModel;4using System.Data;5using System.Drawing;6using System.Text;7using System.Windows.Forms;8using System.Collections;9namespace 餐饮管理系统10.11 public partial class frmManagement : Form12 .13 ArrayList RoomStatus = new Ar

2、rayList();14 ArrayList VipClass = new ArrayList();15 public frmManagement()16 .17 InitializeComponent();18 1920 privatevoid房间类型BindingNavigatorSaveItem_Click(objectsender,EventArgse)21 .22 this.Validate();23 this. 房间类型BindingSource.EndEdit();24 this. 房间类型TableAdapter.Update(this.dieteticManagementDa

3、taSet.房间类型);25 2627 privatevoidfrmManagement_Load(object sender, EventArgse)28 .29 / TODO: 这行代码将数据加载到表“ dieteticManagementDataSet. 管理员” 中。您可以根据需要移动或移除它。30 this. 管理员 TableAdapter.Fill(this.dieteticManagementDataSet. 管理员 );31 / TODO: 这行代码将数据加载到表“dieteticManagementDataSet.Vip ”中。您可以根据需要移动或移除它。32 this.v

4、ipTableAdapter.Fill(this.dieteticManagementDataSet.Vip);3334 / TODO: 这行代码将数据加载到表“dieteticManagementDataSet. 餐牌”中。您可以根据需要移动或移除它。35 this. 餐牌 TableAdapter.Fill(this.dieteticManagementDataSet. 餐牌 );36 / TODO: 这行代码将数据加载到表“dieteticManagementDataSet. 食品类别”中。您可以根据需要移动或移除它。37 this. 食品类别TableAdapter.Fill(this

5、.dieteticManagementDataSet. 食品类别);4142 中您可以根据需要移动或移除它43444546474849505152535455565758596061626364656667686970717273747538/ TODO: 这行代码将数据加载到表“dieteticManagementDataSet. 商品”中您可以根据需要移动或移除它3940/ TODO: 这行代码将数据加载到表“dieteticManagementDataSet. 餐房”中您可以根据需要移动或移除它this. 餐房 TableAdapter.Fill(this.dieteticManagem

6、entDataSet. 餐房 );/ TODO: 这行代码将数据加载到表“dieteticManagementDataSet. 房间类型”您可以根据需要移动或移除它。this. 房间类型TableAdapter.Fill(this.dieteticManagementDataSet. 房间类型);VipClass.Add(" 普通会员");VipClass.Add(" 中级会员");VipClass.Add(" 高级会员");RoomStatus.Add(" 可供");RoomStatus.Add(" 预

7、订");RoomStatus.Add(" 占用");RoomStatus.Add(" 停用");RoomStatus.Add(" 脏台");性别ComboBox.Items.Add(" 男");性别ComboBox.Items.Add(" 女");级别ComboBox.Items.Clear();foreach (string s in VipClass)级别 ComboBox.Items.Add(s);餐台状态ComboBox.Items.Clear();foreach (strin

8、g s in RoomStatus)餐台状态ComboBox.Items.Add(s);string sdata = Program.DBOpertor.GetRoomClass();房间类型ComboBox.Items.Clear();for (int i = 0; i < sdata.Length; i+)房间类型ComboBox.Items.Add(sdatai);private void 餐房 BindingNavigatorSaveItem_Click(object sender, EventArgs e).this.Validate();this. 餐房BindingSour

9、ce.EndEdit();this. 餐房TableAdapter.Update(this.dieteticManagementDataSet. 餐房 );private void Add_Click(object sender, EventArgs e)./new frmAddAndModification( 餐 房 DataGridView,7677this.dieteticManagementDataSet. 餐房 ).Show();frm 餐房 f=new frm 餐房 (this.dieteticManagementDataSet. 餐房 ,"Add");78 f

10、oreach (string s in RoomStatus)79 f. 餐台状态ComboBox.Items.Add(s);80 string sdata = Program.DBOpertor.GetRoomClass();81 for (int i = 0; i < sdata.Length; i+)82 f. 房间类型ComboBox.Items.Add(sdatai);83 f.ShowDialog();84 / f.Dispose();85 8687 privatevoid Delete_Click(object sender, EventArgs e)88 .89 if (

11、MessageBox.Show(" 确 定 要 删 除 吗 ?", " 删 除 确 定 ",MessageBoxButtons.YesNo) = DialogResult.Yes)90 .91 string no = 餐房 DataGridView.CurrentRow.Cells0.Value.ToString();92 this.dieteticManagementDataSet. 餐房 .Rows.Find(no).Delete();93 94 9596 privatevoidModification_Click(object sender, Ev

12、entArgs e)97 .98 string no = 餐房 DataGridView.CurrentRow.Cells0.Value.ToString();99 using (frm 餐房 f = new frm 餐房 (this.dieteticManagementDataSet. 餐房 .Rows.Find(no), "Modification")100 .101 foreach (string s in RoomStatus)102 f. 餐台状态ComboBox.Items.Add(s);103 string sdata = Program.DBOpertor.

13、GetRoomClass();104 for (int i = 0; i < sdata.Length; i+)105f. 房间类型ComboBox.Items.Add(sdatai);106f.ShowDialog();107108109110111privatevoid button1_Click(object sender, EventArgs e)112.113using (frm 房间类型f = new frm 房间类型(this.dieteticManagementDataSet.房间类型,"Add")114.115f.ShowDialog();11611

14、7118119private void button2_Click(object sender, EventArgs e)120.121if (MessageBox.Show(" 确 定 要 删 除 吗 ?", " 删 除 确 定 ",MessageBoxButtons.YesNo) = DialogResult.Yes)122.123string no = 房 间 类 型DataGridView.CurrentRow.Cells0.Value.ToString();124this.dieteticManagementDataSet. 房间类型.Rows

15、.Find(no).Delete();125126127128privatevoidbutton3_Click(object sender, EventArgs e)129.130string no = 房间类型DataGridView.CurrentRow.Cells0.Value.ToString();131using (frm 房间类型f = new frm 房间类型(this.dieteticManagementDataSet.房间类型.Rows.Find(no), "Modification")132.133f.ShowDialog();134135136137p

16、rivatevoid商品类型添加_Click(objectsender, EventArgs e)138.139using (frm 商品类型f = new frm 商品类型(this.dieteticManagementDataSet.食品类别, "Add")140.141f.ShowDialog();142143144145privatevoid商品类型删除_Click(objectsender, EventArgs e)146.147if (MessageBox.Show(" 确 定 要 删 除 吗 ?", " 删 除 确 定 "

17、;,MessageBoxButtons.YesNo) = DialogResult.Yes)148.149string no = 商 品 类 型DataGridView.CurrentRow.Cells0.Value.ToString();150this.dieteticManagementDataSet. 食品类别.Rows.Find(no).Delete();151152153154privatevoid商品类型修改_Click(objectsender, EventArgs e)155.156string no = 商品类型DataGridView.CurrentRow.Cells0.V

18、alue.ToString();157 食品类158159160161162163164165166167 别 );168169170171172 "Add") 173174175176177178179180181182183184185186187using (frm 商品类型f = new frm 商品类型(this.dieteticManagementDataSet.Rows.Find(no), "Modification"). f.ShowDialog(); private void 商品类型保存_Click(object sender, Ev

19、entArgs e).this.Validate();this.食品类另1J BindingSource.EndEdit();this. 食品类TableAdapter.Update(this.dieteticManagementDataSet. 食品类private void 餐牌添加_Click(object sender, EventArgs e).using (frm 餐牌 f = new frm 餐牌 (this.dieteticManagementDataSet. 餐牌 ,.DataTable BigClass = Program.DBOpertor.GetBigClass();s

20、tring SBigClass;for (int i = 0; i < BigClass.Rows.Count; i+) .SBigClass = BigClass.Rowsi" 食品类".ToString();f. 食品类ComboBox.Items.Add(SBigClass); f.ShowDialog(); private void 餐牌删除_Click(object sender, EventArgs e).if (MessageBox.Show(" 确 定 要 删 除 吗 ?", " 删 除 确 定 ",Messag

21、eBoxButtons.YesNo) = DialogResult.Yes)188189190191192193194195196.string no = 餐牌 DataGridView.CurrentRow.Cells0.Value.ToString();this.dieteticManagementDataSet. 餐牌 .Rows.Find(no).Delete();private void 餐牌修改_Click(object sender, EventArgs e).string no = 餐牌 DataGridView.CurrentRow.Cells0.Value.ToString

22、();198199200201202203204205206207208209210211212213214 型 );215216217218219220221222223224225226227228229230231232233234235236237238197using (frm 餐牌 f = new frm 餐牌 (this.dieteticManagementDataSet. 餐牌 .Rows.Find(no), "Modification").f.ShowDialog();private void 餐牌保存_Click(object sender, Event

23、Args e).this.Validate();this.餐牌 BindingSource.EndEdit();this.餐牌 TableAdapter.Update(this.dieteticManagementDataSet.餐牌);private void 房间类保存_Click(object sender, EventArgs e).this.Validate();this.房间类型 BindingSource.EndEdit();this. 房间类TableAdapter.Update(this.dieteticManagementDataSet. 房间类private void 餐

24、房保存_Click(object sender, EventArgs e).this.Validate();this.餐房 BindingSource.EndEdit();this.餐房 TableAdapter.Update(this.dieteticManagementDataSet.餐房);private void Vip 添加 _Click(object sender, EventArgs e) .using (frmVip f = new frmVip(this.dieteticManagementDataSet.Vip, "Add") .f. 性别ComboBo

25、x.Items.Add(" 男 ");f. 性别ComboBox.Items.Add(" 女 ");foreach (string s in VipClass)f. 级别ComboBox.Items.Add(s);f.ShowDialog();private void Vip 修改 _Click(object sender, EventArgs e) .string no = vipDataGridView.CurrentRow.Cells0.Value.ToString();239using (frmVip f = newfrmVip(this.die

26、teticManagementDataSet.Vip.Rows.Find(no), "Modification") 240.241f. 性别ComboBox.Items.Add(" 男 ");242f. 性别ComboBox.Items.Add(" 女 ");243foreach (string s in VipClass)244f. 级别 ComboBox.Items.Add(s);245f.ShowDialog();246247248249privatevoidVip删除 _Click(object sender, EventAr

27、gs e)250.251if (MessageBox.Show(" 确 定 要 删 除 吗 ?", " 删 除 确 定 ",MessageBoxButtons.YesNo) = DialogResult.Yes)252.253string no = vipDataGridView.CurrentRow.Cells0.Value.ToString();254this.dieteticManagementDataSet.Vip.Rows.Find(no).Delete();255256257258private void Vip 保存 _Click(obje

28、ct sender, EventArgs e)259.260this.Validate();261this.vipBindingSource.EndEdit();262this.vipTableAdapter.Update(this.dieteticManagementDataSet.Vip);263264265private void Save_Click(object sender, EventArgs e)266.267餐牌保存_Click(sender, e);268房间类型保存_Click(sender, e);269商品类型保存_Click(sender, e);270餐房保存_Click(sender, e);271Vip 保存 _Click(sender, e);272管理员保存_Click(sender, e);273Program.f.GetUpToDate();274this.Close();275276277private void Cancel_Click(object sender, EventArgs e)278.279this.Close();280281282private void