jsgkj/gkjsjy/docs/数据交换平台/堆场+设施设备.txt

//堆场
insert into GK_BASIC_JSJY_JYR_DC(id,szd,szgq,ssjyr,ssmt,dcmc,scydcyt,dczmj,dczrl,jzxmj,jzxdcdcnl,wxpxdcmj,wxpxdcdcnl,jd,wd,jtjgisdyidh,wxpdc,zwdcyt,create_date_time,update_date_time,record_status,create_user,update_user,
szgk,ssgkglbm,aqid)(select sys_guid(),b.szd,b.id  end,a.id,'',c.dcmc,'',c.dczmj,c.dczrl,c.jzxmj,c.jzxdcdcnl,c.wxpxdcmj,c.wxpxdcdcnl,c.jd,c.wd,c.jtjgisdyidh,case when c. wxpdc='Y' then '201' else '202' end,c.zwdcyt,systimestamp,systimestamp,1,'aq','aq',
b.szgk,'',c.id  from GK_BASIC_JSJY_JYR a,GK_BASIC_JSJY_GK_GQ b,aq.T_YJPT_JYRXX_DC c where c.record_status!=9 and c.SZGQ=b.aqid and a.aqid=c.QYMC)
//码头同步操作
update GK_BASIC_JSJY_JYR_DC t set t.ssmt=(select b.id from aq.t_yjpt_jyrxx_dc a,gk_basic_jsjy_jyr_mt b where a.mtmc=b.aqid and a.id=t.aqid)




//设施设备
insert into GK_BASIC_JSJY_JYR_SSSB(id,ssmc,ssjyr,tbr,lxdh,szd,szgq,yjfl,ejfl,ggxh,sldw,sl,yxq,cfcs,bz,create_user,update_user,create_date_time,update_date_time,record_status,ssgkglbm,szgk,aqid)
(select sys_guid(),c.ssmc,a.id,c.tbr,c.lxdh,b.szd,b.id,'','',c.ggxh,c.sldw,c.sl,c.yxq,c.cfcs,c.bz,'aq','aq',systimestamp,systimestamp,1,'',b.szgk,c.id from GK_BASIC_JSJY_JYR a,GK_BASIC_JSJY_GK_GQ b,aq.T_YJPT_GKSSSB c 
where c.record_status!=9 and c.SZGQ=b.aqid and a.aqid=c.QYMC)
//一级分类同步操作
update GK_BASIC_JSJY_JYR_SSSB t set t.yjfl=(select b.id from aq.T_YJPT_GKSSSB a,GK_OPERATION_JSJY_CODE b where to_char(a.yjfl)=b.yjptid and t.aqid=a.id)
//二级分类同步操作
update GK_BASIC_JSJY_JYR_SSSB t set t.ejfl=(select b.id from aq.T_YJPT_GKSSSB a,GK_OPERATION_JSJY_CODE b where to_char(a.ejfl)=b.yjptid and t.aqid=a.id)



//在安全库查询一级分类数据字典
select * from T_YJPT_GGDM t where t.groupcode='AQSS' 
一级分类：码头及库场安全设施   港口消防安全设施 港口安全标志 港口个体防护设备设施 危险货物码头及库场安全设施 客滚码头及库场安全设施 集装箱码头及库场安全设施 件杂货、散杂货码头及库场安全设施 
//在安全库查询二级分类数据字典
select * from T_YJPT_GGDM t where t.groupcode='AQSS.EJFL' 
二级分类：防冲安全设施 防撞安全设施 导、助航安全设施 系船安全设施 码头附属安全设施 库场安全设施 防风装置 防雷、防静电装置 通信设施 供配电系统安全设施  其他安全设施 固定式消防设施 移动式消防设施 消防供水安全设施 其他消防安全设施
禁止标志 警告标志 指令标志  提示标志 警示标志 危险货物类标志 起重机械危险部位标志 设备、管线安全标志 交通标志、标线  头部护具类  呼吸护具类  眼（面）护具类  耳朵防护类 手部防护类 脚部防护类  防护服类 防坠落护具类 其他防护类 
码头附属安全设施 装卸工艺系统安全设施 装卸设备安全设施 库场安全设施 阀门、管道安全设施 报警及警示装置 泄压、防爆、隔爆安全设施 密封安全设施 油气处理安全设施 防雷、防静电装置  通信设备设施 泄漏应急处置设备 给排水及含油污水处理设备设施 固定式消防设施
移动式消防设施 水上消防设施 消防供水/泡沫/干粉消防安全设施 火灾报警装置 其他消防安全设施 码头附属安全设施 库场安全设施 装卸工艺系统安全设施 通信设施 固定式消防设施  码头附属安全设施 库场安全设施  码头附属安全设施 工艺系统安全设施 
库场安全设施 报警及警示装置 泄压、防爆、隔爆安全设施 连续输送设施安全装置 煤炭翻车机、卸车安全装置 除尘装置 

//一级分类 插入数据字典SQL
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, sortno) values ('45', '00', '一级分类', 'YJFL', 45);
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4501', '45', '码头及库场安全设施', 'MTJKCAQSS','80011' );
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4502', '45', '港口消防安全设施', 'GKXFAQSS','80023' );
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4503', '45', '港口安全标志', 'GKAQBZ','80028' );
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4504', '45', '港口个体防护设备设施', 'GKGTFHSSSB','80038' );
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4505', '45', '危险货物码头及库场安全设施', 'WXHWMTJKCAQSS','80048' );
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4506', '45', '客滚码头及库场安全设施', 'KGMTJKCAQSS','80078' );
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4507', '45', '集装箱码头及库场安全设施', 'JZXMTJKCAQSS','80084' );
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4508', '45', '件杂货、散杂货码头及库场安全设施', 'JZHSZHMTJKCAQSS','80087' );

//二级分类 插入数据字典SQL
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, sortno) values ('46', '00', '二级分类', 'EJFL', 46);
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4601','46','防冲安全设施','FCANSS','80012');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4602','46','防撞安全设施','FZAQSS','80013');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4603','46','导、助航安全设施','DZHAQSS','80014');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4604','46','系船安全设施','XCAQSS','80015');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4605','46','码头附属安全设施','MTFSAQSS','80016');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4606','46','库场安全设施','KCAQSS','80017');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4607','46','防风装置','FFZZ','80018');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4608','46','防雷、防静电装置','FLFJDZZ','80019');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4609','46','通信设施','TXSS','80020');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4610','46','供配电系统安全设施','GPDXTAQSS','80021');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4611','46','其他安全设施','QTAQSS','80022');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4612','46','固定式消防设施','GDSXFSS','80024');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4613','46','移动式消防设施','YDSXFSS','80025');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4614','46','消防供水安全设施','XFGSAQSS','80026');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4615','46','其他消防安全设施','QTXFAQSS','80027');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4616','46','禁止标志','JZBZ','80029');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4617','46','警告标志','JGBZ','80030');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4618','46','指令标志','ZLBZ','80031');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4619','46','提示标志','ZSBZ','80032');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4620','46','警示标志','JSBZ','80033');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4621','46','危险货物类标志','WXHWLBZ','80034');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4622','46','起重机械危险部位标志','QZJXWXBWBZ','80035');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4623','46','设备、管线安全标志','SBGXAQBZ','80036');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4624','46','交通标志、标线','JTBZBX','80037');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4625','46','头部护具类','TBHJL','80039');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4626','46','呼吸护具类','HXHJL','80040');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4627','46','眼（面）护具类','YHJL','80041');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4628','46','耳朵防护类','EDFHL','80042');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4629','46','手部防护类','SBFHL','80043');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4630','46','脚部防护类','JBFHL','80044');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4631','46','防护服类','FHFL','80045');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4632','46','防坠落护具类','FZLHJL','80046');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4633','46','其他防护类','QTFHL','80047');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4634','46','码头附属安全设施','MTFSAQSS','80049');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4635','46','装卸工艺系统安全设施','ZXGYXXAQSS','80050');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4636','46','装卸设备安全设施','ZXSBAQSS','80051');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4637','46','库场安全设施','KCAQSS','80052');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4638','46','阀门、管道安全设施','FMGDAQSS','80053');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4639','46','报警及警示装置','BJHJSZZ','80054');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4640','46','泄压、防爆、隔爆安全设施','XYFBGBAQSS','80055');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4641','46','密封安全设施','MFAQSS','80056');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4642','46','油气处理安全设施','YQCLAQSS','80057');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4643','46','防雷、防静电装置','FLFJDZZ','80058');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4644','46','通信设备设施','TXSBSS','80059');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4645','46','泄漏应急处置设备','XLYJCZSB','80060');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4646','46','给排水及含油污水处理设备设施','JPSJHYWSCLSBSS','80061');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4647','46','固定式消防设施','GDSXFSS','80072');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4648','46','移动式消防设施','YDSXFSS','80073');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4649','46','水上消防设施','SSXFSS','80074');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4650','46','消防供水/泡沫/干粉消防安全设施','XFGSPMQFXFAQSS','80075');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4651','46','火灾报警装置','HZBJZZ','80076');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4652','46','其他消防安全设施','QTXFAQSS','80077');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4653','46','码头附属安全设施','MTFSAQSS','80079');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4654','46','库场安全设施','KCAQSS','80080');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4655','46','装卸工艺系统安全设施','ZXGYXTAQSS','80081');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4656','46','通信设施','TXSS','80082');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4657','46','固定式消防设施','GDSXFSS','80083');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4658','46','码头附属安全设施','MTFSAQSS','80085');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4659','46','库场安全设施','KCAQSS','80086');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4660','46','码头附属安全设施','MTFSAQSS','80088');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4661','46','工艺系统安全设施','GYXTAQSS','80089');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4662','46','库场安全设施','KCAQSS','80090');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4663','46','报警及警示装置','BJHJSZZ','80091');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4664','46','泄压、防爆、隔爆安全设施','XYFBGBAQSS','80092');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4665','46','连续输送设施安全装置','LXSSSSAQZZ','80093');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4666','46','煤炭翻车机、卸车安全装置','MTFCJXCAQZZ','80094');
insert into GK_OPERATION_JSJY_CODE(id, pid, text, code, yjptid) values ('4667','46','除尘装置','FCZZ','80095');