public ActionResult AjaxCouponCodeCustomerLogQuery()
{
CouponCodeCustomerLogFilter filter = BuildQueryFilterEntity <CouponCodeCustomerLogFilter>();
filter.MerchantSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
var result = CouponService.QueryCouponCodeCustomerLog(filter);
return(AjaxGridJson(result));
}
public virtual QueryResult QueryCouponCodeCustomerLog(CouponCodeCustomerLogFilter request)
{
int totalCount;
var dataTable = ObjectFactory <ICouponsQueryDA> .Instance.QueryCouponCodeCustomerLog(request, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public void ExportExcelFile(CouponCodeCustomerLogQueryFilterVM queryVM, ColumnSet[] columns)
{
CouponCodeCustomerLogFilter queryFilter = new CouponCodeCustomerLogFilter();
queryFilter = queryVM.ConvertVM <CouponCodeCustomerLogQueryFilterVM, CouponCodeCustomerLogFilter>();
queryFilter.PageInfo = new PagingInfo
{
PageSize = ConstValue.MaxRowCountLimit,
PageIndex = 0,
SortBy = null
};
string relativeUrl = "/MKTService/Coupons/QueryCustomerGetLog";
restClient.ExportFile(relativeUrl, queryFilter, columns);
}
public void Query(CouponCodeCustomerLogQueryFilterVM filterVM, EventHandler <RestClientEventArgs <dynamic> > callback)
{
if (!filterVM.HasValidationErrors)
{
string relativeUrl = "/MKTService/Coupons/QueryCustomerGetLog";
CouponCodeCustomerLogFilter filter = filterVM.ConvertVM <CouponCodeCustomerLogQueryFilterVM, CouponCodeCustomerLogFilter>();
restClient.QueryDynamicData(relativeUrl, filter, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
}
/// <summary>
/// 优惠券发放记录查询
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryCouponCodeCustomerLog(CouponCodeCustomerLogFilter 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("QueryCouponCodeCustomerLog");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "Coupon.InDate desc"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Coupon.CouponName", DbType.String,
"@CouponName", QueryConditionOperatorType.Like, filter.CouponName);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Customer.SysNo", DbType.String,
"@CustomerSysNo", QueryConditionOperatorType.Equal, filter.CustomerSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Customer.CustomerID", DbType.String,
"@CustomerID", QueryConditionOperatorType.Equal, filter.CustomerID);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "Coupon.SysNo", DbType.Int32,
"@SysNo", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThanOrEqual,
filter.CouponBeginNo, filter.CouponEndNo);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "CustomerLog.GetCouponCodeDate", DbType.DateTime,
"@GetCouponCodeDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThan,
filter.BeginUseDate, filter.EndUseDate);
cmd.CommandText = sqlBuilder.BuildQuerySql();
var dt = cmd.ExecuteDataTable(new EnumColumnList {
{ "Status", typeof(CouponsStatus) }
});
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
/// <summary>
/// 优惠券发放记录查询
/// </summary>
/// <param name="filter"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public static QueryResult QueryCouponCodeCustomerLog(CouponCodeCustomerLogFilter filter)
{
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCouponCodeCustomerLog");
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.Like, filter.CouponName);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CustomerLog.CouponCode", DbType.String,
"@CouponCode", QueryConditionOperatorType.Equal, filter.CouponCode);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Customer.SysNo", DbType.Int32,
"@CustomerSysNo", QueryConditionOperatorType.Equal, filter.CustomerSysNo);
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Customer.CustomerID", DbType.String,
"@CustomerID", QueryConditionOperatorType.Equal, filter.CustomerID);
sqlBuilder.ConditionConstructor.AddBetweenCondition(QueryConditionRelationType.AND, "CustomerLog.GetCouponCodeDate", DbType.DateTime,
"@GetCouponCodeDate", QueryConditionOperatorType.MoreThanOrEqual, QueryConditionOperatorType.LessThan,
filter.BeginUseDate, filter.EndUseDate);
cmd.CommandText = sqlBuilder.BuildQuerySql();
DataTable resultList = cmd.ExecuteDataTable(new EnumColumnList {
{ "Status", typeof(CouponStatus) }
});
int totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(new QueryResult(resultList, filter, totalCount));
}
}
public static QueryResult QueryCouponCodeCustomerLog(CouponCodeCustomerLogFilter filter)
{
return(CouponDA.QueryCouponCodeCustomerLog(filter));
}
