Sākums Izpētīt Palīdzība
Reģistrēties Pierakstīties
hs
/
jsgkj
2
0
Atdalīts 0
Faili Problēmas 0 Izmaiņu pieprasījumi 0 Vikivietne
Koks: be76ef8a1f
Atzari Tagi
jsgkj
/
gkjsjy
/
docs
/
数据交换平台
/
储罐.txt

储罐.txt 14 KB
Vēsture Neapstrādāts

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 
  1. //同步语句
    2. 

  2. insert into GK_BASIC_JSJY_JYR_CG(id,ssjyr,whzyfzbh,qyccbh,scjyhdlx,cchxppzsl,zxgyjzysb,cccscq,gkzdwxybh,gkzdwxybabh,cgqmc,jtwz,cgzb,cgqmj,cggs,cgmc,cgxh,ywfhd,gjzxjl,cgcz,cgrj,cgxs,cgazxs,wzzt,cgwx,sjyl,sjgzyl,sjwd,sjgzwd,tcsj,
    3. 

  3. sjsynx,jlfs,clfs,fjdsssfnjjzs,zsbh,tbr,lxdh,tbsj,hysl,hysm,bdzzsl,bdzzsm,qtsl,qtsm,mapid,hxpmc,hxppz,hxpsl,update_user,record_status,szd,szgq,zdwxycggs,zdwxycgrl,aqgd,zj,wxydj,create_date_time,update_date_time,create_user,szgk,
    4. 

  4. ssgkglbm,aqid)(select sys_guid(),a.id,c.WHZYFZBH,c.QYCCBH,case when c.SCJYHDLX='cc' then '3401' else null end,c.CCHXPPZSL,c.ZXGYJZYSB,case when c.CCCSCQ='zy' then '3501' when c.CCCSCQ='zl' then  '3502' else null  end,c.GKZDWXYBH,
    5. 

  5. c.GKZDWXYBABH,c.CGQMC,c.JTWZ,c.CGZB,c.CGQMJ,c.CGGS,c.CGMC,c.CGXH,case when c.YWFHD='有' then '501' when c.YWFHD='无' then '502'  else null end,c.GJZXJL,case when c.CGCZ='1' then '3001' when c.CGCZ='2' then '3002' when c.CGCZ='3' then '3003' else null  end,
    6. 

  6. c.CGRJ,case when c.CGXS='cc' then '3601' when c.CGXS='sc' then  '3602' else null  end,case when c.CGAZXS='ds' then '3701' when c.CGAZXS='dx' then '3702' when c.CGAZXS='bds' then '3703' else null  end,
    7. 

  7. case when c.WZZT='yt' then '3801' when c.WZZT='qt' then '3802' when c.WZZT='yqt' then '3803' else null  end,
    8. 

  8. case when c.CGWX='ls' then '3901' when c.CGWX='qx' then '3902' when c.CGWX='ws' then '3903' when c.CGWX='qxg' then '3904'  else null  end,c.SJYL,c.SJGZYL,c.SJWD,c.SJGZWD,c.TCSJ,c.SJSYNX,
    9. 

  9. case when c.JLFS='gd' then '4001' when c.JLFS='cc' then  '4002' else null  end,case when c.CLFS='gd' then '4101' when c.CLFS='cc' then  '4102' else null  end,case when c.FJDSSSFNJJZS='s' then '201' else '202' end,
    10. 

  10. c.ZSBH,c.TBR,c.LXDH,c.TBSJ,c.HYSL,c.HYSM,c.BDZZSL,c.BDZZSM,c.QTSL,c.QTSM,c.MAPID,c.HXPMC,c.HXPPZ,c.HXPSL,'aq',1,b.szd,b.id,c.ZDWXYCGGS,c.ZDWXYCGRL,c.AQGD,c.ZJ,c.WXYDJ,systimestamp,systimestamp,'aq',b.szgk,'',
    11. 

  11. c.ID from GK_BASIC_JSJY_JYR a,GK_BASIC_JSJY_GK_GQ b,aq.T_YJPT_CG c where c.record_status!=9 and c.GQ=b.aqid and a.aqid=c.DWMC)
    12. 

  12. 

  13. 

  14. //所需数据字典
    15. 

  15. 生产经营活动类型 :存储        
    16. 

  16.  
    17. 

  17. 储罐材质: 碳钢 不锈钢 玻璃钢  
    18. 

  18. 

  19. 存储场所产权:自有  租赁  
    20. 

  20. 

  21. 储罐形式：储存性储罐 生产性储罐   
    22. 

  22.      
    23. 

  23. 储罐安装形式：地上 地下 半地上 
    24. 

  24. 

  25. 物质状态： 液态 气态 液气态共存  
    26. 

  26. 

  27. 储罐外形： 外浮顶 内浮顶 拱顶 球形罐 
    28. 

  28. 

  29. 进料方式： 管道 槽车 
    30. 

  30. 

  31. 出料方式： 管道 槽车 
    32. 

  32. 

  33. //插入数据字典语句
    34. 

  34. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    35. 

  35. values ('34', '00', '生产经营活动类型', 'SCJYHD', null, 34, to_timestamp('26-11-2015 18:54:20.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 18:54:20.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    36. 

  36. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    37. 

  37. values ('3401', '34', '存储', 'CC', null, null, to_timestamp('26-11-2015 18:58:04.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 18:58:04.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'cc');
    38. 

  38. 

  39. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    40. 

  40. values ('35', '00', '存储场所产权', 'CCCSCQ', null, 35, to_timestamp('26-11-2015 19:07:33.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:07:33.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    41. 

  41. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    42. 

  42. values ('3501', '35', '自有', 'ZY', null, null, to_timestamp('26-11-2015 19:09:07.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:09:07.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'zy');
    43. 

  43. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    44. 

  44. values ('3502', '35', '租赁', 'ZL', null, null, to_timestamp('26-11-2015 19:09:07.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:09:07.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'zl');
    45. 

  45. 

  46. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    47. 

  47. values ('36', '00', '储罐形式', 'CGXS', null, 36, to_timestamp('26-11-2015 19:16:24.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:16:24.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    48. 

  48. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    49. 

  49. values ('3601', '36', '储存性储罐', 'CC', null, null, to_timestamp('26-11-2015 19:18:05.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:18:05.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'cc');
    50. 

  50. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    51. 

  51. values ('3602', '36', '生产性储罐', 'SC', null, null, to_timestamp('26-11-2015 19:18:05.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:18:05.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'sc');
    52. 

  52. 

  53. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    54. 

  54. values ('30', '00', '储罐材质', 'CGCZ', null, 30, to_timestamp('26-11-2015 15:06:18.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 15:06:18.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    55. 

  55. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    56. 

  56. values ('3001', '30', '碳钢', 'CG', null, null, to_timestamp('26-11-2015 15:08:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 15:08:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, '1');
    57. 

  57. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    58. 

  58. values ('3002', '30', '不锈钢', 'BXG', null, null, to_timestamp('26-11-2015 15:08:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 15:08:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, '2');
    59. 

  59. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    60. 

  60. values ('3003', '30', '玻璃钢', 'BLG', null, null, to_timestamp('26-11-2015 15:08:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 15:08:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, '3');
    61. 

  61. 

  62. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    63. 

  63. values ('3701', '37', '地上', 'DS', null, null, to_timestamp('26-11-2015 19:36:39.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:36:39.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'ds');
    64. 

  64. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    65. 

  65. values ('3702', '37', '地下', 'DX', null, null, to_timestamp('26-11-2015 19:36:39.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:36:39.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'dx');
    66. 

  66. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    67. 

  67. values ('37', '00', '储罐安装形式', 'CGAZXX', null, 37, to_timestamp('26-11-2015 19:35:00.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:35:00.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    68. 

  68. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    69. 

  69. values ('3703', '37', '半地上', 'BDS', null, null, to_timestamp('26-11-2015 19:36:39.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:36:39.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'bds');
    70. 

  70. 

  71. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    72. 

  72. values ('38', '00', '物质状态', 'WZZT', null, 38, to_timestamp('26-11-2015 19:37:07.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:37:07.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    73. 

  73. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    74. 

  74. values ('3801', '38', '液态', 'YT', null, null, to_timestamp('26-11-2015 19:38:21.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:38:21.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'yt');
    75. 

  75. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    76. 

  76. values ('3802', '38', '气态', 'QT', null, null, to_timestamp('26-11-2015 19:38:21.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:38:21.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'qt');
    77. 

  77. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    78. 

  78. values ('3803', '38', '液气态共存', 'YQT', null, null, to_timestamp('26-11-2015 19:38:21.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:38:21.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'yqt');
    79. 

  79. 

  80. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    81. 

  81. values ('39', '00', '储罐外形', 'CGWX', null, 39, to_timestamp('26-11-2015 19:39:27.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:39:27.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    82. 

  82. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    83. 

  83. values ('3901', '39', '外浮顶', 'LS', null, null, to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'ls');
    84. 

  84. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    85. 

  85. values ('3902', '39', '内浮顶', 'QX', null, null, to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'qx');
    86. 

  86. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    87. 

  87. values ('3903', '39', '拱顶', 'WS', null, null, to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'ws');
    88. 

  88. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    89. 

  89. values ('3904', '39', '球形罐', 'QXG', null, null, to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 19:58:48.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'qxg');
    90. 

  90. 

  91. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    92. 

  92. values ('40', '00', '进料方式', 'JLFS', null, 40, to_timestamp('26-11-2015 20:00:47.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 20:00:47.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    93. 

  93. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    94. 

  94. values ('4001', '40', '管道', 'GD', null, null, to_timestamp('26-11-2015 20:01:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 20:01:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'gd');
    95. 

  95. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    96. 

  96. values ('4002', '40', '槽车', 'CC', null, null, to_timestamp('26-11-2015 20:01:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 20:01:52.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'cc');
    97. 

  97. 

  98. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    99. 

  99. values ('41', '00', '出料方式', 'CLFS', null, 41, to_timestamp('26-11-2015 20:02:56.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 20:02:56.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, null);
    100. 

  100. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    101. 

  101. values ('4101', '41', '管道', 'GD', null, null, to_timestamp('26-11-2015 20:04:23.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 20:04:23.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'gd');
    102. 

  102. insert into GK_OPERATION_JSJY_CODE (id, pid, text, code, val, sortno, create_date_time, update_date_time, record_status, create_user, update_user, szd, group_code, yjptid)
    103. 

  103. values ('4102', '41', '槽车', 'CC', null, null, to_timestamp('26-11-2015 20:04:23.', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('26-11-2015 20:04:23.', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, null, null, null, null, 'cc');
    104.