tablestateset_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 TableStateSet_Form : Form
    {
        BLL_waiter Bll_waiter = new BLL_waiter();
        Waiter waiter = new Waiter();
        BLL_RoomType bll_roomtype = new BLL_RoomType();
        tableState table = new tableState();
        BLL_tableState bll_tablestate = new BLL_tableState();

        public TableStateSet_Form()
        {
            InitializeComponent();
            InsertCbo();
        }

        public TableStateSet_Form(tableState t,string waitername)
        {
            InitializeComponent();
            InsertCbo();
            this.Text = "修改餐台";
            this.cboRoomType.SelectedIndex = t.RoomID - 1;
            this.txtTableID.Text = t.ID;
            this.txtWaitName.Text = waitername;

        }

        private void button1_Click(object sender, EventArgs e)
        {
           
            this.panel1.Visible = true;
            DataTable dt = Bll_waiter.SelectWaiter();
            InsertListView(dt, this.listView1);
        }

        private void btnPCanfirm_Click(object sender, EventArgs e)
        {
            this.txtWaitName.Text = this.listView1.SelectedItems[0].SubItems[1].Text.ToString();
            waiter.ID = int.Parse(this.listView1.SelectedItems[0].SubItems[0].Text);
            waiter.Name = this.listView1.SelectedItems[0].SubItems[1].Text;
            this.panel1.Visible = false;
        }
        private void InsertListView(DataTable dt, System.Windows.Forms.ListView ls)
        {
            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());
                ls.Items.Add(lv);
            }
        }

        private void btnPCancel_Click(object sender, EventArgs e)
        {
            this.panel1.Visible = false;
        }

        private void TableStateSet_Form_Load(object sender, EventArgs e)
        {
           
        }
        public void InsertCbo()
        {
            this.cboRoomType.Items.Clear();

            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;

        }

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

        private void btnOK_Click(object sender, EventArgs e)
        {
           
            table.ID = txtTableID.Text;
            table.RoomID = this.cboRoomType.SelectedIndex+1;
            table.State = 0;
            table.WaiterID = waiter.ID;
            DataTable dt = bll_tablestate.SelectTableStateByTableID(table);
            int t = dt.Rows.Count;
            if (t == 0)
            {
                int i = bll_tablestate.InsertTableState(table);
                if (i <= 0)
                    MessageBox.Show(" 添加失败", "提示信息");

                else
                {
                    MessageBox.Show(" 添加成功", "提示信息");
                    this.Close();
                }

            }
            else
            {
                int i = bll_tablestate.UpdateTableStateByTableID(table);
                if (i <= 0)
                    MessageBox.Show(" 修改失败", "提示信息");
                else
                {
                    MessageBox.Show(" 修改成功", "提示信息");
                    this.Close();
                }
            }
        }
    }
}