--增加分类
GO
IF not EXISTS(SELECT * FROM SYS_ScriptCategories WHERE id=1)
insert into SYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)  Values(1, 'SC1', 'HOMaster 基础管理', 1, 0, 0, 0, Null)
else
print 'SYS_ScriptCategories.id=1 已经存在.'

GO


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


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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=-10000)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode,Custom)  Values(-10000, 25, 'ExpandPrograms', '扩展程序', 'URL或程序', 1, 1, '', 1, '
--返回字段说明 
--FileName    要打开的程序（路径）
--Caption     显示到菜单中的名称 
--ComponentId 用于授权控制
--Code 需要用户授权的字段返回为产品管理中Code 
--Parameters 传入参数 
/*
内置变量说明 
@$UserId  	操作员ID
@$UserCode	操作员编码
@$UserName	操作员姓名

@$EmpId		员工ID
@$EmpCode	员工编码
@$EmpName	员工姓名

@$DeptId	部门ID
@$DeptCode	部门编码
@$DeptName	部门名称

@$Version	DLL版本号
@$IP		客户端IP地址
@$HostName	客户端机器名    
*/ 
 
select ''http://192.168.1.137:9999/combo/bni1?bce01=''+convert(varchar(20),@$EmpId)+''&bce03=''+@$EmpName as FileName , ''套餐管理'' as Caption  , 7401 as ComponentId , ''Other1'' as Code , '''' as Parameters 
union all
select ''MultiLanguage.exe'' as FileName , ''多语言管理'' as Caption  , 7404 as ComponentId , ''Other4'' as Code , ''HO.Plugin.MultiLang'' as Parameters', '2018-08-14 18:00:28', '(8088)王海涛', 2, Null)
else
print 'SYS_Scripts.id=-10000 已经存在.'

GO


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