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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=7163)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(7163, 100, 'EMR_获取护理入院日期', '', '获取护理入院日期和出院日期', 1, 1, Null, 1, 'DECLARE @VAE01 Int = %d, @VAP01 INT = %d, @InDate datetime, @OutDate datetime, @ZInDate datetime, @ZOutDate datetime
IF Object_id(''tempdb..#VCF09'') IS NOT NULL DROP TABLE #VCF09
select VCF09,VCF11 into #VCF09 from VCF1 with(nolock) WHERE VAA07=@VAE01 AND ACF01=2 and VAP01=@VAP01 order by VCF09
SELECT top 1 @OutDate=VCF09 FROM #VCF09 WHERE (VCF11=''06'' OR VCF11=''07'') order by VCF09 
SELECT top 1 @InDate=VCF09 from #VCF09 WHERE  VCF11=''01'' order by VCF09
SELECT top 1 @ZInDate=VCF09 from #VCF09 WHERE  VCF11=''04'' order by VCF09
SELECT top 1 @ZOutDate=VCF09 from #VCF09 WHERE  VCF11=''08'' order by VCF09
IF Object_id(''tempdb..#VCF09'') IS NOT NULL DROP TABLE #VCF09

if @InDate is null
	if @VAP01>0
	select @InDate = VAP07 from VAP1 where VAP01=@VAP01
	else
	select @InDate = VAE11 from VAE1 with(nolock) where VAE01 = @VAE01
if @OutDate is null
	select @OutDate = VAE26 from VAE1 with(nolock) where VAE01 = @VAE01

if @ZOutDate is not null and @ZInDate is not null and dbo.GetSysParamValue(600,0,67)=''True''
begin
	SELECT @InDate AS VCF09, @ZOutDate as OutDate 
	union all
	SELECT @ZInDate AS VCF09, @OutDate as OutDate 
end
else
SELECT @InDate AS VCF09, @OutDate as OutDate 
', '2016-09-19 15:03:33', '(8088)王海涛', 0)
else
print 'SYS_Scripts.id=7163 已经存在.'

GO