/// <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)); }