private KHAMTHUONGXUYEN getKHAMTHUONGXUYENByForm() { KHAMTHUONGXUYEN ans = new KHAMTHUONGXUYEN(); ans.BACSIID = (int)cbxBacSi.EditValue; ans.BENHNHANID = (int)cbxBenhNhan.EditValue; ans.THOIGIAN = dateThoiGianKham.DateTime; ans.BENHID = (int)cbxBenh.EditValue; ans.CACHGIAIQUYET = cbxCachGiaiQuyet.SelectedIndex; ans.CHANDOANSOBO = txtKetLuan.Text; ans.TRIEUCHUNG = txtTrieuChung.Text; // điều trị tại tuyến if (ans.CACHGIAIQUYET == 1) { ans.THOIGIANVAO = dateThoiGianVao.DateTime; ans.THOIGIANRA = dateThoiGianRa.DateTime; ans.PHUONGPHAPDIEUTRI = txtPhuongPhap.Text; } // chuyển lên tuyến trên if (ans.CACHGIAIQUYET == 2) { ans.BENHVIENID = (int)cbxBenhVien.EditValue; ans.THOIGIANCHUYEN = dateThoiGianChuyen.DateTime; } return(ans); }
public FrmRpChiPhiKhamChuaBenhQuanNhan(int _khamthuongxuyenID, string _nguoilapbangke, string _phutrachquany) { khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys(_khamthuongxuyenID)); nguoilapbangke = _nguoilapbangke; phutrachquany = _phutrachquany; InitializeComponent(); }
private void btnThem_Click(object sender, EventArgs e) { khamthuongxuyen = new KHAMTHUONGXUYEN(); ThamSoHeThong.khamthuongxuyen = khamthuongxuyen; dgvCHITIETCAPTHUOCMain.DataSource = null; dgvCHITIETMUONVATTUMain.DataSource = null; ClearControl(); UpdateStateForm(1); }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of KHAMTHUONGXUYEN</returns> internal List <KHAMTHUONGXUYEN> PopulateObjectsFromReader(IDataReader dataReader) { List <KHAMTHUONGXUYEN> list = new List <KHAMTHUONGXUYEN>(); while (dataReader.Read()) { KHAMTHUONGXUYEN businessObject = new KHAMTHUONGXUYEN(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
public FrmChiTietKhamThuongXuyen(int _id) { InitializeComponent(); KHAMTHUONGXUYEN khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys(_id)); panelMain.Controls.Clear(); ucKhamThuongXuyen uc = new ucKhamThuongXuyen(khamthuongxuyen); panelMain.Controls.Add(uc); uc.Show(); }
public ucKhamThuongXuyen(KHAMTHUONGXUYEN _khamthuongxuyen) { khamthuongxuyen = _khamthuongxuyen;; try { capthuoc = CAPTHUOCService.GetAllEntities().Where(p => p.KHAMTHUONGXUYENID == _khamthuongxuyen.ID).FirstOrDefault(); muonvattu = MUONVATTUService.GetAllEntities().Where(p => p.KHAMTHUONGXUYENID == _khamthuongxuyen.ID).FirstOrDefault(); } catch { } InitializeComponent(); }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(KHAMTHUONGXUYEN businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[KHAMTHUONGXUYEN_Insert]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID)); sqlCommand.Parameters.Add(new SqlParameter("@BENHNHANID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BENHNHANID)); sqlCommand.Parameters.Add(new SqlParameter("@BACSIID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BACSIID)); sqlCommand.Parameters.Add(new SqlParameter("@THOIGIAN", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIAN)); sqlCommand.Parameters.Add(new SqlParameter("@BENHID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BENHID)); sqlCommand.Parameters.Add(new SqlParameter("@CHANDOANSOBO", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CHANDOANSOBO)); sqlCommand.Parameters.Add(new SqlParameter("@CACHGIAIQUYET", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CACHGIAIQUYET)); sqlCommand.Parameters.Add(new SqlParameter("@THOIGIANCHUYEN", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIANCHUYEN)); sqlCommand.Parameters.Add(new SqlParameter("@BENHVIENID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BENHVIENID)); sqlCommand.Parameters.Add(new SqlParameter("@THOIGIANVAO", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIANVAO)); sqlCommand.Parameters.Add(new SqlParameter("@THOIGIANRA", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.THOIGIANRA)); sqlCommand.Parameters.Add(new SqlParameter("@PHUONGPHAPDIEUTRI", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PHUONGPHAPDIEUTRI)); sqlCommand.Parameters.Add(new SqlParameter("@KETQUADIEUTRI", SqlDbType.VarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.KETQUADIEUTRI)); sqlCommand.Parameters.Add(new SqlParameter("@CHIPHIKHAM", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.CHIPHIKHAM)); sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU)); sqlCommand.Parameters.Add(new SqlParameter("@TRIEUCHUNG", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TRIEUCHUNG)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); businessObject.ID = (int)sqlCommand.Parameters["@ID"].Value; return(true); } catch //(Exception ex) { return(false); //throw new Exception("KHAMTHUONGXUYEN::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
private void UpdateDetail() { try { int muonvattuID = (int)dgvMUONVATTU.GetFocusedRowCellValue("ID"); MUONVATTU muonvattu = MUONVATTUService.GetByPrimaryKey(new MUONVATTUKeys(muonvattuID)); KHAMTHUONGXUYEN khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys((int)muonvattu.KHAMTHUONGXUYENID)); // cập nhât txtNgay.Text = ((DateTime)khamthuongxuyen.THOIGIAN).ToString("dd/MM/yyyy"); txtBacSi.Text = BACSIService.GetByPrimaryKey(new BACSIKeys((int)khamthuongxuyen.BACSIID)).HOTEN; txtBenhNhan.Text = BENHNHANService.GetByPrimaryKey(new BENHNHANKeys((int)khamthuongxuyen.BENHNHANID)).HOTEN; txtBenh.Text = BENHService.GetByPrimaryKey(new BENHKeys((int)khamthuongxuyen.BENHID)).TEN; } catch { } }
private void CapNhat(ref KHAMTHUONGXUYEN cu, KHAMTHUONGXUYEN moi) { cu.BACSIID = moi.BACSIID; cu.BENHNHANID = moi.BENHNHANID; cu.THOIGIAN = moi.THOIGIAN; cu.BENHID = moi.BENHID; cu.CACHGIAIQUYET = moi.CACHGIAIQUYET; cu.KETQUADIEUTRI = moi.KETQUADIEUTRI; cu.CHANDOANSOBO = moi.CHANDOANSOBO; cu.THOIGIANVAO = moi.THOIGIANVAO; cu.THOIGIANRA = moi.THOIGIANRA; cu.PHUONGPHAPDIEUTRI = moi.PHUONGPHAPDIEUTRI; cu.BENHVIENID = moi.BENHVIENID; cu.THOIGIANCHUYEN = moi.THOIGIANCHUYEN; cu.TRIEUCHUNG = moi.TRIEUCHUNG; }
private void btnTra_Click(object sender, EventArgs e) { try { int muonvattuID = (int)dgvMUONVATTU.GetFocusedRowCellValue("ID"); MUONVATTU muonvattu = MUONVATTUService.GetByPrimaryKey(new MUONVATTUKeys(muonvattuID)); KHAMTHUONGXUYEN khamthuongxuyen = KHAMTHUONGXUYENService.GetByPrimaryKey(new KHAMTHUONGXUYENKeys((int)muonvattu.KHAMTHUONGXUYENID)); if (muonvattu.TRANGTHAI == 1) { MessageBox.Show("Thông tin mượn vật tư đã được trả", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (muonvattu.TRANGTHAI == 2) { MessageBox.Show("Chưa có vật tư nào được mượn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // cập nhật lại thông tin mượn vật tư muonvattu.TRANGTHAI = 1; muonvattu.NGAYTRA = DateTime.Now; MUONVATTUService.Update(muonvattu); // cập nhật lại kho var listChiTiet = CHITIETMUONVATTUService.GetAllEntities().Where(p => p.MUONVATTUID == muonvattu.ID).ToList(); foreach (var item in listChiTiet) { VATTU vattu = VATTUService.GetByPrimaryKey(new VATTUKeys((int)item.VATTUID)); vattu.SOLUONG += item.SOLUONG; VATTUService.Update(vattu); } MessageBox.Show("Xác nhận trả vật tư thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadDgvMUONVATTU(); } catch { MessageBox.Show("Chưa có thông tin mượn vật tư nào được chọn", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>KHAMTHUONGXUYEN business object</returns> public KHAMTHUONGXUYEN SelectByPrimaryKey(KHAMTHUONGXUYENKeys keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[KHAMTHUONGXUYEN_SelectByPrimaryKey]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.ID)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { KHAMTHUONGXUYEN businessObject = new KHAMTHUONGXUYEN(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch //(Exception ex) { return(null); //throw new Exception("KHAMTHUONGXUYEN::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
private void UpdateDetail() { try { KHAMTHUONGXUYEN tg = khamthuongxuyen; if (tg.ID == 0) { return; } ClearControl(); cbxBacSi.EditValue = (int)tg.BACSIID; cbxBenhNhan.EditValue = (int)tg.BENHNHANID; dateThoiGianKham.DateTime = (DateTime)tg.THOIGIAN; cbxBenh.EditValue = (int)tg.BENHID; cbxCachGiaiQuyet.SelectedIndex = (int)tg.CACHGIAIQUYET; txtKetLuan.Text = tg.CHANDOANSOBO; txtTrieuChung.Text = tg.TRIEUCHUNG; if (tg.CACHGIAIQUYET == 1) { dateThoiGianVao.DateTime = (DateTime)tg.THOIGIANVAO; dateThoiGianRa.DateTime = (DateTime)tg.THOIGIANRA; txtPhuongPhap.Text = tg.PHUONGPHAPDIEUTRI; } if (tg.CACHGIAIQUYET == 2) { cbxBenhVien.EditValue = (int)tg.BENHVIENID; dateThoiGianChuyen.DateTime = (DateTime)tg.THOIGIANCHUYEN; } LoadDgvCHITIETCAPTHUOC(); LoadDgvCHITIETMUONVATTU(); } catch { } }
public FrmInGiayGioiThieu(KHAMTHUONGXUYEN _khamthuongxuyen) { khamthuongxuyen = _khamthuongxuyen; InitializeComponent(); }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(KHAMTHUONGXUYEN businessObject, IDataReader dataReader) { businessObject.ID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.ID.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHNHANID.ToString()))) { businessObject.BENHNHANID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHNHANID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BACSIID.ToString()))) { businessObject.BACSIID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BACSIID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIAN.ToString()))) { businessObject.THOIGIAN = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIAN.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHID.ToString()))) { businessObject.BENHID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHANDOANSOBO.ToString()))) { businessObject.CHANDOANSOBO = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHANDOANSOBO.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CACHGIAIQUYET.ToString()))) { businessObject.CACHGIAIQUYET = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CACHGIAIQUYET.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANCHUYEN.ToString()))) { businessObject.THOIGIANCHUYEN = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANCHUYEN.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHVIENID.ToString()))) { businessObject.BENHVIENID = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.BENHVIENID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANVAO.ToString()))) { businessObject.THOIGIANVAO = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANVAO.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANRA.ToString()))) { businessObject.THOIGIANRA = dataReader.GetDateTime(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.THOIGIANRA.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.PHUONGPHAPDIEUTRI.ToString()))) { businessObject.PHUONGPHAPDIEUTRI = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.PHUONGPHAPDIEUTRI.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.KETQUADIEUTRI.ToString()))) { businessObject.KETQUADIEUTRI = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.KETQUADIEUTRI.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHIPHIKHAM.ToString()))) { businessObject.CHIPHIKHAM = dataReader.GetInt32(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.CHIPHIKHAM.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.GHICHU.ToString()))) { businessObject.GHICHU = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.GHICHU.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.TRIEUCHUNG.ToString()))) { businessObject.TRIEUCHUNG = dataReader.GetString(dataReader.GetOrdinal(KHAMTHUONGXUYEN.KHAMTHUONGXUYENFields.TRIEUCHUNG.ToString())); } }
private void btnLuuThongTin_Click(object sender, EventArgs e) { int exceptionHelp = 0;// -> giúp tạo ra exception if (Check()) { try { KHAMTHUONGXUYEN tg = getKHAMTHUONGXUYENByForm(); if (khamthuongxuyen.ID == 0) { bool kt = KHAMTHUONGXUYENService.Insert(tg); if (kt == false) { exceptionHelp /= 0; } khamthuongxuyen = tg; ThamSoHeThong.khamthuongxuyen = tg; // thêm mới muonvattu = new MUONVATTU(); ThamSoHeThong.muonvattu = muonvattu; muonvattu.KHAMTHUONGXUYENID = khamthuongxuyen.ID; muonvattu.BACSIMUONID = khamthuongxuyen.BACSIID; muonvattu.NGAYMUON = khamthuongxuyen.THOIGIAN; muonvattu.TRANGTHAI = 2; // Chưa mượn MUONVATTUService.Insert(muonvattu); capthuoc = new CAPTHUOC(); ThamSoHeThong.capthuoc = capthuoc; capthuoc.KHAMTHUONGXUYENID = khamthuongxuyen.ID; capthuoc.BACSIID = khamthuongxuyen.BACSIID; capthuoc.NGAY = khamthuongxuyen.THOIGIAN; CAPTHUOCService.Insert(capthuoc); LoadDgvCHITIETCAPTHUOC(); LoadDgvCHITIETMUONVATTU(); MessageBox.Show("Thêm thông tin phiếu khám bệnh thường xuyên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { // cập nhật CapNhat(ref khamthuongxuyen, tg); bool kt = KHAMTHUONGXUYENService.Update(khamthuongxuyen); if (kt == false) { exceptionHelp /= 0; } MessageBox.Show("Cập nhật thông tin phiếu khám bệnh thường xuyên thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { if (khamthuongxuyen.ID == 0) { MessageBox.Show("Thêm phiếu khám bệnh thường xuyên thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Sửa thông tin phiếu khám bệnh thường xuyên thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } finally { if (cbxCachGiaiQuyet.SelectedIndex < 2) { UpdateStateForm(2); } else { UpdateStateForm(0); } UpdateDetail(); } } }