public DataTable QueryCategoryProperty(CategoryPropertyQueryFilter queryCriteria, out int totalCount) { var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCategoryProperty"); 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, "P.SysNo DESC")) { if (queryCriteria.CategorySysNo > 0) { //dataCommand.AddInputParameter("@CategorySysNo", DbType.Int32, queryCriteria.CategorySysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CategorySysNo", DbType.Int32, "@CategorySysNo", QueryConditionOperatorType.Equal, queryCriteria.CategorySysNo); } dataCommand.CommandText = sqlBuilder.BuildQuerySql(); var enumList = new EnumColumnList(); enumList.Add("IsItemSearch", typeof(CategoryPropertyStatus)); enumList.Add("IsInAdvSearch", typeof(CategoryPropertyStatus)); enumList.Add("IsMustInput", typeof(CategoryPropertyStatus)); enumList.Add("WebDisplayStyle", typeof(WebDisplayStyle)); enumList.Add("PropertyType", typeof(PropertyType)); DataTable dt = dataCommand.ExecuteDataTable(enumList); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); } }
/// <summary> /// 查询分类属性 /// </summary> /// <param name="model"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="SortField"></param> /// <param name="callback"></param> public void QueryCategoryProperty(CategoryPropertyQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { CategoryPropertyQueryFilter filter = model.ConvertVM <CategoryPropertyQueryVM, CategoryPropertyQueryFilter>(); filter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; const string relativeUrl = "/IMService/CategoryProperty/QueryCategoryProperty"; restClient.QueryDynamicData(relativeUrl, 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 QueryResult QueryCategoryProperty(CategoryPropertyQueryFilter request) { if (request == null) { throw new BizException(ResouceManager.GetMessageString("IM.CategoryProperty", "CategoryPropertyCondtionIsNull")); } int totalCount; var data = ObjectFactory <ICategoryPropertyQueryDA> .Instance.QueryCategoryProperty(request, out totalCount); var source = new QueryResult { Data = data, TotalCount = totalCount }; return(source); }