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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=6412)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(6412, 80, 'SQL_收费项目材料', '收费项目材料', '收费项目检索材料', 1, 0, Null, 1, 'DECLARE @lACF01 int, @lBDO01 int, @lSql varchar(100), @lDate Datetime,@lABC02 varchar(20),@gparam60 varchar(20) ,
  @lBDP02 varchar(20), @lBCK01 int 
SET @lBDP02 = %s   
SET @lABC02 = %s 
SET @lACF01 = %d
SET @lBDO01 = %d
SET @lSql = %s
SET @lBCK01 = %d 
Set @lDate = CONVERT(datetime, CONVERT(varchar(10), getdate(), 120)) 
set @gparam60 = dbo.GetSysParamValue(9999,9999,60) 
SELECT e.BDN01, e.BDN02,f.AAS02,case when @gparam60=''2'' then dbo.GetBBY1Price(d.BBY01,@lABC02) else d.BBY25 end BBY25
  , a.BBX01, a.BDO01, d.BBY04, d.BBY05
  , a.BDG02, NULL AS BAP02, 0 AS BBT10, 0 AS BBT11 
  , d.BBY06, d.BBE02, d.BBY01, d.BBY08
  , d.BBY08 AS NUnit,0 BCK01,NULL BCK03  , d.BBY48 
FROM BBX1 a
  JOIN BCT1 c ON a.BBX01 = c.BBX01
  JOIN BBY1 d ON c.BBY01 = d.BBY01 
  JOIN BDN1 e ON d.BDN01 = e.BDN01
  LEFT JOIN AAS1 f ON d.AAS01 = f.AAS01
WHERE ((@lBDO01>-1 AND a.BDO01 = @lBDO01)OR(@lBDO01=-1 AND a.BDA01=''4'')) 
  AND d.BBY31 >= @lDate 
  AND c.BCT33=1 
  AND ((d.BBY47 = 0) or (d.BBY47 =1 and exists(select * from BNN1 c2 where c2.BBY01 = d.BBY01 and c2.BCK01 = @lBCK01)))
  AND ((d.BBY49 = 0) or (d.BBY49 =1 and exists(select * from BNR1 c3 where c3.BBY01 = d.BBY01 and c3.BDP02 = @lBDP02)))
  AND (d.ACF01 = 3 OR d.ACF01 = @lACF01) AND (d.BBY04 LIKE @lSql OR
  (EXISTS(SELECT * FROM BCL1 g WHERE g.BBY01=d.BBY01
    AND (g.BCL03 LIKE @lSql OR g.ABBRP LIKE @lSql OR g.ABBRW LIKE @lSql))))', '2016-08-12 16:34:59', '(8088)王海涛', 0)
else
print 'SYS_Scripts.id=6412 已经存在.'

GO