/// <summary> /// 初始化宿舍列表 /// </summary> private void init_dormitory() { Student.BLL.DORMITORY_INFO dormitoryBll = new Student.BLL.DORMITORY_INFO(); DataSet ds = dormitoryBll.GetAllList(); this.cbb_plate.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; cbb_plate.Properties.Items.Clear(); cbb_plate.EditValue = null; cbb_plate.Properties.NullText = "--请选择--"; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string plateName = ds.Tables[0].Rows[i]["DORMITORY_PLATE"].ToString(); this.cbb_plate.Properties.Items.Add(plateName); } }
/// <summary> /// 查询数据 /// </summary> private void ReadData() { string condition = ""; if (this.cbb_buildingname.SelectedIndex != -1) { condition += " and A.BUILDINGNAME ='" + this.cbb_buildingname.Properties.Items[this.cbb_buildingname.SelectedIndex].ToString() + "' "; } if (this.te_plate.Text.Length > 0) { condition += "and B.DORMITORY_PLATE like '%" + this.te_plate.Text + "%'"; } Student.BLL.DORMITORY_INFO dormitoryBll = new Student.BLL.DORMITORY_INFO(); this.gridControl1.DataSource = dormitoryBll.GetList(condition).Tables[0]; this.gridView1.BestFitColumns(); DBUtility.ToolHelper.DrawRowIndicator(gridView1, 40); DBUtility.ToolHelper.SetLineColorofGridView(this.gridView1); }