--增加分类
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


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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=7148)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(7148, 100, 'EMR_获取手术护理信息', '获取手术护理信息', '获取手术护理信息', 1, 1, Null, 1, 'select 
  DISTINCT CONVERT(VARCHAR(10), VCF09, 120) as [Date] 
from 
  vcf1 
where 
  VAA01=%d 
  and VAA07=%d 
  and VAP01=%d 
  and ACF01=%d 
  and (VCF11 = ''02'' or VCF11 = ''03'')
  and (VCF09 BETWEEN ''%s'' and ''%s'')
order by [Date]', '2016-09-12 16:05:25', '(8088)王海涛', 0)
else
print 'SYS_Scripts.id=7148 已经存在.'

GO