{"id":870,"date":"2021-03-17T06:08:37","date_gmt":"2021-03-16T22:08:37","guid":{"rendered":"http:\/\/www.dxQerp.com\/?p=870"},"modified":"2024-02-03T07:40:56","modified_gmt":"2024-02-02T23:40:56","slug":"preface_dxq-12_l%ef%bc%bfdesign-blueprint","status":"publish","type":"post","link":"http:\/\/www.dxQerp.com\/?p=870","title":{"rendered":"DxQ_L \u524d\u8a00"},"content":{"rendered":"<div>DxQ_L \u8a2d\u8a08\u85cd\u5716<\/div>\n<p><span style=\"color: #993300;\"><strong>\u5546\u696d\u908f\u8f2f\u00a0<\/strong><\/span> \u662f\u5b8c\u5168\u4f9d\u64da\u00a0 \u5143\u5fd7\u79d1\u6280\u00a0 \u7684 IE ERP \u7684\u67b6\u69cb \u70ba\u4e3b (\u4ee3\u865f L \u662f\u8868\u4eba\u4e8b\u7cfb\u7d71, 12\u70ba\u7248\u672c\u865f).<br \/>\n<span style=\"color: #993300;\"><strong>\u524d\u7aef\u5de5\u5177<\/strong><\/span>\u662f dBase\u00a0 2019 \u7684\u8996\u7a97\u8868\u55ae\u00a0 ( VB.net \u505a\u6e96\u5099 ) .<br \/>\n<strong><span style=\"color: #993300;\">\u5f8c\u7aef\u8cc7\u6599\u5eab<\/span><\/strong>\u662f\u00a0MS SQL 2014\u00a0 \u7684\u8cc7\u6599\u5b58\u653e\u5340 (\u542bview,\u00a0store procedure, FunCtion\u00a0\u00a0) .<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p><strong><span style=\"color: #993300;\">IE ERP<\/span><\/strong>,\u5728\u7d2f\u7a4d\u904e\u591a\u5ba2\u6236\u5ba2\u5236\u7684\u75d5\u8de1\u5f8c, \u5c0e\u81f4\u7cfb\u7d71\u770b\u8d77\u4f86\u6709\u9ede\u4e82,\u57fa\u672c\u529f\u80fd\u6c92\u554f\u984c,\u4f46\u662f\u5916\u52a0\u7684\u529f\u80fd,\u5c31\u8655\u8655\u986f\u5f97\u7f3a\u5931 \uff08\u7a0b\u5f0fBUG \u96a8\u8655\u53ef\u4ee5\u89f8\u767c\uff09\uff0e\u6240\u4ee5\u6211\u9069\u7576\u7684\u8abf\u6574, \u4f8b\u5982\u8a02\u55ae\u8207\u63a1\u8cfc\u55ae\u3000\u5f9e\u570b\u5167\u8a02\u55ae\u8207\u570b\u5167\u63a1\u8cfc,\u5c31\u6709\u6b04\u4f4d\u904e\u591a\u7684\u554f\u984c..\u589e\u52a0\u4f7f\u7528\u8005\u7684\u64cd\u4f5c\u96e3\u5ea6..<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p><span style=\"color: #993300;\"><strong>\u524d\u7aef\u5de5\u5177<\/strong><\/span> \u4e3b\u8981\u662f\u53c3\u8003\u00a0 <a title=\"http:\/\/http:\/\/www.goldenstag.net\/dbase\/Tutorial\/00_index.htm\" href=\"http:\/\/http\/\/www.goldenstag.net\/dbase\/Tutorial\/00_index.htm\" target=\"_blank\" rel=\"noopener\">http:\/\/www.goldenstag.net\/dbase\/Tutorial\/00_index.htm<\/a>\u00a0\u7684\u6587\u4ef6 \u7522\u751f\u51fa\u4f86.<br \/>\n\u6240\u4ee5 \u8868\u55ae\u7684 \u7269\u4ef6\u5c0e\u5411, QUERY, \u5831\u8868, \u8f49 EXCEL\u00a0 \u90fd\u662f \u53c3\u8003 \u9019\u500b\u6559\u5b78\u6587\u4ef6<\/p>\n<ul>\n<li>\u65e9\u5148\u7684\u5de5\u5177\u662f2.8 \u7248\u8d70\u7684(\uff22\uff24\uff25)\u9023\u7d50\u8cc7\u6599\u5eab(MS SQL 2000)<\/li>\n<li>\u4f9d\u5e8f 8.x \u7248\u672c,<\/li>\n<li>9.x \u7248\u672c(\u4eba\u4e8b\u5916\u639b),<\/li>\n<li>10.x(\u5728\u6211\u7684\u6e2c\u8a66\u5340),<\/li>\n<li>11.x\u00a0 For Win 10 (\u5728\u529b\u97e1),<\/li>\n<li>12.x\u8df3\u904e,<\/li>\n<li>2019.x For \u5929\u5357\u516c\u53f8\u8d70\uff08\uff21\uff24\uff2f\uff09\u9023\u7d50\u8cc7\u6599\u5eab\uff08\u76ee\u524d\u9032\u884c\u5f0f\uff09<\/li>\n<\/ul>\n<p><strong>ADO \u6a21\u5f0f<\/strong> \u7684\u8a9e\u6cd5\u4e0d\u540c\u65bc <strong>BDE \u6a21\u5f0f<\/strong>,\u3000\u6240\u4ee5\u5728 11.x For Win 10 \u5e7e\u4e4e\u662f try Error \u4e2d\u8d70\u904e\uff0e<br \/>\n\u6240\u4ee5\u5148\u524d\u5229\u7528 Query.SQL =[Exec S_L2R2 @X] \u7684\u8a9e\u6cd5&#8230; \u901a\u901a\u653e\u68c4..<\/p>\n<ul>\n<li>\u70ba\u4f8b\u8b93GRID \u7684Data Link \u9023\u7d50\u65b9\u4fbf\u9ede (\u610f\u601d\u5728\u63db\u53c3\u6578\u503c\u6642),\u53ea\u80fd\u4f7f\u7528<span style=\"color: #993300;\"><strong>View<\/strong><\/span> \u8207<span style=\"color: #993300;\"><strong>Function<\/strong><\/span>\u00a0, \u9019\u6a23\u5e36\u8b8a\u6578reQuery() \u5c31\u5feb\u5f88\u591a.<\/li>\n<li>\u4e0d\u7136\u5c31\u662f\u8d70<strong><span style=\"color: #993300;\">\u5b50\u8868\u55ae<\/span><\/strong>\u5448\u73fe<\/li>\n<li>\u6216\u662f <span style=\"color: #800000;\"><strong>\u5148\u65b7\u958b\u9023\u7d50<\/strong><\/span>\uff08DataLink\uff09,\u00a0<strong><span style=\"color: #800000;\">\u505c\u7528\u00a0\u9810\u5b58\u7a0b\u5e8f<\/span><\/strong>, active=false , <span style=\"color: #800000;\"><strong>\u63db\u53c3\u6578\u503c, <\/strong><\/span>\u518d<strong><span style=\"color: #800000;\">\u555f\u52d5<\/span><\/strong>\u00a0active=true \u5728<strong><span style=\"color: #800000;\">Grid.DataLink<\/span><\/strong>..(Grid \u518d\u6b21\u9023\u7d50\u76f8\u95dc<span style=\"color: #800000;\"><strong>\u7269\u4ef6\u7684\u5c6c\u6027<\/strong><\/span>\u9700\u8981<strong><span style=\"color: #800000;\">\u91cd\u65b0\u8a2d\u5b9a<\/span><\/strong>)\uff08\u5728C1Q38\u7684 Query 2 \u5c31\u5f88\u660e\u986f\uff09\uff0e<\/li>\n<\/ul>\n<hr \/>\n<p><span style=\"color: #993300;\"><strong>\u5f8c\u7aef\u8cc7\u6599\u5eab<\/strong><\/span> \u66f4\u65b0\u5347\u7d1a\u5230ms SQL 2014 \u7248,<\/p>\n<p>\u5c07<strong>\u65e5\u671f\u6b04\u4f4d<\/strong>,\u5f9e<span style=\"color: #000000;\"><strong>\u6587\u5b57\u6a21\u5f0f<\/strong><\/span>\u6539\u6210<strong>Date<\/strong> \u6216\u662f<strong>smalldatetime<\/strong> . \u4e3b\u8981\u662f xxx_M \u8cc7\u6599\u5eab\u7684\u5efa\u7acb.<\/p>\n<p>\u5efa\u7acb<strong>\u4e2d\u6587\u6b04\u4f4d\u540d\u7a31<\/strong>\u7684\u8cc7\u6599\u8868\uff08\u6b04\u4f4d\u4e2d\u6587\u5316, \u6709\u9ede\u760b\u72c2\u5594\uff01\uff09<\/p>\n<p>\u5927\u91cf\u5229\u7528<strong>View<\/strong> ,<strong>\u5206\u5272\u8cc7\u6599<\/strong>, \u4f9d\u64da <strong>Form<\/strong> \u8868\u55ae\u7684<strong>\u4ee3\u865f<\/strong>, \u547d\u540d<strong>\u6aa2\u8996\u540d\u7a31<\/strong>. \u8868\u55ae Q1=View1, Q2=View2<\/p>\n<p>\u5927\u91cf\u7684<strong>Storeprocedure<\/strong> \u662f\u4f9d\u64da\u5728<strong>View<\/strong>,\u00a0 \u505a\u8cc7\u6599\u7684<strong>\u81ea\u52d5\u5316<\/strong>\u6216\u662f<strong>\u8cc7\u6599\u5f59\u6574<\/strong> ..<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8a2d\u8a08\u7684\u85cd\u5716<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3,5],"tags":[],"class_list":["post-870","post","type-post","status-publish","format-standard","hentry","category-dxq_erp","category-dxq_l"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/870","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=870"}],"version-history":[{"count":12,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/870\/revisions"}],"predecessor-version":[{"id":882,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=\/wp\/v2\/posts\/870\/revisions\/882"}],"wp:attachment":[{"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=870"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.dxQerp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}