/// <summary>
/// 获取我已审批
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public PageResponse <string> getHaveApprovedList(QueryPendingRequest request)
{
var query = Db.Queryable <TaskRecord, ApproveRecord>((tr, ar) => new object[]
{
JoinType.Left, tr.Id == ar.DocId
}).Where((tr, ar) => tr.Desc.Contains(request.key) && ar.ApproverId == user.UserId && !ar.Result.Equals("已提交"));
if (!string.IsNullOrEmpty(request.startTime) && !string.IsNullOrEmpty(request.endTime))
{
query = query.Where((tr, ar) => SqlFunc.Between(tr.CreateTime, request.startTime, request.endTime));
}
var total = 0;
var json = query.Select((tr, ar) => new
{
id = tr.Id, submitterName = tr.SubmitterName, desc = tr.Desc, status = tr.Status, createTime = tr.CreateTime,
attachment = tr.Attachment, percent = tr.Percent, taskId = tr.TaskId
}).ToPageList(request.page, request.limit, ref total).ToJson();
// 此处返回json的原因是 目前审批类别只有任务完成情况 以后可能会新增审批类别 所以统一转成json返回
var pageResponse = new PageResponse <string> {
Total = total, Result = json
};
return(pageResponse);
}
public PageResponse <string> getMySubmitList(QueryPendingRequest request)
{
var result = new PageResponse <string>();
try
{
result = _service.getMySubmitList(request);
}
catch (Exception ex)
{
result.Code = 500;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 获取我已提交
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public PageResponse <string> getMySubmitList(QueryPendingRequest request)
{
var query = SimpleDb.AsQueryable().Where(u => u.SubmitterId == user.UserId && u.Desc.Contains(request.key));
if (!string.IsNullOrEmpty(request.startTime) && !string.IsNullOrEmpty(request.endTime))
{
query = query.Where(u => SqlFunc.Between(u.CreateTime, request.startTime, request.endTime));
}
var total = 0;
var json = query.Select(u => new
{
id = u.Id, submitterName = u.SubmitterName, desc = u.Desc, status = u.Status, createTime = u.CreateTime,
attachment = u.Attachment, percent = u.Percent, taskId = u.TaskId
}).ToPageList(request.page, request.limit, ref total).ToJson();
// 此处返回json的原因是 目前审批类别只有任务完成情况 以后可能会新增审批类别 所以统一转成json返回
var pageResponse = new PageResponse <string> {
Total = total, Result = json
};
return(pageResponse);
}
