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; }