/// <summary> /// 查询代收结算单商品List /// </summary> /// <param name="info"></param> /// <param name="callback"></param> public void QueryGatherSettlementItemList(GatherSettleItemsQueryFilter filter, EventHandler <RestClientEventArgs <GatherSettlementItemsQueryRsp> > callback) { filter.CompanyCode = CPApplication.Current.CompanyCode; string relativeUrl = "/POService/GatherSettlement/QueryGatherSettlementItemList"; restClient.Query <GatherSettlementItemsQueryRsp>(relativeUrl, filter, callback); }
public GatherSettlementItemsQueryRsp QueryGatherSettlementItemList(GatherSettleItemsQueryFilter queryFilter) { int totalCount = 0; GatherSettlementItemsQueryRsp rep = new GatherSettlementItemsQueryRsp() { ResultList = ObjectFactory <IGatherSettlementDA> .Instance.QueryConsignSettlementProductList(queryFilter, out totalCount) }; rep.TotalCount = totalCount; return(rep); }
public override void OnPageLoad(object sender, EventArgs e) { base.OnPageLoad(sender, e); gatherInfoVM = new GatherSettlementInfoVM(); filter = new GatherSettleItemsQueryFilter(); serviceFacade = new GatherSettlementFacade(this); InitComboBoxData(); this.DataContext = gatherInfoVM; SetAccessControl(); //供应商附加选择事件 ucVendor.VendorSelected += new EventHandler <VendorSelectedEventArgs>(ucVendor_VendorSelected); }
private void btnSearch_Click(object sender, RoutedEventArgs e) { //查询商品操作 : if (this.gatherInfoVM.VendorInfo == null || !this.gatherInfoVM.VendorInfo.SysNo.HasValue || string.IsNullOrEmpty(this.gatherInfoVM.VendorInfo.VendorBasicInfo.VendorNameLocal)) { Window.Alert(ResGatherNew.AlertMsg_VendorSelect); return; } filter = gatherInfoVM.ConvertVM <GatherSettlementInfoVM, GatherSettleItemsQueryFilter>(); filter.VendorSysNo = gatherInfoVM.VendorInfo.SysNo; SettledProductsGrid.Bind(); }
public List <GatherSettlementItemInfo> QueryConsignSettlementProductList(GatherSettleItemsQueryFilter queryFilter, out int totalCount) { PagingInfoEntity pagingInfo = new PagingInfoEntity() { SortField = queryFilter.PageInfo.SortBy, StartRowIndex = queryFilter.PageInfo.PageIndex * queryFilter.PageInfo.PageSize, MaximumRows = queryFilter.PageInfo.PageSize }; CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryConsignSettleGatherItems"); using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(command.CommandText, command, pagingInfo, "b.SONumber DESC")) { if (queryFilter.VendorSysNo.HasValue) { builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "ship.MerchantSysNo", DbType.Int32, "@VendorSysNo", QueryConditionOperatorType.Equal, queryFilter.VendorSysNo); } builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "s.ReferenceType", DbType.AnsiStringFixedLength, "@ReferenceType", QueryConditionOperatorType.IsNull, DBNull.Value); builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "main.CompanyCode", DbType.AnsiStringFixedLength, "@CompanyCode", QueryConditionOperatorType.Equal, queryFilter.CompanyCode); command.CommandText = builder.BuildQuerySql(); string strSQl1 = string.Empty, strSQl2 = string.Empty, strSQl3 = string.Empty; // ##OrderDate1## ##OrderDate2## int referenceId = 0; if (int.TryParse(queryFilter.ReferenceSysNo, out referenceId)) { strSQl1 += " AND main.SONumber =" + queryFilter.ReferenceSysNo + " "; strSQl2 += " AND main.SysNo = " + queryFilter.ReferenceSysNo + " "; strSQl3 += " AND main.SysNo = " + queryFilter.ReferenceSysNo + " "; } if (queryFilter.CreateDateFrom.HasValue) { strSQl1 += " AND main.OrderDate>'" + queryFilter.CreateDateFrom.ToString() + "'"; strSQl2 += " AND main.CreateTime>'" + queryFilter.CreateDateFrom.ToString() + "'"; strSQl3 += " AND main.CreateTime>'" + queryFilter.CreateDateFrom.ToString() + "'"; } if (queryFilter.CreateDateTo.HasValue) { strSQl1 += " AND main.OrderDate<'" + queryFilter.CreateDateTo.ToString() + "'"; strSQl2 += " AND main.CreateTime<'" + queryFilter.CreateDateTo.ToString() + "'"; strSQl3 += " AND main.CreateTime<'" + queryFilter.CreateDateTo.ToString() + "'"; } if (queryFilter.OutStockRefundDateFrom.HasValue) { strSQl1 += " AND main.InvoiceDate>'" + queryFilter.OutStockRefundDateFrom.ToString() + "'"; strSQl2 += " AND main.RefundTime>'" + queryFilter.OutStockRefundDateFrom.ToString() + "'"; strSQl3 += " AND main.RefundTime>'" + queryFilter.OutStockRefundDateFrom.ToString() + "'"; } if (queryFilter.OutStockRefundDateTo.HasValue) { strSQl1 += " AND main.InvoiceDate<'" + queryFilter.OutStockRefundDateTo.ToString() + "'"; strSQl2 += " AND main.RefundTime<'" + queryFilter.OutStockRefundDateTo.ToString() + "'"; strSQl3 += " AND main.RefundTime<'" + queryFilter.OutStockRefundDateTo.ToString() + "'"; } if (queryFilter.StockSysNo.HasValue) { strSQl1 += " AND main.WarehouseNumber=" + queryFilter.StockSysNo.Value.ToString() + " "; strSQl2 += " AND register.LocationWarehouse=" + queryFilter.StockSysNo.Value.ToString() + " "; } else { throw new BizException("未选择仓库,不能进行该操作!"); } command.CommandText = command.CommandText.Replace("##OrderDate1##", strSQl1).Replace("##OrderDate2##", strSQl2).Replace("##OrderDate3##", strSQl3); List <GatherSettlementItemInfo> list = command.ExecuteEntityList <GatherSettlementItemInfo>(); totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount")); return(list); } }