public BasePageList<CustWeChatViewModel> GetCustWeChatList(CustWeChatQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @" wechat_friend ";
const string fields = @"ifnull(accountid,'') accountid,ifnull(nickname,'') nickname,ifnull(openid,'') openid,ifnull(remarkname,'') remarkname,sex,ifnull(createdtime,current_date()) createdtime
,innerid, nickname, photo, area, isdel, subscribe_time, subscribe, country, province, city";
var orderField = string.IsNullOrWhiteSpace(query.Order) ? " createdtime desc" : query.Order;
//查詢條件
var sqlWhere = new StringBuilder(" 1=1 ");
if (!string.IsNullOrWhiteSpace(query.nickname))
{
sqlWhere.Append($" and nickname like '%{query.nickname}%'");
}
var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere.ToString(), query.PageSize, query.PageIndex);
var list = Helper.ExecutePaging<CustWeChatViewModel>(model, query.Echo);
return list;
}