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);
}
