📄 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 = "";
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -