public override void OnPageLoad(object sender, EventArgs e) { base.OnPageLoad(sender, e); queryFilter = new ProductBatchQueryFilter(); serviceFacade = new ProductBatchQueryFacade(this); BatchStatusDataSource = new List <KeyValuePair <string, string> >() { new KeyValuePair <string, string>("A", "正常"), new KeyValuePair <string, string>("R", "临期"), new KeyValuePair <string, string>("I", "过期"), }; string getParam = this.Request.Param; if (!string.IsNullOrEmpty(getParam)) { string[] strPrams = getParam.Split(new char[] { '&' }); if (strPrams.Length == 2) { this.ProductSysNo = Convert.ToInt32(strPrams[0]); this.StockSysNo = Convert.ToInt32(strPrams[1]); } } //this.DataContext = BatchStatusDataSource; this.dgBatchDetailQueryResult.Bind(); //SelectionChanged }
public QueryResult QueryProductBatchInfoByFilter(ProductBatchQueryFilter queryFilter) { QueryResult result = new QueryResult(); int totalCount = 0; result.Data = ObjectFactory <IProductBatchQueryDA> .Instance.QueryProductBatch(queryFilter, out totalCount); result.TotalCount = totalCount; return(result); }
/// <summary> /// 查询商品批次信息 /// </summary> /// <param name="filter"></param> /// <param name="totalCount"></param> /// <returns></returns> public virtual DataTable QueryProductBatch(ProductBatchQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); pagingEntity.SortField = "batch.BatchNumber"; pagingEntity.MaximumRows = filter.PagingInfo.PageSize; pagingEntity.StartRowIndex = filter.PagingInfo.PageIndex * filter.PagingInfo.PageSize; CustomDataCommand cmd = DataCommandManager.CreateCustomDataCommandFromConfig("GetProductBatchInfoByProductAndStock"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "batch.BatchNumber")) { if (filter.ProductSysNo.HasValue && filter.ProductSysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND , "p.SysNo" , DbType.Int32 , "@ProductSysNo" , QueryConditionOperatorType.Equal , filter.ProductSysNo); } if (filter.StockSysNo.HasValue && filter.StockSysNo > 0) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND , "bStock.StockSysNo" , DbType.Int32 , "@StockSysNo" , QueryConditionOperatorType.Equal , filter.StockSysNo); } cmd.CommandText = sqlBuilder.BuildQuerySql(); var result = cmd.ExecuteDataTable(); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(result); } }
void UCProductBatch_Loaded(object sender, RoutedEventArgs e) { this.Loaded -= new RoutedEventHandler(UCProductBatch_Loaded); batchExp.Visibility = this.IsBatch ? System.Windows.Visibility.Visible : System.Windows.Visibility.Collapsed; filterVM = new ProductBatchRequestVM(); query = new ProductBatchQueryFilter(); batches = new List <ProductBatchInfoVM>(); facade = new ProductBatchQueryFacade(CPApplication.Current.CurrentPage); filterVM.HasBatch = false; filterVM.IsCreateMode = this.IsCreateMode; filterVM.IsNotReturn = this.IsNotLend_Return; //this.txtReturn.Visibility = System.Windows.Visibility.Collapsed; //this.lblReturn.Visibility = System.Windows.Visibility.Collapsed; //this.txtLendNum.Visibility = System.Windows.Visibility.Visible; //this.lblLendNum.Visibility = System.Windows.Visibility.Visible; if (StockSysNo.HasValue) { filterVM.StockSysNo = StockSysNo.Value; } if (ReturnDate.HasValue) { filterVM.ReturnDate = ReturnDate.Value; } if (this.ConverterCost.HasValue) { filterVM.ConvertCost = this.ConverterCost; } filterVM.IsCreateMode = IsCreateMode; filterVM.PType = this.PType; if (!this.IsNotLend_Return) { this.batchdg.Columns[10].Visibility = System.Windows.Visibility.Visible; this.batchdg.Columns[9].IsReadOnly = true; //this.txtReturn.Visibility = System.Windows.Visibility.Visible; //this.lblReturn.Visibility = System.Windows.Visibility.Visible; //this.txtLendNum.Visibility = System.Windows.Visibility.Collapsed; //this.lblLendNum.Visibility = System.Windows.Visibility.Collapsed; } if (this.PType == PageType.Lend) { this.batchdg.Columns[9].Header = "借出数量"; } else { this.batchdg.Columns[9].Header = "数量"; } // 修改Model if (!IsCreateMode) { if (!this.IsBatch) { switch (this.PType) { case PageType.Lend: this.filterVM.LendNum = this.OperationQuantity.ToString(); break; case PageType.Adjust: this.filterVM.AdjustNum = this.OperationQuantity.ToString(); break; case PageType.Convert: this.filterVM.ConvertNum = this.OperationQuantity.ToString(); break; default: break; } } else { this.filterVM.HasBatch = true; } filterVM.ProductSysNo = this.ProductSysNo; filterVM.ProductID = this.ProductID; this.batchdg.Bind(); } // Convert if (this.PType == PageType.Convert) { if (this.ConvertType == ConvertProductType.Source) { this.filterVM.ConvertType = "源商品"; } else if (this.ConvertType == ConvertProductType.Target) { this.filterVM.ConvertType = "目标商品"; } } this.basicInfo.DataContext = filterVM; }
/// <summary> /// 查询商品批次信息 /// </summary> /// <param name="filter"></param> /// <param name="callback"></param> public void QueryProductBatchInfo(ProductBatchQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "InventoryService/Inventory/QueryProductBacthInfo"; restClient.QueryDynamicData(relativeUrl, filter, callback); }