{"id":8278,"date":"2021-09-07T17:30:45","date_gmt":"2021-09-07T09:30:45","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=8278"},"modified":"2022-11-28T11:25:44","modified_gmt":"2022-11-28T03:25:44","slug":"%e3%80%90%e5%ae%9e%e4%b9%a0%e4%b9%8bt100%e5%bc%80%e5%8f%91%e3%80%91t100%e7%a8%8b%e5%ba%8f%e4%b8%80%e4%ba%9b%e5%b8%b8%e7%94%a8%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=8278","title":{"rendered":"\u3010\u5b9e\u4e60\u4e4bT100\u5f00\u53d1\u3011T100\u7a0b\u5e8f\u4e00\u4e9b\u5e38\u7528\u4ee3\u7801"},"content":{"rendered":"<p>\u672c\u7ae0\u8282\u5305\u542b\u4ee5\u4e0b\u5185\u5bb9\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">1\u3001azzq171 \u53ef\u67e5\u8be2\u51fd\u6570\u8bf4\u660e\r\n\r\n2\u3001adzi170 \u53ef\u6267\u884cSQL\uff0c\u67e5\u770b\u6570\u636e\u5e93\u6570\u636e\r\n\r\n3\u3001\u63d0\u793a\u62a5\u9519\u4fe1\u606f(\u5f39\u6846)\r\n\r\n4\u3001\u5e74\u9f84\u9650\u5236 18~60\r\n\r\n5\u3001\u5ba1\u6838\u540e\u4fee\u6539\u8eab\u4efd\u8bc1\r\n\r\n6\u3001[\u5df2\u5ba1\u6838]\u548c[\u65e0\u6548] \u72b6\u6001\u4e0b\u65e0\u6cd5\u4fee\u6539\r\n\r\n7\u3001\u5355\u53f7\u5f00\u7a97\u9700\u8981\u4f20\u53c2\u6570\uff08\u53c2\u7167\u8868\u7f16\u53f7\u3001\u7a0b\u5e8f\u7f16\u53f7\uff09+ \u5f00\u7a97\u6d4b\u8bd5\u5de5\u5177\u4f7f\u7528\r\n\r\n8\u3001\u5f00\u7a97\u53c2\u6570\u5199\u6210\u5168\u5c40\u53d8\u91cf\r\n\r\n9\u3001\u9879\u6b21\u81ea\u589e\r\n\r\n10\u3001\u5f00\u7a97\u9009\u62e9\u540e\uff0c\u70b9\u51fb[\u786e\u5b9a]\u540e\u76f4\u63a5\u5e26\u503c\r\n\r\n11\u3001\u5ba1\u6838\u76f8\u5173\r\n\r\n12\u3001[\u5df2\u5ba1\u6838]\u4e0d\u5141\u8bb8\u76f4\u63a5\u5931\u6548\uff0c[\u5931\u6548]\u4e0d\u5141\u8bb8\u76f4\u63a5\u5ba1\u6838\r\n\r\n13\u3001\u5355\u8eab\u6ca1\u6709\u6570\u636e\uff0c\u5ba1\u6838\u4f1a\u62a5\u9519\r\n\r\n14\u3001\u8d44\u6599\u5f02\u52a8\u4e2d, \u8d44\u6599\u5ba1\u6838\u8005,\u8d44\u6599\u5ba1\u6838\u65e5\u671f\r\n\r\n15\u3001\u5df2\u5ba1\u6838\u65f6\u9690\u85cf\u672a\u5ba1\u6838\uff0c\u5931\u6548\u65f6\u9690\u85cf\u5ba1\u6838\r\n\r\n16\u3001\u6570\u636e\u5e93\u67e5\u8be2\u51fa\u67d0\u4e2a\u503c\u5e76\u663e\u793a\u5728\u753b\u9762\u4e0a\r\n\r\n17\u3001\u6e90\u7801\u5206\u6790\r\n\r\n18\u3001\u5f00\u7a97\u4ee3\u7801<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h1>azzq171 \u53ef\u67e5\u8be2\u51fd\u6570\u8bf4\u660e<\/h1>\n<h1>adzi170 \u53ef\u6267\u884cSQL\uff0c\u67e5\u770b\u6570\u636e\u5e93\u6570\u636e<\/h1>\n<h1>\u63d0\u793a\u62a5\u9519\u4fe1\u606f(\u5f39\u6846)<\/h1>\n<pre class=\"pure-highlightjs\"><code class=\"null\">INITIALIZE g_errparam TO NULL \r\nLET g_errparam.extend = \"\u8b66\u544a\uff1a\"       #\u9519\u8bef\u4fe1\u606f\u7684\u524d\u7f00\r\nLET g_errparam.code = 'aap-00113'      #\u9519\u8bef\u4fe1\u606f\u4ee3\u7801\uff0c\u5728\u5e38\u7528\u5de5\u5177-&gt;\u9519\u8bef\u8baf\u606f\u7ef4\u62a4\u4f5c\u4e1a\u4e2d\u6dfb\u52a0\r\nLET g_errparam.popup = FALSE           #\u9519\u8bef\u4fe1\u606f\u662f\u5426\u9700\u8981\u5f39\u6846\uff08false\u4e0d\u7528\uff0ctrue\u5219\u6709\uff09\r\nCALL cl_err()\r\nNEXT FIELD CURRENT  \r\n<\/code><\/pre>\n<h1>\u5e74\u9f84\u9650\u5236 18~60<\/h1>\n<ul>\n<li>cl_null()\u00a0\u7528\u4e8e\u5224\u65ad\u662f\u5426\u4e3a\u7a7a<\/li>\n<li>g_oozyuc_m.oozyuc004\u00a0\u83b7\u53d6\u8868\u5934\u53d8\u91cf<\/li>\n<li>azzi920 \u9519\u8bef\u4ee3\u7801\u7ef4\u62a4\uff0c&#8221;coo-00666&#8243;\u00a0\u662f\u6211\u81ea\u5b9a\u4e49\u7684\u9519\u8bef\u7f16\u53f7<\/li>\n<\/ul>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#\u68c0\u67e5\u5e74\u9f84\u5fc5\u987b &gt;=18 \u5e76\u4e14 &lt;=60\r\n IF NOT cl_null(g_oozyuc_m.oozyuc004) THEN\r\n    IF g_oozyuc_m.oozyuc004 &lt; 18 OR g_oozyuc_m.oozyuc004 &gt; 60 THEN\r\n       INITIALIZE g_errparam TO NULL \r\n       LET g_errparam.extend = \"\"\r\n       LET g_errparam.code   = \"coo-00666\"\r\n       LET g_errparam.popup = TRUE \r\n       CALL cl_err()\r\n       NEXT FIELD oozyuc004\r\n    END IF\r\n END IF\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p><strong>\u62a5\u9519<\/strong>\u00a0\u4ee3\u7801\u6bb5\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">INITIALIZE g_errparam TO NULL \r\nLET g_errparam.extend = \"\"\r\nLET g_errparam.code   = \"coo-00666\" #azzi920\u7ef4\u62a4\u9519\u8bef\u7801\r\nLET g_errparam.popup = TRUE \r\nCALL cl_err()\r\n# NEXT FIELD oozyuc005\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h1>\u5ba1\u6838\u540e\u4fee\u6539\u8eab\u4efd\u8bc1<\/h1>\n<p>\u4e0d\u8981\u5fd8\u8bb0\u5728 ui_dialog \u91cc\u5b9a\u4e49\u53d8\u91cf\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">DEFINE l_success LIKE type_t.num10<\/code><\/pre>\n<p>\u5728 ON ACTION modify_sfz \u5904\u6dfb\u52a0\u4ee3\u7801\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#\u61c9\u7528 a43 \u6a23\u677f\u81ea\u52d5\u7522\u751f(Version:4)\r\nON ACTION modify_sfz\r\n   LET g_action_choice=\"modify_sfz\"\r\n   IF cl_auth_chk_act(\"modify_sfz\") THEN\r\n      \r\n      #add-point:ON ACTION modify_sfz name=\"menu2.modify_sfz\"\r\n      #\u5355\u636e\u5fc5\u987b\u662f\u5ba1\u6838\u72b6\u6001\u624d\u80fd\u6267\u884c\u8fd9\u4e2a\u529f\u80fd\r\n      IF g_oozyuc_m.oozyucstus = 'Y' THEN\r\n         #\u56e0\u4e3a\u4fee\u6539\u753b\u9762\u4e0a\u7684\u8eab\u4efd\u8bc1\u9700\u8981\u5f02\u52a8\u5230\u6570\u636e\u8868,\u6240\u4ee5\u9700\u8981\u5f00\u542f\u4e8b\u52a1\r\n         CALL s_transaction_begin()\r\n         #\u901a\u8fc7\u4e0b\u9762\u51fd\u6570\u8fd4\u56de\u7684l_success,\u5224\u65ad\u4e8b\u52a1\u662f\u63d0\u4ea4\u8fd8\u662f\u56de\u6eda\r\n         CALL cooi666_modify_sfz() RETURNING l_success\r\n         IF NOT l_success THEN\r\n            CALL s_transaction_end('N', '0') #\u56de\u6eda\r\n         ELSE \r\n            CALL s_transaction_end('Y', '0') #\u63d0\u4ea4\r\n         END IF\r\n      ELSE #\u62a5\u9519,\u5355\u636e\u72b6\u6001\u4e0d\u662f\u5ba1\u6838,\u4e0d\u80fd\u70b9\u6b64\u6309\u94ae\r\n         INITIALIZE g_errparam TO NULL \r\n         LET g_errparam.extend = \"\" \r\n         LET g_errparam.code = \"coo-00667\"\r\n         LET g_errparam.popup = TRUE\r\n         CALL cl_err()\r\n         EXIT MENU #\u62a5\u9519\u540e\u9000\u51faMENU\r\n      END IF\r\n      #END add-point\r\n      \r\n   END IF<\/code><\/pre>\n<p>\u7136\u540e\u53bb\u5199 cooi666_modify_sfz() \u51fd\u6570\u7684\u4ee3\u7801\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">PRIVATE FUNCTION cooi666_modify_sfz()\r\n   DEFINE l_success LIKE type_t.num10   #\u8fd4\u56de\u503c\r\n   #\u5c06\u8fd4\u56de\u503c\u9ed8\u8ba4\u4e3aTRUE,\u5728\u4e0b\u9762\u5982\u679c\u6709\u62a5\u9519\u5c31\u9ed8\u8ba4\u4e3afalse,\u8868\u793a\u4e8b\u52a1\u4f1a\u6267\u884c\u56de\u6eda\r\n   LET l_success = TRUE\r\n   \r\n   #\u5148\u5f00\u542f\u6e38\u6807\uff0c\u627e\u7684\u662fMAIN\u51fd\u6570\u91cc\u9762\u7684for update\u7684\u6e38\u6807\uff0c\u76ee\u7684\u662f\u4e3a\u4e86\u9501\u4f4f\u8fd9\u8fb9\u8d44\u6599\u4e0d\u88ab\u5176\u4ed6\u4eba\u4fee\u6539\r\n   OPEN cooi666_cl USING g_enterprise,g_oozyuc_m.oozyuc00\r\n\t\r\n   #\u8fd9\u91cc\u662f\u5224\u65adcooi123_cl\u8fd9\u4e2a\u6e38\u6807\u5bf9\u5e94\u5f97SQL\u8bed\u53e5\u6709\u65e0\u62a5\u9519\r\n   IF STATUS THEN #\u82e5\u62a5\u9519\uff0c\u8d70\u4e0b\u9762\u7684\u62a5\u9519\u4fe1\u606f\uff0c\u5e76\u4e14\u5173\u95ed\u6e38\u6807\uff0c\u76f4\u63a5\u8fd4\u56deFALSE\r\n      INITIALIZE g_errparam TO NULL\r\n      LET g_errparam.extend = \"OPEN cooi666_cl:\"\r\n      LET g_errparam.code = STATUS\r\n      LET g_errparam.popup = TRUE\r\n      CALL cl_err()\r\n      CLOSE cooi666_cl #\u5173\u95ed\u6e38\u6807\r\n      LET l_success = FALSE\r\n      RETURN l_success #\u76f4\u63a5\u8fd4\u56de FALSE\r\n   END IF\r\n\r\n   #\u901a\u8fc7input\u8bed\u6cd5\u76f4\u63a5\u4fee\u6539\u8eab\u4efd\u8bc1\u53f7\uff0c\u5982\u679c\u4e0d\u5199input\uff0c\u4e0d\u80fd\u5728\u753b\u9762\u4e0a\u8f93\u5165\u5b57\u6bb5\u7684\u503c\r\n   DIALOG ATTRIBUTES(UNBUFFERED,FIELD ORDER FORM) \r\n      INPUT BY NAME g_oozyuc_m.oozyuc005 ATTRIBUTE(WITHOUT DEFAULTS)\r\n           BEFORE INPUT\r\n           \r\n           BEFORE FIELD oozyuc005\r\n           \r\n           AFTER FIELD oozyuc005  #\u6821\u9a8c\u5e26\u503c\r\n               IF NOT cl_null(g_oozyuc_m.oozyuc005) THEN\r\n                   #\u5199\u4e00\u4e9b\u5176\u4ed6\u903b\u8f91\r\n                   \r\n                   DISPLAY BY NAME g_oozyuc_m.oozyuc005\r\n               END IF\r\n           \r\n           ON CHANGE oozyuc005\r\n           \r\n           ON ACTION controlp INFIELD oozyuc005  #\u5982\u679c\u662f\u9700\u8981\u5f00\u7a97\u5199\u5728\u4e0b\u9762\r\n           \r\n           AFTER INPUT   #input\u8f93\u5165\u4e4b\u540e\uff0c\u76f4\u63a5\u66f4\u65b0\u5230\u6570\u636e\u5e93\r\n              UPDATE oozyuc_t SET oozyuc005 = g_oozyuc_m.oozyuc005\r\n                   WHERE oozyucent = g_enterprise\r\n                     AND oozyuc001 = g_oozyuc_m.oozyuc001\r\n                    \r\n                        IF SQLCA.SQLCODE THEN\r\n\t                        INITIALIZE g_errparam TO NULL \r\n\t                        LET g_errparam.extend = \"\"\r\n\t                        LET g_errparam.code = SQLCA.SQLCODE \r\n\t                        LET g_errparam.popup = TRUE\r\n\t                        CLOSE cooi666_cl                    \r\n\t                        CALL cl_err()\r\n\t                        LET l_success = FALSE\r\n                        END IF\r\n      END INPUT  #input\u7ed3\u675f\r\n      \r\n     ON ACTION controlf\r\n        CALL cl_set_focus_form(ui.Interface.getRootNode()) RETURNING g_fld_name,g_frm_name\r\n        CALL cl_fldhelp(g_frm_name, g_fld_name, g_lang)\r\n\r\n      ON ACTION controlr\r\n        CALL cl_show_req_fields()\r\n\r\n      ON ACTION controls\r\n        IF g_header_hidden THEN\r\n         CALL gfrm_curr.setElementHidden(\"vb_master\",0)\r\n         CALL gfrm_curr.setElementImage(\"controls\",\"small\/arr-u.png\")\r\n         LET g_header_hidden = 0     #visible\r\n      ELSE\r\n         CALL gfrm_curr.setElementHidden(\"vb_master\",1)\r\n         CALL gfrm_curr.setElementImage(\"controls\",\"small\/arr-d.png\")\r\n         LET g_header_hidden = 1     #hidden     \r\n      END IF\r\n   \r\n      ON ACTION accept\r\n        ACCEPT DIALOG\r\n        \r\n      ON ACTION cancel  #\u53d6\u6d88\r\n        LET INT_FLAG = TRUE\r\n        \r\n      ON ACTION close  #\u5173\u95ed,\u53f3\u4e0a\u89d2\u7684\uff08X\uff09\r\n        ACCEPT DIALOG\r\n        \r\n      ON ACTION exit   #\u79bb\u5f00\r\n        ACCEPT DIALOG\r\n           \r\n      #\u4ea4\u8ac7\u6307\u4ee4\u5171\u7528ACTION\r\n      &amp;include \"common_action.4gl\" \r\n         CONTINUE DIALOG \r\n   END DIALOG\r\n      \r\n   RETURN l_success\r\nEND FUNCTION<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h1>[\u5df2\u5ba1\u6838]\u548c[\u65e0\u6548] \u72b6\u6001\u4e0b\u65e0\u6cd5\u4fee\u6539<\/h1>\n<ul>\n<li>\u67093\u79cd\u72b6\u6001\uff1a<strong>N:\u672a\u5ba1\u6838<\/strong>\u3001<strong>X:\u65e0\u6548<\/strong>\u3001<strong>Y:\u5df2\u5ba1\u6838<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" width=\"136\" height=\"126\" class=\"wp-image-8279\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-217.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/li>\n<li>cl_set_act_visible()\uff1a\u7528\u4e8e\u8bbe\u7f6e\u529f\u80fd\u662f\u5426\u663e\u73b0<\/li>\n<\/ul>\n<p>\u5c06\u4ee3\u7801\u6dfb\u52a0\u5728 xxx_set_act_no_visible<br \/>\n<img loading=\"lazy\" decoding=\"async\" width=\"1541\" height=\"578\" class=\"wp-image-8280\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-218.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">IF g_oozyuc_m.oozyucstus NOT MATCHES \"[N]\" THEN #N\u672a\u5ba1\u6838\/X\u65e0\u6548\/Y\u5df2\u5ba1\u6838\r\n   CALL cl_set_act_visible(\"modify,delete,modify_detail\", FALSE)\r\nEND IF<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h1>\u5355\u53f7\u5f00\u7a97\u9700\u8981\u4f20\u53c2\u6570\uff08\u53c2\u7167\u8868\u7f16\u53f7\u3001\u7a0b\u5e8f\u7f16\u53f7\uff09+ \u5f00\u7a97\u6d4b\u8bd5\u5de5\u5177\u4f7f\u7528<\/h1>\n<p>\u4e0b\u56fe\u4e2d\uff0c\u5728 adzi210\u5f00\u7a97\u8bbe\u8ba1\u5668\u4e2d\u53ef\u4ee5\u770b\u5230\uff0c\u5355\u53f7\u7684\u5f00\u7a97\u8bc6\u522b\u7801<strong>\u8981\u6c42\u4f202\u4e2a\u53c2\u6570<\/strong>\uff0c\u5206\u522b\u662f\u00a0<strong>\u53c2\u7167\u8868\u7f16\u53f7<\/strong>\u00a0\u548c\u00a0<strong>\u7a0b\u5e8f\u7f16\u53f7<\/strong>\u00a0\uff0c\u9700\u8981\u6211\u4eec\u5728\u4ee3\u7801\u91cc\u6dfb\u52a0\u3002<\/p>\n<ul>\n<li><strong>\u53c2\u7167\u8868\u7f16\u53f7<\/strong>\u00a0\u5728\u4e0b\u9762\u7684\u3010\u5355\u636e\u522b\u5efa\u7acb\u6d41\u7a0b\u3011\u4e2d\u6709\u8bb2\uff0caooi100\u4e2d\u53ef\u4ee5\u67e5\u770b<\/li>\n<li><strong>\u7a0b\u5e8f\u7f16\u53f7<\/strong>\u5728\u4ee3\u7801\u91cc\u662f\u4e2a<strong>\u5168\u5c40\u53d8\u91cf<\/strong>\uff0cg_prog\uff0c\u672c\u7a0b\u5e8f\u4e2d\u5373\u00a0cxmt666<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1106\" height=\"143\" class=\"wp-image-8281\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-219.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" width=\"974\" height=\"692\" class=\"wp-image-8282\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-220.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p><strong>\u5f00\u7a97\u6d4b\u8bd5\u5de5\u5177\u7684\u4f7f\u7528<\/strong><br \/>\n\u5728 adzi210\u5f00\u7a97\u8bbe\u8ba1\u5de5\u5177\u4e2d\uff0c\u67e5\u51fa\u4e86\u5bf9\u5e94\u7684\u5f00\u7a97\u8bc6\u522b\u7801\u540e\uff0c\u70b9\u51fb\u3010\u5f00\u7a97\u6d4b\u8bd5\u5de5\u5177\u3011\uff0c\u7136\u540e\u5c06\u5bf9\u5e94\u7684\u53c2\u6570\u8f93\u5165\uff0c\u70b9\u51fb\u53f3\u8fb9\u7684\u5f00\u7a97\uff0c\u5373\u53ef\u67e5\u51fa\u5bf9\u5e94\u7684\u503c\u3002<\/p>\n<p>\u5982\u679c\u6ca1\u6709\u67e5\u51fa\u6765\uff0c\u6309\u7167\u3010\u5355\u636e\u522b\u5efa\u7acb\u6d41\u7a0b\u3011\u68c0\u67e5\u4e00\u904d\u6d41\u7a0b\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"869\" height=\"728\" class=\"wp-image-8283\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-221.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>\u5728\u00a0ON ACTION controlp INFIELD xmzyucdocno\uff0c\u5373\u70b9\u51fb\u5355\u53f7\u5f00\u7a97\u7684\u4f4d\u7f6e\uff0c\u5199\u4ee3\u7801\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#add by lzy #2021\/1\/27 \u6839\u636e\u5f53\u524d\u7684\u636e\u70b9\u627e\u5230\u5bf9\u5e94\u7684\u5355\u636e\u522b\u53c2\u7167\u8868\u53f7\r\nLET l_ooef004 = ''\r\nSELECT ooef004 INTO l_ooef004 FROM ooef_t\r\nWHERE ooefent = g_enterprise #\u4f01\u4e1a\u7f16\u53f7=\u5f53\u524d\u4f01\u4e1a\u7f16\u53f7\r\nAND ooef001 = g_site #\u7ec4\u7ec7\u7f16\u53f7=\u636e\u70b9 \r\n\r\n#\u7d66\u4e88arg\r\nLET g_qryparam.arg1 = l_ooef004\r\nLET g_qryparam.arg2 = g_prog #\u7a0b\u5e8f\u7f16\u53f7:cxmt666<\/code><\/pre>\n<p>\u6ce8\uff1al_ooef004\u00a0\u9700\u8981\u5728\u524d\u9762\u5b9a\u4e49\u53d8\u91cf\uff0c\u6211\u4eec\u5728\u00a0cxmt666_input\u00a0\u5f00\u5934\u5b9a\u4e49\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">DEFINE l_ooef004 LIKE ooef_t.ooef004 #add by lzy#2021\/1\/27 \u5355\u636e\u522b\u53c2\u7167\u8868\u53f7<\/code><\/pre>\n<h2>\u5f00\u7a97\u53c2\u6570\u5199\u6210\u5168\u5c40\u53d8\u91cf<\/h2>\n<p>\u5728\u4e0a\u9762\u6211\u4eec\u662f\u7528\u00a0l_\u00a0\u5f00\u5934\u7684\u5c40\u90e8\u53d8\u91cf\u7684\u65b9\u5f0f\u5199\u7684\uff0c\u4f46\u662f\u6709\u65f6\u5019\u5f88\u591a\u5f00\u7a97\u8981\u4f20\u7684\u53c2\u6570\u662f\u4e00\u6837\u7684\uff0c\u5982\u679c\u6bcf\u6b21\u90fd\u8981\u91cd\u65b0\u5199\uff0c\u90a3\u5c06\u5f88\u9ebb\u70e6\uff0c\u4e0d\u5982\u76f4\u63a5\u6539\u6210\u5168\u5c40\u53d8\u91cf\uff0c\u540e\u9700\u8981\u7528\u5230\u90fd\u53ef\u4ee5\u62ff\u6765\u7528\u3002<\/p>\n<p>\u5c06\u53d8\u91cf\u58f0\u660e\u5230 MAIN \u4e0a\u9762\u7684\u5168\u5c40\u533a\u57df\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#add-point:\u81ea\u5b9a\u7fa9\u6a21\u7d44\u8b8a\u6578(Module Variable) (\u8acb\u76e1\u91cf\u4e0d\u8981\u5728\u5ba2\u88fd\u74b0\u5883\u4fee\u6539\u6b64\u6bb5\u843d\u5167\u5bb9, \u5426\u5247\u5c07\u5f8c\u7e8cpatch\u7684\u8abf\u6574\u9700\u4eba\u5de5\u8655\u7406) name=\"global.variable\"\r\nDEFINE  g_ooef004 LIKE ooef_t.ooef004 #add by lzy#2021\/1\/27 \u5355\u636e\u522b\u53c2\u7167\u8868\u53f7\r\nDEFINE  g_ooef024 LIKE ooef_t.ooef024 #add by lzy#2021\/1\/27 \u4f9b\u5e94\u5546\u7f16\u53f7\r\nDEFINE  g_ooef019 LIKE ooef_t.ooef019 #add by lzy#2021\/1\/27 \u7a0e\u533a\u7f16\u53f7\r\n#end add-point<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>#end add-point<\/p>\n<p>\u5728\u00a0xxxx_init()\u00a0\u7684\u753b\u9762\u8d44\u6599\u521d\u59cb\u5316\u533a\u57df\u5199SQL\u67e5\u8be2\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#add-point:\u756b\u9762\u8cc7\u6599\u521d\u59cb\u5316 name=\"init.init\"\r\nLET g_ooef004 = ''\r\nLET g_ooef024 = ''\r\nSELECT ooef004,ooef024,ooef019 INTO g_ooef004,g_ooef024,g_ooef019 FROM ooef_t\r\nWHERE ooefent = g_enterprise #\u4f01\u4e1a\u7f16\u53f7=\u5f53\u524d\u4f01\u4e1a\u7f16\u53f7\r\nAND ooef001 = g_site #\u7ec4\u7ec7\u7f16\u53f7=\u636e\u70b9 \r\n#end add-point<\/code><\/pre>\n<p>\u6700\u540e\u5728\u00a0ON ACTION controlp INFIELD xxxxx\u00a0\u5904\u7ed9\u53c2\u6570\u8d4b\u503c\u5373\u53ef\u3002<\/p>\n<h1>\u9879\u6b21\u81ea\u589e<\/h1>\n<p>\u5728 axmt500\u00a0xxxx_input\u00a0&gt;\u00a0DIALOG\u00a0&gt;\u00a0BEFORE INSERT\u00a0\u4e0b\u7684\u00a0#\u9805\u6b21\u52a01\u00a0\u5904\u53ef\u4ee5\u635e\u5230\u4ee3\u7801\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#\u9805\u6b21\u52a01\r\nSELECT MAX(xmdcseq)+1 INTO g_xmdc_d[l_ac].xmdcseq FROM xmdc_t\r\n WHERE xmdcent = g_enterprise AND xmdcdocno = g_xmda_m.xmdadocno\r\nIF cl_null(g_xmdc_d[l_ac].xmdcseq) OR g_xmdc_d[l_ac].xmdcseq = 0 THEN\r\n   LET g_xmdc_d[l_ac].xmdcseq = 1\r\nEND IF<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h1>\u5f00\u7a97\u9009\u62e9\u540e\uff0c\u70b9\u51fb[\u786e\u5b9a]\u540e\u76f4\u63a5\u5e26\u503c<\/h1>\n<p>\u8fd9\u4e2a\u548c\u00a0AFTER FIELD\u00a0\u8fc7\u680f\u4f4d\u662f\u4e0d\u540c\u7684\uff0c\u9700\u8981\u5199\u5728\u5f00\u7a97\u540e\u9762\uff08ON ACTION\u91cc\uff09<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\"># add by lzy 2021\/2\/22 \u70b9\u51fb\u786e\u5b9a\u540e\u5c31\u663e\u793a\u53c2\u8003\u5b57\u6bb5(\u4e0e\u8fc7\u680f\u4f4d\u533a\u5206)\r\nINITIALIZE g_ref_fields TO NULL\r\nLET g_ref_fields[1] = g_xmaguc_m.xmaguc003\r\nCALL ap_ref_array2(g_ref_fields,\"SELECT pmaal004 FROM pmaal_t WHERE pmaalent=\"||g_enterprise||\" AND pmaal001=? AND pmaal002='\"||g_dlang||\"'\",\"\") RETURNING g_rtn_fields\r\nLET g_xmaguc_m.xmaguc003_desc = '', g_rtn_fields[1] , ''\r\nDISPLAY BY NAME g_xmaguc_m.xmaguc003_desc          <\/code><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1432\" height=\"550\" class=\"wp-image-8284\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-222.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h1>\u5ba1\u6838\u76f8\u5173<\/h1>\n<h2>[\u5df2\u5ba1\u6838]\u4e0d\u5141\u8bb8\u76f4\u63a5\u5931\u6548\uff0c[\u5931\u6548]\u4e0d\u5141\u8bb8\u76f4\u63a5\u5ba1\u6838<\/h2>\n<p>xxx_statechange\u00a0\u4e2d\u8bbe\u7f6e\u72b6\u6001\u7801\u53d8\u66f4\u540e\u7684\u64cd\u4f5c<\/p>\n<ul>\n<li>cl_set_act_visible\u00a0\u7528\u4e8e\u8bbe\u7f6e\u67d0\u4e2a\u529f\u80fd\u4e0d\u663e\u73b0<\/li>\n<\/ul>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#add-point:menu\u524d name=\"statechange.before_menu\"\r\nCASE g_xmaguc_m.xmagucstus\r\n   # \u5931\u6548\u4e0d\u5141\u8bb8\u5ba1\u6838\r\n   WHEN \"X\"\r\n      CALL cl_set_act_visible(\"valid\",FALSE)\r\n   # \u5df2\u5ba1\u6838\u4e0d\u5141\u8bb8\u5931\u6548\r\n   WHEN \"Y\"\r\n      CALL cl_set_act_visible(\"void\",FALSE)                   \r\n   #160204-00006#1--add--(E)           \r\nEND CASE<\/code><\/pre>\n<h2>\u5355\u8eab\u6ca1\u6709\u6570\u636e\uff0c\u5ba1\u6838\u4f1a\u62a5\u9519<\/h2>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#add-point:stus\u4fee\u6539\u524d name=\"statechange.b_update\"\r\nCASE g_xmaguc_m.xmagucstus\r\n# \u5355\u8eab\u6ca1\u6709\u6570\u636e,\u4e0d\u5141\u8bb8\u5ba1\u6838 add by lzy 2021\/2\/24\r\n   WHEN \"N\"\r\n      SELECT MAX(xmahucseq)+1 INTO g_xmahuc_d[l_ac].xmahucseq FROM xmahuc_t\r\n      WHERE xmahucent = g_enterprise AND xmahuc001 = g_xmaguc_m.xmaguc001\r\n      IF cl_null(g_xmahuc_d[l_ac].xmahucseq) OR g_xmahuc_d[l_ac].xmahucseq = 0 THEN\r\n         CLOSE cxmi902_cl\r\n         INITIALIZE g_errparam TO NULL \r\n         LET g_errparam.extend = \"\u8b66\u544a\uff1a\"       #\u9519\u8bef\u4fe1\u606f\u7684\u524d\u7f00\r\n         LET g_errparam.code = 'agl-00336'      #\u9519\u8bef\u4fe1\u606f\u4ee3\u7801\uff0c\u5728\u5e38\u7528\u5de5\u5177-&gt;\u9519\u8bef\u8baf\u606f\u7ef4\u62a4\u4f5c\u4e1a\u4e2d\u6dfb\u52a0\r\n         LET g_errparam.popup = TRUE           #\u9519\u8bef\u4fe1\u606f\u662f\u5426\u9700\u8981\u5f39\u6846\uff08false\u4e0d\u7528\uff0ctrue\u5219\u6709\uff09\r\n         CALL s_transaction_end('N','0')   #(ver:19)\r\n         CALL cl_err()\r\n         RETURN\r\n      END IF\r\nEND CASE<\/code><\/pre>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1242\" height=\"378\" class=\"wp-image-8285\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-223.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h1>\u8d44\u6599\u5f02\u52a8\u4e2d, \u8d44\u6599\u5ba1\u6838\u8005,\u8d44\u6599\u5ba1\u6838\u65e5\u671f<\/h1>\n<p>\u5199\u5728statechange\u00a0\u91cc\u7684\u00a0#add-point:stus\u4fee\u6539\u5f8c name=&#8221;statechange.a_update&#8221;\u00a0\u4e2d<br \/>\n\u4e3b\u8981\u662f\u4fee\u6539\u4e00\u4e0b\u6267\u884c\u7684SQL\uff0c\u5c06[\u8d44\u6599\u5ba1\u6838\u8005]\u548c[\u8d44\u6599\u5ba1\u6838\u65e5\u671f]\u4e00\u8d77\u53d8\u4e86<br \/>\n<img loading=\"lazy\" decoding=\"async\" width=\"1365\" height=\"693\" class=\"wp-image-8286\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-224.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<h1>\u5df2\u5ba1\u6838\u65f6\u9690\u85cf\u672a\u5ba1\u6838\uff0c\u5931\u6548\u65f6\u9690\u85cf\u5ba1\u6838<\/h1>\n<p>\u51fd\u6570\u00a0cl_set_act_visible\uff1a\u7528\u4e8e\u8bbe\u7f6e\u529f\u80fd\u662f\u5426\u663e\u73b0<\/p>\n<p>\u5728xxx_statechange\u91cc\u7684#add-point:menu\u524d name=&#8221;statechange.before_menu&#8221;\u4e2d\uff1a<\/p>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#add-point:menu\u524d name=\"statechange.before_menu\"\r\nCASE g_xmaguc_m.xmagucstus\r\n   WHEN \"X\"\r\n      CALL cl_set_act_visible(\"valid\",FALSE)\r\n\r\n   WHEN \"Y\"\r\n   \t  CALL cl_set_act_visible(\"void\",FALSE)                   \r\n   #160204-00006#1--add--(E)           \r\nEND CASE\r\n#end add-point<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h1>\u6570\u636e\u5e93\u67e5\u8be2\u51fa\u67d0\u4e2a\u503c\u5e76\u663e\u793a\u5728\u753b\u9762\u4e0a<\/h1>\n<pre class=\"pure-highlightjs\"><code class=\"null\">#\u6aa2\u67e5\u6210\u529f\u6642\u5f8c\u7e8c\u8655\u7406\r\n# add by lzy 2021\/2\/23 \u5f55\u5165\u65f6\u6839\u636e\u5ba2\u6237\u67e5\u8be2\u6700\u5927\u7248\u672c+1\u9884\u8bbe\r\nSELECT MAX(isdauc002) INTO g_isdauc_m.isdauc002\r\n   FROM isdauc_t\r\n   WHERE isdaucent = g_enterprise \r\n   AND isdaucsite = g_site\r\n   AND isdauc001 = g_isdauc_m.isdauc001 \r\nIF (cl_null(g_isdauc_m.isdauc002)) OR (g_isdauc_m.isdauc002=0)  THEN\r\n   LET g_isdauc_m.isdauc002 = 1 # \u4e3a\u7a7a\u6216\u8005\u4e3a0,\u90a3\u4e48\u7f6e\u4e3a1\r\nELSE\r\n   # \u4e0d\u4e3a\u7a7a\u4e0d\u4e3a0,\u5219\u5728\u6700\u5927\u7684\u57fa\u7840\u4e0a+1                  \r\n   LET g_isdauc_m.isdauc002 = g_isdauc_m.isdauc002 + 1\r\nEND IF\r\nDISPLAY BY NAME g_isdauc_m.isdauc002        <\/code><\/pre>\n<p>&nbsp;<\/p>\n<h1>\u6e90\u7801\u5206\u6790<\/h1>\n<h2>\u5f00\u7a97\u4ee3\u7801<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"1272\" height=\"357\" class=\"wp-image-8287\" src=\"https:\/\/www.hefeiyu.com\/wp-content\/uploads\/2022\/11\/unnamed-file-225.png\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" \/><\/p>\n<p>\u7248\u6743\u58f0\u660e\uff1a\u672c\u6587\u4e3a\u535a\u4e3b\u539f\u521b\u6587\u7ae0\uff0c\u9075\u5faa<a href=\"https:\/\/creativecommons.org\/licenses\/by-sa\/4.0\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u00a0CC 4.0 BY-SA\u00a0<\/a>\u7248\u6743\u534f\u8bae\uff0c\u8f6c\u8f7d\u8bf7\u9644\u4e0a\u539f\u6587\u51fa\u5904\u94fe\u63a5\u548c\u672c\u58f0\u660e\u3002<\/p>\n<p>\u672c\u6587\u94fe\u63a5\uff1a<a href=\"https:\/\/blog.csdn.net\/weixin_43734095\/article\/details\/112985307\">https:\/\/blog.csdn.net\/weixin_43734095\/article\/details\/112985307<\/a><\/p>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"https:\/\/www.hefeiyu.com\">\u8d6b\u975e\u57df<\/a> &raquo; <a href=\"https:\/\/www.hefeiyu.com\/?p=8278\">\u3010\u5b9e\u4e60\u4e4bT100\u5f00\u53d1\u3011T100\u7a0b\u5e8f\u4e00\u4e9b\u5e38\u7528\u4ee3\u7801<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>\u672c\u7ae0\u8282\u5305\u542b\u4ee5\u4e0b\u5185\u5bb9\uff1a 1\u3001azzq171 \u53ef\u67e5\u8be2\u51fd\u6570\u8bf4\u660e 2\u3001adzi170 \u53ef\u6267\u884cSQL\uff0c\u67e5\u770b\u6570\u636e\u5e93\u6570\u636e 3\u3001\u63d0\u793a\u62a5\u9519\u4fe1\u606f(\u5f39\u6846) 4\u3001\u5e74\u9f84\u9650\u5236 18~60 5\u3001\u5ba1\u6838\u540e\u4fee\u6539\u8eab\u4efd\u8bc1 6\u3001[\u5df2\u5ba1\u6838]\u548c[\u65e0\u6548] \u72b6\u6001\u4e0b\u65e0\u6cd5\u4fee\u6539 7\u3001\u5355\u53f7\u5f00\u7a97\u9700\u8981\u4f20\u53c2\u6570\uff08\u53c2 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[487,490],"tags":[60,1009,1010],"class_list":["post-8278","post","type-post","status-publish","format-standard","hentry","category-t100-erp","category-490","tag-4gl","tag-t100","tag-1010"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8278","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=8278"}],"version-history":[{"count":3,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8278\/revisions"}],"predecessor-version":[{"id":8668,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/8278\/revisions\/8668"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}