frmoppmanage.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 = "";
        }
    }
}