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