A,190.0063,102,-18,-5,1
C,93.3,185,0,0,0,0,0,0
S,select 患者姓名,case 性别 when 1 then '男' else '女' end as 性别,case when 年龄>=1 then rtrim(convert(char(3) ,floor(年龄))) +'岁' when floor(年龄*1000)=年龄*1000 then rtrim(convert(char(3),floor(年龄*1000))) +'日' else rtrim(convert(char(3),floor(年龄/0.0304))) +'月' end as 年龄,记帐卡号,(case when 入院时间 is null  then '' else convert(char(4) ,year(入院时间)) end ) as 入院时间y,(case when 入院时间 is null  then '' else convert(char(2) ,MONTH(入院时间)) end ) as 入院时间M,(case when 入院时间 is null  then '' else convert(char(2) ,day(入院时间)) end ) as 入院时间D,住院编号 from v_zyhz  where v_zyhz.患者流水号=^/%3^
T,宋体,9,False,False,False,False,32,33,33,03,^患者姓名^,
T,宋体,9,False,False,False,False,32,70,33,03,^性别^,
T,宋体,9,False,False,False,False,23,137,33,03,^记帐卡号^,
T,宋体,9,False,False,False,False,93,140,42.59796,3.70417,^A/YEAR^   ^a/month^   ^a/date^ ,
T,宋体,9,False,False,False,False,93,110,15.87502,3.175003,^/user^,
T,宋体,9,False,False,False,False,23,40.5835,31.75003,3.175003,^/%1^,
T,宋体,9,False,False,False,False,23,164.5835,31.75003,3.175003,^住院编号^,
T,宋体,9,False,False,False,False,27,42,33,03,^入院时间y^,
T,宋体,9,False,False,False,False,27,57,33,03,^入院时间M^,
T,宋体,9,False,False,False,False,27,65,33,03,^入院时间D^,

A,190.0063,110,-18,-5,0
C,93.3,185,0,0,0,0,0,0
S,select sum(金额) as 金额,sum(自负金额) as 自负金额 from  sfxm  where 退费戳记=0 and  sfxm.发票流水号=^/%1^
T,宋体,9,False,False,False,False,80.5,43,20,3.70417,^金额/ucase^,
T,宋体,9,False,False,False,False,80.5,135,25,3.70417,^金额/cur^,

A,190.0063,110,-18,-5,0
C,93.3,185,0,0,0,0,0,0
S,select top 1 科室,convert(bigint,case when 出科时间 is null then 出院时间 else 出科时间 end -入院时间+1) as 时间,case when 出科时间 is null then year(出院时间) else year(出科时间) end as cysjy,case when 出科时间 is null then MONTH(出院时间) else month(出科时间) end as cysjm,case when 出科时间 is null then day(出院时间) else day(出科时间) end as cysjd from  zyxx  left outer join v_zlxx on v_zlxx.患者流水号=zyxx.患者流水号 where zyxx.患者流水号=^/%3^ order by 入科时间 desc
T,宋体,9,False,False,False,False,27,140,33,03,^时间^,
T,宋体,9,False,False,False,False,27,82,33,03,^cysjy^,
T,宋体,9,False,False,False,False,27,95,33,03,^cysjm^,
T,宋体,9,False,False,False,False,27,103,33,03,^cysjD^,

A,165.0063,35,7,38,0
C,5,55,0,0,0,0,0,0
S,SELECT 收费项目,sum(金额) as 金额 FROM sfxm where 退费戳记=0 and  发票流水号=^/%1^ group by 收费项目 having sum(金额)<>0 
T,宋体,9,False,False,False,False,0,5,40,3.175003,^收费项目^,
T,宋体,9,False,False,False,False,0,00,40,3.175003,^金额/rcur^,


A,190.0063,127,-18,-5,0
C,120,185,0,0,0,0,0,0
S,SELECT  sum(case when 收费类别<11 then 金额 else 0 end) as 押金,  sum(case when 收费类别>10  and 金额>0 and 发票编号=^/%1^ then 金额 else 0 end) as 补收, sum(case when 金额<0 and 发票编号=^/%1^ and  (收费类别>10) then -金额 else 0 end) as 退款 FROM ysk where 患者流水号=^/%3^ 
T,宋体,9,False,False,False,False,86,43,3,03,^押金/rcur^,
T,宋体,9,False,False,False,False,86,105,3,03,^补收/rcur^,
T,宋体,9,False,False,False,False,86,153,3,03,^退款/rcur^,