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


GO
IF not EXISTS(SELECT * FROM SYS_Scripts WHERE id=10195)
insert into SYS_Scripts(ID,CategoryID,Code,Name,Description,xType,DatasourceID,DisplayNames,xRowNum,xText,UpdateDate,UpdateUser,UpdateMode)  Values(10195, 121, 'SQL_PatientInto', '检索病人信息', '检索病人信息', 1, 1, '<?xml version="1.0"?>
<Configs Ver="1"><Win WD="600" SZ="1"/><Grid Head="1"><Sql>select a.VAA01, VAA02, VAA03, VAA04, VAA05, VAA06, a.ABBRP, a.ABBRW, a.ABW01, VAA10, a.AAU01, VAA12,
   ACK01, VAA14, VAA15, VAA16, ABJ01, a.BDP02, ABC02, VAA20, ACM02, a.ACC02, a.ABQ02, VAA25, VAA26, 
  VAA27, VAA28, VAA29, VAA30, VAA31, VAA32, VAA33, VAA34, VAA35, VAA36, VAA37, VAA38, VAA39,
 VAA40, VAA41, VAA42, VAA43, VAA44, BAQ01, BAQ02, VAA47, VAA48, VAA49, VAA50, VAA51, VAA52, 
VAA53, VAA54, VAA55, VAA56, VAA57, BCK01A, VAA61, VAA62, BDX02, VAA64, a.VBU01, VAA66, VAA67,
 IAK05, IAA01, BCK01B, BCK01C, BCQ04, VAA73, VAA74, VAA75, BEP05, BEP06, ABL01A, ABL01B, VAA76,
ABL01, BEP06B, VAA78 ,a.AAT02,
  case a.ABW01 when ''0'' then ''未知''
                         when ''1'' then ''男''
                         when ''2'' then ''女''
  end as ABW02 , b.SCA01 
from VAA1 a
  left join SCA1 b on b.VAA01 = a.VAA01</Sql><HD><Ie FD="VAA05" CA="姓名" WD="50" SZ="1"/><Ie FD="VAA03" CA="门诊号" WD="50" SZ="1"/><Ie FD="VAA04" CA="住院号" WD="50" SZ="1"/><Ie FD="ABW02" CA="性别" WD="10" SZ="1"/><Ie FD="VAA10" CA="年龄" WD="10" SZ="1"/><Ie FD="VAA35" CA="手机号" WD="50" SZ="1"/><Ie FD="VAA15" CA="身份证号" WD="100" SZ="1"/><Ie FD="VAA75" CA="建档时间" WD="50" SZ="1"/></HD><QF><Ie FD="VAA05" WE="7"/><Ie FD="a.ABBRP" WE="7"/><Ie FD="a.ABBRW" WE="7"/><Ie FD="VAA03" WE="7"/><Ie FD="VAA04" WE="7"/><Ie FD="VAA35" WE="7"/></QF></Grid></Configs>
', 1, Null, '2015-10-29 14:04:29', '(998)黄海峰', 0)
else
print 'SYS_Scripts.id=10195 已经存在.'

GO