public SysUserCollection FetchAll() { SysUserCollection coll = new SysUserCollection(); Query qry = new Query(SysUser.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public SysUserCollection FetchByQuery(Query qry) { SysUserCollection coll = new SysUserCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public SysUserCollection FetchByID(object PkSuid) { SysUserCollection coll = new SysUserCollection().Where("PK_sUID", PkSuid).Load(); return coll; }
private void InitialData() { try { //Khởi tạo danh mục loại nhân viên DataTable v_dtStaffTypeList = THU_VIEN_CHUNG.LayDulieuDanhmucChung("LOAINHANVIEN",true); // v_dtStaffTypeList = cboStaffType.DataSource = v_dtStaffTypeList.DefaultView; v_dtStaffTypeList.DefaultView.Sort = DmucChung.Columns.SttHthi; cboStaffType.ValueMember = DmucChung.Columns.Ma; cboStaffType.DisplayMember =DmucChung.Columns.Ten; //Khởi tạo danh mục chức vụ //Khởi tạo danh mục phòng ban m_dtDepartmentList = THU_VIEN_CHUNG.Laydanhmuckhoa("ALL", -1); DataBinding.BindData(cboUpLevel, m_dtDepartmentList, DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.TenKhoaphong); cboUpLevel_SelectedIndexChanged(cboUpLevel,new EventArgs()); //Khởi tạo danh mục User DataTable v_dtUserList = new SysUserCollection().Load().ToDataTable(); Utility.AddColumnAlltoUserDataTable(ref v_dtUserList, SysUser.Columns.PkSuid, ""); v_dtUserList.DefaultView.Sort = SysUser.Columns.PkSuid+" ASC"; txtUID.Init(v_dtUserList, new List<string>() { SysUser.Columns.PkSuid, SysUser.Columns.PkSuid, SysUser.Columns.PkSuid }); m_dtKhoThuoc = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA(); Utility.SetDataSourceForDataGridEx(grdKhoThuoc, m_dtKhoThuoc, false, true, "1=1", TDmucKho.Columns.SttHthi); m_dtPhongkham = THU_VIEN_CHUNG.LaydanhmucPhong(0); Utility.SetDataSourceForDataGridEx(grdPhongkham, m_dtPhongkham, false, true, "1=1", VDmucKhoaphong.Columns.SttHthi); m_dtKhoangoaitru = THU_VIEN_CHUNG.Laydanhmuckhoa("NGOAI",0); Utility.SetDataSourceForDataGridEx(grdKhoa, m_dtKhoangoaitru, false, true, "1=1", VDmucKhoaphong.Columns.SttHthi); m_dtKhoanoitru = THU_VIEN_CHUNG.Laydanhmuckhoa("NOI",0); Utility.SetDataSourceForDataGridEx(grdKhoanoitru, m_dtKhoanoitru, false, true, "1=1", VDmucKhoaphong.Columns.SttHthi); } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }