--Begin-- 邵武妇幼入库单 -- 2009-03-19 16:44:09
 
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','邵武妇幼入库单','2008-11-13','管理员','0','0','SELECT TO_DATE(D.QRRQ00,''YYYY-MM-DD'') QRRQ00,D.RKDH00,D.ZKJE00,G.ZWXM00 CGY000, (SELECT H.CRBMMC FROM VW_YK_YPCRKDW H WHERE D.GHDWNM=H.CRBMNM) CRBMMC, (SELECT L.LBMC00 FROM BM_YPLB00 L WHERE L.LBBH00=D.LBBH00) YPLB00, (SELECT G1.ZWXM00 FROM BM_YGBM00 G1 WHERE D.QRRBH0=G1.YGBH00) QRR000, (SELECT Trim(YYQC00) FROM XT_YYXX00 WHERE FLAG00=''1'')||(SELECT Trim(M.BMMC00) FROM  BM_BMBM00 M WHERE D.YKBMBH=M.BMBH00)||''入库单'' Title0,  (SELECT SUM(ROUND(X.RKSL00*X.FPGJDJ,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00  AND SFZBYP=''Y'') ZBGJJE,  (SELECT SUM(ROUND(X.RKSL00*X.LSDJ00,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00  AND SFZBYP=''Y'') ZBLSJE,  (SELECT SUM(ROUND(X.RKSL00*X.LSDJ00,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 )  LSJE00,  (SELECT SUM(ROUND(X.RKSL00*X.FPGJDJ,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 )  GJJE00,  (SELECT SUM(ROUND(X.RKSL00*X.GJDJ00,2)) FROM YK_YPRKMX X WHERE X.RKDH00=D.RKDH00 )  SJGJJE,  (SELECT SUM(ROUND(ROUND(X.RKSL00*X.LSDJ00,2)-X.GJJE00,2)) FROM YK_YPRKMX X WHERE  X.RKDH00=D.RKDH00 ) JXCJ00  FROM YK_YPRKD0 D,BM_YGBM00 G WHERE D.CGYBH0=G.YGBH00(+) AND D.RKDH00=''0618''','0','0','1','1','','','2140','929','16777215','0','0','0','0.1','0','0','');
--T_CTLTEMP------------------------------------------
 
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1007','LABEL','Label7','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1008','LABEL','Label8','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1009','LABEL','Label9','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1010','LABEL','Label10','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1011','LABEL','Label11','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1012','LABEL','Label12','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1013','LABEL','Label13','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'1014','LABEL','Label14','');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2005','EDIT','Edit5','编辑框5');
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,'2009','EDIT','Edit9','编辑框9');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2010','EDIT','Edit10','编辑框10');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2011','EDIT','Edit11','编辑框11');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2012','EDIT','Edit12','编辑框12');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2013','EDIT','Edit13','编辑框13');
INSERT INTO T_CTLTEMP1 (F_SYSID,F_TEMPID,F_SEQUENCE,F_CONTROLTYPE,F_NAMEEG,F_NAMECN) VALUES ('3',V_TEMPID,'2014','EDIT','Edit14','编辑框14');
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,'2005','Edit5','编辑框5','QRRQ00','0','2','0','0','0','0','0','0','9','0','1','0','0','159','111','265','58','宋体','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 ('3',V_TEMPID,'2006','Edit6','编辑框6','RKDH00','0','2','0','0','0','0','0','0','9','0','1','0','0','1765','108','265','61','宋体','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 ('3',V_TEMPID,'2008','Edit8','编辑框8','XT_DAY','0','2','0','0','0','0','0','0','9','0','1','0','0','1818','852','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 ('3',V_TEMPID,'2009','Edit9','编辑框9','TITLE0','2','2','0','0','0','0','0','0','9','0','1','0','0','577','32','1109','71','宋体','1','14','-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 ('3',V_TEMPID,'2010','Edit10','编辑框10','CRBMMC','0','2','0','0','0','0','0','0','9','0','1','0','0','712','111','812','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 ('3',V_TEMPID,'2011','Edit11','编辑框11','CGY000','0','2','0','0','0','0','0','0','9','0','1','0','0','1352','852','251','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 ('3',V_TEMPID,'2012','Edit12','编辑框12','QRR000','0','2','0','0','0','0','0','0','9','0','1','0','0','945','849','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 ('3',V_TEMPID,'2013','Edit13','编辑框13','XT_PAGE','0','2','0','0','0','0','0','0','9','0','1','0','0','1797','37','111','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 ('3',V_TEMPID,'2014','Edit14','编辑框14','XT_TOTALPAGE','0','2','0','0','0','0','0','0','9','0','1','0','0','1900','37','148','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 ('3',V_TEMPID,'1007','Label7','','日期：','0','2','0','0','1','77','114','85','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 ('3',V_TEMPID,'1008','Label8','','NO:','0','2','0','0','1','1707','108','58','61','宋体','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 ('3',V_TEMPID,'1009','Label9','','主管：','0','2','0','0','1','69','839','101','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 ('3',V_TEMPID,'1010','Label10','','仓管员：','0','2','0','0','1','807','844','124','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 ('3',V_TEMPID,'1011','Label11','','采购员：','0','2','0','0','1','1228','847','124','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 ('3',V_TEMPID,'1012','Label12','','药品会计：','0','2','0','0','1','386','844','175','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 ('3',V_TEMPID,'1013','Label13','','打印日期：','0','2','0','0','1','1640','852','169','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 ('3',V_TEMPID,'1014','Label14','','供货单位：','0','2','0','0','1','553','114','164','56','宋体','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 ('3',V_TEMPID,'7000','Grid0','网格0','0','SELECT X.FPH000,X.YPMC00,X.YPGG00,X.RKDW00,X.RKSL00,X.FPGJDJ,X.GJDJ00,X.PFDJ00,X.PZWH00,y.pdxh00, X.KL0000,X.GJJE00,X.LSDJ00,X.BZ0000,X.SCCJZW,X.SCPH00,X.YPSXRQ,X.SFZBYP, ROUND(X.RKSL00*X.FPGJDJ,2) AS FPGJJE, ROUND(X.RKSL00*X.LSDJ00,2) AS LSJE00,ROUND(X.RKSL00*X.PFDJ00,2) AS PFJE00, ROUND(ROUND(X.RKSL00*X.LSDJ00,2)-X.GJJE00,2) AS JXCJ00, ROUND(ROUND(X.RKSL00*X.PFDJ00,2)-X.GJJE00,2) AS CJ0000, ROUND(X.RKSL00*X.LSDJ00,2)-ROUND(X.RKSL00*X.PFDJ00,2) AS PLCJ00  FROM YK_YPRKMX X,bm_yd0000 y  WHERE X.RKDH00=''000001''  ORDER BY X.YPRKPC','','1','17','15','16777215','-2147483643','536870911','1','45','191','2093','601','80','50','宋体','0','10','-2147483640','宋体','0','10','-2147483640','1','1','0','1','1','1','0','0','1','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','FPH000','发票号','0','124','0','1','1','2','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','PDXH00','序号','0','101','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','YPMC00','品  名','0','246','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','YPGG00','规  格','0','191','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','RKDW00','单位','2','101','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','RKSL00','数量','0','93','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','GJDJ00','购进价','1','132','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 ('3',V_TEMPID,'7000','7','GJJE00','购进金额','1','143','0','0','1','2','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 ('3',V_TEMPID,'7000','8','LSDJ00','零售价','1','132','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 ('3',V_TEMPID,'7000','9','LSJE00','零售金额','1','153','0','0','1','2','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 ('3',V_TEMPID,'7000','10','SCCJZW','生厂厂家','0','222','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','SCPH00','批号','0','159','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','12','YPSXRQ','有效期','0','138','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','13','PZWH00','批准文号','0','191','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','14','','质量情况','0','201','0','1','1','0','0','');
--T_CTLGRIDCOL------------------------------------------
 
--T_SQLPARAMS------------------------------------------
 
--T_SQLLIST------------------------------------------
 
commit; 
end; 
--End---邵武妇幼入库单