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

namespace 餐飲管理系統
{
    public partial class Frm會員管理 : Form
    {
        public Frm會員管理()
        {
            InitializeComponent();
        }


        private void buttonAddOk_Click(object sender, EventArgs e)
        {
            //從界面上接收數據
            string strMemID = textBox會員號.Text.Trim();
            string strMemName = textBoxName.Text.Trim();
            string strPwd = textBoxPwd.Text.Trim();
            string strRePwd = textBoxRePwd.Text.Trim();
            string strSex = comboBoxMemSex.Text.Trim();
            string strBrith = dateTimePickerBrithday.Value.ToString();
            string strMemClass = comboBoxMemClass.Text.Trim();
            string str憑證類型 = comboBox憑證類型.Text.Trim();
            string strMem證件號 = textBox證件號.Text.Trim();
            string strMemAddress = textBoxAddress.Text.Trim();

            //驗證數據正確性, 不正確則拋出錯誤

            if (strMemName == "")
            {
                Utility.SetErr(textBoxName, "用戶名不能為空!");
                return;
            }
            if (strPwd == "" || strRePwd == "")
            {
                Utility.SetErr(buttonAddOk, "密碼不能為空！");
                return;
            }
            if (strRePwd != strPwd)
            {
                Utility.SetErr(textBoxRePwd, "兩次密碼不一致！請重新輸入！");
                textBoxPwd.Text = "";
                textBoxRePwd.Text = "";
                textBoxPwd.Focus();
                return;
            }

            //注冊數據插入數據庫
            string strSql = string.Format("insert into dt_會員信息(會員號,密碼,姓名,性別,生日,級別,憑證類型,證件號,詳細地址)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')",
                strMemID, strPwd, strMemName, strSex, strBrith, strMemClass, str憑證類型,strMem證件號, strMemAddress);
            if(DBserver.setCommNornQuey(strSql)>0)
                MessageBox.Show("注冊成功！");
        }

        private void Frm會員管理_Load(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            瀏覽會員信息ToolStripMenuItem_Click(null, null);
            this.Cursor = Cursors.Default;
        }

        //private void tabControl1_Selecting(object sender, TabControlCancelEventArgs e)
        //{

        //    瀏覽會員信息ToolStripMenuItem_Click(null, null);
        //}

        private void 瀏覽會員信息ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            try
            {
                //顯示選中頁面
                tabControl1.SelectedTab = tabPageViewInfo;
                //顯示會員信息到界面上
                string strSql = "select 會員號,姓名,性別,生日,級別,憑證類型,證件號,詳細地址 from dt_會員信息";
                DataTable dt = DBserver.setComGetTable(strSql);
                dataGridView1.DataSource = dt;
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message);
            }
        }

        private void 注冊ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //產生自動編號
            #region 產生工程編號
            //產生工程編號
            string strVipID = string.Format("{0}{1:D2}{2:D2}", DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day);
            string strSql = string.Format("select 會員號 from dt_會員信息 where 會員號 like '{0}%'", strVipID);
            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;
                }
            }
            //調用方法
            strVipID = strVipID + GetAddPart(nMax + 1, 4);
            textBox會員號.Text = strVipID;

            #endregion
            //注冊時
            tabControl1.SelectedTab = tabPageTakeIn;
        }        
        
        #region 工程編號尾號
        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;
        } 
        #endregion
        
        string m_strCurrID="";
        private void 編輯ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (dataGridView1.SelectedRows.Count == 0)
            {
                MessageBox.Show("編輯前必須選中一行數據！");
                return;
            }

            m_strCurrID = dataGridView1.CurrentRow.Cells["會員號"].Value.ToString();
            string strCurIDsQl = string.Format("select *from dt_會員信息 where 會員號='{0}'", m_strCurrID);
            DataTable dt = DBserver.setComGetTable(strCurIDsQl);
            //將獲取的數據賦值到界面上
            DataRow dr = dt.Rows[0];
            textBoxExitID.Text = dr["會員號"].ToString();
            textBoxExitName.Text = dr["姓名"].ToString();
            //textBoxExitPwd.Text = dr["密碼"].ToString();
            //textBoxExitRePwd.Text = dr["密碼"].ToString();
            textBoxExit證件號.Text = dr["證件號"].ToString();
            comboBoxExitSex.Text = dr["性別"].ToString();
            dateTimePickerExitBirthday.Value = Convert.ToDateTime(dr["生日"]);
            comboBoxExitMemClass.Text = dr["級別"].ToString();
            textBoxExit證件號.Text = dr["證件號"].ToString();
            textBoxExitAddress.Text = dr["詳細地址"].ToString();
            comboBoxExit憑證類型.SelectedItem = dr["憑證類型"].ToString();
            tabControl1.SelectedTab = tabPageExitParter;
        }

        //編輯確定時發生
        private void buttonExitOK_Click(object sender, EventArgs e)
        {
            //從界面上接收數據
            string strMemID = textBoxExitID.Text.Trim();
            string strMemName = textBoxExitName.Text.Trim();
            string strSQL = string.Format("select 密碼 from dt_會員信息 where 會員號='{0}'", m_strCurrID);
            string strOldpwd = DBserver.setCommGetScalar(strSQL).ToString();
            string strPwd = "";
            string strRePwd = "";

            //判斷舊密碼是否正確
            if (strOldpwd == textBoxOldPwd.Text.Trim())
            {
                strPwd = textBoxExitPwd.Text.Trim();
                strRePwd = textBoxExitRePwd.Text.Trim();
            }
            else
            {
                Utility.SetErr(textBoxOldPwd, "原密碼不正確！請重新填寫！");
                textBoxOldPwd.Text = "";
                textBoxExitPwd.Text = "";
                textBoxExitRePwd.Text = "";
                textBoxOldPwd.Focus();
            }

            string strSex = comboBoxExitSex.Text.Trim();
            string strBrith = dateTimePickerExitBirthday.Value.ToString();
            string strMemClass = comboBoxExitMemClass.Text.Trim();
            string str憑證類型 = comboBoxExit憑證類型.Text.Trim();
            string strMem證件號 = textBoxExit證件號.Text.Trim();
            string strMemAddress = textBoxExitAddress.Text.Trim();

            //驗證數據正確性, 不正確則拋出錯誤

            if (strMemName == "")
            {
                Utility.SetErr(textBoxName, "用戶名不能為空!");
                return;
            }
            if (strPwd == "" || strRePwd == "")
            {
                Utility.SetErr(buttonAddOk, "密碼不能為空！");
                return;
            }
            if (strRePwd != strPwd)
            {
                Utility.SetErr(textBoxRePwd, "兩次密碼不一致！請重新輸入！");
                textBoxPwd.Text = "";
                textBoxRePwd.Text = "";
                textBoxPwd.Focus();
                return;
            }
            //將修改后的數據在數據庫中修改
            string strSql = string.Format("update dt_會員信息 set 會員號='{0}',密碼='{1}',姓名='{2}',性別='{3}',生日='{4}'" +
                ",級別='{5}',憑證類型='{6}',證件號='{7}',詳細地址='{8}' where 會員號='{9}'",
                strMemID, strPwd, strMemName, strSex, strBrith, strMemClass, str憑證類型, strMem證件號, strMemAddress, m_strCurrID);
            if (DBserver.setCommNornQuey(strSql) > 0)
                MessageBox.Show("編輯成功！");
        }

        private void 刪除DToolStripMenuItem_Click(object sender, EventArgs e)
        {
            if (dataGridView1.SelectedRows.Count == 0)
            {
                MessageBox.Show("刪除數據前必須選中一行！");
                return;
            }
            if (MessageBox.Show("你將刪除一個會員的信息，確認刪除此會員嗎？", "可可西里提示！", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
            {
                string strCurVIPID = dataGridView1.CurrentRow.Cells["會員號"].Value.ToString();
                string strSql = string.Format("delete from dt_會員信息 where 會員號='{0}'", strCurVIPID);
                if (DBserver.setCommNornQuey(strSql) > 0)
                {
                    MessageBox.Show("刪除成功！");
                    //調用一個方法刷新界面
                    瀏覽會員信息ToolStripMenuItem_Click(null, null);
                }
            }
            else
                return;
        }

        private void 退出XToolStripMenuItem_Click(object sender, EventArgs e)
        {
            //關閉當前窗體
            this.Close();
        }

        
    }
}