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