private void FillStatusListBox()
{
_dtTestStatus = TestInfoBusiness.GetTestStatusList();
DataBinding.BindData(clbStatus, _dtTestStatus, "TestStatus_ID",
"TestStatus_Name");
SetAllCheckedBoxTrue(clbStatus);
}
/// <summary>
/// load thông tin
/// của form hiện tai
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frm_baocao_nhapkho_chitiet_Load(object sender, EventArgs e)
{
baocaO_TIEUDE1.Init("thuoc_baocaochitiet_nhapkho");
DataBinding.BindData(cboKho, KIEU_THUOC_VT == "THUOC" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(), TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho);
AutocompleteThuoc();
}
private void cboUpLevel_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dataTable = new DataTable();
dataTable = THU_VIEN_CHUNG.Laydanhsachphongthuockhoa(Utility.Int32Dbnull(cboUpLevel.SelectedValue, -1), -1);
DataBinding.BindData(cboDepart, dataTable, DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.TenKhoaphong);
}
/// <summary>
/// load thông tin
/// của form hiện tai
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frm_Sochitietvatlieu_Load(object sender, EventArgs e)
{
if (KIEU_THUOC_VT == "THUOC")
{
baocaO_TIEUDE1.Init("thuoc_sochitietvatlieu");
}
else
{
baocaO_TIEUDE1.Init("vt_sochitietvatlieu");
}
DataBinding.BindData(cboKho,
KieuKho == "ALL"
? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA()
: (KieuKho == "CHAN"
? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN()
: CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE()), TDmucKho.Columns.IdKho,
TDmucKho.Columns.TenKho);
DataTable m_dtNhomThuoc = new Select().From(DmucLoaithuoc.Schema)
.OrderAsc(DmucLoaithuoc.Columns.SttHthi).ExecuteDataSet().Tables[0];
allowChanged = true;
cboKho_SelectedIndexChanged(cboKho, e);
cboThang.SelectedIndex = globalVariables.SysDate.Month - 1;
}
private void FillTestTypeList()
{
try
{
//Xóa trắng Checklistbox
clbTestType.DataSource = null;
clbTestType.Items.Clear();
dtTestTypeList = TestTypeListBusiness.GetAllTestTypeList();
DataBinding.BindData(clbTestType, dtTestTypeList, TTestTypeList.Columns.TestTypeId,
TTestTypeList.Columns.TestTypeName);
SetAllCheckedBoxTrue(clbTestType);
////Thiết lập chiều rộng tự động cho lưới hiển thị
//clbTestType.ColumnWidth =
// MkStrWidth(dtTestTypeList, clbTestType.Font, TTestTypeList.Columns.TestTypeName) + 20;
}
catch (Exception ex)
{
throw ex;
}
}
private void Load_LyDo()
{
DataTable dt_LyDo =
new Select("*").From(HoadonTrangthai.Schema).Where(HoadonTrangthai.Columns.MessageType).IsEqualTo("LyDoInHD").
OrderAsc(HoadonTrangthai.Columns.MessageOrder).ExecuteDataSet().Tables[0];
DataBinding.BindData(cboLy_Do, dt_LyDo, HoadonTrangthai.Columns.MessageId, HoadonTrangthai.Columns.MessageName);
}
private void LoadTestType()
{
dtTestType =
new Select().From(TTestTypeList.Schema.Name).OrderAsc(TTestTypeList.Columns.IntOrder).ExecuteDataSet().
Tables[0];
DataBinding.BindData(cboTestType, dtTestType, TTestTypeList.Columns.TestTypeId,
TTestTypeList.Columns.TestTypeName);
}
/// <summary>
/// khởi tạo thông tin của Form
/// </summary>
private void IntialData()
{
DataBinding.BindData(cboSurveys, m_dtTinh_Thanhpho, DmucDiachinh.Columns.MaDiachinh, DmucDiachinh.Columns.TenDiachinh);
if (em_Action == action.Insert)
{
txtIntOrder.Value = Utility.Int32Dbnull(Query.GetMax(DmucNoiKCBBD.Columns.SttHthi)) + 1;
}
}
private void LoadAssignDoctor()
{
DataTable dtDoctor = new Select().From(LUser.Schema.Name).ExecuteDataSet().Tables[0];
DataRow dr = dtDoctor.NewRow();
dr[LUser.Columns.UserId] = -1;
dr[LUser.Columns.UserName] = "-----Chọn Bác Sỹ-----";
dtDoctor.Rows.InsertAt(dr, 0);
DataBinding.BindData(cboAssignDoctor, dtDoctor, LUser.Columns.UserId, LUser.Columns.UserName);
}
private void LoadTrangThai()
{
DataTable dtTrang_Thai =
new Select("*").From(HoadonTrangthai.Schema).Where(HoadonTrangthai.Columns.MessageType).
IsEqualTo("CapPhatHD").OrderAsc(HoadonTrangthai.Columns.MessageOrder).
ExecuteDataSet().Tables[0];
DataBinding.BindData(cboTrang_Thai, dtTrang_Thai, "Message_ID", "Message_Name");
cboTrang_Thai.SelectedIndex = 0;
}
private void LoadKhoTheoVatTuThuoc()
{
if (radPhieuThuoc.Checked)
{
m_dtKhoThuoc = LoadDataCommon.CommonLoadDuoc.LayThongTinKhoKeNoiTruThuoc(Utility.sDbnull(cboDoiTuong.SelectedValue));
}
else
{
m_dtKhoThuoc =
LoadDataCommon.CommonLoadDuoc.LayThongTinKhoKeNoiTruVatTu(Utility.sDbnull(cboDoiTuong.SelectedValue));
}
DataBinding.BindData(cboKho, m_dtKhoThuoc, DKho.Columns.IdKho, DKho.Columns.TenKho);
}
/// <summary>
/// load thông tin
/// của form hiện tai
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frm_baocao_huythuoc_Load(object sender, EventArgs e)
{
if (KIEU_THUOC_VT == "THUOC")
{
baocaO_TIEUDE1.Init("thuoc_baocao_huythuoc");
}
else
{
baocaO_TIEUDE1.Init("vt_baocao_huyvt");
}
txtLydohuy.Init();
DataBinding.BindData(cboKho, KIEU_THUOC_VT == "THUOC" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_TATCA(), TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho);
AutocompleteThuoc();
}
/// <summary>
/// hàm thực hiện khởi tạo thông tin
/// </summary>
private void InitalData()
{
m_dtGroupInsurance = THU_VIEN_CHUNG.LayDulieuDanhmucChung("NHOMBHYT", true);
m_dtObjectType =
new Select().From(DmucDoituongkcb.Schema).Where(DmucDoituongkcb.Columns.IdLoaidoituongKcb).IsEqualTo(0).
ExecuteDataSet().Tables[0];
DataBinding.BindData(cboInsuranceGroupID, m_dtGroupInsurance, DmucChung.Columns.Ma, DmucChung.Columns.Ten);
DataBinding.BindData(cboObjectTypeID, m_dtObjectType, DmucDoituongkcb.Columns.IdDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb);
DataTable mdtMaQuyenLoi = THU_VIEN_CHUNG.LayDulieuDanhmucChung("MAQUYENLOIBHYT", true);
Utility.SetDataSourceForDataGridEx(chkMaQuyenLoi, mdtMaQuyenLoi, false, true, "1=1", "");
}
private void frm_baocao_nhapthuoctheoNhacungcap_Load(object sender, EventArgs e)
{
if (KIEU_THUOC_VT == "THUOC")
{
baocaO_TIEUDE1.Init("thuoc_baocao_nhapkho_theonhacungcap");
}
else
{
baocaO_TIEUDE1.Init("vt_baocao_nhapkho_theonhacungcap");
}
txtNhacungcap.Init();
DataBinding.BindData(cboKho, KIEU_THUOC_VT == "THUOC" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_TATCA(), TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho);
AutocompleteThuoc();
AutocompleteLoaithuoc();
}
private void LoadDoctorList()
{
dtDoctor = new Select().From(SysUser.Schema.Name).ExecuteDataSet().Tables[0];
dtDoctor.Columns.Add("DisplayUser");
foreach (DataRow dr in dtDoctor.Rows)
{
dr["DisplayUser"] = dr[SysUser.Columns.PkSuid];
}
DataRow dataRow = dtDoctor.NewRow();
dataRow["DisplayUser"] = "";
dataRow[SysUser.Columns.PkSuid] = "-1";
dtDoctor.Rows.InsertAt(dataRow, 0);
DataBinding.BindData(cboUserName, dtDoctor, SysUser.Columns.PkSuid, "DisplayUser");
}
private void LoadComboBox()
{
DataTable testType = new Select(TTestTypeList.Columns.TestTypeId, TTestTypeList.Columns.TestTypeName).From(
TTestTypeList.Schema).ExecuteDataSet().Tables[0];
DataBinding.BindDataCombox(cboTestType, testType, TTestTypeList.Columns.TestTypeId,
TTestTypeList.Columns.TestTypeName, "-----Chọn loại xét nghiệm-----");
DataTable userName = new Select(SysUser.Columns.PkSuid, SysUser.Columns.SFullName).From(
SysUser.Schema).ExecuteDataSet().Tables[0];
var row = userName.NewRow();
row["PK_sUID"] = "ADMIN";
row["sFullName"] = "ADMIN";
userName.Rows.Add(row);
DataBinding.BindDataCombox(cboUserName, userName, SysUser.Columns.SFullName,
SysUser.Columns.PkSuid, "-----Chọn tài khoản-----");
//cboUserName.DataSource = userName;
//cboUserName.ValueMember = TblUser.Columns.PkSuid;
//cboUserName.DisplayMember = TblUser.Columns.PkSuid;
DataTable reportType = new DataTable();
reportType.Columns.Add("reportTypeId");
reportType.Columns.Add("reportType");
for (int i = 0; i < 2; i++)
{
var rows = reportType.NewRow();
switch (i)
{
case 0:
rows["reportTypeId"] = 0;
rows["reportType"] = "Chi tiết";
break;
case 1:
rows["reportTypeId"] = 1;
rows["reportType"] = "Tổng hợp";
break;
}
reportType.Rows.Add(rows);
}
DataBinding.BindData(cboReportType, reportType, "reportTypeId", "reportType");
cboReportType.SelectedIndex = 1;
}
public void Init()
{
dtPrintDate.Value = globalVariables.SysDate;
dtpFromDate.Value = globalVariables.SysDate;
dtpToDate.Value = globalVariables.SysDate;
DataBinding.BindData(cboObject, THU_VIEN_CHUNG.LaydanhsachDoituongKcb(new List <string>()
{
"BHYT"
}),
DmucDoituongkcb.Columns.MaDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb);
baocaO_TIEUDE1.Init("BHYT_14A_MOI");
txtNhomBHYT.Init();
}
void InitData()
{
try
{
_dtPrintColor = new Select().From(SysPrintColor.Schema).ExecuteDataSet().Tables[0];
_dtPrintColorDetail = new Select().From(SysPrintColorDetail.Schema).ExecuteDataSet().Tables[0];
DataTable dtTestTypeList = TestTypeListBusiness.GetAllTestTypeList();
DataBinding.BindData(cboTestTypeList, dtTestTypeList, TTestTypeList.Columns.TestTypeId,
TTestTypeList.Columns.TestTypeName);
CreateTreeView();
tvwColorConfig.Nodes[0].ExpandAll();
}
catch
{
}
}
private void frm_phatthuoc_ngoaitru_Load(object sender, EventArgs e)
{
if (kieuthuoc_vt == "THUOC")
{
m_dtKhothuoc = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE();
}
else
{
m_dtKhothuoc = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> {
"TATCA", "NGOAITRU"
});
}
DataBinding.BindData(cboKho, m_dtKhothuoc,
TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho);
dtNgayPhatThuoc.Value = globalVariables.SysDate;
TimKiemThongTinDonThuoc();
txtPID.Focus();
txtPID.SelectAll();
}
private void frmTestTypeList_AU_Load(object sender, EventArgs e)
{
try
{
DataTable dtTestType = new Select().From(TTestTypeList.Schema.Name).
OrderAsc(TTestTypeList.Columns.IntOrder).ExecuteDataSet().Tables[0];
DataBinding.BindData(cboTestType, dtTestType, "TestType_ID", "TestType_Name");
if (!string.IsNullOrEmpty(txtID.Text))
{
LoadData();
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
Close();
}
}
private void frm_ChotcapphatThuoc_ngoaitru_Load(object sender, EventArgs e)
{
DataBinding.BindDataCombobox(cboObjectType, THU_VIEN_CHUNG.LaydanhsachDoituongKcb(),
DmucDoituongkcb.Columns.MaDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb, "---Chọn---", true);
if (kieuthuoc_vt == "THUOC")
{
m_dtKhothuoc = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE_NGOAITRU();
}
else
{
m_dtKhothuoc = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> {
"NGOAITRU"
});
}
DataBinding.BindData(cboKho, m_dtKhothuoc,
TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho);
TimKiemThongTinDonThuoc();
ModifyCommand();
CauHinh();
}
private void frm_ChooseIn_Load(object sender, EventArgs e)
{
if (!globalVariables.IsAdmin)
{
if (thamso.Equals("KHO"))
{
m_dtKhoaNoiTru = LoadDataCommon.CommonBusiness.LayThongTin_KhoaNoiTru();
DataBinding.BindDataCombox(cboKhoa, m_dtKhoaNoiTru, LDepartment.Columns.DepartmentId, LDepartment.Columns.DepartmentName, "--Khoa nội trú---");
}
else
{
m_dtKhoaNoiTru = LoadDataCommon.CommonBusiness.LayThongTin_KhoaNoiTruTheoKhoa(globalVariables.DepartmentID);
DataBinding.BindData(cboKhoa, m_dtKhoaNoiTru, LDepartment.Columns.DepartmentId, LDepartment.Columns.DepartmentName);
}
}
else
{
m_dtKhoaNoiTru = LoadDataCommon.CommonBusiness.LayThongTin_KhoaNoiTru();
DataBinding.BindDataCombox(cboKhoa, m_dtKhoaNoiTru, LDepartment.Columns.DepartmentId, LDepartment.Columns.DepartmentName, "--Khoa nội trú---");
}
}
private void frm_ChooseCapPhatNoiTru_Load(object sender, EventArgs e)
{
DataBinding.BindData(cboDoiTuong, LoadDataCommon.CommonBusiness.LayThongTin_DoiTuong(), LObjectType.Columns.ObjectTypeCode, LObjectType.Columns.ObjectTypeName);
if (thamso.Equals("KHOA"))
{
if (globalVariables.IsAdmin)
{
m_dtKhoa = LoadDataCommon.CommonBusiness.LayThongTin_KhoaNoiTru();
}
else
{
m_dtKhoa = LoadDataCommon.CommonBusiness.LayThongTin_KhoaNoiTruTheoKhoa(globalVariables.DepartmentID);
}
}
else
{
m_dtKhoa = LoadDataCommon.CommonBusiness.LayThongTin_KhoaNoiTruTheoKhoa(globalVariables.DepartmentID);
}
DataBinding.BindData(cboKhoa, m_dtKhoa, LDepartment.Columns.DepartmentId, LDepartment.Columns.DepartmentName);
LoadKhoTheoVatTuThuoc();
}
public void Init()
{
log = LogManager.GetCurrentClassLogger();
AutocompleteDmuc();
dtpNgayIn.Value = globalVariables.SysDate;
dtpFromDate.Value = globalVariables.SysDate;
dtpToDate.Value = globalVariables.SysDate;
baocaO_TIEUDE1.Init("BHYT_21A");
AutocompleteKcbbd();
DataBinding.BindData(cboObjectType, THU_VIEN_CHUNG.LaydanhsachDoituongKcb(new List <string> {
"DV", "BHYT"
}),
DmucDoituongkcb.Columns.MaDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb);
txtNhomBHYT.Init();
if (cboObjectType.DataSource != null && cboObjectType.Items.Count > 0)
{
cboObjectType.SelectedIndex = 0;
}
if (cboTuyen.Items.Count > 0)
{
cboTuyen.SelectedIndex = 0;
}
}
/// <summary>
/// load thông tin
/// của form hiện tai
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frm_baocao_tonkho_Load(object sender, EventArgs e)
{
DataTable dtkho = null;
if (KIEU_THUOC_VT == "THUOC")
{
baocaO_TIEUDE1.Init("thuoc_baocao_nhapxuatton_khochan");
dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE());
}
else
{
baocaO_TIEUDE1.Init("vt_baocao_nhapxuatton_khochan");
dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> {
"TATCA", "NGOAITRU", "NOITRU"
}));
}
DataBinding.BindData(cboKho, dtkho, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho);
DataTable m_dtNhomThuoc = new Select().From(DmucLoaithuoc.Schema).Where(DmucLoaithuoc.Columns.KieuThuocvattu).IsEqualTo(KIEU_THUOC_VT)
.OrderAsc(DmucLoaithuoc.Columns.SttHthi).ExecuteDataSet().Tables[0];
allowChanged = true;
cboKho_SelectedIndexChanged(cboKho, e);
}
private void frm_AddRedInvoice_Load(object sender, EventArgs e)
{
try
{
dtTrang_Thai =
new Select("*").From(HoadonTrangthai.Schema).Where(HoadonTrangthai.Columns.MessageType).IsEqualTo("MauHD").
OrderAsc(HoadonTrangthai.Columns.MessageOrder).
ExecuteDataSet().Tables[0];
DataBinding.BindData(cboTrang_Thai, dtTrang_Thai, "Message_ID", "Message_Name");
cboTrang_Thai.SelectedIndex = 0;
dtpHieuLuc.Value = globalVariables.SysDate;
dtpHetHieuLuc.Value = globalVariables.SysDate;
txtNguoi_Tao.Text = globalVariables.UserName;
if (!string.IsNullOrEmpty(txtMau_HD.Text))
{
LoadInvoice();
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
public void Init()
{
log = LogManager.GetCurrentClassLogger();
baocaO_TIEUDE1.Init();
m_dataThuoc = new Select().From(DmucThuoc.Schema).Where(DmucThuoc.KieuThuocvattuColumn).IsEqualTo("THUOC").ExecuteDataSet().Tables[0];
Autocomplete_TinhTP();
AutocompleteThuoc();
AutocompleteLoaithuoc();
dtpNgayIn.Value = globalVariables.SysDate;
dtpFromDate.Value = globalVariables.SysDate;
dtpToDate.Value = globalVariables.SysDate;
baocaO_TIEUDE1.Init("BHYT_20A");
DataBinding.BindData(cboObjectType, THU_VIEN_CHUNG.LaydanhsachDoituongKcb(new List <string> {
"DV", "BHYT"
}),
DmucDoituongkcb.Columns.MaDoituongKcb, DmucDoituongkcb.Columns.TenDoituongKcb);
txtNhomBHYT.Init();
if (cboTuyen.Items.Count > 0)
{
cboTuyen.SelectedIndex = 0;
}
}
private void frmInsertUpdatePatient_Load(object sender, EventArgs e)
{
try
{
// Lấy về tất cả các control của form
arrAllControl = GetAllControls("", this);
// Lấy về danh sách các control được set index
var types = new List <Type>
{
typeof(TextBox),
typeof(CheckBox),
typeof(Janus.Windows.CalendarCombo.CalendarCombo),
typeof(Janus.Windows.GridEX.EditControls.EditBox),
typeof(Janus.Windows.GridEX.EditControls.NumericEditBox),
typeof(Janus.Windows.EditControls.UICheckBox),
typeof(Janus.Windows.EditControls.UIButton),
typeof(ComboBox)
};
controlToSetTabIndex = arrAllControl.Where(
control =>
types.Contains(control.GetType()) && control.Visible &&
!string.IsNullOrEmpty(control.Name.Trim()));
// Gán sự kiện keyup cho tất cả control
foreach (Control control in controlToSetTabIndex)
{
//control.KeyDown += new KeyEventHandler(ControlToSetTabIndex_KeyUp);
//control.KeyDown +=new KeyEventHandler(control_KeyDown);
//control.KeyPress+= control_KeyPress;
}
LoadConfig();
LoadTabOrderConfig();
cboHosStatus.SelectedIndex = 0;
FillSexCombobox();
m_dtDepartment = dtDepartment.Copy();
DataBinding.BindData(cboDepartment, m_dtDepartment, LDepartment.Columns.Id, LDepartment.Columns.SName);
try
{
cboDepartment.SelectedIndex = 0;
}
catch (Exception ex)
{
}
DataBinding.BindData(cboObject, dtObjectType, "ID", "sName");
txtYearOfBirth.Value = pv_CurrentYear;
switch (m_iAction)
{
case action.Insert:
txtPID.Text = Utility.GetYYYYMMDDHHMMSS(Utility.getSysDate());
break;
case action.Update:
LoadData();
break;
}
ActiveControl = (from control in arrAllControl
where (control.Name == (from x in _tabOrderConfig
where x.ControlTabStop
select x.ControlName).FirstOrDefault())
select control).FirstOrDefault();
}
catch (Exception ex)
{
Utility.ShowMsg(string.Format("Lỗi trong quá trình khởi tạo {0}", ex.ToString()));
this.Dispose();
}
}
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 =
// DataBinding.BindData(cboUserName,v_dtStaffTypeList.Select(""));
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 DataTable();
if (em_Action == action.Insert)
{
v_dtUserList =
new Select().From(SysUser.Schema).Where(SysUser.Columns.PkSuid).NotIn(
new Select(DmucNhanvien.Columns.UserName).From(DmucNhanvien.Schema)).ExecuteDataSet().Tables
[0];
DataBinding.BindData(cboUserName, v_dtUserList, SysUser.Columns.PkSuid, SysUser.Columns.PkSuid);
}
else
{
v_dtUserList =
new Select().From(SysUser.Schema).ExecuteDataSet().Tables[0];
DataBinding.BindData(cboUserName, v_dtUserList, SysUser.Columns.PkSuid, SysUser.Columns.PkSuid);
}
//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_KHOTHUOCVaTuThuoc();
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);
DataTable dtQuyen = new Select().From(DmucChung.Schema).Where(DmucChung.Columns.Loai).IsEqualTo("QUYENNHANVIEN").ExecuteDataSet().Tables[0];
Utility.SetDataSourceForDataGridEx_Basic(grdQuyen, dtQuyen, false, true, "1=1", DmucChung.Columns.SttHthi + "," + DmucChung.Columns.Ten);
Utility.SetDataSourceForDataGridEx_Basic(grdLoaiThuoc, SPs.DmucLaydanhsachLoaithuoc("-1").GetDataSet().Tables[0], false, true, "1=1", "stt_nhomthuoc," + DmucLoaithuoc.Columns.SttHthi + "," + DmucLoaithuoc.Columns.TenLoaithuoc);
Utility.SetDataSourceForDataGridEx_Basic(grdDichvuCls, new Select().From(DmucChung.Schema).Where(DmucChung.Columns.Loai).IsEqualTo("LOAIDICHVUCLS").ExecuteDataSet().Tables[0], false, true, "1=1", DmucChung.Columns.SttHthi + "," + DmucChung.Columns.Ten);
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
private void LoadManufacturerList()
{
dtManufacturerList = new Select().From(LManufacture.Schema.Name).ExecuteDataSet().Tables[0];
DataBinding.BindData(cboManufacturer, dtManufacturerList, LManufacture.Columns.Id, LManufacture.Columns.SName);
}
