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