/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(CAPTHUOC businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[CAPTHUOC_Update]"; 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, businessObject.ID)); sqlCommand.Parameters.Add(new SqlParameter("@NGAY", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.NGAY)); sqlCommand.Parameters.Add(new SqlParameter("@BACSIID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BACSIID)); sqlCommand.Parameters.Add(new SqlParameter("@KHAMTHUONGXUYENID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.KHAMTHUONGXUYENID)); sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch //(Exception ex) { return(false); //throw new Exception("CAPTHUOC::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of CAPTHUOC</returns> internal List <CAPTHUOC> PopulateObjectsFromReader(IDataReader dataReader) { List <CAPTHUOC> list = new List <CAPTHUOC>(); while (dataReader.Read()) { CAPTHUOC businessObject = new CAPTHUOC(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
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> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>CAPTHUOC business object</returns> public CAPTHUOC SelectByPrimaryKey(CAPTHUOCKeys keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[CAPTHUOC_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()) { CAPTHUOC businessObject = new CAPTHUOC(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch //(Exception ex) { return(null); //throw new Exception("CAPTHUOC::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(CAPTHUOC businessObject, IDataReader dataReader) { businessObject.ID = dataReader.GetInt32(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.ID.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.NGAY.ToString()))) { businessObject.NGAY = dataReader.GetDateTime(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.NGAY.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.BACSIID.ToString()))) { businessObject.BACSIID = dataReader.GetInt32(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.BACSIID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.KHAMTHUONGXUYENID.ToString()))) { businessObject.KHAMTHUONGXUYENID = dataReader.GetInt32(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.KHAMTHUONGXUYENID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.GHICHU.ToString()))) { businessObject.GHICHU = dataReader.GetString(dataReader.GetOrdinal(CAPTHUOC.CAPTHUOCFields.GHICHU.ToString())); } }
private void FrmRpChiPhiKhamChuaBenhQuanNhan_Load(object sender, EventArgs e) { try { BENHNHAN benhnhan = BENHNHANService.GetByPrimaryKey(new BENHNHANKeys((int)khamthuongxuyen.BENHNHANID)); int tong = 0; CAPTHUOC capthuoc = CAPTHUOCService.GetAllEntities().Where(p => p.KHAMTHUONGXUYENID == khamthuongxuyen.ID).FirstOrDefault(); MUONVATTU muonvattu = MUONVATTUService.GetAllEntities().Where(p => p.KHAMTHUONGXUYENID == khamthuongxuyen.ID).FirstOrDefault(); // thuoc int stt = 0; ChiPhiKhamBenhThuocBindingSource.DataSource = CHITIETCAPTHUOCService.GetAllEntities().ToList() .Where(p => p.CAPTHUOCID == capthuoc.ID) .Select(p => new { STT = ++stt, Thuoc = THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).TEN, Dvt = THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).GHICHU, SoLuong = p.SOLUONG, DonGia = Int32.Parse(THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).HAMLUONG).ToString("N0"), ThanhTien = ((int)p.SOLUONG * Int32.Parse(THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).HAMLUONG)).ToString("N0") }) .ToList(); // vat tu int i = 0; ChiPhiKhamBenhVatTuBindingSource.DataSource = CHITIETMUONVATTUService.GetAllEntities().ToList() .Where(p => p.MUONVATTUID == muonvattu.ID) .Select(p => new { STT = ++i, VatTu = VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).TEN, Dvt = VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).KYHIEU, SoLuong = p.SOLUONG, DonGia = Int32.Parse(VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).GHICHU).ToString("N0"), ThanhTien = ((int)p.SOLUONG * Int32.Parse(VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).GHICHU)).ToString("N0") }) .ToList(); tong = CHITIETCAPTHUOCService.GetAllEntities().ToList() .Where(p => p.CAPTHUOCID == capthuoc.ID) .Select(p => new { STT = ++stt, Thuoc = THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).TEN, Dvt = THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).GHICHU, SoLuong = p.SOLUONG, DonGia = Int32.Parse(THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).HAMLUONG).ToString("N0"), ThanhTien = p.SOLUONG * Int32.Parse(THUOCService.GetByPrimaryKey(new THUOCKeys((int)p.THUOCID)).HAMLUONG) }) .Sum(p => (int)p.ThanhTien) + CHITIETMUONVATTUService.GetAllEntities().ToList() .Where(p => p.MUONVATTUID == muonvattu.ID) .Select(p => new { STT = ++i, VatTu = VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).TEN, Dvt = VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).KYHIEU, SoLuong = p.SOLUONG, DonGia = Int32.Parse(VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).GHICHU).ToString("N0"), ThanhTien = p.SOLUONG * Int32.Parse(VATTUService.GetByPrimaryKey(new VATTUKeys((int)p.VATTUID)).GHICHU) }) .Sum(p => (int)p.ThanhTien); ReportParameter[] listPara = new ReportParameter[] { new ReportParameter("HoTen", benhnhan.HOTEN), new ReportParameter("NgaySinh", ((DateTime)benhnhan.NGAYSINH).ToString("dd/MM/yyyy")), new ReportParameter("GioiTinh", (benhnhan.GIOITINH == 1) ? "Nam" : "Nữ"), new ReportParameter("DonVi", DONVIService.GetByPrimaryKey(new DONVIKeys((int)benhnhan.DONVIID)).TEN), new ReportParameter("MaTheBHYT", benhnhan.MATHEBHYT), new ReportParameter("ChanDoan", (khamthuongxuyen.CHANDOANSOBO == null) ? "" : khamthuongxuyen.CHANDOANSOBO), new ReportParameter("ThoiGian", ((DateTime)khamthuongxuyen.THOIGIAN).ToString("dd/MM/yyyy")), new ReportParameter("NguoiLapBangKe", nguoilapbangke), new ReportParameter("PhuTrachQuanY", phutrachquany), new ReportParameter("Ngay", ((DateTime)khamthuongxuyen.THOIGIAN).ToString(@"\N\g\à\y dd \t\h\á\n\g MM \n\ă\m yyyy")), new ReportParameter("Tong", tong.ToString("N0")) }; this.reportViewer1.LocalReport.SetParameters(listPara); this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); } catch { } }
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(); } } }