--zalshaojun_li 工艺路线 基础数据管控策略


IF NOT EXISTS (SELECT 1 FROM T_BD_DefaultCtrlStrategy WHERE FBASEDATAID = 'pdm_route') 
insert into T_BD_DefaultCtrlStrategy (FID, FNUMBER, FBASEDATAID, FCTRLVIEW, FDATATYPE, FDEFAULTMANAGESTRATEGY, FDEFAULTCTRLSTRATEGY, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FAPPSYSTEMID, FMASTERID, FPLUGIN)
values (895536703786296320, ' ', 'pdm_route', 4, '2', '1', '7', '0', '1', 'A', 878939940484941824, {ts'2020-05-20 14:31:04'}, 878939940484941824, {ts'2020-05-20 14:31:34'}, 0, null, '064+RMU5W7LE', 895536703786296320, ' ');


-- 带组织基础资料要加管控策略 全局共享  BOM版本
--zhaohui_zeng  2019-10-09
IF NOT EXISTS (SELECT 1 FROM T_BD_DefaultCtrlStrategy WHERE FBASEDATAID = 'bd_bomversion') 
insert into T_BD_DefaultCtrlStrategy (FID, FNUMBER, FBASEDATAID, FCTRLVIEW, FDATATYPE, FDEFAULTMANAGESTRATEGY, FDEFAULTCTRLSTRATEGY, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FAPPSYSTEMID, FMASTERID, FPLUGIN)
values ('744144670841540608', ' ', 'bd_bomversion', '4', '2', '1', '5', '0', '1', 'A', '741730085853316096', {ts'2019-10-26 17:34:02'}, '741730085853316096', {ts'2019-10-26 17:34:02'}, '0', null, '0efa1992000000ac', '744144670841540608', ' ');


-- 制造BOM基础数据管控策略
-- 郭凯斌
-- 2019-12-07
IF NOT EXISTS (SELECT 1 FROM T_BD_DefaultCtrlStrategy WHERE FBASEDATAID = 'pdm_mftbom') 
INSERT INTO T_BD_DefaultCtrlStrategy (FID, FNUMBER, FBASEDATAID, FCTRLVIEW, FDATATYPE, FDEFAULTMANAGESTRATEGY, FDEFAULTCTRLSTRATEGY, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FAPPSYSTEMID, FMASTERID, FPLUGIN)
VALUES (899880330662640640, ' ', 'pdm_mftbom', 4, '2', '1', '5', '0', '1', 'A', 1, {ts'2020-05-17 16:13:00'}, 1, {ts'2020-05-17 16:13:00'}, 0, null, '064+RMU5W7LE', 899880330662640640, ' ');
		
-- ECN版本基础数据管控策略
-- 郭凯斌
-- 2019-12-09
IF NOT EXISTS (SELECT 1 FROM T_BD_DefaultCtrlStrategy WHERE FBASEDATAID = 'pdm_ecnversion') 
INSERT INTO T_BD_DefaultCtrlStrategy (FID, FNUMBER, FBASEDATAID, FCTRLVIEW, FDATATYPE, FDEFAULTMANAGESTRATEGY, FDEFAULTCTRLSTRATEGY, FISSYSTEM, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FAPPSYSTEMID, FMASTERID, FPLUGIN)
VALUES (777418905407933440, ' ', 'pdm_ecnversion', 4, '2', '1', '5', '0', '1', 'A', 1, {ts'2019-12-09 15:14:57'}, 1, {ts'2019-12-09 15:14:57'}, 0, null, '064+RMU5W7LE', 777418905407933440, ' ');
