医院系统.zip

CREATE VIEW view_ALLYZ AS SELECT YZinfo.name AS YZ, YSXXB.XM AS Doctor, HosReg.name AS Pname, CWXXB.CWBH AS CWBH, YYJGJBB.JGBH AS BQH, YYJGJBB.JGMC AS BQName, CWXXB.FJH AS FJH, CWXXB.CWMC AS CWMC, CWXXB.KSBH AS KSBH, KSJBB.KSMC AS KSMC, YZinfo.YZtype AS YZtype, (CASE WHEN YZtype = 0 THEN '长期医嘱' WHEN YZType = 1 THEN '临时医嘱' END) AS YZTypeName, YZinfo.ExeType AS ExeType, EXET.NAme AS ExeTypeName, hint.NAME AS Hint, FN .NAME AS Freq FROM YZinfo INNER JOIN Precord ON Precord.ID = YZinfo.BABID INNER JOIN HosReg ON HosReg.ZYH = Precord.ZYH AND Precord.KS = HosReg.KS INNER JOIN CWXXB ON CWXXB.CWBH = HosReg.BedId AND CWXXB.ZYH = HosReg.ZYH INNER JOIN YSXXB ON YSXXB.GH = Precord.doctorId INNER JOIN YYJGJBB ON YYJGJBB.JGBH = CWXXB.BQH INNER JOIN KSJBB ON KSJBB.KSBH = CWXXB.KSBH INNER JOIN MCB AS FN ON FN .CLASS = 'EXEFREQ' AND FN .ID = YZInfo.ExeFreq INNER JOIN MCB AS EXET ON EXET.class = 'YZZXLB' AND EXET.id = yzinfo.ExeType INNER JOIN MCB AS hint ON hint.CLASS = 'HINT' AND hint.ID = YZinfo.hint WHERE (YZinfo.StopTime > { fn NOW() }) CREATE VIEW view_ExeAllInfo AS SELECT ExeALLInfo.*, EN.XM AS ExeNurseName, CN.XM AS CheckNurseName,YZInfo.Name as YZ, (case when State='1' then '已执行' when State='2' then '已确费' when State='3' then '已取消' when State='9' then '已结算' end )as StateName FROM ExeALLInfo INNER JOIN YSXXB EN ON EN.GH = ExeALLInfo.ExeNurseID INNER JOIN YSXXB CN ON CN.GH = ExeALLInfo.CheckNurseID left join YZinfo ON YZInfo.ID=ExeAllInfo.YZID MCB 中添加EXEFREQ(医嘱执行频率)，HINT(执行提示)