frm单台预定.cs

c#can yin guan li xi tong

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

namespace 餐饮管理系统
{
    public partial class frm单台预定 : Form
    {
        public frm单台预定()
        {
            InitializeComponent();
        }
        //用他判定是否是处于编辑状态
        private bool m_bIsExit;

        public bool bIsExit
        {
            get { return m_bIsExit; }
            set { m_bIsExit = value; }
        }

        //全局变量，获取编号
        string m_strCurrBookNO = "";
        public string strCurrBookNO
        {
            get { return m_strCurrBookNO; }
            set { m_strCurrBookNO = value; }
        }
        
        private void buttonOK_Click(object sender, EventArgs e)
        {
            //接收界面数据
            string strBookNo = tbBookNO.Text.Trim();
            string strVIPName = tbVIPName.Text.Trim();
            string strMoveTeleNum = tbMoveTeleNum.Text.Trim();
            string strPhoneNum = tbPhoneNum.Text.Trim();
            string strBookSize = comboBoxBookSize.Text.Trim();
            string strTableNO = comboBoxTableID.Text.Trim();
            string strBookHour = comboBoxBookMin.Text.Trim();
            string strBookMin = comboBoxBookMin.Text.Trim();
            string strArrHour = comboBoxArrvHour.Text.Trim();
            string strArrMin = comboBoxArrMin.Text.Trim();
            string str留言 = textBox客户留言.Text.Trim();
            float f押金 = 0.0f;
            {
                try
                {
                    f押金 = float.Parse(textBox预抵压金.Text.Trim());
                }
                catch {}
            }
            string strBookTSpend = comboBoxTimeSpamd.Text.Trim();
            DateTime dtBookTime = dateTimePicker1.Value.Date;
            DateTime dtArrTime = dateTimePicker2.Value.Date;
            bool bIsAutoCancle = checkBox1.Checked;

            if (tbVIPName.Text.Trim() == "")
            {
                Utility.SetErr(tbVIPName, "名称不能为空！");
                return;
            }
            if (tbPhoneNum.Text.Trim() == "")
            {
                Utility.SetErr(tbPhoneNum, "固定电话不能为空！");
                return;
            }
            string strSql = "";
            if (bIsExit)
            {
                strSql = string.Format("update dt_BookRoomInfo set 预定编号='{0}',姓名='{1}',"+
                    "固定电话='{2}',移动电话='{3}',预定时间='{4}',房间类型='{5}',餐台名='{6}',"+
                    "客户留言='{7}',押金='{8}',自动取消='{9}' where 预定编号='{10}'", strBookNo, strVIPName, strPhoneNum, strMoveTeleNum, strBookTSpend, strBookSize, strTableNO,
                    str留言, f押金, bIsAutoCancle ? 1 : 0,strBookNo);
            }
            else
            {
                strSql = string.Format("insert into dt_BookRoomInfo(预定编号,姓名,固定电话,移动电话,预定时间," +
                    "房间类型,餐台名,客户留言,押金,自动取消)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},{9})",
                    strBookNo, strVIPName, strPhoneNum, strMoveTeleNum, strBookTSpend, strBookSize, strTableNO,
                    str留言, f押金, bIsAutoCancle ? 1 : 0);
            }
            if (DBserver.setCommNornQuey(strSql) > 0)
            {
                MessageBox.Show("操作成功！");
            }
            this.DialogResult = DialogResult.OK;
            this.Close();
        }

        private void frm单台预定_Load(object sender, EventArgs e)
        {
            //如果是编辑状态。。。。。。。
            if (bIsExit)
            {
                string strSQL = string.Format("select * from dt_BookRoomInfo where 预定编号={0}", m_strCurrBookNO);
                DataTable dtRow = DBserver.setComGetTable(strSQL);
                DataRow ExitRow = dtRow.Rows[0];
                tbMoveTeleNum.Text = ExitRow["移动电话"].ToString();
                tbPhoneNum.Text = ExitRow["固定电话"].ToString();
                tbVIPName.Text = ExitRow["姓名"].ToString();
                textBox客户留言.Text = ExitRow["客户留言"].ToString();
                textBox预抵压金.Text = ExitRow["押金"].ToString();
                tbBookNO.Text = ExitRow["预定编号"].ToString();
            }
            //产生工程编号
            else
            {
                string strProjID = string.Format("{0}{1:D2}{2:D2}", DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day);
                string strSql = string.Format("select 预定编号 from dt_BookRoomInfo where 预定编号 like '{0}%'", strProjID);
                DataTable dt = DBserver.setComGetTable(strSql);
                int nMax = 0;
                foreach (DataRow drow in dt.Rows)
                {
                    //获取数据的自增部分，并产生最大值。
                    string strCurr = drow[0].ToString().Substring(8);
                    int nIn = int.Parse(strCurr);
                    if (nIn >= nMax)
                    {
                        nMax = nIn;
                    }
                }
                //调用方法
                strProjID = strProjID + GetAddPart(nMax + 1, 4);
                tbBookNO.Text = strProjID;
            }

            //给comboBoxBookSize中添加项
            string strSelect = "select distinct(房间类型) from dt_Htype@TabNo";
            DataTable dtab = DBserver.setComGetTable(strSelect);
            foreach (DataRow dr in dtab.Rows)
            {
                comboBoxBookSize.Items.Add(dr["房间类型"].ToString());
            }
            comboBoxBookSize.SelectedIndex = 0;
            //给comboBoxTableID中添加项
            string strTabNo = string.Format("select distinct(餐台编号) from dt_Htype@TabNo where 房间类型='{0}'", "大厅") ;
            DataTable table = DBserver.setComGetTable(strTabNo);
            foreach (DataRow drow in table.Rows)
            {
                comboBoxTableID.Items.Add(drow["餐台编号"].ToString());
            }
            comboBoxTableID.SelectedIndex = 0;
            comboBoxTimeSpamd.SelectedIndex = 0;
        }
        private string GetAddPart(int nIn, int nLength)
        {
            string strOut = "";
            if (nIn == 1)
            {
                strOut = "0001";
            }
            else
            {
                string strIn = nIn.ToString();
                strOut = strIn;
                for (int i = 0; i < nLength - strIn.Length; i++)
                {
                    strOut = "0" + strOut;
                }
            }
            return strOut;
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            frm添加预定类型 frmAdd = new frm添加预定类型();
            if (frmAdd.ShowDialog() == DialogResult.OK)
            {
                //刷新combox中的内容
                string strSql = "select distinct(房间类型) from dt_Htype@TabNo";
                DataTable dt = DBserver.setComGetTable(strSql);
                comboBoxBookSize.Items.Clear();
                foreach (DataRow dr in dt.Rows)
                {
                    comboBoxBookSize.Items.Add(dr["房间类型"].ToString());
                }
            }
        }

        private void comboBoxBookSize_SelectedIndexChanged(object sender, EventArgs e)
        {
            //当comboBoxBookSize中的选择改变时发生
            string strValue = comboBoxBookSize.Text.Trim();
            string strSql = string.Format("select 餐台编号 from dt_Htype@TabNo where 房间类型='{0}'", strValue);
            DataTable dt = DBserver.setComGetTable(strSql);
            comboBoxTableID.Items.Clear();
            foreach (DataRow dr in dt.Rows)
            {
                comboBoxTableID.Items.Add(dr["餐台编号"].ToString());
            }
            comboBoxTableID.SelectedIndex = 0;
        }


       
    }
}