--增加分类
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=2021 --删除脚本内容
GO


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=2021)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode,Custom)  Values(2021, 32, 'Sql_门诊首页诊断记录', Null, '门诊首页诊断记录  FSign 0 =新增; 1 = 不变 2 ＝ 修改  3 ＝ 删除', 1, 0, Null, 1, 'SELECT cast(1 as tinyint) FSign,a.VAO01,isnull(a.VAF01,0) VAF01,a.VAO15,a.VAO07
  ,a.VAO11,a.VAO18,a.BAK01A,b.CAM01,a.VAO22,b.CAM04,a.BGP01,d.BGP02,a.ADY01,e.ADY02,c.BAK02
  ,a.BAK01B,a.VAO26,c1.BAK02 BAK02B,a.IAD03,a.IAD04,a.IAD01,a.IAA01
FROM VAO1 a
left JOIN CAM1 b ON b.CAM01 = a.CAM01
left join BAK1 c on c.BAK01 = a.BAK01A
left join BGP1 d on d.BGP01 = a.BGP01
left join ADY1 e on e.ADY01 = a.ADY01
left join BAK1 c1 on c1.BAK01 = a.BAK01B
WHERE a.ACF01 = 1 AND a.VAO11 = 1 and a.VAO22 <= 1 AND a.VAA07 = %d
order by a.VAF01, a.VAO06', '2018-09-19 10:40:06', '(8058)高瑜', 0, 0)
else
print 'SYS_Scripts.id=2021 已经存在.'

GO


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