//Them Vao STT, MaPhieuKham, MaPhongKham, MaBenhNhan
public void ThemPhieuKhamBN(PhieuKham pk)
{
string sql = string.Format("Insert into PHIEUKHAM(STT, MaPhieuKham, MaPhongKham, MaBenhNhan) values('{0}', '{1}', '{2}', '{3}' ) ",
"0", pk.MaPhieuKham, pk.MaPhongKham, pk.MaBenhNhan);
connData.ExcuteQuery(sql);
}
//Ham Lay Thong Tin phieu kham: MaPhieuKham, MaPhongKham, MaBenhNhan
private PhieuKham LayThongTinSoBoPhieuKham()
{
PhieuKham pk = new PhieuKham();
pk.MaPhieuKham = txtThemBN_MaPhieuBN.Text;
pk.MaBenhNhan = txtThemBN_MaBenhNhan.Text;
pk.MaPhongKham = cboThemBN_PhongKham.SelectedValue.ToString();
return pk;
}
//ham lay thong tin kham benh
private PhieuKham LayThongTinKhamBenh()
{
PhieuKham pk = new PhieuKham();
pk.MaBenhNhan = txtKBenh_MaBenhNhan.Text;
pk.CanNang = Convert.ToInt32(txtKBenh_CanNang.Text);
pk.NhomMau = cboKBenh_NhomMauBN.Text;
pk.NhietDo = Convert.ToInt32(txtKBenh_NhietDo.Text);
pk.Mach = Convert.ToInt32(txtKBenh_Mach.Text);
pk.HuyetAp = Convert.ToInt32(txtKBenh_HuyetAp.Text);
pk.NhipTho = Convert.ToInt32(txtKBenh_NhipTho.Text);
pk.LyDoKham = txtKBenh_LyDoKham.Text;
pk.TinhTrangHienTai = txtKBenh_TTHienTai.Text;
pk.BenhSu = txtKBenh_BenhSu.Text;
pk.ChuanDoanSoDo = txtKBenh_ChuanDoanSoBo.Text;
pk.YeuCauThem = txtKBenh_YeuCauThem.Text;
pk.ChuanDoanSauCung = txtKBenh_ChuanDoanSauCung.Text;
pk.HuongDieuTri = txtKBenh_HuongDieuTri.Text;
pk.NgayKham = Convert.ToDateTime(dtPickerKBenh_NgayKham.Value.ToString());
return pk;
}
//ham them thong tin cho phieu kham
public bool ThemThongTinPhieuKham(PhieuKham pk)
{
string sql = string.Format(" Update PHIEUKHAM set CanNang = '{0}', NhomMau = '{1}', Mach = '{2}', HuyetAp = '{3}', NhietDo = '{4}', NhipTho = '{5}', LyDoKham = N'{6}', "
+ " TinhTrangHienTai = N'{7}', BenhSu = N'{8}', NgayKham = N'{9}', ChuanDoanSoBo = N'{10}', YeuCauThem = N'{11}', ChuanDoanSauCung = N'{12}', HuongDieuTri = N'{13}', YeuCauKham = N'{14}' "
+ " where MaBenhNhan = '{15}'", pk.CanNang, pk.NhomMau, pk.Mach, pk.HuyetAp, pk.NhietDo, pk.NhipTho, pk.LyDoKham, pk.TinhTrangHienTai, pk.BenhSu, pk.NgayKham.ToString("MM/dd/yyyy"),
pk.ChuanDoanSoDo, pk.YeuCauThem, pk.ChuanDoanSauCung, pk.HuongDieuTri,pk.YeuCauThem, pk.MaBenhNhan);
if (connData.ExcuteQuery(sql))
return true;
return false;
}
