Пример #1
0
 private void InitData()
 {
     DataBinding.BindDataCombobox(cboNhanVien, CommonLoadDuoc.LAYTHONGTIN_NHANVIEN(),
                                  DmucNhanvien.Columns.IdNhanvien, DmucNhanvien.Columns.TenNhanvien, "---Nhân viên---", false);
     cboNhanVien.Enabled = false;
     LoadKho();
 }
 private void InitData()
 {
     m_KhoaTra = THU_VIEN_CHUNG.Laydanhmuckhoa("NOI", 0);
     DataBinding.BindDataCombobox(cboNhanVien, CommonLoadDuoc.LAYTHONGTIN_NHANVIEN(),
                                  DmucNhanvien.Columns.IdNhanvien, DmucNhanvien.Columns.TenNhanvien, "---Nhân viên---", true);
     cboNhanVien.Enabled = false;
     LoadKho();
 }
Пример #3
0
        private void frm_baocaochidinhCLS_Load(object sender, EventArgs e)
        {
            try
            {
                DataTable dtNhomdichvu = new Select().From(VDmucDichvucl.Schema).ExecuteDataSet().Tables[0];
                cboNhomdichvuCLS.DropDownDataSource    = dtNhomdichvu;
                cboNhomdichvuCLS.DropDownDataMember    = VDmucDichvucl.Columns.IdDichvu;
                cboNhomdichvuCLS.DropDownDisplayMember = VDmucDichvucl.Columns.TenDichvu;
                cboNhomdichvuCLS.DropDownValueMember   = VDmucDichvucl.Columns.IdDichvu;

                DataBinding.BindDataCombobox(cboDoituongKCB, THU_VIEN_CHUNG.LaydanhsachDoituongKcb(),
                                             DmucDoituongkcb.Columns.MaDoituongKcb,
                                             DmucDoituongkcb.Columns.TenDoituongKcb, "Chọn đối tượng KCB", true);

                txtNhanvien.Init(CommonLoadDuoc.LAYTHONGTIN_NHANVIEN());
                m_dtKhoathucHien = THU_VIEN_CHUNG.Laydanhmuckhoa("NGOAI", 0);
                DataBinding.BindDataCombobox(cbokhoa, m_dtKhoathucHien,
                                             DmucKhoaphong.Columns.MaKhoaphong, DmucKhoaphong.Columns.TenKhoaphong,
                                             "Chọn khoa KCB", true);
                EnumerableRowCollection <DataRow> query = from khoa in m_dtKhoathucHien.AsEnumerable()
                                                          where
                                                          Utility.sDbnull(khoa[DmucKhoaphong.Columns.MaKhoaphong]) ==
                                                          globalVariables.MA_KHOA_THIEN
                                                          select khoa;
                if (query.Count() > 0)
                {
                    cbokhoa.SelectedValue = globalVariables.MA_KHOA_THIEN;
                }
                DataTable dtdmuc = new Select().From(DmucDichvuclsChitiet.Schema).Where(DmucDichvuclsChitiet.Columns.TrangThai).IsEqualTo(1).ExecuteDataSet().Tables[0];
                txtchitietdichvu.Init(dtdmuc
                                      ,
                                      new List <string>
                {
                    DmucDichvuclsChitiet.Columns.IdChitietdichvu,
                    DmucDichvuclsChitiet.Columns.MaChitietdichvu,
                    DmucDichvuclsChitiet.Columns.TenChitietdichvu
                });
                DataTable dtBacsi = THU_VIEN_CHUNG.LaydanhsachBacsi(-1, -1);
                cboBacSyChiDinh.DropDownDataSource    = dtBacsi;
                cboBacSyChiDinh.DropDownDataMember    = DmucNhanvien.Columns.IdNhanvien;
                cboBacSyChiDinh.DropDownDisplayMember = DmucNhanvien.Columns.TenNhanvien;
                cboBacSyChiDinh.DropDownValueMember   = DmucNhanvien.Columns.UserName;
                m_blnhasLoaded = true;
            }
            catch (Exception ex)
            {
                Utility.CatchException("Lỗi khi load chức năng!", ex);
            }
        }
Пример #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 (KieuThuocVt == "THUOC")
            {
                m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOXUATTHUOC_XAHUYEN();
                m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_XAHUYEN();
            }
            else
            {
                m_dtKhoXuat = CommonLoadDuoc.LAYTHONGTIN_KHOXUATTHUOC_XAHUYEN();
                m_dtKhoNhap = CommonLoadDuoc.LAYTHONGTIN_KHOVT_XAHUYEN();
            }

            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);
            //DataBinding.BindDataCombobox(cboKhoNhap, m_dtKhoNhap,
            //                          TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho,
            //                          "---Kho nhập---",false);
            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(KieuThuocVt),
                             new List <string>()
            {
                DmucThuoc.Columns.IdThuoc, DmucThuoc.Columns.MaThuoc, DmucThuoc.Columns.TenThuoc
            });
        }
Пример #5
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
            });
        }
Пример #6
0
 private void InitData()
 {
     DataBinding.BindDataCombobox(cboNhanVien, CommonLoadDuoc.LAYTHONGTIN_NHANVIEN(),
                                  DmucNhanvien.Columns.IdNhanvien, DmucNhanvien.Columns.TenNhanvien, "---Nhân viên---", false);
     cboNhanVien.Enabled = false;
     if (KIEU_THUOC_VT == "THUOC")
     {
         m_dtKhohuy = CommonLoadDuoc.LAYTHONGTIN_KHOTHUOC_TATCA();
     }
     else
     {
         m_dtKhohuy = CommonLoadDuoc.LAYTHONGTIN_KHOVATTU_TATCA();
     }
     cboNhanVien.SelectedValue = globalVariables.gv_intIDNhanvien;
     DataBinding.BindDataCombobox(cboKhohuy, m_dtKhohuy,
                                  TDmucKho.Columns.IdKho, TDmucKho.Columns.TenKho, "---Kho nhập---", false);
 }
Пример #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
     });
 }