{"id":1076,"date":"2019-06-06T10:46:46","date_gmt":"2019-06-06T02:46:46","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=1076"},"modified":"2019-06-06T10:49:42","modified_gmt":"2019-06-06T02:49:42","slug":"tiptop-%e4%bc%9a%e8%ae%a1%e6%9c%9f%e9%97%b4%e3%80%81%e6%97%a5%e6%9c%9f%e5%8c%ba%e9%97%b4%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=1076","title":{"rendered":"TIPTOP \u4f1a\u8ba1\u671f\u95f4\u3001\u65e5\u671f\u533a\u95f4\u51fd\u6570"},"content":{"rendered":"

<\/p>\n

\n
\n

\u4f1a\u8ba1\u671f\u95f4\u3001\u65e5\u671f\u533a\u95f4<\/span><\/p>\n

1\u3001\u53d6\u4e00\u4e2a\u65e5\u671f\u7684 \u5e74\u3001\u6708\u3001\u65e5\u3001\u661f\u671f<\/span><\/p>\n

#TODAY\u3001YEAR(\u65e5\u671f)\u3001MONTH(\u65e5\u671f)\u3001DAY(\u65e5\u671f)\u3001WEEKDAY(\u65e5\u671f)   \r\nLET l_today = TODAY                 #\u5f53\u524d\u65e5\u671f   \r\nLET l_year  = YEAR(2014\/02\/13)      #\u53d6\u65e5\u671f\u7684\u5e74\uff1a2014   \r\nLET l_month  = MONTH(2014\/02\/13)    #\u53d6\u65e5\u671f\u7684\u6708\uff1a2   \r\nLET l_day  = DAY(2014\/02\/13)        #\u53d6\u65e5\u671f\u7684\u65e5\uff1a13   \r\n           = s_day(2014\/02\/13)  \r\nLET l_weekday = WEEKDAY(2014\/02\/13) #\u53d6\u65e5\u671f\u662f\u661f\u671f\u51e0\uff1a4  <\/code><\/pre>\n
\n
2\u3001\u53d6\u4e00\u4e2a\u65e5\u671f\u6240\u5728\u6708\u4efd\u7684 \u7b2c\u4e00\u5929\u3001\u6700\u540e\u4e00\u5929\u3001\u6708\u4e00\u5171\u591a\u5c11\u5929<\/span><\/p>\n
#s_months(\u65e5\u671f)\u3001s_first(\u65e5\u671f)\u3001s_getfirstday(\u65e5\u671f)\u3001s_last(\u65e5\u671f)\u3001s_getlastday(\u65e5\u671f)   \r\n#\u4e0b\u9762\u662f\u53ea\u8ba1\u7b97\u65e5\u671f\uff0c\u4e0d\u662f\u4f1a\u8ba1\u671f\u95f4\u7684\u6708\u521d\u3001\u6708\u672b\u5929\u3001\u4e00\u4e2a\u4f1a\u8ba1\u671f\u95f4\u591a\u5c11\u5929   \r\n#\u5982\u679c\u662f12\u671f\u5236\uff0c\u5219\u4e00\u822c\u90fd\u662f\u4e00\u6837\uff1b\u5177\u4f53\u8fd8\u8981\u8003\u8651aoos010\u3001aoos021\u3001aoos031\u7684\u671f\u95f4\u8bbe\u7f6e   \r\nLET l_monDays = s_months(2014\/02\/13)        #\u8fd4\u56de\u65e5\u671f\u6240\u5728\u6708\u4efd\u7684\u6708\u5929\u6570\uff1a28   \r\nLET l_monFirstDay  = s_first(2014\/02\/13)    #\u8fd4\u56de\u65e5\u671f\u6240\u5728\u6708\u4efd\u7684\u7b2c\u4e00\u5929\uff1a1   \r\n                   = s_getfirstday(2014\/02\/13)  \r\nLET l_monLastDay  = s_last(2014\/02\/13)      #\u8fd4\u56de\u65e5\u671f\u6240\u5728\u6708\u4efd\u7684\u6700\u540e\u4e00\u5929\uff1a28   \r\n                  = s_getlastday(2014\/02\/13)    <\/code><\/pre>\n
\n
3\u3001\u4f1a\u8ba1\u671f\u95f4\u76f8\u5173<\/span><\/p>\n
#1.\u53d6\u5f97\u65e5\u671f\u6240\u5728\u4f1a\u8ba1\u5e74\u6708: s_yp(\u65e5\u671f) RETURNING \u65e5\u671f\u6240\u5728\u4f1a\u8ba1\u5e74,\u65e5\u671f\u6240\u5728\u4f1a\u8ba1\u6708    \r\ns_yp(p_date) RETURNING l_year,l_month  \r\n#\u4ee3\u7801\uff1as_yp.4gl      \r\n# Input Parameter: p_date  \u65e5\u671f      \r\n# Return Code....: l_year  \u4f1a\u8ba1\u5e74\u5ea6   \r\n#                  l_month \u671f\u5225    \r\nDemo\uff1aCALL s_yp(p_date) RETURNING l_year,l_month  \r\n  \r\n  \r\n#2.\u53d6\u5f97\u65e5\u671f\u6240\u5728\u4f1a\u8ba1\u5e74or\u671f\u522bor\u5b63\u5ea6or\u5468   \r\ns_get_aznn(p_plant,p_bookno,p_date,p_flag) RETURN p_mm  \r\n#\u4ee3\u7801\uff1as_get_aznn.4gl      \r\n# Descriptions...: \u4f20\u5165\u8425\u8fd0\u4e2d\u5fc3,\u8d26\u522b\uff0c\u65e5\u671f\uff0c\u6293\u53d6aznn_file\u7684\u5e74\u5ea6\uff0c\u5b63\u522b\uff0c\u671f\u522b\u548c\u5468\u522b       \r\n# Input Parameter\uff1a                 \r\n#      p_plant            \u8425\u8fd0\u4e2d\u5fc3         \r\n#      p_bookno           \u8d26\u522b           \r\n#      p_date             \u65e5\u671f      \r\n#      p_flag             \u6807\u8bc6\u7b26   1\uff0c\u56de\u4f20\u5e74\u5ea6     2\uff0c\u56de\u4f20\u5b63\u522b       3\uff0c\u56de\u4f20\u671f\u522b            4\uff0c\u56de\u4f20\u5468\u522b      \r\n# Return code\uff1a    p_mm   \u56de\u4f20\u503c      \u5e74\u5ea6            \/\u5b63\u522b             \/\u671f\u522b                  \/\u5468\u522b   \r\nDemo\uff1aCALL s_get_aznn(p_plant,p_bookno,p_date,p_flag) RETURN p_mm  \r\n  \r\n  \r\n#3.\u6839\u636e\u5f53\u524d\u53d6\u5e74\u5ea6\u671f\u522b \u53d6 \u4e0a\u4e00\u671f\u5e74\u5ea6\u671f\u522b: s_lsperiod(\u672c\u671f\u5e74\u5ea6,\u672c\u671f\u671f\u522b) RETURNING \u4e0a\u671f\u5e74\u5ea6,\u4e0a\u671f\u671f\u522b   \r\ns_lsperiod(p_sma51,p_sma52) RETURNING l_sma51, l_sma52     \r\n#\u4ee3\u7801\uff1as_lsperiod.4gl      \r\n# Input Parameter: p_sma51   \u672c\u671f\u5e74\u5ea6                    \r\n#                  p_sma52   \u672c\u671f\u671f\u5225                    \r\n# Return code....: l_sma51,l_sma52    \r\nDemo\uff1aCALL s_lsperiod('2014','1') RETURNING 2013,12   #\u6ce8\u610f,\u9700\u662f\u5426\u662f12\u671f   \r\n  \r\n  \r\n#4.\u6839\u636e\u4f1a\u8ba1\u5e74,\u6708\uff0c\u53d6\u8be5\u4f1a\u8ba1\u5e74\u6708\u671f\u8d77\u59cb\u3001\u622a\u6b62\u65e5\u671f   \r\ns_azm(p_year,p_mon) RETURNING l_flag,l_bdate,l_edate  \r\n\u6216  \r\ns_azn01(p_year,p_month) RETURNING l_bdate,l_edate     \r\n#\u4ee3\u7801\uff1as_azm.4gl   \u6216 s_azn01.4gl   \r\n# Input PARAMETER: p_year  \u6703\u8a08\u5e74\u5ea6      \r\n#                  p_mon    \u65e5\u671f      \r\n# RETURN Code....: l_flag   \u6210\u529f\u5426      \r\n#                     1     YES      \r\n#                     0     NO      \r\n#                  l_bdate  \u8d77\u59cb\u65e5\u671f      \r\n#                  l_edate  \u622a\u6b62\u65e5\u671f   \r\nDemo\uff1aCALL s_azm(p_year,p_mon) RETURNING l_flag,l_bdate,l_edate  \r\nDemo\uff1aCALL s_azn01(p_year,p_month) RETURNING l_bdate,l_edate    \r\n  \r\n    \r\n#5.\u591a\u5e10\u522b\uff0c\u6839\u636e\u8be5\u5e10\u522b,\u4f1a\u8ba1\u5e74,\u6708\uff0c\u53d6\u8be5\u4f1a\u8ba1\u5e74\u6708\u671f\u8d77\u59cb\u3001\u622a\u6b62\u65e5\u671f   \r\ns_azmm01(p_year,p_month,p_ooz02p,p_ooz02b_c)  RETURNING l_bdate,l_edate  \r\n\u6216  \r\ns_azmm(p_year,p_mon,p_ooz02p,p_ooz02b_c) RETURNING l_flag,l_bdate,l_edate  \r\n#\u4ee3\u7801\uff1as_azmm01.4gl   \u6216 s_azmm.4gl     \r\n# Input PARAMETER: p_year      \u6703\u8a08\u5e74\u5ea6      \r\n#                  p_month     \u671f\u5225      \r\n#                  p_ooz02p    \u7e3d\u5e33\u7ba1\u7406\u7cfb\u7d71\u6240\u5728\u71df\u904b\u4e2d\u5fc3\u7de8\u865f        \r\n#                  p_ooz02b_c  \u7e3d\u5e33\u7ba1\u7406\u7cfb\u7d71\u4f7f\u7528\u5e33\u5957\u7de8\u865f       \r\n# RETURN Code....: l_flag      \u6210\u529f\u5426  1 YES\uff1b0 NO   \r\n#                  l_bdate     \u8d77\u59cb\u65e5\u671f     \r\n#                  l_edate     \u622a\u6b62\u65e5\u671f   \r\nDemo\uff1aCALL s_azmm(p_year,p_mon,p_ooz02p,p_ooz02b_c) RETURNING l_flag,l_bdate,l_edate    \r\nDemo\uff1aCALL s_azmm01(p_year,p_month,p_ooz02p,p_ooz02b_c)  RETURNING l_bdate,l_edate<\/code><\/pre>\n
\n
4\u3001\u5de5\u4f5c\u65e5\u3001\u4ea4\u671f\u8ba1\u7b97<\/span><\/p>\n
#1.\u68c0\u67e5\u5f53\u524d\u65e5\u662f\u5426\u5de5\u4f5c\u65e5:s_daywk(\u65e5\u671f) RETURNING \u8fd4\u56de\u662f\u5426\u5de5\u4f5c\u65e5   \r\ns_daywk(p_date) RETURNING l_flag    \r\n#\u4ee3\u7801\uff1as_daywk.4gl      \r\n# Input Parameter: p_date   date      \r\n# Return code....: 1  YES \u5de5\u4f5c\u65e5     \r\n#                  0  NO  \u975e\u5de5\u4f5c\u65e5    \r\n#                  2  \u7121\u8cc7\u6599 \u5de5\u4f5c\u65e5\u672a\u8bbe\u7f6e\uff0c\u68c0\u67e5asmp400\u3001asmi400   \r\nDemo\uff1aIF NOT s_daywk(p_date) ...   \r\n  \r\n  \r\n#2.\u68c0\u67e5\u5f53\u524d\u65e5\u662f\u5426\u5de5\u4f5c\u65e5:s_daywk(\u65e5\u671f) RETURNING \u8fd4\u56de\u662f\u5426\u5de5\u4f5c\u65e5,\u6700\u8fd1\u7684\u5de5\u4f5c\u65e5   \r\ns_wkday(p_date) RETURNING l_flag,l_date   \r\n#\u4ee3\u7801\uff1as_wkday.4gl      \r\n# Input Parameter: p_date   date      \r\n# Return code....: 1  YES \u5de5\u4f5c\u65e5  \/  0  NO  \u975e\u5de5\u4f5c\u65e5    \r\n#                  2  l_date  \u6700\u8fd1\u7684working date   \r\nDemo\uff1aCALL s_wkday(p_date) RETURNING l_flag,l_date  \r\n  \r\n  \r\n#3.\u8ba1\u7b972\u4e2a\u65e5\u671f\u533a\u95f4\u6709\u591a\u5c11\u4e2a\u5de5\u4f5c\u65e5:s_wksize(\u8d77\u59cb\u65e5,\u7ed3\u675f\u65e5) RETURNING \u8ba1\u7b97\u6b63\u786eflag,\u591a\u5c11\u4e2a\u5de5\u4f5c\u65e5   \r\ns_wksize(p_fdate,p_edate) RETURNING l_flag,l_n   \r\n#\u4ee3\u7801\uff1as_wksize.4gl     \r\n# Input Parameter: p_fdate  \u8d77\u59cb\u65e5\u671f      \r\n#                  p_edate  \u622a\u6b62\u65e5\u671f      \r\n# Return Code....: l_flag   0:\u6b63\u78ba 1:\u932f\u8aa4      \r\n#                  l_n      \u5de5\u4f5c\u65e5\u5929\u6578   \r\nDemo\uff1aCALL s_wksize(p_fdate,p_edate) RETURNING l_flag,l_n    \r\n  \r\n    \r\n#4.\u4ea4\u671f\u8ba1\u7b97\uff1a\u63a8\u7b97\u65e5\u671f, \u4f46\u8df3\u904e\u975e\u5de5\u4f5c\u65e5: s_aday(\u65e5\u671f,\u5411\u524dor\u5411\u540e,\u591a\u5c11\u5929) RETURNING \u63a8\u7b97\u51fa\u65e5\u671f   \r\ns_aday(p_date,p_op,p_offset) RETURNING l_date  \r\n#\u4ee3\u7801\uff1as_aday.4gl   \r\n# Input Parameter: p_date  \u65e5\u671f      \r\n#                  p_op    1:\u5f80\u540e\u63a8\u7b97      \r\n#                         -1:\u5f80\u524d\u63a8\u7b97      \r\n#                  p_offset       \u5929\u6578,\u7121\u689d\u4ef6\u9032\u4f4d      \r\n# Return Code....: p_wdate        working date    \r\nDemo\uff1aCALL s_aday(p_date,p_op,p_offset) RETURNING l_date <\/code><\/pre>\n
\n
\u5e93\u5b58\u6709\u6548\u671f\u8bbe\u7f6e\u3001\u68c0\u67e5\u5e93\u5b58\u6709\u6548\u671f\u3001\u5e93\u5b58\u6709\u6548\u671f\u5269\u4f59\u5929\u6570<\/span><\/p>\n
#1.\u68c0\u67e5\u6599+\u4ed3+\u5e93+\u6279\u7684\u5e93\u5b58\u662f\u5426\u8d85\u51fa\u6709\u6548\u671f   \r\ns_actimg(p_item,p_ware,p_loc,p_lot)  \r\n\u6216  \r\ns_actimg1(p_item,p_ware,p_loc,p_lot,p_dbs)  \r\n#\u4ee3\u7801\uff1as_actimg.4gl  \u6216 s_actimg1.4gl   \r\n# Input Parameter: p_item  \u6599\u4ef6\u7de8\u865f      \r\n#                  p_ware  \u5009\u5eab\u865f\u78bc      \r\n#                  p_loc   \u5132\u4f4d\u865f\u78bc      \r\n#                  p_lot   \u6279\u6b21      \r\n#                  p_dbs   \u8cc7\u6599\u5eab\u4ee3\u865f      \r\n# Return Code....: 0   \u8a72\u6279\u865f\u5df2\u904e\u671f      \r\n#                  1   \u8a72\u6279\u865f\u672a\u904e\u671f     \r\nDemo\uff1aIF NOT s_actimg1(p_item,p_ware,p_loc,p_lot,p_dbs) ...  <\/code><\/pre>\n
 <\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » TIPTOP \u4f1a\u8ba1\u671f\u95f4\u3001\u65e5\u671f\u533a\u95f4\u51fd\u6570<\/a><\/p>","protected":false},"excerpt":{"rendered":"
\u4f1a\u8ba1\u671f\u95f4\u3001\u65e5\u671f\u533a\u95f4 1\u3001\u53d6\u4e00\u4e2a\u65e5\u671f\u7684 \u5e74\u3001\u6708\u3001\u65e5\u3001\u661f\u671f #TODAY\u3001YEAR(\u65e5\u671f)\u3001MONTH(\u65e5\u671f)\u3001DAY(\u65e5\u671f)\u3001WEEKDAY(\u65e5\u671f) LET l_today = TODAY #\u5f53\u524d\u65e5\u671f LET l_year = YEAR(2014\/02 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[324],"class_list":["post-1076","post","type-post","status-publish","format-standard","hentry","category-4gl","tag-324"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1076","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=1076"}],"version-history":[{"count":3,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1076\/revisions"}],"predecessor-version":[{"id":1079,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/1076\/revisions\/1079"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1076"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1076"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}