本文實例為大家分享了C#實現餐飲管理系統的具體代碼，供大家參考，具體內容如下
此系統采用C#語言的Winfrom和ADO.NET技術搭建的簡單的CS系統。
部分代碼：
frmBook.cs
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace Catering{ public partial class frmBook : Form { public frmBook() { InitializeComponent(); } public void getData() { string Filter = " WHERE 1 = 1 "; if (txtName.Text.Trim() != "") { Filter += " AND Name Like '%" + txtName.Text + "%'"; } BookEntity book = new BookEntity(); DataTable dt = book.Query(Filter); this.dataGridView1.DataSource = dt; for (int i = 1; i < this.dataGridView1.Columns.Count; i++) { this.dataGridView1.Columns[i].ReadOnly = true; } } private void frmBook_Load(object sender, EventArgs e) { getData(); } //全選 private void btnChose_Click(object sender, EventArgs e) { bool b = false; if (btnChose.Text == "全 選") { b = true; btnChose.Text = "取消全選"; } else { b = false; btnChose.Text = "全 選"; } for (int i = 0; i < this.dataGridView1.Rows.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = b; } this.dataGridView1.EndEdit(); this.dataGridView1.CurrentCell = null; } //刪除 private void btnDelete_Click(object sender, EventArgs e) { dataGridView1.EndEdit(); dataGridView1.CurrentCell = null; DataTable dt = (DataTable)this.dataGridView1.DataSource; DataRow[] drs = dt.Select("選擇=1"); if (drs.Length == 0) { MessageBox.Show("請選擇要刪除的記錄！"); return; } foreach (DataRow dr in drs) { BookEntity book = new BookEntity(); book.Id = Convert.ToInt32(dr["編號"].ToString()); book.Delete(); } MessageBox.Show("刪除成功！"); getData(); } //查詢 private void btnSearch_Click(object sender, EventArgs e) { getData(); } //雙擊修改 private void dataGridView1_MouseDoubleClick(object sender, MouseEventArgs e) { if (this.dataGridView1.CurrentRow.Index > -1) { frmBookEdit frm = new frmBookEdit(); frm.StartPosition = FormStartPosition.CenterScreen; frm.IdNo = dataGridView1.CurrentRow.Cells[1].Value.ToString(); if (frm.ShowDialog() == DialogResult.OK) { getData(); } } } }} |
frmControl.cs
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DAL;namespace Catering{ public partial class frmControl : Form { public frmControl() { InitializeComponent(); } private void frmControl_Load(object sender, EventArgs e) { #region 生成餐桌信息 TableNoEntity table = new TableNoEntity(); DataTable dt = table.Query(" ORDER BY DispalyIndex "); int x = 46; int y = 66; int width = 150; int height = 95; //動態生成餐臺 for (int i = 0; i < dt.Rows.Count; i = i + 5) { for (int j = 0; j < 5 && (i + j) < dt.Rows.Count; j++) { DataRow dr = dt.Rows[i + j]; //生成餐臺圖片控件 PictureBox pictureBox = new PictureBox(); pictureBox.ContextMenuStrip = this.contextMenuStrip1; pictureBox.Image = Image.FromFile(Application.StartupPath + "\\res\\綠.gif"); //判斷是否有預定 BookEntity book = new BookEntity(); DataTable dat = book.Query(" where TableNo ='" + dr["TableNo"] + "' AND BookTime>getdate()"); if (dat.Rows.Count > 0) { pictureBox.Image = Image.FromFile(Application.StartupPath + "\\res\\黃.gif"); } //判斷是否在使用 OrdersEntity orders = new OrdersEntity(); DataTable dats = orders.Query(" where TableNo ='" + dr["TableNo"] + "' and PayORnot ='否'"); if (dats.Rows.Count > 0) { pictureBox.Image = Image.FromFile(Application.StartupPath + "\\res\\紅.gif"); } pictureBox.Location = new System.Drawing.Point(x, y); pictureBox.Name = "pictureBox_" + dr["TableNo"].ToString(); pictureBox.Size = new System.Drawing.Size(width, height); pictureBox.TabStop = false; pictureBox.Visible = true; pictureBox.SendToBack(); this.Controls.Add(pictureBox); //生成餐臺說明信息 Label lbl = new Label(); lbl.Name = "lbl_" + dr["TableNo"].ToString(); lbl.Text = dr["TableNo"].ToString() + " " + dr["SitCount"].ToString() + "座位"; lbl.Font = new Font("宋體", 10); lbl.BackColor = Color.Transparent; lbl.Location = new Point(25, 30); pictureBox.Controls.Add(lbl); x = x + 200; } y = y + 150; x = 46; } #endregion } private void 預定ToolStripMenuItem_Click(object sender, EventArgs e) { string Name = contextMenuStrip1.SourceControl.Name; string[] str = Name.Split('_'); frmBookEdit frm = new frmBookEdit(); frm.StartPosition = FormStartPosition.CenterScreen; frm.TopMost = true; frm.Id = str[1]; if (frm.ShowDialog() == DialogResult.OK) { ((PictureBox)contextMenuStrip1.SourceControl).Image = Image.FromFile(Application.StartupPath + "\\res\\黃.gif"); } } private void 結賬ToolStripMenuItem_Click(object sender, EventArgs e) { string Name = contextMenuStrip1.SourceControl.Name; string[] str = Name.Split('_'); frmPayEdit frm = new frmPayEdit(); frm.StartPosition = FormStartPosition.CenterScreen; //frm.TopMost = true; frm.Id = str[1]; if (frm.ShowDialog() == DialogResult.OK) { ((PictureBox)contextMenuStrip1.SourceControl).Image = Image.FromFile(Application.StartupPath + "\\res\\綠.gif"); } } private void 退訂ToolStripMenuItem_Click(object sender, EventArgs e) { } private void 點菜ToolStripMenuItem1_Click(object sender, EventArgs e) { string Name = contextMenuStrip1.SourceControl.Name; string[] str = Name.Split('_'); frmOrdersEdit frm = new frmOrdersEdit(); frm.StartPosition = FormStartPosition.CenterScreen; frm.TopMost = true; frm.Id = str[1]; if (frm.ShowDialog() == DialogResult.OK) { ((PictureBox)contextMenuStrip1.SourceControl).Image = Image.FromFile(Application.StartupPath + "\\res\\紅.gif"); } } private void btnRefesh_Click(object sender, EventArgs e) { } }} |
源碼下載：C#實現餐飲管理系統
以上就是本文的全部內容，希望對大家的學習有所幫助，也希望大家多多支持服務器之家。
