/// <summary>
/// 保存
/// Created:20170526(ChengMengjia)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
ReturnValue = new WorkloadEntity();
ReturnValue.Manager = cbManager.SelectedItem == null ? "" : ((ComboItem)cbManager.SelectedItem).Tag.ToString();
ReturnValue.ManagerName = cbManager.SelectedItem == null ? "" : ((ComboItem)cbManager.SelectedItem).Text;
ReturnValue.Workload = intWorkload.Value;
ReturnValue.ActualWorkload = intActualWorkload.Value;
if (string.IsNullOrEmpty(ReturnValue.Manager))
{
MessageHelper.ShowMsg(MessageID.W000000001, MessageType.Alert, "责任人");
cbManager.Focus();
return;
}
if (ReturnValue.Workload == null)
{
MessageHelper.ShowMsg(MessageID.W000000001, MessageType.Alert, "预计工作量");
intWorkload.Focus();
return;
}
this.DialogResult = DialogResult.OK;
}
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 }));
}
