--增加分类
GO
IF EXISTS(SELECT * FROM SYS_ScriptCategories WHERE id=238) 
Delete from SYS_ScriptCategories WHERE id=238
insert into SYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)  Values(238, 'TOESB', '对接ESB通用转发接口', 1, 0, 158, 0, Null)

GO


--删除旧记录
delete from SYS_Scripts where id=20162 --删除脚本内容
GO


GO
IF EXISTS(SELECT * FROM SYS_Scripts WHERE id=20162) 
Delete from SYS_Scripts WHERE id=20162
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode,Custom,ConnectSlave)  Values(20162, 238, 'Sql_Params', 'Sql_Params', '用户操作界面后调用ESB地址', 1, 0, Null, 1, 'select
   '''' Url
  ,''RCYY'' ETLCode
  ,''0'' CompType --默认Indy方式 0-Indy方式 1-ICS方式
  ,''0'' ASync --默认同步方式 0-同步 1-异步
  ,30 TimeOut --超时时间（秒） ', '2021-09-29 10:56:32', '(01251)汪作鹏', 0, 0, 0)

GO


If EXISTS(SELECT * from Sys_CustomScripts WHERE ID = 20162)
Update a SET a.Custom = b.Custom from SYS_Scripts a join Sys_CustomScripts b on b.ID = a.ID
where a.ID=20162
GO