--Begin-- 出库月统计报表(器械) -- 2009-06-02 15:17:36
 
declare 
  V_TEMPID  T_CTLTEMP.F_TEMPID%TYPE; 
begin 
  SELECT COUNT(*) INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='K' AND F_NAMECN='出库月统计报表(器械)';
  IF V_TEMPID =0 THEN
    SELECT nvl(MAX(F_TEMPID),0)+1 INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='K';
  ELSE
    SELECT F_TEMPID INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='K' AND F_NAMECN='出库月统计报表(器械)';
  END IF;
DELETE FROM T_TEMPTYPE WHERE F_SYSID='K' AND F_TYPEID='001';
INSERT INTO T_TEMPTYPE (F_SYSID,F_TYPEID,F_TYPENAME,F_MEMO) VALUES ('K','001','库存自定义','');
-- T_TEMPTYPE ------------------------------------------
 
DELETE FROM T_CTLTEMP WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLTEMP1 WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLEDIT WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLLABEL WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLLINE WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLDATE WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLCMB WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLCURR WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLGRID WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLGRIDCOL WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_SQLPARAMS WHERE F_SYSID='K' AND F_TEMPID=V_TEMPID;
DELETE FROM T_SQLLIST WHERE F_SYSID='K' 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 ('K',V_TEMPID,'001','出库月统计报表(器械)','2006-11-14','9999','0','0','select Z.SHBMMC, SUM(DECODE(Trim(X.WZSXMC),''低值易耗'',ROUND(X.CGJ000*X.CRKSL0,2),0)) DZYHHJ, SUM(DECODE(Trim(X.WZSXMC),''卫生材料'',ROUND(X.CGJ000*X.CRKSL0,2),0)) WSCLHJ, SUM(DECODE(Trim(X.WZSXMC),''其他材料'',ROUND(X.CGJ000*X.CRKSL0,2),0)) QTCLSJ, SUM(DECODE(Trim(X.WZSXMC),''加工材料'',ROUND(X.CGJ000*X.CRKSL0,2),0)) JGCLGJ, SUM(Z.RCKLB0)/2 PJS000 from WZ_RCK000 Z,WZ_RCKMX0 X WHERE Z.RCKID0=X.RCKID0 AND Z.RCKLB0=''2'' AND Z.QRRQ00>=:起始日期 AND Z.QRRQ00<=:终止日期 AND Z.KFBMBH=:仓库名称 GROUP BY Z.SHBMMC','0','0','1','1','','Tabloid','2794','2998','16777215','0','0','0','0.1','0','1','0');
--T_CTLTEMP------------------------------------------
 
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'1000','LABEL','Label0','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'1001','LABEL','Label1','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'1005','LABEL','Label5','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'2000','EDIT','Edit0','编辑框0');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'2001','EDIT','Edit1','编辑框1');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'7002','GRID','Grid2','网格2');
--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 ('K',V_TEMPID,'2000','Edit0','编辑框0','CS_起始日期','0','2','0','0','0','0','0','0','9','0','1','0','0','532','71','265','56','宋体','0','10','-2147483640','','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 ('K',V_TEMPID,'2001','Edit1','编辑框1','CS_终止日期','0','2','0','0','0','0','0','0','9','0','1','0','0','1069','69','265','56','宋体','0','10','-2147483640','','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 ('K',V_TEMPID,'1000','Label0','','起始日期','0','2','0','0','1','312','71','212','56','宋体','00','10','-2147483640','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 ('K',V_TEMPID,'1001','Label1','','终止日期','0','2','0','0','1','889','69','177','56','宋体','00','10','-2147483640','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 ('K',V_TEMPID,'1005','Label5','','器械库月统计报表','0','2','0','0','1','699','16','654','45','宋体','00','14','-2147483640','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 ('K',V_TEMPID,'7002','Grid2','网格2','0','select * from (select Z.SHBMMC, SUM(DECODE(Trim(X.WZSXMC),''低值材料'', ROUND(X.CGJ000*X.CRKSL0,2),0)) DZYHHJ,SUM(DECODE(Trim(X.WZSXMC),''卫生材料'',ROUND(X.CGJ000*X.CRKSL0,2),0)) WSCLHJ, SUM(DECODE(Trim(X.WZSXMC),''其他材料'',ROUND(X.CGJ000*X.CRKSL0,2),0)) QTCLSJ, SUM(DECODE(Trim(X.WZSXMC),''加工材料'',ROUND(X.CGJ000*X.CRKSL0,2),0)) JGCLGJ, SUM(DECODE(Trim(X.WZSXMC),''高值材料'',ROUND(X.CGJ000*X.CRKSL0,2),0)) GZCLHJ, SUM(DECODE(Trim(X.WZSXMC),''仪器设备'',ROUND(X.CGJ000*X.CRKSL0,2),0)) YQSBHJ,  SUM(DECODE(substr(B.wzdmbm,1,3),''101'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB101, SUM(DECODE(substr(B.wzdmbm,1,3),''102'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB102, SUM(DECODE(substr(B.wzdmbm,1,3),''103'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB103, SUM(DECODE(substr(B.wzdmbm,1,3),''104'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB104, SUM(DECODE(substr(B.wzdmbm,1,3),''105'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB105, SUM(DECODE(substr(B.wzdmbm,1,3),''106'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB106, SUM(DECODE(substr(B.wzdmbm,1,3),''107'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB107, SUM(DECODE(substr(B.wzdmbm,1,3),''201'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB201, SUM(DECODE(substr(B.wzdmbm,1,3),''202'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB202, SUM(DECODE(substr(B.wzdmbm,1,3),''203'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB203, SUM(DECODE(substr(B.wzdmbm,1,3),''204'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB204, SUM(DECODE(substr(B.wzdmbm,1,3),''301'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB301, SUM(DECODE(substr(B.wzdmbm,1,3),''302'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB302, SUM(DECODE(substr(B.wzdmbm,1,3),''303'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB303, SUM(DECODE(substr(B.wzdmbm,1,3),''304'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB304, SUM(DECODE(substr(B.wzdmbm,1,3),''305'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB305, SUM(DECODE(substr(B.wzdmbm,1,3),''306'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB306, SUM(DECODE(substr(B.wzdmbm,1,3),''307'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB307, SUM(DECODE(substr(B.wzdmbm,1,3),''308'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB308, SUM(DECODE(substr(B.wzdmbm,1,3),''309'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB309, SUM(DECODE(substr(B.wzdmbm,1,3),''401'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB401, SUM(DECODE(substr(B.wzdmbm,1,3),''501'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB501, SUM(DECODE(substr(B.wzdmbm,1,3),''502'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB502, SUM(DECODE(substr(B.wzdmbm,1,3),''601'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB601, SUM(DECODE(substr(B.wzdmbm,1,3),''602'',ROUND(X.CGJ000*X.CRKSL0,2),0)) FLB602,  SUM(ROUND(X.CGJ000*X.CRKSL0,2)) HJ0000, SUM(Z.RCKLB0)/2 PJS000 from  WZ_RCK000 Z,WZ_RCKMX0 X,bm_wzdm00 B,bm_wzyjfl A ,bm_bmbm00 C WHERE Z.RCKID0=X.RCKID0  and substr(B.wzdmbm,1,3)=trim(A.yjflbh)and X.wzdmid=B.wzdmid  AND Z.RCKLB0=''2'' and   trim(z.shbmmc)=trim(C.bmmc00) AND Z.QRRQ00>=:起始日期 AND Z.QRRQ00<=:终止日期 AND Z.KFBMBH=:仓库名称 GROUP BY Z.SHBMMC )M ,bm_bmbm00bak N where trim(M.shbmmc)=trim(N.bmmc00) order by N.bmxz00 desc','','3','1','31','16777215','-2147483643','536870911','1','48','191','2000','2500','100','85','宋体','0','11','-2147483640','宋体','0','11','-2147483640','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 ('K',V_TEMPID,'7002','0','SHBMMC','科室','0','257','0','1','1','0','1','');
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 ('K',V_TEMPID,'7002','30','HJ0000','合计:','0','315','0','1','1','0','2','');
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 ('K',V_TEMPID,'7002','2','FLB102','办公用品','0','370','0','0','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 ('K',V_TEMPID,'7002','3','FLB103','棉织品','0','405','0','0','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 ('K',V_TEMPID,'7002','4','FLB104','其他用品','0','370','0','0','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 ('K',V_TEMPID,'7002','5','FLB105','一次性医用耗材','0','415','0','0','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 ('K',V_TEMPID,'7002','6','FLB106','安全消防器材','0','341','0','0','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 ('K',V_TEMPID,'7002','7','FLB107','办公家具','0','405','0','0','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 ('K',V_TEMPID,'7002','8','FLB201','一次性材料','0','270','0','1','1','0','2','');
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 ('K',V_TEMPID,'7002','9','DZYHHJ','低值材料','0','315','0','0','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 ('K',V_TEMPID,'7002','10','FLB201+FLB203','卫生材料','0','384','0','0','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 ('K',V_TEMPID,'7002','11','GZCLHJ','高值材料','0','315','0','0','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 ('K',V_TEMPID,'7002','12','FLB202','化学试剂','0','296','0','1','1','0','2','');
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 ('K',V_TEMPID,'7002','13','FLB203+401','医用材料','0','299','0','1','1','0','2','');
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 ('K',V_TEMPID,'7002','14','FLB204','其他卫生材料','0','275','0','1','1','0','2','');
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 ('K',V_TEMPID,'7002','15','FLB301','布匹','0','341','0','0','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 ('K',V_TEMPID,'7002','16','FLB302','办公用品','0','405','0','0','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 ('K',V_TEMPID,'7002','17','FLB303','劳保用品','0','323','0','0','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 ('K',V_TEMPID,'7002','18','FLB304','清洁工具','0','405','0','0','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 ('K',V_TEMPID,'7002','19','FLB305','燃料','0','415','0','0','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 ('K',V_TEMPID,'7002','20','FLB306','后勤维修','0','415','0','0','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 ('K',V_TEMPID,'7002','21','FLB307','医疗设备维修','0','415','0','0','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 ('K',V_TEMPID,'7002','22','FLB308','印刷品','0','405','0','0','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 ('K',V_TEMPID,'7002','23','FLB309','其他用品','0','423','0','0','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 ('K',V_TEMPID,'7002','24','FLB401','齿科材料','0','415','0','0','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 ('K',V_TEMPID,'7002','25','FLB501','高值耗材','0','344','0','0','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 ('K',V_TEMPID,'7002','26','FLB502','高值医疗器械','0','423','0','0','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 ('K',V_TEMPID,'7002','27','FLB601','医疗设备','0','415','0','0','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 ('K',V_TEMPID,'7002','28','FLB602','普通设备','0','415','0','0','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 ('K',V_TEMPID,'7002','29','PJS000','票据数','0','415','0','0','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 ('K',V_TEMPID,'7002','1','FLB101+FLB501','医疗用品','0','278','0','1','1','0','2','');
--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 ('K',V_TEMPID,'0','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 ('K',V_TEMPID,'0','1','终止日期','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 ('K',V_TEMPID,'0','2','仓库名称','0','0','','','');
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 ('K',V_TEMPID,'7002','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 ('K',V_TEMPID,'7002','1','终止日期','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 ('K',V_TEMPID,'7002','2','仓库名称','0','0','','','');
--T_SQLPARAMS------------------------------------------
 
--T_SQLLIST------------------------------------------
 
commit; 
end; 
--End---出库月统计报表(器械)