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); }