public QueryResult QueryWarehouseOwner(WarehouseOwnerQueryFilter request) { int totalCount; var dataTable = ObjectFactory <IWarehouseOwnerQueryDA> .Instance.QueryWarehouseOwner(request, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public void QueryWarehouseOwner(WarehouseOwnerQueryVM model, EventHandler <RestClientEventArgs <dynamic> > callback) { WarehouseOwnerQueryFilter filter = model.ConvertVM <WarehouseOwnerQueryVM, WarehouseOwnerQueryFilter>(); string relativeUrl = "/InventoryService/Stock/QueryWarehouseOwner"; restClient.QueryDynamicData(relativeUrl, filter, (obj, args) => { if (!args.FaultsHandle()) { foreach (var item in args.Result.Rows) { item.IsChecked = false; } callback(obj, args); } }); }
/// <summary> /// 查询仓库所有者 /// </summary> /// <returns></returns> public virtual DataTable QueryWarehouseOwner(WarehouseOwnerQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = SortFieldMapping(filter.PagingInfo.SortBy); pagingEntity.MaximumRows = filter.PagingInfo.PageSize; pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize; CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Inventory_QueryWarehouseOwner"); using (var sb = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "a.SysNo DESC")) { sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.OwnerName", DbType.String, "@OwnerName", QueryConditionOperatorType.Like, filter.OwnerName); if (filter.OwnerStatus.HasValue) { sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.[Status]", DbType.Int32, "@OwnerStatus", QueryConditionOperatorType.Equal, filter.OwnerStatus); } if (filter.OwnerType.HasValue) { sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.[OwnerType]", DbType.Int32, "@OwnerType", QueryConditionOperatorType.Equal, filter.OwnerType); } sb.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "a.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, filter.CompanyCode); cmd.CommandText = sb.BuildQuerySql(); EnumColumnList enumColumnList = new EnumColumnList(); enumColumnList.Add("OwnerStatus", typeof(ValidStatus)); enumColumnList.Add("OwnerType", typeof(WarehouseOwnerType)); var resultData = cmd.ExecuteDataTable(enumColumnList); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(resultData); } }