址,CEmail as Email地址,CRemark as 备注from tb_ClientInfo where CBy = '\ + frmLogin.M_str_name + \;
protected string M_str_table = \; protected int M_int_judge; public frmClientManage() {
InitializeComponent(); }
private void frmClientManage_Load(object sender, EventArgs e) {
txtCBy.Text = frmLogin.M_str_name;
opAndvalidate.cboxBind(\, \, \, cboxCArea);
DataSet myds;
if (frmLogin.M_str_right == \超级管理员\) {
myds = boperate.getds(M_str_sql, M_str_table); } else {
myds = boperate.getds(M_str_sql2, 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(\, \, \, \, \, txtClientCode); tsbtnSave.Enabled = true; M_int_judge = 0; ClearText(); }
private void tsbtnEdit_Click(object sender, EventArgs e) {
tsbtnSave.Enabled = true; M_int_judge = 1;
31
}
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, \地址输入格式不正确\); } else {
errorCFax.Clear();
32
errorCPhone.Clear(); errorCPostCode.Clear(); errorCEmail.Clear(); boperate.getcom(\tb_ClientInfo(ClientID,CName,CStep,CRoot,CTrade,CBy,\
+ \values('\ + txtClientCode.Text.Trim()
+ \ + txtCName.Text.Trim() + \ + cboxCStep.Text.Trim() + \ + cboxCRoot.Text.Trim()
+ \ + cboxCTrade.Text.Trim() + \ + txtCBy.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, \传真号码输入格式不正确\);
33
}
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, \地址输入格式不正确\); } else {
errorCFax.Clear(); errorCPhone.Clear(); errorCPostCode.Clear(); errorCEmail.Clear();
boperate.getcom(\ + txtCName.Text.Trim()
+ \ + cboxCStep.Text.Trim() + \ + cboxCRoot.Text.Trim() + \
+ cboxCTrade.Text.Trim() + \ + txtCBy.Text.Trim() + \
+ cboxCArea.Text.Trim() + \ + txtCPhone.Text.Trim() + \ + txtCFax.Text.Trim()
+ \ + txtCPostCode.Text.Trim() + \ + txtCAddress.Text.Trim()
+ \ + txtCEmail.Text.Trim() + \ + txtCRemark.Text.Trim() + \ + txtClientCode.Text.Trim() + \); frmClientManage_Load(sender, e);
MessageBox.Show(\客户信息修改成功！\, \提示\, MessageBoxButtons.OK, MessageBoxIcon.Information);
tsbtnSave.Enabled = false; } } } }
（六）竞争对手信息
在系统主界面点击资料管理的竞争对手信息,显示竞争对手信息（对手名称、法人、地址等），修改按钮，删除按钮，查询按钮，保存按钮和取消按钮；点击
34
【添加】按钮选择竞争对手信息，输入名称、法人、电话等记录；点击【保存】按钮，可以保存当前记录；选择记录信息，可以进行修改；点击【删除】按钮，删除相应信息。如图所示：
图5-6 竞争对手信息
其关键代码实现如下：
CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate();
CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate(); protected string M_str_sql = \对手编号,OName as 对手名称,OManager as 法人代表,\
+ \所属行业,OArea as 所在区域,OSize as 企业规模,OPhone as 联系电话,\ + \传真号码,OPostCode as 邮政编码,OAddress as 联系地址,OEmail as Email地址,ORemark as 备注from tb_Opponent\;
protected string M_str_table = \; protected int M_int_judge; public frmOppManage() {
InitializeComponent(); }
private void frmOppManage_Load(object sender, EventArgs e) {
opAndvalidate.cboxBind(\, \, \, cboxOArea);
DataSet myds = boperate.getds(M_str_sql, M_str_table); dgvOppInfo.DataSource = myds.Tables[0];
35