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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=615)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(615, 20, 'SQL_DirDayRSInfo', Null, '查询当天的挂号信息', 1, 1, Null, 1, 'select a.VAC01, a.VAC02 , a.VAA01 , a.VAA10 , a.AAU01 , a.VAC06 , a.VAC09 , a.VAC10
  , a.BAS02A , a.BDP02 , a.ABC02 , a.ABT02 , a.ACK01 , a.VAC16 , a.VAC17 , a.VAC18
  , a.VAC19 , a.VAC20 , a.VAC21 , a.AAZ02 , a.VAC23 , a.VAC24 , a.BAQ01 , a.VAC26
  , a.VAC27 , a.VAC28 , a.VAC29 , a.VAC30 , a.VAC31 , a.VAC34 , a.VAC35 , a.VAC36
  , a.VAC37 , a.BCE02 , a.BCE03B , a.VAC40 , a.VAC41 , a.VAC42 , a.VAC43 , a.VAC44
  , a.VAC45 , a.VAC46 , a.VAC57 , a.IAA01 , a.UAA01 , a.BCE03A , a.BCK01A , j.BCK02
  , case ISNULL(J.BCK03,'''') when '''' then ''所有科室''
                 else j.BCK03
    end as BCK03  , f.VAK19  , f.VAK13  , f.VAK01  , d.BDX02 
  , b.BBY01 , b.BCK01 , b.BCE01 , b.BCE03 , b.BCB02 , b.BCB03 , b.BAO02 , VAK08 
  , d.VAA03 , d.VAA05 , d.ABW01 , d.VAA10 , d.VAA02 
  , d.ABBRP , d.ABBRW , d.VAA33 , d.VAA34 , d.AAU01 , d.VAA12 , d.BDP02 
  , n.UAA03 ,d.ABJ01 , f.VAK01 , l.BBY05  , FAB03 ='''' , d.BEP06B  , f.BCE03A as OBCE03A 
  , a.VAC70 , a.BAK05 , a.VAC72 , f.VAK18 , f.PARTS , v.VCJ15  , d.VAA35 , d.VAA37 , g.BNS02  
FROM VAC1 a with(nolock)
  JOIN BCB1 b On a.BCB01A = b.BCB01 
  JOIN BBY1 l on b.BBY01 = l.BBY01 
  LEFT JOIN BCK1 j ON a.BCK01A = J.BCK01
  Join V_VAK_FULL f with(nolock) On a.VAC01 = f.VAA07
  Join VAA1 d with(nolock) On a.VAA01 = d.VAA01  
  Left JOIN UAA1 n on a.UAA01 = n.UAA01 
  JOIN VCJ1 v with(nolock) on v.VAA07 = a.VAC01
  Left JOIN BNS1 g on g.BNS01 = a.VAC06
where f.VAK06 = 1 and SFLAG = 0  

', '2016-07-29 09:48:19', '(8065)冯义强', 0)
else
print 'SYS_Scripts.id=615 已经存在.'

GO