public JsonAjaxResult _Print(PrintPara para)
{
JsonAjaxResult jsonR = new JsonAjaxResult();
entities.Set <S_E_PublishInfoDetail>().Where(a => a.ID == para.ID)
.Update(a =>
{
a.Count = a.Count + para.Count;
a.Printed = true;
});
Formula.Exceptions.BusinessException e = null;
try
{
entities.SaveChanges();
}
catch (Formula.Exceptions.BusinessException ex)
{
jsonR.Message = ex.Message;
jsonR.StatusCode = 500;
}
if (e != null)
{
jsonR.Message = e.Message;
jsonR.StatusCode = 500;
}
else
{
jsonR.Message = "操作成功";
jsonR.StatusCode = 200;
}
return(jsonR);
}
public JsonAjaxResult _UpdatePrintConfig(List <UpdatePrintConfigPara> paras)
{
JsonAjaxResult jsonR = new JsonAjaxResult();
foreach (UpdatePrintConfigPara dic in paras)
{
entities.Set <S_E_PublishInfoDetail>().Where(a => a.ID == dic.ID)
.Update(a =>
{
a.PaperSize = dic.PaperSize;
a.IsVertical = dic.IsVertical;
});
}
Formula.Exceptions.BusinessException e = null;
try
{
entities.SaveChanges();
}
catch (Formula.Exceptions.BusinessException ex)
{
jsonR.Message = ex.Message;
jsonR.StatusCode = 500;
}
if (e != null)
{
jsonR.Message = e.Message;
jsonR.StatusCode = 500;
}
else
{
jsonR.Message = "操作成功";
jsonR.StatusCode = 200;
}
return(jsonR);
}
public JsonAjaxResult _GetList(SearchPara para)
{
SearchResult result = new SearchResult();
JsonAjaxResult jsonR = new JsonAjaxResult()
{
Data = result
};
Expression <Func <S_E_PublishInfoDetail, bool> > predicate = a => true;
int pageIndex = 1;
int pageSize = 10;
if (para != null)
{
pageIndex = para.CurPage;
pageSize = para.PageSize;
predicate = And(predicate, a => a.Printed == para.Printed && !string.IsNullOrEmpty(a.PdfFile));
if (!string.IsNullOrEmpty(para.ProjectInfoName))
{
predicate = And(predicate, a => a.ProjectInfoName.Contains(para.ProjectInfoName));
}
if (!string.IsNullOrEmpty(para.ProjectCode))
{
predicate = And(predicate, a => a.ProjectCode.Contains(para.ProjectCode));
}
if (!string.IsNullOrEmpty(para.ProjectManager))
{
predicate = And(predicate, a => a.S_E_PublishInfo.S_I_ProjectInfo.ChargeUserName.Contains(para.ProjectManager));
}
if (!string.IsNullOrEmpty(para.ChargeDeptName))
{
predicate = And(predicate, a => a.ChargeDeptName.Contains(para.ChargeDeptName));
}
if (!string.IsNullOrEmpty(para.DesignerName))
{
predicate = And(predicate, a => a.DesingerName.Contains(para.DesignerName));
}
if (para.SubmitDateFrm != null)
{
predicate = And(predicate, a => a.PublishDate >= para.SubmitDateFrm);
}
if (para.SubmitDateTo != null)
{
DateTime to = para.SubmitDateTo.Value.AddDays(1);
predicate = And(predicate, a => a.PublishDate < to);
}
}
else
{
jsonR.Message = "传入的SearchPara参数为空,过滤条件失效,默认显示10条数据";
}
if (pageIndex < 1)
{
pageIndex = 1;
}
var itemIndex = (pageIndex - 1) * pageSize;
Formula.Exceptions.BusinessException e = null;
try
{
result.PageList = entities.Set <S_E_PublishInfoDetail>().Include("S_E_PublishInfo").Include("S_E_PublishInfo.S_I_ProjectInfo")
.Where(predicate.Compile())
.OrderBy(a => a.ProductCode)
.Skip(itemIndex).Take(pageSize).ToList().Select(a => {
var dic = new Dictionary <string, object>();
dic = a.ToDic();
dic.SetValue("ProjectManagerName", a.S_E_PublishInfo.S_I_ProjectInfo.ChargeUserName);
dic.SetValue("MajorName", a.S_E_PublishInfo.MajorName);
dic.SetValue("StepName", a.S_E_PublishInfo.S_I_ProjectInfo.PhaseName);
return(dic);
}).ToList();
result.Total = entities.Set <S_E_PublishInfoDetail>().Count(predicate.Compile());
}
catch (Formula.Exceptions.BusinessException ex)
{
e = ex;
}
if (e != null)
{
jsonR.Message = e.Message;
jsonR.StatusCode = 500;
}
else
{
jsonR.Message = "获取成功";
jsonR.StatusCode = 200;
}
return(jsonR);
}
