--增加分类
GO
IF EXISTS(SELECT * FROM SYS_ScriptCategories WHERE id=12) 
Delete from SYS_ScriptCategories WHERE id=12
insert into SYS_ScriptCategories(ID,Code,Name,ComponentID,xRowNum,ParentID,xLevel,Description)  Values(12, 'SC12', '诊疗项目管理 ', 1, 0, 1, 0, Null)

GO


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


GO
IF EXISTS(SELECT * FROM SYS_Scripts WHERE id=26989) 
Delete from SYS_Scripts WHERE id=26989
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode,Custom,ConnectSlave)  Values(26989, 12, 'SQL_BFC1', '检验项目信息', '检验项目信息', 1, 0, Null, 1, 'select B.BBX19,B.BBX12,B.BBX11,D.BEL02,D.BEL08,B.BBX13,BFC03
,A.BBX01,B.BDA01,B.BDO01, B.BBX04,B.BBX05,A.BDG02,A.BFC03,C.BDK03,A.BFC04
,A.BFC05,A.BFC06,A.BFC07,A.BFC09,A.BFC10,A.BFC11,A.ROWNR, A.BFC13,A.BFC14
,A.BFC15,A.BFC16,A.BFC17,A.BFC18,A.BFC19,A.BFC20,A.BFC21,A.BFC22, A.BFC23
,A.BFC24,A.BFC25,A.BFC26,A.BFC27,A.BFC28,A.BFC29,A.BFC30,A.BFC31,A.BFC32
,A.BFC33,A.BFC34,A.BFC35
from BFC1 A Join BBX1 B On A.BBX01 = B.BBX01 
Join BDK1 C On C.BBX01=A.BBX01 And C.BDK06=1 
Left Join BEL1 D On D.BEL01=B.BBX19 
Where (%s) 
Order by A.BFC04', '2023-08-11 16:25:19', '(03432)乔晓钢', 0, 0, 0)

GO


If EXISTS(SELECT * from Sys_CustomScripts WHERE ID = 26989)
Update a SET a.Custom = b.Custom from SYS_Scripts a join Sys_CustomScripts b on b.ID = a.ID
where a.ID=26989
GO