//Ham luu thong tin X Quang benh nhan
public bool LuuThongTinXQuangBN(X_Quang xq)
{
string sql = string.Format("Insert into X_QUANG (STT, MaPhieuChup, MaBenhNhan, MaNhanVien, MaPhongXQ, NgayChup, KyThuat,"
+" KyThuatChup, MoTaAnhChup, ChuanDoan, KetLuan, DeNghi) Values('{0}', '{1}', '{2}', '{3}', '{4}', N'{5}', N'{6}',"
+" N'{7}', N'{8}', N'{9}', N'{10}', N'{11}')", "0", xq.MaPhieuChup, xq.MaBenhNhan, xq.MaNhanVien, xq.MaPhongXQ, xq.NgayChup.ToString("MM/dd/yyyy"),
xq.KyThuat, xq.KyThuatChup, xq.MoTaAnhChup, xq.ChuanDoan, xq.KetLuan, xq.DeNghi);
if (connData.ExcuteQuery(sql))
return true;
return false;
}
private X_Quang LayThongTinXQuangBN()
{
X_Quang xq = new X_Quang();
xq.MaBenhNhan = txtXQuang_MaBN.Text;
xq.MaPhieuChup = txtXQuang_MaPhieuXQBN.Text;
xq.MaPhongXQ = cboXQuang_MaPhongXQ.SelectedValue.ToString();
xq.KyThuat = txtXQuang_KyThuatXQ.Text;
xq.KyThuatChup = txtXQuang_KyThuatChupXQ.Text;
xq.MaNhanVien = cboXQuang_MaKTVXQ.SelectedValue.ToString();
xq.ChuanDoan = txtXQuang_ChuanDoanBN.Text;
xq.NgayChup = Convert.ToDateTime(dtPickerXQuang_NgayChupXQ.Value.ToString());
xq.MoTaAnhChup = txtXQuang_ChiTietHinhAnh.Text;
xq.KetLuan = txtXQuang_KetLuan.Text;
xq.DeNghi = txtXQuang_DeNghi.Text;
return xq;
}
public bool SuaDoiThongTinXQuangBN(X_Quang xq)
{
string sql = string.Format("Update X_QUANG set MaPhongXQ = '{0}', MaNhanVien = '{1}', KyThuat = N'{2}', KyThuatChup = N'{3}', MoTaAnhChup = N'{4}',"
+ " ChuanDoan = N'{5}', KetLuan = N'{6}', DeNghi = N'{7}' where MaPhieuChup = '{8}'", xq.MaPhongXQ, xq.MaNhanVien, xq.KyThuat, xq.KyThuatChup,
xq.MoTaAnhChup, xq.ChuanDoan, xq.KetLuan, xq.DeNghi, xq.MaPhieuChup);
if (connData.ExcuteQuery(sql))
return true;
return false;
}