--删除旧记录
--delete from Report_Objects where Code='HO.ops.000003' --删除脚本内容
IF not EXISTS(SELECT * FROM Report_Objects WHERE code='HO.ops.000003')
begin --插入
Declare @Report_Id_1163 int
Exec Core_NewId 'Report_Objects', 'id', @Report_Id_1163 out
Declare @Report_Id_1163_CateID int
Set @Report_Id_1163_CateID = (select id from Report_Categories where code='HIS.18')
insert into Report_Objects(ID,Code,Name,Description,Password,CategoryID,xType,Classification,ProductID,ProgramID,ElementID,CreateDate,UpdateDate,ISSUANCEDATE,Config,SetupPath,IsMenu,Enabled,GroupName,Authorized,RefreshInterval) Values(@Report_Id_1163, 'HO.ops.000003', '手术工作站过滤查询', Null, Null, @Report_Id_1163_CateID, 1, 4, 100, 0, Null, '2013-07-19 11:12:21', '2013-07-19 11:12:21', Null, '
B789C27DEE07FE3DD94FCBFED7A4DB9Edeclare @lBCK01 int,
@lMember tinyint,
@aDate datetime ,
@VAA01 int
set @lBCK01 = :BCK01
set @lMember = :Member
set @aDate = :dt1
set @VAA01=:VAA01
--说明:上面两个参数及名称是固定的不能修改,其他条件可以随意加,包括下面的字段也不能改变只能增加不能减少
IF object_id(''tempdb..#tmp_VAT'') IS NOT NULL DROP TABLE #tmp_VAT
IF object_id(''tempdb..#tmp_VAF1'') IS NOT NULL DROP TABLE #tmp_VAF1
IF object_id(''tempdb..#tmp_VAF2'') IS NOT NULL DROP TABLE #tmp_VAF2
SELECT a.VAT01 , a.VAT04 , a.BEE01 , a.BEE03 ,a.VAT33 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , a.VAT08,a.VAT09,a.VAF01,a.VCY01
, ( select Case when MAX(Feeflag)>0 then 1 else 0 end as Feeflag from
(select top 1 1 as Feeflag from VAI1 T2 where t2.VAA01=a.VAA01 and T2.VAI16<2 and T2.CBM01=a.vat01 and T2.VAI18>=5
union all
select top 1 1 as Feeflag from VAI2 T2 where t2.VAA01=a.VAA01 and T2.VAI16<2 and T2.CBM01=a.vat01 and T2.VAI18>=5 ) t3
) as Feeflag
into #tmp_VAT
FROM VAT1 a with(nolock)
where a.VAT04 <= 4 and a.VAT08 >= @aDate and (a.VAA01=@VAA01 or @VAA01=0)
select v.bda01,v.vaf35,v.VAF22,v.BCE03A,v.VAF01,v.CBM01,v.BBX01,v.BCK01A,v.BCK01B,V.BCK01D,v.VAF01A,v.VAA01,v.VAF06,v.VAF47,v.VAF23,v.BCE01A into #tmp_VAF1
from VAF1 v with(nolock)
where v.VAF47 >= @aDate and v.VAF10 >=8 and v.VAF10 <= 9 and (v.bck01b=@lBCK01 or v.bck01d=@lBCK01) and (v.VAA01=@VAA01 or @VAA01=0)
select v.bda01,v.vaf35,v.VAF22,v.BCE03A,v.VAF01,v.CBM01,v.BBX01,v.BCK01A,v.BCK01B,V.BCK01D,v.VAF01A,v.VAA01,v.VAF06,v.VAF47,v.VAF23,v.BCE01A into #tmp_VAF2
from VAF2 v with(nolock)
where v.VAF47 >= @aDate and v.VAF10 >=8 and v.VAF10 <= 9 and (v.bck01b=@lBCK01 or v.bck01d=@lBCK01) and (v.VAA01=@VAA01 or @VAA01=0)
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
,a.VAT33 ,d.BCQ04B ,f.BAK05 ,((case when v.VAF35 = 1 then ''(紧急)'' else '''' end)+isnull(g.BBX05,v.VAF22)) BBX05
, m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , d.VAE44,a.VAT08,v.BCE03A,v.VAF01,v.CBM01,a.VAT09,isnull(b.VBU01,0) VBU01
,v.BCE01A,k.BCE01 BCE01C,a.FeeFlag
FROM #tmp_VAT a
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
JOIN VAE1 d with(nolock) ON a.VAA07 = d.VAE01
JOIN #tmp_VAF2 v with(nolock) ON a.VAF01 = v.VAF01
left JOIN BBX1 g with(nolock) ON v.BBX01 = g.BBX01
LEFT JOIN BCK1 n with(nolock) ON v.BCK01A = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO2 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
LEFT JOIN BCE1 k with(nolock) on k.BCE02=d.BCE02C
where a.VAT04 <= 4 and a.ACF01 = 2 and d.VAE44 >= 1 and d.VAE44<= 5 and a.VAT08 >= @aDate
and v.BCK01B = @lBCK01
union all
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
,a.VAT33 ,d.BCQ04B ,f.BAK05 ,((case when v.VAF35 = 1 then ''(紧急)'' else '''' end)+isnull(g.BBX05,v.VAF22)) BBX05
, m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , d.VAE44,a.VAT08,v.BCE03A,v.VAF01,v.CBM01,a.VAT09,isnull(b.VBU01,0) VBU01
,v.BCE01A,k.BCE01 BCE01C,a.FeeFlag
FROM #tmp_VAT a
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
JOIN VAE1 d with(nolock) ON a.VAA07 = d.VAE01
JOIN #tmp_VAF2 v with(nolock) ON a.VAF01 = v.VAF01
left JOIN BBX1 g with(nolock) ON v.BBX01 = g.BBX01
LEFT JOIN BCK1 n with(nolock) ON v.BCK01A = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO2 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
LEFT JOIN BCE1 k with(nolock) on k.BCE02=d.BCE02C
where a.VAT04 <= 4 and a.ACF01 = 2 and d.VAE44 >= 1 and d.VAE44<= 5 and a.VAT08 >= @aDate
and v.BCK01B <> @lBCK01 and exists(select vaf01 from #tmp_VAF2 v1 where v1.VAF01A = v.VAF01 and v1.BCK01B = @lBCK01)
Union All
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA03 VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
,a.VAT33 ,BCQ04B='''' ,f.BAK05 , g.BBX05 , m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , VAE44 = 0 ,a.VAT08,v.BCE03A,v.VAF01,v.CBM01,a.VAT09 ,isnull(b.VBU01,0) VBU01
,v.BCE01A,v.BCE01A BCE01C,a.FeeFlag
FROM #tmp_VAT a
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
JOIN VAC1 d with(nolock) ON a.VAA07 = d.VAC01
JOIN #tmp_VAF1 v ON a.VAF01 = v.VAF01
JOIN BBX1 g with(nolock) ON v.BBX01 = g.BBX01
LEFT JOIN BCK1 n with(nolock) ON v.BCK01A = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO1 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
where a.VAT04 <= 4 and a.ACF01 = 1 and a.VAT08 >= @aDate
and (v.BCK01B = @lBCK01 or exists(select vaf01 from #tmp_VAF1 v1 where v1.VAF01A = v.VAF01 and v1.BCK01B = @lBCK01))
and exists(select * from VAI1 s where v.CBM01 = s.CBM01 and ((s.VAI18 = 4) or (@lMember >= 1 and s.VAI18 <= 3) ))
UNION ALL
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA03 VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
, a.VAT33 ,BCQ04B='''' ,f.BAK05 , '''' , m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , VAE44 = 0 ,a.VAT08,g.BCE03,0,g.CBM01,a.VAT09,isnull(b.VBU01,0) VBU01
,g.BCE01,g.BCE01 as BCE01C ,a.FeeFlag
FROM #tmp_VAT a
JOIN CBM1 g with(nolock) ON a.VAT01 = g.CBM01
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
LEFT JOIN BCK1 n with(nolock) ON g.BCK01B = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO1 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
WHERE a.VAT04 <= 4 AND a.VAT08 >= @aDate AND a.BCK01 = @lBCK01
AND a.VCY01 > 0 AND a.VAA07 > 0
IF object_id(''tempdb..#tmp_VAT'') IS NOT NULL DROP TABLE #tmp_VAT
IF object_id(''tempdb..#tmp_VAF1'') IS NOT NULL DROP TABLE #tmp_VAF1
IF object_id(''tempdb..#tmp_VAF2'') IS NOT NULL DROP TABLE #tmp_VAF2<?xml version="1.0"?>
<Configs Ver="1"><Win SZ="1"/><Grid UseW="1"><Sql>select * from BCK1 where exists(select * from BAZ1 where BCK01=BCK1.BCK01 and BAU01=''03'')</Sql><HD><Ie FD="BCK03" WD="100"/></HD><QF><Ie FD="BCK01" WE="7"/><Ie FD="BCK02" WE="7"/><Ie FD="BCK03" WE="7"/><Ie FD="ABBRP" WE="7"/></QF></Grid></Configs>0=否
1=是<?xml version="1.0"?>
<Configs Ver="1"><Win SZ="1"/><Grid Head="1" UseW="1"><Sql>select VAA01,VAA03,VAA04,VAA05,ABBRP from VAA1 a where exists(select * from VAT1 where VAA01=a.VAA01)</Sql><HD><Ie FD="VAA03" CA="门诊号" WD="100"/><Ie FD="VAA04" CA="住院号" WD="100"/><Ie FD="VAA05" CA="姓名" WD="100"/><Ie FD="abbrp" CA="拼音码" WD="100"/></HD><QF><Ie FD="VAA03" WE="7"/><Ie FD="VAA04" WE="7"/><Ie FD="VAA05" WE="7"/><Ie FD="ABBRP" WE="7"/></QF></Grid></Configs>
', Null, 0, 1, Null, 0, Null)
end
else --更新
begin
update Report_Objects set Config='
B789C27DEE07FE3DD94FCBFED7A4DB9Edeclare @lBCK01 int,
@lMember tinyint,
@aDate datetime ,
@VAA01 int
set @lBCK01 = :BCK01
set @lMember = :Member
set @aDate = :dt1
set @VAA01=:VAA01
--说明:上面两个参数及名称是固定的不能修改,其他条件可以随意加,包括下面的字段也不能改变只能增加不能减少
IF object_id(''tempdb..#tmp_VAT'') IS NOT NULL DROP TABLE #tmp_VAT
IF object_id(''tempdb..#tmp_VAF1'') IS NOT NULL DROP TABLE #tmp_VAF1
IF object_id(''tempdb..#tmp_VAF2'') IS NOT NULL DROP TABLE #tmp_VAF2
SELECT a.VAT01 , a.VAT04 , a.BEE01 , a.BEE03 ,a.VAT33 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , a.VAT08,a.VAT09,a.VAF01,a.VCY01
, ( select Case when MAX(Feeflag)>0 then 1 else 0 end as Feeflag from
(select top 1 1 as Feeflag from VAI1 T2 where t2.VAA01=a.VAA01 and T2.VAI16<2 and T2.CBM01=a.vat01 and T2.VAI18>=5
union all
select top 1 1 as Feeflag from VAI2 T2 where t2.VAA01=a.VAA01 and T2.VAI16<2 and T2.CBM01=a.vat01 and T2.VAI18>=5 ) t3
) as Feeflag
into #tmp_VAT
FROM VAT1 a with(nolock)
where a.VAT04 <= 4 and a.VAT08 >= @aDate and (a.VAA01=@VAA01 or @VAA01=0)
select v.bda01,v.vaf35,v.VAF22,v.BCE03A,v.VAF01,v.CBM01,v.BBX01,v.BCK01A,v.BCK01B,V.BCK01D,v.VAF01A,v.VAA01,v.VAF06,v.VAF47,v.VAF23,v.BCE01A into #tmp_VAF1
from VAF1 v with(nolock)
where v.VAF47 >= @aDate and v.VAF10 >=8 and v.VAF10 <= 9 and (v.bck01b=@lBCK01 or v.bck01d=@lBCK01) and (v.VAA01=@VAA01 or @VAA01=0)
select v.bda01,v.vaf35,v.VAF22,v.BCE03A,v.VAF01,v.CBM01,v.BBX01,v.BCK01A,v.BCK01B,V.BCK01D,v.VAF01A,v.VAA01,v.VAF06,v.VAF47,v.VAF23,v.BCE01A into #tmp_VAF2
from VAF2 v with(nolock)
where v.VAF47 >= @aDate and v.VAF10 >=8 and v.VAF10 <= 9 and (v.bck01b=@lBCK01 or v.bck01d=@lBCK01) and (v.VAA01=@VAA01 or @VAA01=0)
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
,a.VAT33 ,d.BCQ04B ,f.BAK05 ,((case when v.VAF35 = 1 then ''(紧急)'' else '''' end)+isnull(g.BBX05,v.VAF22)) BBX05
, m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , d.VAE44,a.VAT08,v.BCE03A,v.VAF01,v.CBM01,a.VAT09,isnull(b.VBU01,0) VBU01
,v.BCE01A,k.BCE01 BCE01C,a.FeeFlag
FROM #tmp_VAT a
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
JOIN VAE1 d with(nolock) ON a.VAA07 = d.VAE01
JOIN #tmp_VAF2 v with(nolock) ON a.VAF01 = v.VAF01
left JOIN BBX1 g with(nolock) ON v.BBX01 = g.BBX01
LEFT JOIN BCK1 n with(nolock) ON v.BCK01A = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO2 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
LEFT JOIN BCE1 k with(nolock) on k.BCE02=d.BCE02C
where a.VAT04 <= 4 and a.ACF01 = 2 and d.VAE44 >= 1 and d.VAE44<= 5 and a.VAT08 >= @aDate
and v.BCK01B = @lBCK01
union all
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
,a.VAT33 ,d.BCQ04B ,f.BAK05 ,((case when v.VAF35 = 1 then ''(紧急)'' else '''' end)+isnull(g.BBX05,v.VAF22)) BBX05
, m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , d.VAE44,a.VAT08,v.BCE03A,v.VAF01,v.CBM01,a.VAT09,isnull(b.VBU01,0) VBU01
,v.BCE01A,k.BCE01 BCE01C,a.FeeFlag
FROM #tmp_VAT a
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
JOIN VAE1 d with(nolock) ON a.VAA07 = d.VAE01
JOIN #tmp_VAF2 v with(nolock) ON a.VAF01 = v.VAF01
left JOIN BBX1 g with(nolock) ON v.BBX01 = g.BBX01
LEFT JOIN BCK1 n with(nolock) ON v.BCK01A = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO2 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
LEFT JOIN BCE1 k with(nolock) on k.BCE02=d.BCE02C
where a.VAT04 <= 4 and a.ACF01 = 2 and d.VAE44 >= 1 and d.VAE44<= 5 and a.VAT08 >= @aDate
and v.BCK01B <> @lBCK01 and exists(select vaf01 from #tmp_VAF2 v1 where v1.VAF01A = v.VAF01 and v1.BCK01B = @lBCK01)
Union All
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA03 VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
,a.VAT33 ,BCQ04B='''' ,f.BAK05 , g.BBX05 , m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , VAE44 = 0 ,a.VAT08,v.BCE03A,v.VAF01,v.CBM01,a.VAT09 ,isnull(b.VBU01,0) VBU01
,v.BCE01A,v.BCE01A BCE01C,a.FeeFlag
FROM #tmp_VAT a
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
JOIN VAC1 d with(nolock) ON a.VAA07 = d.VAC01
JOIN #tmp_VAF1 v ON a.VAF01 = v.VAF01
JOIN BBX1 g with(nolock) ON v.BBX01 = g.BBX01
LEFT JOIN BCK1 n with(nolock) ON v.BCK01A = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO1 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
where a.VAT04 <= 4 and a.ACF01 = 1 and a.VAT08 >= @aDate
and (v.BCK01B = @lBCK01 or exists(select vaf01 from #tmp_VAF1 v1 where v1.VAF01A = v.VAF01 and v1.BCK01B = @lBCK01))
and exists(select * from VAI1 s where v.CBM01 = s.CBM01 and ((s.VAI18 = 4) or (@lMember >= 1 and s.VAI18 <= 3) ))
UNION ALL
SELECT a.VAT01 , a.VAT04 ,b.VAA03, b.VAA03 VAA04, b.VAA05 , c.ABW02 , b.VAA10 , a.BEE01 , a.BEE03 ,b.ABBRP,B.ABBRW
, a.VAT33 ,BCQ04B='''' ,f.BAK05 , '''' , m.BBX05 MBBX05 , n.BCK03 , a.BCK01 , a.BBX01
, a.VAA01 , a.VAA07 , a.ACF01 , VAE44 = 0 ,a.VAT08,g.BCE03,0,g.CBM01,a.VAT09,isnull(b.VBU01,0) VBU01
,g.BCE01,g.BCE01 as BCE01C ,a.FeeFlag
FROM #tmp_VAT a
JOIN CBM1 g with(nolock) ON a.VAT01 = g.CBM01
JOIN VAA1 b with(nolock) ON a.VAA01 = b.VAA01
LEFT JOIN BCK1 n with(nolock) ON g.BCK01B = n.BCK01
LEFT JOIN BBX1 m with(nolock) ON a.BBX01 = m.BBX01
LEFT JOIN VAO1 e with(nolock) ON a.VAF01 = e.VAF01 AND e.VAO11 = 8
LEFT JOIN BAK1 f with(nolock) ON e.BAK01A = f.BAK01
LEFT JOIN ABW1 c with(nolock) ON b.ABW01 = c.ABW01
WHERE a.VAT04 <= 4 AND a.VAT08 >= @aDate AND a.BCK01 = @lBCK01
AND a.VCY01 > 0 AND a.VAA07 > 0
IF object_id(''tempdb..#tmp_VAT'') IS NOT NULL DROP TABLE #tmp_VAT
IF object_id(''tempdb..#tmp_VAF1'') IS NOT NULL DROP TABLE #tmp_VAF1
IF object_id(''tempdb..#tmp_VAF2'') IS NOT NULL DROP TABLE #tmp_VAF2<?xml version="1.0"?>
<Configs Ver="1"><Win SZ="1"/><Grid UseW="1"><Sql>select * from BCK1 where exists(select * from BAZ1 where BCK01=BCK1.BCK01 and BAU01=''03'')</Sql><HD><Ie FD="BCK03" WD="100"/></HD><QF><Ie FD="BCK01" WE="7"/><Ie FD="BCK02" WE="7"/><Ie FD="BCK03" WE="7"/><Ie FD="ABBRP" WE="7"/></QF></Grid></Configs>0=否
1=是<?xml version="1.0"?>
<Configs Ver="1"><Win SZ="1"/><Grid Head="1" UseW="1"><Sql>select VAA01,VAA03,VAA04,VAA05,ABBRP from VAA1 a where exists(select * from VAT1 where VAA01=a.VAA01)</Sql><HD><Ie FD="VAA03" CA="门诊号" WD="100"/><Ie FD="VAA04" CA="住院号" WD="100"/><Ie FD="VAA05" CA="姓名" WD="100"/><Ie FD="abbrp" CA="拼音码" WD="100"/></HD><QF><Ie FD="VAA03" WE="7"/><Ie FD="VAA04" WE="7"/><Ie FD="VAA05" WE="7"/><Ie FD="ABBRP" WE="7"/></QF></Grid></Configs>
' where Code='HO.ops.000003'
end
GO