--Begin-- 3*3打印格式输液卡(德化医技系统) -- 2019-07-11 08:41:40
 
declare 
  V_TEMPID  T_CTLTEMP.F_TEMPID%TYPE; 
begin 
  SELECT COUNT(*) INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='7' AND F_NAMECN='3*3打印格式输液卡(德化医技系统)';
  IF V_TEMPID =0 THEN
    SELECT nvl(MAX(F_TEMPID),0)+1 INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='7';
  ELSE
    SELECT F_TEMPID INTO V_TEMPID FROM T_CTLTEMP WHERE F_SYSID='7' AND F_NAMECN='3*3打印格式输液卡(德化医技系统)';
  END IF;
DELETE FROM T_TEMPTYPE WHERE F_SYSID='7' AND F_TYPEID='00001';
INSERT INTO T_TEMPTYPE (F_SYSID,F_TYPEID,F_TYPENAME,F_MEMO) VALUES ('7','00001','输液卡','');
-- T_TEMPTYPE ------------------------------------------
 
DELETE FROM T_CTLTEMP WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLTEMP1 WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLEDIT WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLLABEL WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLLINE WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLDATE WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLCMB WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLCURR WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLGRID WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_CTLGRIDCOL WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
DELETE FROM T_SQLPARAMS WHERE F_SYSID='7' AND F_TEMPID=V_TEMPID;
-- DELETE ------------------------------------------
 
--T_CTLTEMP------------------------------------------
 
--T_CTLTEMP1------------------------------------------
 
--T_CTLEDIT------------------------------------------
 
--T_CTLLABEL------------------------------------------
 
--T_CTLLINE------------------------------------------
 
--T_CTLDATE------------------------------------------
 
--T_CTLCMB------------------------------------------
 
--T_CTLCURR------------------------------------------
 
--T_CTLGRID------------------------------------------
 
--T_CTLGRIDCOL------------------------------------------
 
--T_SQLPARAMS------------------------------------------
 
commit; 
end; 
--End---3*3打印格式输液卡(德化医技系统)