public void NewInfoService_GetNewInfoList_Test()
{
SearchNewInfoModel snmodel = new SearchNewInfoModel();
snmodel.PagedIndex = 0;
snmodel.PagedSize = 10;
List <NewInfoModel> resultModel = this._newInfoService.GetNewInfoList(snmodel).Data;
Assert.IsTrue(true);
}
/// <summary>
/// 列表Banner
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult List(SearchNewInfoModel model)
{
model.PagedIndex = model.PagedIndex == 0 ? 0 : model.PagedIndex;
model.PagedSize = model.PagedSize == 0 ? 10 : model.PagedSize;
//列表查询
var result = this._newInfoService.GetNewInfoList(model);
List <NewInfoModel> ds = result.Data;
var data = new
{
rows = ds,
total = ds.Count,
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取新闻信息表 wuyf
/// </summary>
/// <param name="model">model</param>
/// <returns>新闻信息表</returns>
public ResultModel GetNewInfoList(SearchNewInfoModel model)
{
var tb = _database.Db.NewInfo;
var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); //
if (model.NewInfoId > 0)
{
//ID
where = new SimpleExpression(where, tb.NewInfoId == model.NewInfoId, SimpleExpressionType.And);
}
if (model.IsRecommend != 10)
{
//IsRecommend 是否推荐
where = new SimpleExpression(where, tb.IsRecommend == model.IsRecommend, SimpleExpressionType.And);
}
if (!string.IsNullOrEmpty(model.NewTitle))
{
//新闻标题model.NewTitle.Trim() 这里不用Trim是为了英文
where = new SimpleExpression(where, tb.NewTitle.Like("%" + model.NewTitle + "%"), SimpleExpressionType.And);
}
if (model.NewType > 0)
{
//新闻类型
where = new SimpleExpression(where, tb.NewType == model.NewType, SimpleExpressionType.And);
}
//dynamic pc;
var query = tb
.Query()
//.LeftJoin(_database.Db.YH_User, out pc)
//.On(_database.Db.YH_User.UserID == tb.UserID)
.Select(
tb.NewInfoId,
tb.NewType,
tb.NewTitle,
tb.NewContent,
tb.IsRecommend,
tb.NewImage,
tb.CreateBy,
tb.CreateDT,
tb.UpdateBy,
tb.UpdateDT
//pc.Phone,
//pc.RealName,
//pc.Account
)
.Where(where)
.OrderByCreateDTDescending();
var result = new ResultModel
{
Data = new SimpleDataPagedList <NewInfoModel>(query,
model.PagedIndex, model.PagedSize)
};
return(result);
}