systemset_form.cs

饮食管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using BusinessLayer;
using Entity;

namespace project_beat
{
    public partial class SystemSet_Form : Form
    {
        private BLL_RoomType bll_roomtype = new BLL_RoomType();
        RoomType r = new RoomType();
        BLL_State bll_state = new BLL_State();
        BLL_tableState bll_tablestate = new BLL_tableState();
        tableState tablestate = new tableState();
        Bll_WaiterLevel bll_waiterlevel = new Bll_WaiterLevel();
        BLL_waiter bll_waiter = new BLL_waiter();
        Waiter waiter = new Waiter();
        WaiterLevel wl = new WaiterLevel();
        Bll_OpTable bll_optabel = new Bll_OpTable();
        OpTable op = new OpTable();
        Bll_SjTable bll_sj = new Bll_SjTable();


        public SystemSet_Form()
        {
            InitializeComponent();
        }

        private void panel1_Paint(object sender, PaintEventArgs e)
        {

        }

        private void tabPage5_Click(object sender, EventArgs e)
        {

        }

        private void tabPage3_Click(object sender, EventArgs e)
        {
          
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void button10_Click(object sender, EventArgs e)
        {

        }

        private void SystemSet_Form_Load(object sender, EventArgs e)
        {
            InsertLsvTop();
            InsertLsvBot();
            
        }
        public void InsertLsvWaiterLevel()
        {
            this.lsvWaiterLevel.Items.Clear();
            DataTable dt = bll_waiterlevel.SelectWaiterLevel();
            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());
                if (i % 2 == 1)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                this.lsvWaiterLevel.Items.Add(lv);
             }
        }
        public void InsertLsvBot()
        {
            this.lsvBot.Items.Clear();
            DataTable dt = bll_tablestate.SelectTableStateAndWaiter();
            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());
        
                if (i % 2 == 1)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                lsvBot.Items.Add(lv);
            }

        }
        public void InsertCbo()
        {
            this.cboRoomType.Items.Clear();
            this.cboRoomType.Items.Add("所有房间类型");
            DataTable dt = bll_roomtype.SelectRoomTypeAll();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                
                this.cboRoomType.Items.Add( dt.Rows[i][1].ToString());
                
            }
            this.cboRoomType.SelectedIndex = 0;
            
        }

        public void InsertLsvTop()
        {
            DataTable dt = bll_roomtype.SelectRoomTypeAll();
            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;
                lsvTop.Items.Add(lv);
            }
            InsertCbo();
        }

        private void btnInsertRoom_Click(object sender, EventArgs e)
        {
            InsertRoomType_Form f = new InsertRoomType_Form();
            f.ShowDialog();
            lsvTop.Items.Clear();
            InsertLsvTop();
        }

        private void btnUpdateRoom_Click(object sender, EventArgs e)
        {
            if (lsvTop.SelectedItems.Count != 0)
            {
                r.RoomId = int.Parse(this.lsvTop.SelectedItems[0].SubItems[0].Text);
                r.roomType = this.lsvTop.SelectedItems[0].SubItems[1].Text;
                r.LowCousume = float.Parse(this.lsvTop.SelectedItems[0].SubItems[2].Text);
                r.RoomReamrk = this.lsvTop.SelectedItems[0].SubItems[3].Text;
                r.RoomRs = int .Parse(this.lsvTop.SelectedItems[0].SubItems[4].Text) ;
                InsertRoomType_Form f = new InsertRoomType_Form(r);
                f.ShowDialog();
                lsvTop.Items.Clear();
                InsertLsvTop();
             
            }
            else
                MessageBox.Show("请选择要修改的房间类型!","提示信息");
        }

        private void btnDeleteRoom_Click(object sender, EventArgs e)
        {
             if (lsvTop.SelectedItems.Count != 0)
            {
                DialogResult d = MessageBox.Show("删除此房间类型将连同属于此房间类型的餐台全部删除!真的要删除?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
                if (d == DialogResult.Yes)
                {
                    r.RoomId =int.Parse( lsvTop.SelectedItems[0].SubItems[0].Text);
                    int i = bll_roomtype.DeleteRoomTypeById(r);
                    if (i > 0)
                    {
                        
                        lsvTop.Items.Clear();
                        InsertLsvTop();
                       
                    }
                    else
                        MessageBox.Show("删除失败!", "提示信息");
                }
                

             }
            else
                MessageBox.Show("请选择要删除的房间类型!", "提示信息");
        }

        private void cboRoomType_SelectedValueChanged(object sender, EventArgs e)
        {
            if (this.cboRoomType.SelectedIndex == 0)
            {
                InsertLsvBot();
            }
            else
            {
                r.RoomId = this.cboRoomType.SelectedIndex;
                InsertLsvBotByRoomID(r);
            }
            
        }
        public void InsertLsvBotByRoomID(RoomType r)
        {
            lsvBot.Items.Clear();
            DataTable dt = bll_tablestate.SelectTableStateAndWaiterByRoomID(r);
            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());

                if (i % 2 == 1)
                    lv.BackColor = Color.LightCyan;
                else
                    lv.BackColor = Color.WhiteSmoke;
                lsvBot.Items.Add(lv);
            }

        }

        private void btnDgInsert_Click(object sender, EventArgs e)
        {
            TableStateSet_Form f = new TableStateSet_Form();
            f.ShowDialog();
            InsertLsvBot();
        }

        private void btnUpdateCt_Click(object sender, EventArgs e)
        {
          
            if (lsvBot.SelectedItems.Count != 0)
            {
                if (lsvBot.SelectedItems[0].SubItems[1].Text != "占用")
                {
                    tablestate.ID = lsvBot.SelectedItems[0].SubItems[0].Text;
                    string wainame = lsvBot.SelectedItems[0].SubItems[3].Text;
                    DataTable dt = bll_tablestate.SelectTableStateByTableID(tablestate);
                    tablestate.RoomID = int.Parse(dt.Rows[0][0].ToString());
                    tablestate.WaiterID = int.Parse(dt.Rows[0][1].ToString());
                    TableStateSet_Form f = new TableStateSet_Form(tablestate, wainame);
                    f.ShowDialog();
                }
                else
                    MessageBox.Show("此餐台正在使用,不能执行此操作!","提示信息");
            }
            else
                MessageBox.Show("请选择你要修改的餐台","提示信息");
        }

        private void btnDelCt_Click(object sender, EventArgs e)
        {
            if (lsvBot.SelectedItems.Count != 0)
            {
                if (lsvBot.SelectedItems[0].SubItems[1].Text != "占用")
                {
                    tablestate.ID = lsvBot.SelectedItems[0].SubItems[0].Text;
                    int i = bll_tablestate.DeleteTableStateByTableID(tablestate);
                    if (i <= 0)
                        MessageBox.Show(" 删除失败", "提示信息");

                    else