{"id":5312,"date":"2019-09-03T09:33:09","date_gmt":"2019-09-03T01:33:09","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=5312"},"modified":"2019-09-03T09:33:09","modified_gmt":"2019-09-03T01:33:09","slug":"t100%e5%bc%80%e7%aa%97%e8%ae%be%e8%ae%a1%e5%99%a8-%e6%9d%a1%e4%bb%b6%ef%bc%8c%e5%8f%82%e6%95%b0%ef%bc%8c%e8%bf%94%e5%9b%9e%e5%80%bc%e6%8e%a5%e6%94%b6%e6%98%be%e7%a4%ba","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=5312","title":{"rendered":"T100\u5f00\u7a97\u8bbe\u8ba1\u5668\u2014\u2014\u6761\u4ef6\uff0c\u53c2\u6570\uff0c\u8fd4\u56de\u503c\u63a5\u6536\u663e\u793a"},"content":{"rendered":"

\u5f00\u7a97\u8bbe\u8ba1\u5668\uff08adzi210 \u6216 c.q\uff09<\/strong><\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

\u5728SQL\u6307\u4ee4\u4e2d\uff0c<\/p>\n

SELECT DISTINCT <field>xmdtdocno,xmdtdocdt,xmdtstus,xmdt002,oofa011,xmdt003,ooefl003,xmdtua001,xmdtua002<\/field><\/p>\n

FROM <table>xmdt_t LEFT OUTER JOIN oofa_t ON oofa002 = ‘2’ AND oofa003 = xmdt002 AND oofaent = xmdtent<\/p>\n

LEFT OUTER JOIN ooefl_t ON ooefl001 = xmdt003 AND ooefl002 = :DLANG AND ooeflent = xmdtent<\/table><\/p>\n

WHERE\u00a0<wc>xmdtent = :ENT AND xmdtsite = :SITE AND xmdtstus = ‘Y'<\/wc><inwc><\/inwc><\/p>\n

ORDER BY xmdtdocno<\/p>\n

\u6ce8\u610fWHERE\u6761\u4ef6\uff1a<wc>\u91cc\u9762\u7684\u67e5\u8be2\u6761\u4ef6\u5728construct\u548cinput\u6bb5\u90fd\u4f1a\u751f\u6548\uff0c\u800c\u5199\u5728<inwc>\u91cc\u7684\u67e5\u8be2\u6761\u4ef6\u53ea\u4f1a\u5728\u7a0b\u5e8finput\u6bb5\u4e2d\u751f\u6548\u3002<\/p>\n

 <\/p>\n

\u5982\u9700\u6dfb\u52a0\u53c2\u6570\uff0c\u53ef\u89c1\uff1a<\/p>\n

SELECT DISTINCT <field>imaa001,imaal003,imaal004<\/field><\/p>\n

FROM <table>imaa_t LEFT OUTER JOIN imaal_t ON imaa001 = imaal001 AND imaaent = imaalent AND imaal002 = :DLANG <\/table><\/p>\n

WHERE <wc>imaaent = :ENT AND imaa004 NOT IN (‘T’,’X’) AND\u00a0imaaua003=’arg1′\u00a0AND imaastus = ‘Y'<\/wc><\/p>\n

ORDER BY imaa001<\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

\u5176\u4e2d\u7cfb\u7edf\u53c2\u6570\uff1a<\/p>\n

:ENT \u00a0\u2014\u2014 \u4f01\u4e1a\u7f16\u53f7<\/p>\n

:SITE\u3000\u3000\u2014\u2014 \u8fd0\u8425\u636e\u70b9<\/p>\n

:DLANG\u3000\u3000\u2014\u2014 \u8bed\u522b<\/p>\n

 <\/p>\n

 <\/p>\n

\u7a0b\u5e8f\u4e2d\uff0c\u4f20\u9012\u53c2\u6570\u3001\u63a5\u6536\u56de\u4f20\u503c\uff1a<\/p>\n

\u4f8b\u5b50\uff1a<\/p>\n

ON\u00a0ACTION\u00a0controlp\u00a0INFIELD\u00a0pmdsdocno
\nINITIALIZE\u00a0g_qryparam.*\u00a0TO\u00a0NULL\u3000\u3000\u2014\u2014\u5f00\u7a97\u524d\u5148\u628a\u53c2\u6570\u90fd\u521d\u59cb\u5316\u7a7a
\nLET\u00a0g_qryparam.state\u00a0=\u00a0‘c’\u3000\u3000\u3000\u3000\u2014\u2014c<\/strong>\u00a0\u662f\u591a\u9009\uff0c\u00a0i<\/strong>\u00a0\u662f\u5355\u9009
\nLET\u00a0g_qryparam.reqry\u00a0=\u00a0FALSE\u3000\u3000\u3000\u3000\u2014\u2014\u8fd8\u6ca1\u5f04\u660e\u786e\u8fd9\u4e2a\u53c2\u6570\u4f5c\u7528
\nLET\u00a0g_qryparam.where\u00a0=\u00a0” pmdsstus =’S’ “\u3000\u3000\u3000\u3000\u2014\u2014\u6539\u5199\u5f00\u7a97\u67e5\u8be2\u6761\u4ef6
\nLET\u00a0g_qryparam.arg1\u00a0=\u00a0‘6’\u3000\u3000\u3000\u3000\u2014\u2014\u4f20\u5165\u67e5\u8be2\u53c2\u6570\uff0c\u5982\u6709\u591a\u4e2a\u53c2\u6570\u5c31arg2\u3001arg3…
\nCALL\u00a0q_pmdsdocno()\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u3000\u3000\u2014\u2014\u5f00\u7a97\u52a8\u4f5c
\nDISPLAY\u00a0g_qryparam.return1\u00a0TO\u00a0pmdsdocno \u00a0\u3000\u3000\u3000\u3000\u2014\u2014\u63a5\u6536\u56de\u4f20\u503c\uff0c\u5e76\u663e\u793a\u5230pmdsdocno\u4e0a\uff1b\u5982\u6709\u591a\u4e2a\u56de\u4f20\u503c\u5c31return2\u3001return3…<\/p>\n

\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » T100\u5f00\u7a97\u8bbe\u8ba1\u5668\u2014\u2014\u6761\u4ef6\uff0c\u53c2\u6570\uff0c\u8fd4\u56de\u503c\u63a5\u6536\u663e\u793a<\/a><\/p>","protected":false},"excerpt":{"rendered":"

\u5f00\u7a97\u8bbe\u8ba1\u5668\uff08adzi210 \u6216 c.q\uff09     \u5728SQL\u6307\u4ee4\u4e2d\uff0c SELECT DISTINCT <field>xmdtdocno,xmdtdocdt,xmdtstus,xmdt002,oofa011,xmdt003 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[489],"tags":[815,816],"class_list":["post-5312","post","type-post","status-publish","format-standard","hentry","category-489","tag-field","tag-xmdt"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/5312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5312"}],"version-history":[{"count":1,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/5312\/revisions"}],"predecessor-version":[{"id":5315,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/5312\/revisions\/5315"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}