public ActionResult GetWorkloadListForAuthorID(FlowStatusQuery fquery) { JsonExecResult <FlowStatusEntity> jsonResult0 = new JsonExecResult <FlowStatusEntity>(); JsonExecResult <FlowStatusEntity> jsonResult1 = new JsonExecResult <FlowStatusEntity>(); IFlowFacadeService fservice = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>(); fquery.JournalID = JournalID; #region 待处理 try { fquery.IsHandled = 0;//0=待处理 jsonResult0.ItemList = fservice.GetHaveRightFlowStatusForStat(fquery); if (jsonResult0.ItemList != null) { jsonResult0.ItemList = jsonResult0.ItemList.Where(p => p.ContributionCount > 0).ToList <FlowStatusEntity>(); } jsonResult0.result = EnumJsonResult.success.ToString(); } catch (Exception ex) { jsonResult0.result = EnumJsonResult.error.ToString(); jsonResult0.msg = "获取当前人可以处理的稿件状态出现异常:" + ex.Message; } #endregion #region 已处理 try { fquery.IsHandled = 1;//1=已处理 jsonResult1.ItemList = fservice.GetHaveRightFlowStatusForStat(fquery); if (jsonResult1.ItemList != null) { jsonResult1.ItemList = jsonResult1.ItemList.Where(p => p.ContributionCount > 0).ToList <FlowStatusEntity>(); } jsonResult1.result = EnumJsonResult.success.ToString(); } catch (Exception ex) { jsonResult1.result = EnumJsonResult.error.ToString(); jsonResult1.msg = "获取当前人可以处理的稿件状态出现异常:" + ex.Message; } #endregion return(Json(new { Rows0 = jsonResult0.ItemList, Rows1 = jsonResult1.ItemList })); }
public ActionResult WorkloadListForEditorToExcel(FlowStatusQuery fquery) { JsonExecResult <FlowStatusEntity> jsonResult0 = new JsonExecResult <FlowStatusEntity>(); JsonExecResult <FlowStatusEntity> jsonResult1 = new JsonExecResult <FlowStatusEntity>(); IFlowFacadeService fservice = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>(); fquery.JournalID = JournalID; List <WorkloadEntity> list = new List <WorkloadEntity>(); #region 已处理 try { fquery.IsHandled = 1;//1=已处理 jsonResult1.ItemList = fservice.GetHaveRightFlowStatusForStat(fquery); if (jsonResult1.ItemList != null) { int WorkCount = 0; jsonResult1.ItemList = jsonResult1.ItemList.Where(p => p.ContributionCount > 0).ToList <FlowStatusEntity>(); for (int n = 0; n < jsonResult1.ItemList.Count; n++) { WorkloadEntity workloadEntity = new WorkloadEntity(); workloadEntity.StatusName = jsonResult1.ItemList[n].StatusName; workloadEntity.AlreadyCount = jsonResult1.ItemList[n].ContributionCount; WorkCount += jsonResult1.ItemList[n].ContributionCount; workloadEntity.RealName = Request.Params["RealName"]; list.Add(workloadEntity); } WorkloadEntity workloadEntityCount = new WorkloadEntity(); workloadEntityCount.StatusName = "已处理总计:"; workloadEntityCount.AlreadyCount = WorkCount; list.Add(workloadEntityCount); } } catch (Exception ex) { jsonResult1.result = EnumJsonResult.error.ToString(); jsonResult1.msg = "获取当前人可以处理的稿件状态出现异常:" + ex.Message; } #endregion #region 待处理 try { fquery.IsHandled = 0;//0=待处理 jsonResult0.ItemList = fservice.GetHaveRightFlowStatusForStat(fquery); if (jsonResult0.ItemList != null) { int WaitCount = 0; jsonResult0.ItemList = jsonResult0.ItemList.Where(p => p.ContributionCount > 0).ToList <FlowStatusEntity>(); for (int m = 0; m < jsonResult0.ItemList.Count; m++) { WorkloadEntity workloadEntity = new WorkloadEntity(); workloadEntity.StatusName = jsonResult0.ItemList[m].StatusName; workloadEntity.AlreadyCount = jsonResult0.ItemList[m].ContributionCount; WaitCount += jsonResult0.ItemList[m].ContributionCount; workloadEntity.RealName = Request.Params["RealName"]; list.Add(workloadEntity); } WorkloadEntity workloadEntityCount = new WorkloadEntity(); workloadEntityCount.StatusName = "待处理总计:"; workloadEntityCount.AlreadyCount = WaitCount; list.Add(workloadEntityCount); } } catch (Exception ex) { jsonResult0.result = EnumJsonResult.error.ToString(); jsonResult0.msg = "获取当前人可以处理的稿件状态出现异常:" + ex.Message; } #endregion string[] titleFiles = new string[] { "编辑姓名", "稿件状态", "数量" }; int[] titleWidth = new int[] { 80, 80, 80 }; string[] dataFiles = new string[] { "RealName", "StatusName", "AlreadyCount" }; string[] fomateFiles = new string[] { "", "", "" }; string strTempPath = "/UploadFile/TempFile/" + "WorkloadListForEditor.xls"; ExcelHelperEx.CreateExcel <WorkloadEntity>("编辑(" + Request.Params["RealName"] + ")工作量统计", titleFiles, titleWidth, dataFiles, fomateFiles, list, strTempPath); return(Json(new { flag = 1, ExcelPath = strTempPath })); }
public ActionResult WorkloadListToExcel(WorkloadQuery query) { IRoleAuthorFacadeService roleAuthorService = ServiceContainer.Instance.Container.Resolve <IRoleAuthorFacadeService>(); RoleAuthorQuery roleAuthorQuery = new RoleAuthorQuery(); roleAuthorQuery.JournalID = JournalID; roleAuthorQuery.GroupID = 1; roleAuthorQuery.OrderStr = " AI.AuthorID ASC"; roleAuthorQuery.RealName = query.RealName; if (query.RoleID > 0) { roleAuthorQuery.RoleID = query.RoleID; } int pageIndex = TypeParse.ToInt(Request.Params["page"], 1); IList <RoleAuthorEntity> listRoleAuthor = roleAuthorService.GetRoleAuthorDetailList(roleAuthorQuery); List <WorkloadEntity> list = new List <WorkloadEntity> (); for (int i = 0; i < listRoleAuthor.Count; i++) { WorkloadEntity workloadEntity = new WorkloadEntity(); FlowStatusQuery fquery = new FlowStatusQuery(); JsonExecResult <FlowStatusEntity> jsonResult0 = new JsonExecResult <FlowStatusEntity>(); JsonExecResult <FlowStatusEntity> jsonResult1 = new JsonExecResult <FlowStatusEntity>(); IFlowFacadeService fservice = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>(); fquery.JournalID = JournalID; fquery.CurAuthorID = listRoleAuthor[i].AuthorID; fquery.RoleID = listRoleAuthor[i].RoleID; fquery.StartDate = query.StartDate; fquery.EndDate = query.EndDate; #region 待处理 try { fquery.IsHandled = 0;//0=待处理 jsonResult0.ItemList = fservice.GetHaveRightFlowStatusForStat(fquery); if (jsonResult0.ItemList != null && jsonResult0.ItemList.Count > 0) { jsonResult0.ItemList = jsonResult0.ItemList.Where(p => p.ContributionCount > 0).ToList <FlowStatusEntity>(); for (int m = 0; m < jsonResult0.ItemList.Count; m++) { workloadEntity.WaitCount += jsonResult0.ItemList[m].ContributionCount; } } } catch (Exception ex) { jsonResult0.result = EnumJsonResult.error.ToString(); jsonResult0.msg = "获取当前人可以处理的稿件状态出现异常:" + ex.Message; } #endregion #region 已处理 try { fquery.IsHandled = 1;//1=已处理 jsonResult1.ItemList = fservice.GetHaveRightFlowStatusForStat(fquery); if (jsonResult1.ItemList != null && jsonResult1.ItemList.Count > 0) { jsonResult1.ItemList = jsonResult1.ItemList.Where(p => p.ContributionCount > 0).ToList <FlowStatusEntity>(); for (int n = 0; n < jsonResult1.ItemList.Count; n++) { workloadEntity.WorkCount += jsonResult1.ItemList[n].ContributionCount; } } } catch (Exception ex) { jsonResult1.result = EnumJsonResult.error.ToString(); jsonResult1.msg = "获取当前人可以处理的稿件状态出现异常:" + ex.Message; } #endregion workloadEntity.AuthorID = listRoleAuthor[i].AuthorID; workloadEntity.RealName = listRoleAuthor[i].RealName; if (workloadEntity.WorkCount > 0) { list.Add(workloadEntity); } } //去除固定的不需统计的人员ID list.Where(p => p.AuthorID != 84381 && p.AuthorID != 84386 && p.AuthorID != 84388 && p.AuthorID != 95844); //去除List中的重复项 List <WorkloadEntity> WorkloadList = list.Distinct(new Compare <WorkloadEntity>((x, y) => (null != x && null != y) && (x.AuthorID == y.AuthorID))).ToList(); string[] titleFiles = new string[] { "编辑姓名", "已处理", "待处理" }; int[] titleWidth = new int[] { 80, 80, 80 }; string[] dataFiles = new string[] { "RealName", "WorkCount", "WaitCount" }; string[] fomateFiles = new string[] { "", "", "" }; string strTempPath = "/UploadFile/TempFile/" + "WorkloadListAll.xls"; ExcelHelperEx.CreateExcel <WorkloadEntity>("编辑部工作量统计", titleFiles, titleWidth, dataFiles, fomateFiles, WorkloadList, strTempPath); return(Json(new { flag = 1, ExcelPath = strTempPath })); }