C#餐厅管理系统3--MAIN窗口

C#餐厅管理系统6--呼叫管理员！         地址：点击打开链接

C#餐厅管理系统5--餐桌和职员            地址：点击打开链接

C#餐厅管理系统4--增删改查！            地址：点击打开链接

C#餐厅管理系统3--MAIN窗口              地址：点击打开链接

C#餐厅管理系统2--数据连接及登录     地址：点击打开链接

C#餐厅管理系统1--ER图                      地址：点击打开链接

 

源码下载地址：点击打开下载地址

 

这小节我们主要来写MAIN窗口。

可以看到。MAIN窗口主要由menuStrip、ListView（imageList）、statusStrip构成。其实还有contextMenuStrip，这是一个右键菜单。

右键菜单图：

其中的menuStrip对应着第1节的ER图可以写出。中间的ListView控件我们命名为LVDesk，其中包含了一个ImageList，imageList就是上图中的图片，可以用来显示当前桌位的状态。（图上显示有2张图片，其实有3张图片噢，后面我会告诉大家）

在ListView属性中：LargeImageList就放入imagelist，把MultiSelect设为False（不允许多选）。

main窗口代码如下：

 public partial class Main : Form
    {
        public Main()
        {
            InitializeComponent();
        }
        public SqlDataReader sdr;
        public string power;        //用户权限
        public string username;     //用户名
        public string time;         //用户登录时间

        private void Main_Load(object sender, EventArgs e)
        {
            switch (power)
            {
                case "0": sslblPower.Text = "超级管理员"; break;
                case "1": sslblPower.Text = "管理员"; break;
                case "2": sslblPower.Text = "职员"; break;
            }
            sslblUsername.Text = username;
            sslblTime.Text = time;
            //权限控制未设置
        }

        private void AddItem(string zt,string cl) 
        //桌台添加状态
        {
            if (zt == "使用")
            {
                int callnum = Convert.ToInt16(cl);
                if (callnum > 0)
                {
                    lvDesk.Items.Add(sdr["roomName"].ToString(), 2);
                }
                else
                {
                    lvDesk.Items.Add(sdr["roomName"].ToString(), 1);
                }
            }
            else
            {
                lvDesk.Items.Add(sdr["roomName"].ToString(), 0);
            }
        }

        private void Main_Activated(object sender, EventArgs e)
        {
            lvDesk.Items.Clear();
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from tb_Room",conn);
            sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                string zt = sdr["roomZT"].ToString().Trim(); //搜索桌台
                string call = sdr["Call"].ToString().Trim(); //呼叫
                AddItem(zt,call);
            }
            conn.Close();
        }

        private void 退出ToolStripMenuItem1_Click(object sender, EventArgs e)
        {
            if (DialogResult.OK == MessageBox.Show("确定退出本系统吗？", "提示", MessageBoxButtons.OKCancel,MessageBoxIcon.Exclamation))
            {
                Application.Exit();
            }
        }

        private void 记事本ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            System.Diagnostics.Process.Start("notepad.exe");
        }

        private void 计算器ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            System.Diagnostics.Process.Start("calc.exe");
        }

        private void 开台ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lvDesk.SelectedItems.Count != 0)
            {
                string name = lvDesk.SelectedItems[0].SubItems[0].Text;
                Open openroom = new Open();
                openroom.name = name;
                openroom.ShowDialog();
            }
            else
            {
                MessageBox.Show("请选择桌台","提示");
            }
        }

        private void lvDesk_Click(object sender, EventArgs e)
        {
            string roomName = lvDesk.SelectedItems[0].SubItems[0].Text;
            SqlConnection conn = BaseClass.DBConn.SaylnConn();
            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from tb_Room where roomName='"+ roomName +"'",conn);
            SqlDataReader sdr = cmd.ExecuteReader();
            sdr.Read();
            string zhuangtai = sdr["roomZT"].ToString().Trim(); //桌台状态
            sdr.Close();
            if ("使用" == zhuangtai)
            {
                this.contextMenuStrip1.Items[0].Enabled = false;
                this.contextMenuStrip1.Items[1].Enabled = true;
                this.contextMenuStrip1.Items[3].Enabled = true;
                this.contextMenuStrip1.Items[5].Enabled = true;
                this.contextMenuStrip1.Items[6].Enabled = true;
            }
            if ("待用" == zhuangtai)
            {
                this.contextMenuStrip1.Items[0].Enabled = true;
                this.contextMenuStrip1.Items[1].Enabled = false;
                this.contextMenuStrip1.Items[3].Enabled = false;
                this.contextMenuStrip1.Items[5].Enabled = false;
                this.contextMenuStrip1.Items[6].Enabled = false;
            }
            conn.Close();
        }

        private void 取消开台ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lvDesk.SelectedItems.Count != 0)
            {
                string roomName = lvDesk.SelectedItems[0].SubItems[0].Text;
                SqlConnection conn = BaseClass.DBConn.SaylnConn();
                conn.Open();
                SqlCommand cmd = new SqlCommand("update tb_Room set roomZT='待用',GuestName='',GuestNum='',waiterName='',zhangdanDate='' where roomName='" + roomName + "'", conn);
                cmd.ExecuteNonQuery();
                //暂缺去掉GuestFood
                conn.Close();
                Main_Activated(sender, e);
            }
            else
            {
                MessageBox.Show("请选择桌台","提示");
            }
        }

        private void 点加菜ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lvDesk.SelectedItems.Count != 0)
            {
                DianCai dc = new DianCai();
                dc.roomName = lvDesk.SelectedItems[0].SubItems[0].Text;
                dc.ShowDialog();
            }
            else
            {
                MessageBox.Show("请选择桌台", "提示");
            }
        }

        private void 消费查询ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lvDesk.SelectedItems.Count != 0)
            {
                Xfcx xfcx = new Xfcx();
                xfcx.tablenum = lvDesk.SelectedItems[0].SubItems[0].Text;
                xfcx.ShowDialog();
            }
            else
            {
                MessageBox.Show("请选择桌台", "提示");
            }
        }

        private void 结账ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lvDesk.SelectedItems.Count != 0)
            {
                JieZhang jz = new JieZhang();
                jz.roomname = lvDesk.SelectedItems[0].SubItems[0].Text;
                jz.ShowDialog();
            }
            else
            {
                MessageBox.Show("请选择桌台", "提示");
            }
        }

        private void 职员信息ToolStripMenuItem_Click_1(object sender, EventArgs e)
        {
            Waiter waiter = new Waiter();
            waiter.ShowDialog();
        }

        private void 桌台信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Desk desk = new Desk();
            desk.ShowDialog();
        }

        private void 用户管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            User user = new User();
            user.ShowDialog();
        }

        private void 刷新桌台ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Main_Activated(sender, e);
        }

        private void 取消呼叫ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (lvDesk.SelectedItems.Count != 0)
            {
                SqlConnection co = BaseClass.DBConn.SaylnConn();
                co.Open();
                SqlCommand cm = new SqlCommand("update tb_Room set Call='0' where roomName='" + lvDesk.SelectedItems[0].SubItems[0].Text + "'", co);
                cm.ExecuteNonQuery();
                co.Close();
                
            }
            else
            {
                MessageBox.Show("请选择桌台", "提示");
            }
            Main_Activated(sender, e);
        }

             


    }

细心地朋友会发现多了一个呼叫功能，这里就对应着imagelist里的第三张图片。

 

源码下载地址：点击打开下载地址