/// <summary>
/// 根据cardid获取已核销的code列表
/// </summary>
/// <param name="query">查询条件</param>
/// <returns></returns>
public BasePageList<CodeViewListModel> GetUsedCodePageList(UsedCodeQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @"coupon_code";
const string fields = "code,usedtime";
var orderField = string.IsNullOrWhiteSpace(query.Order) ? "usedtime desc" : query.Order;
//查询条件
var sqlWhere = new StringBuilder("1=1");
if (!string.IsNullOrWhiteSpace(query.Cardid))
{
sqlWhere.Append($" and cardid='{query.Cardid}'");
}
if (!string.IsNullOrWhiteSpace(query.Code))
{
sqlWhere.Append($" and code like '%{query.Code}%'");
}
if (query.StartTime != null)
{
sqlWhere.Append($" and usedtime>='{query.StartTime?.ToString("yyyy-MM-dd 00:00:00")}'");
}
if (query.EndTime != null)
{
sqlWhere.Append($" and usedtime<='{query.EndTime?.ToString("yyyy-MM-dd 23:59:59")}'");
}
var model = new PagingModel(spName, tableName, fields, orderField, sqlWhere.ToString(), query.PageSize,
query.PageIndex);
var list = Helper.ExecutePaging<CodeViewListModel>(model, query.Echo);
return list;
}
