public BasePageList<SettedCodeViewListModel> GetSettedCodePageList(SettedCodeQueryModel query)
{
return _rewardsservice.GetSettedCodePageList(query);
}
/// <summary>
/// 根据settid获取已结算的code列表
/// </summary>
/// <param name="query">查询条件</param>
/// <returns></returns>
public BasePageList<SettedCodeViewListModel> GetSettedCodePageList(SettedCodeQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @"coupon_settcoderecord as a
left join coupon_card as b on a.cardid=b.innerid
left join coupon_code as c on a.`code`=c.`code`
left join cust_info as ci on ci.innerid=c.custid";
const string fields = "a.`code`,c.usedtime,b.title,ci.custname";
var orderField = string.IsNullOrWhiteSpace(query.Order) ? "b.innerid,c.usedtime desc" : query.Order;
//查询条件
var sqlWhere = new StringBuilder("1=1");
if (!string.IsNullOrWhiteSpace(query.Settid))
{
sqlWhere.Append($" and a.settid='{query.Settid}'");
}
var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere.ToString(), query.PageSize,
query.PageIndex);
var list = Helper.ExecutePaging<SettedCodeViewListModel>(model, query.Echo);
return list;
}
