?? frmoppmanage.cs

?? 客戶關系管理系統
?? CS
字號:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace CRM.DataManage
{
    public partial class frmOppManage : Form
    {
        CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
        CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate();
        protected string M_str_sql = "select OID as 對手編號,OName as 對手名稱,OManager as 法人代表,"
            + "OTrade as 所屬行業,OArea as 所在區域,OSize as 企業規模,OPhone as 聯系電話,"
            + "OFax as 傳真號碼,OPostCode as 郵政編碼,OAddress as 聯系地址,OEmail as Email地址,ORemark as 備注 from tb_Opponent";
        protected string M_str_table = "tb_Opponent";
        protected int M_int_judge;
        public frmOppManage()
        {
            InitializeComponent();
        }

        private void frmOppManage_Load(object sender, EventArgs e)
        {
            opAndvalidate.cboxBind("select AreaName from tb_Area", "tb_Area", "AreaName", cboxOArea);
            DataSet myds = boperate.getds(M_str_sql, M_str_table);
            dgvOppInfo.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 OID from tb_Opponent", "tb_Opponent", "OID", "DS", "1000001", txtOppCode);
            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 (txtOName.Text == "")
                {
                    MessageBox.Show("對手名稱不能為空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    if (!opAndvalidate.validatePhone(txtOPhone.Text.Trim()))
                    {
                        errorOFax.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.Clear();
                        errorOPhone.SetError(txtOPhone, "電話號碼格式不正確");
                    }
                    else if (!opAndvalidate.validateFax(txtOFax.Text.Trim()))
                    {
                        errorOPhone.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.Clear();
                        errorOFax.SetError(txtOFax, "傳真號碼輸入格式不正確");
                    }
                    else if (!opAndvalidate.validatePostCode(txtOPostCode.Text.Trim()))
                    {
                        errorOFax.Clear();
                        errorOPhone.Clear();
                        errorOEmail.Clear();
                        errorOPostCode.SetError(txtOPostCode, "郵編輸入格式不正確");
                    }
                    else if (!opAndvalidate.validateEmail(txtOEmail.Text.Trim()))
                    {
                        errorOFax.Clear();
                        errorOPhone.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.SetError(txtOEmail, "E-mail地址輸入格式不正確");
                    }
                    else
                    {
                        errorOFax.Clear();
                        errorOPhone.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.Clear();
                        boperate.getcom("insert into tb_Opponent(OID,OName,OManager,OTrade,OArea,OSize,OPhone,"
                            + "OFax,OPostCode,OAddress,OEmail,ORemark) values('" + txtOppCode.Text.Trim()
                            + "','" + txtOName.Text.Trim() + "','" + txtOManager.Text.Trim() + "','" + cboxOTrade.Text.Trim()
                            + "','" + cboxOArea.Text.Trim() + "','" + cboxOSize.Text.Trim() + "','" + txtOPhone.Text.Trim()
                            + "','" + txtOFax.Text.Trim() + "','" + txtOPostCode.Text.Trim() + "','" + txtOAddress.Text.Trim()
                            + "','" + txtOEmail.Text.Trim() + "','" + txtORemark.Text.Trim() + "')");
                        frmOppManage_Load(sender, e);
                        MessageBox.Show("競爭對手信息添加成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        tsbtnSave.Enabled = false;
                    }
                }
            }
            if (M_int_judge == 1)
            {
                if (txtOName.Text == "")
                {
                    MessageBox.Show("對手名稱不能為空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    if (!opAndvalidate.validatePhone(txtOPhone.Text.Trim()))
                    {
                        errorOFax.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.Clear();
                        errorOPhone.SetError(txtOPhone, "電話號碼格式不正確");
                    }
                    else if (!opAndvalidate.validateFax(txtOFax.Text.Trim()))
                    {
                        errorOPhone.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.Clear();
                        errorOFax.SetError(txtOFax, "傳真號碼輸入格式不正確");
                    }
                    else if (!opAndvalidate.validatePostCode(txtOPostCode.Text.Trim()))
                    {
                        errorOFax.Clear();
                        errorOPhone.Clear();
                        errorOEmail.Clear();
                        errorOPostCode.SetError(txtOPostCode, "郵編輸入格式不正確");
                    }
                    else if (!opAndvalidate.validateEmail(txtOEmail.Text.Trim()))
                    {
                        errorOFax.Clear();
                        errorOPhone.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.SetError(txtOEmail, "E-mail地址輸入格式不正確");
                    }
                    else
                    {
                        errorOFax.Clear();
                        errorOPhone.Clear();
                        errorOPostCode.Clear();
                        errorOEmail.Clear();
                        boperate.getcom("update tb_Opponent set OName='" + txtOName.Text.Trim()
                            + "',OManager='" + txtOManager.Text.Trim() + "',OTrade='" + cboxOTrade.Text.Trim() + "',OArea='"
                            + cboxOArea.Text.Trim() + "',OSize='" + cboxOSize.Text.Trim() + "',OPhone='"
                            + txtOPhone.Text.Trim() + "',OFax='" + txtOFax.Text.Trim() + "',OPostCode='" + txtOPostCode.Text.Trim()
                            + "',OAddress='" + txtOAddress.Text.Trim() + "',OEmail='" + txtOEmail.Text.Trim()
                            + "',ORemark='" + txtORemark.Text.Trim() + "' where OID='" + txtOppCode.Text.Trim() + "'");
                        frmOppManage_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_Opponent where OID='" + Convert.ToString(dgvOppInfo[0, dgvOppInfo.CurrentCell.RowIndex].Value).Trim() + "'");
                    frmOppManage_Load(sender, e);
                    MessageBox.Show("刪除數據成功！", "提示", 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 == "")
                {
                    frmOppManage_Load(sender, e);
                }
                if (tscboxCondition.Text.Trim() == "對手編號")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where OID like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvOppInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關記錄！");
                }
                if (tscboxCondition.Text.Trim() == "對手名稱")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where OName like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvOppInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關記錄！");
                }
                if (tscboxCondition.Text.Trim() == "所屬行業")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where OTrade like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvOppInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關記錄！");
                }
                if (tscboxCondition.Text.Trim() == "企業規模")
                {
                    DataSet myds = boperate.getds(M_str_sql + " where OSize like '%" + tstxtKeyWord.Text.Trim() + "%'", M_str_table);
                    if (myds.Tables[0].Rows.Count > 0)
                        dgvOppInfo.DataSource = myds.Tables[0];
                    else
                        MessageBox.Show("沒有要查找的相關記錄！");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

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

        private void dgvOppInfo_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtOppCode.Text = Convert.ToString(dgvOppInfo[0, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtOName.Text = Convert.ToString(dgvOppInfo[1, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtOManager.Text = Convert.ToString(dgvOppInfo[2, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            cboxOTrade.Text = Convert.ToString(dgvOppInfo[3, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            cboxOArea.Text = Convert.ToString(dgvOppInfo[4, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            cboxOSize.Text = Convert.ToString(dgvOppInfo[5, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtOPhone.Text = Convert.ToString(dgvOppInfo[6, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtOFax.Text = Convert.ToString(dgvOppInfo[7, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtOPostCode.Text = Convert.ToString(dgvOppInfo[8, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtOAddress.Text = Convert.ToString(dgvOppInfo[9, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtOEmail.Text = Convert.ToString(dgvOppInfo[10, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
            txtORemark.Text = Convert.ToString(dgvOppInfo[11, dgvOppInfo.CurrentCell.RowIndex].Value).Trim();
        }

        public void ClearText()
        {
            txtOName.Text = "";
            txtOManager.Text = "";
            txtOPhone.Text = "";
            txtOFax.Text = "";
            txtOPostCode.Text = "";
            txtOAddress.Text = "";
            txtOEmail.Text = "";
            txtORemark.Text = "";
        }
    }
}
?? 文件大小 1193 K
?? 上傳用戶 wzsq12
?? 所屬分類企業管理
??? 相關標簽

#管理系統
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? frmoppmanage.cs

?? 快捷鍵說明
