void InitData()
{
try
{
DataTable m_dtDichvuCLS = new Select().From(DmucDichvucl.Schema).ExecuteDataSet().Tables[0];
DataTable m_dtDichvuCLS_new = m_dtDichvuCLS.Clone();
foreach (DataRow dr in m_dtDichvuCLS.Rows)
{
if (Utility.CoquyenTruycapDanhmuc(Utility.sDbnull(dr[DmucDichvucl.Columns.IdLoaidichvu]), "0"))
{
m_dtDichvuCLS_new.ImportRow(dr);
}
}
DataBinding.BindDataCombobox(cboService, m_dtDichvuCLS_new, DmucDichvucl.Columns.IdDichvu, DmucDichvucl.Columns.TenDichvu, "---Chọn---", true);
// m_dtDataDetailService = SPs.DmucLaydanhmucDichvuclsChitietTheoID(Utility.Int16Dbnull(cboService.SelectedValue, -1)).GetDataSet().Tables[0];
Utility.SetDataSourceForDataGridEx(grdList, m_dtDataDetailService, true, true, "1=1", "stt_hthi_dichvu,stt_hthi_chitiet," + DmucDichvuclsChitiet.Columns.TenChitietdichvu);
dt_KhoaThucHien = THU_VIEN_CHUNG.Laydanhmuckhoa("NGOAI", 0);
cboKhoaTH.DataSource = dt_KhoaThucHien;
cboKhoaTH.ValueMember = DmucKhoaphong.Columns.MaKhoaphong;
cboKhoaTH.DisplayMember = DmucKhoaphong.Columns.TenKhoaphong;
cboKhoaTH.SelectedIndex = 0;
}
catch (Exception)
{
Utility.ShowMsg("Có lỗi trong quá trình lấy thông tin khoa");
}
}
void InitData()
{
try
{
DataTable m_dtLoaithuoc = new Select().From(DmucLoaithuoc.Schema).
Where(DmucLoaithuoc.Columns.KieuThuocvattu).IsEqualTo(Kieuthuoc_vt)
.ExecuteDataSet().Tables[0];
DataTable m_dtLoaithuoc_new = m_dtLoaithuoc.Clone();
if (globalVariables.gv_dtQuyenNhanvien_Dmuc.Select(QheNhanvienDanhmuc.Columns.Loai + "= 1").Length <= 0)
m_dtLoaithuoc_new = m_dtLoaithuoc.Copy();
else
{
foreach (DataRow dr in m_dtLoaithuoc.Rows)
{
if (Utility.CoquyenTruycapDanhmuc(Utility.sDbnull(dr[DmucLoaithuoc.Columns.IdLoaithuoc]), "1"))
{
m_dtLoaithuoc_new.ImportRow(dr);
}
}
}
DataBinding.BindDataCombobox(cboloaithuoc, m_dtLoaithuoc_new, DmucLoaithuoc.Columns.IdLoaithuoc, DmucLoaithuoc.Columns.TenLoaithuoc, "Chọn", false);
dt_KhoaThucHien = THU_VIEN_CHUNG.Laydanhmuckhoa("NGOAI", 0);
DataBinding.BindDataCombobox_Basic(cboKhoaTH, dt_KhoaThucHien, DmucKhoaphong.Columns.MaKhoaphong, DmucKhoaphong.Columns.TenKhoaphong);
Laydanhmucthuoc();
}
catch (Exception)
{
Utility.ShowMsg("Có lỗi trong quá trình lấy thông tin khoa");
}
}
private void AutocompleteLoaithuoc()
{
DataTable dtLoaithuoc = null;
dtLoaithuoc = new Select().From(DmucLoaithuoc.Schema)
.Where(DmucLoaithuoc.KieuThuocvattuColumn).IsEqualTo(txtKieuthuocVT.myCode)
.ExecuteDataSet().Tables[0];
if (dtLoaithuoc == null) return;
if (!dtLoaithuoc.Columns.Contains("ShortCut"))
dtLoaithuoc.Columns.Add(new DataColumn("ShortCut", typeof(string)));
DataTable m_dtLoaithuoc_new = dtLoaithuoc.Clone();
if (globalVariables.gv_dtQuyenNhanvien_Dmuc.Select(QheNhanvienDanhmuc.Columns.Loai + "= 1").Length <= 0)
m_dtLoaithuoc_new = dtLoaithuoc.Copy();
else
{
foreach (DataRow dr in dtLoaithuoc.Rows)
{
if (Utility.CoquyenTruycapDanhmuc(Utility.sDbnull(dr[DmucLoaithuoc.Columns.IdLoaithuoc]), "1"))
{
m_dtLoaithuoc_new.ImportRow(dr);
}
}
}
txtLoaithuoc.Init(m_dtLoaithuoc_new, new List<string>() { DmucLoaithuoc.Columns.IdLoaithuoc, DmucLoaithuoc.Columns.MaLoaithuoc, DmucLoaithuoc.Columns.TenLoaithuoc });
}