private bool CheckTonTai(string strMa)
{
bool kq = false;
clsDM_ICD obj = new clsDM_ICD();
kq = obj.CheckTonTai(strMa);
return kq;
}
public bool CheckTonTai(int intMucHuong)
{
SQLiteConnection m_dbConnection = new SQLiteConnection(connectionString);
m_dbConnection.Open();
DataTable dt = new DataTable();
string sql = "SELECT MucHuong FROM DM_MucHuongDoiTuong WHERE MucHuong=@MucHuong";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.Parameters.Add(new SQLiteParameter("@MucHuong", intMucHuong));
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
da.Fill(dt);
m_dbConnection.Close();
clsDM_ICD obj = new clsDM_ICD();
if (dt.Rows.Count > 0)
{
return true;
}
return false;
}
public bool CheckTonTai(string strMa)
{
//SQLiteConnection m_dbConnection = new SQLiteConnection(connectionString);
m_dbConnection.Open();
DataTable dt = new DataTable();
string sql = "SELECT MaICD FROM DM_ICD WHERE MaICD=@MaICD";
SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);
command.Parameters.Add(new SQLiteParameter("@MaICD", strMa));
SQLiteDataAdapter da = new SQLiteDataAdapter(command);
da.Fill(dt);
m_dbConnection.Close();
clsDM_ICD obj = new clsDM_ICD();
if (dt.Rows.Count > 0)
{
return true;
}
return false;
}
private void txtMaICD_Validated(object sender, EventArgs e)
{
try
{
//txtMaICD.UpdateData();
clsDM_ICD obj = new clsDM_ICD();
obj.GetByKey(txtMaICD.Text);
if (obj.MaICD == null)
{
txtMaICD.Text = "";//txtMaICD.SelectedValues["TenICD"].ToString();
txtChanDoan.Text = "";
}
else
{
txtChanDoan.Text = obj.TenICD;
}
txtChanDoan.Select(txtChanDoan.Text.Length, 0);
}
catch { }
}
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";
}
private void LoadGridView()
{
clsDM_ICD obj = new clsDM_ICD();
TableDanhMucICD = obj.GetAll();
grdDM_ICD.DataSource = TableDanhMucICD;
}