/// <summary> /// 查询分类属性 /// </summary> /// <param name="model"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="SortField"></param> /// <param name="callback"></param> public void QueryProductChannelPeriodPrice(ProductChannelPeriodPriceQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { ProductChannelPeriodPriceQueryFilter filter = model.ConvertVM <ProductChannelPeriodPriceQueryVM, ProductChannelPeriodPriceQueryFilter>(); filter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; restClient.QueryDynamicData(GetPeriodPriceRelativeUrl, filter, (obj, args) => { if (args.FaultsHandle()) { return; } if (!(args.Result == null || args.Result.Rows == null)) { foreach (var item in args.Result.Rows) { item.IsChecked = false; } } callback(obj, args); } ); }
public DataTable QueryProductChannelPeriodPrice(ProductChannelPeriodPriceQueryFilter queryCriteria, out int totalCount) { var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProductChannelPeriodPrice"); var pagingInfo = new PagingInfoEntity { SortField = queryCriteria.PagingInfo.SortBy, StartRowIndex = queryCriteria.PagingInfo.PageIndex * queryCriteria.PagingInfo.PageSize, MaximumRows = queryCriteria.PagingInfo.PageSize }; using (var sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "SysNo DESC")) { if (queryCriteria.ChannelProductSysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ChannelProductInfoSysNo", DbType.Int32, "@ChannelProductSysNo", QueryConditionOperatorType.Equal, queryCriteria.ChannelProductSysNo); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "Status", DbType.String, "@Status", QueryConditionOperatorType.NotEqual, ProductChannelPeriodPriceStatus.Abandon); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = dataCommand.ExecuteDataTable("Status", typeof(ProductChannelPeriodPriceStatus)); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); } }
public QueryResult QueryProductChannelPeriodPrice(ProductChannelPeriodPriceQueryFilter request) { if (request == null) { throw new BizException(ResouceManager.GetMessageString("IM.ProductChannelInfo", "ProductChannelInfoCondtionIsNull")); } int totalCount; var data = ObjectFactory <IProductChannelInfoQueryDA> .Instance.QueryProductChannelPeriodPrice(request, out totalCount); var source = new QueryResult { Data = data, TotalCount = totalCount }; return(source); }