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

namespace CRM.DataManage
{
    public partial class frmClientManage : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate();
        protected string M_str_sql = "select ClientID as 客戶編號,CName as 客戶名稱,CStep as 客戶等級,"
            + "CRoot as 客戶來源,CTrade as 所屬行業(yè),CType as 客戶類別,CArea as 所在區(qū)域,CPhone as 聯(lián)系電話,"
            + "CFax as 傳真號碼,CPostCode as 郵政編碼,CAddress as 聯(lián)系地址,CEmail as Email地址,CRemark as 備注 from tb_ClientInfo";
        protected string M_str_table = "tb_ClientInfo";
        protected int M_int_judge;
        public frmClientManage()
        {
            InitializeComponent();
        }

        private void frmClientManage_Load(object sender, EventArgs e)
        {
            opAndvalidate.cboxBind("select AreaName from tb_Area", "tb_Area", "AreaName", cboxCArea);
            DataSet myds = boperate.getds(M_str_sql, M_str_table);
            dgvClientInfo.DataSource = myds.Tables[0];
            if (myds.Tables[0].Rows.Count > 0)
                tsbtnDel.Enabled = true;
            else
                tsbtnDel.Enabled = false;
        }

        private void tsbtnAdd_Click(object sender, EventArgs e)
        {
            opAndvalidate.autoNum("select ClientID from tb_ClientInfo", "tb_ClientInfo", "ClientID", "KH", "1000001", txtClientCode);
            tsbtnSave.Enabled = true;
            M_int_judge = 0;
            ClearText();
        }

        private void tsbtnEdit_Click(object sender, EventArgs e)
        {
            tsbtnSave.Enabled = true;
            M_int_judge = 1;
        }

        private void tsbtnSave_Click(object sender, EventArgs e)
        {
            if (M_int_judge == 0)
            {
                if (txtCName.Text == "")
                {
                    MessageBox.Show("客戶名稱不能為空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    if (!opAndvalidate.validatePhone(txtCPhone.Text.Trim()))
                    {
                        errorCFax.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.Clear();
                        errorCPhone.SetError(txtCPhone, "電話號碼格式不正確");
                    }
                    else if (!opAndvalidate.validateFax(txtCFax.Text.Trim()))
                    {
                        errorCPhone.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.Clear();
                        errorCFax.SetError(txtCFax, "傳真號碼輸入格式不正確");
                    }
                    else if (!opAndvalidate.validatePostCode(txtCPostCode.Text.Trim()))
                    {
                        errorCFax.Clear();
                        errorCPhone.Clear();
                        errorCEmail.Clear();
                        errorCPostCode.SetError(txtCPostCode, "郵編輸入格式不正確");
                    }
                    else if (!opAndvalidate.validateEmail(txtCEmail.Text.Trim()))
                    {
                        errorCFax.Clear();
                        errorCPhone.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.SetError(txtCEmail, "E-mail地址輸入格式不正確");
                    }
                    else
                    {
                        errorCFax.Clear();
                        errorCPhone.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.Clear();
                        boperate.getcom("insert into tb_ClientInfo(ClientID,CName,CStep,CRoot,CTrade,CType,"
                            + "CArea,CPhone,CFax,CPostCode,CAddress,CEmail,CRemark) values('" + txtClientCode.Text.Trim()
                            + "','" + txtCName.Text.Trim() + "','" + cboxCStep.Text.Trim() + "','" + cboxCRoot.Text.Trim()
                            + "','" + cboxCTrade.Text.Trim() + "','" + cboxCType.Text.Trim() + "','" + cboxCArea.Text.Trim()
                            + "','" + txtCPhone.Text.Trim() + "','" + txtCFax.Text.Trim() + "','" + txtCPostCode.Text.Trim()
                            + "','" + txtCAddress.Text.Trim() + "','" + txtCEmail.Text.Trim() + "','" + txtCRemark.Text.Trim() + "')");
                        frmClientManage_Load(sender, e);
                        MessageBox.Show("客戶信息添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        tsbtnSave.Enabled = false;
                    }
                }
            }
            if (M_int_judge == 1)
            {
                if (txtCName.Text == "")
                {
                    MessageBox.Show("客戶名稱不能為空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    if (!opAndvalidate.validatePhone(txtCPhone.Text.Trim()))
                    {
                        errorCFax.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.Clear();
                        errorCPhone.SetError(txtCPhone, "電話號碼格式不正確");
                    }
                    else if (!opAndvalidate.validateFax(txtCFax.Text.Trim()))
                    {
                        errorCPhone.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.Clear();
                        errorCFax.SetError(txtCFax, "傳真號碼輸入格式不正確");
                    }
                    else if (!opAndvalidate.validatePostCode(txtCPostCode.Text.Trim()))
                    {
                        errorCFax.Clear();
                        errorCPhone.Clear();
                        errorCEmail.Clear();
                        errorCPostCode.SetError(txtCPostCode, "郵編輸入格式不正確");
                    }
                    else if (!opAndvalidate.validateEmail(txtCEmail.Text.Trim()))
                    {
                        errorCFax.Clear();
                        errorCPhone.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.SetError(txtCEmail, "E-mail地址輸入格式不正確");
                    }
                    else
                    {
                        errorCFax.Clear();
                        errorCPhone.Clear();
                        errorCPostCode.Clear();
                        errorCEmail.Clear();
                        boperate.getcom("update tb_ClientInfo set CName='" + txtCName.Text.Trim()
                            + "',CStep='" + cboxCStep.Text.Trim() + "',CRoot='" + cboxCRoot.Text.Trim() + "',CTrade='"
                            + cboxCTrade.Text.Trim() + "',CType='" + cboxCType.Text.Trim() + "',CArea='"
                            + cboxCArea.Text.Trim() + "',CPhone='" + txtCPhone.Text.Trim() + "',CFax='" + txtCFax.Text.Trim()
                            + "',CPostCode='" + txtCPostCode.Text.Trim() + "',CAddress='" + txtCAddress.Text.Trim()
                            + "',CEmail='" + txtCEmail.Text.Trim() + "',CRemark='" + txtCRemark.Text.Trim() + "' where ClientID='" + txtClientCode.Text.Trim() + "'");
                        frmClientManage_Load(sender, e);
                        MessageBox.Show("客戶信息修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        tsbtnSave.Enabled = false;
                    }
                }
            }
        }

        private void tsbtnDel_Click(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("確定要刪除該客戶嗎？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
                {
                    boperate.getcom("delete from tb_ClientInfo where ClientID='" + Convert.ToString(dgvClientInfo[0, dgvClientInfo.CurrentCell.RowIndex].Value).Trim() + "'");
                    frmClientManage_Load(sender, e);
                    MessageBox.Show("刪除數(shù)據(jù)成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
            }
        }

        private void tsbtnLook_Click(object sender, EventArgs e)
        {
            try
            {
                if (tstxtKeyWord.Text == "")
                {
                    frmClientManage_Load(sender, e);
                }
                if (tscboxCondition.Text.Trim() == "客戶編號")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where ClientID like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvClientInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關(guān)記錄！");
                }
                if (tscboxCondition.Text.Trim() == "客戶名稱")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where CName like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvClientInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關(guān)記錄！");
                }
                if (tscboxCondition.Text.Trim() == "客戶來源")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where CRoot like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvClientInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關(guān)記錄！");
                }
                if (tscboxCondition.Text.Trim() == "所屬行業(yè)")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where CTrade like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvClientInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關(guān)記錄！");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

        private void tsbtnRClient_Click(object sender, EventArgs e)
        {
            CRM.DataManage.frmRClient dmFRC = new frmRClient();
            dmFRC.ShowDialog();
        }

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

        private void dgvClientInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtClientCode.Text = Convert.ToString(dgvClientInfo[0, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            txtCName.Text = Convert.ToString(dgvClientInfo[1, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            cboxCStep.Text = Convert.ToString(dgvClientInfo[2, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            cboxCRoot.Text = Convert.ToString(dgvClientInfo[3, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            cboxCTrade.Text = Convert.ToString(dgvClientInfo[4, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            cboxCType.Text = Convert.ToString(dgvClientInfo[5, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            cboxCArea.Text = Convert.ToString(dgvClientInfo[6, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            txtCPhone.Text = Convert.ToString(dgvClientInfo[7, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            txtCFax.Text = Convert.ToString(dgvClientInfo[8, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            txtCPostCode.Text = Convert.ToString(dgvClientInfo[9, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            txtCAddress.Text = Convert.ToString(dgvClientInfo[10, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            txtCEmail.Text = Convert.ToString(dgvClientInfo[11, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
            txtCRemark.Text = Convert.ToString(dgvClientInfo[12, dgvClientInfo.CurrentCell.RowIndex].Value).Trim();
        }

        public void ClearText()
        {
            txtCName.Text = "";
            txtCPhone.Text = "";
            txtCFax.Text = "";
            txtCPostCode.Text = "";
            txtCAddress.Text = "";
            txtCEmail.Text = "";
            txtCRemark.Text = "";
        }
    }
}