//条件查询 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; }