天心sunlike erp 生产需求分析 按生产订单号生成单号

-- 冲压/托工生产需求分析刷单
ALTER PROCEDURE [dbo].[am_update_mp_xb_mo]
	 @mp varchar(30),
-- 成品仓库
	 @ck_01 VARCHAR(10),
-- 总装车间 编号
   @DEP_03 VARCHAR(10),
-- 部装 编号
   @DEP_0309 VARCHAR(10),
-- 04仓
	 @ck_04 VARCHAR(10),
-- 0801仓  开料
	 @DEP_0801 VARCHAR(10),
-- 0802仓  冲压
	 @DEP_0802 VARCHAR(10),
-- 05仓
	 @ck_05 VARCHAR(10),
-- 开料仓
	 @ck_18 VARCHAR(10),
-- 喷涂仓
	 @ck_32 VARCHAR(10)
AS
BEGIN
	
--0000 bug
UPDATE
	TF_MP3
SET
DEP=@DEP_03,ML_BY_MM='F',WH=@ck_01
WHERE
	MP_NO = @mp AND DEP='00000000' AND ITM='1' ;

UPDATE
	TF_MP3
SET
DEP=@DEP_03,ML_BY_MM='F',WH=@ck_01
WHERE
	MP_NO = @mp AND DEP=@DEP_03 AND ITM='1' ;


--部装BUG
UPDATE
	TF_MP3
SET
DEP=@DEP_0309,ML_BY_MM='F',WH=@ck_04
WHERE
	MP_NO = @mp AND DEP='00000000'  ;


-- 生产部门
UPDATE
	TF_MP3
SET
DEP=@DEP_03,ML_BY_MM='F'
WHERE
	MP_NO = @mp AND DEP='03' ;

-- 部装同一0309
UPDATE
	TF_MP3
SET
DEP=@DEP_0309,ML_BY_MM='F',WH=@ck_04
WHERE
	MP_NO = @mp AND DEP LIKE '%0309%' ;


-- MO  车间
UPDATE
	TF_MP3
SET
MO_NO='M'+SO_NO+'-'+DEP+CONVERT(VARCHAR,ITM)
--MO_NO=DEP
WHERE
	MP_NO = @mp AND TW_ID='';

-- 开料  冲压部门
UPDATE
	TF_MP3
SET
DEP='CH0801'
--MO_NO=DEP
WHERE
	MP_NO = @mp AND TW_ID='' AND DEP LIKE '%0801%';

UPDATE
	TF_MP3
SET
DEP='CH0802'
--MO_NO=DEP
WHERE
	MP_NO = @mp AND TW_ID='' AND DEP LIKE '%0802%';

-- MO  开料
UPDATE
	TF_MP3
SET
MO_NO='M'+SO_NO+'-'+DEP++CONVERT(VARCHAR,ITM),
ML_BY_MM='T',
WH='CH04'
WHERE
	MP_NO = @mp AND TW_ID='' AND DEP IN('0801','CH0801');

-- MO  冲压
UPDATE
	TF_MP3
SET
MO_NO='M'+SO_NO+'-'+DEP+CONVERT(VARCHAR,ITM),
ML_BY_MM='T',
WH=@ck_05
WHERE
	MP_NO = @mp AND TW_ID='' AND DEP IN('0802','CH0802','CH19');


-- TW
UPDATE
	TF_MP3
SET
MO_NO='',
ML_BY_MM='F',
TW_ID='1',
WH=@ck_32
WHERE
	MP_NO = @mp AND DEP IN ('09','CH09');

UPDATE
	TF_MP3
SET
MO_NO='TW'+SO_NO+'-'+CUS_NO+CONVERT(VARCHAR,ITM),
ML_BY_MM='F',
WH=@ck_32
WHERE
	MP_NO = @mp AND TW_ID=1 
AND CUS_NO !='';




-- 整数BUG

UPDATE
	TF_MP3
SET QTY=CONVERT(INT,QTY)
--ML_BY_MM='F'
WHERE
	MP_NO =@mp;

END