本文实例为大家分享了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#实现餐饮管理系统
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。
dy("nrwz");