?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();
        }
        //用他判定是否是處于編輯狀態(tài)
        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)
        {
            //如果是編輯狀態(tài)。。。。。。。
            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中的選擇改變時發(fā)生
            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;
        }


       
    }
}