public void onSave() { this.Cursor = Cursors.Wait; try { if (ValidateValue()) { HT_TSO ret = null; QuanTriHeThongProcess process = new QuanTriHeThongProcess(); // Nếu là thêm mới if (id == 0) { //getObject(DatabaseConstant.Action.THEM); //ret = process.ThemNSD(obj, lstIdNHNSD); //afterAddNew(ret); } // Nếu là sửa else { getObjectValue(DatabaseConstant.Action.SUA); ret = process.capNhatGiaTriThamSo(obj); afterModify(ret); } } } catch (System.Exception ex) { CommonFunction.ThongBaoLoi(ex); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } Mouse.OverrideCursor = Cursors.Arrow; }
public HT_TSO SuaGiaTriThamSo(HT_TSO obj) { HT_TSO kq = null; Entities entities = ContextFactory.GetInstance(); EntityKey key = null; object original = null; try { key = entities.CreateEntityKey(ENTITY_SET_NAME, obj); if (entities.TryGetObjectByKey(key, out original)) { entities.ApplyCurrentValues(key.EntitySetName, obj); } entities.SaveChanges(); kq = obj; } catch (System.Exception ex) { kq = null; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } finally { entities = null; } return(kq); }
public bool ThoaiDuyetListTheoID(List <int> listID) { bool kq = true; Entities entities = ContextFactory.GetInstance(); try { using (TransactionScope trans = new TransactionScope()) { foreach (int id in listID) { HT_TSO obj = new HT_TSO(); obj = entities.HT_TSO.FirstOrDefault(e => e.ID == id); obj.TTHAI_NVU = BusinessConstant.TrangThaiNghiepVu.THOAI_DUYET.layGiaTri(); entities.SaveChanges(); } trans.Complete(); } } catch (System.Exception ex) { kq = false; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } finally { entities = null; } return(kq); }
public bool XoaListTheoID(List <int> listID) { bool kq = true; Entities entities = ContextFactory.GetInstance(); try { using (TransactionScope trans = new TransactionScope()) { foreach (int id in listID) { HT_TSO obj = new HT_TSO(); obj = entities.HT_TSO.FirstOrDefault(e => e.ID == id); entities.HT_TSO.DeleteObject(obj); entities.SaveChanges(); } trans.Complete(); } } catch (System.Exception ex) { kq = false; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } finally { entities = null; } return(kq); }
public HT_TSO layThamSoDonVi(BusinessConstant.LoaiThamSo loaiThamSo, BusinessConstant.MaThamSo maThamSo, string maDonVi) { try { HT_TSO htTso = null; Entities entities = ContextFactory.GetInstance(); string strLoaiThamSo = loaiThamSo.layGiaTri(); string strMaThamSo = maThamSo.layGiaTri(); //htTso = entities.HT_TSO.FirstOrDefault(e => e.MA_TSO_LOAI.Equals(strLoaiThamSo) && e.MA_TSO.Equals(strMaThamSo) && e.MA_DVI_QLY.Equals(maDonVi)); htTso = entities.HT_TSO.Where(e => e.MA_TSO_LOAI.Equals(strLoaiThamSo) && e.MA_TSO.Equals(strMaThamSo) && e.MA_DVI_QLY.Equals(maDonVi)).ToList().FirstOrDefault(); return(htTso); } catch (Exception ex) { // Ghi log LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } }
public HT_TSO GetByMa(string ma) { HT_TSO kq = null; Entities entities = ContextFactory.GetInstance(); try { kq = entities.HT_TSO.FirstOrDefault(e => e.MA_TSO.Equals(ma)); return(kq); } catch (System.Exception ex) { kq = null; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } finally { entities = null; } return(kq); }
/// <summary> /// Thêm đối tượng Tham số /// </summary> /// <param name="obj">Đối tượng Tham số</param> /// <returns>True nếu thành công, false ngược lại</returns> public bool Them(HT_TSO obj) { bool kq = true; Entities entities = ContextFactory.GetInstance(); try { entities.HT_TSO.AddObject(obj); entities.SaveChanges(); } catch (System.Exception ex) { kq = false; LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); throw ex; } finally { entities = null; } return(kq); }
/// <summary> /// Sau khi sửa /// </summary> /// <param name="ret"></param> private void afterModify(HT_TSO ret) { if (ret != null) { LMessage.ShowMessage("M.DungChung.CapNhatThanhCong", LMessage.MessageBoxType.Information); id = ret.ID; TthaiNvu = ret.TTHAI_NVU; lblTrangThai.Content = BusinessConstant.layNgonNguSuDung(ret.TTHAI_BGHI); txtTrangThai.Text = BusinessConstant.layNgonNguSuDung(ret.TTHAI_BGHI); raddtNgayNhap.Value = LDateTime.StringToDate(obj.NGAY_NHAP, "yyyyMMdd"); txtNguoiLap.Text = obj.NGUOI_NHAP; raddtNgayCNhat.Value = LDateTime.StringToDate(obj.NGAY_CNHAT, "yyyyMMdd"); txtNguoiCapNhat.Text = obj.NGUOI_CNHAT; CommonFunction.RefreshButton(Toolbar, DatabaseConstant.Action.XEM, tthaiNvu, mnuMain, DatabaseConstant.Function.HT_THAM_SO); formCase = "XEM"; HideControl(); } else { LMessage.ShowMessage("M.DungChung.CapNhatKoThanhCong", LMessage.MessageBoxType.Error); } // Yêu cầu Unlock bản ghi cần sửa UtilitiesProcess process = new UtilitiesProcess(); List <int> listLockId = new List <int>(); listLockId.Add(id); bool retUnlockData = process.UnlockData(DatabaseConstant.Module.QTHT, DatabaseConstant.Function.HT_THAM_SO, DatabaseConstant.Table.HT_TSO, DatabaseConstant.Action.SUA, listLockId); }
public void getObject(DatabaseConstant.Action action) { Mouse.OverrideCursor = Cursors.Wait; try { if (obj == null) { obj = new HT_TSO(); } //obj.MA_TSO_LOAI = txtMaLoaiThamSo.Text; //obj.ID_TSO_LOAI = idLoai; obj.MA_TSO = txtMaThamSo.Text; obj.TEN_TSO = txtTenThamSo.Text; obj.PVI_AHUONG = lstSourcePhamVi.ElementAt(cmbPhamViAHuong.SelectedIndex).KeywordStrings.First(); obj.MO_TA = txtMoTaThamSo.Text; obj.MA_DVI_QLY = ClientInformation.MaDonVi; obj.MA_DVI_TAO = ClientInformation.MaDonVi; obj.HTHI_DIEU_KHIEN = lstSourceLoaiControl.ElementAt(cmbHienThiTren.SelectedIndex).KeywordStrings.First(); obj.HTHI_GTRI_MDINH = txtGiaTriMacDinh.Text; obj.GIA_TRI = txtGiaTri.Text; //if (rbtCodeQuery.IsChecked == true) //{ // obj.HTHI_POPUP = BusinessConstant.CoKhong.CO.layGiaTri(); // obj.HTHI_SDUNG_TVAN = BusinessConstant.CoKhong.CO.layGiaTri(); //} //else //{ obj.HTHI_POPUP = BusinessConstant.CoKhong.KHONG.layGiaTri(); obj.HTHI_SDUNG_TVAN = BusinessConstant.CoKhong.KHONG.layGiaTri(); //} //if (rbtSQLQuery.IsChecked == true) // obj.HTHI_SQL = BusinessConstant.CoKhong.CO.layGiaTri(); //else obj.HTHI_SQL = BusinessConstant.CoKhong.KHONG.layGiaTri(); //obj.ID_PHAN_HE = Convert.ToInt32(lstSourcePhanHe.ElementAt(cmbThuocPhanHe.SelectedIndex).KeywordStrings.ElementAt(1)); obj.MA_PHAN_HE = lstSourcePhanHe.ElementAt(cmbThuocPhanHe.SelectedIndex).KeywordStrings.First(); obj.KIEU_DU_LIEU = lstSourceKieuDL.ElementAt(cmbKieuDuLieu.SelectedIndex).KeywordStrings.First(); obj.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(); obj.NGAY_CNHAT = string.IsNullOrEmpty(raddtNgayCNhat.Value.ToString().Trim()) ? ((DateTime)raddtNgayCNhat.Value).ToString("yyyyMMdd") : (DateTime.Today).ToString("yyyyMMdd"); if (obj.ID == 0) { obj.NGAY_NHAP = string.IsNullOrEmpty(raddtNgayCNhat.Value.ToString().Trim()) ? ((DateTime)raddtNgayNhap.Value).ToString("yyyyMMdd") : (DateTime.Today).ToString("yyyyMMdd"); obj.NGUOI_NHAP = ClientInformation.TenDangNhap; } obj.NGUOI_CNHAT = ClientInformation.TenDangNhap; obj.NGUON_TAO_DL = "NSD"; string strTTNV = string.Empty; if (obj.ID > 0) { strTTNV = obj.TTHAI_NVU; } obj.TTHAI_NVU = CommonFunction.LayTrangThaiBanGhi(action, BusinessConstant.layTrangThaiNghiepVu(strTTNV)); obj.TTHAI_BGHI = BusinessConstant.TrangThaiBanGhi.SU_DUNG.layGiaTri(); } catch (System.Exception ex) { CommonFunction.ThongBaoLoi(ex); LLogging.WriteLog(System.Reflection.MethodInfo.GetCurrentMethod().ToString(), LLogging.LogType.ERR, ex); } Mouse.OverrideCursor = Cursors.Arrow; }