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