systemset_form.cs

饮食管理系统

                    {
                        MessageBox.Show(" 删除成功", "提示信息");
                        r.RoomId = this.cboRoomType.SelectedIndex;
                        InsertLsvBotByRoomID(r);
                    }
                }
                else
                    MessageBox.Show("此餐台正在使用,不能执行此操作!", "提示信息");
            }
            else
                MessageBox.Show("请选择你要删除的餐台", "提示信息");
        }

        private void tabPage3_Enter(object sender, EventArgs e)
        {
            InsertLsvWaiterLevel();
            InsertCboWaiterlevel();
            InsertlistviewWaiter();
        }
        private void InsertCboWaiterlevel()
        {
            this.cboWaiterlevel.Items.Clear();
            this.cboWaiterlevel.Items.Add("所有服务生");
            DataTable dt = bll_waiterlevel.SelectWaiterLevel();
            for (int i = 0; i < dt.Rows.Count; i++)
            {

                this.cboWaiterlevel.Items.Add(dt.Rows[i][1].ToString());

            }
            this.cboWaiterlevel.SelectedIndex = 0;
        }

        private void InsertlistviewWaiter()
        {
            this.listviewWaiter.Items.Clear();
            DataTable dt = bll_waiter.SelectWaiter();
            for (int i=0; i < dt.Rows.Count; i++)
            {
                ListViewItem lv = new ListViewItem();
                lv.SubItems[0].Text = dt.Rows[i][0].ToString();
                lv.SubItems.Add(dt.Rows[i][1].ToString());
                lv.SubItems.Add(dt.Rows[i][2].ToString().Trim());
                lv.SubItems.Add(dt.Rows[i][3].ToString().Trim());
                lv.SubItems.Add(dt.Rows[i][4].ToString());
                lv.SubItems.Add(dt.Rows[i][5].ToString());
                lv.SubItems.Add(dt.Rows[i][6].ToString());
                lv.SubItems.Add(dt.Rows[i][7].ToString());
                if (i % 2 == 1)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                this.listviewWaiter.Items.Add(lv);

            }
        
        }

        private void cboWaiterlevel_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cboWaiterlevel.SelectedIndex == 0)
            {
                InsertlistviewWaiter();
            }
            else
            {
                InsertlistviewWaiterByLevel();
            }
        }

        private void InsertlistviewWaiterByLevel()
        {
            this.listviewWaiter.Items.Clear();
            waiter.Dj=this.cboWaiterlevel.SelectedIndex;
            DataTable dt = bll_waiter.SelectWaiterByLevel(waiter);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lv = new ListViewItem();
                lv.SubItems[0].Text = dt.Rows[i][0].ToString();
                lv.SubItems.Add(dt.Rows[i][1].ToString());
                lv.SubItems.Add(dt.Rows[i][2].ToString().Trim());
                lv.SubItems.Add(dt.Rows[i][3].ToString().Trim());
                lv.SubItems.Add(dt.Rows[i][4].ToString());
                lv.SubItems.Add(dt.Rows[i][5].ToString());
                lv.SubItems.Add(dt.Rows[i][6].ToString());
                lv.SubItems.Add(dt.Rows[i][7].ToString());
                if (i % 2 == 1)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                this.listviewWaiter.Items.Add(lv);

            }

        }

        private void btnDjinsert_Click(object sender, EventArgs e)
        {
            InsertWaiterLevel_Form f = new InsertWaiterLevel_Form();
            f.ShowDialog();
            InsertLsvWaiterLevel();
            InsertCboWaiterlevel();
        }

        private void btnDjUpdate_Click(object sender, EventArgs e)
        {
           if(lsvWaiterLevel.SelectedItems.Count !=0)
           {
               wl.ID = int.Parse(lsvWaiterLevel.SelectedItems[0].SubItems[0].Text.ToString());
               wl.Dj = lsvWaiterLevel.SelectedItems[0].SubItems[1].Text.ToString();
            InsertWaiterLevel_Form f = new InsertWaiterLevel_Form(wl);
            f.ShowDialog();
            InsertLsvWaiterLevel();
            InsertCboWaiterlevel();
           }
           else
               MessageBox.Show("请选择要修改的服务生等级!","提示信息");
        }

        private void btnDjDelete_Click(object sender, EventArgs e)
        {
            if (lsvWaiterLevel.SelectedItems.Count != 0)
            {
                wl.ID = int.Parse(lsvWaiterLevel.SelectedItems[0].SubItems[0].Text.ToString());
                int i = bll_waiterlevel.DeleteWaiterLevelByid(wl);
                if (i < 1)
                    MessageBox.Show("删除失败!", "提示信息");
                else
                {
                    InsertLsvWaiterLevel();
                    InsertCboWaiterlevel();
                }

            }
            else
                MessageBox.Show("请选择要删除的服务生等级!", "提示信息");
        }

        private void btnWaiterInsert_Click(object sender, EventArgs e)
        {
            InsertWaiter_Form f = new InsertWaiter_Form();
            f.ShowDialog();
            InsertlistviewWaiter();
        }

        private void btnWaiterUpdate_Click(object sender, EventArgs e)
        {
            if (listviewWaiter.SelectedItems.Count != 0)
            {
                UpdateWaiter();
            }
            else
                MessageBox.Show("请选择要修改的服务生!","提示信息");
        }
        private void UpdateWaiter()
        { 
            waiter.ID=int.Parse(listviewWaiter.SelectedItems[0].SubItems[0].Text.ToString());
            waiter=bll_waiter.SelectWaiterByID(waiter);
            InsertWaiter_Form f = new InsertWaiter_Form(waiter);
            f.ShowDialog();
            InsertlistviewWaiter();

        }

        private void btnWaiterDelete_Click(object sender, EventArgs e)
        {
            waiter.ID = int.Parse(listviewWaiter.SelectedItems[0].SubItems[0].Text.ToString());
           
     bll_waiter.DeleteWaiterByID(waiter);
     InsertlistviewWaiter();
 }

        private void tabControl1_Enter(object sender, EventArgs e)
        {
            InsertListViewOp();
        }
        private void InsertListViewOp()
        {
            this.listViewOp.Items.Clear();
            DataTable dt = bll_optabel.SelectOpTabelAll();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lv = new ListViewItem();
                lv.SubItems[0].Text = dt.Rows[i][0].ToString();
                lv.SubItems.Add(dt.Rows[i][1].ToString());
                lv.SubItems.Add(dt.Rows[i][2].ToString()); 
                lv.SubItems.Add(dt.Rows[i][3].ToString());
                lv.SubItems.Add(dt.Rows[i][4].ToString());
                if (i % 2 == 1)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                listViewOp.Items.Add(lv);
            }
            
        }

        private void btnCZYInsert_Click(object sender, EventArgs e)
        {
            InsertOp_Form f = new InsertOp_Form();
            f.ShowDialog();
            InsertListViewOp();
        }

        private void btnCZYUpdate_Click(object sender, EventArgs e)
        {
            if (listViewOp.SelectedItems.Count != 0)
            {
                UpdateOp();
            }
            else
                MessageBox.Show("请选择要修改的操作员!", "信息提示");
        }

        private void UpdateOp()
        {
            op.OpId = listViewOp.SelectedItems[0].SubItems[0].Text.ToString();
            op.OpName = listViewOp.SelectedItems[0].SubItems[1].Text.ToString();
            op.State = listViewOp.SelectedItems[0].SubItems[2].Text.ToString();
            op.MaxMoney =int.Parse( listViewOp.SelectedItems[0].SubItems[3].Text.ToString());
            op.OpPwd = listViewOp.SelectedItems[0].SubItems[4].Text.ToString();
            InsertOp_Form f = new InsertOp_Form(op);
            f.ShowDialog();
            InsertListViewOp();
        }

        private void btnCZYDelete_Click(object sender, EventArgs e)
        {

            if (listViewOp.SelectedItems.Count != 0)
            {
                op.OpId = listViewOp.SelectedItems[0].SubItems[0].Text.ToString();
                int i = bll_optabel.DeleteOpTableById(op);
                if (i > 0)
                {
                    InsertListViewOp();
                }
                else
                    MessageBox.Show("删除失败!", "提示信息"); ;
            }
            else
                MessageBox.Show("请选择要修改的操作员!", "信息提示");
        }

        private void tabPage9_Enter(object sender, EventArgs e)
        {
            InsertListViewTime();
        }
        private void InsertListViewTime()
        {

            this.listViewTime.Items.Clear();
            DataTable dt = bll_sj.SelectSjTableAll();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ListViewItem lv = new ListViewItem();
                lv.SubItems[0].Text = dt.Rows[i][0].ToString();
                lv.SubItems.Add(dt.Rows[i][1].ToString());
                lv.SubItems.Add(dt.Rows[i][2].ToString());
                if (i % 2 == 1)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                listViewTime.Items.Add(lv);
            }
        }
    }
}