/// <summary> /// 查询可用商品入库成本明细 /// </summary> /// <param name="queryFilter"></param> /// <param name="callback"></param> public void QueryCostItems(CostChangeItemsQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback) { queryFilter.CompanyCode = CPApplication.Current.CompanyCode; string relativeUrl = "InventoryService/Inventory/QueryAvaliableCostInList"; restClient.QueryDynamicData(relativeUrl, queryFilter, callback); }
public QueryResult QueryAvaliableCostInList(CostChangeItemsQueryFilter queryFilter) { QueryResult result = new QueryResult(); int getTotalCount = 0; result.Data = ObjectFactory <IProductCostQueryDA> .Instance.QueryAvaliableCostInList(queryFilter, out getTotalCount); result.TotalCount = getTotalCount; return(result); }
public CostChangeItemsQuery(int vendorSysNo, int pmSysNo) { InitializeComponent(); this.DataGrid.DataContext = m_queryReq = new CostChangeItemsQueryFilter() { VendorSysNo = vendorSysNo, PMSysNo = pmSysNo }; //this.ucVendorPicker.SelectedVendorSysNo = vendorSysNo.ToString(); //this.ucPM.SelectedPMSysNo = pmSysNo; this.Loaded += UCCostChangeItemsQuery_Loaded; m_selectData = new Dictionary <string, CostItemInfoVM>(); }
/// <summary> /// 查询商品入库成本明细 /// </summary> /// <param name="queryFilter"></param> /// <returns></returns> public virtual DataTable QueryAvaliableCostInList(CostChangeItemsQueryFilter queryFilter, out int totalCount) { DataTable dt = new DataTable(); if (queryFilter == null) { totalCount = 0; return(null); } var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryAvaliableCostInList"); PagingInfoEntity pagingInfo = new PagingInfoEntity() { SortField = queryFilter.PageInfo.SortBy, StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize, MaximumRows = queryFilter.PageInfo.PageSize }; using (var sqlBuilder = new DynamicQuerySqlBuilder( dataCommand.CommandText, dataCommand, pagingInfo, "c.[Priority],c.SysNo")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.BillType", DbType.Int32, "@BillType", QueryConditionOperatorType.Equal, (int)ECCentral.BizEntity.Inventory.InventoryAdjustContractInfo.CostBillType.PO); if (queryFilter.ProductSysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.ProductSysNo", DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryFilter.ProductSysNo); } else { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "0", DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryFilter.ProductSysNo); } sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pm.PMSysNo", DbType.Int32, "@PMSysNo", QueryConditionOperatorType.Equal, queryFilter.PMSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "pm.VendorSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, queryFilter.VendorSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.LeftQuantity-c.LockQuantity", DbType.Int32, "@AvaliableQty", QueryConditionOperatorType.MoreThan, 0); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); dt = dataCommand.ExecuteDataTable(); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); } return(dt); }