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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=7790)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(7790, 33, 'Sql_出院病人出院诊断', '', '出院病人出院诊断', 1, 1, '<?xml version="1.0"?>
<Configs Ver="1"><Win WD="600" SZ="1"/><Grid Head="1" UseW="1" QDB="1"><Sql>DECLARE @lTxt varchar(100),@bdate datetime
SET @lTxt = %s
set @bdate = Getdate()
SELECT a.BAK01,a.BAK02,a.BAK05,a.BAK06,a.ABBRP,a.ABBRW,a.ABW01,isnull(b.CAM01,0)AS CAM01,a.ABX01,d.BNO03,d.BNO04
FROM BAK1 a
LEFT JOIN BEA1 b ON a.BAK01 = b.BAK01
left join BNO1 d on d.BAK02=a.BAK02
WHERE a.BAF01 in (%s) and bak17&gt;@bdate and   (a.BAK02 LIKE @lTxt OR a.BAK05 LIKE @lTxt  OR a.BAK06 LIKE @lTxt OR a.ABBRP LIKE @lTxt
   OR a.ABBRW LIKE @lTxt)</Sql><GT><Sql>SELECT a.BAK01,a.BAK02,a.BAK05,a.ABBRP,a.ABBRW,a.ABW01,isnull(b.CAM01,0)AS CAM01,a.ABX01,d.BNO03,d.BNO04
FROM BAK1 a
LEFT JOIN BEA1 b ON a.BAK01 = b.BAK01
left join BNO1 d on d.BAK02=a.BAK02
WHERE a.BAF01 in (''B'',''D'',''Z'') and a.BAH01=%s</Sql></GT><HD><Ie FD="BAK02" CA="编码" WD="60" SZ="1"/><Ie FD="BAK05" CA="疾病名称" WD="200" SZ="1"/><Ie FD="BNO03" CA="分组名称" WD="150" SZ="1"/><Ie FD="BNO04" CA="分组费用标准" WD="80" SZ="1"/></HD><QF><Ie FD="a.BAK05" WE="7"/><Ie FD="a.ABBRP" WE="7"/><Ie FD="a.BAK02" WE="7"/></QF><FF><Ie FD="0" WE="7"/></FF></Grid><Tree ID="BAH01" PID="BAH01A" LISTID="BAH03"><Sql>SELECT BAH01,BAH03,BAH01A FROM BAH1</Sql></Tree></Configs>
', 1, 'declare @bdate datetime
set @bdate = Getdate()
SELECT a.BAK01,a.BAK02,a.BAK05,a.ABBRP,a.ABBRW,a.ABW01,0 AS CAM01
FROM BAK1 a
WHERE a.BAF01 in (%s) and bak17 > @bdate and ((a.ABW01 = ''0'') OR (a.ABW01 = ''%s''))', '2016-10-24 09:28:56', '(8088)王海涛', 0)
else
print 'SYS_Scripts.id=7790 已经存在.'

GO