--增加分类
GO
IF not EXISTS(SELECT * FROM SYS_ScriptCategories WHERE id=85)
insert into SYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)  Values(85, 'SC85', '挂号', 15, 0, 51, 0, Null)
else
print 'SYS_ScriptCategories.id=85 已经存在.'

GO


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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=1647)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(1647, 78, 'SQL_结帐票据使用情况', '结帐票据使用情况', '按结帐单据 查找结帐票据使用情况', 1, 0, Null, 1, 'SELECT b.FAB03,b.FAB08,b.BCE03 ,
   CASE b.FAB04 WHEN 1 THEN ''正常打印''
                WHEN 2 THEN ''退单回收''
                WHEN 3 THEN ''重新打印''
                WHEN 4 THEN ''补打''
                WHEN 5 THEN ''空白回收''
                WHEN 6 THEN ''报损''
   END as FAB04 ,b.FAA01,b.FAB01,b.AAK01                                
FROM V_FAC_FULL a with(nolock)
  JOIN V_FAB_FULL b with(nolock) ON a.FAC01 = b.FAC01
WHERE   (a.FAC03 = ''%s'') or  (a.FAC01 = %d)', '2017-03-08 14:55:00', '(8065)冯义强', 0)
else
print 'SYS_Scripts.id=1647 已经存在.'

GO