第7讲 多项选择框CheckBoxComboBox实现组合查询.pptVIP

CheckBoxComboBox界面 操作步骤 将CheckBoxComboBox加到工具箱 将控件CheckBoxComboBox加入窗体 动态加载CheckBoxComboBox数据源 调用CheckBoxComboBox的Text 1.加入到工具箱 右击工具栏,选择[添加选项卡]命令 输入选项卡名称:CheckBoxComboBox 将CheckBoxComboBox.dll拖至此文本可将其添加到箱. 2.将控件CheckBoxComboBox加入窗体 加入三个CheckBoxComboBox控件 楼宇:cbBilding 宿舍性别:cbSex 宿舍性质:cbType 3.动态加载数据源 private DataTable dtBuilding,dtSex,dtType; dtBuilding=SqlHelper.CmdDataSet(SELECT BuildingID,BuildingName FROM B_Building); foreach (DataRow dr in dtBuilding.Rows) { cbBilding.Items.Add(dr[BuildingName].ToString()); } 获取字典数据方法 dtSex = SqlHelper.BaseGetParaList(宿舍性别).Tables[0]; foreach (DataRow dr in dtSex.Rows) { cbSex.Items.Add(dr[Para_Name].ToString()); } 4.调用CheckBoxComboBox过滤数据 string s = cbBilding.Text; //格式:1号楼, 2号楼,3号楼 string sFilter = HouseID0 ; if (s.IndexOf(全部) 0) { foreach (DataRow dr in dtBuilding.Rows) { s = s.Replace(dr[“BuildingName”].ToString(), dr[“BuildingID”].ToString());//把楼宇名称替换成代码 } //生成过滤条件 if (!string.IsNullOrEmpty(s)) sFilter += string.Format( and (BuildingID in ({0})), s); } 处理宿舍性别选项cbSex s = ckbSex.Text; foreach (DataRow dr in dtSex.Rows) { oldValue = dr[Para_Name].ToString(); newValue = string.Format({0}, oldValue); s = s.Replace(oldValue, newValue); } if (!string.IsNullOrEmpty(s)) sFilter += string.Format( and (Sex in ({0})), s); 处理宿舍性质选项cbType s = ckbType.Text; foreach (DataRow dr in dtType.Rows) { oldValue = dr[Para_Name].ToString(); newValue = string.Format({0}, oldValue); s = s.Replace(oldValue, newValue); } if (!string.IsNullOrEmpty(s)) sFilter += string.Format( and (HouseType in ({0})), s); 处理宿舍名称条件 s = Ho