/// <summary> /// hà thực hiện khởi tạo thông tin của Form /// </summary> private void InitalData() { try { dtDept = THU_VIEN_CHUNG.Laydanhmuckhoa("NGOAI", 0); //Khởi tạo danh mục Loại khám DataTable v_ExamTypeList = new DmucKieukhamCollection().Load().ToDataTable(); Utility.AddColumnAlltoDataTable(ref v_ExamTypeList, DmucDichvukcb.Columns.IdKieukham, DmucKieukham.Columns.TenKieukham, "====Chọn===="); v_ExamTypeList.DefaultView.Sort = DmucKieukham.Columns.SttHthi + " ASC"; cboLoaiKham.DataSource = v_ExamTypeList.DefaultView; cboLoaiKham.ValueMember = DmucDichvukcb.Columns.IdKieukham; cboLoaiKham.DisplayMember = DmucKieukham.Columns.TenKieukham; cboLoaiKham.SelectedValue = -1; //Khởi tạo danh mục Loại khám DataTable v_ObjectTypeList = new DmucDoituongkcbCollection().Load().ToDataTable(); Utility.AddColumnAlltoDataTable(ref v_ObjectTypeList, DmucDichvukcb.Columns.IdDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb, "====Chọn===="); v_ObjectTypeList.DefaultView.Sort = DmucDoituongkcb.Columns.SttHthi + " ASC"; cboDoituong.DataSource = v_ObjectTypeList.DefaultView; cboDoituong.ValueMember = DmucDichvukcb.Columns.IdDoituongKcb; cboDoituong.DisplayMember = DmucDoituongkcb.Columns.TenDoituongKcb; //Phòng ban BindDepartment(); } catch { } }
public DmucKieukhamCollection FetchAll() { DmucKieukhamCollection coll = new DmucKieukhamCollection(); Query qry = new Query(DmucKieukham.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
/// <summary> /// hàm thực hiện khởi tạo thông tin /// </summary> private void InitData() { try { dtDept = THU_VIEN_CHUNG.Laydanhmuckhoa("NGOAI", 0); //Khởi tạo danh mục Loại khám DataTable v_ExamTypeList = new DmucKieukhamCollection().Load().ToDataTable(); cboLoaiKham.DataSource = v_ExamTypeList.DefaultView; cboLoaiKham.ValueMember = DmucDichvukcb.Columns.IdKieukham; cboLoaiKham.DisplayMember = DmucKieukham.Columns.TenKieukham; //Khởi tạo danh mục Loại khám v_ObjectTypeList = new Select().From(DmucDoituongkcb.Schema).ExecuteDataSet().Tables[0]; //Utility.AddColumnAlltoDataTable(ref v_ObjectTypeList, DmucDoituongkcb.Columns.IdDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb, "====Chọn===="); //v_ObjectTypeList.DefaultView.Sort = DmucDoituongkcb.Columns.SttHthi; DataBinding.BindDataCombox(cboDoituong, v_ObjectTypeList, DmucDoituongkcb.Columns.IdDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb); //cboDoituong.DataSource = v_ObjectTypeList.DefaultView; //cboDoituong.ValueMember = DmucDoituongkcb.Columns.IdDoituongKcb; //cboDoituong.DisplayMember = DmucDoituongkcb.Columns.TenDoituongKcb; //Phòng ban BindDepartment(); } catch (Exception ex) { Utility.ShowMsg("Lỗi:" + ex.Message); } }
/// <summary> /// hà thực hiện khởi tạo thông tin của Form /// </summary> private void InitalData() { try { dtDept = THU_VIEN_CHUNG.Laydanhmuckhoa("NGOAI",0); //Khởi tạo danh mục Loại khám DataTable v_ExamTypeList = new DmucKieukhamCollection().Load().ToDataTable(); Utility.AddColumnAlltoDataTable(ref v_ExamTypeList, DmucDichvukcb.Columns.IdKieukham, DmucKieukham.Columns.TenKieukham, "====Chọn===="); v_ExamTypeList.DefaultView.Sort =DmucKieukham.Columns.SttHthi+ " ASC"; cboLoaiKham.DataSource = v_ExamTypeList.DefaultView; cboLoaiKham.ValueMember = DmucDichvukcb.Columns.IdKieukham; cboLoaiKham.DisplayMember = DmucKieukham.Columns.TenKieukham; cboLoaiKham.SelectedValue = -1; //Khởi tạo danh mục Loại khám DataTable v_ObjectTypeList = new DmucDoituongkcbCollection().Load().ToDataTable(); Utility.AddColumnAlltoDataTable(ref v_ObjectTypeList, DmucDichvukcb.Columns.IdDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb, "====Chọn===="); v_ObjectTypeList.DefaultView.Sort =DmucDoituongkcb.Columns.SttHthi+ " ASC"; cboDoituong.DataSource = v_ObjectTypeList.DefaultView; cboDoituong.ValueMember = DmucDichvukcb.Columns.IdDoituongKcb; cboDoituong.DisplayMember = DmucDoituongkcb.Columns.TenDoituongKcb; //Phòng ban BindDepartment(); } catch { } }
public DmucKieukhamCollection FetchByQuery(Query qry) { DmucKieukhamCollection coll = new DmucKieukhamCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public DmucKieukhamCollection FetchByID(object IdKieukham) { DmucKieukhamCollection coll = new DmucKieukhamCollection().Where("id_kieukham", IdKieukham).Load(); return coll; }