/// <summary>
/// 导出excel - 备货中心List
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="columns"></param>
public void ExportExcelForTransferStockingList(InventoryTransferStockingQueryFilter queryFilter, ColumnSet[] columns)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "InventoryService/Inventory/QueryInventoryTransferStockingListForExportExcel";
restClient.ExportFile(relativeUrl, queryFilter, columns);
}
/// <summary>
/// 查询 - 备货中心List
/// </summary>
/// <param name="queryFilter"></param>
/// <param name="callback"></param>
public void QueryInventoryTransferStockingList(InventoryTransferStockingQueryFilter queryFilter, EventHandler <RestClientEventArgs <InventoryTransferStockingQueryRsp> > callback)
{
queryFilter.CompanyCode = CPApplication.Current.CompanyCode;
string relativeUrl = "InventoryService/Inventory/QueryInventoryTransferStockingList";
restClient.Query <InventoryTransferStockingQueryRsp>(relativeUrl, queryFilter, callback);
}
public InventoryTransferStockingQueryRsp QueryInventoryTransferStockingList(InventoryTransferStockingQueryFilter queryFilter)
{
InventoryTransferStockingQueryRsp result = new InventoryTransferStockingQueryRsp();
int getTotalCount = 0;
result.ResultList = ObjectFactory <IInventoryTransferStockingDA> .Instance.QueryInventoryTransferStockingList(queryFilter, out getTotalCount);
result.TotalCount = getTotalCount;
return(result);
}
public QueryResult QueryInventoryTransferStockingListForExport(InventoryTransferStockingQueryFilter queryFilter)
{
QueryResult result = new QueryResult();
int getTotalCount = 0;
List <ProductCenterItemInfo> itemInfoList = ObjectFactory <IInventoryTransferStockingDA> .Instance.QueryInventoryTransferStockingList(queryFilter, out getTotalCount);
#region [构建DataTable]
DataTable dt = new DataTable();
dt.Columns.Add("ItemCode");
dt.Columns.Add("ItemName");
dt.Columns.Add("ItemSysNumber");
dt.Columns.Add("ManufacturerName");
dt.Columns.Add("Brand");
dt.Columns.Add("AllAvailableQty");
dt.Columns.Add("ConsignQty");
dt.Columns.Add("AllStockAVGDailySales");
dt.Columns.Add("AllStockAvailableSalesDays");
dt.Columns.Add("AllOutStockQuantity");
dt.Columns.Add("VirtualQty");
dt.Columns.Add("InventoryQty");
dt.Columns.Add("PurchasePrice");
dt.Columns.Add("OrderQty");
dt.Columns.Add("TransferStockQty");
dt.Columns.Add("PurchaseQty");
dt.Columns.Add("SuggestQtyAll");
dt.Columns.Add("VirtualPrice");
dt.Columns.Add("UnitCost");
dt.Columns.Add("GrossProfitRate");
dt.Columns.Add("UnmarketableQty");
dt.Columns.Add("D1");
dt.Columns.Add("D2");
dt.Columns.Add("D3");
dt.Columns.Add("D4");
dt.Columns.Add("D5");
dt.Columns.Add("D6");
dt.Columns.Add("D7");
dt.Columns.Add("W1");
dt.Columns.Add("W2");
dt.Columns.Add("W3");
dt.Columns.Add("W4");
dt.Columns.Add("M1");
dt.Columns.Add("M2");
dt.Columns.Add("M3");
dt.Columns.Add("PO_Memo");
dt.Columns.Add("CurrentPrice");
dt.Columns.Add("JDPrice");
if (null != itemInfoList && itemInfoList.Count > 0)
{
for (int i = 0; i < itemInfoList[0].SuggestTransferStocks.Count; i++)
{
dt.Columns.Add("SuggestTransferStocks_" + i + "_AvailableQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_VirtualQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_OrderQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_ConsignQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_AvailableSalesDays");
dt.Columns.Add("SuggestTransferStocks_" + i + "_PurchaseInQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_ShiftInQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_D1");
dt.Columns.Add("SuggestTransferStocks_" + i + "_D2");
dt.Columns.Add("SuggestTransferStocks_" + i + "_D3");
dt.Columns.Add("SuggestTransferStocks_" + i + "_D4");
dt.Columns.Add("SuggestTransferStocks_" + i + "_D5");
dt.Columns.Add("SuggestTransferStocks_" + i + "_D6");
dt.Columns.Add("SuggestTransferStocks_" + i + "_D7");
dt.Columns.Add("SuggestTransferStocks_" + i + "_W1");
dt.Columns.Add("SuggestTransferStocks_" + i + "_W2");
dt.Columns.Add("SuggestTransferStocks_" + i + "_W3");
dt.Columns.Add("SuggestTransferStocks_" + i + "_W4");
dt.Columns.Add("SuggestTransferStocks_" + i + "_M1");
dt.Columns.Add("SuggestTransferStocks_" + i + "_M2");
dt.Columns.Add("SuggestTransferStocks_" + i + "_M3");
dt.Columns.Add("SuggestTransferStocks_" + i + "_W1RegionSalesQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_M1RegionSalesQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_AVGDailySales");
dt.Columns.Add("SuggestTransferStocks_" + i + "_SuggestQty");
dt.Columns.Add("SuggestTransferStocks_" + i + "_Lastintime");
dt.Columns.Add("SuggestTransferStocks_" + i + "_LastPrice");
}
}
itemInfoList.ForEach(x =>
{
DataRow dr = dt.NewRow();
dr["ItemCode"] = x.ItemCode;
dr["ItemName"] = x.ItemName;
dr["ItemSysNumber"] = x.ItemSysNumber.ToInteger();
dr["ManufacturerName"] = x.ManufacturerName;
dr["Brand"] = x.Brand;
dr["AllAvailableQty"] = x.AllAvailableQty.ToInteger();
dr["ConsignQty"] = x.ConsignQty.ToInteger();
dr["AllStockAVGDailySales"] = x.AllStockAVGDailySales.ToDecimal().ToString("f2");
dr["AllStockAvailableSalesDays"] = x.AllStockAvailableSalesDays.ToInteger();
dr["AllOutStockQuantity"] = x.AllOutStockQuantity.ToInteger();
dr["VirtualQty"] = x.VirtualQty.ToInteger();
dr["InventoryQty"] = x.InventoryQty.ToInteger();
dr["PurchasePrice"] = x.PurchasePrice.ToDecimal().ToString("f2");
dr["OrderQty"] = x.OrderQty.ToInteger();
dr["TransferStockQty"] = x.TransferStockQty.ToInteger();
dr["PurchaseQty"] = x.PurchaseQty.ToInteger();
dr["SuggestQtyAll"] = x.SuggestQtyAll.ToInteger();
dr["VirtualPrice"] = x.VirtualPrice.ToDecimal().ToString("f2");
dr["UnitCost"] = x.UnitCost.ToDecimal().ToString("f2");
dr["GrossProfitRate"] = x.GrossProfitRate;
dr["D1"] = x.D1.ToInteger();
dr["D2"] = x.D2.ToInteger();
dr["D3"] = x.D3.ToInteger();
dr["D4"] = x.D4.ToInteger();
dr["D5"] = x.D5.ToInteger();
dr["D6"] = x.D6.ToInteger();
dr["D7"] = x.D7.ToInteger();
dr["W1"] = x.W1.ToInteger();
dr["W2"] = x.W2.ToInteger();
dr["W3"] = x.W3.ToInteger();
dr["W4"] = x.W4.ToInteger();
dr["M1"] = x.M1.ToInteger();
dr["M2"] = x.M2.ToInteger();
dr["M3"] = x.M3.ToInteger();
dr["PO_Memo"] = x.PO_Memo;
dr["CurrentPrice"] = x.CurrentPrice.ToDecimal().ToString("f2");
dr["JDPrice"] = x.JDPrice.ToDecimal().ToString("f2");
int stockIndex = 0;
x.SuggestTransferStocks.ForEach(y =>
{
dr["SuggestTransferStocks_" + stockIndex + "_AvailableQty"] = y.AvailableQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_VirtualQty"] = y.VirtualQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_OrderQty"] = y.OrderQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_ConsignQty"] = y.ConsignQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_AvailableSalesDays"] = y.AvailableSalesDays.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_PurchaseInQty"] = y.PurchaseInQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_ShiftInQty"] = y.ShiftInQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_D1"] = y.D1.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_D2"] = y.D2.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_D3"] = y.D3.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_D4"] = y.D4.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_D5"] = y.D5.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_D6"] = y.D6.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_D7"] = y.D7.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_W1"] = y.W1.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_W2"] = y.W2.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_W3"] = y.W3.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_W4"] = y.W4.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_M1"] = y.M1.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_M2"] = y.M2.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_M3"] = y.M3.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_W1RegionSalesQty"] = y.W1RegionSalesQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_M1RegionSalesQty"] = y.M1RegionSalesQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_AVGDailySales"] = y.AVGDailySales.ToDecimal().ToString("f2");
dr["SuggestTransferStocks_" + stockIndex + "_SuggestQty"] = y.SuggestQty.ToInteger();
dr["SuggestTransferStocks_" + stockIndex + "_Lastintime"] = y.Lastintime;
dr["SuggestTransferStocks_" + stockIndex + "_LastPrice"] = y.LastPrice.ToDecimal().ToString("f2");
stockIndex++;
});
dt.Rows.Add(dr);
});
#endregion
result.Data = dt;
result.TotalCount = getTotalCount;
return(result);
}
