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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=1527)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(1527, 82, 'SQL_OutPtDrop_Side', 'SQL_OutPtDrop_Side', '门诊病人发药_可作废病人(已做退费申请的不检索)', 2, 0, '', 1, 'SELECT DISTINCT TOP 50
  J.VAA01
  , A.VAA03
  , A.VAA05
  , J.VAI01
  , J.BCE03C
  , D.BCK03 BCK03C
  , VAJ51
  , %s     
FROM V_VAJ_1 J 
  join VAA1 A ON A.VAA01 = J.VAA01
  join BCK1 D on D.BCK01 = J.BCK01C
WHERE (J.ACF01 = 1 --1=门诊病人
  and J.VAJ25-isnull((select sum(VAJ25) VAJ25 from VBY1 V where V.VAJ01 = J.VAJ01 group by VAJ01 ),0)>0
  and J.BDN01 <= ''3''
  and J.VAJ48 > 0 --已执行ID
  and (J.VAJ05 <= 2) 
  and J.VAJ53 = 1 )
  and (J.BCK01D = %d)
  %s 
order by J.VAJ51 desc ', '2014-08-04 15:37:39', '(8088)王海涛', 0)
else
print 'SYS_Scripts.id=1527 已经存在.'

GO