public IActionResult keshizongjies(alltaskrequestpayload payload)
{
using (_dbContext)
{
var query = from m in _dbContext.DepartSumary
join d in _dbContext.Department
on m.MissionId equals d.DepartmentUuid
orderby m.DeSuAddTime descending
select new
{
//missionUuid = m.MissionUuid,
//priorityUUID = m.AdministrativeOffice,//科室uuid
missionHeadline = m.DeSuHeadLine, //任务标题
priorityHeadline = m.DeSuDescribe, //内容
auditStatus = d.Name, //科室
//auditStatus = m.DepartName,//负责人uuid
//principal = getfuzeren(m.Principal),//负责人姓名
startTime = m.DeSuAddTime, //开始时间
//finishTime = m.FinishTime,//结束时间
missionDescribe = m.DeSuDescribe, //任务描述
MissionID = m.MissionId, //优先级
//manhour = m.Manhour,//计划工时
//participant = m.Participant,//参与人
//adduser = m.EstablishName,//添加人uuid
id = m.DeSumaryId //id
};
if (!string.IsNullOrEmpty(payload.kwbt))
{
query = query.Where(x => x.missionHeadline.Contains(payload.kwbt));//任务标题
}
if (!string.IsNullOrEmpty(payload.kwfzr))
{
query = query.Where(x => x.auditStatus.Contains(payload.kwfzr));//科室选择
}
if (!string.IsNullOrEmpty(payload.kwendtime))
{
query = query.Where(x => x.startTime.Contains(payload.kwendtime));//创建时间
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List(alltaskrequestpayload payload)
{
using (_dbContext)
{
var userid = _dbContext.SystemUser.Where(x => x.SystemUserUuid == Guid.Parse(payload.userguid)).ToList()[0].Id;//登录账号id
var query = from m in _dbContext.Mission
where m.Recycle == "0"
where m.Preserve == "1" //没有在回收站且没有在草稿箱中
where m.AdministrativeOffice == null || m.AdministrativeOffice == "" //不是科室工作总结
select new
{
missionUuid = m.MissionUuid,
accomplish = m.Accomplish,
priorityUUID = m.PriorityUuid == null ? "" : m.PriorityUuid.ToString(), //所属重点工作uuid
priorityHeadline = m.PriorityUuid == null ? "" : _dbContext.Priority.FirstOrDefault(x => x.PriorityUuid == m.PriorityUuid).PriorityHeadline, //所属重点工作
missionHeadline = m.MissionHeadline, //任务标题
principaluuid = m.Principal, //负责人uuid
principal = getfuzeren(m.Principal), //负责人姓名
startTime = m.StartTime, //开始时间
finishTime = m.FinishTime, //结束时间
missionDescribe = m.MissionDescribe, //任务描述
priority = m.Priority, //优先级
approver = m.Approver == "" ? "" : m.Approver == null ? "" : m.Approver, //审批人uuid
//approvername = us.RealName,//审批人
//approvername = m.Approver == "" ? "" : m.Approver == null ? "" : _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == Guid.Parse(m.Approver)).RealName,//审批人
approvername = getfuzeren(m.Approver), //审批人
auditStatus = m.AuditStatus, //审核状态
participant = m.Participant, //参与人
id = m.Id, //id
establishName = m.EstablishName, //创建人
auditOpinion = m.AuditOpinion == null ? "" : m.Approver, //审核意见
};
if (!string.IsNullOrEmpty(payload.userguid))
{
query = query.Where(x => x.participant.Contains("," + userid.ToString() + ","));//所参与
}
if (!string.IsNullOrEmpty(payload.kwsszdgz))
{
query = query.Where(x => x.priorityUUID == payload.kwsszdgz);//所属重点工作
}
if (!string.IsNullOrEmpty(payload.kwbt))
{
query = query.Where(x => x.missionHeadline.Contains(payload.kwbt));//任务标题
}
if (!string.IsNullOrEmpty(payload.kwfzr))
{
query = query.Where(x => x.principaluuid.Contains(payload.kwfzr));//负责人
}
if (!string.IsNullOrEmpty(payload.zt))
{
query = query.Where(x => x.auditStatus.Contains(payload.zt));//状态
}
if (!string.IsNullOrEmpty(payload.yxj))
{
query = query.Where(x => x.priority.Contains(payload.yxj));//优先级
}
//排序
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:我参与的任务信息数据", _dbContext);
return(Ok(response));
}
}
public IActionResult List(alltaskrequestpayload payload)
{
using (_dbContext)
{
var query = from m in _dbContext.Mission
where m.Recycle == "0" //没有在回收站
where m.Preserve == "1" //没有在草稿箱中
where m.Accomplish == "0" //没有完成
where m.AdministrativeOffice == null || m.AdministrativeOffice == "" //不是科室工作总结
orderby m.FinishTime ascending
select new
{
priorityUUID = m.PriorityUuid == null ? "" : m.PriorityUuid.ToString(), //所属重点工作uuid
priorityHeadline = m.PriorityUuid == null ? "" : _dbContext.Priority.FirstOrDefault(x => x.PriorityUuid == m.PriorityUuid).PriorityHeadline, //所属重点工作
missionHeadline = m.MissionHeadline, //任务标题
principaluuid = m.Principal, //负责人uuid
//principal = u.RealName,//负责人姓名
principal = getfuzeren(m.Principal), //负责人姓名
startTime = m.StartTime, //开始时间
finishTime = m.FinishTime, //结束时间
missionDescribe = m.MissionDescribe, //任务描述
priority = m.Priority, //优先级
approver = m.Approver == "" ? "" : m.Approver == null ? "" : m.Approver, //审批人uuid
//approvername = us.RealName,//审批人
//approvername = m.Approver == "" ? "" : m.Approver == null ? "" : _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == Guid.Parse(m.Approver)).RealName,//审批人
approvername = getfuzeren(m.Approver), //审批人
auditStatus = m.AuditStatus, //审核状态
participant = m.Participant, //参与人
id = m.Id, //id
establishName = m.EstablishName, //创建人
auditOpinion = m.AuditOpinion == null ? "" : m.Approver, //审核意见
};
var nowdate = DateTime.Now;
query = query.Where(x => Convert.ToDateTime(x.finishTime).AddDays(-30) <= nowdate && Convert.ToDateTime(x.finishTime) >= nowdate);//即将到期
if (!string.IsNullOrEmpty(payload.kwsszdgz))
{
query = query.Where(x => x.priorityUUID == payload.kwsszdgz);//所属重点工作
}
if (!string.IsNullOrEmpty(payload.kwbt))
{
query = query.Where(x => x.missionHeadline.Contains(payload.kwbt));//任务标题
}
if (!string.IsNullOrEmpty(payload.kwfzr))
{
query = query.Where(x => x.principaluuid.Contains(payload.kwfzr));//负责人
}
if (!string.IsNullOrEmpty(payload.zt))
{
query = query.Where(x => x.auditStatus.Contains(payload.zt));//状态
}
if (!string.IsNullOrEmpty(payload.yxj))
{
query = query.Where(x => x.priority.Contains(payload.yxj));//优先级
}
//今日到期
var nowdatestr = DateTime.Now.ToString("yyyy-MM-dd");
if (payload.canshu == "jrdq")
{
query = query.Where(x => x.finishTime.Contains(nowdatestr));
}
//排序
//if (payload.FirstSort != null)
//{
// query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
//}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List(alltaskrequestpayload payload)
{
using (_dbContext)
{
var deluuuid = AuthContextService.CurrentUser.Guid; //当前登录人uuid
var RoleName = AuthContextService.CurrentUser.RoleName; //当前登陆人角色名
string deptuuid = _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == deluuuid).DepartmentUuid.ToString(); //当前登陆人所属科室
var query = from m in _dbContext.Mission
where m.Recycle == "0" && (m.AuditStatus == "0" || m.AuditStatus == "" || m.AuditStatus == "1")//没有在回收站且没有在草稿箱中且未完成 状态为办理中
select new
{
missionUuid = m.MissionUuid,
isyuqi = panduanyuqi(m.FinishTime, m.MissionUuid), //判断是否逾期
missionHeadline = m.MissionHeadline, //任务标题
isouttime = m.Isouttime, //是否逾期
startTime = m.StartTime, //开始时间
finishTime = m.FinishTime, //结束时间
shenpishow = shenpishow(m.AuditStatus, RoleName), //判断是否能审批
wanchenshow = wanchengshow(deptuuid.ToString(), m.AdministrativeOffice, RoleName, m.AuditStatus), //判断是否能完成此任务
administrativeOffice = getdept(m.AdministrativeOffice), //下派部门(村庄,科室)
keshiuuid = m.AdministrativeOffice,
missionDescribe = m.MissionDescribe, //任务描述
priority = m.Priority, //优先级
auditStatus = m.AuditStatus, //审核状态
establishTime = m.EstablishTime,
auditOpinion = m.AuditOpinion, //审核意见
accomplish = m.Accomplish,
id = m.Id, //id
};
if (RoleName.Contains("科室负责人"))//科室负责人查看分配给自己的
{
query = query.Where(x => x.keshiuuid == deptuuid);
}
//查询时间
if (!string.IsNullOrEmpty(payload.kwstartime))
{
query = query.Where(x => Convert.ToDateTime(x.startTime) >= Convert.ToDateTime(payload.kwstartime));
}
if (!string.IsNullOrEmpty(payload.kwendtime))
{
query = query.Where(x => Convert.ToDateTime(x.finishTime) <= Convert.ToDateTime(payload.kwendtime));
}
if (!string.IsNullOrEmpty(payload.kwbt))
{
query = query.Where(x => x.missionHeadline.Contains(payload.kwbt));//任务标题
}
if (!string.IsNullOrEmpty(payload.zt))
{
query = query.Where(x => x.auditStatus.Contains(payload.zt));//状态
}
if (!string.IsNullOrEmpty(payload.yxj))
{
query = query.Where(x => x.priority.Contains(payload.yxj));//优先级
}
//排序
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:任务信息数据", _dbContext);
return(Ok(response));
}
}
public IActionResult keshizongjie(alltaskrequestpayload payload)
{
using (_dbContext)
{
var query = from m in _dbContext.Mission
join d in _dbContext.Department
on m.AdministrativeOffice equals d.DepartmentUuid.ToString()
where m.Recycle == "0"
where m.Preserve == "1" //没有在回收站且没有在草稿箱中
where m.AdministrativeOffice != "" && m.AdministrativeOffice != null //科室工作总结
select new
{
missionUuid = m.MissionUuid,
priorityUUID = m.AdministrativeOffice, //科室uuid
priorityHeadline = d.Name, //科室
missionHeadline = m.MissionHeadline, //任务标题
principaluuid = m.Principal, //负责人uuid
principal = getfuzeren(m.Principal), //负责人姓名
startTime = m.StartTime, //开始时间
finishTime = m.FinishTime, //结束时间
missionDescribe = m.MissionDescribe, //任务描述
priority = m.Priority, //优先级
manhour = m.Manhour, //计划工时
approver = m.Approver == "" ? "" : m.Approver == null ? "" : m.Approver, //审批人uuid
approvername = getfuzeren(m.Approver), //审批人
auditStatus = m.AuditStatus, //审核状态
participant = m.Participant, //参与人
adduser = m.EstablishName, //添加人uuid
id = m.Id //id
};
if (!string.IsNullOrEmpty(payload.kwbt))
{
query = query.Where(x => x.missionHeadline.Contains(payload.kwbt));//任务标题
}
if (!string.IsNullOrEmpty(payload.kwfzr))
{
query = query.Where(x => x.principaluuid.Contains(payload.kwfzr));//负责人
}
var data = payload.kwendtime;
if (!string.IsNullOrEmpty(payload.kwendtime))
{
query = query.Where(x => x.finishTime.Contains(payload.kwendtime));//结束时间
}
//排序
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List(alltaskrequestpayload payload)
{
using (_dbContext)
{
var deluuuid = AuthContextService.CurrentUser.Guid; //当前登录人uuid
var RoleName = AuthContextService.CurrentUser.RoleName; //当前登陆人角色名
var deptuuid = _dbContext.SystemUser.FirstOrDefault(x => x.SystemUserUuid == deluuuid).DepartmentUuid; //当前登陆人所属科室
var query = from m in _dbContext.Mission
where m.Recycle == "0" && m.Preserve == "1" && m.Accomplish == "1" && m.Isouttime == "0"//没有在回收站 没有在草稿箱中 已完成 并没有逾期
select new
{
missionUuid = m.MissionUuid,
missionHeadline = m.MissionHeadline, //任务标题
startTime = m.StartTime, //开始时间
finishTime = m.FinishTime, //结束时间
administrativeOffice = getdept(m.AdministrativeOffice), //下派部门(村庄,科室)
keshiuuid = m.AdministrativeOffice,
missionDescribe = m.MissionDescribe, //任务描述
priority = m.Priority, //优先级
auditStatus = m.AuditStatus, //审核状态
establishTime = m.EstablishTime,
auditOpinion = m.AuditOpinion, //审核意见
id = m.Id, //id
Sortord = m.Sortord
};
if (RoleName.Contains("科室负责人"))//科室负责人查看分配给自己的
{
query = query.Where(x => x.keshiuuid == deptuuid.ToString());
}
if (!string.IsNullOrEmpty(payload.kwbt))
{
query = query.Where(x => x.missionHeadline.Contains(payload.kwbt));//任务标题
}
if (!string.IsNullOrEmpty(payload.zt))
{
query = query.Where(x => x.auditStatus.Contains(payload.zt));//状态
}
if (!string.IsNullOrEmpty(payload.yxj))
{
query = query.Where(x => x.priority.Contains(payload.yxj));//优先级
}
//按时完成
if (payload.canshu == "aswc")
{
query = query.Where(x => x.Sortord != "" && x.Sortord != null && Convert.ToDateTime(x.finishTime) >= Convert.ToDateTime(x.Sortord));
}
//逾期完成
if (payload.canshu == "yqwc")
{
query = query.Where(x => x.Sortord != "" && x.Sortord != null && Convert.ToDateTime(x.finishTime) < Convert.ToDateTime(x.Sortord));
}
//排序
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
//var data = list.Select(_mapper.Map<SystemUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
ToLog.AddLog("查询", "成功:查询:我完成的任务信息数据", _dbContext);
return(Ok(response));
}
}
