private void dgProductCostResult_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { queryFilter = EntityConverter <ProductCostQueryVM, ProductCostQueryFilter> .Convert(queryVM); this.queryFilter.PagingInfo = new QueryFilter.Common.PagingInfo(); this.queryFilter.PagingInfo.PageIndex = e.PageIndex; this.queryFilter.PagingInfo.PageSize = e.PageSize; this.queryFilter.PagingInfo.SortBy = e.SortField; #region 获取自己能访问到的PM //queryFilter.UserSysNo = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.LoginUser.UserSysNo; queryFilter.CompanyCode = Newegg.Oversea.Silverlight.ControlPanel.Core.CPApplication.Current.CompanyCode; serviceFacade.QueryProductCostInList(queryFilter, (obj, args) => { if (args.FaultsHandle()) { return; } dgProductCostQueryResult.TotalCount = args.Result.TotalCount; dgProductCostQueryResult.ItemsSource = args.Result.Rows.ToList("IsCheck", false); }); #endregion }
public void QueryProductCostInList(ProductCostQueryFilter queryFilter, EventHandler <RestClientEventArgs <dynamic> > callback) { queryFilter.CompanyCode = CPApplication.Current.CompanyCode; string relativeUrl = "InventoryService/Inventory/QueryProductCostInList"; restClient.QueryDynamicData(relativeUrl, queryFilter, callback); }
public QueryResult QueryProductCostInList(ProductCostQueryFilter queryFilter) { QueryResult result = new QueryResult(); int getTotalCount = 0; result.Data = ObjectFactory <IProductCostQueryDA> .Instance.QueryProductCostInList(queryFilter, out getTotalCount); result.TotalCount = getTotalCount; return(result); }
private void btnSearch_Click(object sender, RoutedEventArgs e) { this.queryFilter = EntityConverter <ProductCostQueryVM, ProductCostQueryFilter> .Convert(this.queryVM); if (queryFilter == null || !queryFilter.ProductSysNo.HasValue) { Window.Alert(string.Format("请输入商品编号")); return; } this.dgProductCostQueryResult.Bind(); }
public virtual DataTable QueryProductCostInList(ProductCostQueryFilter queryFilter, out int totalCount) { DataTable dt = new DataTable(); if (queryFilter == null) { totalCount = 0; return(null); } var dataCommand = DataCommandManager.CreateCustomDataCommandFromConfig("QueryProductCostInList"); PagingInfoEntity pagingInfo = new PagingInfoEntity() { SortField = queryFilter.PagingInfo.SortBy, StartRowIndex = queryFilter.PagingInfo.PageIndex * queryFilter.PagingInfo.PageSize, MaximumRows = queryFilter.PagingInfo.PageSize }; using (var sqlBuilder = new DynamicQuerySqlBuilder( dataCommand.CommandText, dataCommand, pagingInfo, "c.[Priority],c.SysNo")) { if (queryFilter.IsAvailableInventory) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.LeftQuantity", DbType.Int32, "@LeftQuantity", QueryConditionOperatorType.MoreThan, 0); } else { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.LeftQuantity", DbType.Int32, "@LeftQuantity", QueryConditionOperatorType.MoreThanOrEqual, 0); } if (queryFilter.ProductSysNo.HasValue) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "c.ProductSysNo", DbType.Int32, "@ProductSysNo", QueryConditionOperatorType.Equal, queryFilter.ProductSysNo.Value); dataCommand.CommandText = sqlBuilder.BuildQuerySql(); dt = dataCommand.ExecuteDataTable(); totalCount = Convert.ToInt32(dataCommand.GetParameterValue("@TotalCount")); } else { totalCount = 0; } } return(dt); }
public override void OnPageLoad(object sender, EventArgs e) { base.OnPageLoad(sender, e); queryFilter = new ProductCostQueryFilter(); queryVM = new ProductCostQueryVM(); serviceFacade = new ProductCostQueryFacade(this); string getParam = this.Request.Param; if (!string.IsNullOrEmpty(getParam)) { queryVM.ProductSysNo = Convert.ToInt32(getParam.Trim()); this.DataContext = queryVM; btnSearch_Click(null, null); } else { this.DataContext = queryVM; } }