/// <summary>
/// 【视图】查看文章
/// </summary>
/// <returns></returns>
public ViewResult Show(string ArticleApplyID)
{
ArticleApply_S model = _ArticleApplyFacade.Value.GetByID <ArticleApply_S>(ArticleApplyID);
model.VC_ARTICLE_NAME = _ArticleFacade.Value.GetByID <Article_S>(model.N_ARTICLE_ID).VC_TITLE;
model.VC_CHECKER_NAME = CurrentUserContext.UserInfo.UserDisplayName;
return(View(model));
}
/// <summary>
/// 【视图】文章列表
/// </summary>
/// <returns></returns>
public ViewResult List(string columnid)
{
ViewBag.N_START_DATE = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
ViewBag.N_END_DATE = DateTime.Now.ToString("yyyy-MM-dd");
ArticleApply_S model = new ArticleApply_S();
return(View(model));
}
/// <summary>
/// 分页获取文章
/// </summary>
/// <param name="article">搜索条件</param>
/// <param name="pi">分页信息</param>
/// <returns></returns>
public JsonResult _ArticleApplyList(ArticleApply_S ArticleApply, PageInfo pi)
{
var data = _ArticleApplyFacade.Value.GetArticleApplyListPaged(ArticleApply, pi);
var result = new
{
Rows = data,
Total = pi.Total
};
return(Json(result));
}
/// <summary>
/// 修改专题明细
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditArticleApply(ArticleApply_S model)
{
using (var factory = new BaseAccess())
{
try
{
var entity = model.Adapter <ArticleApplyEntity>(new ArticleApplyEntity());
factory.Update <ArticleApplyEntity>(entity);
return(true);
}
catch
{
return(false);
}
}
}
/// <summary>
/// 分页获取专题明细列表
/// </summary>
/// <param name="model"></param>
/// <param name="pi"></param>
/// <returns></returns>
public List <ArticleApply_S> GetArticleApplyListPaged(ArticleApply_S model, PageInfo pi)
{
using (var factory = new BaseAccess())
{
List <Orderby <ArticleApplyEntity> > orders = new List <Orderby <ArticleApplyEntity> >()
{
new Orderby <ArticleApplyEntity>(c => c.DT_APPLY_TIME, SortOrder.Descending)
};
var spec = Specification <ArticleApplyEntity> .Create(c => true);
if (!string.IsNullOrWhiteSpace(model.VC_ARTICLE_NAME))
{
var ArticleIDs = factory.GetAll <ArticleEntity>(Specification <ArticleEntity> .Create(c => c.VC_TITLE.Contains(model.VC_ARTICLE_NAME))).Select(c => c.ID).ToList().ToArray();
spec &= Specification <ArticleApplyEntity> .Create(c => ArticleIDs.Contains(c.ID));
}
if (!string.IsNullOrWhiteSpace(model.C_CHECK_STATUS))
{
spec &= Specification <ArticleApplyEntity> .Create(c => c.C_CHECK_STATUS == model.C_CHECK_STATUS);
}
if (!string.IsNullOrWhiteSpace(model.VC_APPLYER_NAME))
{
spec &= Specification <ArticleApplyEntity> .Create(c => c.VC_APPLYER_NAME.Contains(model.VC_APPLYER_NAME));
}
if (model.N_START_DATE != null)
{
spec &= (Specification <ArticleApplyEntity> .Create(c => c.DT_APPLY_TIME >= model.N_START_DATE));
}
if (model.N_END_DATE != null)
{
spec &= (Specification <ArticleApplyEntity> .Create(c => c.DT_APPLY_TIME <= model.N_END_DATE));
}
var list = factory.GetPage <ArticleApplyEntity>(pi, spec, orders)
.Adapter <ArticleApplyEntity, ArticleApply_S>(new List <ArticleApply_S>());
foreach (var item in list)
{
// item.VC_ARTICLE_NAME = factory.GetSingle<ArticleEntity>(item.N_ARTICLE_ID).VC_TITLE;
item.VC_ARTICLE_NAME = factory.GetSingle <ArticleEntity>(item.N_ARTICLE_ID) == null ? "未知" : factory.GetSingle <ArticleEntity>(item.N_ARTICLE_ID).VC_TITLE;
if (!string.IsNullOrWhiteSpace(item.VC_CHECKER_ID))
{
var checker = factory.GetSingle <SYS_UserEntity>(item.VC_CHECKER_ID);
item.VC_CHECKER_NAME = checker == null ? "" : checker.UserDisplayName;
}
}
return(list);
}
}
