private KhamBenh_DTO BienDoiKB()
{
KhamBenh_DTO kb = new KhamBenh_DTO();
kb.Ma_so = txtSoHs.Text;
kb.Ma_bn = cboMabn.Text;
kb.Ghi_chu = cboGhichu.Text;
return(kb);
}
private KhamBenh_DTO BienDoiKB()
{
KhamBenh_DTO kb = new KhamBenh_DTO();
kb.Ma_so = lbMaso.Text;
kb.Cd_vao = txtCDvao.Text;
kb.Cd_ra = txtCDra.Text;
kb.Qua_trinh = txtQuatrinh.Text;
kb.Phuong_phap = txtPhuongphap.Text;
kb.Ket_qua = txtKetqua.Text;
return(kb);
}
// hoàn thành khám bệnh
public void HoanThanh(KhamBenh_DTO kb)
{
string sql = "UPDATE khambenh SET ket_thuc = GETDATE(), cd_vao = N'" + kb.Cd_vao + "', cd_ra = N'" + kb.Cd_ra + "', qua_trinh = N'" + kb.Qua_trinh + "', phuong_phap = N'" + kb.Phuong_phap + "', ket_qua = N'" + kb.Ket_qua + "' WHERE ma_so = '" + kb.Ma_so + "'";
KetNoiDB.Khoa.ChayLenh(sql);
}
// thêm hồ sơ khám bệnh
public void ThemKB(KhamBenh_DTO kb)
{
string sql = @"INSERT INTO khambenh (ma_so, ma_bn, bat_dau, ket_thuc, cd_vao, cd_ra, qua_trinh, phuong_phap, ket_qua, ghi_chu) VALUES('" + kb.Ma_so + "','" + kb.Ma_bn + "',GETDATE(),NULL,NULL,NULL,NULL,NULL,NULL,N'" + kb.Ghi_chu + "')";
KetNoiDB.Khoa.ChayLenh(sql);
}
