public DataTable QueryPurchaseOrderBatchNumberList(PurchaseOrderBatchNumberQueryFilter queryFilter, out int totalCount) { DataTable dt = new DataTable(); PagingInfoEntity pagingInfo = new PagingInfoEntity() { SortField = queryFilter.PageInfo.SortBy, StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize, MaximumRows = queryFilter.PageInfo.PageSize }; CustomDataCommand dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("SearchPOBatchNumberList"); using (DynamicQuerySqlBuilder sqlBuilder = new DynamicQuerySqlBuilder(dataCommand.CommandText, dataCommand, pagingInfo, "batch.ExpDate desc")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "batch.ProductSysNo", DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryFilter.ProductSysNo); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "batch.StockSysNo", DbType.Int32, "@StockSysNo", QueryConditionOperatorType.Equal, queryFilter.StockSysNo); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); if (pagingInfo != null) { dataCommand.SetParameterValue("@StartNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex); dataCommand.SetParameterValue("@EndNumber", queryFilter.PageInfo.PageSize * queryFilter.PageInfo.PageIndex + queryFilter.PageInfo.PageSize); } } dt = dataCommand.ExecuteDataTable("Status", typeof(PurchaseOrderBatchInfoStatus)); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); return(dt); }
public QueryResult QueryPurchaseOrderBatchNumberList(PurchaseOrderBatchNumberQueryFilter queryFilter) { QueryResult result = new QueryResult(); int totalCount = 0; result.Data = ObjectFactory <IPurchaseOrderQueryDA> .Instance.QueryPurchaseOrderBatchNumberList(queryFilter, out totalCount); result.TotalCount = totalCount; return(result); }
public PurchaseOrderBatchInfoList(int itemSysNo, int productSysNo, int stockSysNo, string batchInfo) { InitializeComponent(); queryFilter = new PurchaseOrderBatchNumberQueryFilter(); list = new List <PurchaseOrderItemBatchInfoVM>(); this.ItemSysNo = itemSysNo; this.ProductSysNo = productSysNo; this.StockSysNo = stockSysNo; this.batchInfo = batchInfo; this.Loaded += new RoutedEventHandler(PurchaseOrderBatchInfoList_Loaded); }
/// <summary> /// 查询PO单退货批次信息 /// </summary> /// <param name="queryFilter"></param> /// <param name="callback"></param> public void QueryPurchaseOrderBatchNumberList(PurchaseOrderBatchNumberQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "POService/PurchaseOrder/QueryPurchaseOrderBatchNumberList"; restClient.QueryDynamicData(relativeUrl, queryFilter, callback); }