prometheus告警
开始时间: 10:44:08
错误代码: N1044081
sql类型: -----------采购入库---------
sql: [10:44:08] -------------------------------------------------------------
CODE:N1044081
Error:15_102_1_-2146232060
SQL:-----------采购入库---------
select top 0 t.月 份,
t.产 品 名 称,
t.仓 库 类 型,
t.WareHouseName AS '入库仓库',
t.一 级 单 据 类 型,
t.一 级 单 据 类 型 AS '二级单据类型',
t.SupplierID AS '供应商ID',
t.SupplierName AS '供应商',
CASE
t.ProcType
WHEN 1 THEN '市场采购'
WHEN 2 THEN '网络采购'
WHEN 3 THEN '工厂采购'
WHEN 4 THEN '自主生产'
ELSE '其他'
END AS '采购类型',
CASE
t.ProcPayType
WHEN 1 THEN '付款给采购'
WHEN 2 THEN '网络自动付款'
WHEN 3 THEN '付款给供应商'
WHEN 4 THEN '阿里账期付款'
END AS '付款方式',
t.BuyerName 采 购 员,
SUM(t.OperateNum) 数 量,
SUM(t.金 额) 金 额,
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.不 含 包 材 金 额) 不 含 包 材 金 额,
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
t.BrandName '品牌名称',
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
p.ProductNameCN '产品名称',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
b.WareHouseName,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
pds.SupplierID,
pds.SupplierName,
CASE
WHEN ISNULL(pds.SupplierType, 0) = 0 THEN ISNULL(ps.SupplierType, 0)
ELSE pds.SupplierType
END ProcType,
--采购类型
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * ISNULL(a.BuyPrice + a.BuyShipPrice - a.UnitMinus, 0) 不 含 包 材 金 额,
p.ProductType ProductType,
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
a.SKU,
ISNULL(pb.BrandName, '') BrandName,
pds.ProcPayType,
--AS 付款方式,
pds.BuyerName --采购员
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON a.CustomerID = b.CustomerID
AND a.WareHouseID = b.ID
LEFT JOIN dbo.RB_Procurement_Detail_BuyList (NOLOCK) pdb ON pdb.CustomerID = a.CustomerID
AND a.OriginBillNumber = pdb.ListNo
LEFT JOIN dbo.RB_Procurement_Detail_SingleList (NOLOCK) pds ON pds.CustomerID = pdb.CustomerID
AND pds.Single_NO = pdb.Single_NO
LEFT JOIN dbo.RB_Product_Supplier (NOLOCK) ps ON ps.CustomerID = pds.CustomerID
AND ps.ID = pds.SupplierID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
LEFT JOIN dbo.RB_Product_Brand pb ON pb.ID = p.BrandID
AND pb.CustomerID = a.CustomerID
WHERE
a.CustomerID = @customerid
AND a.BillType = 0
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType NOT IN (75, 76, 81)
AND a.OriginBillNumber != ''
UNION ALL
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
p.ProductNameCN '产品名称',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
b.WareHouseName,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
d.SupplierID,
d.SupplierName,
CASE
WHEN ISNULL(e.SupplierType, 0) = 0 THEN ISNULL(e.SupplierType, 0)
ELSE e.SupplierType
END ProcType,
--采购类型
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * ISNULL(a.BuyPrice + a.BuyShipPrice - a.UnitMinus, 0) 不 含 包 材 金 额,
p.ProductType,
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
a.SKU,
ISNULL(pb.BrandName, '') BrandName,
e.ProcPayType,
--AS 付款方式,
e.BuyerName --采购员
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON a.CustomerID = b.CustomerID
AND a.WareHouseID = b.ID
LEFT JOIN dbo.RB_WareHouse_Product_PutIn_Log c ON c.ID = a.RealtionId
AND a.CustomerID = c.CustomerID
LEFT JOIN dbo.RB_Procurement_Detail_SingleList_Detail d ON d.ID = c.SingleDetailID
AND a.CustomerID = d.CustomerID
LEFT JOIN dbo.RB_Procurement_Detail_SingleList (NOLOCK) e ON e.CustomerID = a.CustomerID
AND e.ID = d.ListID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
LEFT JOIN dbo.RB_Product_Brand pb ON pb.ID = p.BrandID
AND pb.CustomerID = a.CustomerID
WHERE
a.CustomerID = @customerid
AND a.BillType = 0
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND a.OriginBillNumber = ''
AND b.WareHouseType NOT IN (75, 76, 81)
AND d.CustomerID IS not NULL
UNION ALL
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
p.ProductNameCN '产品名称',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
b.WareHouseName,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
e.SupplierID,
e.SupplierName,
CASE
WHEN ISNULL(k.SupplierType, 0) = 0 THEN ISNULL(k.SupplierType, 0)
ELSE k.SupplierType
END ProcType,
--采购类型
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * ISNULL(a.BuyPrice + a.BuyShipPrice - a.UnitMinus, 0) 不 含 包 材 金 额,
p.ProductType,
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
a.SKU,
ISNULL(pb.BrandName, '') BrandName,
e.ProcPayType,
--AS 付款方式,
e.BuyerName --采购员
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON a.CustomerID = b.CustomerID
AND a.WareHouseID = b.ID
LEFT JOIN dbo.RB_WareHouse_Product_PutIn_Log c ON c.ID = a.RealtionId
AND a.CustomerID = c.CustomerID
LEFT JOIN dbo.RB_Procurement_Detail_SingleList_Detail d ON d.ID = c.SingleDetailID
AND a.CustomerID = d.CustomerID
left JOIN rb_procurement_detail(NOLOCK) m ON c.CustomerID = m.CustomerID
AND c.DetailID = m.ID
left JOIN dbo.RB_Procurement_List(NOLOCK) e ON c.CustomerID = e.CustomerID
AND c.P_Code = e.P_Code
left join RB_Product_Supplier k (nolock) on e.CustomerID = k.CustomerID
and e.SupplierID = k.ID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
LEFT JOIN dbo.RB_Product_Brand pb ON pb.ID = p.BrandID
AND pb.CustomerID = a.CustomerID
WHERE
a.CustomerID = @customerid
AND a.BillType = 0
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND a.OriginBillNumber = ''
AND b.WareHouseType NOT IN (75, 76, 81)
AND d.CustomerID IS NULL
) t
GROUP BY
CASE
t.ProcType
WHEN 1 THEN '市场采购'
WHEN 2 THEN '网络采购'
WHEN 3 THEN '工厂采购'
WHEN 4 THEN '自主生产'
ELSE '其他'
END,
CASE
t.ProcPayType
WHEN 1 THEN '付款给采购'
WHEN 2 THEN '网络自动付款'
WHEN 3 THEN '付款给供应商'
WHEN 4 THEN '阿里账期付款'
END,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.月 份,
t.产 品 名 称,
t.仓 库 类 型,
t.WareHouseName,
t.一 级 单 据 类 型,
t.一 级 单 据 类 型,
t.SupplierID,
t.SupplierName,
t.BuyerName,
t.Sku,
t.BrandName ---------调拨出库---------
select top 0 t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.发 货 仓 库,
t.母 仓,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
SUM(t.OperateNum) AS '数量',
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.金 额) AS '金额',
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
c.WareHouseName 入 库 仓 库,
b.WareHouseName 发 货 仓 库,
ISNULL(iw.InventoryWarehouseName, b.WareHouseName) '母仓',
'调拨出库单' '一级单据类型',
'调拨出库单' '二级单据类型',
a.OperateNum,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
p.ProductType,
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
a.SKU
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND b.ID = a.WareHouseID
LEFT JOIN (
select top 0 CustomerID,
AllocationNumber,
InWareHouseID,
OutWareHouseID
FROM
dbo.RB_Inventory_AllocationBill (NOLOCK)
) ia ON ia.CustomerID = a.CustomerID
AND a.OriginBillNumber = ia.AllocationNumber
LEFT JOIN (
select top 0 a.CustomerID,
a.OrderListID,
b.AllocationNumber,
b.InWareHouseID,
b.OutWareHouseID
FROM
RB_Inventory_AllocationDetailBill a
INNER JOIN dbo.RB_Inventory_AllocationBill b ON b.CustomerID = a.CustomerID
AND a.AllocationBillID = b.ID
WHERE
a.OrderListID > 0
AND a.Status < 3
) ial ON ial.CustomerID = a.CustomerID
AND ial.OrderListID = a.OrderListID
AND ial.AllocationNumber = a.OriginBillNumber
LEFT JOIN dbo.RB_WareHouse (NOLOCK) c ON c.CustomerID = a.CustomerID
AND c.ID = ISNULL(ial.InWareHouseID, ia.InWareHouseID)
LEFT JOIN dbo.RB_Inventory_WareHouse (NOLOCK) iw ON iw.CustomerID = a.CustomerID
AND a.MontherWareHouseID = iw.ID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
WHERE
a.CustomerID = @CustomerID
AND a.BillType = 5
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType NOT IN (75, 76, 81)
) t
GROUP BY
t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.发 货 仓 库,
t.母 仓,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.Sku;---------调拨入库---------
select top 0 t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.母 仓,
t.发 货 仓 库,
t.一 级 单 据 类 型,
t.一 级 单 据 类 型 AS '二级单据类型',
SUM(t.OperateNum) AS '数量',
SUM(t.金 额) AS '金额',
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
b.WareHouseName 入 库 仓 库,
ISNULL(iw.InventoryWarehouseName, b.WareHouseName) 母 仓,
c.WareHouseName 发 货 仓 库,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
a.UnitPrice,
a.BuyPrice,
p.ProductType,
a.SKU
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN (
select top 0 CustomerID,
AllocationNumber,
InWareHouseID,
OutWareHouseID
FROM
dbo.RB_Inventory_AllocationBill (NOLOCK)
) ia ON ia.CustomerID = a.CustomerID
AND a.OriginBillNumber = ia.AllocationNumber
LEFT JOIN (
select top 0 a.CustomerID,
a.OrderListID,
b.AllocationNumber,
b.InWareHouseID,
b.OutWareHouseID
FROM
RB_Inventory_AllocationDetailBill a
INNER JOIN dbo.RB_Inventory_AllocationBill b ON b.CustomerID = a.CustomerID
AND a.AllocationBillID = b.ID
WHERE
a.OrderListID > 0
AND a.Status < 3
) ial ON ial.CustomerID = a.CustomerID
AND ial.OrderListID = a.OrderListID
AND ial.AllocationNumber = a.OriginBillNumber
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND b.ID = a.WareHouseID
LEFT JOIN dbo.RB_WareHouse (NOLOCK) c ON c.CustomerID = ia.CustomerID
AND c.ID = ISNULL(ial.OutWareHouseID, ia.OutWareHouseID)
LEFT JOIN dbo.RB_Inventory_WareHouse (NOLOCK) iw ON iw.CustomerID = a.CustomerID
AND a.MontherWareHouseID = iw.ID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
WHERE
a.CustomerID = @CustomerID
AND a.BillType = 4
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType != 81
) t
GROUP BY
t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.母 仓,
t.发 货 仓 库,
t.一 级 单 据 类 型,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.Sku;---------销售出库-------------
select top 0 CONVERT(NVARCHAR(6), t.OperateTime, 112) 月 份,
CASE
WHEN wh.WareHouseType = 1 THEN '本地仓'
WHEN wh.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
wh.WareHouseName 仓 库,
ISNULL(iw.InventoryWarehouseName, wh.WareHouseName) 母 仓,
ISNULL(os.OrderSourceName, os2.OrderSourceName) AS '来源渠道',
CASE
ISNULL(os.OrderSourceType, os2.OrderSourceType)
WHEN 1 THEN '亚马逊平台'
WHEN 2 THEN 'Ebay平台'
WHEN 3 THEN '团购平台'
WHEN 4 THEN 'B2C网站平台'
WHEN 5 THEN '赠送订单'
WHEN 6 THEN '枪手订单'
WHEN 7 THEN '问题订单重发'
WHEN 8 THEN '问题订单补发'
WHEN 9 THEN '代发货渠道'
WHEN 10 THEN '亚马逊FBA'
WHEN 19 THEN '其他第三方渠道'
WHEN 20 THEN '本地仓库备库订单'
WHEN 21 THEN '海外仓库备库订单'
WHEN 22 THEN '亚马逊仓库备库订单'
WHEN 23 THEN 'Wish平台'
WHEN 24 THEN '共享平台'
WHEN 25 THEN '速卖通平台'
WHEN 26 THEN '麦进斗平台'
WHEN 27 THEN '敦煌平台'
WHEN 28 THEN 'PayPal交易斗平台'
WHEN 29 THEN '新蛋平台'
WHEN 30 THEN 'LetsEcig平台'
WHEN 31 THEN 'Meetgift平台'
WHEN 32 THEN 'Qoo10平台'
WHEN 33 THEN 'Lazada平台'
WHEN 34 THEN 'Alibaba平台'
WHEN 35 THEN 'Cdiscount平台'
WHEN 36 THEN 'Linio平台'
WHEN 37 THEN 'Bellabuy平台'
WHEN 38 THEN '京东平台'
WHEN 39 THEN 'Tophatter平台'
WHEN 40 THEN 'PriceMinister平台'
WHEN 41 THEN 'Mercadolibre平台'
WHEN 42 THEN 'Shopee平台'
WHEN 43 THEN 'Kamvio平台'
WHEN 44 THEN 'Amazonvendorexpress平台'
WHEN 45 THEN 'Walmart平台'
WHEN 46 THEN 'Deal平台'
WHEN 47 THEN 'Jumia平台'
WHEN 48 THEN 'Jet平台'
WHEN 49 THEN 'Sears平台'
WHEN 50 THEN 'Shopify平台'
WHEN 51 THEN 'Joom平台'
WHEN 52 THEN 'MyMall平台'
WHEN 53 THEN 'FactoryMarket平台'
WHEN 54 THEN 'Fyndiq平台'
WHEN 55 THEN '京东国内平台'
WHEN 56 THEN 'Oberlo平台'
WHEN 57 THEN '速卖通V2平台'
WHEN 58 THEN 'LazadaV2平台'
WHEN 59 THEN 'Yandex平台'
WHEN 60 THEN 'Paytm平台'
WHEN 61 THEN '京东国际平台'
WHEN 62 THEN 'Vova平台'
WHEN 63 THEN '京东印尼平台'
WHEN 64 THEN 'UMKA平台'
WHEN 65 THEN 'Rakuten平台'
WHEN 66 THEN '值点平台'
WHEN 67 THEN 'Allegro平台'
WHEN 68 THEN '亲库平台'
WHEN 69 THEN 'ZoodMall平台'
WHEN 70 THEN 'Mercadolibre国际平台'
WHEN 71 THEN 'Gmarket平台'
WHEN 72 THEN 'Auction平台'
WHEN 73 THEN 'Coupang平台'
WHEN 74 THEN 'FacebookMarketplace平台'
WHEN 75 THEN 'KauflandDe平台'
WHEN 76 THEN '阿里巴巴国际站平台'
WHEN 77 THEN 'RatukenDE平台'
WHEN 78 THEN 'Wayfair平台'
WHEN 79 THEN '店匠平台'
WHEN 80 THEN 'B2W平台'
WHEN 81 THEN 'Kogan平台'
WHEN 82 THEN 'Fruugo平台'
WHEN 83 THEN 'Komolett平台'
WHEN 84 THEN 'Digitect平台'
WHEN 85 THEN 'Yahoo平台'
WHEN 87 THEN '沃尔玛DSV平台'
WHEN 88 THEN 'Shopyy平台'
WHEN 89 THEN 'L192平台'
WHEN 90 THEN 'OTTO平台'
WHEN 91 THEN 'CrossMall平台'
WHEN 92 THEN 'Fnac平台'
WHEN 93 THEN 'Darty平台'
WHEN 94 THEN 'EPrice平台'
WHEN 95 THEN 'Daraz平台'
WHEN 96 THEN 'Americanas平台'
WHEN 97 THEN 'ShopeeV2平台'
WHEN 98 THEN 'Snapdeal平台'
WHEN 99 THEN 'Submarino平台'
WHEN 100 THEN 'Overstock平台'
WHEN 101 THEN 'ManoMano平台'
WHEN 102 THEN 'RueduCommerce平台'
WHEN 103 THEN 'TradeMe平台'
WHEN 104 THEN 'TikTok平台'
WHEN 105 THEN 'Worten平台'
WHEN 106 THEN 'PayPayMall平台'
WHEN 107 THEN 'Target平台'
WHEN 108 THEN 'Flipkart平台'
WHEN 109 THEN 'BestBuy平台'
WHEN 110 THEN 'BolCom平台'
WHEN 111 THEN 'Tokopedia平台'
WHEN 112 THEN 'SHOPLINE平台'
WHEN 114 THEN 'Akulaku平台'
WHEN 115 THEN 'Funpinpin平台'
WHEN 116 THEN 'Fannoshop平台'
WHEN 117 THEN 'OnBuy平台'
WHEN 118 THEN 'HomeDepot平台'
WHEN 119 THEN 'WooCommerce平台'
WHEN 120 THEN 'Thisshop平台'
WHEN 121 THEN 'XShoppy平台'
ELSE ''
END '来源渠道平台',
'销售出库单' AS '一级单据类型',
'销售出库单' AS '二级单据类型',
SUM(ISNULL(t.OperateNum, 0)) AS '数量',
SUM(t.OperateNum * ISNULL(t.MUnitPrice, 0)) AS '管理帐金额',
SUM(ISNULL(t.OperateNum, 0) * ISNULL(t.UnitPrice, 0)) AS '金额',
SUM(
ISNULL(t.OperateNum, 0) * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
)
) AS '金额（销单价/供货价）',
CASE
p.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.SKU
FROM
dbo.RB_Inventory_DetailLog t (NOLOCK)
LEFT JOIN dbo.RB_WareHouse wh (NOLOCK) ON t.CustomerID = wh.CustomerID
AND t.WareHouseID = wh.ID
LEFT JOIN RB_Product p (NOLOCK) ON p.CustomerID = t.CustomerID
AND p.SKU = t.SKU
LEFT JOIN dbo.RB_Inventory_WareHouse (NOLOCK) iw ON iw.CustomerID = t.CustomerID
AND t.MontherWareHouseID = iw.ID
LEFT JOIN dbo.RB_OrderInfo (NOLOCK) oi ON oi.CustomerID = t.CustomerID
AND t.OriginBillNumber = oi.OrderCode
LEFT JOIN dbo.RB_OrderList (NOLOCK) ol ON ol.CustomerID = t.CustomerID
AND ol.ID = t.OrderListID
LEFT JOIN dbo.RB_OrderInfo (NOLOCK) oi2 ON oi2.OrderCode = ol.OrderCode
AND oi2.CustomerID = t.CustomerID
LEFT JOIN dbo.RB_OrderSource os ON os.CustomerID = oi.CustomerID
AND os.ID = oi.OrderSourceID
LEFT JOIN RB_OrderSource os2 ON os2.ID = oi2.OrderSourceID
AND os2.CustomerID = t.CustomerID
WHERE
t.CustomerID = @CustomerID
AND t.OperateTime >= @starttime
AND t.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND t.BillType = 2
AND wh.WareHouseType NOT IN (75, 76, 81)
GROUP BY
CONVERT(NVARCHAR(6), t.OperateTime, 112),
CASE
WHEN wh.WareHouseType = 1 THEN '本地仓'
WHEN wh.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END,
ISNULL(iw.InventoryWarehouseName, wh.WareHouseName),
ISNULL(os.OrderSourceName, os2.OrderSourceName),
CASE
ISNULL(os.OrderSourceType, os2.OrderSourceType)
WHEN 1 THEN '亚马逊平台'
WHEN 2 THEN 'Ebay平台'
WHEN 3 THEN '团购平台'
WHEN 4 THEN 'B2C网站平台'
WHEN 5 THEN '赠送订单'
WHEN 6 THEN '枪手订单'
WHEN 7 THEN '问题订单重发'
WHEN 8 THEN '问题订单补发'
WHEN 9 THEN '代发货渠道'
WHEN 10 THEN '亚马逊FBA'
WHEN 19 THEN '其他第三方渠道'
WHEN 20 THEN '本地仓库备库订单'
WHEN 21 THEN '海外仓库备库订单'
WHEN 22 THEN '亚马逊仓库备库订单'
WHEN 23 THEN 'Wish平台'
WHEN 24 THEN '共享平台'
WHEN 25 THEN '速卖通平台'
WHEN 26 THEN '麦进斗平台'
WHEN 27 THEN '敦煌平台'
WHEN 28 THEN 'PayPal交易斗平台'
WHEN 29 THEN '新蛋平台'
WHEN 30 THEN 'LetsEcig平台'
WHEN 31 THEN 'Meetgift平台'
WHEN 32 THEN 'Qoo10平台'
WHEN 33 THEN 'Lazada平台'
WHEN 34 THEN 'Alibaba平台'
WHEN 35 THEN 'Cdiscount平台'
WHEN 36 THEN 'Linio平台'
WHEN 37 THEN 'Bellabuy平台'
WHEN 38 THEN '京东平台'
WHEN 39 THEN 'Tophatter平台'
WHEN 40 THEN 'PriceMinister平台'
WHEN 41 THEN 'Mercadolibre平台'
WHEN 42 THEN 'Shopee平台'
WHEN 43 THEN 'Kamvio平台'
WHEN 44 THEN 'Amazonvendorexpress平台'
WHEN 45 THEN 'Walmart平台'
WHEN 46 THEN 'Deal平台'
WHEN 47 THEN 'Jumia平台'
WHEN 48 THEN 'Jet平台'
WHEN 49 THEN 'Sears平台'
WHEN 50 THEN 'Shopify平台'
WHEN 51 THEN 'Joom平台'
WHEN 52 THEN 'MyMall平台'
WHEN 53 THEN 'FactoryMarket平台'
WHEN 54 THEN 'Fyndiq平台'
WHEN 55 THEN '京东国内平台'
WHEN 56 THEN 'Oberlo平台'
WHEN 57 THEN '速卖通V2平台'
WHEN 58 THEN 'LazadaV2平台'
WHEN 59 THEN 'Yandex平台'
WHEN 60 THEN 'Paytm平台'
WHEN 61 THEN '京东国际平台'
WHEN 62 THEN 'Vova平台'
WHEN 63 THEN '京东印尼平台'
WHEN 64 THEN 'UMKA平台'
WHEN 65 THEN 'Rakuten平台'
WHEN 66 THEN '值点平台'
WHEN 67 THEN 'Allegro平台'
WHEN 68 THEN '亲库平台'
WHEN 69 THEN 'ZoodMall平台'
WHEN 70 THEN 'Mercadolibre国际平台'
WHEN 71 THEN 'Gmarket平台'
WHEN 72 THEN 'Auction平台'
WHEN 73 THEN 'Coupang平台'
WHEN 74 THEN 'FacebookMarketplace平台'
WHEN 75 THEN 'KauflandDe平台'
WHEN 76 THEN '阿里巴巴国际站平台'
WHEN 77 THEN 'RatukenDE平台'
WHEN 78 THEN 'Wayfair平台'
WHEN 79 THEN '店匠平台'
WHEN 80 THEN 'B2W平台'
WHEN 81 THEN 'Kogan平台'
WHEN 82 THEN 'Fruugo平台'
WHEN 83 THEN 'Komolett平台'
WHEN 84 THEN 'Digitect平台'
WHEN 85 THEN 'Yahoo平台'
WHEN 87 THEN '沃尔玛DSV平台'
WHEN 88 THEN 'Shopyy平台'
WHEN 89 THEN 'L192平台'
WHEN 90 THEN 'OTTO平台'
WHEN 91 THEN 'CrossMall平台'
WHEN 92 THEN 'Fnac平台'
WHEN 93 THEN 'Darty平台'
WHEN 94 THEN 'EPrice平台'
WHEN 95 THEN 'Daraz平台'
WHEN 96 THEN 'Americanas平台'
WHEN 97 THEN 'ShopeeV2平台'
WHEN 98 THEN 'Snapdeal平台'
WHEN 99 THEN 'Submarino平台'
WHEN 100 THEN 'Overstock平台'
WHEN 101 THEN 'ManoMano平台'
WHEN 102 THEN 'RueduCommerce平台'
WHEN 103 THEN 'TradeMe平台'
WHEN 104 THEN 'TikTok平台'
WHEN 105 THEN 'Worten平台'
WHEN 106 THEN 'PayPayMall平台'
WHEN 107 THEN 'Target平台'
WHEN 108 THEN 'Flipkart平台'
WHEN 109 THEN 'BestBuy平台'
WHEN 110 THEN 'BolCom平台'
WHEN 111 THEN 'Tokopedia平台'
WHEN 112 THEN 'SHOPLINE平台'
WHEN 114 THEN 'Akulaku平台'
WHEN 115 THEN 'Funpinpin平台'
WHEN 116 THEN 'Fannoshop平台'
WHEN 117 THEN 'OnBuy平台'
WHEN 118 THEN 'HomeDepot平台'
WHEN 119 THEN 'WooCommerce平台'
WHEN 120 THEN 'Thisshop平台'
WHEN 121 THEN 'XShoppy平台'
ELSE ''
END,
CASE
p.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
wh.WareHouseName,
t.SKU ---------其他出入库---------
select top 0 t.月 份,
t.仓 库 类 型,
t.仓 库,
t.母 仓,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
SUM(t.OperateNum) AS '数量',
SUM(t.金 额) AS '金额',
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
t.BrandName '品牌名称',
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
b.WareHouseName 仓 库,
ISNULL(iw.InventoryWarehouseName, b.WareHouseName) 母 仓,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
CASE
iib.OperateType
WHEN 1 THEN '其他入库'
WHEN 2 THEN '物流退回入库'
WHEN 3 THEN '备品入库'
WHEN 4 THEN '客户退货入库'
WHEN 9 THEN '第三方仓入库'
WHEN 10 THEN '换货入库'
WHEN 11 THEN '拍照归还入库'
WHEN 12 THEN '拍卖归还入库'
WHEN 13 THEN '重新质检入库'
WHEN 14 THEN '系统操作失误入库'
WHEN 15 THEN '发货仓多发入库'
WHEN 16 THEN '本地仓发错入库'
WHEN 17 THEN '办公用品入库'
WHEN 25 THEN '物流丢包'
WHEN 27 THEN '收货仓少收入库'
WHEN 29 THEN '盘盈入库'
WHEN 46 THEN '收货仓丢包'
WHEN 34 THEN 'FBA库存找到'
WHEN 35 THEN 'FBA库存丢失'
WHEN 36 THEN 'FBA库存报废'
WHEN 37 THEN '从暂存仓移入'
WHEN 38 THEN '移出至暂存仓'
WHEN 39 THEN '盘点移入'
WHEN 40 THEN '盘点移出'
WHEN 41 THEN 'FBA仓客户退货入库'
WHEN 43 THEN '其他入库报关入库'
WHEN 45 THEN '海外仓客户退件入库'
WHEN 5 THEN '其他出库'
WHEN 6 THEN '呆滞品退货出库'
WHEN 7 THEN '清货销售出库'
WHEN 8 THEN '销毁出库'
WHEN 18 THEN '换货出库'
WHEN 19 THEN '办公用品出库'
WHEN 20 THEN '拍照出库'
WHEN 21 THEN '拍卖出库'
WHEN 22 THEN '采购退货出库'
WHEN 23 THEN '质检出库'
WHEN 24 THEN '发货仓少发出库'
WHEN 26 THEN '收货仓多收出库'
WHEN 28 THEN '包材出库'
WHEN 30 THEN '盘亏出库'
WHEN 31 THEN '未称重出库'
WHEN 32 THEN '加工原料出库'
WHEN 33 THEN '物流丢包'
WHEN 34 THEN 'FBA库存找到'
WHEN 35 THEN 'FBA库存丢失'
WHEN 36 THEN 'FBA库存报废'
WHEN 37 THEN '从暂存仓移入'
WHEN 38 THEN '移出至暂存仓'
WHEN 39 THEN '盘点移入'
WHEN 40 THEN '盘点移出'
WHEN 42 THEN '其他出库报关出库'
WHEN 44 THEN '物流退回出库'
WHEN 47 then '在途仓收货调整'
WHEN 48 THEN '换标入库'
WHEN 49 THEN '换标出库'
WHEN 50 THEN '其他入库_数据换标入库'
WHEN 51 THEN '其他入库_业务换标入库'
WHEN 52 THEN '其他出库_数据换标出库'
WHEN 53 THEN '其他出库_业务换标出库'
WHEN 54 THEN '调拨收货调整'
ELSE CASE
WHEN a.BillType = 1
AND iad.ID > 0 THEN '组合产品入库'
WHEN a.BillType = 3
AND iad.ID > 0 THEN '子产品出库'
WHEN a.BillType = 3
AND ipi.ID > 0 THEN '采购包材出库'
ELSE ''
END
END 二 级 单 据 类 型,
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
p.ProductType,
a.SKU,
ISNULL(pb.BrandName, '') BrandName
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN dbo.RB_Inventory_InOutBallance iib ON iib.CustomerID = a.CustomerID
AND iib.BallanceNumber = a.OriginBillNumber
AND a.SKU = iib.SKU
AND a.RealtionId = iib.ID
AND a.BillType IN (1, 3)
LEFT JOIN dbo.RB_Inventory_Assembly_Disassembly (NOLOCK) iad ON iad.CustomerID = a.CustomerID
AND a.OriginBillNumber = iad.BillNumber
AND a.BillType IN (1, 3)
LEFT JOIN dbo.RB_Inventory_PackingMaterials_Info (NOLOCK) ipi ON ipi.CustomerID = a.CustomerID
AND a.OriginBillNumber = ipi.PackingNumber
AND a.BillType = 3
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND b.ID = a.WareHouseID
LEFT JOIN dbo.RB_Inventory_WareHouse (NOLOCK) iw ON iw.CustomerID = a.CustomerID
AND a.MontherWareHouseID = iw.ID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
LEFT JOIN dbo.RB_Product_Brand pb ON pb.ID = p.BrandID
AND pb.CustomerID = a.CustomerID
WHERE
a.CustomerID = @CustomerID
AND a.BillType IN (1, 3)
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType NOT IN (75, 76, 81)
) t
GROUP BY
t.月 份,
t.仓 库 类 型,
t.仓 库,
t.母 仓,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.Sku,
t.BrandName;---------盘盈亏---------
select top 0 t.月 份,
t.仓 库 类 型,
t.仓 库,
t.母 仓,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
SUM(t.OperateNum) AS '数量',
SUM(t.金 额) AS '金额',
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
t.BrandName '品牌名称',
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
b.WareHouseName 仓 库,
ISNULL(iw.InventoryWarehouseName, b.WareHouseName) 母 仓,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '二级单据类型',
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
ISNULL(pb.BrandName, '') BrandName,
p.ProductType,
a.SKU
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND b.ID = a.WareHouseID
LEFT JOIN dbo.RB_Inventory_WareHouse (NOLOCK) iw ON iw.CustomerID = a.CustomerID
AND a.MontherWareHouseID = iw.ID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
LEFT JOIN dbo.RB_Product_Brand pb ON pb.ID = p.BrandID
AND pb.CustomerID = a.CustomerID
WHERE
a.CustomerID = @CustomerID
AND a.BillType IN (6, 7)
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType NOT IN (75, 76, 81)
) t
GROUP BY
t.月 份,
t.仓 库 类 型,
t.仓 库,
t.母 仓,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.Sku,
t.BrandName;---------退供应商出库---------
select top 0 t.月 份,
t.仓 库 类 型,
t.仓 库,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
SUM(t.OperateNum) AS '数量',
t.核 算 单 价,
SUM(t.金 额) AS '金额',
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
t.退 货 产 品 价 格,
t.供 应 商,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
ELSE '海外仓'
END AS '仓库类型',
b.WareHouseName 仓 库,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '二级单据类型',
a.OperateNum,
ISNULL(a.UnitPrice, 0) '核算单价',
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
p.ProductType,
a.SKU,
t2.供 应 商,
t2.退 货 产 品 价 格
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND b.ID = a.WareHouseID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
LEFT JOIN (
select top 0 srg.ReturnCode,
ps.SupplierName AS '供应商',
srg.WareHouseID,
srgd.SKU,
srg.CustomerID,
srgd.ReturnPrice AS '退货产品价格'
FROM
RB_SupplierReturnGood srg (NOLOCK)
LEFT JOIN RB_SupplierReturnGood_Detail srgd (NOLOCK) ON srg.ReturnCode = srgd.ReturnCode
AND srg.CustomerID = srgd.CustomerID
LEFT JOIN RB_Product_Supplier ps (NOLOCK) ON srg.SupplierID = ps.ID
AND srg.CustomerID = ps.CustomerID
WHERE
srg.CustomerID = @CustomerID
) t2 ON t2.WareHouseID = a.WareHouseID
AND t2.ReturnCode = a.OriginBillNumber
AND a.SKU = t2.SKU
AND a.CustomerID = t2.CustomerID
WHERE
a.CustomerID = @CustomerID
AND a.BillType = 8
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType NOT IN (75, 76, 81)
) t
GROUP BY
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.仓 库 类 型,
t.仓 库,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
t.核 算 单 价,
t.退 货 产 品 价 格,
t.供 应 商,
t.月 份,
t.Sku;---------在途仓---------
select top 0 t.出 入 库 类 型,
t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.发 货 仓 库,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
SUM(t.OperateNum) AS '数量',
SUM(t.金 额) AS '金额',
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
t.BrandName '品牌名称',
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
WHEN a.BillType IN (0, 1, 4, 6) THEN '入库'
ELSE '出库'
END 出 入 库 类 型,
CASE
WHEN w.WareHouseType = 1 THEN '本地在途仓'
WHEN w.WareHouseType = 3 THEN 'FBA在途仓'
ELSE '海外在途仓'
END AS '仓库类型',
CASE
WHEN a.BillType != 5 THEN b.WareHouseName
ELSE c1.WareHouseName
END 入 库 仓 库,
CASE
WHEN a.BillType = 5 THEN b.WareHouseName
ELSE ISNULL(c.WareHouseName, '')
END 发 货 仓 库,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
CASE
iib.OperateType
WHEN 1 THEN '其他入库'
WHEN 2 THEN '物流退回入库'
WHEN 3 THEN '备品入库'
WHEN 4 THEN '客户退货入库'
WHEN 9 THEN '第三方仓入库'
WHEN 10 THEN '换货入库'
WHEN 11 THEN '拍照归还入库'
WHEN 12 THEN '拍卖归还入库'
WHEN 13 THEN '重新质检入库'
WHEN 14 THEN '系统操作失误入库'
WHEN 15 THEN '发货仓多发入库'
WHEN 16 THEN '本地仓发错入库'
WHEN 17 THEN '办公用品入库'
WHEN 25 THEN '物流丢包'
WHEN 27 THEN '收货仓少收入库'
WHEN 29 THEN '盘盈入库'
WHEN 46 THEN '收货仓丢包'
WHEN 34 THEN 'FBA库存找到'
WHEN 35 THEN 'FBA库存丢失'
WHEN 36 THEN 'FBA库存报废'
WHEN 37 THEN '从暂存仓移入'
WHEN 38 THEN '移出至暂存仓'
WHEN 39 THEN '盘点移入'
WHEN 40 THEN '盘点移出'
WHEN 41 THEN 'FBA仓客户退货入库'
WHEN 43 THEN '其他入库报关入库'
WHEN 45 THEN '海外仓客户退件入库'
WHEN 5 THEN '其他出库'
WHEN 6 THEN '呆滞品退货出库'
WHEN 7 THEN '内部销售出库'
WHEN 8 THEN '销毁出库'
WHEN 18 THEN '换货出库'
WHEN 19 THEN '办公用品出库'
WHEN 20 THEN '拍照出库'
WHEN 21 THEN '拍卖出库'
WHEN 22 THEN '采购退货出库'
WHEN 23 THEN '质检出库'
WHEN 24 THEN '发货仓少发出库'
WHEN 26 THEN '收货仓多收出库'
WHEN 28 THEN '包材出库'
WHEN 30 THEN '盘亏出库'
WHEN 31 THEN '未称重出库'
WHEN 32 THEN '加工原料出库'
WHEN 33 THEN '物流丢包'
WHEN 34 THEN 'FBA库存找到'
WHEN 35 THEN 'FBA库存丢失'
WHEN 36 THEN 'FBA库存报废'
WHEN 37 THEN '从暂存仓移入'
WHEN 38 THEN '移出至暂存仓'
WHEN 39 THEN '盘点移入'
WHEN 40 THEN '盘点移出'
WHEN 42 THEN '其他出库报关出库'
WHEN 44 THEN '物流退回出库'
WHEN 47 then '在途仓收货调整'
WHEN 48 THEN '换标入库'
WHEN 49 THEN '换标出库'
WHEN 50 THEN '其他入库_数据换标入库'
WHEN 51 THEN '其他入库_业务换标入库'
WHEN 52 THEN '其他出库_数据换标出库'
WHEN 53 THEN '其他出库_业务换标出库'
WHEN 54 THEN '调拨收货调整'
ELSE ''
END 二 级 单 据 类 型,
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
ISNULL(pb.BrandName, '') BrandName,
a.UnitPrice,
a.BuyPrice,
p.ProductType,
a.SKU
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN (
select top 0 CustomerID,
AllocationNumber,
InWareHouseID,
OutWareHouseID
FROM
dbo.RB_Inventory_AllocationBill (NOLOCK)
) ia ON ia.CustomerID = a.CustomerID
AND a.OriginBillNumber = ia.AllocationNumber
LEFT JOIN (
select top 0 a.CustomerID,
a.OrderListID,
b.AllocationNumber,
b.InWareHouseID,
b.OutWareHouseID
FROM
RB_Inventory_AllocationDetailBill a
INNER JOIN dbo.RB_Inventory_AllocationBill b ON b.CustomerID = a.CustomerID
AND a.AllocationBillID = b.ID
WHERE
a.OrderListID > 0
AND a.Status < 3
) ial ON ial.CustomerID = a.CustomerID
AND ial.OrderListID = a.OrderListID
AND ial.AllocationNumber = a.OriginBillNumber
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND b.ID = a.WareHouseID
LEFT JOIN dbo.RB_WareHouse (NOLOCK) w ON w.CustomerID = a.CustomerID
AND b.AutonomousWareHouseID = w.ID
AND b.WareHouseType = 81
LEFT JOIN dbo.RB_Inventory_InOutBallance (NOLOCK) iib ON iib.CustomerID = a.CustomerID
AND a.OriginBillNumber = iib.BallanceNumber
AND iib.SKU = a.SKU
AND a.RealtionId = iib.ID
AND a.BillType IN (1, 3)
LEFT JOIN dbo.RB_WareHouse (NOLOCK) c ON c.CustomerID = ia.CustomerID
AND c.ID = ISNULL(ial.OutWareHouseID, ia.OutWareHouseID)
AND a.BillType = 4
LEFT JOIN dbo.RB_WareHouse (NOLOCK) c1 ON c1.CustomerID = ia.CustomerID
AND c1.ID = ISNULL(ial.InWareHouseID, ia.InWareHouseID)
AND a.BillType = 5
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
LEFT JOIN dbo.RB_Product_Brand pb ON pb.ID = p.BrandID
AND pb.CustomerID = a.CustomerID
WHERE
a.CustomerID = @CustomerID
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType = 81
) t
GROUP BY
t.出 入 库 类 型,
t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.发 货 仓 库,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.Sku,
t.BrandName;---------虚拟仓---------
select top 0 t.出 入 库 类 型,
t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.发 货 仓 库,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
SUM(t.OperateNum) AS '数量',
SUM(t.金 额) AS '核算金额',
SUM(t.管 理 帐 金 额) AS '管理帐金额',
SUM(t.[金额（销单价/供货价）]) '金额（销单价/供货价）',
SUM(t.报 关 金 额) AS '报关金额',
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
t.Sku
FROM
(
select top 0 CONVERT(NVARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
WHEN a.BillType IN (0, 1, 4, 6) THEN '入库'
ELSE '出库'
END 出 入 库 类 型,
CASE
WHEN b.WareHouseType = 1 THEN '本地仓'
WHEN b.WareHouseType = 3 THEN 'FBA仓'
WHEN a.BillType IN (75, 76) THEN '报关虚拟仓'
ELSE '海外仓'
END AS '仓库类型',
CASE
WHEN a.BillType != 5 THEN b.WareHouseName
ELSE c1.WareHouseName
END 入 库 仓 库,
CASE
WHEN a.BillType = 5 THEN b.WareHouseName
ELSE ISNULL(c.WareHouseName, '')
END 发 货 仓 库,
CASE
a.BillType
WHEN 0 THEN '采购入库单'
WHEN 1 THEN '其他入库单'
WHEN 2 THEN '销售出库单'
WHEN 3 THEN '其他出库单'
WHEN 4 THEN '调拨入库单'
WHEN 5 THEN '调拨出库单'
WHEN 6 THEN '盘盈单'
WHEN 7 THEN '盘亏单'
WHEN 8 THEN '退供应商出库单'
END '一级单据类型',
CASE
iib.OperateType
WHEN 1 THEN '其他入库'
WHEN 2 THEN '物流退回入库'
WHEN 3 THEN '备品入库'
WHEN 4 THEN '客户退货入库'
WHEN 9 THEN '第三方仓入库'
WHEN 10 THEN '换货入库'
WHEN 11 THEN '拍照归还入库'
WHEN 12 THEN '拍卖归还入库'
WHEN 13 THEN '重新质检入库'
WHEN 14 THEN '系统操作失误入库'
WHEN 15 THEN '发货仓多发入库'
WHEN 16 THEN '本地仓发错入库'
WHEN 17 THEN '办公用品入库'
WHEN 25 THEN '物流丢包'
WHEN 27 THEN '收货仓少收入库'
WHEN 29 THEN '盘盈入库'
WHEN 46 THEN '收货仓丢包'
WHEN 34 THEN 'FBA库存找到'
WHEN 35 THEN 'FBA库存丢失'
WHEN 36 THEN 'FBA库存报废'
WHEN 37 THEN '从暂存仓移入'
WHEN 38 THEN '移出至暂存仓'
WHEN 39 THEN '盘点移入'
WHEN 40 THEN '盘点移出'
WHEN 41 THEN 'FBA仓客户退货入库'
WHEN 43 THEN '其他入库报关入库'
WHEN 45 THEN '海外仓客户退件入库'
WHEN 5 THEN '其他出库'
WHEN 6 THEN '呆滞品退货出库'
WHEN 7 THEN '内部销售出库'
WHEN 8 THEN '销毁出库'
WHEN 18 THEN '换货出库'
WHEN 19 THEN '办公用品出库'
WHEN 20 THEN '拍照出库'
WHEN 21 THEN '拍卖出库'
WHEN 22 THEN '采购退货出库'
WHEN 23 THEN '质检出库'
WHEN 24 THEN '发货仓少发出库'
WHEN 26 THEN '收货仓多收出库'
WHEN 28 THEN '包材出库'
WHEN 30 THEN '盘亏出库'
WHEN 31 THEN '未称重出库'
WHEN 32 THEN '加工原料出库'
WHEN 33 THEN '物流丢包'
WHEN 34 THEN 'FBA库存找到'
WHEN 35 THEN 'FBA库存丢失'
WHEN 36 THEN 'FBA库存报废'
WHEN 37 THEN '从暂存仓移入'
WHEN 38 THEN '移出至暂存仓'
WHEN 39 THEN '盘点移入'
WHEN 40 THEN '盘点移出'
WHEN 42 THEN '其他出库报关出库'
WHEN 44 THEN '物流退回出库'
WHEN 47 then '在途仓收货调整'
WHEN 48 THEN '换标入库'
WHEN 49 THEN '换标出库'
WHEN 50 THEN '其他入库_数据换标入库'
WHEN 51 THEN '其他入库_业务换标入库'
WHEN 52 THEN '其他出库_数据换标出库'
WHEN 53 THEN '其他出库_业务换标出库'
WHEN 54 THEN '调拨收货调整'
ELSE ''
END 二 级 单 据 类 型,
a.OperateNum,
a.OperateNum * ISNULL(a.UnitPrice, 0) 金 额,
a.OperateNum * ISNULL(a.MUnitPrice, 0) AS '管理帐金额',
a.OperateNum * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
) AS '金额（销单价/供货价）',
a.OperateNum * ISNULL(a.DecalrePrice, 0) 报 关 金 额,
a.UnitPrice,
a.BuyPrice,
p.ProductType,
a.SKU
FROM
dbo.RB_Inventory_DetailLog (NOLOCK) a
LEFT JOIN (
select top 0 CustomerID,
AllocationNumber,
InWareHouseID,
OutWareHouseID
FROM
dbo.RB_Inventory_AllocationBill (NOLOCK)
) ia ON ia.CustomerID = a.CustomerID
AND a.OriginBillNumber = ia.AllocationNumber
LEFT JOIN (
select top 0 a.CustomerID,
a.OrderListID,
b.AllocationNumber,
b.InWareHouseID,
b.OutWareHouseID
FROM
RB_Inventory_AllocationDetailBill a
INNER JOIN dbo.RB_Inventory_AllocationBill b ON b.CustomerID = a.CustomerID
AND a.AllocationBillID = b.ID
WHERE
a.OrderListID > 0
AND a.Status < 3
) ial ON ial.CustomerID = a.CustomerID
AND ial.OrderListID = a.OrderListID
AND ial.AllocationNumber = a.OriginBillNumber
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND b.ID = a.WareHouseID
LEFT JOIN dbo.RB_Inventory_InOutBallance (NOLOCK) iib ON iib.CustomerID = a.CustomerID
AND a.OriginBillNumber = iib.BallanceNumber
AND iib.SKU = a.SKU
AND a.RealtionId = iib.ID
AND a.BillType IN (1, 3)
LEFT JOIN dbo.RB_WareHouse (NOLOCK) c ON c.CustomerID = ia.CustomerID
AND c.ID = ISNULL(ial.OutWareHouseID, ia.OutWareHouseID)
AND a.BillType = 4
LEFT JOIN dbo.RB_WareHouse (NOLOCK) c1 ON c1.CustomerID = ia.CustomerID
AND c1.ID = ISNULL(ial.InWareHouseID, ia.InWareHouseID)
AND a.BillType = 5
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
WHERE
a.CustomerID = @CustomerID
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime)
AND a.OperateNum != 0
AND b.WareHouseType IN (75, 76)
) t
GROUP BY
t.出 入 库 类 型,
t.月 份,
t.仓 库 类 型,
t.入 库 仓 库,
t.发 货 仓 库,
t.一 级 单 据 类 型,
t.二 级 单 据 类 型,
CASE
t.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
t.Sku;--成本调整单
select top 0 CONVERT(VARCHAR(6), a.OperateTime, 112) AS '月份',
CASE
a.IsManage
WHEN 0 THEN '税务帐'
WHEN 1 THEN '管理帐'
ELSE ''
END AS '账务类型',
CASE
WHEN b.WareHouseType = 1
AND b.IsTaxFree = 1 THEN '本地退税仓'
WHEN b.WareHouseType = 1
AND ISNULL(b.IsTaxFree, 0) = 0 THEN '本地非退税仓'
WHEN ISNULL(iw.InventoryWareHouseType, b.WareHouseType) = 3 THEN '亚马逊FBA仓'
WHEN b.WareHouseType = 81 THEN '在途仓'
WHEN b.WareHouseType IN (75, 76) THEN '虚拟仓'
ELSE '海外仓'
END AS '仓库类型',
ISNULL(b.WareHouseName, iw.InventoryWarehouseName) 仓 库,
'成本调整单' AS '单据类型',
a.SKU,
SUM(a.OperateNum) AS 数 量,
SUM(a.OperateNum * (a.CurrPrice - a.LastPrice)) AS 金 额,
SUM(
ISNULL(a.OperateNum, 0) * (
CASE
WHEN ISNULL(p.LastBuyPrice, 0) = 0 THEN ISNULL(p.LastSupplierPrice, 0)
ELSE ISNULL(p.LastBuyPrice, 0)
END
)
) AS '金额（销单价/供货价）',
CASE
p.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END 产 品 类 型,
a.Remark 调 整 类 型
FROM
RB_Inventory_Cost_Accounting (NOLOCK) a
LEFT JOIN dbo.RB_WareHouse (NOLOCK) b ON b.CustomerID = a.CustomerID
AND a.WareHouseID = b.ID
LEFT JOIN dbo.RB_Inventory_WareHouse iw (NOLOCK) ON iw.CustomerID = a.CustomerID
AND a.WareHouseID = iw.ID
LEFT JOIN dbo.RB_Product (NOLOCK) p ON p.CustomerID = a.CustomerID
AND p.SKU = a.SKU
WHERE
a.CustomerID = @CustomerID
AND a.CurrPrice != a.LastPrice
AND a.OperateTime >= @starttime
AND a.OperateTime < DATEADD(SECOND, 1, @EndTime) --AND b.WareHouseType != 81
GROUP BY
CONVERT(VARCHAR(6), a.OperateTime, 112),
CASE
a.IsManage
WHEN 0 THEN '税务帐'
WHEN 1 THEN '管理帐'
ELSE ''
END,
CASE
WHEN b.WareHouseType = 1
AND b.IsTaxFree = 1 THEN '本地退税仓'
WHEN b.WareHouseType = 1
AND ISNULL(b.IsTaxFree, 0) = 0 THEN '本地非退税仓'
WHEN ISNULL(iw.InventoryWareHouseType, b.WareHouseType) = 3 THEN '亚马逊FBA仓'
WHEN b.WareHouseType = 81 THEN '在途仓'
WHEN b.WareHouseType IN (75, 76) THEN '虚拟仓'
ELSE '海外仓'
END,
ISNULL(b.WareHouseName, iw.InventoryWarehouseName),
CASE
p.ProductType
WHEN 1 THEN '采购包材'
WHEN 2 THEN '物流包材'
ELSE '普通产品'
END,
a.SKU,
a.Remark
PARAMS:@starttime = null ,@endtime = null ,@CustomerId = 0 ,
MESSAGE:Incorrect syntax near '名'.
Incorrect syntax near '产'.
Incorrect syntax near '额'.
Incorrect syntax near '额'.
Incorrect syntax near '额'.
Incorrect syntax near '类'.
Incorrect syntax near '产'.
Incorrect syntax near '库'.
Incorrect syntax near 'ia'.
Incorrect syntax near 'ial'.
Incorrect syntax near '类'.
Incorrect syntax near '产'.
Incorrect syntax near '库'.
Incorrect syntax near 'ia'.
Incorrect syntax near 'ial'.
Incorrect syntax near '份'.
Incorrect syntax near '产'.
Incorrect syntax near '类'.
Incorrect syntax near '产'.
Incorrect syntax near '库'.
Incorrect syntax near '二'.
Incorrect syntax near '类'.
Incorrect syntax near '产'.
Incorrect syntax near '库'.
Incorrect syntax near '类'.
Incorrect syntax near '产'.
Incorrect syntax near '库'.
Incorrect syntax near 't2'.
Incorrect syntax near '库'.
Incorrect syntax near '产'.
Incorrect syntax near '入'.
Incorrect syntax near '入'.
Incorrect syntax near '发'.
Incorrect syntax near '二'.
Incorrect syntax near 'ia'.
Incorrect syntax near 'ial'.
Incorrect syntax near '库'.
Incorrect syntax near '产'.
Incorrect syntax near '入'.
Incorrect syntax near '入'.
Incorrect syntax near '发'.
Incorrect syntax near '二'.
Incorrect syntax near 'ia'.
Incorrect syntax near 'ial'.
Incorrect syntax near '库'.
Incorrect syntax near '产'.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DALExtend.RB_CustomReportExtend.GetSheetFieldsDr(String sqlContent, List1 sqlParameters)
在 Biz.Irobotbox.ReportCentre.CustomReportService.CheckSqlAndGetFields(String sqlContent, List`1 paramList)
在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.CheckSqlAndGetFields()
在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.Page_Load(Object sender, EventArgs e)
在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
在 System.Web.UI.Control.OnLoad(EventArgs e)
在 System.Web.UI.Control.LoadRecursive()
在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
在 System.Web.UI.Page.ProcessRequest()
在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
在 System.Web.UI.Page.ProcessRequest(HttpContext context)
在 ASP.irobotbox_reportcentre_customreportedit_aspx.ProcessRequest(HttpContext context)
在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
[期望]
158数据分析组自改自定义报告，调试错误
已处理好