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