private IList <aers_tbl_hospdep> GetDepartment()
{
aers_tbl_hospdepSqlMapDao ad = new aers_tbl_hospdepSqlMapDao();
IList <aers_tbl_hospdep> codelist = ad.hospdepFindAll();
return(codelist);
}
public void DataBind()
{
IList <aers_tbl_hospdep> list = dal.hospdepFindAll();
IList <aers_tbl_hospital> listhospital = dalhospital.hospitalFindAll();
foreach (aers_tbl_hospdep item in list)
{
aers_tbl_hospital hospital = listhospital.FirstOrDefault(o => o.HospId == item.HospId);
if (hospital != null)
{
item.HospName = hospital.HospName;
}
}
string Pram = txtfind.Text.Trim();
if (!string.IsNullOrEmpty(Pram))
{
list = list.Where(o => o.HospName.Contains(Pram) || o.HospdepName.Contains(Pram)).ToList();
}
this.gridControl1.DataSource = new BindingList <aers_tbl_hospdep>(list);;
lblcount.Text = "共 " + list.Count + " 条";
}
private void OperatorForm_Load(object sender, EventArgs e)
{
IList <aers_tbl_hospital> listhospital = dalhospital.hospitalFindAll();
this.txt_HospId.Properties.DisplayMember = "HospName";
this.txt_HospId.Properties.ValueMember = "HospId";
this.txt_HospId.Properties.DataSource = listhospital;
IList <aers_tbl_hospdep> listhospdep = dalhospdep.hospdepFindAll();
this.txt_HospdepId.FieldValue = "HospdepName";
this.txt_HospdepId.DisplayValue = "HospdepName";
this.txt_HospdepId.DataSource = listhospdep;
}
private void txt_HospId_EditValueChanged(object sender, EventArgs e)
{
string HospId = txt_HospId.EditValue.ToString();
IList <aers_tbl_hospdep> listhospdep = dalhospdep.hospdepFindAll();
IList <aers_tbl_staff> liststaff = dalstaff.staffFindAll();
foreach (aers_tbl_staff item in liststaff)
{
aers_tbl_hospdep hospdep = listhospdep.FirstOrDefault(o => o.HospdepId == item.DepId);
if (hospdep != null)
{
item.HospId = hospdep.HospId;
item.HospdepName = hospdep.HospdepName;
}
}
this.txt_HospdepId.FieldValue = "HospdepId";
this.txt_HospdepId.DisplayValue = "HospdepName";
this.txt_HospdepId.DataSource = listhospdep.Where(o => o.HospId == HospId).ToList();
}
