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