public int GetTaskPunishmentCount(TaskPunishmentSearchCondition condition) { var query = _taskpunishmentRepository.Table; try { if (!string.IsNullOrEmpty(condition.Name)) { query = query.Where(q => q.Name.Contains(condition.Name)); } if (!string.IsNullOrEmpty(condition.NameRe)) { query = query.Where(q => q.Name == condition.NameRe); } if (!string.IsNullOrEmpty(condition.Describe)) { query = query.Where(q => q.Describe.Contains(condition.Describe)); } if (!string.IsNullOrEmpty(condition.Value)) { query = query.Where(q => q.Value.Contains(condition.Value)); } if (condition.Ids != null && condition.Ids.Any()) { query = query.Where(q => condition.Ids.Contains(q.Id)); } return(query.Count()); } catch (Exception e) { _log.Error(e, "数据库操作出错"); return(-1); } }
public IQueryable <TaskPunishmentEntity> GetTaskPunishmentsByCondition(TaskPunishmentSearchCondition condition) { var query = _taskpunishmentRepository.Table; try { if (!string.IsNullOrEmpty(condition.Name)) { query = query.Where(q => q.Name.Contains(condition.Name)); } if (!string.IsNullOrEmpty(condition.Describe)) { query = query.Where(q => q.Describe.Contains(condition.Describe)); } if (!string.IsNullOrEmpty(condition.Value)) { query = query.Where(q => q.Value.Contains(condition.Value)); } if (condition.Ids != null && condition.Ids.Any()) { query = query.Where(q => condition.Ids.Contains(q.Id)); } if (condition.OrderBy.HasValue) { switch (condition.OrderBy.Value) { case EnumTaskPunishmentSearchOrderBy.OrderById: query = condition.isDescending?query.OrderByDescending(q => q.Id):query.OrderBy(q => q.Id); break; } } else { query = query.OrderBy(q => q.Id); } if (condition.Page.HasValue && condition.PageCount.HasValue) { query = query.Skip((condition.Page.Value - 1) * condition.PageCount.Value).Take(condition.PageCount.Value); } return(query); } catch (Exception e) { _log.Error(e, "数据库操作出错"); return(null); } }
public HttpResponseMessage TaskPunishmentList() { //var condition = new TaskPunishmentSearchCondition //{ // OrderBy = EnumTaskPunishmentSearchOrderBy.OrderById //}; //return PageHelper.toJson(_taskPunishmentService.GetTaskPunishmentsByCondition(condition).ToList()); var condition = new TaskPunishmentSearchCondition { OrderBy = EnumTaskPunishmentSearchOrderBy.OrderById }; var typelist = _taskPunishmentService.GetTaskPunishmentsByCondition(condition).Select(p => new { Id = p.Id, Name = p.Name }).ToList(); return(PageHelper.toJson(typelist)); }
public HttpResponseMessage AddTaskPunishment([FromBody] TaskPunishmentModel taskPunishmentModel) { if (!string.IsNullOrWhiteSpace(taskPunishmentModel.Name)) { Regex reg = new Regex(@"^[^ %@#!*~&',;=?$\x22]+$"); var m = reg.IsMatch(taskPunishmentModel.Name); if (!m) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "惩罚名称存在非法字符!"))); } if (!string.IsNullOrEmpty(taskPunishmentModel.Describe)) { var m1 = reg.IsMatch(taskPunishmentModel.Describe); if (!m1) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "描述存在非法字符!"))); } } var model = new TaskPunishmentEntity { Id = taskPunishmentModel.Id, Name = taskPunishmentModel.Name, Describe = taskPunishmentModel.Describe, Value = taskPunishmentModel.Value }; var mo1 = new TaskPunishmentSearchCondition { NameRe = taskPunishmentModel.Name }; if (taskPunishmentModel.Type == "add") { int taskPunishCount = _taskPunishmentService.GetTaskPunishmentCount(mo1); if (taskPunishCount > 0) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "名称重复,请更换"))); } else { try { _taskPunishmentService.Create(model); return(PageHelper.toJson(PageHelper.ReturnValue(true, "添加成功"))); } catch (Exception) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "添加失败"))); } } } if (taskPunishmentModel.Type == "edit") { try { _taskPunishmentService.Update(_taskPunishmentService.GetTaskPunishmentById(taskPunishmentModel.Id)); return(PageHelper.toJson(PageHelper.ReturnValue(true, "修改失败"))); } catch (Exception) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "修改失败"))); } } } return(PageHelper.toJson(PageHelper.ReturnValue(false, "类型名称不能为空"))); }