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