--预置SN XY CG商务伙伴
IF NOT EXISTS (SELECT 1 FROM t_bd_bizpartner WHERE FID = 1125316232338315264)
INSERT INTO t_bd_bizpartner(FTYPE,FADMINDIVISION,FCOUNTRYID,FMASTERID,FLOGO,FISSUPPLIER,FCREATETIME,FPARTNERROLE,FENABLE,FFAX,FYZJID,FESTABLISHDATE,FIDNO,FTXREGISTERNO,FPOSTALCODE,FDISABLERID,FID,FBIZREGISTERNO,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FINTERNALCOMPANYID,FPHONE,FMODIFIERID,FMODIFYTIME,FSOCIETYCREDITCODE,FCREATORID,FORGCODE,FISCUSTOMER) VALUES ('1',' ',0,1125316232338315264,' ','0',{ts'2021-04-02  15:22:10'},',1,','1',' ','0',NULL,' ',' ',' ',0,1125316232338315264,' ',NULL,' ','C','SN',0,' ',13466739,{ts'2021-04-02  15:22:28'},' ',13466739,' ','0'); 

DELETE FROM t_bd_bizpartner_l WHERE FPKID = '1I79H3UKZ31M';
INSERT INTO t_bd_bizpartner_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1125316232338315264,' ','1I79H3UKZ31M','zh_CN',' ',' ','苏宁易购',' ',' ','苏宁易购',' '); 
DELETE FROM t_bd_bizpartner_l WHERE FPKID = '1I79H3UKZ31N';
INSERT INTO t_bd_bizpartner_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1125316232338315264,' ','1I79H3UKZ31N','zh_TW',' ',' ','蘇寧易購',' ',' ','蘇寧易購',' '); 

IF NOT EXISTS (SELECT 1 FROM t_bd_bizpartner WHERE FID = 1125318051374405632)
INSERT INTO t_bd_bizpartner(FTYPE,FADMINDIVISION,FCOUNTRYID,FMASTERID,FLOGO,FISSUPPLIER,FCREATETIME,FPARTNERROLE,FENABLE,FFAX,FYZJID,FESTABLISHDATE,FIDNO,FTXREGISTERNO,FPOSTALCODE,FDISABLERID,FID,FBIZREGISTERNO,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FINTERNALCOMPANYID,FPHONE,FMODIFIERID,FMODIFYTIME,FSOCIETYCREDITCODE,FCREATORID,FORGCODE,FISCUSTOMER) VALUES ('1',' ',0,1125318051374405632,' ','0',{ts'2021-04-02  15:25:50'},',1,','1',' ','0',NULL,' ',' ',' ',0,1125318051374405632,' ',NULL,' ','C','XY',0,' ',13466739,{ts'2021-04-02  15:26:05'},' ',13466739,' ','0'); 

DELETE FROM t_bd_bizpartner_l WHERE FPKID = '1I79UCSW6NHP';
INSERT INTO t_bd_bizpartner_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1125318051374405632,' ','1I79UCSW6NHP','zh_CN',' ',' ','西域商城',' ',' ','西域商城',' '); 
DELETE FROM t_bd_bizpartner_l WHERE FPKID = '1I79UCSW6NHQ';
INSERT INTO t_bd_bizpartner_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1125318051374405632,' ','1I79UCSW6NHQ','zh_TW',' ',' ','西域商城',' ',' ','西域商城',' '); 

IF NOT EXISTS (SELECT 1 FROM t_bd_bizpartner WHERE FID = 1125318646260930560)
INSERT INTO t_bd_bizpartner(FTYPE,FADMINDIVISION,FCOUNTRYID,FMASTERID,FLOGO,FISSUPPLIER,FCREATETIME,FPARTNERROLE,FENABLE,FFAX,FYZJID,FESTABLISHDATE,FIDNO,FTXREGISTERNO,FPOSTALCODE,FDISABLERID,FID,FBIZREGISTERNO,FDISABLEDATE,FURL,FSTATUS,FNUMBER,FINTERNALCOMPANYID,FPHONE,FMODIFIERID,FMODIFYTIME,FSOCIETYCREDITCODE,FCREATORID,FORGCODE,FISCUSTOMER) VALUES ('1',' ',0,1125318646260930560,' ','0',{ts'2021-04-02  15:27:06'},',1,','1',' ','0',NULL,' ',' ',' ',0,1125318646260930560,' ',NULL,' ','C','CG',0,' ',13466739,{ts'2021-04-02  15:27:16'},' ',13466739,' ','0'); 

DELETE FROM t_bd_bizpartner_l WHERE FPKID = '1I79YPV759AC';
INSERT INTO t_bd_bizpartner_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1125318646260930560,' ','1I79YPV759AC','zh_CN',' ',' ','晨光商城',' ',' ','晨光商城',' '); 
DELETE FROM t_bd_bizpartner_l WHERE FPKID = '1I79YPV759AD';
INSERT INTO t_bd_bizpartner_l(FID,FREGCAPITAL,FPKID,FLOCALEID,FBUSINESSTERM,FLINKMAN,FSIMPLENAME,FADDRESS,FBUSINESSSCOPE,FNAME,FARTIFICIALPERSON) VALUES (1125318646260930560,' ','1I79YPV759AD','zh_TW',' ',' ','晨光商城',' ',' ','晨光商城',' '); 

-- 修改SN XY CG 预置商务伙伴
update t_bd_supplier  set fbizpartnerid = '1125316232338315264' where fid = 1125316232338315264;

update t_bd_supplier  set fbizpartnerid = '1125318051374405632' where fid = 1125318051374405632;

update t_bd_supplier  set fbizpartnerid = '1125318646260930560' where fid = 1125318646260930560;

