public DataTable QueryStorePageInfo(StorePageQueryFilter filter, out int totalCount) { CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryStorePageInfo"); PagingInfoEntity pagingInfo = new PagingInfoEntity() { SortField = filter.PageInfo.SortBy, StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize, MaximumRows = filter.PageInfo.PageSize }; using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "sp.SysNo desc")) { if (filter.MerchantSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sp.SellerSysNo", DbType.Int32, "@SellerSysNo", QueryConditionOperatorType.Equal, filter.MerchantSysNo.Value); } if (!string.IsNullOrEmpty(filter.PageType)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sp.PageTypeKey", DbType.String, "@PageTypeKey", QueryConditionOperatorType.Equal, filter.PageType); } dataCommand.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = dataCommand.ExecuteDataTable(); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); } }
public QueryResult QueryStorePageInfo(StorePageQueryFilter filter) { int totalCount = 0; QueryResult result = new QueryResult() { Data = ObjectFactory <IVendorQueryDA> .Instance.QueryStorePageInfo(filter, out totalCount) }; result.TotalCount = totalCount; return(result); }
/// <summary> /// 查询商家页面 /// </summary> /// <param name="vendorSysNo"></param> /// <param name="callback"></param> public void QueryStorePageInfo(StorePageQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = string.Format("/POService/Vendor/QueryStorePageInfo"); restClient.QueryDynamicData(relativeUrl, filter, callback); }