public void Delete(string ID)
{
sql = "Delete thanhtoanbhyt where [ID]='" + ID + "'";
CConnection data = new CConnection();
data.setData(sql);
}
public void Delete(string MaBN)
{
sql = "Delete btdbn where mabn='" + MaBN + "'";
CConnection data = new CConnection();
data.setData(sql);
}
public void Insert(CBenhNhan bn)
{
sql = "Insert into btdbn(mabn,hoten,namsinh,thon,phai)";
sql += " values('" + bn.MaBN + "',N'" + bn.HoTen + "','" + bn.NamSinh + "',N'" + bn.DiaChi + "'," + bn.GioiTinh + ")";
CConnection data = new CConnection();
data.setData(sql);
}
public int InsertCLS20(string id, string mabn, string stt, string mavp, string dongia, string soluong, DateTime ngay)
{
int roweffect = 0;
try
{
sql = "Insert into d_clsbhyt20(ID,STT,MABN,MAVP,DONGIA,soluong,ngay)";
sql += " values(" + id + "," + stt + ",'" + mabn + "','" + mavp + "',";
sql += dongia + "," + soluong + ",'" + FormatYYYY_MM_DD(ngay) + "')";
CConnection data = new CConnection();
roweffect = data.setData(sql);
}
catch { }
return(roweffect);
}
public int InsertThuoc20(string id, string mabn, string stt, string mabd, string dongia, string soluong, string thanhtien, string GPNK, string BVAPTHAU, string noikham, DateTime ngay)
{
int roweffect = 0;
try
{
sql = "Insert into d_thuocbhyt20(ID,STT,MABN,MABD,DONGIA,SOLUONG,THANHTIEN,GPNK,BVAPTHAU,MaKho,ngay)";
sql += " values(" + id + "," + stt + ",'" + mabn + "','" + mabd + "',";
sql += dongia + "," + soluong + "," + thanhtien + ",'" + GPNK + "','" + BVAPTHAU + "','" + noikham + "','" + FormatYYYY_MM_DD(ngay) + "')";
CConnection data = new CConnection();
roweffect = data.setData(sql);
}
catch { }
return(roweffect);
}
public int Insert(CThanhToanBHYT t)
{
int roweffect = 0;
try
{
sql = "Insert into thanhtoanbhyt(mabn,nhomthe,loaithe,mavaovien,sothebhyt,noidangky,icd,chandoan,tongtien,bhyttra,bntra,thuoc,mau,xetnghiem,cdha,dvktthongthuong,dvktcao,vtyt,tienkham,chiphivc,thamdochucnang,giuong,traituyen,idttrv,ngaylamviec,sophieu,khac,manhomthe,ngayhd,loaiba,sobienlai,tungay)";
sql += " values('" + t.MaBN + "',N'" + t.NhomThe + "','" + t.LoaiThe + "'," + t.MaVaoVien + ",";
sql += "'" + t.SoTheBHYT + "',N'" + t.NoiDangKyBHYT + "','" + t.ICD + "',N'" + t.ChanDoan + "',";
sql += t.TongTien + "," + t.BHYTTra + "," + t.BNTra + "," + t.Thuoc + "," + t.Mau + "," + t.XetNghiem + ",";
sql += t.CDHA + "," + t.DVKTthongthuong + "," + t.DVKTcao + "," + t.VTYT + "," + t.TienKham + "," + t.ChiPhiVC + ",";
sql += t.ThamDoChucNang + "," + t.Giuong + "," + t.TraiTuyen + "," + t.IDTTRV + ",'" + FormatYYYY_MM_DD(t.NgayLamViec) + "','" + t.SoPhieu + "'," + t.Khac + ",'" + t.MaNhomThe + "','" + FormatYYYY_MM_DD(t.HSD) + "','" + t.LoaiBA + "'," + t.SoBienLai + ",'" + FormatYYYY_MM_DD(t.TuNgay) + "')";
CConnection data = new CConnection();
roweffect = data.setData(sql);
}
catch { }
return(roweffect);
}