//条件查询
private void button_inquery_Click(object sender, EventArgs e)
{
if (CValidateTools.containsBlank(textBox_QueryKey.Text))
{
CValidateTools.showError("关键字不合法！");
return;
}
/* 一种过滤数据的方法
*
* string strQuery = @" select u1.AdmName as 用户名, u1.cName as 姓名, u1.userNumber as 编号, d1.depName as 所属部门, r1.roleName as 角色, u1.AddDate as 创建时间 from userInfo u1, department d1, role r1
* where u1.roleID = r1.ID and u1.depCID = d1.categroyID and u1.depID = d1.depID and d1.categroyID = 2 and #col like '%#value%' and depCID = 2 ";
* string str = strQuery;
* if (comboBox_queryCol.SelectedIndex == 0)
* str = str.Replace("#col", "userNumber").Replace("#value", textBox_QueryKey.Text );
* else if(comboBox_queryCol.SelectedIndex == 1)
* str = str.Replace("#col", "admName").Replace("#value", textBox_QueryKey.Text);
* else
* str = str.Replace("#col", "cName").Replace("#value", textBox_QueryKey.Text);
*
*
* dview_UserInfo.rows
*
* ADOHelper db = new ADOHelper();
* if (db.ExecuteGet(str) == null)
* return;
*
* dview_UserInfo.DataBindings.Clear();
* dview_UserInfo.DataSource = db.ExecuteGet(str).Tables[0];
*
*
* */
//另一种过滤数据的方法
string str = "#col like '%#value%' ";
if (comboBox_queryCol.SelectedIndex == 0)
{
str = str.Replace("#col", "编号").Replace("#value", textBox_QueryKey.Text);
}
else if (comboBox_queryCol.SelectedIndex == 1)
{
str = str.Replace("#col", "用户名").Replace("#value", textBox_QueryKey.Text);
}
else
{
str = str.Replace("#col", "姓名").Replace("#value", textBox_QueryKey.Text);
}
string strQuery = @" select u1.AdmName as 用户名, u1.cName as 姓名, u1.userNumber as 编号, d1.depName as 所属部门, r1.roleName as 角色, u1.AddDate as 创建时间 from userInfo u1, department d1, role r1
where u1.roleID = r1.ID and u1.depCID = d1.categroyID and u1.depID = d1.depID and d1.categroyID = " + DevTools.getDepartmentId();
ADOHelper db = new ADOHelper();
DataView dvNewDataViewObject = new DataView();
dvNewDataViewObject.Table = db.ExecuteGet(strQuery).Tables[0];
dvNewDataViewObject.RowFilter = str;
dview_UserInfo.DataBindings.Clear();
dview_UserInfo.DataSource = dvNewDataViewObject;
}
