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