采集方式-db数据源分页列表

{
    "code": "100100000",
    "message": "操作成功",
    "data": {
        "rows": [
            {
                "wsid": "WSID_CSID_0000019540bc13c100ff14e774250899",
                "systemWsid": "WSID_CSYS_00000186a6984e6b00ff14e774256eb7",
                "targetWsid": "WSID_CSID_0000019540bc13c100ff14e774250899",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "ENABLE",
                "cron": "0 0 2 * * ?",
                "systemName": "测试系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "测试db-1",
                "dataSourceWsid": "WSID_CDSO_000001952623cb1e00ff14e774256856",
                "querySql": "select a.fileName from a",
                "charset": "utf-8",
                "resultDataType": "FILE",
                "templateWsid": "模板wsid",
                "dataSourceName": "技科八议族他"
            },
            {
                "wsid": "WSID_CSID_000001902fae133bb28646537e1384f2",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_000001902fae133bb28646537e1384f2",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "ENABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0/10 * * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "DZBA03.00.01",
                "mrClassName": "西药处方",
                "name": "采集自带签名的文件",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "SELECT\nf.fileDownloadUrl fileDownloadUrl,\nf.fileName fileName\nFROM\nemr_file_copy1 f\nWHERE  f.inp_No ='${inpNo}'",
                "charset": "UTF-8",
                "resultDataType": "FILE",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018e651f2cd12a39a3afee80200e",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018e651f2cd12a39a3afee80200e",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_OPERATION",
                "status": "ENABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "100",
                "mrClassName": "住院首页",
                "name": "新首页-手术信息1",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "SELECT\n\t`inpNo`,\n  `operationName` C15N,\n  `operationCode` C14C,\n  `operationDate` C16,\n  `operationLevel` C17,\n  `operationDoctor` C18,\n  `operationCollaboratorOne` C19,\n  `operationCollaboratorTwo` C20,\n  `operationIncisionsLevel` C21C,\n  `operationAnesthesiaType` C22C,\n  `operationAnesthesiaDoctor`C23,\n  `sn` \nFROM\n\t`home_page_operation` t\n\tWHERE t.inpNo ='${inpNo}'",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018c37c9d6152a39a3afee801024",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018e184da44f00ff14e77425036e",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018e184da44f00ff14e77425036e",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_BASE_INFO",
                "status": "ENABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "100",
                "mrClassName": "住院首页",
                "name": "新-首页患者信息",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "SELECT\n`inpNo`,\n`organizationCode` A01,\n`organizationName` A02,\n`payMode` A46C,\n`healthCardNumber` A47,\n`visitId` A49,\n`mrNo` A48,\n`patientName` A11,\n`patientSex` A12C,\n`birthDate` A13,\n`patientAge` A14,\n`nationality` A15C,\n`patientAgeDay` A16,\n`neonatusBirthWeight` A18,\n`neonatusBirthWeightGrams` A18x01,\n`birthPlace` A22,\n`nativePlace`,\n`nation` A23C,\n`idCard` A20,\n`career` A38C,\n`marriage` A21C,\n`currentAddress` A26,\n`currentAddressPhone` A27,\n`currentAddressPostCode` A28C,\n`registeredAddress` A24,\n`registeredAddressPostCode` A25C,\n`workAddress` A29,\n`workPhone` A30,\n`workAddressPostCode` A31C,\n`contactsName` A32,\n`contactsRelationship` A33C,\n`contactsAddress` A34,\n`inHospitalizedPathway`B11C,\n`inHospitalizedDateTime` B12,\n`inHospitalizedDeptWsid` B13C,\n`inHospitalizedWard` B14,\n`transferDeptWsid` B21C,\n`outHospitalDateTime` B15,\n`outHospitalWsid` B16C,\n`outHospitalizedWard` B17,\n`hospitalizationDays` B20,\n`clinicEmergencyDiagnosisName`,\n`clinicEmergencyDiagnosisCode`,\n`outHospitalWay` B34C,\n`transferHospitalName`B35,\n`hospitalOneMonth` B36C,\n`hospitalOneMonthReason` B37,\n`comaDaysBeforeInHospital` C28,\n`comaHoursBeforeInHospital` C29,\n`comaMinuteBeforeInHospital` C30,\n`comaDaysAfterInHospital` C31,\n`comaHoursAfterInHospital` C32,\n`comaMinuteAfterInHospital` C33,\n`poisoningDamageName` C13N,\n`poisoningDamageCode` C12C,\n`pathologyDiagnosisName` C10N,\n`pathologyDiagnosisCode` C09C,\n`diagnosisNo` C11,\n`drugAllergies` C24C,\n`drugAllergiesName` C25,\n`isAutopsy` C34C,\n`bloodType` C26C,\n`rhBloodType`C27C,\n`departmentHead` B22,\n`headDoctor` B23,\n`attendingDoctor` B24,\n`residentDoctor` B25,\n`chargeNurse` B26,\n`refresherDoctor` B27,\n`internDoctor` B28,\n`coder` B29,\n`medicalRecordQuality` B30C,\n`qcDoctor` B31,\n`qcNurse` B32,\n`qcDateTime` B33,\n`daySurgery` B38,\n          \"121212\" o1,\n          \"123123123\" o2,\n          \"这是测试这是测试这是测试这是测试\" QQQQhh1\nFROM\n\t`home_page_patient_info` c\n\tWHERE c.inpNo ='${inpNo}'",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018c37c9d6152a39a3afee801024",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018e08933f9ec2c5f2fac55d60f1",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018e08933f9ec2c5f2fac55d60f1",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_BASE_INFO",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "name": "首页患者基础信息采集.",
                "dataSourceWsid": "WSID_CDSO_0000018e086ff852c2c5f2fac55d60f1",
                "querySql": "SELECT\n`inpNo`,\n`organizationCode` A01,\n`organizationName` A02,\n`payMode` A46C,\n`healthCardNumber` A47,\n`visitId` A49,\n`mrNo` A48,\n`patientName` A11,\n`patientSex` A12C,\n`birthDate` A13,\n`patientAge` A14,\n`nationality` A15C,\n`patientAgeDay` A16,\n`neonatusBirthWeight` A18,\n`neonatusBirthWeightGrams` A18x01,\n`birthPlace` A22,\n`nativePlace`,\n`nation` A23C,\n`idCard` A20,\n`career` A38C,\n`marriage` A21C,\n`currentAddress` A26,\n`currentAddressPhone` A27,\n`currentAddressPostCode` A28C,\n`registeredAddress` A24,\n`registeredAddressPostCode` A25C,\n`workAddress` A29,\n`workPhone` A30,\n`workAddressPostCode` A31C,\n`contactsName` A32,\n`contactsRelationship` A33C,\n`contactsAddress` A34,\n`inHospitalizedPathway`B11C,\n`inHospitalizedDateTime` B12,\n`inHospitalizedDeptWsid` B13C,\n`inHospitalizedWard` B14,\n`transferDeptWsid` B21C,\n`outHospitalDateTime` B15,\n`outHospitalWsid` B16C,\n`outHospitalizedWard` B17,\n`hospitalizationDays` B20,\n`clinicEmergencyDiagnosisName`,\n`clinicEmergencyDiagnosisCode`,\n`outHospitalWay` B34C,\n`transferHospitalName`B35,\n`hospitalOneMonth` B36C,\n`hospitalOneMonthReason` B37,\n`comaDaysBeforeInHospital` C28,\n`comaHoursBeforeInHospital` C29,\n`comaMinuteBeforeInHospital` C30,\n`comaDaysAfterInHospital` C31,\n`comaHoursAfterInHospital` C32,\n`comaMinuteAfterInHospital` C33,\n`poisoningDamageName` C13N,\n`poisoningDamageCode` C12C,\n`pathologyDiagnosisName` C10N,\n`pathologyDiagnosisCode` C09C,\n`diagnosisNo` C11,\n`drugAllergies` C24C,\n`drugAllergiesName` C25,\n`isAutopsy` C34C,\n`bloodType` C26C,\n`rhBloodType`C27C,\n`departmentHead` B22,\n`headDoctor` B23,\n`attendingDoctor` B24,\n`residentDoctor` B25,\n`chargeNurse` B26,\n`refresherDoctor` B27,\n`internDoctor` B28,\n`coder` B29,\n`medicalRecordQuality` B30C,\n`qcDoctor` B31,\n`qcNurse` B32,\n`qcDateTime` B33\nFROM\n\t`home_page_patient_info` c\n\tWHERE c.inpNo ='${inpNo}'",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018c37c9d6152a39a3afee801024",
                "dataSourceName": "电子病历系统数据库"
            },
            {
                "wsid": "WSID_CSID_0000018ca4a1284500ff14e774259d47",
                "systemWsid": "WSID_CSYS_0000018731ce53437e04ecdc02919409",
                "targetWsid": "WSID_CSID_0000018ca4a1284500ff14e774259d47",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0/10 * * * 1",
                "systemName": "医院LIS病理系统",
                "mrClassCode": "DZBA02.00.02",
                "mrClassName": "急诊留观病历",
                "name": "file_info测试-带签名-4",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "select elementCode,elementValue,inpNo,fileName,fileNo from file_info where inpNo = \"${inpNo}\"",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018b179b4115f64b34686cde1f30",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018ca4a0ec3200ff14e774259d47",
                "systemWsid": "WSID_CSYS_0000018731ce53437e04ecdc02919409",
                "targetWsid": "WSID_CSID_0000018ca4a0ec3200ff14e774259d47",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0/10 * * * ?",
                "systemName": "医院LIS病理系统",
                "mrClassCode": "DZBA02.00.02",
                "mrClassName": "急诊留观病历",
                "name": "file_info测试-带签名-3",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "select elementCode,elementValue,inpNo,fileName,fileNo from file_info where inpNo = \"${inpNo}\"",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018b179b4115f64b34686cde1f30",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018ca4a053ec00ff14e774259d47",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018ca4a053ec00ff14e774259d47",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_OPERATION",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0/10 * * * ?",
                "systemName": "心电图系统",
                "name": "file_info测试-带签名-2",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "select elementCode,elementValue,inpNo,fileName,fileNo from file_info where inpNo = \"${inpNo}\"",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018b179b4115f64b34686cde1f30",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018b179c7e03f64b34686cde1f30",
                "systemWsid": "WSID_CSYS_0000018731ce53437e04ecdc02919409",
                "targetWsid": "WSID_CSID_0000018b179c7e03f64b34686cde1f30",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "ENABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0/10 * * * ?",
                "systemName": "医院LIS病理系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "file_info测试-带三个签名",
                "dataSourceWsid": "WSID_CDSO_00000186baaf4f697e04ecdc029172e8",
                "querySql": "select elementCode,elementValue,inpNo,fileName,fileNo from file_info where inpNo = \"${inpNo}\"",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018b179b4115f64b34686cde1f30",
                "dataConvertType": "ARRAY",
                "dataSourceName": "mysql0307"
            },
            {
                "wsid": "WSID_CSID_0000018b17631f2df64b34686cde1f30",
                "systemWsid": "WSID_CSYS_0000018731ce53437e04ecdc02919409",
                "targetWsid": "WSID_CSID_0000018b17631f2df64b34686cde1f30",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "ENABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0/10 * * * ?",
                "systemName": "医院LIS病理系统",
                "mrClassCode": "DZBA02.00.02",
                "mrClassName": "急诊留观病历",
                "name": "file_info测试-带签名",
                "dataSourceWsid": "WSID_CDSO_00000186baaf4f697e04ecdc029172e8",
                "querySql": "SELECT\n\"护理记录单\" fileName,\n\"hljld\" fileNo,\nf.sj,\nf.bqgc,\nf.hx,\nf.inpNo,\nf.mb,\nf.tw,\nf.xl\nFROM\nfile_nurse_log f\nWHERE f.inpNo ='${inpNo}'",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018ab5a4e9b100ff14e77425827f",
                "dataConvertType": "ARRAY",
                "dataSourceName": "mysql0307"
            },
            {
                "wsid": "WSID_CSID_0000018aba95a9bc00ff14e7742511d8",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018aba95a9bc00ff14e7742511d8",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 1,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "测试（无数据）1",
                "dataSourceWsid": "WSID_CDSO_00000186baaf4f697e04ecdc029172e8",
                "querySql": "SELECT\n\"护理记录单\" fileName,\n\"hljld\" fileNo,\nf.sj,\nf.bqgc,\nf.hx,\nf.inpNo,\nf.mb,\nf.tw,\nf.xl\nFROM\nfile_nurse_log f\n\nWHERE f.inpNo ='${inpNo}'",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018ab5a4e9b100ff14e77425827f",
                "dataConvertType": "ARRAY",
                "dataSourceName": "mysql0307"
            },
            {
                "wsid": "WSID_CSID_0000018ab79009c500ff14e774251f21",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018ab79009c500ff14e774251f21",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "DZBA01.00",
                "mrClassName": "病历概要",
                "name": "测试（无数据）",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "SELECT\n\"护理记录单\" fileName,\n\"hljld\" fileNo,\nf.sj,\nf.bqgc,\nf.hx,\nf.inpNo,\nf.mb,\nf.tw,\nf.xl\nFROM\nfile_nurse_log f\n\nWHERE f.inpNo ='${inpNo}'",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018b179b4115f64b34686cde1f30",
                "dataConvertType": "ARRAY",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018ab5aa33db00ff14e77425827f",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018ab5aa33db00ff14e77425827f",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "护理记录单",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "SELECT\n\"护理记录单\" fileName,\n\"hljld\" fileNo,\nf.sj,\nf.bqgc,\nf.hx,\nf.inpNo,\nf.mb,\nf.tw,\nf.xl\nFROM\nfile_nurse_log f\n\nWHERE f.inpNo ='${inpNo}'",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018ab5a4e9b100ff14e77425827f",
                "dataConvertType": "ARRAY",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018a5fd2bf7300ff14e77425a85b",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018a5fd2bf7300ff14e77425a85b",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "测试-单对象",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "SELECT\nf.inpNo,\n'111' fileNo,\n\"多表头\" fileName,\nf.sx,\nf.ty,\nf.yw\nFROM\nfile_info_test f \nWHERE f.inpNo ='${inpNo}'",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018a5fd1eb8500ff14e77425a85b",
                "dataConvertType": "COLUMN_TO_ROW",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018a5fbf8f7100ff14e774253851",
                "systemWsid": "WSID_CSYS_00000186baaeb11d7e04ecdc029172e8",
                "targetWsid": "WSID_CSID_0000018a5fbf8f7100ff14e774253851",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "心电图系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "测试-多表头",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "SELECT\nf.inpNo,\n'111' fileNo,\n\"多表头\" fileName,\nf.sx,\nf.ty,\nf.yw\nFROM\nfile_info_test f \nWHERE f.inpNo ='${inpNo}'",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018a5fb9c3a200ff14e774253851",
                "dataConvertType": "ARRAY",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018a1b85607300ff14e774256b96",
                "systemWsid": "WSID_CSYS_00000189b983defe00ff14e774256525",
                "targetWsid": "WSID_CSID_0000018a1b85607300ff14e774256b96",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_FEE_INFO",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "手术麻醉系统",
                "mrClassCode": "100",
                "mrClassName": "住院首页",
                "name": "首页-费用采集",
                "dataSourceWsid": "WSID_CDSO_00000186baaf4f697e04ecdc029172e8",
                "querySql": "SELECT\n\t`inpNo`,\n\t`totalCost` D01,\n\t`selfFundedAmount` D09,\n\t`medicalServiceAmount` D11,\n\t`treatmentOperationAmount` D12,\n\t`nurseAmount` D13,\n\t`integratedMedicalServiceAmount` D14,\n\t`pathologicDiagnosisAmount` D15,\n\t`experimentDiagnosisAmount` D16,\n\t`laboratoryDiagnosisAmount` D17,\n\t`clinicalDiagnosisAmount` D18,\n\t`treatmentAmount` D19,\n\t`physicotherapeuticsAmount` D19x01,\n\t`surgicalTreatmentAmount` D20,\n\t`anesthesiaAmount` D20x01,\n\t`surgicalAmount` D20x02,\n\t`rehabilitationAmount` D21,\n\t`tcmTreatmentAmount` D22,\n\t`westernMedicineAmount` D23,\n\t`antibioticsAmount` D23x01,\n\t`cpdAmount` D24,\n\t`chmAmount` D25,\n\t`bloodAmount` D26,\n\t`albuminAmount` D27,\n\t`globulinAmount` D28,\n\t`coagulationFactorAmount` D29,\n\t`cytokineAmount` D30,\n\t`examinationDMMAmount` D31,\n\t`treatmentDMMAmount` D32,\n\t`surgicalDMMAmount` D33,\n\t`otherAmount` D34 \nFROM\n\thome_page_fee c \nWHERE\n\tc.inpNo = '${inpNo}'",
                "charset": "GB2312",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018c37c9d6152a39a3afee801024",
                "dataSourceName": "mysql0307"
            },
            {
                "wsid": "WSID_CSID_00000189bf4e8fa700ff14e7742505a1",
                "systemWsid": "WSID_CSYS_00000189b983defe00ff14e774256525",
                "targetWsid": "WSID_CSID_00000189bf4e8fa700ff14e7742505a1",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_DISCHARGE_DIAGNOSIS",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "手术麻醉系统",
                "name": "首页-出院诊断采集",
                "dataSourceWsid": "WSID_CDSO_00000186baaf4f697e04ecdc029172e8",
                "querySql": "SELECT\nd.dischargeDiagnosisName C04N,\nd.dischargeDiagnosisCode C03C,\nd.dischargeDiagnosisDisease C05C,\nd.sn\nFROM\nhome_page_discharge_diagnosis d \nWHERE d.inpNo ='${inpNo}'",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018c37c9d6152a39a3afee801024",
                "dataSourceName": "mysql0307"
            },
            {
                "wsid": "WSID_CSID_000001898b9f894b00ff14e77425548b",
                "systemWsid": "WSID_CSYS_00000189b983defe00ff14e774256525",
                "targetWsid": "WSID_CSID_000001898b9f894b00ff14e77425548b",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_BASE_INFO",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0 0 * * ?",
                "systemName": "手术麻醉系统",
                "name": "首页患者基础信息采集.",
                "dataSourceWsid": "WSID_CDSO_00000186baaf4f697e04ecdc029172e8",
                "querySql": "SELECT\n`inpNo`,\n`organizationCode` A01,\n`organizationName` A02,\n`payMode` A46C,\n`healthCardNumber` A47,\n`visitId` A49,\n`mrNo` A48,\n`patientName` A11,\n`patientSex` A12C,\n`birthDate` A13,\n`patientAge` A14,\n`nationality` A15C,\n`patientAgeDay` A16,\n`neonatusBirthWeight` A18,\n`neonatusBirthWeightGrams` A18x01,\n`birthPlace` A22,\n`nativePlace`,\n`nation` A23C,\n`idCard` A20,\n`career` A38C,\n`marriage` A21C,\n`currentAddress` A26,\n`currentAddressPhone` A27,\n`currentAddressPostCode` A28C,\n`registeredAddress` A24,\n`registeredAddressPostCode` A25C,\n`workAddress` A29,\n`workPhone` A30,\n`workAddressPostCode` A31C,\n`contactsName` A32,\n`contactsRelationship` A33C,\n`contactsAddress` A34,\n`inHospitalizedPathway`B11C,\n`inHospitalizedDateTime` B12,\n`inHospitalizedDeptWsid` B13C,\n`inHospitalizedWard` B14,\n`transferDeptWsid` B21C,\n`outHospitalDateTime` B15,\n`outHospitalWsid` B16C,\n`outHospitalizedWard` B17,\n`hospitalizationDays` B20,\n`clinicEmergencyDiagnosisName`,\n`clinicEmergencyDiagnosisCode`,\n`outHospitalWay` B34C,\n`transferHospitalName`B35,\n`hospitalOneMonth` B36C,\n`hospitalOneMonthReason` B37,\n`comaDaysBeforeInHospital` C28,\n`comaHoursBeforeInHospital` C29,\n`comaMinuteBeforeInHospital` C30,\n`comaDaysAfterInHospital` C31,\n`comaHoursAfterInHospital` C32,\n`comaMinuteAfterInHospital` C33,\n`poisoningDamageName` C13N,\n`poisoningDamageCode` C12C,\n`pathologyDiagnosisName` C10N,\n`pathologyDiagnosisCode` C09C,\n`diagnosisNo` C11,\n`drugAllergies` C24C,\n`drugAllergiesName` C25,\n`isAutopsy` C34C,\n`bloodType` C26C,\n`rhBloodType`C27C,\n`departmentHead` B22,\n`headDoctor` B23,\n`attendingDoctor` B24,\n`residentDoctor` B25,\n`chargeNurse` B26,\n`refresherDoctor` B27,\n`internDoctor` B28,\n`coder` B29,\n`medicalRecordQuality` B30C,\n`qcDoctor` B31,\n`qcNurse` B32,\n`qcDateTime` B33\nFROM\n\t`home_page_patient_info` c\n\tWHERE c.inpNo ='${inpNo}'",
                "charset": "GBK",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_0000018c37c9d6152a39a3afee801024",
                "dataSourceName": "mysql0307"
            },
            {
                "wsid": "WSID_CSID_000001894d3522ec00ff14e774252515",
                "systemWsid": "WSID_CSYS_0000018731ce53437e04ecdc02919409",
                "targetWsid": "WSID_CSID_000001894d3522ec00ff14e774252515",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 0,
                "extractType": 1,
                "cron": "0 0/10 * * * ?",
                "systemName": "医院LIS病理系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "测试1",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "select elementCode,elementValue,inpNo,fileName,fileNo from file_info",
                "charset": "GB2312",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_000001892a027d27f64b34686cde2130",
                "dataSourceName": "测试47数据库"
            },
            {
                "wsid": "WSID_CSID_0000018948fdd9fd00ff14e77425027b",
                "systemWsid": "WSID_CSYS_0000018731ce53437e04ecdc02919409",
                "targetWsid": "WSID_CSID_0000018948fdd9fd00ff14e77425027b",
                "triggerType": "TIME",
                "scene": "IN_HOSPITAL",
                "dataType": "MR_CONTENT",
                "status": "DISABLE",
                "needConfirmArchive": 1,
                "extractType": 1,
                "cron": "0 0/10 * * * ?",
                "systemName": "医院LIS病理系统",
                "mrClassCode": "DZBA02.00",
                "mrClassName": "门（急）诊病历",
                "name": "file_info测试",
                "dataSourceWsid": "WSID_CDSO_00000186a699db4700ff14e774256eb7",
                "querySql": "select elementCode,elementValue,inpNo,fileName,fileNo from file_info where inpNo = \"${inpNo}\"",
                "charset": "UTF-8",
                "resultDataType": "DATA_KEY_VALUE",
                "templateWsid": "WSID_CCTE_00000189af2a10fef64b34686cde17bc",
                "dataSourceName": "测试47数据库"
            }
        ],
        "page": {
            "size": 20,
            "totalElements": 31,
            "totalPages": 1,
            "number": 0
        }
    }
}