您当前的位置： 首页 >  oracle

liaowenxiong

暂无认证

  • 0浏览

    0关注

    1171博文

    0收益

  • 0浏览

    0点赞

    0打赏

    0留言

私信
关注
热门博文

Oracle 数据库的替代变量问题（即 set define off/on 的用法）

liaowenxiong 发布时间：2021-04-06 12:04:50 ，浏览量：0

在 SQL*Plus 中默认的 & 表示替代变量，也就是说，只要在命令中出现该符号，SQL*Plus 就会要你输入替代值。这就意味着你无法将一个含有该符号的字符串输入数据库或赋给变量，如字符串 SQL&Plus 系统会理解为以 SQL 打头的字符串，它会提示你输入替代变量 Plus的值，如果你输入 ABC，则最终字符串转化为 SQLABC。

set define off 则关闭该功能，& 将作为普通字符，如上例，最终字符就为 SQL&Plus，set define on 开启替代变量功能。set define * 将默认替代变量标志符该为 * (也可以设为其它字符)。

经常会用在 SQL 脚本文件中，如下：

set define off;
delete from HYT2PFHN.T_PF_OP where opid='A72A268A2AE9BD44366EDB5B59F53019';
insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME)
values ('A72A268A2AE9BD44366EDB5B59F53019', '8DD3171CE0E8439FBE1B8970880931D9', '1', '函件管理', 16, 'hyt2/images/toolbar/filing.gif', '6F2F48352C9A930FB8697BBEEE0CF4A2', 'PERID=[RESULT1.PERID.1,1]', '0', 2.0130821023702E16);

delete from HYT2PFHN.T_PF_WINDOW where windowid='6F2F48352C9A930FB8697BBEEE0CF4A2';
insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME)
values ('6F2F48352C9A930FB8697BBEEE0CF4A2', '运政系统', '函件管理', '', '', '', 'F8A586C5D3FC573D2DDF194317650136', '0', 2.01308200757305E16);


delete from HYT2PFHN.T_PF_OP where opid='C7EB7481DB92FFCF60D799A7CF336B8D'; 
insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME)
values ('C7EB7481DB92FFCF60D799A7CF336B8D', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '制作函件', 1, 'hyt2/images/toolbar/add.png', '6FD602DE6C1B2A01F40E5490E75A5E98', 'PERID=[url.PERID]'||'&'||'opmethod=valPerStatus', '0', 2.01308210928291E16);

delete from HYT2PFHN.T_PF_OP where opid='A9667DD77B51F931E9C3ADD2DD40B700';
insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME)
values ('A9667DD77B51F931E9C3ADD2DD40B700', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '详情', 2, '/hyt2/images/toolbar/detail.png', '60FF0FD1012712DF9922BD74434B92D1', 'DOID=[RESULT1.LETTERID.1,1] ', '0', 2.01308210954171E16);

delete from HYT2PFHN.T_PF_OP where opid='CAAB3D3ABB0539E7B695687574DF3CCC';
insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME)
values ('CAAB3D3ABB0539E7B695687574DF3CCC', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '打印', 3, 'hyt2/images/toolbar/print.gif', 'AAFD41259C425044072DE919131111F7', 'action=fzrtmis.hztech.middle.per.AppPer,printLetter,web'||'&'||'mouldId=lineLetter'||'&'||'DOID='||'&'||'opmethod=printWitness', '0', 2.01308220310548E16);

delete from HYT2PFHN.T_PF_OP where opid='9424219486E854CE974A52463AD6917F';
insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME)
values ('9424219486E854CE974A52463AD6917F', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '修改', 4, 'hyt2/images/toolbar/edit.png', '3F0CC8E075BACF71456CBA37BFCBF573', 'DOID=[RESULT1.LETTERID.1,1] ', '0', 2.01308210954269E16);

delete from HYT2PFHN.T_PF_OP where opid='657B34D7B3DC84F9EE65EAE9EBD7735E';
insert into HYT2PFHN.T_PF_OP (OPID, WINDOWID, OPGROUP, OPNAME, SEQNO, ICONURL, PWINDOWID, PURL, ISPFDEFAULT, SYSOPERTIME)
values ('657B34D7B3DC84F9EE65EAE9EBD7735E', '6F2F48352C9A930FB8697BBEEE0CF4A2', '1', '删除', 5, 'hyt2/images/toolbar/del.png', 'CB34650CFA8B689E966E8A39E13D87B8', 'action=fzrtmis.hztech.middle.per.AppPer,deleteLetter'||'&'||'DOID='||'&'||'opmethod=del', '0', 2.01308211229182E16);


delete from HYT2PFHN.T_CF2_MAIN where code='F8A586C5D3FC573D2DDF194317650136';
insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME)
values ('F8A586C5D3FC573D2DDF194317650136', '1', '', '', '', '', '', '/hyt2/jsp/scripts/fzrtmis/permission/accept.js', '0', '', '0', '', '', '', '', '', '', 2.01308210914136E16);


insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('F8A586C5D3FC573D2DDF194317650136', 'TITLE', '函件标题', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308210914136E16);


insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('F8A586C5D3FC573D2DDF194317650136', 'RECEIVEORG', '接收机构', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '0', '1', 2, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308210914136E16);


insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('F8A586C5D3FC573D2DDF194317650136', 'LETTERNUM', '发函函号', '', '1', '1', '1', '', '', '', '', '0', '0', 3, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308210914136E16);


insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('F8A586C5D3FC573D2DDF194317650136', 'CREDATE', '发函日期', '', '1', '1', '6', '', '', '', '', '0', '0', 1, '0', '', '', '0', 4, '', '', '', '', '', '', '', '', 2.01308210914136E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('F8A586C5D3FC573D2DDF194317650136', 'BTNQUERY', '', '', '1', '1', 'G', '', '', '', '', '0', '0', 2, '0', '1', '查询', '0', 5, '', 'οnclick="defaultQuery(this,''$SYS_WEB_PATH/platform/pages/common/subcommfunc2.jsp?action=XML.LINE.queryLetters'||'&'||'ISONEPAGE=0'||'&'||'COLWD=,350,,,,,110,230'||'&'||'FROZENCOL=1'||'&'||'ISAUTO=1'||'&'||'$URL_PARAMETER'',''RESULT1'')"', '', '', '', '', '', '', 2.01308210914136E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('F8A586C5D3FC573D2DDF194317650136', 'RESULT1', '*00*', '', '1', '-1', 'K', '', 'RESULT1', '/platform/pages/common/subcommfuncblank.jsp', '', '0', '0', 1, '0', '', '', '0', 6, '', '', '-1', '', '', '', '', '', 2.01308210914136E16);

delete from HYT2PFHN.T_PF_WINDOW where windowid='6FD602DE6C1B2A01F40E5490E75A5E98';
insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME)
values ('6FD602DE6C1B2A01F40E5490E75A5E98', '运政系统', '函件制作', '', '', '', '631B246C1280E52F731A3503DF55BA8E', '0', 2.01308210242304E16);

delete from HYT2PFHN.T_CF2_MAIN where code='631B246C1280E52F731A3503DF55BA8E';
insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', '1', '', '', '', '', '', '', '0', '', '0', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'V1', '函件基本信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'TITLE', '函件标题', '', '1', '2,450', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'LETTERNUM', '发函函号', '', '1', '1,150', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'RECEIVEORG', '接收机构', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '1', '0', 2, '0', '', '', '0', 4, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'RECIPIENT', '收件人', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 5, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'SENDORG1', '发函机构', '***显示给用户看而已', '1', '1,150', '1', '', '', '', '', '1', '0', 3, '0', '7', '$SYSDEPNAME', '0', 6, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'SENDORG', '', '***实际保存到表中的', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '7', '$SYSDEPCODE', '0', 7, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'SENDER', '发函人', '', '1', '1', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 8, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'PHONE', '发函人联系电话', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 9, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'FAX', '发函人传真', '', '1', '1', '1', '', '', '', '', '1', '0', 3, '0', '', '', '0', 10, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'CONTENTOFLETTER', '函件内容', '', '1', '-1,,150', 'F', '', '', '', '', '1', '0', 1, '0', '', '', '0', 11, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'V2', '收件人回复信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 12, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'ANSWER', '回复人', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 13, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'REPLYDATE', '回复日期', '', '1', '1', '6', '', '', '', '', '0', '0', 2, '0', '', '', '0', 14, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'AGREE', '是否同意', '', '1', '1,65', 'L', '', '', 'SELECT '' '' AS CODE,'' '' AS NAME FROM DUAL UNION ALL
SELECT ''1'' AS CODE, ''同意'' AS NAME FROM DUAL UNION ALL
  SELECT ''2'' AS CODE, ''不同意'' AS NAME FROM DUAL ', '', '0', '0', 3, '0', '', '', '0', 15, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'CONTENTOFREPLY', '回复内容', '', '1', '-1,,150', 'F', '', '', '', '', '0', '0', 1, '0', '', '', '0', 16, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'PERID', '许可申请ID', '', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '2', 'PERID', '0', 17, '', '', '', '', '', '', '', '', 2.01308210908195E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('631B246C1280E52F731A3503DF55BA8E', 'BTNSAVE', '', '', '1', '-1', 'G', '', 'BTNSAVE', '', 'function save(){
if(formValidate()){
ARSNew("business","fzrtmis.hztech.middle.per.AppPer,addLetter",getDefaultXML(),"saveWithClosePageImpl");
}}', '0', '0', 0, '0', '1', '保  存', '0', 18, '', 'οnclick="save();"', 'TOOLBARBUTTON', '', '', '', '', '', 2.01308210908195E16);

delete from HYT2PFHN.T_PF_WINDOW where windowid='60FF0FD1012712DF9922BD74434B92D1';
insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME)
values ('60FF0FD1012712DF9922BD74434B92D1', '运政系统', '函件详情', '', '', '', '800F35387B7830C7A83739ECAAAC1703', '0', 2.01308200810562E16);

delete from HYT2PFHN.T_CF2_MAIN  where code='800F35387B7830C7A83739ECAAAC1703';
insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', '1', '', '5', '$PRDLINE.LETTERS:LETTERID[$DOID]', '', '', '', '0', '', '0', '', '', '', '', '', '', 2.01308211058508E16);


insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'V1', '函件基本信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'TITLE', '函件标题', '', '1', '2,450', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'LETTERNUM', '发函函号', '', '1', '1,150', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'RECEIVEORG', '接收机构', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '1', '0', 2, '0', '7', '$INITFLD_RECEIVEORG###[DEPCODE(INITFLD_RECEIVEORG)]', '0', 4, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'RECIPIENT', '收件人', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 5, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'SENDORG', '发函机构', '', '1', '1,150', '1', '', '', '', '', '0', '1', 3, '0', '7', '$SYSDEPNAME', '0', 6, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'SENDER', '发函人', '', '1', '1', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 7, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'PHONE', '发函人联系电话', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 8, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'FAX', '发函人传真', '', '1', '1', '1', '', '', '', '', '1', '0', 3, '0', '', '', '0', 9, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'CONTENTOFLETTER', '函件内容', '', '1', '-1,,150', 'F', '', '', '', '', '1', '0', 1, '0', '', '', '0', 10, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'V2', '收件人回复信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 11, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'ANSWER', '回复人', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 12, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'REPLYDATE', '回复日期', '', '1', '1', '6', '', '', '', '', '0', '0', 2, '0', '', '', '0', 13, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'AGREE', '是否同意', '', '1', '1,65', 'L', '', '', 'SELECT '' '' AS CODE,'' '' AS NAME FROM DUAL UNION ALL
SELECT ''1'' AS CODE, ''同意'' AS NAME FROM DUAL UNION ALL
  SELECT ''2'' AS CODE, ''不同意'' AS NAME FROM DUAL', '', '0', '0', 3, '0', '', '', '0', 14, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'CONTENTOFREPLY', '回复内容', '', '1', '-1,,150', 'F', '', '', '', '', '0', '0', 1, '0', '', '', '0', 15, '', '', '', '', '', '', '', '', 2.01308211058508E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('800F35387B7830C7A83739ECAAAC1703', 'PERID', '许可申请ID', '', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '2', 'PERID', '0', 16, '', '', '', '', '', '', '', '', 2.01308211058508E16);

delete from HYT2PFHN.T_PF_WINDOW where windowid='3F0CC8E075BACF71456CBA37BFCBF573';
insert into HYT2PFHN.T_PF_WINDOW (WINDOWID, WINDOWTYPE, WINDOWNAME, NVPURL, WINDOWNOTE, TESTPARAM, CODE, ISPFDEFAULT, SYSOPERTIME)
values ('3F0CC8E075BACF71456CBA37BFCBF573', '运政系统', '修改函件', '', '', '', 'B9CD4E88AC79A529E6CCAB98174E367A', '0', 2.01308211110118E16);

delete from HYT2PFHN.T_CF2_MAIN where code='B9CD4E88AC79A529E6CCAB98174E367A';
insert into HYT2PFHN.T_CF2_MAIN (CODE, ISSHOWELEMENT, AUTOOPNAME, LOGIC, LOGICCONT, CSSFILE, COLRATE, JSFILE, ISKEYSHOW, JSPAGE, ISPFDEFAULT, DEF1, DEF2, DEF3, DEF4, DEF5, DEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', '1', '', '5', '$PRDLINE.LETTERS:LETTERID[$DOID]', '', '', '', '0', '', '0', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'V1', '函件基本信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 1, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'TITLE', '函件标题', '', '1', '2,450', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 2, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'LETTERNUM', '发函函号', '', '1', '1,150', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 3, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'RECEIVEORG', '接收机构', '', '1', '1,180', '9', '', 'RECEIVEORG', '/hyt2/comm/pages/choosedep.jsp?ACTION=XML.per.getDep'||'&'||'TEXT9=[RECEIVEORG]'||'&'||'MULTISELECT=1', '', '1', '0', 2, '0', '7', '$INITFLD_RECEIVEORG###[DEPCODE(INITFLD_RECEIVEORG)]', '0', 4, '', '', 'ALLREAD', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'RECIPIENT', '收件人', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 5, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'SENDORG1', '发函机构', '***显示给用户看而已', '1', '1,150', '1', '', '', '', '', '1', '0', 3, '0', '7', '$SYSDEPNAME', '0', 6, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'SENDORG', '', '***实际保存到表中的', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '7', '$SYSDEPCODE', '0', 7, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'SENDER', '发函人', '', '1', '1', '1', '', '', '', '', '1', '0', 1, '0', '', '', '0', 8, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'PHONE', '发函人联系电话', '', '1', '1', '1', '', '', '', '', '1', '0', 2, '0', '', '', '0', 9, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'FAX', '发函人传真', '', '1', '1', '1', '', '', '', '', '1', '0', 3, '0', '', '', '0', 10, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'CONTENTOFLETTER', '函件内容', '', '1', '-1,,150', 'F', '', '', '', '', '1', '0', 1, '0', '', '', '0', 11, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'V2', '收件人回复信息', '', '1', '1', 'J', '', '', '', '', '0', '0', 1, '0', '', '', '0', 12, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'ANSWER', '回复人', '', '1', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 13, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'REPLYDATE', '回复日期', '', '1', '1', '6', '', '', '', '', '0', '0', 2, '0', '', '', '0', 14, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'AGREE', '是否同意', '', '1', '1,65', 'L', '', '', 'SELECT '' '' AS CODE,'' '' AS NAME FROM DUAL UNION ALL
SELECT ''1'' AS CODE, ''同意'' AS NAME FROM DUAL UNION ALL
  SELECT ''2'' AS CODE, ''不同意'' AS NAME FROM DUAL', '', '0', '0', 3, '0', '', '', '0', 15, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'CONTENTOFREPLY', '回复内容', '', '1', '-1,,150', 'F', '', '', '', '', '0', '0', 1, '0', '', '', '0', 16, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'PERID', '许可申请ID', '', '0', '1', '1', '', '', '', '', '0', '0', 1, '0', '', '', '0', 17, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'LETTERID', '信函ID', '', '0', '1', '1', '', '', '', '', '0', '0', 2, '0', '', '', '0', 18, '', '', '', '', '', '', '', '', 2.01308211239313E16);

insert into HYT2PFHN.T_CF2_DETAIL (CODE, NAME, CNNAME, TIP, ISVALID, ISPOS, CTRLTYPE, REGU, DDFLD, APPIXPARA, JSCONTROL, ISNEED, ISREAD, FIELDCOL, ISPFDEFAULT, INITTYPE, INITEXPRESSION, ISCHANGE, INNERORDER, CTRLSHOWPARA, EVENTCTRL, DDEF1, DDEF2, DDEF3, DDEF4, DDEF5, DDEF6, SYSOPERTIME)
values ('B9CD4E88AC79A529E6CCAB98174E367A', 'BTNSAVE', '', '', '1', '-1', 'G', '', 'BTNSAVE', '', 'function save(){
defaultSave(this,''fzrtmis.hztech.middle.per.AppPer,modifyLetter'');
}', '0', '0', 0, '0', '1', '修 改', '0', 19, '', 'οnclick="save()"', 'TOOLBARBUTTON', '', '', '', '', '', 2.01308211239313E16);

delete from hyt2pfhn.t_pf_rptmould where RPTMOULDID='EE84464BA38E2AEFD41DBB1FBF475831';
insert into t_pf_rptmould (RPTMOULDID, DEPCODE, USERCODE, MOULDTYPE, MOULDNAME, PRINTTYPE, MOULDXML, CREUSRCODE, CREDATE, CRETIME, EDIUSRCODE, EDIDATE, EDITIME, REMARK, PRINTERINFO, SYSOPERTIME)
values ('EE84464BA38E2AEFD41DBB1FBF475831', '', 'fzrtmis', 'lineLetter', '客运班线经营行政许可征求意见函', '1', 'EE84464BA38E2AEFD41DBB1FBF475831fzrtmislineLetter客运班线经营行政许可征求意见函1缺省打印机0,09/images/print_imges/appcmvecup.jpg#882#11630#0#1XML.line.printLetterTITLE#text2#text1#CREDATE#SENDER#FAX#PHONE#rectangle9#text10#text11#text12#text13#text14#text15#text16#text17#text18#text19#text20#BYWAYOF#BERTH#REGCTCTYPE#text24#PERVECNUM#TIMES#APPLYTYPE客运班线经营行政许可征求意见函#编号：省际变更[2011]第110号#信件内容#2011年08月16日#联系人#传真#联系电话#矩形9#申请人#起讫站点名称#途经地#停靠站点#班车类型#里程# 班次#许可车辆数#许可申请类型#文本19#文本20#文本21#文本22#文本23#文本24#文本25#文本26#文本281#1#1#1#1#1#1#3#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1客运班线经营行政许可征求意见函#{h:LETTERNUM}#{h:CONTENTOFLETTER}#{h:CREDATE}#联系人：{h:SENDER}#传真：{h:FAX}#联系电话：{h:PHONE}##申请人#起讫站点名称#途经地#停靠站点#班车类型#里程# 班次#许可车辆数#许可申请类型#{h:CLITNAME}#{h:STACLTNAME} 至 {h:ENDCLTNAME}####{h:SUMMIL}###1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1#1103#410#72#521#66#466#231#37#39#88#185#238#313#389#433#490#582#38#110#187#245#316#383#504#435#605161#222#347#867#537#534#535#602#606#606#607#608#607#607#606#608#608#641#638#638#637#639#647#642#646#6420#0#600#0#600#600#600#677#0#0#0#0#0#0#0#0#0#60#60#60#60#60#60#60#60#600#0#-10#0#0#0#0#768#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0宋体#宋体#宋体#宋体#宋体#宋体#宋体#2:15,85:10,20,10,15,15,10,10,20,20#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys#Fixedsys-35,700,0,0,700,0,0,0,134,3,2,1,2#-20,700,0,0,700,0,0,0,134,3,2,1,2#-20,700,0,0,700,0,0,0,134,3,2,1,2#-20,700,0,0,700,0,0,0,134,3,2,1,2#-19,700,0,0,700,0,0,0,134,3,2,1,2#-19,700,0,0,700,0,0,0,134,3,2,1,2#-19,700,0,0,700,0,0,0,134,3,2,1,2#0,1#12#12#12#12#12#12#12#12#12#12#12#12#12#12#12#12#12#120#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0#0客运班线经营行政许可征求意见函#编号：省际变更[2011]第110号#    #2011年08月16日#测试7#测试8#测试9#测rectangle9#测试10#起讫站点名称#途经地#停靠站点#班车类型#里程#测试16#测试17#测试18#申请人#测试20#测试21#测试22#测试23#测试24#测试25#测试26#测试28', '', '', '', 'fzrtmis', '2013-08-22', '07:21:50', '', '缺省打印机', 2.0130822110334E16);
set define on;


alter table HYT2LINEHN.APPLINPER add(applytype varchar2(50));

create table LETTERS
(
  SYSOPERTIME     NUMBER(25),
  REMARKDOC       VARCHAR2(500),
  EDITIME         VARCHAR2(100),
  EDIDATE         VARCHAR2(100),
  EDIUSRCODE      VARCHAR2(100),
  CRETIME         VARCHAR2(100),
  CREDATE         VARCHAR2(100),
  CREUSRCODE      VARCHAR2(100),
  TITLE           VARCHAR2(500),
  RECEIVEORG      VARCHAR2(100),
  CONTENTOFLETTER VARCHAR2(2000),
  SENDORG         VARCHAR2(100),
  SENDER          VARCHAR2(100),
  PHONE           VARCHAR2(100),
  FAX             VARCHAR2(100),
  LETTERNUM       VARCHAR2(100),
  PERID           VARCHAR2(200),
  LETTERID        VARCHAR2(200) not null,
  RECIPIENT       VARCHAR2(100),
  ANSWER          VARCHAR2(100),
  REPLYDATE       VARCHAR2(100),
  CONTENTOFREPLY  VARCHAR2(2000),
  AGREE           VARCHAR2(50)
)


create table RELATIONSHIPOFLINEWITHVEHICLE
(
  SYSOPERTIME NUMBER(25),
  REMARKDOC   VARCHAR2(500),
  EDITIME     VARCHAR2(100),
  EDIDATE     VARCHAR2(100),
  EDIUSRCODE  VARCHAR2(100),
  CRETIME     VARCHAR2(100),
  CREDATE     VARCHAR2(100),
  CREUSRCODE  VARCHAR2(100),
  CMVECID     VARCHAR2(200),
  PERID       VARCHAR2(200)
)
关注
打赏
1661566967
查看更多评论

最近更新

热门博客

[ 申请 ]友情链接：

ClashX教程 绘画宝宝 配音宝宝
立即登录/注册

微信扫码登录

0.1459s