public void capnhatpkham(EC_tb_Phieukham key)
{
string sql = (@"UPDATE dbo.PHIEUKHAM
SET ChuanDoanBenh =N'" + key.CHUANDOANBENH + "',KeDonThuoc=N'" + key.KEDONTHUOC + "',TongTienThuoc='" + key.TONGTIENTHUOC + "',SuDungDVKyThuatYTe=N'" + key.SUDUNGDVKYTHUATYTE + "',TongTienDVKyThuat='" + key.TONGTIENDVKYTHUAT + "',SuDungDVSoCuu=N'" + key.SUDUNGDVSOCUU + "',TongTienDVSoCuu='" + key.TONGTIENDVSOCUU + "' where MaPhieuKham ='" + key.MAPHIEUKHAM + "'");
cn.ExcuteNonQuery(sql);
}
public void themmoi(EC_tb_Phieukham val)
{
if (!keysql.kiemtramapukh(val.MAPHIEUKHAM))
{
keysql.themmoi(val);
}
else
{
}
}
public void themmoi(EC_tb_Phieukham key)
{
cn.ExcuteNonQuery(@"INSERT INTO dbo.PHIEUKHAM
(MaPhieuKham,MaNhanVien,MaBenhNhan,NgayKham,ChuanDoanBenh,KeDonThuoc,TongTienThuoc,SuDungDVKyThuatYTe,TongTienDVKyThuat,SuDungDVSoCuu,TongTienDVSoCuu) VALUES ('" + key.MAPHIEUKHAM + "','" + key.MAHNHANVIEN + "','" + key.MABENHNHAN + "','" + key.NGAYKHAM + "',N'" + key.CHUANDOANBENH + "',N'" + key.KEDONTHUOC + "','" + key.TONGTIENTHUOC + "',N'" + key.SUDUNGDVKYTHUATYTE + "','" + key.TONGTIENDVKYTHUAT + "',N'" + key.SUDUNGDVSOCUU + "','" + key.TONGTIENDVSOCUU + "')");
}
public void capnhatpkham(EC_tb_Phieukham val)
{
keysql.capnhatpkham(val);
}
