C#实现餐饮管理系统
本文实例为大家分享了C#实现餐饮管理系统的具体代码,供大家参考,具体内容如下
此系统采用C#语言的Winfrom和ADO.NET技术搭建的简单的CS系统。
部分代码:
frmBook.cs
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
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#实现餐饮管理系统
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持海外IDC网。