--Begin-- 住院合理用药最新指标分区报表 -- 2015-02-12 10:28:07 declare V_TEMPID T_CTLTEMP.F_TEMPID%TYPE; begin SELECT COUNT(*) INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='3' AND F_NAMECN='住院合理用药最新指标分区报表'; IF V_TEMPID =0 THEN SELECT nvl(MAX(F_TEMPID),0)+1 INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='3'; ELSE SELECT F_TEMPID INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='3' AND F_NAMECN='住院合理用药最新指标分区报表'; END IF; DELETE FROM T_TEMPTYPE WHERE F_SYSID='3' AND F_TYPEID='00001'; INSERT INTO T_TEMPTYPE (F_SYSID,F_TYPEID,F_TYPENAME,F_MEMO) VALUES ('3','00001','自定义报表',''); -- T_TEMPTYPE ------------------------------------------ DELETE FROM T_CTLTEMP WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLTEMP1 WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLEDIT WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLLABEL WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLLINE WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLDATE WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLCMB WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLCURR WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLGRID WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_CTLGRIDCOL WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_SQLPARAMS WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; DELETE FROM T_SQLLIST WHERE F_SYSID='3' AND F_TEMPID=V_TEMPID; -- DELETE ------------------------------------------ INSERT INTO T_CTLTEMP (F_SYSID,F_TEMPID,F_TEMPTYPE,F_NAMECN,F_CREATEDATE,F_CREATEPERSON,F_DATASRC,F_PACK,F_SQL,F_MODEL,F_MODELDIRECT,F_MODELCOLCOUNT,F_MODELROWCOUNT,F_PRINTER,F_PAPER,F_WIDTH,F_HEIGHT,F_COLOR,F_BORDERCOLOR,F_LOCK,F_ISSYS,F_ZOOM,F_ORIENTATION,F_MENUSHOW,F_MODELCOUNT) VALUES ('3',V_TEMPID,'00001','住院合理用药最新指标分区报表','2015/2/3 2','测试员','0','0','','0','0','1','1','','A3','2971','4199','16777215','0','0','0','0.1','0','1',''); --T_CTLTEMP------------------------------------------ INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1003','LABEL','Label3',''); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1004','LABEL','Label4',''); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1005','LABEL','Label5',''); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1006','LABEL','label1006',''); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2002','EDIT','Edit2','编辑框2'); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2003','EDIT','Edit3','编辑3'); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2006','EDIT','Edit6','编辑6'); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2008','EDIT','Edit8','编辑8'); INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'7000','GRID','Grid0','网格0'); --T_CTLTEMP1------------------------------------------ INSERT INTO T_CTLEDIT (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_NAMECN,F_FIELD,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_DATA,F_DECIMAL,F_FORMATFLOAT,F_CAPITAL,F_DIGITAL,F_READONLY,F_PRINT,F_BORDERSTYLE,F_TAB,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_DEFAULT,F_CURRFORMAT,F_FULLPRINT,F_SHOWBTN,F_VISUAL) VALUES ('3',V_TEMPID,'2002','Edit2','编辑框2','CS_开始日期','1','2','0','0','0','0','0','0','9','0','1','0','0','302','238','336','61','宋体','0','12','0','','0','0','0','1'); INSERT INTO T_CTLEDIT (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_NAMECN,F_FIELD,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_DATA,F_DECIMAL,F_FORMATFLOAT,F_CAPITAL,F_DIGITAL,F_READONLY,F_PRINT,F_BORDERSTYLE,F_TAB,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_DEFAULT,F_CURRFORMAT,F_FULLPRINT,F_SHOWBTN,F_VISUAL) VALUES ('3',V_TEMPID,'2003','Edit3','编辑3','CS_结束日期','0','2','0','0','0','0','0','0','9','0','1','0','0','699','238','336','61','宋体','0','12','0','','0','0','0','1'); INSERT INTO T_CTLEDIT (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_NAMECN,F_FIELD,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_DATA,F_DECIMAL,F_FORMATFLOAT,F_CAPITAL,F_DIGITAL,F_READONLY,F_PRINT,F_BORDERSTYLE,F_TAB,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_DEFAULT,F_CURRFORMAT,F_FULLPRINT,F_SHOWBTN,F_VISUAL) VALUES ('3',V_TEMPID,'2006','Edit6','编辑6','XT_HOSNAME','1','2','0','0','0','0','0','0','9','0','1','0','0','103','98','812','98','宋体','1','24','0','','0','0','0','1'); INSERT INTO T_CTLEDIT (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_NAMECN,F_FIELD,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_DATA,F_DECIMAL,F_FORMATFLOAT,F_CAPITAL,F_DIGITAL,F_READONLY,F_PRINT,F_BORDERSTYLE,F_TAB,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_DEFAULT,F_CURRFORMAT,F_FULLPRINT,F_SHOWBTN,F_VISUAL) VALUES ('3',V_TEMPID,'2008','Edit8','编辑8','XT_NOW','0','2','0','0','0','0','0','0','9','0','1','0','0','1267','235','529','64','宋体','0','12','0','','0','0','0','1'); --T_CTLEDIT------------------------------------------ INSERT INTO T_CTLLABEL (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_FIELD,F_CAPTION,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_PRINT,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_VISUAL) VALUES ('3',V_TEMPID,'1003','Label3','','住院合理用药指标分区报表','2','2','0','0','1','884','108','1106','79','宋体','10','24','-16777208','1'); INSERT INTO T_CTLLABEL (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_FIELD,F_CAPTION,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_PRINT,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_VISUAL) VALUES ('3',V_TEMPID,'1004','Label4','','统计时间:','0','2','0','0','1','114','238','191','56','宋体','00','12','-16777208','1'); INSERT INTO T_CTLLABEL (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_FIELD,F_CAPTION,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_PRINT,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_VISUAL) VALUES ('3',V_TEMPID,'1005','Label5','','至','0','2','0','0','1','638','238','58','56','宋体','00','12','0','1'); INSERT INTO T_CTLLABEL (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_FIELD,F_CAPTION,F_HALIGN,F_VALIGN,F_DISPERSE,F_MULLINE,F_PRINT,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FONTNAME,F_FONTSTYLE,F_FONTSIZE,F_FONTCOLOR,F_VISUAL) VALUES ('3',V_TEMPID,'1006','label1006','','打印时间:','0','2','0','0','1','1072','238','220','56','宋体','00','12','0','1'); --T_CTLLABEL------------------------------------------ --T_CTLLINE------------------------------------------ --T_CTLDATE------------------------------------------ --T_CTLCMB------------------------------------------ --T_CTLCURR------------------------------------------ INSERT INTO T_CTLGRID (F_SYSID,F_TEMPID,F_SEQUENCE,F_NAMEEG,F_NAMECN,F_PACK,F_SQL,F_MASTERFIELD,F_FIXROWS,F_ROWS,F_COLS,F_FIXCOLOR,F_DETAILCOLOR,F_LINECOLOR,F_VISUAL,F_LEFT,F_TOP,F_WIDTH,F_HEIGHT,F_FIXHEIGHT,F_DETAILHEIGHT,F_FONTNAME1,F_FONTSTYLE1,F_FONTSIZE1,F_FONTCOLOR1,F_FONTNAME2,F_FONTSTYLE2,F_FONTSIZE2,F_FONTCOLOR2,F_PRINTHEADER,F_PRINTDETAIL,F_PRINTCOLOR,F_PRINTVLINE,F_PRINTHLINE,F_INTERVAL,F_BORDERSTYLE,F_BORDERCOLOR,F_FILLALL,F_CURRENCY,F_CURRSYMBOL,F_CURRDIGITAL,F_CURRDECIMAL,F_SQL1) VALUES ('3',V_TEMPID,'7000','Grid0','网格0','0','SELECT bmmc00,(SELECT TO_CHAR (ROUND (SUM (kjywpz) / GREATEST (COUNT (1), 1), 2) ) FROM zh_cybrbb_ls a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00 AND a.kjywpz > 0) rjkjpz,(SELECT TO_CHAR (ROUND (SUM (kjywje) / GREATEST (COUNT (1), 1), 2) ) FROM zh_cybrbb_ls a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00 AND a.kjywpz > 0) rjkjfy, (SELECT ROUND (SUM (SIGN (kjywpz)) / GREATEST (COUNT (1), 1),4 ) * 100|| ''%'' FROM zh_cybrbb_ls a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00) sykjbl,(SELECT ROUND ( nvl((SELECT SUM (ROUND (ypzsl0 * zhl000 / ddd000, 3)) FROM vw_yk_kssjb0_zy a WHERE a.bqbmbh = m.bmbh00 AND a.fyrq00 BETWEEN :开始日期 AND :结束日期),0) / (SELECT GREATEST (COUNT (*), 1) FROM zy_zybrmx a WHERE zyrq00 BETWEEN :开始日期 AND :结束日期 AND a.bqh000 = m.bmbh00 AND flag00 = ''0''), 2)* 100 FROM DUAL) kjsyqd, (SELECT RTRIM(REPLACE ( TO_CHAR (ROUND (SUM (kjywje) / GREATEST (SUM (ypf000), 1 ), 4)* 100,''FM9999990.999'' )|| '' '',''. '','''' ))|| ''%'' sj0000 FROM zh_cybrbb a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00) kjywbl,(SELECT ROUND (SUM (SIGN (ejkjpz)) / GREATEST (COUNT (1), 1),4 ) * 100|| ''%'' FROM zh_cybrbb_ls a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00) ejkjbl,(SELECT ROUND (nvl((SELECT SUM (ROUND (ypzsl0 * zhl000 / ddd000, 3))FROM vw_yk_kssjb0_zy a WHERE a.bqbmbh = m.bmbh00 AND a.fyrq00 BETWEEN :开始日期 AND :结束日期 AND kssjb0 = 2),0) / (SELECT GREATEST (COUNT (*), 1)FROM zy_zybrmx a WHERE zyrq00 BETWEEN :开始日期 AND :结束日期 AND a.bqh000 = m.bmbh00 AND flag00 = ''0''), 2)* 100 FROM DUAL) ejkjqd, (SELECT RTRIM(REPLACE ( TO_CHAR (ROUND (SUM (ejkjje) / GREATEST (SUM (ypf000), 1), 4)* 100,''FM9999990.999'' )|| '' '',''. '','''' ))|| ''%'' sj0000 FROM zh_cybrbb_ls a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00) ejywbl, (SELECT ROUND (SUM (SIGN (sjkjpz)) / GREATEST (COUNT (1), 1),4 ) * 100|| ''%'' FROM zh_cybrbb_ls a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00) sjkjbl, (SELECT ROUND (nvl((SELECT SUM (ROUND (ypzsl0 * zhl000 / ddd000, 3))FROM vw_yk_kssjb0_zy a WHERE a.bqbmbh = m.bmbh00 AND a.fyrq00 BETWEEN :开始日期 AND :结束日期 AND kssjb0 = 3),0) / (SELECT GREATEST (COUNT (*), 1)FROM zy_zybrmx a WHERE zyrq00 BETWEEN :开始日期 AND :结束日期 AND a.bqh000 = m.bmbh00 AND flag00 = ''0''), 4)* 100 FROM DUAL) sjkjqd, (SELECT RTRIM(REPLACE ( TO_CHAR (ROUND (SUM (sjkjje) / GREATEST (SUM (ypf000), 1), 4)* 100, ''FM9999990.999'') || '' '',''. '', '''' ) ) || ''%'' sj0000 FROM zh_cybrbb_ls a WHERE a.cyrq00 BETWEEN :开始日期 AND :结束日期 AND a.cybq00 = m.bmbh00) sjywbl FROM bm_bmbm00 m WHERE bmxz00 = ''9'' AND czbz00 <> ''2'' ORDER BY pxxh00, bh0000','','1','1','12','16777215','-2147483643','536870911','1','69','331','2839','2561','80','70','宋体','0','14','0','宋体','0','14','0','1','1','0','1','1','1','0','0','0','0','','9','2',''); --T_CTLGRID------------------------------------------ INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','0','BMMC00','病区','0','349','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','1','RJKJPZ','人均抗菌药物品种数','1','249','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','2','RJKJFY','人均抗菌药物费用','0','249','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','3','SYKJBL','使用抗菌药物百分率','0','249','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','4','KJSYQD','抗菌药物使用强度','0','151','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','11','SJKJBL','三级抗菌药物占药费总额百分率','0','249','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','6','EJKJBL','二级抗菌药物百分率','0','249','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','7','EJKJQD','二级抗菌药物使用强度','0','151','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','8','EJYWBL','二级抗菌药物占药费总额百分率','0','249','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','9','SJKJBL','三级抗菌药物百分率','0','249','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','10','SJKJQD','三级抗菌药物使用强度','0','151','0','1','1','0','0',''); INSERT INTO T_CTLGRIDCOL (F_SYSID,F_TEMPID,F_SEQUENCE,F_COLID,F_COLFIELD,F_COLCAPTION,F_COLALIGN,F_COLWIDTH,F_COLFIXED,F_COLVISUAL,F_COLPRINT,F_COLPAGETYPE,F_COLDATATYPE,F_COLDATANAME) VALUES ('3',V_TEMPID,'7000','5','KJYWBL','抗菌药物占药费总额百分率','0','249','0','1','1','0','0',''); --T_CTLGRIDCOL------------------------------------------ INSERT INTO T_SQLPARAMS (F_SYSID,F_TEMPID,F_SEQUENCE,F_PARAMID,F_PARAMNAME,F_VALUETYPE,F_EDITTYPE,F_COMBOSTR,F_DEFAULT,F_DEFAUL1) VALUES ('3',V_TEMPID,'7000','0','开始日期','0','4','','',''); INSERT INTO T_SQLPARAMS (F_SYSID,F_TEMPID,F_SEQUENCE,F_PARAMID,F_PARAMNAME,F_VALUETYPE,F_EDITTYPE,F_COMBOSTR,F_DEFAULT,F_DEFAUL1) VALUES ('3',V_TEMPID,'7000','1','结束日期','0','4','','',''); --T_SQLPARAMS------------------------------------------ --T_SQLLIST------------------------------------------ commit; end; --End---住院合理用药最新指标分区报表