/// <summary>
/// 礼品卡消费记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static QueryResult <GiftCardUseInfo> QueryUsedRecord(UsedRecordQuery filter)
{
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("GiftCard_QueryUsedRecord");
using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(command.CommandText, command, filter.ConvertToPaging(), "SO.[SysNo] DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "GC.Code", DbType.String, "@Code", QueryConditionOperatorType.Equal, filter.Code);
command.CommandText = sqlBuilder.BuildQuerySql();
command.SetParameterValue("@CustomerSysNo", filter.CustomerSysNo);
command.SetParameterValue("@ActionType", "SO");
var newsList = command.ExecuteEntityList <GiftCardUseInfo>();
var totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
QueryResult <GiftCardUseInfo> result = new QueryResult <GiftCardUseInfo>();
result.ResultList = newsList;
result.PageInfo = filter.ConvertToPageInfo(totalCount);
return(result);
}
}
