Пример #1
0
        private void LoadKho()
        {
            if (KIEU_THUOC_VT == "THUOC")
            {
                m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE_NOITRU();
                m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_TUTHUOC();
            }
            else
            {
                m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN();
                m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> {
                    "TATCA", "NOITRU"
                });
            }
            DataBinding.BindDataCombobox(cboKhonhan, m_dtKhoLinh,
                                         TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho,
                                         "---Kho nhận---", true);
            cboNhanVien.SelectedValue = globalVariables.gv_intIDNhanvien;

            DataBinding.BindDataCombobox(cboKhoxuat, m_dtKhoXuat,
                                         TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho,
                                         "---Kho xuất---", true);

            DataBinding.BindDataCombobox(cboKhoalinh, m_KhoaLinh,
                                         DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.TenKhoaphong, "--Khoa lĩnh--", true);
        }
        /// <summary>
        /// hàm thực hiện việc khởi tạo thông tin của Form
        /// </summary>
        private void InitData()
        {
            DataTable m_dtKhoaNoitru = THU_VIEN_CHUNG.Laydanhmuckhoa("NOI", 0);

            txtKhoanoitru.Init(m_dtKhoaNoitru, new List <string>()
            {
                DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.MaKhoaphong, DmucKhoaphong.Columns.TenKhoaphong
            });
            if (KIEU_THUOC_VT == "THUOC")
            {
                m_dtKhoNhan = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE_NOITRU();
            }
            else
            {
                m_dtKhoNhan = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN();
            }
            txtKhothuoc.Init(m_dtKhoNhan, new List <string>()
            {
                TDmucKho.Columns.IdKho, TDmucKho.Columns.MaKho, TDmucKho.Columns.TenKho
            });
            DataTable dtnhanvien = THU_VIEN_CHUNG.Laydanhsachnhanvien("ALL");

            txtNguoinhan.Init(dtnhanvien, new List <string>()
            {
                DmucNhanvien.Columns.IdNhanvien, DmucNhanvien.Columns.MaNhanvien, DmucNhanvien.Columns.TenNhanvien
            });
            txtNguoitra.Init(dtnhanvien, new List <string>()
            {
                DmucNhanvien.Columns.IdNhanvien, DmucNhanvien.Columns.MaNhanvien, DmucNhanvien.Columns.TenNhanvien
            });
            b_Hasloaded = true;
        }
Пример #3
0
 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)
     {
     }
 }
Пример #4
0
        /// <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()
 {
     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);
 }
Пример #6
0
        /// <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
            });
        }
Пример #7
0
 /// <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()
 {
     m_KhoaLinh = THU_VIEN_CHUNG.Laydanhmuckhoa("NOI", 0);
     if (KIEU_THUOC_VT == "THUOC")
     {
         m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE_NOITRU();
         m_dtKhonhan = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_AO(true);
     }
     else
     {
         m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN();
         m_dtKhonhan = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_AO(true);
     }
     DataBinding.BindDataCombobox(cboKhoxuat, m_dtKhoXuat,
                                  TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho,
                                  "---Kho xuất---", true);
     DataBinding.BindDataCombobox(cboKhoaLinh, m_KhoaLinh,
                                  DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.TenKhoaphong,
                                  "---Khoa lĩnh---", true);
     b_Hasloaded = true;
 }
        private void LoadKho()
        {
            if (KIEU_THUOC_VT == "THUOC")
            {
                m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE_NOITRU();
                m_dtKhoTra  = CommonLoadDuoc.LAYTHONGTIN_TUTHUOC();
            }
            else
            {
                m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN();
                m_dtKhoTra  = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE_TUTRUC();//new List<string> { "TATCA", "NOITRU" });
            }

            //m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE();
            //m_dtKhoTra = m_dtKhoNhap.Copy();

            cboNhanVien.SelectedValue = globalVariables.gv_intIDNhanvien;
            DataBinding.BindDataCombobox(cboKhoNhap, m_dtKhoNhap,
                                         TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho nhập---", false);
            DataBinding.BindDataCombobox(cboKhoaTra, m_KhoaTra,
                                         DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.TenKhoaphong,
                                         "---Khoa 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()
 {
     m_KhoaLinh = THU_VIEN_CHUNG.Laydanhmuckhoa("NOI", 0);
     if (KIEU_THUOC_VT == "THUOC")
     {
         m_dtKhoNhan = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE_NOITRU();
         m_dtKhoTra  = CommonLoadDuoc.LAYTHONGTIN_TUTHUOC();
     }
     else
     {
         m_dtKhoNhan = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN();
         m_dtKhoTra  = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> {
             "TATCA", "NOITRU"
         });
     }
     DataBinding.BindDataCombobox(cboKhoNhan, m_dtKhoNhan,
                                  TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho,
                                  "---kho nhận---", true);
     DataBinding.BindDataCombobox(cboKhoaLinh, m_KhoaLinh,
                                  DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.TenKhoaphong,
                                  "---Khoa trả---", true);
     b_Hasloaded = true;
 }
Пример #11
0
 /// <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);
     }
 }
Пример #12
0
 private void LoadKho()
 {
     if (KIEU_THUOC_VT == "THUOC")
     {
         m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_LE_NOITRU();
         m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_TUTHUOC();
     }
     else
     {
         m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_CHAN();
         m_dtKhoLinh = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_LE(new List <string> {
             "TATCA", "NOITRU"
         });
     }
     DataBinding.BindDataCombobox(cboKhonhan, m_dtKhoLinh,
                                  TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho,
                                  "---Kho nhận---", true);
     DataBinding.BindDataCombobox(cboKhoxuat, m_dtKhoXuat,
                                  TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho,
                                  "---Kho xuất---", true);
     m_KhoaLinh = THU_VIEN_CHUNG.Laydanhmuckhoa("NOI", 0);
     DataBinding.BindDataCombobox(cboKhoalinh, m_KhoaLinh,
                                  DmucKhoaphong.Columns.IdKhoaphong, DmucKhoaphong.Columns.TenKhoaphong, "--Khoa lĩnh--", true);
 }
Пример #13
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;
        }
Пример #14
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_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;
        }
Пример #15
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);
        }
Пример #16
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_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_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();
        }
        /// <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;
        }