private TheoDoi LayThongTinTheoDoiBN()
{
TheoDoi td = new TheoDoi();
td.MaTheoDoi = txtMaTheoDoiBN.Text;
td.MaBenhAn = txtMaBenhAn.Text;
td.MaBenhNhan = txtMaBenhNhan.Text;
td.MaKhoa = txtMaKhoaDieuTriBN.Text;
td.MaBacSi = txtMaBSPhongBenh.Text;
td.MaYTa = txtMaYTaPhongBenh.Text;
td.MaGiuongBenh = txtMaGiuongBenhBN.Text;
td.MaNhapVien = txtMaNhapVien.Text;
td.MaGiuongBenh = txtMaGiuongBenhBN.Text;
td.MaPhongBenh = txtMaGiuongBenhBN.Text;
return td;
}
//them chi tiet theo doi cho benh nha
public bool ThemThongTinChiTietTheoDoi(TheoDoi td)
{
string sql = string.Format("exec sp_ThemThongTinCHITIETTHEODOI '{0}', N'{1}', '{2}', '{3}', '{4}', '{5}', '{6}', N'{7}', N'{8}', N'{9}', N'{10}', N'{11}' ",
td.MaTheoDoi, td.NgayTheoDoi.ToString("MM/dd/yyyy"), td.Mach, td.NhietDo, td.NhipTho, td.HuyetAp, td.CanNang, td.DienBien, td.XuLiChamSoc, td.ThuocVatTu,
td.NhanDinhTinhTrang, td.KeHoachChamSoc);
if (connData.ExcuteQuery(sql))
return true;
return false;
}
private TheoDoi LayThongTinChiTietTheoDoiBN()
{
TheoDoi td = new TheoDoi();
td.MaTheoDoi = txtMaTheoDoiBN.Text;
td.NhanDinhTinhTrang = txtNhanDinhTT.Text;
td.XuLiChamSoc = txtTheoDoi_XuLiChamSoc.Text;
td.NgayTheoDoi = Convert.ToDateTime(dtPickerNgayTheoDoi.Value.ToString());
td.Mach = Convert.ToInt32(txtTheoDoi_MachBN.Text);
td.NhietDo = Convert.ToInt32(txtTheoDoi_NhietDoBN.Text);
td.NhipTho = Convert.ToInt32(txtTheoDoi_NhipThoBN.Text);
td.HuyetAp = Convert.ToInt32(txtTheoDoi_HuyetApBN.Text);
td.CanNang = Convert.ToInt32(txtTheoDoi_CanNangBN.Text);
td.DienBien = txtTheoDoi_DienBien.Text;
td.KeHoachChamSoc = txtKeHoachMucTieu.Text;
td.ThuocVatTu = txtTheoDoi_VatTuSuDung.Text;
return td;
}
//tao moi ma theo doi va luu thong tin theo doi benh nha
public bool LuuThongTinTheoDoiBN(TheoDoi td)
{
string sql = string.Format("exec sp_ThemThongTinTheoDoiBN '{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}' ",
td.MaTheoDoi, td.MaBenhAn, td.MaBenhNhan, td.MaKhoa, td.MaBacSi, td.MaYTa, td.MaNhapVien, td.MaPhongBenh, td.MaGiuongBenh);
if (connData.ExcuteQuery(sql))
return true;
return false;
}
