public ActionResult AjaxCouponCodeRedeemLogQuery()
{
CouponCodeRedeemLogFilter filter = BuildQueryFilterEntity <CouponCodeRedeemLogFilter>();
filter.MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
var result = CouponService.QueryCouponCodeRedeemLog(filter);
return(AjaxGridJson(result));
}
public virtual QueryResult QueryCouponCodeRedeemLog(CouponCodeRedeemLogFilter request)
{
int totalCount;
var dataTable = ObjectFactory <ICouponsQueryDA> .Instance.QueryCouponCodeRedeemLog(request, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public void Query(CouponCodeRedeemLogQueryFilterVM filterVM, EventHandler <RestClientEventArgs <dynamic> > callback)
{
if (!filterVM.HasValidationErrors)
{
string relativeUrl = "/MKTService/Coupons/QueryCustomerRedeemLog";
CouponCodeRedeemLogFilter filter = filterVM.ConvertVM <CouponCodeRedeemLogQueryFilterVM, CouponCodeRedeemLogFilter>();
restClient.QueryDynamicData(relativeUrl, filter, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
}
/// <summary>
/// 优惠券使用记录查询
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
public static QueryResult QueryCouponCodeRedeemLog(CouponCodeRedeemLogFilter filter)
{
CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCouponCodeRedeemLog");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, filter, string.IsNullOrEmpty(filter.SortFields) ? "Coupon.SysNo ASC" : filter.SortFields))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Coupon.MerchantSysNo", DbType.Int32,
"@MerchantSysNo", QueryConditionOperatorType.Equal, filter.MerchantSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Coupon.SysNo", DbType.Int32,
"@SysNo", QueryConditionOperatorType.Equal, filter.CouponSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Coupon.CouponName", DbType.String,
"@CouponName", QueryConditionOperatorType.Equal, filter.CouponName);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RedeemLog.CouponCode", DbType.String,
"@CouponCode", QueryConditionOperatorType.Equal, filter.CouponCode);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cs.CustomerID", DbType.String,
"@CustomerID", QueryConditionOperatorType.Equal, filter.CustomerID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "so.SysNo", DbType.String,
"@SOID", QueryConditionOperatorType.Equal, filter.SOID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RedeemLog.Status", DbType.String,
"@CouponCodeStatus", QueryConditionOperatorType.Equal, filter.CouponCodeStatus);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "RedeemLog.InDate", DbType.DateTime,
"@InDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThan
, filter.BeginUseDate.HasValue ? filter.BeginUseDate.Value.Date : filter.BeginUseDate
, filter.EndUseDate.HasValue ? filter.EndUseDate.Value.Date : filter.EndUseDate);
cmd.CommandText = sqlBuilder.BuildQuerySql();
DataTable resultList = cmd.ExecuteDataTable(new EnumColumnList {
{ "SOStatus", typeof(SOStatus) }, { "RedeemLogStatus", typeof(CouponCodeUsedStatus) }
});
int totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(new QueryResult(resultList, filter, totalCount));// { PageInfo = new PageInfo() { PageIndex = queryFilter.PageIndex, PageSize = queryFilter.PageSize, TotalCount = totalCount, SortBy = queryFilter.SortFields }, ResultList = resultList };
}
}
/// <summary>
/// 优惠券使用记录查询
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryCouponCodeRedeemLog(CouponCodeRedeemLogFilter filter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = filter.PageInfo.SortBy;
pagingEntity.MaximumRows = filter.PageInfo.PageSize;
pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCouponCodeRedeemLog");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "Coupon.SysNo desc"))
{
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "Coupon.SysNo", DbType.Int32,
"@SysNo", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual,
filter.CouponBeginNo, filter.CouponEndNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Coupon.CouponName", DbType.String,
"@CouponName", QueryConditionOperatorType.Equal, filter.CouponName);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RedeemLog.CouponCode", DbType.String,
"@CouponCode", QueryConditionOperatorType.Equal, filter.CouponCode);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "cs.CustomerID", DbType.String,
"@CustomerID", QueryConditionOperatorType.Equal, filter.CustomerID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "so.SysNo", DbType.String,
"@SOID", QueryConditionOperatorType.Equal, filter.SOID);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RedeemLog.Status", DbType.String,
"@CouponCodeStatus", QueryConditionOperatorType.Equal, filter.CouponCodeStatus);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "RedeemLog.InDate", DbType.DateTime,
"@InDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThan,
filter.BeginUseDate, filter.EndUseDate);
cmd.CommandText = sqlBuilder.BuildQuerySql();
var dt = cmd.ExecuteDataTable(new EnumColumnList {
{ "SOStatus", typeof(SOStatus) }, { "RedeemLogStatus", typeof(CouponCodeUsedStatus) }
});
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
public static QueryResult QueryCouponCodeRedeemLog(CouponCodeRedeemLogFilter filter)
{
return(CouponDA.QueryCouponCodeRedeemLog(filter));
}
