/// <summary> /// hàm thực hiện việc khởi tạo thông tin của Form /// </summary> private void InitData() { if (KIEU_THUOC_VT == "THUOC") { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN(); m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE(); } else { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(); m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> { "TATCA", "NGOAITRU", "NOITRU" }); } if (m_dtKhoXuat.Rows.Count > 1) { DataBinding.BindDataCombobox(cboKhoXuat, m_dtKhoXuat, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho xuất---", false); } else { DataBinding.BindDataCombobox(cboKhoXuat, m_dtKhoXuat, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Chọn---", true); } DataBinding.BindDataCombobox(cboKhoNhap, m_dtKhoNhap, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho nhập---", false); }
private void LoadKho() { try { if (KIEU_THUOC_VT == "THUOC") { m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN(); m_dtKhoTraLai = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE(); } else { m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(); m_dtKhoTraLai = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> { "TATCA", "NGOAITRU", "NOITRU" }); } cboNhanVien.SelectedValue = globalVariables.gv_intIDNhanvien; DataBinding.BindDataCombobox(cboKhoLinh, m_dtKhoLinh, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho lĩnh---", false); DataBinding.BindDataCombobox(cboKhoTra, m_dtKhoTraLai, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho trả---", false); }catch (Exception exception) { } }
/// <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; }
/// <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 LoadKho() { if (KIEU_THUOC_VT == "THUOC") { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN(); } else { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(); } cboNhanVien.SelectedValue = globalVariables.gv_intIDNhanvien; DataBinding.BindDataCombobox(cboKhoXuat, m_dtKhoXuat, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho trả---", false); }
/// <summary> /// hàm thực hiện việc khởi tạo thông tin của Form /// </summary> private void InitData() { if (KIEU_THUOC_VT == "THUOC") { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN(); m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE(); } else { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(); m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> { "TATCA", "NGOAITRU", "NOITRU" }); } if (m_dtKhoXuat.Rows.Count > 1) { txtKhoXuat.Init(m_dtKhoXuat, new List <string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); } //DataBinding.BindDataCombobox(cboKhoXuat, m_dtKhoXuat, // TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, // "---Kho xuất---",false); else { txtKhoXuat.Init(m_dtKhoXuat, new List <string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); } //DataBinding.BindDataCombobox(cboKhoXuat, m_dtKhoXuat, // TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Chọn---", true); // txtKhonhap.Init(m_dtDataKhoNhap, new List<string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); txtKhoNhap.Init(m_dtKhoNhap, new List <string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); //DataBinding.BindDataCombobox(cboKhoNhap, m_dtKhoNhap, // TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, // "---Kho nhập---",false); txtNhanvien.Init(CommonLoadDuoc.LAYTHONGTIN_NHANVIEN()); txtTenthuoc.Init(CommonLoadDuoc.LayThongTinThuoc(KIEU_THUOC_VT), new List <string>() { DmucThuoc.Columns.IdThuoc, DmucThuoc.Columns.MaThuoc, DmucThuoc.Columns.TenThuoc }); }
/// <summary> /// hàm thực hiện việc khởi tạo thông tin của Form /// </summary> private void InitData() { txtNhacungcap.Init(); if (KIEU_THUOC_VT == "THUOC") { m_dtKhoThuoc = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN(); } else { m_dtKhoThuoc = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(); } if (m_dtKhoThuoc.Rows.Count > 1) { txtkhonhap.Init(m_dtKhoThuoc, new List <string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); } //DataBinding.BindDataCombobox(cboKhoThuoc, m_dtKhoThuoc, // TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, // "---Chọn kho---",false); else { //DataBinding.BindDataCombobox(cboKhoThuoc, m_dtKhoThuoc, // TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Chọn---", true); txtkhonhap.Init(m_dtKhoThuoc, new List <string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); } //DataBinding.BindDataCombobox(cboKhoNhap, m_dtKhoNhap, // TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, // "---Kho nhập---",false); txtNhanvien.Init(CommonLoadDuoc.LAYTHONGTIN_NHANVIEN()); txtTenthuoc.Init(CommonLoadDuoc.LayThongTinThuoc(KIEU_THUOC_VT), new List <string>() { DmucThuoc.Columns.IdThuoc, DmucThuoc.Columns.MaThuoc, DmucThuoc.Columns.TenThuoc }); }
/// <summary> /// hàm thực hiện việc khởi tạo thông tin của Form /// </summary> private void InitData() { txtNhacungcap.Init(); if (KIEU_THUOC_VT == "THUOC") { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN(); } else { m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(); } if (m_dtKhoXuat.Rows.Count > 1) { DataBinding.BindDataCombobox(cboKhoXuat, m_dtKhoXuat, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho trả---", false); } else { DataBinding.BindDataCombobox(cboKhoXuat, m_dtKhoXuat, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Chọn---", true); } }
/// <summary> /// load thông tin /// của form hiện tai /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frm_tonghopphatsinh_nhapxuat_Load(object sender, EventArgs e) { modifyTieude(); txtKho.Init(KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE()), new List <string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); txtKhoXuat.Init(KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE()), new List <string>() { TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho }); //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; cboKieubangke.SelectedIndex = 0; cboKieutonghop.SelectedIndex = 0; }
private void frm_PhieuTraLai_Kho_Load(object sender, EventArgs e) { CauHinh(); cmdCauHinh.Visible = globalVariables.IsAdmin; if (KIEU_THUOC_VT == "THUOC") { m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN(); m_dtKhoTraLai = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE(); } else { m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN(); m_dtKhoTraLai = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> { "TATCA", "NGOAITRU", "NOITRU" }); } DataBinding.BindDataCombobox(cboKhoTra, m_dtKhoTraLai, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho trả lại---", false); DataBinding.BindDataCombobox(cboKhoLinh, m_dtKhoLinh, TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "----Kho lĩnh", false); TimKiemThongTinDonThuoc(); b_Hasloaded = true; }
/// <summary> /// load thông tin /// của form hiện tai /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frm_baocao_nhapxuathuoc_Load(object sender, EventArgs e) { DataTable dtkho = null; modifyTieude(); if (KIEU_THUOC_VT == "THUOC") { dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE()); } else { dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> { "TATCA", "NGOAITRU", "NOITRU" })); } cboKho.DropDownDataSource = dtkho; cboKho.DropDownDataMember = TDmucKho.Columns.IdKho; cboKho.DropDownDisplayMember = TDmucKho.Columns.TenKho; cboKho.DropDownValueMember = TDmucKho.Columns.IdKho; //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_CheckedValuesChanged(cboKho, e); cboThang.SelectedIndex = globalVariables.SysDate.Month - 1; }
/// <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); }
/// <summary> /// load thông tin /// của form hiện tai /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frm_baocao_phanungnang_sautiemchung_Load(object sender, EventArgs e) { DataTable dtkho = null; txtGioitinh.Init(); if (KIEU_THUOC_VT.Contains("THUOC")) { baocaO_TIEUDE1.Init("vacxin_baocao_phanungnang_sautiemchung"); dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE()); } else { baocaO_TIEUDE1.Init("vacxin_baocao_phanungnang_sautiemchung"); dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> { "TATCA", "NGOAITRU", "NOITRU" })); } 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; }
/// <summary> /// load thông tin /// của form hiện tai /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void frm_baocao_xuatthuoc_khoanoitru_Load(object sender, EventArgs e) { DataTable dtkho = null; if (KIEU_THUOC_VT == "THUOC") { baocaO_TIEUDE1.Init("thuoc_baocao_xuatthuocnoitru"); dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE()); } else { baocaO_TIEUDE1.Init("thuoc_baocao_xuatthuocnoitru"); dtkho = KieuKho == "ALL" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_TATCA() : (KieuKho == "CHAN" ? CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN() : CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> { "TATCA", "NGOAITRU", "NOITRU" })); } cboKho.DropDownDataSource = dtkho; cboKho.DropDownDataMember = TDmucKho.Columns.IdKho; cboKho.DropDownDisplayMember = TDmucKho.Columns.TenKho; cboKho.DropDownValueMember = TDmucKho.Columns.IdKho; DataTable dtKhoaNoitru = THU_VIEN_CHUNG.Laydanhmuckhoa("NOI", 0); cboKhoalinh.DropDownDataSource = dtKhoaNoitru; cboKhoalinh.DropDownDataMember = DmucKhoaphong.Columns.IdKhoaphong; cboKhoalinh.DropDownDisplayMember = DmucKhoaphong.Columns.TenKhoaphong; cboKhoalinh.DropDownValueMember = DmucKhoaphong.Columns.IdKhoaphong; //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_CheckedValuesChanged(cboKho, e); cboKhoalinh_CheckedValuesChanged(cboKhoalinh, e); cboThang.SelectedIndex = globalVariables.SysDate.Month - 1; }