}// end if
#endregion
#region//修改客户信息，返回值， １表示成功，0表示失败
public int tbCustomerUpdate(tbCustomerClass Customer)
{
int intFalg = 0;
try
{
tbDai = new tbDaiConnection();
oledCon = tbDai.OledCon();
string strUpdate = "update tb_Customer set ";
strUpdate += "khName ='" + Customer.khName + "',";
strUpdate += "khPi ='" + Customer.khPi + "',khType='" + Customer.khType + "',khHandye='" + Customer.khHandye + "',khState='" + Customer.khState + "',";
strUpdate += "khTel='" + Customer.kuTel + "',kuOffice='" + Customer.kuOffice + "',kuEmail='" + Customer.kuEmail + "',";
strUpdate += "kuAddress='" + Customer.kuAddress + "',kuChangPi='" + Customer.kuChangPi + "',kuSum='" + Customer.kuSum + "',";
strUpdate += "kuDate='" + Customer.kuDate + "',kuEmploy='" + Customer.kuEmploy + "',kuDateLaste='" + Customer.kuDateLaste + "',kuFalg='" + Customer.kuFalg + "'";
strUpdate += " where khID='" + Customer.khID + "'";
oledCmd = new OleDbCommand(strUpdate, oledCon);
if (oledCmd.ExecuteNonQuery() != 0)
{
intFalg = 1;//添加成功
}
return(intFalg);
}
catch (Exception ee)
{
return(intFalg);
}
}// end if
public int tbCustomerAdd(tbCustomerClass Customer)
{
int intFalg = 0;
try
{
tbDai = new tbDaiConnection();
oledCon = tbDai.OledCon();
string strAdd = "insert into tb_Customer ";
strAdd += "values('" + Customer.khID + "','" + Customer.khName + "',";
strAdd += "'" + Customer.khPi + "','" + Customer.khType + "','" + Customer.khHandye + "','" + Customer.khState + "',";
strAdd += "'" + Customer.kuTel + "','" + Customer.kuOffice + "','" + Customer.kuEmail + "',";
strAdd += "'" + Customer.kuAddress + "','" + Customer.kuChangPi + "','" + Customer.kuSum + "',";
strAdd += "'" + Customer.kuDate + "','" + Customer.kuEmploy + "','" + Customer.kuDateLaste + "','" + Customer.kuFalg + "')";
oledCmd = new OleDbCommand(strAdd, oledCon);
if (oledCmd.ExecuteNonQuery() != 0)
{
intFalg = 1;//添加成功
}
return(intFalg);
}
catch (Exception ee)
{
return(intFalg);
}
}// end if
private void button1_Click(object sender, EventArgs e)
{
if (cmbFind.Text == "")
{
MessageBox.Show("请选择查询条件！", "提示");
cmbFind.Focus();
return;
}
if (txtWord.Text == "")
{
MessageBox.Show("请输入查询条件！", "提示");
txtWord.Focus();
return;
}
tbCustomerClass tbClass = new tbCustomerClass();
tbCustomerMethod tbMenthod = new tbCustomerMethod();
switch (cmbFind.Text)
{
case "客户编号":
tbClass.khID = txtWord.Text.Trim();
int intFalg = tbMenthod.fillDataGridView(dataGridView1, tbMenthod.tbCustomerSecarf(tbClass, "khID"), DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "khID")));
if (intFalg == 0)
{
DtatClear();
} //调用方法清空控件
break;
case "客户姓名":
tbClass.khPi = txtWord.Text.Trim();
int intFalgName = tbMenthod.fillDataGridView(dataGridView1, tbMenthod.tbCustomerSecarf(tbClass, "khName"), DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "khName")));
if (intFalgName == 0)
{
DtatClear();
} //调用方法清空控件
break;
case "公司名称":
tbClass.khName = txtWord.Text.Trim();
int intFalgCName = tbMenthod.fillDataGridView(dataGridView1, tbMenthod.tbCustomerSecarf(tbClass, "kuComputy"), DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "kuComputy")));
if (intFalgCName == 0)
{
DtatClear();
} //调用方法清空控件
break;
case "电话查询":
tbClass.kuTel = txtWord.Text.Trim();
tbClass.kuOffice = txtWord.Text.Trim();
int intFalgTel = tbMenthod.fillDataGridView(dataGridView1, tbMenthod.tbCustomerSecarf(tbClass, "khTel"), DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "khTel")));
if (intFalgTel == 0)
{
DtatClear();
} //调用方法清空控件
break;
}//end
}
private void bntLike_Click(object sender, EventArgs e)
{
if (cmbFind.Text == "")
{
MessageBox.Show("请选择查询条件！", "提示");
cmbFind.Focus();
return;
}
tbCustomerClass tbClass = new tbCustomerClass();
tbCustomerMethod tbMenthod = new tbCustomerMethod();
switch (cmbFind.Text)
{
case "客户编号":
tbClass.khID = txtWord.Text.Trim();
int intCout = DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "LikekhID"));
int intFalg = DataGridFalg(tbMenthod.tbCustomerSecarf(tbClass, "LikekhID"), intCout);
if (intFalg == 0)
{
DtatClear();
} //调用方法清空控件
break;
case "客户姓名":
tbClass.khPi = txtWord.Text.Trim();
int intCout1 = DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "LikekhName"));
int intFalgName = DataGridFalg(tbMenthod.tbCustomerSecarf(tbClass, "LikekhName"), intCout1);
if (intFalgName == 0)
{
DtatClear();
} //调用方法清空控件
break;
case "公司名称":
tbClass.khName = txtWord.Text.Trim();
int intCout2 = DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "kuComputylike"));
int intFalgCName = DataGridFalg(tbMenthod.tbCustomerSecarf(tbClass, "kuComputylike"), intCout2);
if (intFalgCName == 0)
{
DtatClear();
} //调用方法清空控件
break;
case "电话查询":
tbClass.kuTel = txtWord.Text.Trim();
tbClass.kuOffice = txtWord.Text.Trim();
int intCout3 = DataGridViewCount(tbMenthod.tbCustomerSecarf(tbClass, "khTelLike"));
int intFalgTel = DataGridFalg(tbMenthod.tbCustomerSecarf(tbClass, "khTelLike"), intCout3);
if (intFalgTel == 0)
{
DtatClear();
} //调用方法清空控件
break;
}//end
}//
}// end if
#endregion
#region//删除客户信息，返回值， １表示成功，0表示失败，将客户删除标记修改为1
public int tbCustomerDelete(tbCustomerClass Customer)
{
int intFalg = 0;
try
{
tbDai = new tbDaiConnection();
oledCon = tbDai.OledCon();
string strUpdate = "update tb_Customer set ";
strUpdate += "kuFalg='" + Customer.kuFalg + "'";
strUpdate += " where khID='" + Customer.khID + "'";
oledCmd = new OleDbCommand(strUpdate, oledCon);
if (oledCmd.ExecuteNonQuery() != 0)
{
intFalg = 1;//添加成功
}
return(intFalg);
}
catch (Exception ee)
{
return(intFalg);
}
}// end if
public void tbTelRecordAdd(string stringId, int intChannel)
{
tbTelRecordClass tbClass = new tbTelRecordClass();
tbTelRecordMenthod tbMenhod = new tbTelRecordMenthod();
tbCustomerMethod tbCustom = new tbCustomerMethod();
tbCustomerClass tbCuClass = new tbCustomerClass();
tbClass.strfldTel = stringId;
tbClass.daSearchDate = DateTime.Now;
tbClass.shfldChannel = intChannel;
if (intLY == 1)
{
tbCuClass.kuTel = stringId;
tbCuClass.kuOffice = stringId;
int intFalgTel = DataGridFalg(tbCustom.tbCustomerSecarf(tbCuClass, "khTel"), DataGridViewCount(tbCustom.tbCustomerSecarf(tbCuClass, "khTel")));
tbClass.strsType = "打入";
}
if (intLY == 0)
{
tbClass.strsType = "打出";
}
tbMenhod.tbTelRecordAdd(tbClass);
intLY = 0;
}
}// end if
#endregion
#region//查询客户信息，返回，OleDbDataReader对象
public OleDbDataReader tbCustomerSecarf(tbCustomerClass Customer, string strFalg)
{
string strSecarf = null;
try
{
tbDai = new tbDaiConnection();
oledCon = tbDai.OledCon();
switch (strFalg)
{
case "khID": //客户ID
strSecarf = "select * from tb_Customer where khID='" + Customer.khID + "'";
break;
case "LikekhID": //客户ID
if (Customer.khID == "")
{
strSecarf = "select * from tb_Customer where kuFalg= 0";
}
else
{
strSecarf = "select * from tb_Customer where khID like '%" + Customer.khID + "%' and kuFalg= 0";
}
break;
case "khName": //客户姓名
strSecarf = "select * from tb_Customer where khPi='" + Customer.khPi + "' and kuFalg= 0";
break;
case "LikekhName": //客户姓名
if (Customer.khPi != "")
{
strSecarf = "select * from tb_Customer where khPi like'%" + Customer.khPi + "%' and kuFalg= 0";
}
else
{
strSecarf = "select * from tb_Customer where kuFalg= 0";
}
// "select * from tb_TelSend where TelContent like '%" + textBox1.Text + "%'";
break;
case "kuComputy": //公司姓名
strSecarf = "select * from tb_Customer where khName='" + Customer.khName + "'and kuFalg= 0 ";
break;
case "kuComputylike": //公司姓名
if (Customer.khName != "")
{
strSecarf = "select * from tb_Customer where khName like'%" + Customer.khName + "%' and kuFalg= 0";
}
else
{
strSecarf = "select * from tb_Customer where kuFalg= 0";
}
break;
case "khTel": //电话查询
strSecarf = "select * from tb_Customer where khTel='" + Customer.kuTel + "' or kuOffice='" + Customer.kuOffice + "'";
break;
case "khTelLike": //电话查询
if (Customer.kuTel != "" || Customer.kuOffice != "")
{
strSecarf = "select * from tb_Customer where khTel like '%" + Customer.kuTel + "%' or kuOffice like '%" + Customer.kuOffice + "%'";
}
else
{
strSecarf = "select * from tb_Customer where kuFalg= 0";
}
break;
}
oledCmd = new OleDbCommand(strSecarf, oledCon);
oledDr = oledCmd.ExecuteReader();//
return(oledDr);
}
catch (Exception ee)
{
return(oledDr);
}
}// end if