public QueryResult QueryDynamicCategoryMapping(ECDynamicCategoryMappingQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <IECDynamicCategoryQueryDA> .Instance.QueryECDynamicCategoryMapping(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public void QueryProductMapping(int categorySysNo, int pageIndex, int pageSize, string sortBy, EventHandler <RestClientEventArgs <dynamic> > callback) { ECDynamicCategoryMappingQueryFilter filter = new ECDynamicCategoryMappingQueryFilter { CompanyCode = CPApplication.Current.CompanyCode, DynamicCategorySysNo = categorySysNo, PagingInfo = new PagingInfo { PageIndex = pageIndex, PageSize = pageSize, SortBy = sortBy } }; string relativeUrl = "/MKTService/ECDynamicCategory/QueryMapping"; restClient.QueryDynamicData(relativeUrl, filter, callback); }
public DataTable QueryECDynamicCategoryMapping(ECDynamicCategoryMappingQueryFilter filter, out int totalCount) { var pagingInfo = new PagingInfoEntity { SortField = filter.PagingInfo.SortBy, StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize, MaximumRows = filter.PagingInfo.PageSize }; var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("MKT_GetECDynamicCategoryMapping"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingInfo, "m.SysNo DESC")) { //状态 sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "m.DynamicCategorySysNo", DbType.Int32, "@DynamicCategorySysNo", QueryConditionOperatorType.Equal, filter.DynamicCategorySysNo); //只查询有效的 sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "m.Status", DbType.Int32, "@Status", QueryConditionOperatorType.Equal, 0); sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "m.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); //TODO:添加渠道过滤条件 cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList list = new EnumColumnList(); list.Add("ProductStatus", typeof(ProductStatus)); var dt = cmd.ExecuteDataTable(list); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }