中医院2.0-接口视图建立

emrgrantselectonordadm.orderstoemrwithgrantgrantselectonordadm.orders_coststoemrwithgrantOrder_status=5:医生已保存，doctor为保存医生的，start_date_time为医嘱的开始Order_status=7:医生已停止，stop_doctor为停止的医生，stop_date_time为医嘱的Order_status=1:护士已转抄停止医嘱，stop_processing_date_time嘱的时间，stop_processing_nurseOrder_status=6:医生已作废，cancel_date_timecancel_cessing_nurse为转抄作废医嘱护士createorreplaceviewIN_ADVICE to_char(ORDERS.VISIT_ID)asIN_PATIENT_FLOW, to_char(ORDERS.ORDER_NO)asASSEMBLE_ID, LONG_FLAG,ORDERS.ORDER_CLASSasADVICE_TYPE, ADVICE_CONTENT,to_char(ORDERS.BILLING_ATTR)asSELF_MEDICINE, ORDERS.DOSAGE_UNITSasDOSAGE_UNIT,orders_costs.AMOUNTasTOTAL,orders_costs.UNITSas ADVICE_FREQNUM,to_char(ORDERS.START_DATE_TIME,'yyyymmddhh24miss')asto_char(ORDERS.stop_date_time,'yyyymmddhh24miss')asEDN_Time, to_char(ORDERS.ENTER_DATE_TIME,'yyyymmddhh24miss')asORDERS.DOCTORasD2_Name,to_char(ORDERS.CANCEL_DATE_TIME,'yyyymmddhh24miss')asORDERS.CANCEL_DOCTORasD3_ID,ORDERS.STOP_DOCTORas ORDERS.processing_nurseasND_Name,to_char(ORDERS.VERIFY_DATA_TIME,'yyyymmddhh24miss')asNE_TIME,ORDERS.NURSEasNE_Name,ORDERS.STOP_NURSEasNG_Name,to_char(ORDERS.stop_processing_date_time,'yyyymmddhh24miss')asORDERS.stop_processing_nurseasfromORDERSleftjoinorders_costsonORDERS.PATIENT_ID= whereCREATEVIEWZyReportView dbo.ReportItem.ReceiveDate,dbo.ReportForm.PatNoASameASpname,dbo.ReportForm.AgeASpage,dbo.ReportForm.GenderNoASpsex, ameASdeptname,dbo.ReportForm.Bed,dbo.ReportItem.ItemNoAStestcode,dbo.ReportForm.SerialNoASitem_no, ASprname_c,TestItem_2.ENameASprname_a,ISNULL(dbo.ReportItem.ReportDesc,'')+dbo.ReportItem.ReportValue),'')ASresult,TestItem_2.UnitAStestunit,dbo.ReportItem.ResultStatusASnormal,dbo.ReportForm.OperDateASexe_date,CONVERT(datetime,CONVERT(varchar(8),dbo.ReportForm.OperTime,108))ASdbo.ReportItem.RefRangeASuplimit,dbo.ReportItem.RefRangeASdnlimit,dbo.ReportForm.SerialNoASserial_no8,dbo.ReportForm.CheckDateASsenddate,CONVERT(datetime,CONVERT(varchar(8),dbo.ReportForm.CheckTime,108))ASdbo.ReportForm.zdy4ASorder_name,dbo.ReportForm.DoctorASenter_oper,dbo.ReportForm.OperatorASexe_name,dbo.ReportForm.SampleTypeNoASinspection,dbo.ReportForm.CollectDate,CAST(dbo.ReportForm.AgeASvarchar)AScage,dbo.ReportForm.ReceiveDate,112)+','+CAST(dbo.ReportForm.SectionNoASvarchar)+','+CAST(dbo.ReportForm.TestTypeNoASvarchar)+','+CAST(dbo.ReportForm.SampleNoASvarchar)ASserial_no,CONVERT(varchar,dbo.ReportForm.ReceiveDate,112)+','+CAST(dbo.ReportForm.SectionNoASvarchar)+','+CAST(dbo.ReportForm.TestTypeNoASvarchar)+','+CAST(dbo.ReportForm.SampleNoASvarchar)dbo.ReportForm.formmemoasdbo.ReportForm.ReceiveDate,112)asapplydate dbo.ReportItemINNERJOINdbo.ReportFormONdbo.ReportItem.ReceiveDate=dbo.ReportForm.ReceiveDateANDdbo.ReportItem.SectionNo=dbo.ReportForm.SectionNoANDdbo.ReportItem.TestTypeNo=dbo.ReportForm.TestTypeNoANDdbo.ReportItem.SampleNo=dbo.ReportForm.SampleNoLEFTOUTERJOINdbo.TestItemASTestItem_1ON=TestItem_1.ItemNoLEFTOUTERdbo.TestItemASTestItem_2ONdbo.ReportItem.ItemNoTestItem_2.ItemNoINNERdbo.DepartmentONdbo.ReportForm.DeptNo2、细菌报告CREATEVIEWZyReportMicroView dbo.ReportForm.PatNoASpid, ameASpname,dbo.ReportForm.AgeASpage,dbo.ReportForm.GenderNoASpsex,dbo.ReportForm.DeptNo,dbo.ReportForm.Bed,dbo.ReportForm.SerialNoASitem_no,dbo.ReportForm.OperDateASexe_date,CONVERT(varchar(8),dbo.ReportForm.OperTime,108))ASexe_time,dbo.ReportForm.SerialNoASSerialNoParent,RTRIM(CONVERT(varchar,SUBSTRING(dbo.ReportForm.SerialNo,6,5)ASitemno8,dbo.ReportForm.CheckDateASsenddate,CONVERT(datetime,CONVERT(varchar(8),dbo.ReportForm.CheckTime,108))ASsendtime,dbo.ReportForm.zdy4ASdbo.ReportForm.DoctorASenter_oper,dbo.ReportForm.OperatorASexe_name,dbo.ReportForm.Checker,SPACE(20)ASdbo.ReportMicro.ReceiveDate,dbo.ReportMicro.SectionNo,dbo.ReportMicro.TestTypeNo,dbo.ReportMicro.SampleNo,SPACE(8)AS ameAS o,d ameAS dbo.ReportMicro.MicroNo,dbo.ReportMicro.MicroDesc,ameASMicroName,ameASAntiName,dbo.ReportMicro.Suscept,dbo.ReportMicro.SusQuan,dbo.ReportMicro.RefRange,dbo.AntiGroup.AntiUnit,dbo.ReportMicro.ItemDate,dbo.ReportMicro.ItemTime,dbo.ReportMicro.ItemDesc,dbo.ReportMicro.EquipNo,dbo.ReportMicro.Modified,dbo.ReportMicro.IsMatch,dbo.ReportMicro.CheckType,dbo.ReportForm.SerialNo,dbo.ReportForm.SerialNoASdbo.ReportForm.SampleTypeNoASinspection,dbo.ReportForm.CollectDate,CAST(dbo.ReportForm.AgeASvarchar)AScage,dbo.ReportMicro.ReceiveDate,112),5,4)+','+CAST(dbo.ReportMicro.SectionNoASvarchar)+','+CAST(dbo.ReportMicro.TestTypeNoASvarchar)++CAST(dbo.ReportMicro.SampleNoASvarchar)ASdbo.ReportForm.formmemoasmrid,CONVERT(varchar(8),dbo.ReportForm.ReceiveDate,112)asapplydate dbo.AntiGroupINNERdbo.MicroGroupONdbo.AntiGroup.FamilyNo=dbo.MicroGroup.FamilyNoRIGHTOUTERJOINdbo.ReportMicroONdbo.MicroGroup.MicroNo=dbo.ReportMicro.MicroNoANDdbo.AntiGroup.Range=dbo.ReportMicro.RefRangeOUTER

dbo.AntiGroup.AntiNo=dbo.ReportMicro.AntiNodbo.AntiBioticONdbo.ReportMicro.AntiNodbo.AntiBiotic.AntiNoLEFTOUTERdbo.MicroItemONdbo.ReportMicro.MicroNo=dbo.MicroItem.MicroNoLEFTOUTERJOINdbo.MicroPhraseON o oLEFTOUTERdbo.TestIt