--Begin-- 出库单汇总 -- 2010-08-09 09:35:59
 
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='11';
INSERT INTO T_TEMPTYPE (F_SYSID,F_TYPEID,F_TYPENAME,F_MEMO) VALUES ('K','11','模板1','');
-- 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 ------------------------------------------
 
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,'11','出库单汇总','2008-12-1','陈剑锋','0','0','','0','0','1','1','','A4','2101','2971','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 ('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,'1005','LABEL','Label5','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'1006','LABEL','Label6','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'1007','LABEL','Label7','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'2002','EDIT','Edit2','编辑框2');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',V_TEMPID,'2003','EDIT','Edit3','编辑框3');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('K',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 ('K',V_TEMPID,'2002','Edit2','编辑框2','CS_开始日期','0','2','0','0','0','0','0','0','9','0','1','0','0','66','2577','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,'2003','Edit3','编辑框3','CS_结束日期','0','2','0','0','0','0','0','0','9','0','1','0','0','429','2577','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','1','0','1','445','140','717','56','宋体','00','16','-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','349','2577','71','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,'1006','Label6','','制表人:','0','2','0','0','1','974','2577','265','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,'1007','Label7','','复核人:','0','2','0','0','1','1553','2572','265','61','宋体','00','10','-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,'7000','Grid0','网格0','0','select hj0000,shbmmc,wscl,dzyh,qtcl from (select sum(hjje00)hj0000,shbmmc,sum(wscl)wscl,sum(dzyh)dzyh,sum(qtcl)qtcl  from (select hjje00,shbmmc, wscl,dzyh,qtcl  from (select sum(a.zje000)hjje00,b.shbmmc,to_char(sum(a.zje000)) wscl,''''dzyh,''''qtcl  from VW_WZ_RCKMX0 a,VW_WZ_RCK000 b where a.rckid0=b.rckid0 and b.rcklb0=''2''   and b.rckbmc<>''盘盈'' and b.kfbmbh=:仓库名称 and a.wzsxmc=''卫生材料''  and b.qrrq00>=:开始日期 and b.qrrq00<=:结束日期 group by b.shbmmc,a.wzsxmc,b.rckbmc  union  select sum(a.zje000)hjje00,b.shbmmc,'''' wscl,''''dzyh,to_char(sum(a.zje000))qtcl  from VW_WZ_RCKMX0 a,VW_WZ_RCK000 b where a.rckid0=b.rckid0 and b.rcklb0=''2''   and b.rckbmc<>''盘盈'' and b.kfbmbh=:仓库名称 and a.wzsxmc= ''其他材料''  and b.shrq00>=:开始日期 and b.shrq00<=:结束日期 group by b.shbmmc,a.wzsxmc,b.rckbmc      union select sum(a.zje000),b.shbmmc,''''wscl, to_char(sum(a.zje000))dzyh,''''qtcl from VW_WZ_RCKMX0 a,VW_WZ_RCK000 b where a.rckid0=b.rckid0 and b.rcklb0=''2'' and b.rckbmc<>''盘盈'' and b.kfbmbh=:仓库名称 and a.wzsxmc = ''低值易耗品'' and b.qrrq00>=:开始日期 and b.qrrq00<=:结束日期 group by b.shbmmc,a.wzsxmc,b.rckbmc) ) group by shbmmc   union select sum(hjje00)hj0000,''合计''shbmmc,sum(wscl)wscl,sum(dzyh)dzyh,sum(qtcl)qtcl  from (select hjje00,shbmmc, wscl,dzyh,qtcl   from (select sum(a.zje000)hjje00,b.shbmmc,to_char(sum(a.zje000)) wscl,''''dzyh,''''qtcl from VW_WZ_RCKMX0 a,VW_WZ_RCK000 b  where a.rckid0=b.rckid0 and b.rcklb0=''2''   and b.rckbmc<>''盘盈'' and b.kfbmbh=:仓库名称 and a.wzsxmc = ''卫生材料'' and b.qrrq00>=:开始日期  and b.qrrq00<=:结束日期 group by b.shbmmc,a.wzsxmc,b.rckbmc  union select sum(a.zje000)hjje00,b.shbmmc,'''' wscl,''''dzyh,to_char(sum(a.zje000))qtcl from VW_WZ_RCKMX0 a,VW_WZ_RCK000 b  where a.rckid0=b.rckid0 and b.rcklb0=''2''   and b.rckbmc<>''盘盈'' and b.kfbmbh=:仓库名称 and a.wzsxmc=''其他材料'' and b.qrrq00>=:开始日期  and b.qrrq00<=:结束日期 group by b.shbmmc,a.wzsxmc,b.rckbmc    union  select sum(a.zje000),b.shbmmc,''''wscl,to_char(sum(a.zje000))dzyh ,''''qtcl from VW_WZ_RCKMX0 a,VW_WZ_RCK000 b where a.rckid0=b.rckid0 and b.rcklb0=''2'' and b.rckbmc<>''盘盈'' and b.kfbmbh=:仓库名称 and a.wzsxmc = ''低值易耗品''  and b.qrrq00>=:开始日期 and b.qrrq00<=:结束日期 group by b.shbmmc,a.wzsxmc,b.rckbmc) ))order by hj0000','','1','1','5','-2147483633','-2147483643','536870911','1','71','302','1881','2270','80','50','宋体','0','11','-2147483640','宋体','0','10','-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,'7000','0','SHBMMC','申领科室','0','878','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 ('K',V_TEMPID,'7000','1','HJ0000','合计金额','0','265','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 ('K',V_TEMPID,'7000','4','qtcl','其他材料','0','201','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 ('K',V_TEMPID,'7000','3','DZYH','低值易耗','0','265','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 ('K',V_TEMPID,'7000','2','WSCL','卫生材料','0','265','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 ('K',V_TEMPID,'7000','0','仓库名称','0','3','208|176||设备仓库|总务科仓库','','');
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,'7000','1','开始日期','2','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,'7000','2','结束日期','2','4','','','');
--T_SQLPARAMS------------------------------------------
 
commit; 
end; 
--End---出库单汇总