/// <summary>
/// 新闻信息分布查询
/// </summary>
/// <param name="model">输入查询参数对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-8-10</remarks>
public ResultModel Select(SearchBD_NewsInfoModel model)
{
var newsInfo = base._database.Db.BD_NewsInfo;
//查询参数条件
var whereParam = new SimpleExpression(1, 1, SimpleExpressionType.Equal);
whereParam = new SimpleExpression(whereParam, newsInfo.IsDelete == 0, SimpleExpressionType.And);
//1.惠卡动态,2惠粉公告,3惠粉消息
if (model.TypeID != null)
{
whereParam = new SimpleExpression(whereParam, newsInfo.TypeID == model.TypeID.Value, SimpleExpressionType.And);
}
//标题
if (!string.IsNullOrEmpty(model.Title))
{
whereParam = new SimpleExpression(whereParam, newsInfo.Title.Like("%" + model.Title + "%"), SimpleExpressionType.And);
}
//发布人
if (!string.IsNullOrEmpty(model.Releaser))
{
whereParam = new SimpleExpression(whereParam, newsInfo.Releaser.Like("%" + model.Releaser + "%"), SimpleExpressionType.And);
}
//是否导读
if (model.IsHasNaviContent != null)
{
whereParam = new SimpleExpression(whereParam, newsInfo.IsHasNaviContent == model.IsHasNaviContent.Value, SimpleExpressionType.And);
}
//是否已经审核(1:审核通过,2:待审核,3.拒审)
if (model.IsCheck != null)
{
whereParam = new SimpleExpression(whereParam, newsInfo.IsCheck == model.IsCheck.Value, SimpleExpressionType.And);
}
//是否图片新闻(0:否,1:是)
if (model.IsPic != null)
{
whereParam = new SimpleExpression(whereParam, newsInfo.IsPic == model.IsPic.Value, SimpleExpressionType.And);
}
//发布时间
if (model.BeginDate != null)
{
whereParam = new SimpleExpression(whereParam, newsInfo.ReleaseDT >= model.BeginDate, SimpleExpressionType.And);
}
if (model.EndDate != null)
{
whereParam = new SimpleExpression(whereParam, newsInfo.CreateDT < Convert.ToDateTime(model.EndDate).AddDays(1), SimpleExpressionType.And);
}
var query = newsInfo.All().Where(whereParam).OrderByCreateDTDescending();
var result = new ResultModel()
{
Data = new SimpleDataPagedList <BD_NewsInfoModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}
/// <summary>
/// 查询新闻信息列表
/// </summary>
/// <param name="model">搜索实体对象</param>
/// <returns></returns>
/// <remarks>added by jimmy,2015-7-3</remarks>
public JsonResult List(SearchBD_NewsInfoModel model)
{
DrowList(null);
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
var list =
_bD_NewsInfoService.Select(model);
var data = new { rows = list.Data, total = list.Data.TotalCount };
return(Json(data, JsonRequestBehavior.AllowGet));
}
