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