// sửa dữ liệu BHYT
public void SuaBH(BaoHiem_DTO bh, string cq = null)
{
if (cq == null)
{
string sql = "UPDATE baohiem SET ma_cq = NULL, thoi_gian = '" + bh.Thoi_gian + "', hieu_luc = '" + bh.Hieu_luc + "', ptram = " + bh.Ptram + ", noi_kham = N'" + bh.Noi_kham + "' WHERE so_the = '" + bh.So_the + "'";
KetNoiDB.Khoa.ChayLenh(sql);
}
else
{
string sql2 = "UPDATE baohiem SET ma_cq = '" + cq + "', thoi_gian = '" + bh.Thoi_gian + "', hieu_luc = '" + bh.Hieu_luc + "', ptram = " + bh.Ptram + ", noi_kham = N'" + bh.Noi_kham + "' WHERE so_the = '" + bh.So_the + "'";
KetNoiDB.Khoa.ChayLenh(sql2);
}
}
private BaoHiem_DTO BiendoiBH()
{
BaoHiem_DTO bh = new BaoHiem_DTO();
bh.So_the = txtBHYT.Text;
bh.Ma_bn = txtMa.Text;
//
bh.Thoi_gian = chuyenkieu(dateBHYT.Text.ToString());
bh.Hieu_luc = txtHLuuBHYT.Text;
bh.Ptram = float.Parse(txtPtram.Text);
bh.Noi_kham = txtNkhamBHYT.Text;
return(bh);
}
// thêm dữ liệu BHYT
public void ThemBH(BaoHiem_DTO bh)
{
string sql = @"INSERT INTO baohiem (so_the, ma_bn, ma_cq, thoi_gian, hieu_luc, ptram, noi_kham) VALUES ('" + bh.So_the + "','" + bh.Ma_bn + "',NULL,'" + bh.Thoi_gian + "'," + bh.Hieu_luc + "," + bh.Ptram + ",N'" + bh.Noi_kham + "')";
KetNoiDB.Khoa.ChayLenh(sql);
}
