在好例子网,分享、交流、成长!
您当前所在位置:首页C# 开发实例C#语言基础 → C# 火锅自助店管理系统源码下载(含access数据库以及安装包)

C# 火锅自助店管理系统源码下载(含access数据库以及安装包)

C#语言基础

下载此实例
  • 开发语言:C#
  • 实例大小:3.99M
  • 下载次数:18
  • 浏览次数:180
  • 发布时间:2018-02-12
  • 实例类别:C#语言基础
  • 发 布 人:TT的天
  • 所需积分:4
 相关标签: 系统 管理 管理系统

实例介绍

【实例简介】

用于火锅自助店管理系统,这个是实际火锅店使用的系统。已打包可以直接安装运行

收银员和管理员 密码均为: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("当前桌子还没开台,请先开台!");
            }
        }

 

实例下载地址

C# 火锅自助店管理系统源码下载(含access数据库以及安装包)

不能下载?内容有错? 点击这里报错 + 投诉 + 提问

好例子网口号:伸出你的我的手 — 分享

网友评论

发表评论

(您的评论需要经过审核才能显示)

查看所有0条评论>>

小贴士

感谢您为本站写下的评论,您的评论对其它用户来说具有重要的参考价值,所以请认真填写。

  • 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  • 相信您也不想看到一排文字/表情墙,所以请不要反馈意义不大的重复字符,也请尽量不要纯表情的回复。
  • 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  • 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
;
报警
var cnzz_protocol = (("https:" == document.location.protocol) ? " https://" : " http://");document.write(unescape("%3Cspan id='cnzz_stat_icon_4847253'%3E%3C/span%3E%3Cscript src='" + cnzz_protocol + "s13.cnzz.com/stat.php%3Fid%3D4847253' type='text/javascript'%3E%3C/script%3E"));