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