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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=23)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(23, 8, 'SQL_Employees_All', Null, '查询员工信息', 1, 1, '<?xml version="1.0"?>
<Configs Ver="1"><Win HG="360" SZ="1"/><Grid RecNo="1" Head="1" UseW="1" QDB="1"><Sql>SELECT 
  E.BCE01 
  , E.BCE02 
  , E.BCE03 
  , E.BCE04 
  , E.BCE05 
  , E.ABBRP 
  , E.ABBRW 
  , K.BCK01
  , K.BCK02 
  , K.BCK03 
  , isnull(S.Code, '''') code
FROM BCE1 E join BCK1 K
  ON E.BCK01 = K.BCK01 
  LEFT JOIN SYS_Users S ON S.EmployeeID=E.BCE01
WHERE E.BCE41 = 1</Sql><HD><Ie FD="BCE02" CA="编码" WD="60" SZ="1"/><Ie FD="BCE03" CA="姓名" WD="100" SZ="1"/><Ie FD="BCK03" CA="部门" WD="100"/></HD><QF><Ie FD="E.BCE02" WE="7"/><Ie FD="E.BCE03" WE="7"/><Ie FD="E.ABBRP" WE="7"/><Ie FD="E.ABBRW" WE="7"/></QF><FF><Ie FD="BCE02" WE="7"/><Ie FD="BCE03" WE="7"/><Ie FD="ABBRP" WE="7"/><Ie FD="ABBRW" WE="7"/></FF></Grid><Tree FFUse="1"/></Configs>
', 1, 'select BCE01, BCE02, BCE03, BCE04, BCE05, BCE06, ABBRP, ABBRW,
 ABW01, ACK01, BCE11, ABQ01, BCE13, BCK01, ACP01, AAY01, ACT01, BCE18, BCE19, ABU02,
 AAD01, ABG01, BCE24, ABS01, ABI01, AAH01, BCE28, AAQ01, ABE01, BCE31, BCE32, BCE33,
 BCE34, BCE35, BCE36, BCE37, BCE38, BCE39, BCE40, BCE41, BCE42, BCE43, BCE23 ,BCE44 ,
 BCE45 , BCE46 , BCE47
 from BCE1', '2016-09-22 14:52:22', '(8065)冯义强', 0)
else
print 'SYS_Scripts.id=23 已经存在.'

GO