/// <summary> /// 保存数据 /// </summary> public virtual void SaveImportData(IEnumerable <SysExceptionModel> list) { try { using (DBContainer db = new DBContainer()) { foreach (var model in list) { SysException entity = new SysException(); entity.Id = ResultHelper.NewId; entity.HelpLink = model.HelpLink; entity.Message = model.Message; entity.Source = model.Source; entity.StackTrace = model.StackTrace; entity.TargetSite = model.TargetSite; entity.Data = model.Data; entity.CreateTime = ResultHelper.NowTime; db.SysException.Add(entity); } db.SaveChanges(); } } catch (Exception ex) { throw; } }
public BaseResponse <SysManagerUser> editUser(string loginName, ViewModelUserEditReqeust condtion) { BaseResponse <SysManagerUser> result = new BaseResponse <SysManagerUser>(); try { if (!User.IsInRole("admin")) { loginName = User.Identity.Name; } SysManagerUser smu = new SysManagerUser(loginName); result.result = smu.saveInfo(condtion); result.msg = "保存成功"; } catch (SysException ex) { result = ex.getresult(result, true); } catch (Exception e) { result = SysException.getResult(result, e, condtion); } return(result); }
//[Dependency] //public static ISysExceptionBLL exBLL { get; set; } /// <summary> /// 加入异常日志 /// </summary> /// <param name="ex">异常</param> public static void WriteException(Exception ex) { try { SysException model = new SysException() { Id = ResultHelper.NewId, HelpLink = ex.HelpLink, Message = ex.Message, Source = ex.Source, StackTrace = ex.StackTrace, TargetSite = ex.TargetSite.ToString(), Data = ex.Data.ToString(), CreateTime = ResultHelper.NowTime }; new SysExceptionRepository().Create(model); } catch (Exception ep) { try { //异常失败写入txt string path = @"~/exceptionLog.txt"; string txtPath = System.Web.HttpContext.Current.Server.MapPath(path);//获取绝对路径 using (StreamWriter sw = new StreamWriter(txtPath, true, Encoding.Default)) { sw.WriteLine((ex.Message + "|" + ex.StackTrace + "|" + ep.Message + "|" + DateTime.Now.ToString()).ToString()); sw.Dispose(); sw.Close(); } return; } catch { return; } } }
public bool Create(SysExceptionModel model) { try { if (exceptionRepository.IsExist(model.Id)) { return(false); } SysException entity = new SysException { Id = ResultHelper.NewId, HelpLink = model.HelpLink, Message = model.Message, Source = model.Source, StackTrace = model.StackTrace, TargetSite = model.TargetSite, Data = model.Data, CreateTime = model.CreateTime }; return(exceptionRepository.Create(entity) == 1); } catch (Exception) { return(false); } }
/// <summary> /// Get SysException By Id /// </summary> /// <param name="Id"></param> /// <returns></returns> public SysException GetSysExceptionById(string Id) { SysException sysException = new SysException(); string sql = "SELECT * FROM SysException WHERE Id = '" + Id.ToString() + "'"; SqlCommand sqlCommand = new SqlCommand(); sqlCommand.Connection = dbConnection; sqlCommand.CommandText = sql; SqlDataReader reader = sqlCommand.ExecuteReader(); if (reader.Read()) { DataReader dataReader = new DataReader(reader); sysException.Id = dataReader.GetString("Id"); sysException.HelpLink = dataReader.GetString("HelpLink"); sysException.Message = dataReader.GetString("Message"); sysException.Source = dataReader.GetString("Source"); sysException.StackTrace = dataReader.GetString("StackTrace"); sysException.TargetSite = dataReader.GetString("TargetSite"); sysException.Data = dataReader.GetString("Data"); sysException.CreateTime = dataReader.GetDateTime("CreateTime"); } reader.Close(); return(sysException); }
public ActionResult Edit(string id, SysException entity) { if (entity != null && ModelState.IsValid) { //数据校验 string currentPerson = GetCurrentPerson(); //entity.UpdateTime = DateTime.Now; //entity.UpdatePerson = currentPerson; string returnValue = string.Empty; if (m_BLL.Edit(ref validationErrors, entity)) { LogClassModels.WriteServiceLog(Suggestion.UpdateSucceed + ",异常处理信息的Id为" + id, "异常处理" ); //写入日志 return(Json(Suggestion.UpdateSucceed)); //提示更新成功 } else { if (validationErrors != null && validationErrors.Count > 0) { validationErrors.All(a => { returnValue += a.ErrorMessage; return(true); }); } LogClassModels.WriteServiceLog(Suggestion.UpdateFail + ",异常处理信息的Id为" + id + "," + returnValue, "异常处理" ); //写入日志 return(Json(Suggestion.UpdateFail + returnValue)); //提示更新失败 } } return(Json(Suggestion.UpdateFail + "请核对输入的数据的格式")); //提示输入的数据的格式不对 }
public ActionResult Create(SysException entity) { if (entity != null && ModelState.IsValid) { string currentPerson = GetCurrentPerson(); entity.CreateTime = DateTime.Now; entity.CreatePerson = currentPerson; entity.Id = Result.GetNewId(); string returnValue = string.Empty; if (m_BLL.Create(ref validationErrors, entity)) { LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + ",异常处理的信息的Id为" + entity.Id, "异常处理" );//写入日志 return(Json(Suggestion.InsertSucceed)); } else { if (validationErrors != null && validationErrors.Count > 0) { validationErrors.All(a => { returnValue += a.ErrorMessage; return(true); }); } LogClassModels.WriteServiceLog(Suggestion.InsertFail + ",异常处理的信息," + returnValue, "异常处理" ); //写入日志 return(Json(Suggestion.InsertFail + returnValue)); //提示插入失败 } } return(Json(Suggestion.InsertFail + ",请核对输入的数据的格式")); //提示输入的数据的格式不对 }
public virtual void Modify(ref ValidationErrors errors, Apps.Models.Sys.SysExceptionModel model, params string[] updateProperties) { SysException entity = m_Rep.GetById(model.Id); if (entity == null) { errors.Add(Resource.Disable); return; } if (updateProperties.Count() <= 0) { entity.Id = model.Id; entity.HelpLink = model.HelpLink; entity.Message = model.Message; entity.Source = model.Source; entity.StackTrace = model.StackTrace; entity.TargetSite = model.TargetSite; entity.Data = model.Data; entity.CreateTime = model.CreateTime; } else { Type type = typeof(Apps.Models.Sys.SysExceptionModel); Type typeE = typeof(Apps.Models.SysException); foreach (var item in updateProperties) { System.Reflection.PropertyInfo pi = type.GetProperty(item); System.Reflection.PropertyInfo piE = typeE.GetProperty(item); piE.SetValue(entity, pi.GetValue(model), null); } } m_Rep.Modify(entity, updateProperties); }
/// <summary> /// 删除对象集合 /// </summary> /// <param name="db">数据库</param> /// <param name="deleteCollection">集合</param> public int Delete(AppDBContainer db, string id) { SysException entity = db.SysException.SingleOrDefault(x => x.Id == id); db.SysException.Remove(entity); return(db.SaveChanges()); }
public async Task <IActionResult> HardDelete(int id = 0) { Result result = new Result(false, "Unable to delete post at this time."); if (id != 0) { try { await _post.DeletePostAsync(id); result.Succeeded = true; result.Message = "Post deleted."; } catch (Exception ex) { result.Message = "Unable to delete post at this time."; SysException exception = new SysException(ex) { Url = UrlHelper.GetRequestUrl(HttpContext) }; } } return(Json(new { result })); }
/// <summary> /// 将异常信息写入数据库,或者文本文件 /// </summary> /// <param name="ex"></param> public static void WriteExceptions(Exception ex) { bool exceptionEnabled = Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["ExceptionEnabled"]); if (!exceptionEnabled) { return; } //此处实现异常的记录 SysException sysException = new SysException(); sysException.CreateTime = DateTime.Now; sysException.Remark = ex.StackTrace; sysException.Message = ex.Message; sysException.LeiXing = "异常"; sysException.Result = (ex.InnerException == null) ? string.Empty : ex.InnerException.Message; sysException.Id = Result.GetNewId(); using (SysExceptionBLL sysExceptionRepository = new SysExceptionBLL()) { ValidationErrors validationErrors = new ValidationErrors(); sysExceptionRepository.Create(ref validationErrors, sysException); return; } }
/// <summary> /// 创建一个对象 /// </summary> /// <param name="db">数据库</param> /// <param name="entity">实体</param> public int Create(SysException entity) { using (DBContainer db = new DBContainer()) { db.SysException.Add(entity); return(db.SaveChanges()); } }
public int Create(SysException entity) { using (var db = new SysMgr_DBEntities()) { db.Set <SysException>().Add(entity); return(db.SaveChanges()); } }
public static bool Insert(SysException sysException) { using (var context = db.Context()) { return(context.Insert <SysException>("SysException", sysException) .Execute() > 0); } }
/// <summary> /// 创建一个实体 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Create(SysException entity) { using (AppsDBEntities db = new AppsDBEntities()) { db.SysException.Add(entity); return(db.SaveChanges()); } }
public ActionResult DeleteConfirmed(string id) { SysException sysExceptionModel = db.SysException.Find(id); db.SysException.Remove(sysExceptionModel); db.SaveChanges(); return(RedirectToAction("Index")); }
public int Delete(string id) { using (AppsDBEntities db = new AppsDBEntities()) { SysException entity = db.SysException.SingleOrDefault(a => a.Id == id); db.SysException.Remove(entity); return(db.SaveChanges()); } }
/// <summary> /// 创建一个对象 /// </summary> /// <param name="db">数据库</param> /// <param name="entity">实体</param> public int Create(SysException entity) { using (AppDBContainer db = new AppDBContainer()) { //db.SysExceptions.AddObject(entity); db.SysException.Add(entity); return(db.SaveChanges()); } }
/// <summary> /// 删除对象集合 /// </summary> /// <param name="db">数据库</param> /// <param name="entity">集合</param> public int Delete(string id) { using (DBContainer db = new DBContainer()) { SysException entity = db.SysException.SingleOrDefault(a => a.Id == id); db.Set <SysException>().Remove(entity); return(Convert.ToInt32(db.SaveChanges() > 0)); } }
public ActionResult Edit([Bind(Include = "Id,HelpLink,Message,Source,StackTrace,TargetSite,Data,CreateTime")] SysException sysExceptionModel) { if (ModelState.IsValid) { db.Entry(sysExceptionModel).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sysExceptionModel)); }
public ActionResult Create([Bind(Include = "Id,HelpLink,Message,Source,StackTrace,TargetSite,Data,CreateTime")] SysException sysExceptionModel) { if (ModelState.IsValid) { db.SysException.Add(sysExceptionModel); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sysExceptionModel)); }
public JsonResult Delete(FormCollection postedFormData, [System.Web.Http.FromBody] SysExceptionMaintenanceDTO sysExceptionDTO) { TransactionalInformation transaction; SysExceptionMaintenanceViewModel sysExceptionMaintenanceViewModel = new SysExceptionMaintenanceViewModel(); SysException sysException = new SysException(); ModelStateHelper.UpdateViewModel(sysExceptionDTO, sysException); SysExceptionApplicationService sysExceptionApplicationService = new SysExceptionApplicationService(sysExceptionDataService); sysExceptionApplicationService.DeleteSysExceptionById(sysException.Id, out transaction); sysExceptionMaintenanceViewModel.SysException = sysException; sysExceptionMaintenanceViewModel.ReturnStatus = transaction.ReturnStatus; sysExceptionMaintenanceViewModel.ReturnMessage = transaction.ReturnMessage; sysExceptionMaintenanceViewModel.ValidationErrors = transaction.ValidationErrors; if (transaction.ReturnStatus == false) { //var Json = Request.CreateResponse<CustomerMaintenanceViewModel>(HttpStatusCode.BadRequest, customerMaintenanceViewModel); //return badresponse; //return Json(new //{ // ReturnStatus = sysExceptionMaintenanceViewModel.ReturnStatus, // ViewModel = sysExceptionMaintenanceViewModel, // ValidationErrors = sysExceptionMaintenanceViewModel.ValidationErrors, // //MessageBoxView = Helpers.MvcHelpers.RenderPartialView(this, "_MessageBox", sysExceptionMaintenanceViewModel), // //JsonRequestBehavior.AllowGet //}); return(Json(0, JsonRequestBehavior.AllowGet)); } else { //var response = Request.CreateResponse<CustomerMaintenanceViewModel>(HttpStatusCode.Created, customerMaintenanceViewModel); //return response; //return Json(new //{ // ReturnStatus = sysExceptionMaintenanceViewModel.ReturnStatus, // ViewModel = sysExceptionMaintenanceViewModel, // ValidationErrors = sysExceptionMaintenanceViewModel.ValidationErrors, // //MessageBoxView = Helpers.MvcHelpers.RenderPartialView(this, "_MessageBox", sysExceptionMaintenanceViewModel), // JsonRequestBehavior.AllowGet //}); return(Json(1, JsonRequestBehavior.AllowGet)); } }
public static bool Update(SysException sysException) { using (var context = db.Context()) { return(context.Update <SysException>("SysException", sysException) .AutoMap(x => x.Id) .Where("Id", sysException.Id) .Execute() > 0); } }
public bool IsExist(string id) { using (DBContainer db = new DBContainer()) { SysException entity = GetById(id); if (entity != null) { return(true); } return(false); } }
public async Task <IActionResult> Delete(DeletePostViewModel model) { Result result = new Result(false, "Unable to delete post at this time."); if (ModelState.IsValid) { Post post = await _post.GetPostAndCommentsAsync(model.Id); post.IsActive = false; post.RowModifiedBy = Convert.ToInt32(_userManager.GetUserId(User)); post.RowModifiedDateTime = DateTime.Now; if (post.Comments != null && post.Comments.Count() != 0) { foreach (var comment in post.Comments) { comment.IsActive = false; comment.RowModifiedBy = post.RowModifiedBy; comment.RowModifiedDateTime = post.RowModifiedDateTime; if (comment.Replies != null && comment.Replies.Count() != 0) { foreach (var reply in comment.Replies) { reply.IsActive = false; reply.RowModifiedBy = post.RowModifiedBy; reply.RowModifiedDateTime = post.RowModifiedDateTime; } } } } try { await _post.EditPostAsync(post); result.Succeeded = true; result.Message = "Post deleted."; } catch (Exception ex) { result.Message = "Unable to delete post at this time."; SysException exception = new SysException(ex) { Url = UrlHelper.GetRequestUrl(HttpContext) }; } } return(Json(result)); }
/// <summary> /// 创建一个异常处理 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据库上下文</param> /// <param name="entity">一个异常处理</param> /// <returns></returns> public bool Create(ref ValidationErrors validationErrors, SysException entity) { try { return(repository.Create(entity) == 1); } catch (Exception ex) { validationErrors.Add(ex.Message); ExceptionsHander.WriteExceptions(ex); } return(false); }
public BaseResponse <List <SysCatTree> > getTreelist(string fun) { BaseResponse <List <SysCatTree> > result = new BaseResponse <List <SysCatTree> >(); try { result.result = SysCatTree.getTreeList(fun); } catch (Exception e) { result = SysException.getResult(result, e, fun); } return(result); }
public BaseResponse <BaseResponseList <SysUserLog> > searchUserLog(ViewModelMsgSearchUserLogReqeust condtion) { BaseResponse <BaseResponseList <SysUserLog> > result = new BaseResponse <BaseResponseList <SysUserLog> >(); try { result.result = SysUserLog.searchLog(condtion); } catch (Exception e) { SysException.getResult(result, e, condtion); } return(result); }
public BaseResponse <BaseResponseList <SysManagerUser> > searchUserList(ViewModelSearchUserBaseRequest condtion) { BaseResponse <BaseResponseList <SysManagerUser> > res = new BaseResponse <BaseResponseList <SysManagerUser> >(); try { res.result = SysManagerUser.searchUserList(condtion); } catch (Exception e) { res = SysException.getResult(res, e, condtion); } return(res); }
public BaseResponse <BaseResponseList <SysExcptionLog> > searchExceptionLog(VMMsgSearchExceptionLogRequest condtion) { BaseResponse <BaseResponseList <SysExcptionLog> > result = new BaseResponse <BaseResponseList <SysExcptionLog> >(); try { result.result = SysExcptionLog.searchLog(condtion); } catch (Exception e) { result = SysException.getResult(result, e, condtion); } return(result); }
/// <summary> /// 创建一个异常处理 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="db">数据库上下文</param> /// <param name="entity">一个异常处理</param> /// <returns></returns> public bool Create(ref ValidationErrors validationErrors, SysException entity) { try { repository.Create(entity); return true; } catch (Exception ex) { validationErrors.Add(ex.Message); //ExceptionsHander.WriteExceptions(ex); } return false; }
/// <summary> /// 编辑一个异常处理 /// </summary> /// <param name="validationErrors">返回的错误信息</param> /// <param name="entity">一个异常处理</param> /// <returns></returns> public bool Edit(ref ValidationErrors validationErrors, SysException entity) { try { repository.Edit(db, entity); repository.Save(db); return true; } catch (Exception ex) { validationErrors.Add(ex.Message); ExceptionsHander.WriteExceptions(ex); } return false; }