1.工厂直发采购管理

页面添加仓库

搜索：

搜索清空：

导出列表：

导出明细：

2.有货先交：

操作前：

操作：

操作后：

3.确认质检

操作：

操作后：

库存：

4.回仓：

工厂直发库存：

5.确认质检配货

操作后：

6.工厂直发库存管理

页面添加仓库

搜索：

搜索清空：

导出列表：

7.工厂直发发货管理

页面添加仓库

搜索：

清空：

导出列表：

导出明细：

8.获取货齐时间

操作后:

9.配货

操作前：

库存：

操作后：

库存：

9.取消配货

操作前：

库存：

操作后：

库存：

10.确认提货

11.有货先发

操作前：

操作后：

12.发货管理列表添加sku显示

13.历史数据修复语句：根据客户id

--采购单
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Procurement_List a  WITH(NOLOCK)  INNER JOIN RB_Procurement_list b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.P_Code=b.P_Code WHERE a.CustomerID=2147
--采购单详情
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Procurement_Detail a WITH(NOLOCK)   INNER JOIN RB_Procurement_list b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.P_Code=b.P_Code WHERE a.CustomerID=2147
--采购单日志
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Procurement_Log a  WITH(NOLOCK)  INNER JOIN RB_Factory_Procurement_List b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.Single_NO=b.Single_NO AND a.DeliveryBatchNo=b.DeliveryBatchNo WHERE a.CustomerID=2147
--库存的质检记录
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Inventory_InCheck_Log a  WITH(NOLOCK)  INNER JOIN RB_Factory_Procurement_Detail b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.SupplierID=b.SupplierID AND a.SKU=b.SKU AND a.DeliveryBatchNo=b.DeliveryBatchNo WHERE a.CustomerID=2147
--库存数据
UPDATE a SET a.WareHouseID=b.WareHouseID  FROM dbo.RB_Factory_Inventory a WITH(NOLOCK) 
INNER JOIN( SELECT CustomerID,SupplierID,WareHouseID,SKU ,SUM(PutInNum-OutNum) AS Num from RB_Factory_Inventory_InCheck_Log   WITH(NOLOCK) WHERE (PutInNum-OutNum)>0  GROUP BY CustomerID,SupplierID,WareHouseID,SKU) b
 ON b.CustomerID = a.CustomerID AND a.SKU=b.SKU AND a.SupplierID=b.SupplierID WHERE a.CustomerID=2147
--库存记录
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Inventory_Log a  WITH(NOLOCK)  INNER JOIN RB_Factory_Inventory b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.SupplierID=b.SupplierID AND a.SKU=b.SKU WHERE a.CustomerID=2147
--发货管理
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Shipments_List a  WITH(NOLOCK)  INNER JOIN RB_OrderInfo b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.OrderCode=b.OrderCode WHERE a.CustomerID=2147
---发货详情
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Shipments_Detail a  WITH(NOLOCK)  INNER JOIN RB_OrderInfo b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.OrderCode=b.OrderCode WHERE a.CustomerID=2147
--发货日志
UPDATE a SET a.WareHouseID=b.WareHouseID FROM  RB_Factory_Shipments_Log a  WITH(NOLOCK)  INNER JOIN RB_Factory_Shipments_List b WITH(NOLOCK) 
ON a.CustomerID=b.CustomerID AND a.ShipmentsNo=b.ShipmentsNo AND a.OrderCode=b.OrderCode WHERE a.CustomerID=2147