public BasePageList<UserListModel> GetUserPageList(UserQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @"user_info";
const string fields = "innerid, nickname, mobile, email, headportrait, status, sex, brithday, qq, createdtime";
var orderField = string.IsNullOrWhiteSpace(query.Order) ? "createdtime desc" : query.Order;
//查询条件
var sqlWhere = new StringBuilder("1=1");
sqlWhere.Append(query.Status != null
? $" and status={query.Status}"
: "");
//手机号
if (!string.IsNullOrWhiteSpace(query.Mobile))
{
sqlWhere.Append($" and mobile like '%{query.Mobile}%'");
}
//昵称
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<UserListModel>(model, query.Echo);
return list;
}