实例介绍
【实例简介】
用于火锅自助店管理系统，这个是实际火锅店使用的系统。已打包可以直接安装运行
收银员和管理员 密码均为：123
另外因为用的access数据库，所以请运行x86版本
【实例截
图】
【核心代码】
private void loadDB()
{
DBClass db = new DBClass();
DataTable desk = db.selectDB("select * from [desk] where startup=1");
int i = 0, x = 0, y = 0;
if (desk.DataSet != null && desk.Rows.Count > 0)
{
int [,] cz=new int[10,6];
for (i = 0; i < desk.Rows.Count; i )
{
btn = new Button(); //生成按钮
btn.Name = "btn" desk.Rows[i][1].ToString(); //设置按钮的ID
btn.Height = 104;
btn.Width = 108;
btn.Text = desk.Rows[i][1].ToString();
if (desk.Rows[i][3].ToString() == "0")
{
btn.Tag = "虚席以待";
btn.BackgroundImage = imageList1.Images[0];
}
else if (desk.Rows[i][3].ToString() == "1")
{
btn.Tag = "使用中";
btn.BackgroundImage = imageList1.Images[1];
}
else if (desk.Rows[i][3].ToString() == "2")
{
btn.Tag = "预定中";
btn.BackgroundImage = imageList1.Images[2];
}
else if (desk.Rows[i][3].ToString() == "3")
{
btn.Tag = "已停用";
btn.BackgroundImage = imageList1.Images[3];
}
else
{
btn.Tag = "超时";
btn.BackgroundImage = imageList1.Images[4];
}
btn.BackgroundImageLayout = ImageLayout.Stretch;
btn.Click = new System.EventHandler(this.btn_Click);
//btn.DoubleClick = new EventHandler(this.btn_DoubleClick);
btn.MouseDown = new System.Windows.Forms.MouseEventHandler(this.bt_MouseDown);
toolTip1.SetToolTip(btn, desk.Rows[i][2].ToString());
btn.TextAlign = ContentAlignment.TopCenter;
btn.Font = new System.Drawing.Font("宋体", 50F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
btn.ForeColor = System.Drawing.Color.Red;
btn.ContextMenuStrip = contextMenuStrip1;
if (i == 0)
{
btn.ForeColor = System.Drawing.Color.Blue;
label1.Text = btn.Text " 号桌 " btn.Tag;
leftbt = btn;
if (desk.Rows[i][3].ToString() == "1" || desk.Rows[i][3].ToString() == "4")
{
openInfo(btn.Text);
}
else
{
label3.Text = "编 号：";
label4.Text = "开始时间：";
label5.Text = "就餐用时：";
label6.Text = "锅 底：";
label7.Text = "消费金额：";
label8.Text = "超时金额：";
label9.Text = "已付金额：";
label10.Text = "未付金额：";
label11.Text = "成人：";
label12.Text = "免费：";
label13.Text = "半价：";
}
}
sunbtn[i] = btn;
for (x = 0; x < 10; x )
{
for (y = 0; y < 6; y )
{
if (cz[x, y] == 0)
{
btn.Location = new System.Drawing.Point(y * 114 10, x * 114 10);
cz[x, y] = 1;
goto xh;
}
}
}
xh:
this.panel1.Controls.Add(btn);
}
}
label14.Text = "";//时间基数
label15.Text = "";//免费
label16.Text = "";//半价
label17.Text = "";//成人
desk = db.selectDB("select * from [sort] where id in(3,4,5,10)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
for (int s = 0; s < desk.Rows.Count; s )
{
if (desk.Rows[s][1].ToString() == "超时")
{
label14.Tag = desk.Rows[s]["sort"].ToString();
}
else if (desk.Rows[s][1].ToString() == "免费")
{
label15.Tag = desk.Rows[s]["money"].ToString();
}
else if (desk.Rows[s][1].ToString() == "半价")
{
label16.Tag = desk.Rows[s]["money"].ToString();
}
else
{
label17.Tag = desk.Rows[s]["money"].ToString();
}
}
}
}
private void btn_Click(object sender, EventArgs e)
{
Button b1 = (Button)sender;//将触发此事件的对象转换为该Button对象
leftbt.ForeColor = System.Drawing.Color.Red;
leftbt = b1;
b1.ForeColor = System.Drawing.Color.Blue;
label1.Text = b1.Text " 号桌 " b1.Tag;
if (b1.Name == btname)
{
TimeSpan span = DateTime.Now - clickTime;
if (span.Milliseconds < SystemInformation.DoubleClickTime - 150)
{
btn_DoubleClick(sender, e);
}
}
btname = b1.Name;
clickTime = DateTime.Now;
if (b1.Tag.ToString() == "使用中" || btn.Tag.ToString() == "超时")
{
openInfo(b1.Text);
}
else
{
label3.Text = "编 号：";
label4.Text = "开始时间：";
label5.Text = "就餐用时：";
label6.Text = "锅 底：";
label7.Text = "消费金额：";
label8.Text = "超时金额：";
label9.Text = "已付金额：";
label10.Text = "未付金额：";
label11.Text = "成人：";
label12.Text = "免费：";
label13.Text = "半价：";
}
}
private void openInfo(string deskNo)
{
DataTable desk = db.selectDB("select a2.*,adult addadult-deladult as adult1,bairn addbairn-delbairn as bairn1,elder addelder-delelder as elder1 from [desk] as a1,[consumed] as a2 where a1.consumedNo=a2.consumedno and deskNO=" deskNo);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
for (int i = 0; i < desk.Rows.Count; i )
{
label3.Text = "编 号：" desk.Rows[i]["consumedno"].ToString();
label4.Text = "开始时间：" DateTime.Parse(desk.Rows[i]["startdate"].ToString()).ToString("HH:mm:ss");
label5.Text = "就餐用时：" desk.Rows[i]["depletedate"].ToString() "小时";
label7.Text = "消费金额：" desk.Rows[i]["consumedmoney"].ToString();
label8.Text = "超时金额：" desk.Rows[i]["overtime"].ToString();
label9.Text = "已付金额：" desk.Rows[i]["paymentmoney"].ToString();
label10.Text = "未付金额：" desk.Rows[i]["nonpaymentmoney"].ToString();
label11.Text = "成人：" desk.Rows[i]["adult1"].ToString();
label12.Text = "免费：" desk.Rows[i]["elder1"].ToString();
label13.Text = "半价：" desk.Rows[i]["bairn1"].ToString();
desk = db.selectDB("select * from [sort] where id=" desk.Rows[i]["boiler"].ToString());
if (desk.DataSet != null && desk.Rows.Count > 0)
{
label6.Text = "锅 底：" desk.Rows[0][1].ToString();//
}
}
}
}
private string status(Button IL)
{
string str = "";
if (IL.BackgroundImage == imageList1.Images[0])
{ str = "虚席以待"; }
else if (IL.BackgroundImage == imageList1.Images[1])
{ str = "使用中"; }
else if (IL.BackgroundImage == imageList1.Images[2])
{ str = "预留中"; }
else if (IL.BackgroundImage == imageList1.Images[3])
{ str = "停用中"; }
else if (IL.BackgroundImage == imageList1.Images[4])
{ str = "超时了"; }
return str;
}
private void Form2_FormClosing(object sender, FormClosingEventArgs e)
{
if (e.CloseReason == CloseReason.UserClosing)
{
DialogResult r = MessageBox.Show("确定要退出程序?", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (r == DialogResult.OK)
{
Application.Exit();
}
else
{
e.Cancel = true;
}
}
}
private void MDIMain_Load(object sender, EventArgs e)
{
this.toolStripStatusLabel1.Text = "欢迎使用慧创软件";
this.toolStripStatusLabel2.BorderSides = ToolStripStatusLabelBorderSides.Left;
this.toolStripStatusLabel2.Text = "用户名：" loginName;
this.toolStripStatusLabel2.BorderSides = ToolStripStatusLabelBorderSides.Right;
this.toolStripStatusLabel2.Spring = true;
this.toolStripStatusLabel3.Text = "系统当前时间：" DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
panel1.Height = 620;
panel1.Width = 710;
panel2.Height = 620;
panel2.Width = 310;
panel2.Location = new System.Drawing.Point(713,60);
label1.Height = 50;
label1.Width = 310;
label1.Location = new System.Drawing.Point(0, 0);
label2.Location = new System.Drawing.Point(0, 50);
label3.Location = new System.Drawing.Point(20, 100);//编号
label4.Location = new System.Drawing.Point(20, 140);//开始时间
label5.Location = new System.Drawing.Point(20, 180);//就餐用时
label6.Location = new System.Drawing.Point(20, 220);//锅底
groupBox1.Location = new System.Drawing.Point(20, 260);//人数
label11.Location = new System.Drawing.Point(5, 30);//成人
label12.Location = new System.Drawing.Point(5, 60);//免费
label13.Location = new System.Drawing.Point(5, 90);//小孩
label8.Location = new System.Drawing.Point(20, 410);//超时金额
label7.Location = new System.Drawing.Point(20, 450);//总金额
label9.Location = new System.Drawing.Point(20, 490);//已付款
label10.Location = new System.Drawing.Point(20, 530);//未付款
}
private void timer1_Tick(object sender, EventArgs e)
{
this.toolStripStatusLabel3.Text = "系统当前时间：" DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
this.label2.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
//开台
private void toolStripMenuItem7_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(0,2) and deskNO=" xzbt.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
start st = new start(xzbt.Text);
st.mdi = this;
st.ShowDialog();
xzbt.Tag = "使用中";
}
else
{
MessageBox.Show("当前桌子还在使用中！");
}
}
//换台
private void toolStripMenuItem8_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(1,4) and deskNO=" xzbt.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
exchange ex = new exchange(xzbt.Text);
ex.mdi = this;
ex.ShowDialog();
}
else
{
MessageBox.Show("当前桌子还没开台！");
}
}
//清台
private void toolStripMenuItem9_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(1,2,3,4) and deskNO=" xzbt.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
CleanDesk clean = new CleanDesk(xzbt.Text);
clean.mdi = this;
clean.ShowDialog();
xzbt.Tag = "虚席以待";
}
else
{
MessageBox.Show("当前桌子还没开台或预定或停用！");
}
}
//打印
private void toolStripMenuItem10_Click(object sender, EventArgs e)
{
}
//加人
private void toolStripMenuItem11_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(1,4) and deskNO=" xzbt.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
AddMan man = new AddMan(xzbt.Text);
man.mdi = this;
man.ShowDialog();
}
else
{
MessageBox.Show("当前桌子还没开台，请先开台！");
}
}
//预留
private void toolStripMenuItem12_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status=0 and deskNO=" xzbt.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
db.EditDB("update [desk] set status=2 where deskNO=" xzbt.Text);
xzbt.BackgroundImage = imageList1.Images[2];
xzbt.Tag = "预留中";
}
else
{
MessageBox.Show("当前桌子正在使用或者预定中，请先清台！");
}
}
//停用
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status=0 and deskNO=" xzbt.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
db.EditDB("update [desk] set status=3 where deskNO=" xzbt.Text);
xzbt.BackgroundImage = imageList1.Images[3];
xzbt.Tag = "停用中";
}
else
{
MessageBox.Show("当前桌子正在使用或者预定中，请先清台！");
}
}
private void bt_MouseDown(object sender, MouseEventArgs e)
{
if (e.Button != MouseButtons.Left)
{
Button b1 = (Button)sender;
xzbt = b1;
}
}
//退出
private void toolStripButton5_Click(object sender, EventArgs e)
{
DialogResult r = MessageBox.Show("确定要退出程序?", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (r == DialogResult.OK)
{
Application.Exit();
}
}
//双击
private void btn_DoubleClick(object sender, EventArgs e)
{
Button b1 = (Button)sender;//将触发此事件的对象转换为该Button对象
desk = db.selectDB("select * from [desk] where startup=1 and status in(0,2) and deskNO=" b1.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
start st = new start(b1.Text);
st.mdi = this;
st.ShowDialog();
b1.Tag = "使用中";
label1.Text = b1.Text " 号桌 使用中";
if (deskNo != "")
openInfo(deskNo);
}
else
MessageBox.Show("当前桌正在使用不能开台，请先清台！");
}
//开台
private void toolStripButton1_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(0,2)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
start st = new start("");
st.mdi = this;
st.ShowDialog();
}
else
MessageBox.Show("目前没有空余的桌子！");
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [user] where type=0 and userName='" loginName "'");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
setup set = new setup();
set.ShowDialog();
}
else
MessageBox.Show("对不起，管理员才有此权限！");
}
private void toolStripButton8_Click(object sender, EventArgs e)
{
PWD pwd = new PWD(loginName);
pwd.ShowDialog();
}
//换台
private void toolStripButton2_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(1,4)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(0,2)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
exchange ex = new exchange("");
ex.mdi = this;
ex.ShowDialog();
}
else
MessageBox.Show("目前没有空余的桌子可换！");
}
else
{
MessageBox.Show("目前前还没开台！");
}
}
//清台
private void toolStripButton3_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(2,1,4,3)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
CleanDesk clean = new CleanDesk("");
clean.mdi = this;
clean.ShowDialog();
}
else
MessageBox.Show("目前没有开台的桌子！");
}
//加人
private void toolStripButton6_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(1,4)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
AddMan man = new AddMan("");
man.mdi = this;
man.ShowDialog();
if (deskNo != "")
openInfo(deskNo);
}
else
MessageBox.Show("目前没有开台的桌子！");
}
private void toolStripButton9_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [user] where type=0 and userName='" loginName "'");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
search se = new search();
se.ShowDialog();
}
else
MessageBox.Show("对不起，管理员才有此权限！");
}
//计算超时金额
private void timer2_Tick(object sender, EventArgs e)
{
DateTime dtone ;
TimeSpan span ;
string timeMoney="";
int cr = 0;
int et = 0;
int lr = 0;
desk = db.selectDB("select a2.*,adult addadult-deladult as adult1,bairn addbairn-delbairn as bairn1,elder addelder-delelder as elder1 from [desk] as a1,[consumed] as a2 where a1.consumedNo=a2.consumedno and a1.startup=1 and a1.status in(1,4)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
for (int i = 0; i < desk.Rows.Count;i )
{
dtone = Convert.ToDateTime(desk.Rows[i]["startdate"].ToString());
span = DateTime.Now.Subtract(dtone);
//timeMoney= ((Math.Ceiling(span.TotalHours / double.Parse(label14.Tag.ToString())) - 1) * int.Parse(label15.Tag.ToString())).ToString();
cr= int.Parse(label17.Tag.ToString())*int.Parse(desk.Rows[i]["adult1"].ToString());
et= int.Parse(label16.Tag.ToString())*int.Parse(desk.Rows[i]["bairn1"].ToString());
lr= int.Parse(label15.Tag.ToString())*int.Parse(desk.Rows[i]["elder1"].ToString());
timeMoney = ((Math.Ceiling(span.TotalHours / double.Parse(label14.Tag.ToString())) - 1) * (et cr lr)).ToString();
db.EditDB("update [consumed] set depletedate=" span.TotalHours.ToString("0.00") ",overtime=" timeMoney " where consumedno=" desk.Rows[i]["consumedno"].ToString());//, nonpaymentmoney=nonpaymentmoney " timeMoney "
if (int.Parse(timeMoney) > 0)
db.EditDB("update [desk] set status=4 deskNO=" desk.Rows[i]["desk"].ToString());
}
}
}
//打印
private void toolStripButton7_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(1,4)");
if (desk.DataSet != null && desk.Rows.Count > 0)
{
delMan man = new delMan("");
man.mdi = this;
man.ShowDialog();
if (deskNo != "")
openInfo(deskNo);
}
else
MessageBox.Show("目前没有开台的桌子！");
}
private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e)
{
Point pt = new Point(0, 0);
}
//减人
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
desk = db.selectDB("select * from [desk] where startup=1 and status in(1,4) and deskNO=" xzbt.Text);
if (desk.DataSet != null && desk.Rows.Count > 0)
{
delMan man = new delMan(xzbt.Text);
man.mdi = this;
man.ShowDialog();
}
else
{
MessageBox.Show("当前桌子还没开台，请先开台！");
}
}
网友评论
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)