public HttpResponseMessage DelTaskTag(int id)
{
try
{
var cond = new TaskSearchCondition()
{
tagId = id
};
int tlistcout = _taskService.GetTaskCount(cond);
if (tlistcout > 0) { return PageHelper.toJson(PageHelper.ReturnValue(false, "该目标使用中，删除失败")); }
else
{
_taskTagService.Delete(_taskTagService.GetTaskTagById(id));
return PageHelper.toJson(PageHelper.ReturnValue(true, "删除成功"));
}
}
catch (Exception)
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "删除失败"));
}
}
public HttpResponseMessage TaskList(string Taskname="", int page=1, int pageSize=10, EnumTaskSearchOrderBy orderByAll = EnumTaskSearchOrderBy .OrderById, bool isDes = true)
{
//验证是否有非法字符
Regex reg = new Regex(@"^[^ %@#!*~&',;=?$\x22]+$");
if (!string.IsNullOrEmpty(Taskname))
{
var m = reg.IsMatch(Taskname);
if (!m)
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "搜索输入存在非法字符！"));
}
}
var taskcondition = new TaskSearchCondition
{
OrderBy =orderByAll,
Taskname = Taskname,
Page = page,
PageCount = pageSize,
IsDescending =isDes
};
try
{
var taskList = _taskService.GetTasksByCondition(taskcondition).Select(p => new
{
Taskname = p.Taskname,
Name = p.TaskType.Name,
Endtime = p.Endtime,
Adduser = p.Adduser,
Id = p.Id
}).ToList().Select(p => new
{
Taskname = p.Taskname,
Name = p.Name,
Endtime = p.Endtime.ToShortDateString(),
// Adduser = _brokerService.GetBrokerByUserId(p.Adduser).Brokername,
Adduser = _userservice.GetUserById(p.Adduser) == null ? p.Adduser.ToString() : _userservice.GetUserById(p.Adduser).UserName,
Id = p.Id
}).ToList();
var taskCount = _taskService.GetTaskCount(taskcondition);
if (taskCount > 0)
{
return PageHelper.toJson(new { list = taskList, totalCount = taskCount, condition = taskcondition });
}
else
{
return PageHelper.toJson(PageHelper.ReturnValue(true, "不存在数据！"));
}
}
catch {
return PageHelper.toJson(PageHelper.ReturnValue(false , "出现数据错误！"));
}
}
public HttpResponseMessage AddTask([FromBody]TaskModel taskModel)
{
if (!string.IsNullOrEmpty(taskModel.Taskname))
{
//用正则表达式验证是否存在非法字符/^(\d{4})-(0\d{1}|1[0-2])-(0\d{1}|[12]\d{1}|3[01])$/
Regex reg = new Regex(@"^[^ %@#!*~&',;=?$\x22]+$");
var m = reg.IsMatch(taskModel.Taskname);
if (!m)
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "任务名称存在非法字符！"));
}
//验证日期格式
if (taskModel.Endtime == null)
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "结束时间格式错误！"));
}
if (DateTime.Today >= Convert.ToDateTime(taskModel.Endtime))
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "结束时间至少是明天！"));
}
if (!string.IsNullOrEmpty(taskModel.Describe))
{
var m1 = reg.IsMatch(taskModel.Describe);
if (!m1)
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "描述存在非法字符！"));
}
}
var user = (UserBase)_workContext.CurrentUser;
var model = new TaskEntity
{
Id = user.Id,
TaskPunishment = _taskPunishmentService.GetTaskPunishmentById(taskModel.TaskPunishmentId),
TaskAward = _taskAwardService.GetTaskAwardById(taskModel.TaskAwardId),
TaskTag = _taskTagService.GetTaskTagById(taskModel.TaskTagId),
TaskType = _taskTypeService.GetTaskTypeById(taskModel.TaskTypeId),
Taskname = taskModel.Taskname,
Describe = taskModel.Describe,
Endtime = Convert.ToDateTime(taskModel.Endtime),
Adduser = _workContext.CurrentUser.Id,
Addtime = DateTime.Now,
Upuser = 0,
Uptime = DateTime.Now,
};
var mo1 = new TaskSearchCondition
{
TasknameRe = taskModel.Taskname
};
if (taskModel.Type == "add")
{
//判断是否存在同名名称
int taskCount = _taskService.GetTaskCount(mo1);
if (taskCount == 0)
{
try
{
if (_taskService.Create(model) != null)
{
return PageHelper.toJson(PageHelper.ReturnValue(true, "添加成功"));
}
}
catch (Exception)
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "添加失败"));
}
}
else
{ return PageHelper.toJson(PageHelper.ReturnValue(false, "任务名称已存在，请换名称")); }
}
if (taskModel.Type == "edit")
{
var cond = new TaskListSearchCondition()
{
TaskId = taskModel.Id
};
//判断任务是否被接手
int tlistcout = _taskListService.GetTaskListCount(cond);
//判断是否存在同名名称
var mo11 = new TaskSearchCondition
{
TasknameRe = taskModel.Taskname,
Id = taskModel.Id
};
int tasknameCount = _taskService.GetTaskCount(mo11);
if (tlistcout > 0) { return PageHelper.toJson(PageHelper.ReturnValue(false, "不能修改，已经有人接手任务")); }
else if (tasknameCount > 0) { return PageHelper.toJson(PageHelper.ReturnValue(false, "任务名称已存在，请换名称")); }
else
{
var mdel = _taskService.GetTaskById(taskModel.Id);
mdel.Id = taskModel.Id;
mdel.TaskPunishment = _taskPunishmentService.GetTaskPunishmentById(taskModel.TaskPunishmentId);
mdel.TaskAward = _taskAwardService.GetTaskAwardById(taskModel.TaskAwardId);
mdel.TaskTag = _taskTagService.GetTaskTagById(taskModel.TaskTagId);
mdel.TaskType = _taskTypeService.GetTaskTypeById(taskModel.TaskTypeId);
mdel.Taskname = taskModel.Taskname;
mdel.Describe = taskModel.Describe;
mdel.Endtime = Convert.ToDateTime(taskModel.Endtime);
mdel.Upuser = _workContext.CurrentUser.Id;
mdel.Uptime = DateTime.Now;
try
{
_taskService.Update(mdel);
return PageHelper.toJson(PageHelper.ReturnValue(true, "修改成功"));
}
catch (Exception)
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "修改失败"));
}
}
}
}
else
{
return PageHelper.toJson(PageHelper.ReturnValue(false, "任务名称不能为空！"));
}
return PageHelper.toJson(PageHelper.ReturnValue(false, "数据验证失败"));
}
public HttpResponseMessage TaskListMobile(int page, string type)
{
int pageSize = 10;
var taskcondition = new TaskSearchCondition
{
OrderBy = EnumTaskSearchOrderBy.OrderById,
Page = page,
PageCount = pageSize,
};
if (type == "today")///查找今天的任务，否则查询所有任务
{
//taskcondition.AddtimeBegin = DateTime.Today;
//taskcondition.AddtimeEnd = DateTime.Today.AddDays(1);
taskcondition.PageCount = 5;
taskcondition.Page = 1;
taskcondition.IsDescending = true;//降序
}
var taskList = _taskService.GetTasksByCondition(taskcondition).Select(p => new
{
Taskname = p.Taskname,
Name = p.TaskType.Name,
awardname = p.TaskAward.Name,
awardvalue = p.TaskAward.Value,
Endtime = p.Endtime,
Adduser = p.Adduser,
Id = p.Id,
}).ToList();
var taskCount = _taskService.GetTaskCount(taskcondition);
if (taskCount > 0)
{
return PageHelper.toJson(new { list = taskList, totalCount = taskCount, condition = taskcondition });
}
else
{
return PageHelper.toJson(PageHelper.ReturnValue(true, "不存在数据！"));
}
}
public IQueryable<TaskEntity> GetTasksByCondition(TaskSearchCondition condition)
{
var query = _taskRepository.Table;
try
{
if (condition.EndtimeBegin.HasValue)
{
query = query.Where(q => q.Endtime>= condition.EndtimeBegin.Value);
}
if (condition.EndtimeEnd.HasValue)
{
query = query.Where(q => q.Endtime < condition.EndtimeEnd.Value);
}
if (condition.AddtimeBegin.HasValue)
{
query = query.Where(q => q.Addtime>= condition.AddtimeBegin.Value);
}
if (condition.AddtimeEnd.HasValue)
{
query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value);
}
if (condition.UptimeBegin.HasValue)
{
query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value);
}
if (condition.UptimeEnd.HasValue)
{
query = query.Where(q => q.Uptime < condition.UptimeEnd.Value);
}
if (!string.IsNullOrEmpty(condition.Taskname))
{
query = query.Where(q => q.Taskname.Contains(condition.Taskname));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.Id >0)
{
query = query.Where(q => condition.Id==q.Id);
}
if (condition.TaskPunishments != null && condition.TaskPunishments.Any())
{
query = query.Where(q => condition.TaskPunishments.Contains(q.TaskPunishment));
}
if (condition.TaskAwards != null && condition.TaskAwards.Any())
{
query = query.Where(q => condition.TaskAwards.Contains(q.TaskAward));
}
if (condition.TaskTags != null && condition.TaskTags.Any())
{
query = query.Where(q => condition.TaskTags.Contains(q.TaskTag));
}
if (condition.TaskTypes != null && condition.TaskTypes.Any())
{
query = query.Where(q => condition.TaskTypes.Contains(q.TaskType));
}
if (condition.Addusers != null && condition.Addusers.Any())
{
query = query.Where(q => condition.Addusers.Contains(q.Adduser));
}
if (condition.Upusers != null && condition.Upusers.Any())
{
query = query.Where(q => condition.Upusers.Contains(q.Upuser));
}
if(condition.OrderBy.HasValue)
{
switch (condition.OrderBy.Value)
{
case EnumTaskSearchOrderBy.OrderById:
query = condition.IsDescending?query.OrderByDescending(q=>q.Id):query.OrderBy(q=>q.Id);
break;
case EnumTaskSearchOrderBy.OrderByTaskname:
query = condition.IsDescending ? query.OrderByDescending(q => q.Taskname) : query.OrderBy(q => q.Taskname);
break;
case EnumTaskSearchOrderBy.OrderByName:
query = condition.IsDescending ? query.OrderByDescending(q => q.TaskType.Name) : query.OrderBy(q => q.TaskType.Name);
break;
case EnumTaskSearchOrderBy.OrderByEndtime:
query = condition.IsDescending ? query.OrderByDescending(q => q.Endtime) : query.OrderBy(q => q.Endtime);
break;
case EnumTaskSearchOrderBy.OrderByAdduser:
query = condition.IsDescending ? query.OrderByDescending(q => q.Adduser) : query.OrderBy(q => q.Adduser);
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 int GetTaskCount (TaskSearchCondition condition)
{
var query = _taskRepository.Table;
try
{
if (condition.EndtimeBegin.HasValue)
{
query = query.Where(q => q.Endtime>= condition.EndtimeBegin.Value);
}
if (condition.EndtimeEnd.HasValue)
{
query = query.Where(q => q.Endtime < condition.EndtimeEnd.Value);
}
if (condition.AddtimeBegin.HasValue)
{
query = query.Where(q => q.Addtime>= condition.AddtimeBegin.Value);
}
if (condition.AddtimeEnd.HasValue)
{
query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value);
}
if (condition.UptimeBegin.HasValue)
{
query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value);
}
if (condition.UptimeEnd.HasValue)
{
query = query.Where(q => q.Uptime < condition.UptimeEnd.Value);
}
if (!string.IsNullOrEmpty(condition.Taskname))
{
query = query.Where(q => q.Taskname.Contains(condition.Taskname));
}
if (!string.IsNullOrEmpty(condition.TasknameRe))
{
query = query.Where(q => q.Taskname==condition.TasknameRe);
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.TaskPunishments != null && condition.TaskPunishments.Any())
{
query = query.Where(q => condition.TaskPunishments.Contains(q.TaskPunishment));
}
if (condition.TaskAwards != null && condition.TaskAwards.Any())
{
query = query.Where(q => condition.TaskAwards.Contains(q.TaskAward));
}
if (condition.TaskTags != null && condition.TaskTags.Any())
{
query = query.Where(q => condition.TaskTags.Contains(q.TaskTag));
}
if (condition.TaskTypes != null && condition.TaskTypes.Any())
{
query = query.Where(q => condition.TaskTypes.Contains(q.TaskType));
}
if (condition.Addusers != null && condition.Addusers.Any())
{
query = query.Where(q => condition.Addusers.Contains(q.Adduser));
}
if (condition.Addusers != null && condition.Addusers.Any())
{
query = query.Where(q => condition.Addusers.Contains(q.Adduser));
}
if (condition.typeId >0)
{
query = query.Where(q => q.TaskType.Id == condition.typeId);
}
if (condition.awardId >0)
{
query = query.Where(q => q.TaskAward.Id == condition.awardId);
}
if (condition.punishId >0)
{
query = query.Where(q => q.TaskPunishment.Id == condition.punishId);
}
if (condition.tagId >0)
{
query = query.Where(q => q.TaskTag.Id == condition.tagId);
}
if (condition.Id > 0)
{
query = query.Where(q => q.Id!= condition.Id);
}
return query.Count();
}
catch(Exception e)
{
_log.Error(e,"数据库操作出错");
return -1;
}
}
