private void tsbQuery_Click(object sender, EventArgs e) { string[,] strsQueryTmp = new string[2, 2]; DataTable[] dt = new DataTable[strsQueryTmp.GetLongLength(0)]; strsQueryTmp[0, 0] = "单位编号"; strsQueryTmp[1, 0] = "单位名称"; strsQueryTmp[0, 1] = "txt"; strsQueryTmp[1, 1] = "txt"; FrmQueryCondition f = new FrmQueryCondition(strsQueryTmp, dt); f.ShowDialog(); string strFilter; strFilter = "UnitNo like '*" + strsQueryTmp[0, 1] + "*' " + "and UnitName like '*" + strsQueryTmp[1, 1] + "*'"; this.bS_UnitCatgBindingSource.Filter = strFilter; }
private void tsbQuery_Click(object sender, EventArgs e) { string[,] strsQueryTmp = new string[3, 2]; DataTable[] dt = new DataTable[strsQueryTmp.GetLongLength(0)]; strsQueryTmp[0, 0] = "部门编号"; strsQueryTmp[1, 0] = "部门名称"; strsQueryTmp[2, 0] = "上级部门编号"; strsQueryTmp[0, 1] = "txt"; strsQueryTmp[1, 1] = "cbo"; strsQueryTmp[2, 1] = "txt"; dt[1] = BSCommon.getDepartmentList();//下标代表代号 FrmQueryCondition f = new FrmQueryCondition(strsQueryTmp, dt); f.ShowDialog(); string strFilter; strFilter = "DepartmentNo like '*" + strsQueryTmp[0, 1] + "*' " + "and DepartmentNo like '*" + strsQueryTmp[1, 1] + "*' " + "and ParentDepartmentNo like '*" + strsQueryTmp[2, 1] + "*'"; this.bS_DepartmentBindingSource.Filter = strFilter; }
/// <summary> /// 筛选绑定数据源中的数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsbQuery_Click(object sender, EventArgs e) { string[,] strsQueryTmp = new string[3, 2]; DataTable[] dt = new DataTable[strsQueryTmp.GetLongLength(0)]; strsQueryTmp[0, 0] = "用户ID"; strsQueryTmp[1, 0] = "用户姓名"; strsQueryTmp[2, 0] = "部门名称"; strsQueryTmp[0, 1] = "txt"; strsQueryTmp[1, 1] = "txt"; strsQueryTmp[2, 1] = "cbo"; dt[2] = BSCommon.getDepartmentList(); FrmQueryCondition f = new FrmQueryCondition(strsQueryTmp, dt); f.ShowDialog(); string strFilter; strFilter = "LoginId like '*" + strsQueryTmp[0, 1] + "*' " + "and EmpName like '*" + strsQueryTmp[1, 1] + "*' " + "and departmentNo like '*" + strsQueryTmp[2, 1] + "*'"; this.bS_UserInfoBindingSource.Filter = strFilter; }