public ResGetTasks GetTasks([FromHeader] ReqTaskBase task)
{
ResGetTasks retValue = new ResGetTasks();
using (var db = DbContext.GetInstance("T_TASK"))
{
try
{
if (string.IsNullOrEmpty(task.createUserCode))
{
retValue.FailDefalut("必填参数【用户编号】");
}
else
{
//如果有信息被设置为置顶并且根据创建时间降序
var TaskList = db.Queryable <TASKBASE>()
.Where(s => s.isDone == task.isDone)
.Where(s => s.createUserCode == task.createUserCode)
.OrderBy(s => s.lastEditTime, OrderByType.desc)
.ToList();
//分页 0是第一页
var reList = TaskList.Skip((task.currentPage - 1) * task.pageSize)
.Take(task.pageSize).ToList();
retValue.SuccessDefalut(reList, TaskList.Count);
}
}
catch (Exception ex)
{
retValue.FailDefalut(ex);
}
}
return(retValue);
}
public ResTaskBase UpdateTask([FromBody] ReqTaskBase task)
{
ResTaskBase retValue = new ResTaskBase();
using (var db = DbContext.GetInstance("T_TASK"))
{
try
{
bool isIDExist = db.Queryable <TASKBASE>()
.Any(s => s.ID == task.ID);
if (isIDExist)
{
// 设置禁止更新列
db.AddDisableUpdateColumns("create_time");
//规范日期格式
db.SerializerDateFormat = "yyyy-mm-dd";
//设置时间
task.lastEditTime = DateTime.Now;
//设置最近编辑人
task.lastEditUserCode = task.createUserCode;
task.lastEditUserName = task.createUserName;
var taskModel = new TASKBASE();
//只更新需要更新的部分
db.Update <TASKBASE>(
new
{
taskTitle = task.taskTitle,
endTime = task.endTime,
taskDescription = task.taskDescription,
isDone = task.isDone,
lastEditUserName = task.lastEditUserName,
lastEditUserCode = task.lastEditUserCode
},
it => it.ID == task.ID
);
retValue.SuccessDefalut("编辑任务成功", 1);
LogWirter.Record(LogType.Personal, OpType.Update, task.taskTitle + "]", "编辑任务 [", task.ID, task.createUserCode, task.createUserName);
}
else
{
retValue.FailDefalut("不存在该任务ID");
}
}
catch (Exception ex)
{
retValue.FailDefalut(ex);
}
}
return(retValue);
}
