{"id":1106,"date":"2019-02-03T09:59:26","date_gmt":"2019-02-03T01:59:26","guid":{"rendered":"http:\/\/www.tairongkj.com\/?p=1106"},"modified":"2019-02-03T10:01:45","modified_gmt":"2019-02-03T02:01:45","slug":"%e7%94%b5%e5%ad%90%e7%97%85%e4%be%8b%e4%ba%94%e7%ba%a7%e8%af%84%e5%ae%a1-uses-2-5","status":"publish","type":"post","link":"https:\/\/www.tairongkj.com\/?p=1106","title":{"rendered":"\u7535\u5b50\u75c5\u4f8b\u4e94\u7ea7\u8bc4\u5ba1-USES-2-5"},"content":{"rendered":"

\u4e8c\u3001\u68c0\u67e5\u8bb0\u5f55\u90e8\u4efd<\/h1>\n

04.02.3\u68c0\u67e5\u8bb0\u5f55\uff1a 3\u7ea7\u7684\u6570\u636e\u8d28\u91cf\u8981\u6c42\u4e00\u81f4\u6027\u7684\u9879\u76ee\u5305\u62ec\u68c0\u67e5\u9879\u76ee\u3001\u90e8\u4f4d\uff0c\u6570\u636e\u8d28\u91cf\u5206\u6790\u6240\u9700\u7684\u5177\u4f53\u6570\u636e\u5185\u5bb9\u4e0e\u6765\u6e90\u5217\u8868\u5982\u4e0b\uff1a<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/p>\n

 <\/td>\n<\/tr>\n

\u68c0\u67e5\u9879\u76ee<\/td>\n\u68c0\u67e5\u9879\u76ee<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n
\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u9879\u76ee<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u6570\u91cf 1911<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> sum<\/span>(<\/span>t.<\/span>\u6570\u91cf)<\/span> as<\/span> \u9879\u76ee\u6570\u91cf,<\/span>sum<\/span>(<\/span>t.<\/span>\u6570\u91cf)<\/span> as<\/span> \u90e8\u4f4d\u6570\u91cf from <\/span>(<\/span>select<\/span> uitems as<\/span> \u68c0\u67e5\u9879\u76ee\u90e8\u4f4d,<\/span>uitems as<\/span> \u68c0\u67e5\u90e8\u4f4d ,<\/span>COUNT<\/span>(*)<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vUptoServ<\/p>\n

where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uPsource=<\/span>‘\u95e8\u8bca’<\/span><\/p>\n

group<\/span> by<\/span> uitems)<\/span> as<\/span> t<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.02.4\uff08\u9009\u62e9\u9879\uff09\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u8bb0\u5f55<\/a>\uff08\u60a3\u8005\u6807\u8bc6\u3001\u68c0\u67e5\u9879\u76ee\u3001\u90e8\u4f4d\u3001\u6d4b\u91cf\u503c\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/p>\n

 <\/td>\n<\/tr>\n

\u60a3\u8005\u6807\u8bc6<\/td>\n\u60a3\u8005\u6807\u8bc6<\/td>\nvUptoServ.patientid<\/td>\nvUptoServ.uItems<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee<\/td>\n\u68c0\u67e5\u9879\u76ee<\/td>\nvUptoServ.uItems<\/td>\nvUptoServ.uItems<\/td>\n<\/tr>\n
\u90e8\u4f4d<\/td>\n\u60a3\u90e8\u4f4d<\/td>\nvUptoServ.uItems<\/td>\nvUptoServ.uItems<\/td>\n<\/tr>\n
\u6d4b\u91cf\u503c<\/td>\n\u6d4b\u91cf\u503c<\/td>\nvUptoServ.uItems<\/td>\nvUptoServ.uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u603b\u8ba1 54492<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> top<\/span> 10 patientid as<\/span> \u60a3\u8005\u6807\u8bc6 ,<\/span>uItems as<\/span> \u68c0\u67e5\u9879\u76ee,<\/span>uItems as<\/span> \u90e8\u4f4d,<\/span>‘None’<\/span> as<\/span> \u6d4b\u91cf\u503c,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u62a5\u544a\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span> ”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

04.02.5\uff08\u9009\u62e9\u9879\uff09\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u8bb0\u5f55\uff08\u68c0\u67e5\u65f6\u95f4\u3001\u68c0\u67e5\u533b\u5e08\u3001\u68c0\u67e5\u72b6\u6001\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/p>\n

 <\/td>\n<\/tr>\n

\u68c0\u67e5\u533b\u5e08<\/td>\n\u60a3\u68c0\u67e5\u533b\u5e08<\/td>\nvUptoServ. uExamDoc<\/td>\nvUptoServ. uExamDoc<\/td>\n<\/tr>\n
\u68c0\u67e5\u72b6\u6001<\/td>\n\u68c0\u67e5\u72b6\u6001<\/td>\nvUptoServ. ReportState<\/td>\nvUptoServ. ReportState<\/td>\n<\/tr>\n
\u68c0\u67e5\u65f6\u95f4<\/td>\n\u68c0\u67e5\u65f6\u95f4<\/td>\nvUptoServ. uRptDate<\/td>\nvUptoServ. uRptDate<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u603b\u8ba1 54492<\/p>\n\n\n<\/colgroup>\n\n\n
use<\/span> Pacs4all<\/p>\n

— \u68c0\u67e5\u65f6\u95f4\u3001\u68c0\u67e5\u533b\u5e08\u3001\u68c0\u67e5\u72b6\u6001<\/span><\/p>\n

select<\/span> top<\/span> 10 uExamDoc as<\/span> \u68c0\u67e5\u533b\u5e08 ,<\/span>ReportState as<\/span> \u68c0\u67e5\u72b6\u6001,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u68c0\u67e5\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ‘\u603b\u8ba1’<\/span>,<\/span>”<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.02.5\uff08\u9009\u62e9\u9879\uff09\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u8bb0\u5f55\uff08\u60a3\u8005\u6807\u8bc6\u3001\u68c0\u67e5\u9879\u76ee\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u60a3\u8005\u6807\u8bc6<\/td>\n\u60a3\u8005\u6807\u8bc6<\/td>\nvUptoServ. patientid<\/td>\nvUptoServ. patientid<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee<\/td>\n\u68c0\u67e5\u9879\u76ee<\/td>\nvUptoServ. uItems<\/td>\nvUptoServ. uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u603b\u8ba1 54492<\/p>\n\n\n<\/colgroup>\n\n\n
use<\/span> Pacs4all<\/p>\n

— \u60a3\u8005\u6807\u8bc6\u3001\u68c0\u67e5\u9879\u76ee<\/span><\/p>\n

select<\/span> top<\/span> 10 patientid as<\/span> \u60a3\u8005\u6807\u8bc6 ,<\/span>uItems as<\/span> \u68c0\u67e5\u9879\u76ee,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u68c0\u67e5\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ‘\u603b\u8ba1’<\/span>,<\/span>”<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u4e09\u3001\u68c0\u67e5\u62a5\u544a\u90e8\u4efd<\/h1>\n

0.4.03 \u7ea7\u7684\u6570\u636e\u8d28\u91cf\u8981\u6c42\u68c0\u67e5\u62a5\u544a\u4e00\u81f4\u6027\u7684\u9879\u76ee\u5305\u62ec\u68c0\u67e5\u9879\u76ee\u3001\u90e8\u4f4d\u3002\u6570\u636e\u8d28\u91cf\u5206\u6790\u6240\u9700\u7684\u5177\u4f53\u6570\u636e\u5185\u5bb9\u4e0e\u6765\u6e90\u5217\u8868\u5982\u4e0b\uff1a<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\n

\u67e5\u8be2sql:<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> uItems as<\/span> \u68c0\u67e5\u9879<\/span> ,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0 group<\/span> by<\/span> uItems<\/p>\n

union<\/span> all<\/span> select<\/span> ‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.03.4(4\u7ea7\u9009\u62e9\u9879)\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55(\u68c0\u67e5\u62a5\u544a\u7f16\u53f7\u3001\u60a3\u8005\u6807\u8bc6\u3001\u68c0\u67e5\u9879\u76ee\u3001\u90e8\u4f4d\u3001\u68c0\u67e5\u7ed3\u8bba\u3001\u62a5\u544a\u65f6\u95f4)<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u62a5\u544a\u65f6\u95f4<\/td>\n\u62a5\u544a\u65f6\u95f4<\/td>\nFYCS.vUptoServ.uRptDate<\/td>\nFYCS.vUptoServ.uRptDate<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n
\u68c0\u67e5\u62a5\u544a\u7f16\u53f7<\/td>\n\u68c0\u67e5\u62a5\u544a\u7f16\u53f7<\/td>\nFYCS.vUptoServ.uAccnu<\/td>\nFYCS.vUptoServ.uAccnu<\/td>\n<\/tr>\n
\u60a3\u8005\u6807\u8bc6<\/td>\n\u60a3\u8005\u6807\u8bc6<\/td>\nFYCS.vUptoServ.PatientID<\/td>\nFYCS.vUptoServ.PatientID<\/td>\n<\/tr>\n
\u59d3\u540d,<\/span><\/td>\n\u59d3\u540d,<\/span><\/td>\nFYCS.vUptoServ.uName<\/td>\nFYCS.vUptoServ.uName<\/td>\n<\/tr>\n
\u68c0\u67e5\u7ed3\u8bba<\/td>\n\u68c0\u67e5\u7ed3\u8bba<\/td>\nFYCS.vUptoServ.uJianLun<\/td>\nFYCS.vUptoServ.uJianLun<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u603b\u8bb0\u5f55\u6570\u53c2\u8003\u503c\uff1a\u533b\u9662\u8fd0\u884c\u57fa\u7840\u6570\u636e\uff1a\u68c0\u67e5\u9879\u76ee\u4eba\u6b21\u6570\uff1a<\/p>\n

\"\"<\/p>\n

\u67e5\u8be2Sql:\u5e93\u540dfycs<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> top<\/span> 10 uAccnu as<\/span> \u68c0\u67e5\u62a5\u544a\u7f16\u53f7 ,<\/span>PatientID as<\/span> \u60a3\u8005\u6807\u8bc6,<\/span>uName as<\/span> \u59d3\u540d,<\/span> uItems as<\/span> \u68c0\u67e5\u9879\u76ee\u90e8\u4f4d,<\/span>uJianLun as<\/span> \u68c0\u67e5\u7ed3\u8bba,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u62a5\u544a\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span>‘ ‘<\/span>,<\/span>”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

04.03.5(5\u7ea7\u9009\u62e9\u9879)\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55<\/a>(\u68c0\u67e5\u6240\u89c1\u3001\u62a5\u544a\u533b\u5e08\u3001\u5ba1\u6838\u533b\u5e08\u3001\u62a5\u544a\u65f6\u95f4)<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u62a5\u544a\u65f6\u95f4<\/td>\n\u62a5\u544a\u65f6\u95f4<\/td>\nFYCS.vUptoServ.uRptDate<\/td>\nFYCS.vUptoServ.uRptDate<\/td>\n<\/tr>\n
\u68c0\u67e5\u6240\u89c1<\/td>\n\u68c0\u67e5\u6240\u89c1<\/td>\nFYCS.vUptoServ. uSuoJian<\/td>\nFYCS.vUptoServ. uSuoJian<\/td>\n<\/tr>\n
\u62a5\u544a\u533b\u5e08<\/td>\n\u62a5\u544a\u533b\u5e08<\/td>\nFYCS.vUptoServ. uRptDoc<\/td>\nFYCS.vUptoServ. uRptDoc<\/td>\n<\/tr>\n
\u5ba1\u6838\u533b\u5e08<\/td>\n\u5ba1\u6838\u533b\u5e08<\/td>\nFYCS.vUptoServ. uExamDoc<\/td>\nFYCS.vUptoServ. uExamDoc<\/td>\n<\/tr>\n
\u62a5\u544a\u72b6\u6001<\/td>\n\u62a5\u544a\u72b6\u6001<\/td>\nFYCS.vUptoServ. ReportState<\/td>\nFYCS.vUptoServ. ReportState<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u603b\u8bb0\u5f55\u6570\u53c2\u8003\u503c\uff1a\u533b\u9662\u8fd0\u884c\u57fa\u7840\u6570\u636e\uff1a\u68c0\u67e5\u9879\u76ee\u4eba\u6b21\u6570\uff1a<\/p>\n

\"\"<\/p>\n

\u67e5\u8be2Sql:\u5e93\u540dfycs<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> top<\/span> 10 uAccnu as<\/span> \u68c0\u67e5\u62a5\u544a\u7f16\u53f7 ,<\/span>ReportState as<\/span> \u62a5\u544a\u72b6\u6001,<\/span>uRptDoc as<\/span> \u62a5\u544a\u533b\u5e08,<\/span> uExamDoc as<\/span> \u5ba1\u6838\u533b\u5e08,<\/span>uSuoJian as<\/span> \u68c0\u67e5\u6240\u89c1,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u62a5\u544a\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span>‘ ‘<\/span>,<\/span>”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.03.5(5\u7ea7\u9009\u62e9\u9879)\u6574\u5408\u6027\uff1a\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55<\/a>\u4e0e\u68c0\u67e5\u7533\u8bf7\u8bb0\u5f55(\u7533\u8bf7\u5355\u7f16\u53f7\u3001\u60a3\u8005\u6807\u8bc6\u3001\u68c0\u67e5\u9879\u76ee\u3001\u7533\u8bf7\u79d1\u5ba4)<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u75c5\u4eba\u6807\u8bc6<\/td>\n\u75c5\u4eba\u6807\u8bc6<\/td>\nFYCS.vUptoServ. PatientID<\/td>\nFYCS.vUptoServ. PatientID<\/td>\n<\/tr>\n
\u7533\u8bf7\u5355\u7f16\u53f7<\/td>\n\u7533\u8bf7\u5355\u7f16\u53f7<\/td>\nFYCS.vUptoServ. uitemid<\/td>\nFYCS.vUptoServ. uitemid<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee_\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u9879\u76ee_\u90e8\u4f4d<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n
\u7533\u8bf7\u79d1\u5ba4<\/td>\n\u7533\u8bf7\u79d1\u5ba4<\/td>\nFYCS.vUptoServ. uSqKeShi<\/td>\nFYCS.vUptoServ. uSqKeShi<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\"\"<\/p>\n

\u67e5\u8be2Sql:\u5e93\u540dfycs<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> top<\/span> 10 PatientID as<\/span> \u75c5\u4eba\u6807\u8bc6,<\/span> uitemid as<\/span> \u7533\u8bf7\u5355\u7f16\u53f7,<\/span>uItems as<\/span> \u68c0\u67e5\u9879\u76ee_\u90e8\u4f4d,<\/span> uSqKeShi as<\/span> \u7533\u8bf7\u79d1\u5ba4,<\/span>1 as<\/span> \u6570\u91cf from<\/span> vuptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span>”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.03.5(6\u7ea7\u9009\u62e9\u9879)\u53ca\u65f6\u6027\uff1a\u68c0\u67e5\u7533\u8bf7\u8bb0\u5f55\uff08\u7533\u8bf7\u65f6\u95f4\uff09<= \u68c0\u67e5\u8bb0\u5f55\uff08\u60a3\u8005\u62a5\u5230\u65f6\u95f4\uff09<=\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55\uff08\u62a5\u544a\u5ba1\u6838\u65f6\u95f4\uff09<\/h2>\n

\u56db\u3001\u68c0\u67e5\u56fe\u50cf\u90e8\u4efd<\/h1>\n

04.04.3 \uff083\u7ea7\u9009\u62e9\u9879\uff09\u4e00\u81f4\u6027\uff1a\u68c0\u67e5\u56fe\u50cf\u4e0e\u76f8\u5173\u6570\u636e\u5b57\u5178\uff08\u68c0\u67e5\u9879\u76ee\u3001\u90e8\u4f4d\u3001\u53ca\u91c7\u96c6\u4eba\u7684\u540d\u79f0\u548c\u7f16\u7801\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee<\/td>\n\u68c0\u67e5\u9879\u76ee<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n
\u90e8\u4f4d<\/td>\n\u90e8\u4f4d<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n
\u91c7\u96c6\u4eba\u540d\u79f0<\/td>\n\u59d3\u540d<\/td>\nFYCS.vUptoServ. uName<\/td>\nFYCS.vUptoServ. uName<\/td>\n<\/tr>\n
\u91c7\u96c6\u4eba\u7f16\u7801<\/td>\n\u75c5\u4eba\u6807\u8bc6<\/td>\nFYCS.vUptoServ. PatientID<\/td>\nFYCS.vUptoServ. PatientID<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\"\"<\/p>\n\n\n<\/colgroup>\n\n\n
Use fycs<\/span><\/p>\n

select<\/span> top<\/span> 10 PatientID as<\/span> \u75c5\u4eba\u6807\u8bc6,<\/span>uName as<\/span> \u59d3\u540d,<\/span> uItems as<\/span> \u90e8\u4f4d,<\/span>uItems as<\/span> \u68c0\u67e5\u9879\u76ee_\u90e8\u4f4d,<\/span> 1 as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vuptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span>”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.04.4 \uff084\u7ea7\u57fa\u7840\u9879\uff09\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u56fe\u50cf\u8bb0\u5f55\uff08\u56fe\u50cf\u552f\u4e00\u7f16\u53f7\u3001\u60a3\u8005\u6807\u8bc6\u53f7\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u56fe\u50cf\u552f\u4e00\u7f16\u53f7<\/td>\nAccsssionNumber<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n
\u60a3\u8005\u6807\u8bc6\u53f7<\/td>\nPatientId<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\"\"<\/p>\n\n\n<\/colgroup>\n\n\n
Use fycs<\/span><\/p>\n

select<\/span> top<\/span> 10 uAccnu as<\/span> \u56fe\u50cf\u552f\u4e00\u7f16\u53f7,<\/span> PatientID as<\/span> \u60a3\u8005\u6807\u8bc6,<\/span> 1 as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vuptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ‘ ‘<\/span>,<\/span> ‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

04.04.5 \uff084\u7ea7\u57fa\u7840\u9879\uff09\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u56fe\u50cf\u8bb0\u5f55\uff08\u56fe\u50cf\u4ea7\u751f\u7684\u65f6\u95f4\u3001\u68c0\u67e5\u90e8\u4f4d\u3001\u56fe\u50cf\u751f\u4ea7\u8bbe\u5907\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u56fe\u50cf\u4ea7\u751f\u65f6\u95f4<\/td>\n\u521b\u5efa\u65f6\u95f4<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n
\u68c0\u67e5\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u90e8\u4f4d<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n
\u56fe\u50cf\u751f\u4ea7\u8bbe\u5907<\/td>\n\u56fe\u50cf\u751f\u4ea7\u8bbe\u5907<\/td>\nFYCS.vUptoServ. uName<\/td>\nFYCS.vUptoServ. uName<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\"\"<\/p>\n\n\n<\/colgroup>\n\n\n
Use fycs<\/span><\/p>\n

select<\/span> top<\/span> 10 urptdate as<\/span> \u56fe\u50cf\u4ea7\u751f\u65f6\u95f4,<\/span> uItems as<\/span> \u68c0\u67e5\u90e8\u4f4d,<\/span>udevicetype as<\/span> \u56fe\u50cf\u4ea7\u751f\u8bbe\u5907,<\/span> 1 as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vuptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ‘2018-12-31’<\/span>,<\/span>”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.04.5 \uff085\u7ea7\u57fa\u7840\u9879\uff09\u6574\u5408\u6027\uff1a1.\u68c0\u67e5\u56fe\u50cf\u8bb0\u5f55\u4e0e\u68c0\u67e5\u7533\u8bf7\u8bb0\u5f55\uff08\u68c0\u67e5\u9879\u76ee\u3001\u60a3\u8005\u6807\u8bc6\uff09\u6709\u5bf9\u7167<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee<\/td>\n\u68c0\u67e5\u9879\u76ee<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n
\u60a3\u90fd\u6807\u8bc6<\/td>\n\u60a3\u8005\u6807\u8bc6<\/td>\nFYCS.vUptoServ. PatientID<\/td>\nFYCS.vUptoServ. PatientID<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> top<\/span> 10 uItems as<\/span> \u68c0\u67e5\u9879\u76ee,<\/span> PatientID as<\/span> \u60a3\u90fd\u6807\u8bc6,<\/span> 1 as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vuptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ‘ ‘<\/span>,<\/span> ‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

04.04.5 \uff085\u7ea7\u57fa\u7840\u9879\uff09\u6574\u5408\u6027\uff1a2.\u68c0\u67e5\u56fe\u50cf\u8bb0\u5f55\u4e0e\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55\uff08\u56fe\u50cf\u53f7\uff09\u6709\u5bf9\u7167<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u56fe\u50cf\u53f7<\/td>\n\u56fe\u50cf\u53f7<\/td>\nFYCS.vUptoServ. uAccnu<\/td>\nFYCS.vUptoServ. uAccnu<\/td>\n<\/tr>\n
\u62a5\u544a\u53f7<\/td>\n\u62a5\u544a\u53f7<\/td>\nFYCS.vUptoServ. uAccnu<\/td>\nFYCS.vUptoServ. uAccnu<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n

 <\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> top<\/span> 10 uaccnu as<\/span> \u56fe\u50cf\u53f7,<\/span> uAccnu as<\/span> \u62a5\u544a\u53f7,<\/span> 1 as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vuptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ‘ ‘<\/span>,<\/span> ‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e94\u3001\u75c5\u623f\u68c0\u67e5\u62a5\u544a<\/a>\u90e8\u4efd<\/h1>\n

01.05.3 \uff083\u7ea7\u57fa\u7840\u9879\uff09\u4e00\u81f4\u6027\uff1a\u68c0\u67e5\u9879\u76ee\u4ee3\u7801;<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee<\/td>\n\u68c0\u67e5\u9879\u76ee<\/td>\nFYCS.vUptoServ. uItems<\/td>\nFYCS.vUptoServ. uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n\n\n<\/colgroup>\n\n\n
use<\/span> fycs<\/p>\n

select<\/span> uItems as<\/span> \u68c0\u67e5\u9879 ,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span><\/p>\n

and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0 and<\/span> uPsource=<\/span>‘\u4f4f\u9662’<\/span><\/p>\n

group<\/span> by<\/span> uItems<\/p>\n

union<\/span> all<\/span> select<\/span> ‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0 and<\/span> uPsource=<\/span>‘\u4f4f\u9662’<\/span><\/p>\n

 <\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

01.05.4 \uff084\u7ea7\u57fa\u7840\u9879\uff09\u5b8c\u6574\u6027\uff1a\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55\uff08\u68c0\u67e5\u9879\u76ee\u540d\u79f0\u3001\u68c0\u67e5\u9879\u76ee\u7f16\u7801\u3001\u68c0\u67e5\u63cf\u8ff0\u3001\u8bca\u65ad\uff09;<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee\u7f16<\/td>\n\u68c0\u67e5\u9879\u76ee\u7f16<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n
\u68c0\u67e5\u7ed3\u8bba<\/td>\n\u68c0\u67e5\u7ed3\u8bba<\/td>\nFYCS.vUptoServ.uJianLun<\/td>\nFYCS.vUptoServ.uJianLun<\/td>\n<\/tr>\n
\u68c0\u67e5\u63cf\u8ff0<\/td>\n\u68c0\u67e5\u63cf\u8ff0<\/td>\nFYCS.vUptoServ. usuojian<\/td>\nFYCS.vUptoServ. usuojian<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n\n\n<\/colgroup>\n\n\n
use<\/span> fycs<\/p>\n

select<\/span> top<\/span> 10 uItems as<\/span> \u68c0\u67e5\u9879\u76ee\u540d\u79f0,<\/span> uItemID as<\/span> \u68c0\u67e5\u9879\u76ee\u4ee3\u7801,<\/span>usuojian,<\/span>uJianLun,<\/span> 1 as<\/span> \u6570\u91cf from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span><\/p>\n

and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0 and<\/span> uPsource=<\/span>‘\u4f4f\u9662’<\/span><\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span>”<\/span> ,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0 and<\/span> uPsource=<\/span>‘\u4f4f\u9662’<\/span><\/p>\n

 <\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

01.05.5 \uff084\u7ea7\u57fa\u7840\u9879\uff09\u5b8c\u6574\u6027\uff1a1.\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55\uff08\u62a5\u544a\u79d1\u5ba4\uff0c\u62a5\u544a\u533b\u5e08\uff0c\u68c0\u67e5\u8bca\u65ad\u7f16\u7801\uff0c\u5ba1\u6838\u533b\u5e08\u7f16\u7801\uff09;<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u62a5\u544a\u79d1\u5ba4<\/td>\n\u62a5\u544a\u79d1\u5ba4<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n
\u62a5\u544a\u533b\u5e08<\/td>\n\u62a5\u544a\u533b\u5e08<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n
\u68c0\u67e5\u8bca\u65ad\u7f16\u7801<\/td>\n\u68c0\u67e5\u8bca\u65ad\u7f16\u7801<\/td>\nFYCS.vUptoServ.uJianLun<\/td>\nFYCS.vUptoServ.uJianLun<\/td>\n<\/tr>\n
\u5ba1\u6838\u533b\u5e08\u7f16\u7801<\/td>\n\u5ba1\u6838\u533b\u5e08\u7f16\u7801<\/td>\nFYCS.vUptoServ. usuojian<\/td>\nFYCS.vUptoServ. usuojian<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> ExFiedInt1 as<\/span> \u5371\u6025\u503c ,<\/span>baogaodoc as<\/span> \u62a5\u544a\u533b\u751f,<\/span>‘\u8d85\u58f0\u79d1’<\/span> as<\/span> \u62a5\u544a\u79d1\u5ba4,<\/span>jianchajielun AS<\/span> \u68c0\u67e5\u8bca\u65ad\u7f16\u7801 ,<\/span>shenhedoc as<\/span> \u5ba1\u6838\u533b\u751f\u7f16\u7801,<\/span>‘1’<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> patient<\/p>\n

where<\/span><\/p>\n

baogaoriqi >=<\/span>‘2018-10-01 00:00:00’<\/span><\/p>\n

and<\/span> baogaoriqi<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> patientsource=<\/span>‘\u4f4f\u9662’<\/span> and<\/span> ExFiedInt1><\/span>0<\/p>\n

 <\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span>”<\/span>,<\/span>”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>COUNT<\/span>(<\/span>id)<\/span> from<\/span> patient<\/p>\n

where<\/span> baogaoriqi >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> baogaoriqi<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> patientsource=<\/span>‘\u4f4f\u9662’<\/span> and<\/span> ExFiedInt1><\/span>0<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

01.05.5 \uff084\u7ea7\u57fa\u7840\u9879\uff09\u5b8c\u6574\u6027\uff1a2.\u68c0\u67e5\u5371\u6025\u503c\u8bb0\u5f55\uff08\u68c0\u67e5\u9879\u76ee\u7f16\u7801\u3001\u901a\u77e5\u5bf9\u50cf\u3001\u901a\u77e5\u65f6\u95f4\u3001\u5904\u7406\u4eba\u3001\u5904\u7406\u8bb0\u5f55\u5185\u5bb9\uff09;<\/h2>\n

\u62a5\u544a\u5de5\u4f5c\u7ad9\u4e2d\u65e0\u4e9b\u529f\u80fd\u3002<\/p>\n

01.05.5 \uff084\u7ea7\u57fa\u7840\u9879\uff09\u6574\u5408\u6027\uff1a\u68c0\u67e5\u7cfb\u7edf\u4e0e\u75c5\u623f\u68c0\u67e5\u7cfb\u7edf\u4e2d\u7684\u9879\u76ee\u7f16\u7801\u3001\u540d\u79f0\u53ef\u5bf9\u7167;<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n<\/tr>\n
\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u9879\u76ee\u90e8\u4f4d<\/td>\nFYCS.vUptoServ.uItems<\/td>\nFYCS.vUptoServ.uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n\n\n<\/colgroup>\n\n\n
select<\/span> uItems as<\/span> \u68c0\u67e5\u9879\u76ee ,<\/span>uItemID as<\/span> \u9879\u76ee\u7f16\u53f7 from<\/span> vUptoServ<\/p>\n

where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0 group<\/span> by<\/span> uItems,<\/span>uItemID<\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e94\u3001\u95e8\u8bca\u68c0\u67e5\u62a5\u544a\u90e8\u4efd<\/h1>\n

03.05.03 \uff083\u7ea7\u9009\u62e9\u9879\uff09\u4e00\u81f4\u6027\uff1a<\/h2>\n

3\u7ea7\u7684\u6570\u636e\u8d28\u91cf\u8981\u6c42\u4e00\u81f4\u6027\u7684\u9879\u76ee\u5305\u62ec\u68c0\u67e5\u9879\u76ee\u7f16\u7801\u3001\u9879\u76ee\u540d\u79f0\u3001\u68c0\u67e5\u90e8\u4f4d\u3002\u6570\u636e\u8d28\u91cf\u5206\u6790\u6240\u9700\u7684\u5177\u4f53\u6570\u636e\u5185\u5bb9\u4e0e\u6765\u6e90\u5217\u8868\u5982\u4e0b\uff1a<\/p>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/p>\n

 <\/td>\n<\/tr>\n

\u68c0\u67e5\u9879\u76ee\u7f16\u7801<\/td>\n\u68c0\u67e5\u9879\u76ee\u540d\u79f0<\/td>\nvUptoServ.uitems<\/td>\nvUptoServ.rmod<\/td>\n<\/tr>\n
\u9879\u76ee\u540d\u79f0<\/td>\n\u68c0\u67e5\u9879\u76ee\u7f16\u7801<\/td>\nvUptoServ.ritem<\/td>\nUptoServ.ritem<\/td>\n<\/tr>\n
\u68c0\u67e5\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u90e8\u4f4d<\/td>\nvUptoServ.ritem<\/td>\nvUptoServ.ritem<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u603b\u8ba1\uff1a 57293<\/p>\n

 <\/p>\n\n\n<\/colgroup>\n\n\n
Use pacs4all<\/p>\n

select<\/span> uitems as<\/span> \u68c0\u67e5\u9879\u76ee\u90e8\u4f4d,<\/span>uItemID as<\/span> \u9879\u76ee\u7f16\u7801 ,<\/span>COUNT<\/span>(*)<\/span> as<\/span> \u6570\u91cf<\/p>\n

from<\/span> vUptoServ<\/p>\n

where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uPsource=<\/span>‘\u95e8\u8bca’<\/span><\/p>\n

group<\/span> by<\/span> uitems,<\/span>uItemID<\/p>\n

union<\/span> all<\/span><\/p>\n

select<\/span> ”<\/span>,<\/span>‘\u603b\u8ba1\uff1a’<\/span>,<\/span>count<\/span>(*)<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uPsource=<\/span>‘\u95e8\u8bca’<\/span><\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

03.05.04\uff084\u7ea7\u9009\u62e9\u9879\uff09\u5b8c\u6574\u6027\uff1a\u95e8\u8bca\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55\uff08\u62a5\u544a\u5355\u53f7\u3001\u60a3\u8005\u6807\u8bc6\u3001\u60a3\u8005\u540d\u79f0\u3001\u9879\u76ee\u7f16\u7801\u3001\u9879\u76ee\u540d\u79f0\u3001\u68c0\u67e5\u90e8\u4f4d\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/p>\n

 <\/td>\n<\/tr>\n

\u62a5\u544a\u5355\u53f7<\/td>\n\u62a5\u544a\u5355\u53f7<\/td>\nvUptoServ.uaccnu<\/td>\nvUptoServ. uaccnu<\/td>\n<\/tr>\n
\u60a3\u8005\u6807\u8bc6<\/td>\n\u60a3\u8005\u6807\u8bc6<\/td>\nvUptoServ.patientid<\/td>\nUptoServ.ritem<\/td>\n<\/tr>\n
\u60a3\u8005\u540d\u79f0<\/td>\n\u60a3\u8005\u6807\u8bc6<\/td>\nvUptoServ.uname<\/td>\nvUptoServ. uname<\/td>\n<\/tr>\n
\u9879\u76ee\u7f16\u7801<\/td>\n\u60a3\u8005\u540d\u79f0<\/td>\nvUptoServ.uitemid<\/td>\nvUptoServ. uitemid<\/td>\n<\/tr>\n
\u9879\u76ee\u540d\u79f0<\/td>\n\u9879\u76ee\u540d\u79f0<\/td>\nvUptoServ.uitems<\/td>\nvUptoServ. uitems<\/td>\n<\/tr>\n
\u68c0\u67e5\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u90e8\u4f4d<\/td>\nvUptoServ.uitems<\/td>\nvUptoServ. uitems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u603b\u8ba1 54492<\/p>\n\n\n<\/colgroup>\n\n\n
use<\/span> Pacs4all<\/p>\n

— \u62a5\u544a\u5355\u53f7\u3001\u60a3\u8005\u6807\u8bc6\u3001\u60a3\u8005\u540d\u79f0\u3001\u9879\u76ee\u7f16\u7801\u3001\u9879\u76ee\u540d\u79f0\u3001\u68c0\u67e5\u90e8\u4f4d<\/span><\/p>\n

select<\/span> top<\/span> 10 uAccnu as<\/span> \u68c0\u67e5\u62a5\u544a\u7f16\u53f7 ,<\/span>PatientID as<\/span> \u60a3\u8005\u6807\u8bc6,<\/span>uName as<\/span> \u59d3\u540d,<\/span>uItemID as<\/span> \u9879\u76ee\u7f16\u7801,<\/span><\/p>\n

uItems as<\/span> \u9879\u76ee\u540d\u79f0,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u62a5\u544a\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span>‘ ‘<\/span>,<\/span>”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<<\/span><\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

03.05.04\uff084\u7ea7\u9009\u62e9\u9879\uff09\u5b8c\u6574\u6027\uff1a\u95e8\u8bca\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55<\/a>\uff08\u62a5\u544a\u533b\u5e08\u7f16\u7801\u3001\u533b\u5e08\u59d3\u540d\u3001\u60a3\u8005\u5e74\u9f84\uff08\u51fa\u751f\u65e5\u671f\uff09\u3001\u8bca\u65ad\u7f16\u7801\uff09<\/h2>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/p>\n

 <\/td>\n<\/tr>\n

\u62a5\u544a\u533b\u5e08\u7f16\u7801<\/td>\n\u62a5\u544a\u533b\u5e08\u7f16\u7801<\/td>\nvUptoServ. uRptDoc<\/td>\nvUptoServ. uRptDoc<\/td>\n<\/tr>\n
\u533b\u5e08\u59d3\u540d<\/td>\n\u533b\u5e08\u59d3\u540d<\/td>\nvUptoServ. uexamdoc<\/td>\nUptoServ. uexamdoc<\/td>\n<\/tr>\n
\u60a3\u8005\u5e74\u9f84<\/td>\n\u60a3\u8005\u5e74\u9f84<\/td>\nvUptoServ.uname<\/td>\nvUptoServ. uname<\/td>\n<\/tr>\n
\u9879\u76ee\u7f16\u7801<\/td>\n\u9879\u76ee\u7f16\u7801<\/td>\nvUptoServ. uAge<\/td>\nvUptoServ. uAge<\/td>\n<\/tr>\n
\u8bca\u65ad\u7f16\u7801<\/td>\n\u8bca\u65ad\u7f16\u7801<\/td>\nvUptoServ. uJianLun<\/td>\nvUptoServ. uJianLun<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u603b\u8ba1 54492<\/p>\n\n\n<\/colgroup>\n\n\n
use<\/span> Pacs4all<\/p>\n

— \u62a5\u544a\u533b\u5e08\u7f16\u7801\u3001\u533b\u5e08\u59d3\u540d\u3001\u60a3\u8005\u5e74\u9f84\uff08\u51fa\u751f\u65e5\u671f\uff09\u3001\u8bca\u65ad\u7f16\u7801<\/span><\/p>\n

select<\/span> top<\/span> 10 uRptDoc as<\/span> \u62a5\u544a\u533b\u5e08\u7f16\u7801 ,<\/span>uexamdoc as<\/span> \u533b\u5e08\u59d3\u540d,<\/span>uAge as<\/span> \u60a3\u8005\u5e74\u9f84,<\/span>uJianLun as<\/span> \u8bca\u65ad\u7f16\u7801,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u62a5\u544a\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span> ”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

03.05.05 \uff085\u7ea7\u57fa\u7840\u9879\uff09\u6574\u5408\u9879\uff1a\u95e8\u8bca\u68c0\u67e5\u62a5\u544a\u8bb0\u5f55\u4e0e\u95e8\u8bca\u68c0\u67e5\u7533\u8bf7\u5355\u8bb0\u5f55\uff08\u7533\u8bf7\u5355\u53f7\u3001\u9879\u76ee\u7f16\u7801\u3001\u9879\u76ee\u540d\u79f0\u3001\u68c0\u67e5\u90e8\u4f4d\uff09\u9879\u76ee\u5bf9\u7167<\/h2>\n

 <\/p>\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
\u8981\u6c42\u9879\u76ee<\/td>\n\u533b\u9662\u9879\u76ee<\/td>\n\u6570\u636e\u5e93\u8868\u4e0e\u5b57\u6bb5\u540d<\/td>\n\u6570\u636e\u5b57\u5178\u8868\u4e0e\u5b57\u6bb5\u540d<\/p>\n

 <\/td>\n<\/tr>\n

\u7533\u8bf7\u5355\u53f7<\/td>\n\u7533\u8bf7\u5355\u53f7<\/td>\nvUptoServ. uItemID<\/td>\nvUptoServ. uItemID<\/td>\n<\/tr>\n
\u9879\u76ee\u7f16\u7801<\/td>\n\u9879\u76ee\u7f16\u7801<\/td>\nvUptoServ. uItemID<\/td>\nUptoServ. uItemID<\/td>\n<\/tr>\n
\u9879\u76ee\u540d\u79f0<\/td>\n\u9879\u76ee\u540d\u79f0<\/td>\nvUptoServ. uItems<\/td>\nvUptoServ. uItems<\/td>\n<\/tr>\n
\u68c0\u67e5\u90e8\u4f4d<\/td>\n\u68c0\u67e5\u90e8\u4f4d<\/td>\nvUptoServ. uItems<\/td>\nvUptoServ. uItems<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u603b\u8ba1 54492<\/p>\n\n\n<\/colgroup>\n\n\n
use<\/span> Pacs4all<\/p>\n

— \u7533\u8bf7\u5355\u53f7\u3001\u9879\u76ee\u7f16\u7801\u3001\u9879\u76ee\u540d\u79f0\u3001\u68c0\u67e5\u90e8\u4f4d<\/span><\/p>\n

select<\/span> top<\/span> 10 uItemID as<\/span> \u7533\u8bf7\u5355\u53f7 ,<\/span>uItemID as<\/span> \u9879\u76ee\u7f16\u7801,<\/span>uItems as<\/span> \u9879\u76ee\u540d\u79f0,<\/span>uItems as<\/span> \u68c0\u67e5\u90e8\u4f4d,<\/span>1 as<\/span> \u6570\u91cf,<\/span>uRptDate as<\/span> \u62a5\u544a\u65f6\u95f4<\/p>\n

from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

union<\/span> all<\/span> select<\/span> ”<\/span>,<\/span>”<\/span>,<\/span> ”<\/span>,<\/span>‘\u603b\u8ba1’<\/span>,<\/span>count<\/span>(<\/span>uAccnu)<\/span> as<\/span> \u6570\u91cf,<\/span>‘2018-12-31 00:00:00’<\/span> from<\/span> vUptoServ where<\/span> uRptDate >=<\/span>‘2018-10-01 00:00:00’<\/span> and<\/span> uRptDate<=<\/span>‘2018-12-31 23:59:59’<\/span> and<\/span> uItemID<><\/span>0<\/p>\n

 <\/p>\n

 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u4e8c\u3001\u68c0\u67e5\u8bb0\u5f55\u90e8\u4efd 04.02.3\u68c0\u67e5\u8bb0\u5f55\uff1a 3\u7ea7\u7684\u6570\u636e\u8d28\u91cf\u8981\u6c42\u4e00\u81f4\u6027\u7684\u9879\u76ee\u5305\u62ec\u68c0\u67e5\u9879\u76ee\u3001\u90e8\u4f4d\uff0c\u6570\u636e\u8d28\u91cf\u5206\u6790\u6240\u9700 […]<\/p>\n","protected":false},"author":1,"featured_media":1107,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[55],"series":[],"class_list":{"0":"post-1106","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-hangyenews","8":"tag-55","10":"post-with-thumbnail","11":"post-with-thumbnail-large"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=\/wp\/v2\/posts\/1106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1106"}],"version-history":[{"count":2,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=\/wp\/v2\/posts\/1106\/revisions"}],"predecessor-version":[{"id":1109,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=\/wp\/v2\/posts\/1106\/revisions\/1109"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=\/wp\/v2\/media\/1107"}],"wp:attachment":[{"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1106"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/www.tairongkj.com\/index.php?rest_route=%2Fwp%2Fv2%2Fseries&post=1106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}