{"id":982,"date":"2021-04-24T07:20:27","date_gmt":"2021-04-23T23:20:27","guid":{"rendered":"http:\/\/www.dxQerp.com\/?p=982"},"modified":"2024-02-03T07:38:19","modified_gmt":"2024-02-02T23:38:19","slug":"material-receipts-four-models","status":"publish","type":"post","link":"http:\/\/www.dxQerp.com\/?p=982","title":{"rendered":"\u7528\u6599\u55ae\u64da \u56db\u5927\u6a21\u5f0f (\u7cfb\u5217 C)"},"content":{"rendered":"<p><strong>(<\/strong><strong>\u8a08\u756b\u7528\u6599<\/strong>\u00a0<strong>\u6599\u4ef6\u865b\u55ae)\u55ae\u64da\u4f5c\u696d\u56db\u5927\u6a21\u5f0f\u00a0. <\/strong><\/p>\n<ul>\n<li><strong>\u672a\u751f\u6548<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f (<\/strong>\u55ae\u865f\u6e05\u55ae\uff0c \u9700\u8981\u00a0<strong>\u7d93\u8fa6\u4eba(\u90e8\u9580)<\/strong>\u3001<strong>\u5c0d\u8c61\u985e\u578b<\/strong>\u3001\u8207<strong>\u5c0d\u8c61\u4ee3\u865f<\/strong>\u00a0\u7be9\u9078\u55ce\u00a0<strong>)<\/strong><\/li>\n<li><strong>\u751f\u6548<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f (<\/strong>\u8a08\u756b\u7528\u6599\u7684\u8a08\u7b97\u5340\u3001\u9700\u8981\u00a0<strong>\u7d93\u8fa6\u4eba(\u90e8\u9580)<\/strong>\u3001<strong>\u5c0d\u8c61\u985e\u578b<\/strong>\u3001\u8207<strong>\u5c0d\u8c61\u4ee3\u865f<\/strong>\u00a0\u7be9\u9078\u55ce<strong>)<\/strong><\/li>\n<li><strong>\u7d50\u6848<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f (\u00a0<\/strong>\u8a08\u756b\u7528\u6599\uff0c\u5e74\u6708\uff0c\u7d93\u8fa6\u4eba(\u90e8\u9580)\u3001\u5c0d\u8c61\u985e\u578b\u3001\u8207\u5c0d\u8c61\u4ee3\u865f(\u7be9\u9078)\uff0c\u5229\u7528 \u7279\u7d50\uff0c\u89c0\u5bdf\u8a08\u756b\u57f7\u884c\u7684\u6548\u7387<strong>)<\/strong>\u3002<\/li>\n<li><strong>\u5c01\u5b58<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f (\u00a0<\/strong>\u8a08\u756b\u7528\u6599\uff0c\u5e74\u6708\uff0c\u7d93\u8fa6\u4eba(\u90e8\u9580)\u3001\u5c0d\u8c61\u985e\u578b\u3001\u8207\u5c0d\u8c61\u4ee3\u865f(\u7be9\u9078)\uff0c\u5229\u7528 \u7279\u7d50\uff0c\u89c0\u5bdf\u8a08\u756b\u57f7\u884c\u7684\u6548\u7387<strong>)<\/strong>\u3002<\/li>\n<\/ul>\n<ul>\n<li><strong>\u672a\u751f\u6548<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f<\/strong>\u00a0(<strong>\u65b0\u589e<\/strong>\u3001<strong>\u7de8\u4fee<\/strong>\u3001<strong>\u522a\u9664<\/strong>\u00a0\u901a\u7a31<strong>\u7570\u52d5\u74b0\u5883<\/strong>) -&gt; \u55ae\u865f(\u6e05\u55ae)\u3002<\/li>\n<li><strong>\u751f\u6548<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f<\/strong>\u00a0(\u9810\u8a08(\u9032)\uff0c\u9810\u8a08(\u51fa) )\u3002\n<ul>\n<li>\u55ae\u8eab\u90e8\u5206\u53ef\u80fd\u5148\u7d50\u6848\uff0c\u5b8c\u6210\u8a08\u756b\u7528\u6599\u7684\u90e8\u5206\uff0c\u76f4\u63a5\u7d50\u6848\u3002<\/li>\n<li>\u53ef\u4ee5\u7279\u7d50(\u7528\u6599\u8a08\u756b\uff0c\u505c\u6b62\u9032\u884c)\u3002(\u7279\u7d50\u4f5c\u696d \u53e6\u5916\u8a2d\u8a08 \u4e00\u500b\u8868\u55ae \u5c08\u8cac\u8655\u7406)\u3002<\/li>\n<li>\u5229\u7528<strong>\u8b8a\u66f4\u55ae<\/strong>\u00a0\u8b8a\u66f4\u00a0<strong>\u672a\u7d50\u6848<\/strong>\u7684\u7528\u6599\u8a08\u756b\u3002<\/li>\n<\/ul>\n<\/li>\n<li><strong>\u7d50\u6848<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f<\/strong>\u00a0(\u67e5\u7528\u6599\u8a08\u756b\u7684\u6b77\u53f2\u8ecc\u8de1)\u3002(\u9700\u8981\u4e00\u500b\u8868\u55ae\uff0c\u5c08\u8cac\u8655\u7406)\u3002<\/li>\n<li><strong>\u5c01\u5b58<\/strong><strong>\u00a0<\/strong><strong>\u6a21\u5f0f<\/strong>\u00a0(\u5c07\u6bd4\u8f03\u4e45\u7684\uff0c\u7528\u6599\u8a08\u756b\uff0c\u5c01\u5b58) \u2013 &gt; \u5c01\u5b58\u5f8c\u53ef\u4ee5 \u9032\u884c<strong>\u522a\u9664\u4f5c\u696d<\/strong>\u3002(\u5c01\u5b58\u4f5c\u696d \u9700\u8981\u4e00\u500b\u8868\u55ae \u5c08\u8cac\u8655\u7406)\u3002<\/li>\n<\/ul>\n<p>\u5229\u7528 \u5b50\u8868\u55ae \u8a2d\u8a08 \u7be9\u9078\u689d\u4ef6 ..(\u689d\u4ef6 \u5f62\u6210 SQL \u8ff0\u53e5)\u3002\u8b8a\u6210 \u55ae\u865f\u7684\u6e05\u55ae\u7684\u4f86\u6e90\u3002<\/p>\n<p><strong>(<\/strong><strong>\u6599\u4ef6\u9032\u51fa\u7684\u5be6\u969b\u7d00\u9304\u00a0\u6599\u4ef6\u5be6\u55ae)\u55ae\u64da\u4f5c\u696d\u6a21\u5f0f\u00a0<\/strong>.<\/p>\n<ul>\n<li><strong>\u95dc\u5e33\u6a21\u5f0f<\/strong>(<strong>\u8ca1\u52d9<\/strong>\u7d50\u5e33\u7684\u55ae\u64da)\u00a0<strong>(<\/strong>\u55ae\u865f\u6e05\u55ae\uff0c \u9700\u8981\u00a0<strong>\u7d93\u8fa6\u4eba(\u90e8\u9580)<\/strong>\u3001<strong>\u5c0d\u8c61\u985e\u578b<\/strong>\u3001\u8207<strong>\u5c0d\u8c61\u4ee3\u865f<\/strong>\u00a0\u7be9\u9078\u55ce\u00a0<strong>)\u00a0<\/strong>\u3002<\/li>\n<li><strong>\u73fe\u884c\u5e74\u6708\u6a21\u5f0f<\/strong>(<strong>\u65b0\u589e<\/strong>\u3001<strong>\u7de8\u4fee<\/strong>\u3001<strong>\u522a\u9664<\/strong>\u00a0\u901a\u7a31<strong>\u7570\u52d5\u74b0\u5883<\/strong>) (<strong>\u8ca1\u52d9\u5c1a\u672a<\/strong>\u7d50\u5e33\u7684\u55ae\u64da)\u00a0<strong>(<\/strong>\u55ae\u865f\u6e05\u55ae\uff0c \u9700\u8981\u00a0<strong>\u7d93\u8fa6\u4eba(\u90e8\u9580)<\/strong>\u3001<strong>\u5c0d\u8c61\u985e\u578b<\/strong>\u3001\u8207<strong>\u5c0d\u8c61\u4ee3\u865f<\/strong>\u00a0\u7be9\u9078\u55ce\u00a0<strong>)<\/strong>\u3002<\/li>\n<\/ul>\n<p>\u4e0a\u9762\u4e3b\u8981\u7522\u751f\u7684<strong>\u55ae\u865f<\/strong>\u00a0\u4fbf\u65bc \u700f\u89bd\u8207\u7570\u52d5\u3002<\/p>\n<p>\u5728 \u7121\u7570\u52d5\u72c0\u6cc1\u4e0b (\u67e5\u8a62\u6a21\u5f0f) \u914d\u5408\u5e74\u6708 \u7684\u7be9\u9078 \u907f\u514d\u8cc7\u6599\u904e\u591a..<\/p>\n<ul>\n<li>\u55ae\u982d<strong>\u65b0\u589e<\/strong>\u00a0( lbox.value=1, form.xspin1.value=1 )\n<ul>\n<li>cta.enabled := false (\u55ae\u982d \u76f8\u95dc\u63a7\u5236\u9805 \u505c\u7528\uff0c\u812b\u96e2\u6c38\u9060 \u4fdd\u6301\u958b\u555f\u72c0\u614b)<\/li>\n<li>ctd.enabled := false (\u55ae\u8eab \u76f8\u95dc\u63a7\u5236\u9805 \u505c\u7528)<\/li>\n<li>cte.enabled := false (\u55ae\u8eab\u4e0b\u7684\u5448\u73fe\u5340 \u505c\u7528)<\/li>\n<\/ul>\n<\/li>\n<li>xcaa.Pageno:= 1 (\u55ae\u982d \u8cc7\u6599\u8655\u7406\u5340 \u4e0a\u6d6e)<\/li>\n<li>\u9001\u51fa \u6216\u662f \u653e\u68c4\n<ul>\n<li>\u9001\u51fa\n<ul>\n<li>(\u55ae\u982d<strong>\u8cc7\u6599\u8655\u7406\u5340<\/strong>\u00a0\u4e0b\u6c89)<\/li>\n<li>\u55ae\u982d \u5448\u73fe\u65b0\u7684\u8cc7\u6599 (\u5c07<strong>\u8cc7\u6599\u8655\u7406\u5340<\/strong>\u00a0\u8f49\u5370 \u904e\u53bb\u3002\u6216\u662f \u5229\u7528\u00a0<strong>\u55ae\u865f\u79fb\u52d5<\/strong>\u7684\u65b9\u5f0f \u5448\u73fe\u51fa\u4f86)\u3002<\/li>\n<li>\u89f8\u52d5\u55ae\u8eab\u7684\u65b0\u589e\u4f5c\u696d\u3002\n<ul>\n<li>\u55ae\u8eab\u00a0<strong>\u8cc7\u6599\u8655\u7406\u5340\u00a0<\/strong>\u4e0a\u6d6e \u5728\u7b2c\u4e00\u500b\u5bb9\u5668\u4f4d\u7f6e<\/li>\n<li>\u55ae\u8eab\u5bb9\u5668 \u6e05\u7a7a\u3002\u7576\u7b2c\u4e00\u7b46\u8cc7\u6599\u751f\u6210\u5f8c,\u624d\u7522\u751f\u7b2c\u4e00\u500b\u5bb9\u5668\u3002<\/li>\n<\/ul>\n<\/li>\n<li>\u653e\u68c4\n<ul>\n<li>(\u55ae\u982d<strong>\u8cc7\u6599\u8655\u7406\u5340<\/strong>\u00a0\u4e0b\u6c89)<\/li>\n<li>\u55ae\u982d \u6709\u8cc7\u6599, \u6062\u5fa9 \u76f8\u95dc\u63a7\u5236\u9805\u7684\u529f\u80fd\u3002<\/li>\n<li>\u55ae\u982d\u6c92\u8cc7\u6599\uff0c\u505c\u5728\u00a0<strong>\u812b\u96e2\u9375<\/strong>\u4e0a\u3002<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>\u55ae\u982d<strong>\u7de8\u4fee<\/strong>\u00a0( lbox.value=1, form.xspin1.value=2 )\n<ul>\n<li>cta.enabled := false (\u55ae\u982d \u76f8\u95dc\u63a7\u5236\u9805 \u505c\u7528\uff0c\u812b\u96e2\u6c38\u9060 \u4fdd\u6301\u958b\u555f\u72c0\u614b)<\/li>\n<li>ctd.enabled := false (\u55ae\u8eab \u76f8\u95dc\u63a7\u5236\u9805 \u505c\u7528)<\/li>\n<li>cte.enabled := false (\u55ae\u8eab\u4e0b\u7684\u5448\u73fe\u5340 \u505c\u7528)<\/li>\n<\/ul>\n<\/li>\n<li>xcaa.Pageno:= 1 (\u55ae\u982d \u8cc7\u6599\u8655\u7406\u5340 \u4e0a\u6d6e\uff0c\u5728\u7de8\u4fee\u6a21\u5f0f\u7684\u6709\u4e9b\u6b04\u4f4d\u4e0d\u80fd\u4fee\u6539,\u5728\u6b64\u8655\u7406)<\/li>\n<li>\u9001\u51fa \u6216\u662f \u653e\u68c4\n<ul>\n<li>\u6062\u5fa9 \u76f8\u95dc\u63a7\u5236\u9805\u7684\u529f\u80fd\u3002<\/li>\n<li>\u55ae\u982d<strong>\u8cc7\u6599\u8655\u7406\u5340<\/strong>\u00a0\u4e0b\u6c89<\/li>\n<li>\u9001\u51fa\n<ul>\n<li>\u55ae\u982d \u5448\u73fe\u65b0\u7684\u8cc7\u6599 (\u5c07<strong>\u8cc7\u6599\u8655\u7406\u5340<\/strong>\u00a0\u8f49\u5370 \u904e\u53bb\u3002 \u6216\u662f \u5229\u7528\u00a0<strong>\u55ae\u865f\u79fb\u52d5<\/strong>\u7684\u65b9\u5f0f \u5448\u73fe\u51fa\u4f86)\u3002<\/li>\n<\/ul>\n<\/li>\n<li>\u653e\u68c4 \u5448\u73fe\u539f\u8c8c\u3002<\/li>\n<\/ul>\n<\/li>\n<li>\u55ae\u982d<strong>\u522a\u9664<\/strong>\u00a0( lbox.value=1, form.xspin1.value=3 ) \u6216\u662f \u4f5c\u5ee2(\u53e6\u985e\u7d50\u6848) \u3002\n<ul>\n<li>\u6210\u529f\u5f8c \u79fb\u5230\u4e0b\u4e00\u7b46 (ListBox) \u6216\u662f \u6700\u5f8c\u4e00\u7b46\u3002<\/li>\n<li>\u6c92\u6709\u8cc7\u6599\u6642 \u505c\u5728\u00a0<strong>\u812b\u96e2\u9375<\/strong>\u4e0a<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>(\u8a08\u756b\u7528\u6599\u00a0\u6599\u4ef6\u865b\u55ae)\u55ae\u64da\u4f5c\u696d\u56db\u5927\u6a21\u5f0f\u00a0. \u672a\u751f\u6548\u00a0\u6a21\u5f0f (\u55ae\u865f\u6e05\u55ae\uff0c \u9700\u8981\u00a0\u7d93\u8fa6\u4eba(\u90e8\u9580)\u3001\u5c0d\u8c61\u985e\u578b\u3001\u8207\u5c0d\u8c61 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[],"class_list":["post-982","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dxq_erp"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.dxQerp.com\/wp-content\/uploads\/2020\/09\/cropped-tz1bkncn8qk-scaled-1.jpg?fit=210%2C101","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/982","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=982"}],"version-history":[{"count":1,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/982\/revisions"}],"predecessor-version":[{"id":983,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/982\/revisions\/983"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/media\/226"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=982"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=982"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=982"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}