/// <summary>
/// 获取广告列表--分页
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public BasePageList<BaseBannerPageListModel> GetBannerPageList(BaseBannerQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @"base_banner ";
const string fields = "innerid, title, picurl, linkurl, autoenabletime, autodisabletime, sort, isenabled, createrid, createdtime, modifierid, modifiedtime";
var oldField = string.IsNullOrWhiteSpace(query.Order) ? " sort asc " : query.Order;
var sqlWhere = new StringBuilder("1=1");
if (!string.IsNullOrWhiteSpace(query.Title))
{
sqlWhere.Append($" and title like '%{query.Title}%'");
}
if (query.Isenabled != null)
{
sqlWhere.Append($" and isenabled = '{query.Isenabled}'");
}
var model = new PagingModel(spName, tableName, fields, oldField, sqlWhere.ToString(), query.PageSize, query.PageIndex);
var list = Helper.ExecutePaging<BaseBannerPageListModel>(model, query.Echo);
return list;
}
