天心ERP 采购单刷单号 增加工厂订单编号，供应商编号

--长辉采购单刷单
--@mp  生产需求分析单号
ALTER PROCEDURE [dbo].[am_update_po_xb]
	@mp VARCHAR(20)
AS
BEGIN
-- 修改请购量
UPDATE 	TF_MP2
SET 
QTY=CONVERT(INT,QTY_AD)
WHERE
	MP_NO =@mp
AND CUS_NO !=''

-- 刷单号
UPDATE 	TF_MP2
SET 
QTY=CONVERT(INT,QTY),
WH='CH04',
PO_NO = 'PO'+SO_NO+'-'+CONVERT(VARCHAR,CUS_NO)+CONVERT(VARCHAR,ITM)
WHERE
	MP_NO = @mp
AND CUS_NO !=''
AND QTY IS NOT NULL

--塑胶采购
UPDATE 	TF_MP2
SET  SAL_NO='CHCG01'
WHERE
	MP_NO = @mp
AND SAL_NO='CG06'
AND QTY IS NOT NULL


--电器采购
UPDATE 	TF_MP2
SET  SAL_NO='CHCG02'
WHERE
	MP_NO = @mp
AND SAL_NO='CG05'
AND QTY IS NOT NULL

--五金采购
UPDATE 	TF_MP2
SET  SAL_NO='CHCG03'
WHERE
	MP_NO = @mp
AND SAL_NO='CG07'
AND QTY IS NOT NULL

END