📄 frmclientmanage.cs
字号:
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 所属行业,CType as 客户类别,CArea as 所在区域,CPhone as 联系电话,"
+ "CFax as 传真号码,CPostCode as 邮政编码,CAddress as 联系地址,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("删除数据成功！", "提示", 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("没有要查找的相关记录！");
}
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("没有要查找的相关记录！");
}
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("没有要查找的相关记录！");
}
if (tscboxCondition.Text.Trim() == "所属行业")
{
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("没有要查找的相关记录！");
}
}
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 = "";
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -