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