删除GS平台上的东西

DLL:
Genersoft.Fms.Center.WebAPI.Model.dll
Genersoft.Fms.Center.WebAPI.ZXGL.dll
Genersoft.Fms.Center.YJGL.Interface.dll
Genersoft.Fms.Center.ZXGL.DAL.dll
Genersoft.Fms.Center.ZXGL.Model.dll
Genersoft.Fms.Center.ZXGL.ZXZMGL.dll
资信证明数据库表删除:
declare
num1 number;
num2 number;
num3 number;
num4 number;
num5 number;
num6 number;

begin
select count(1) into num1 from user_all_Tables where TABLE_NAME = 'ZXGLZXZMKCSQ';
select count(1) into num2 from user_all_Tables where TABLE_NAME = 'ZXGLZXZMKCSQMX';
select count(1) into num3 from user_all_Tables where TABLE_NAME = 'ZXGLZXZMSDSQ';
select count(1) into num4 from user_all_Tables where TABLE_NAME = 'ZXGLZXZMKC';
select count(1) into num5 from user_all_Tables where TABLE_NAME = 'ZXGLZXZMKCMX';
select count(1) into num6 from user_all_Tables where TABLE_NAME = 'ZXGLZXZMSD';
if num1=1 then
execute immediate 'drop table ZXGLZXZMKCSQ';
end if;
if num2=1 then
execute immediate 'drop table ZXGLZXZMKCSQMX';
end if;
if num3=1 then
execute immediate 'drop table ZXGLZXZMSDSQ';
end if;
if num4=1 then
execute immediate 'drop table ZXGLZXZMKC';
end if;
if num5=1 then
execute immediate 'drop table ZXGLZXZMKCMX';
end if;
if num6=1 then
execute immediate 'drop table ZXGLZXZMSD';
end if;
end;

--资信证明一二级菜单删除:
begin
delete from gspauditcategory where ID = 'FMSZXGL' and name = '资信管理';
--三级菜单GSPBIZOBJECT
delete from GSPBIZOBJECT where ID= 'ZXGL_SDZXZMGL';--资信管理下级菜单
delete from GSPBIZOBJECT where ID= 'ZXGL_KCZXZMGL';
--二级菜单GSPBIZOBJECT
delete from GSPBIZOBJECT where ID = 'FMS_ZXGL_ZXZMGL_SDZXZM';
delete from GSPBIZOBJECT where ID = 'FMS_ZXGL_ZXZMGL_KCZXZM';
delete from GSPBIZOBJECT where ID = 'FMS_ZXGL_ZXZMGL_KCZXZMCX';
delete from GSPBIZOBJECT where ID = 'FMS_ZXGL_ZXZMGL_SDZXZMCX';
delete from GSPBIZOBJECT where ID = 'FMS_ZXGL_ZXZMGL';
delete from GSPBIZOBJECT where ID = 'FMS_ZXGL';
--三级菜单gspfunc
delete from gspfunc where PARENTID = 'ZXGL_ZXZMGL';--资信管理下级菜单
--一二级菜单gspfunc
delete from gspfunc where ID = 'FMS_ZXGL';--资信管理
delete from gspfunc where ID = 'ZXGL_ZXGL';--资信管理
end;

 

posted @ 2020-06-04 15:56  泉城余文乐  Views(182)  Comments(0Edit  收藏  举报