USE [HISC]
GO
/****** Object: View [dbo].[TJ_SSFJTJ] Script Date: 11/19/2020 18:07:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER view [dbo].[TJ_SSFJTJ]
as
SELECT
BAH=b.PatientId,
XM=b.A11,
XB=CASE WHEN b.A12C=1 THEN '男'
WHEN b.A12C='2' THEN '女'
END,
NL=b.A14,
CYRQ=b.B15,
CYKS=b.B16N,
SSRQ=s.op_time,
SSBM=s.code,
SSMC=s.name,
YH=CASE WHEN s.heal_level='1' THEN '甲'
WHEN s.heal_level='2' THEN '乙'
WHEN s.heal_level='3' THEN '丙'
WHEN s.heal_level='4' THEN '其他'
END,
QK=CASE WHEN s.wound_level='1' THEN 'Ⅰ類'
WHEN s.wound_level='2' THEN 'Ⅱ類'
WHEN s.wound_level='3' THEN 'Ⅲ類'
END,
SSJB= s.op_level,
CYQK=CASE WHEN s.wound_level='1' THEN '治愈'
WHEN s.wound_level='2' THEN '好轉'
WHEN s.wound_level='3' THEN '未愈'
WHEN s.wound_level='4' THEN '死亡'
WHEN s.wound_level='9' THEN '其他'
END,
GZDWJDZ=b.A29,
ZYFY=f.D01,
SSYS=s.op_doctor,
MZFS=CASE WHEN s.anes_mode='01'THEN '全身麻醉'
WHEN s.anes_mode='0101' THEN '吸入麻醉 （氣管內插管、喉罩、面罩）'
WHEN s.anes_mode='0102' THEN '靜脈麻醉 （全憑靜脈麻醉）'
WHEN s.anes_mode='0103' THEN '靜吸復合麻醉'
WHEN s.anes_mode='0104' THEN '基礎麻醉 （直腸注入、肌肉注射）'
WHEN s.anes_mode='02' THEN '區域麻醉'
WHEN s.anes_mode='0201' THEN '椎管內麻醉'
WHEN s.anes_mode='020101' THEN '蛛網膜下腔阻滯'
WHEN s.anes_mode='020102' THEN '硬膜外間隙阻滯（含骶管阻滯）'
WHEN s.anes_mode='020103' THEN '蛛網膜下-硬膜外復合麻醉'
WHEN s.anes_mode='0202' THEN '神經及神經叢阻滯'
WHEN s.anes_mode='020201' THEN '頸叢阻滯'
WHEN s.anes_mode='020202' THEN '臂叢阻滯及上肢神經阻滯'
WHEN s.anes_mode='020203' THEN '腰骶神經叢阻滯及下肢神經阻滯'
WHEN s.anes_mode='020204' THEN '軀干神經阻滯：肋間神經阻滯'
WHEN s.anes_mode='020205' THEN '椎旁神經阻滯'
WHEN s.anes_mode='020206' THEN '會陰神經阻滯'
WHEN s.anes_mode='020207' THEN '交感神經阻滯：星狀神經節阻滯'
WHEN s.anes_mode='020208' THEN '胸腰交感神經阻滯'
WHEN s.anes_mode='020209' THEN '腦神經阻滯：三叉神經阻滯、舌咽神經阻滯'
WHEN s.anes_mode='03' THEN '區域麻醉'
WHEN s.anes_mode='0301' THEN '表面麻醉'
WHEN s.anes_mode='0302' THEN '區域浸潤麻醉'
WHEN s.anes_mode='0301' THEN '表面麻醉'
WHEN s.anes_mode='0303' THEN '區域阻滯麻醉'
WHEN s.anes_mode='0304' THEN '靜脈區域麻醉'
WHEN s.anes_mode='04' THEN '針刺鎮痛與麻醉'
WHEN s.anes_mode='05' THEN '復合麻醉'
WHEN s.anes_mode='0501' THEN '針刺鎮痛與麻醉'
WHEN s.anes_mode='0501'THEN '不同藥物的復合：普魯卡因靜脈復合全麻，神經安定鎮痛麻醉等'
WHEN s.anes_mode='0502' THEN '不同方法的復合：靜吸復合全麻，針藥復合麻醉，全身-硬膜外復合麻醉，脊髓-硬膜外復合麻醉等'
WHEN s.anes_mode='0503' THEN '特殊方法的復合：全麻復合全身降溫（低溫麻醉）， 控制性降壓等'
WHEN s.anes_mode='99' THEN '其他'
END
FROM archives_baseinfo b
LEFT JOIN archives_operation s
on s.PatientId=b.PatientId
LEFT JOIN archives_fee f on
f.PatientId=b.PatientId WHERE 1=1 and s.name!=''
group by b.B16N,b.PatientId,b.A11,b.A12C,b.A14,b.B15,s.op_time,s.code,s.name,s.heal_level,s.wound_level,s.is_master,s.op_doctor,s.anes_mode,b.A29,f.D01,s.op_level
GO
如何讓查詢結果是這樣的
使用的是FastReport
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/225208.html
標籤：新技術前沿
上一篇：資料合并問題，MySQL大神請進