private void T_CustID_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
//Dictionary<string, string> findFields = new Dictionary<string, string>();
//findFields.Add("CustID", "s");
//findFields.Add("CustName", "s");
//Dictionary<string,string> displayFields = new Dictionary<string,string>();
//displayFields.Add("CustID", "客户编码");
//displayFields.Add("CustName", "客户名称");
//displayFields.Add("communicateAddr", "通信地址");
//displayFields.Add("AtBank", "开户银行");
//InitFuncs.FindInfoToControl(textBox, "T_CustomerInf", "CustID", findFields, displayFields);
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string strSql = "select CustID as 客户编码,CustName as 客户名称,"
+ "PinYinCode as 助记符,communicateAddr as 通信地址, "
+ "Degree as 客户等级 " +
"from T_CustomerInf where CustID like '%{0}%' or CustName like '%{1}%' or PinYinCode like '%{2}%'";
strSql = string.Format(strSql, textBoxName, textBoxName, textBoxName);
InitFuncs.FindInfoToControl(textBox, strSql, "客户名称");
}
}
private void textBox1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string strSql = "select CustID as 客户编码,CustName as 客户名称,"
+ "PinYinCode as 助记符,communicateAddr as 通信地址, "
+ "Degree as 客户等级 " +
"from T_CustomerInf where CustID like '%{0}%' or CustName like '%{1}%' or PinYinCode like '%{2}%'";
strSql = string.Format(strSql, textBoxName, textBoxName, textBoxName);
InitFuncs.FindInfoToControl(textBox, strSql, "客户名称");
}
}
private void T_Puser_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
TextBox textBox = sender as TextBox;
string textBoxName = textBox.Text.Trim();
if (textBoxName == "")
{
return;
}
string strSql = "select T_Users.UserID as 人员编号,"
+ "T_Users.UserName as 姓名,"
+ "T_Users.UserNameZJM as 助记符,"
+ " T_Branch.BName as 部门, "
+ " T_Users.groups as 组别"
+ " from T_Users, T_Branch"
+ " where T_Users.BranchId=T_Branch.bid "
+ " and ( UserID like '%{0}%' or UserName like '%{1}%'"
+ " or UserNameZJM like '%{2}%' or BName like '%{3}%'"
+ " or groups like '%{4}%')";
strSql = string.Format(strSql, textBoxName, textBoxName, textBoxName, textBoxName, textBoxName);
InitFuncs.FindInfoToControl(textBox, strSql, "姓名");
}
}