【實例簡介】

用于火鍋自助店管理系統，這個是實際火鍋店使用的系統。已打包可以直接安裝運行

收銀員和管理員 密碼均為：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("當前桌子還沒開臺，請先開臺！");
            }
        }