public virtual QueryResult QueryPageType(PageTypeQueryFilter filter) { var pageTypeQueryDA = ObjectFactory <IPageTypeQueryDA> .Instance; int totalCount; var data = pageTypeQueryDA.Query(filter, out totalCount); return(new QueryResult { Data = data, TotalCount = totalCount }); }
public DataTable Query(PageTypeQueryFilter 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("PageType_QueryPageType"); var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "A.SysNo DESC"); sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "A.PageTypeName", DbType.String, "@PageTypeName", QueryConditionOperatorType.Like, filter.PageTypeName); sqlBuilder.ConditionConstructor.AddCondition( QueryConditionRelationType.AND, "A.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); //TODO:添加ChannelID参数 cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList enumConfig = new EnumColumnList(); enumConfig.Add("Status", typeof(ADStatus)); var dt = cmd.ExecuteDataTable(enumConfig); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); }