private bool CheckTonTai(int intMucHuong) { bool kq = false; clsDM_MucHuong obj = new clsDM_MucHuong(); kq = obj.CheckTonTai(intMucHuong); return kq; }
public static List<clsDM_MucHuong> GetListMucHuong() { List<clsDM_MucHuong> lst = new List<clsDM_MucHuong>(); SQLiteConnection m_dbConnection = new SQLiteConnection(ConfigurationManager.AppSettings["ConnectionString"]); m_dbConnection.Open(); DataTable dt = new DataTable(); string sql = "select * from DM_MucHuong Where Active=1 order by MucHuong"; SQLiteCommand cmd = new SQLiteCommand(sql, m_dbConnection); SQLiteDataAdapter da = new SQLiteDataAdapter(cmd); da.Fill(dt); m_dbConnection.Close(); foreach (DataRow row in dt.Rows) { clsDM_MucHuong mh = new clsDM_MucHuong(); mh.MucHuong_Id = int.Parse(row["MucHuong_Id"].ToString()); mh.MucHuong = int.Parse(row["MucHuong"].ToString()); mh.PhanTram = (decimal)row["PhanTram"]; mh.Active = (bool)row["Active"]; lst.Add(mh); } return lst; }
private void LoadGridView() { clsDM_MucHuong obj = new clsDM_MucHuong(); TableDanhMucMucHuong = obj.GetAll(); grdDM_MucHuong.DataSource = TableDanhMucMucHuong; }
private void LoadDataCombobox() { //Chú ý khi đổ dữ liệu lần đầu, không cho valuechanged sự kiện cbo //Load data cbo trạng thái - 2 trạng thái: "tạo mới" và "đã gửi BHXH". Mặc định là tạo mới, khi cột DaGuiBHXH trong bảng BangKe là 1 thì sẽ là "đã gửi BHXH" cboTinhTrang.DataSource = Utilities.Utils.GetTrangThai(); cboTinhTrang.DisplayMember = "Name"; cboTinhTrang.ValueMember = "Value"; //Load data cbo mã nơi sinh sống - 3 nơi: K1, K2, K3 cboMaNoiSinhSong.DisplayMember = "Name"; cboMaNoiSinhSong.ValueMember = "Value"; cboMaNoiSinhSong.DataSource = Utilities.Utils.GetKhuVucSong(); //Load gioi tinh cboGioiTinh.DataSource = Utilities.Utils.GetGioiTinh(); cboGioiTinh.DisplayMember = "Name"; cboGioiTinh.ValueMember = "Value"; //Load gioi tinh cboTuyenKham.DataSource = Utilities.Utils.GetTuyenKham(); cboTuyenKham.DisplayMember = "Name"; cboTuyenKham.ValueMember = "Value"; //Load data cơ sở khám chữa bệnh clsDM_CSKCB cskcb = new clsDM_CSKCB(); dtCSKCB = cskcb.GetAllActive(); txtNoiChuyenDen.Values = dtCSKCB; List<CDisplayColumns> lstColCSKCB = new List<CDisplayColumns>(); lstColCSKCB.Add(new CDisplayColumns("MaCSKCB", "Mã CSKCB", true, true)); lstColCSKCB.Add(new CDisplayColumns("TenCSKCB", "Tên CSKCB", true, true)); txtNoiChuyenDen.DisplayColumns = lstColCSKCB; //Load data cbo mức hưởng clsDM_MucHuong mucHuong = new clsDM_MucHuong(); cboMucHuong.DataSource = mucHuong.GetAllActive(); cboMucHuong.DisplayMember = "MucHuong"; cboMucHuong.ValueMember = "MucHuong"; cboMucHuong.SelectedValue = 0; //Load data cbo ICD clsDM_ICD icd = new clsDM_ICD(); DataTable dt = new DataTable(); dt = icd.GetAllActive(); txtMaICD.Values = dt; List<CDisplayColumns> lstCol = new List<CDisplayColumns>(); lstCol.Add(new CDisplayColumns("MaICD", "Mã ICD", true, true)); lstCol.Add(new CDisplayColumns("TenICD", "Tên ICD", true, true)); txtMaICD.DisplayColumns = lstCol; txtBenhKhac.DisplayColumns = lstCol; txtBenhKhac.Values = dt; //Load data cbo Thuốc clsDM_Thuoc thuoc = new clsDM_Thuoc(); txtThuoc.DropDownSize = new Size(600, 155); txtThuoc.Values = thuoc.GetAllALL(); List<CDisplayColumns> lstColT = new List<CDisplayColumns>(); lstColT.Add(new CDisplayColumns("Nhom", "Nhóm", false, true)); lstColT.Add(new CDisplayColumns("MaChiPhi", "Mã chi phí", true, true)); lstColT.Add(new CDisplayColumns("TenChiPhi", "Tên chi phí", true, true)); lstColT.Add(new CDisplayColumns("DonGiaBHYT", "Đơn giá", false, true)); txtThuoc.DisplayColumns = lstColT; txtThuoc.DisplayMember = "TenChiPhi"; //Danh mục phòng ban clsDM_PhongBan phongban = new clsDM_PhongBan(); txtKhoa.DropDownSize = new Size(300, 110); txtKhoa.Values = phongban.GetAllActive(); List<CDisplayColumns> lstColPB = new List<CDisplayColumns>(); lstColPB.Add(new CDisplayColumns("MaPhongBan", "Mã Khoa", true, true)); lstColPB.Add(new CDisplayColumns("TenPhongBan", "Tên khoa", true, true)); txtKhoa.DisplayColumns = lstColPB; txtKhoa.DisplayMember = "TenPhongBan"; }