/// <summary> /// 查询分类属性 /// </summary> /// <param name="model"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="SortField"></param> /// <param name="callback"></param> public void QueryCategoryExtendWarrantyDisuseBrand(CategoryExtendWarrantyDisuseBrandQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { CategoryExtendWarrantyDisuseBrandQueryFilter filter = model.ConvertVM <CategoryExtendWarrantyDisuseBrandQueryVM, CategoryExtendWarrantyDisuseBrandQueryFilter>(); filter.PagingInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; restClient.QueryDynamicData(GetDisuseBrandRelativeUrl, 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 QueryCategoryExtendWarrantyDisuseBrand(CategoryExtendWarrantyDisuseBrandQueryFilter request) { if (request == null) { throw new BizException(ResouceManager.GetMessageString("IM.CategoryExtendWarranty", "CategoryExtendWarrantyCondtionIsNull")); } int totalCount; var data = ObjectFactory <ICategoryExtendWarrantyQueryDA> .Instance.QueryCategoryExtendWarrantyDisuseBrand(request, out totalCount); var source = new QueryResult { Data = data, TotalCount = totalCount }; return(source); }
public DataTable QueryCategoryExtendWarrantyDisuseBrand(CategoryExtendWarrantyDisuseBrandQueryFilter queryCriteria, out int totalCount) { var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryCategoryExtendWarrantyDisuseBrand"); 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, "A.SysNo DESC")) { if (queryCriteria.C1SysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C2.C1SysNo", DbType.Int32, "@C1SysNo", QueryConditionOperatorType.Equal, queryCriteria.C1SysNo); } if (queryCriteria.C2SysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C2.SysNo", DbType.Int32, "@C2SysNo", QueryConditionOperatorType.Equal, queryCriteria.C2SysNo); } if (queryCriteria.C3SysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "C.SysNo", DbType.Int32, "@C3SysNo", QueryConditionOperatorType.Equal, queryCriteria.C3SysNo); } if (!string.IsNullOrEmpty(queryCriteria.BrandName)) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "B.ManufacturerName + B.BriefName", DbType.String, "@BrandName", QueryConditionOperatorType.Like, queryCriteria.BrandName); } if (!queryCriteria.Status.ToString().Equals("0")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "A.Status", DbType.String, "@Status", QueryConditionOperatorType.Equal, queryCriteria.Status); } dataCommand.CommandText = sqlBuilder.BuildQuerySql(); DataTable dt = dataCommand.ExecuteDataTable("Status", typeof(CategoryExtendWarrantyStatus)); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); } }