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
}//
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;
}
