[数据库编程] DATABASE
如果把企业的数据比做生命所必需的血液，那么数据库的设计就是应用中最重要的一部分。有关数据
库设计的材料汗牛充栋，大学学位课程里也有专门的讲述。不过，就如我们反复强调的那样，再好的
老师也比不过经验的教诲。所以我们最近找了些对数据库设计颇有造诣的专业人士给大家传授一些设
计数据库的技巧和经验。我们的编辑从收到的130 个反馈中精选了其中的60 个最佳技巧，并把这些
技巧编写成了本文，为了方便索引其内容划
If the enterprise data likened necessary for life s blood, then the database design is the most important part of the application. The data
Voluminous materials database design, university degree programs where there are special about. However, as we have repeatedly emphasized, even the best
Teacher ratio, but also experience the teachings. So we recently found some quite accomplished on database design professionals give you impart some set
Meter database skills and experience. Our editors from the feedback received from 130 of them selected 60 best tips, and these
This technique would be prepared, in order to facilitate its contents index Scheme (2013-09-16, Others, 55KB, 下载2次)
[数据库编程] K3BOSLinLiaoDanTwoDev
单据二次开发是针对现目前单据的一些功能无法满足一些客户的特殊要求，同时分公司又有能力进行二次开发而提出的，这样既可以在现有的系统不做变动的情况下面满足用户的需求，同时也增强了系统的稳定性。
本篇所介绍所用到的动态连接库名为：K3BillTransfer.dll
通过该说明文档，你可以了解到
1.如何通过K3BillTransfer组件在录单过程中对单据上各项目加以控制。
2.如何通过K3BillTransfer组件实现自定义功能菜单。
3.如何通过K3BillTransfer组件控制数据的保存。
4.如何在序时薄上增加菜单及应用。
5.应用示例—实战演练。
适用对象
需要在K/3供应链系统单据上进行二次开发的开发者
开发环境
1.安装过K/3ERP 9.41以后的版本且购买过供应链系统。
2.VB6.0企业版+SP1
3.SQL SERVER 2000及后续版本（SQL SERVER 2005,SQL SERVER 2008)
failed to translate (2013-05-02, Visual Basic, 13KB, 下载12次)
[数据库编程] xsgl
1、系统需求
（1）问题描述：
该系统实现对若大学生的学习成绩进行管理。至少包括以下信息：
学号、姓名、科目、成绩。
（2）功能要求：
1．使用中文菜单，界面设计和用户输入输出要人性化些；
2．具有数据输入功能，输入的数据能最终保存在文件中；
3．具有数据删除功能，能最终从文件中删除；
4．具有多种查询（如按学号查询、按姓名查询、按成绩查询等）及输出功能；
5．其它功能（如各种统计，统计每个学生所有课程的平均分等等）
6．学生信息的修改（比如修改学生姓名，修改学生某门课程的成绩）
（3）、输入输出的形式
本系统是一个学生成绩管理系统，采用VF6.0 编译器作为开 发环境，用户在输入学生数据时要保证输入数据格式的正确性，系统不会自动检测输入的数据是否正确，输出形式与输入形式类似，根据需要可以选择显示输入的各项内容，还可以选择显示计算好平均分后并排序后的记录，显示内容包括：学期、学号、姓名、高等数学成绩等等。
包含源代码、报告~
1.主程序代码
DO SETUP
DO FORM jrxt
READ EVENTS
2.setup程序代码
CLOSE ALL
SET SYSMENU OFF
SET TALK OFF
SET SAFETY OFF
3.cleanup程序代码
SET sysmenu TO defa
SET TALK ON
SET SAFETY ON
CLOSE ALL
CLEAR WINDOWS
CLEAR EVENT
4.各班人数代码
SELECT Bjml.班级名称, COUNT(Xsda.学号)as班级人数
FROM xsgl!bjml FULL JOIN xsgl!xsda
ON Bjml.班级编号 = Xsda.班级
GROUP BY Bjml.班级名称
5.平均入学成绩代码
SELECT Bjml.班级名称, AVG(Xsda.入学成绩)AS平均入学成绩
FROM xsgl!bjml
GROUP BY Bjml.班级名称
ORDER BY 2
6.菜单程序代码
SET SYSMENU TO
SET SYSMENU AUTOMATIC
DEFINE PAD _1z80npzgr OF _MSYSMENU PROMPT "系统管理(\<S)" COLOR SCHEME 3
(2012-06-25, Visual Basic, 492KB, 下载8次)
[数据库编程] DryHouse
为一家冶金企业量身定做的去湿房仓库管理系统，其中强调的是先进先出原则，由于生产流程的各个工序不能及时更上，必须选择一个临时的存放地点，而且金属制品的生锈会大大增加次品率，影响效率，增加成本。为了尽可能的减少损失，对于存放金属制品的仓库必须具有去湿功能。仓库增加去湿功能必然增加仓库的使用成本，必须减少金属制品在仓库中的积留时间，以至于更有利于整个产品流转过程的统一管理和有机整合。
Dewetting room for a metallurgical enterprises tailored warehouse management system, which emphasized the FIFO principle, the various processes of the production process can not be more on the timely, you must select a temporary storage location, and the rusting of metal productswould greatly increase the defect rate, affecting the efficiency, increase costs. To minimize losses, the warehouse for storage of metal products with dehumidification function. Warehouse to increase dehumidification function is bound to increase the use of warehouse costs, we must reduce the metal products accumulates in the warehouse that is more conducive to unified management and organic integration of the entire product flow process. (2012-04-23, Java, 10381KB, 下载11次)
[数据库编程] WuLiu
附加数据库SQL Server 2000
（1）将TM\09\App_Data文件夹中的扩展名为db_WL_Data.MDF和db_WL_Log.LDF的两个文件拷贝到SQL Server安装路径下的Data文件夹中。
（2）打开SQL Server 2000中的“企业管理器”，然后展开本地服务器，在“数据库”数据项上单击鼠标右键，在弹出的快捷菜单中选择“所有任务”/“附加数据库”菜单项。
（3）将弹出“附加数据库”对话框，在该对话框中单击【 】按钮，选择所要附加数据库的db_WL_Data.MDF文件，单击【确定】按钮，即可完成数据库的附加操作
Additional database SQL Server 2000 (1) to TM \ 09 \ App_Data folder and db_WL_Log.LDF extension db_WL_Data.MDF two files copied to the SQL Server installation path under the Data folder. (2) Open the SQL Server 2000 in the " Enterprise Manager" and then expand the local server, in the " database" data item, click the right mouse button, the shortcut menu, select " All Tasks" /" Add Database" menu item . (3) will pop up " additional database" dialog box, in the dialog box, click 【】 button to select the file you want to attach the database db_WL_Data.MDF, click 【OK】 button to complete the database of additional operations (2011-05-15, C#, 1074KB, 下载7次)
[数据库编程] CMS
具有完善的基础信息维护和客户信息维护功能，并增置了客户服务模块，满足了客户日常管理的需求；强大的数据查询及图表分析功能，帮助企业能够及时根据分析结果进行新规划和方案，以适应变化万千的消费市场。客户管理系统后台数据库采用SQL Server 2000数据库，以保证数据的安全、高效和稳定。前台采用Microsoft公司的Visual C++ 6.0作为主要的开发工具，其可与SQL Server 2000数据库无缝链接
Basic information with a complete maintenance and customer information, maintenance, and additional provision of customer service modules to meet the daily management of customer demand powerful data query and chart analysis functions to help enterprises timely manner the results of the analysis of new plans and programs, to adapt to the changing consumer market. Customer management system back-end database using SQL Server 2000 database to ensure data security, efficiency and stability. Front using Microsoft' s Visual C++ 6.0 as the main development tool, which can be seamlessly with SQL Server 2000 database link (2010-03-24, Visual C++, 1894KB, 下载14次)
[数据库编程] DBdesign60kills
如果把企业的数据比做生命所必需的血液，那么数据库的设计就是应用中最重要的一部分。有关数据
库设计的材料汗牛充栋，大学学位课程里也有专门的讲述。不过，就如我们反复强调的那样，再好的
老师也比不过经验的教诲。所以我们最近找了些对数据库设计颇有造诣的专业人士给大家传授一些设
计数据库的技巧和经验。我们的编辑从收到的130个反馈中精选了其中的60个最佳技巧，并把这些
技巧编写成了本文，为了方便索引其内容划分为5个部分
If the enterprise' s data comparing the blood necessary for life, then the database design is the application of the most important part of it. Voluminous material related to database design, university degree courses where there are special about. However, as we have repeatedly emphasized, even the best teachers, but the experience than the teachings. Therefore, we have recently looked for some pairs of database design is quite accomplished professionals who give you some design a database to teach skills and experience. Our editors from the feedback received, 130 of them selected the 60 best skills, and put these skills into the preparation of this article, in order to facilitate the indexing of its content is divided into five parts (2010-02-05, Unix_Linux, 55KB, 下载4次)
[数据库编程] Librarymanagementsystem
图书管理系统，目前，图书市场日益激烈的竞争迫使图书企业希望采用一种新的管理方式来加快图书流通信息的反馈速度，而计算机信息技术的发展为图书管理注入了新的生机。
本图书管理系统实现了以下功能：
实现图书的入库与入库退货管理。
实现图书的库存盘点管理。
实现图书的定价、调价管理。
实现图书的销售、销售退货管理。
实现图书的入库查询、入库退货查询、图书销售查询等信息查询。
Library management system, At present, the book market with increasing competition forcing companies want to book a new management methods to speed up the flow of information books feedback speed, and computer information technology for library management has injected new vitality. The library management system to achieve the following features: to achieve storage and warehousing books Return Management. achieve inventory management books. books to achieve pricing, price management. achieve book sales, sales returns management. to achieve the storage of books information, warehousing return information, book sales information and other inquiries. (2009-07-16, Visual C++, 1637KB, 下载7次)
[数据库编程] PurchaseSalesandInventoryManagementSystemforSuperm
超市进销存管理系统将包含以下内容：
1． 能对企业内的各类货物进行ABC分类管理，并提供最低超市量、最高超市量、安全超市量的预警功能。
2． 可以存储各类信息档案包括物资、产品基本信息、供货单位信息、使用单位信息等。
3． 可以方便快捷的进行物资入库管理\物资出库管理等等，安全、高效；支持各种类型的出/入库业务：生产入库、委外加工入库、采购入库、其他入库、生产领料出库、委外领料出库、销售出库和其他出库等
4． 提供退货管理功能
5． 通过查询超市，
Purchase, Sales and Inventory Management System supermarket will include the following: 1. Enterprises can carry out all types of cargo within the ABC classification management, and provide a minimum volume of supermarkets, the highest volume stores, security, early warning function of the volume of the supermarket. 2. Can store files of all types of information, including materials, products, basic information, delivery information units, the use of units of information. 3. Can be convenient and efficient management of materials storage \ supplies a database management, security, and efficient to support various types of out/warehousing business: the production of storage, processing outsourcing warehousing, procurement warehousing and other storage, the production of materials from the library, the library is expected from outsourcing, sales of the library and other libraries, such as 4. 5 provides returns management capabilities. Through inquiries supermarkets, (2009-06-17, Visual Basic, 542KB, 下载15次)
[数据库编程] system
企业仓库管理系统使用SQL2000做为后台数据库数据库文件在压缩文件中在database文件夹下。使用VC++编写，使用ADO方法访问数据库，程序中将数据库操作封装成一个很健全的类，用户可以直接将ADO类应用在其他的系统中．系统的功能如下：
系统由基本信息管理模块、入库管理模块、库存管理模块、查询管理模块等几部分组成。
１、基本信息管理模块主要包括操作员管理、商品信息管理、库存信息管理、供应商信息管理4部分。
2、入库管理模块主要包括商品入库、入库退货两部分。
3、库存管理模块主要由库存商品打印、库存盘点、库存调拨、库存出货、库存上下限管理5部分组成。
4、查询管理管理模块主要由商品入库查询、入库退货查询、报损/报益查询3部分组成。
This is a Corporation Warehouse Management System,it Program with VC++,it Contains SQL2000 DataBase,the Program accessing the SQL2000 DataBase with ADO Method. (2009-02-13, Visual C++, 1567KB, 下载22次)
[数据库编程] NetBarSDK
1. 发卡服务端：Server 项目文件：autojet.prj 2. 计费客户端：Client 项目文件：internet.prj Explorer.prj 先启动Explorer.exe, 再启动internet.exe 3. 数据库脚本 INIT（原版）.SQL 和 New init.sql（新版），数据库名 NetBar 4. 动态连接库： NETBAR.dll hookdll.dll 5. 大学生公寓城System ID为5046 其余程序说明全在程序内的文本文件中说明-1. round card service end: Server project document: Autojet.prj 2. costs the customer end: Client project document: Internet.prj Explorer.prj First starts Explorer.exe, then starts internet.exe 3. databases scripts INIT (first edition) SQL and New init.sql (new edition), database NetBar 4. dynamic connections storehouses: NETBAR.dll hookdll.dll 5. university students lodgings city System ID is 5,046 other procedures explained all explained in the procedure text documents
1. Issuing server: Server project documents: autojet.prj 2. Recosting Client: Client project files: internet.prj Explorer.prj first start Explorer.exe, and then start internet.exe 3. Database script INIT (the original). SQL and New init.sql (new version), database name NetBar 4. Dynamic Link Library: NETBAR.dll hookdll.dll 5. college apartments City System ID for the 5046 remaining description of the procedures in the whole procedure described in the text file-1. round card service end: Server project document: Autojet.prj 2. costs the customer end: Client project document: Internet.prj Explorer.prj First starts Explorer.exe, then starts internet.exe 3. databases scripts INIT (first edition) SQL and New init.sql (new edition), database NetBar 4. dynamic connections storehouses: NETBAR.dll hookdll.dll 5. university students lodgings city System ID is 5046 other procedures explained all explained in the procedure text documents (2008-11-17, Visual C++, 2692KB, 下载8次)
[数据库编程] SQL_design_guide
数据库设计指南.pdf
如果把企业的数据比做生命所必需的血液，那么数据库的设计就是应用中最重要的一部分。有关数据
库设计的材料汗牛充栋，大学学位课程里也有专门的讲述。不过，就如我们反复强调的那样，再好的
老师也比不过经验的教诲。所以我们最近找了些对数据库设计颇有造诣的专业人士给大家传授一些设
计数据库的技巧和经验。我们的编辑从收到的130 个反馈中精选了其中的60 个最佳技巧，并把这些
技巧编写成了本文，为了方便索引其内容划分为5 个部分：
Database Design Guide. Pdf if the enterprise data likened vital blood, then the database design is the application of the most important part. Related to database design voluminous materials, university degree courses also have a special on. However, as we have repeatedly emphasized, even the best teachers but also the teachings of experience. Therefore, we have recently found some of the database design is quite accomplished professionals to impart to you some of the design of database skills and experience. Our editorial from the feedback received 130 of them selected the 60 best skills, and to the preparation of these techniques has become of this article, in order to facilitate the indexing of its content is divided into five parts: (2007-12-20, SQL, 55KB, 下载10次)
[数据库编程] skyBusiness
课程设计（电子商务系统）
对于典型的数据库管理系统，尤其是对像电子商务这样的数据流量特别大的网络管理系统，必须要满足使用方便、操作灵活等设计需求。本系统在设计时应该满足以下几个目标：
采用人机对话的操作方式，界面设计美观友好、信息查询灵活、方便、快捷、准确、数据存储安全可靠。
全面展示商城内所有商品，并可展示最新商品及特价商品。
实现网上购物。
商品销售排行，以方便顾客了解本商城内的热销商品及帮助企业领导者做出相应的决策。
查看商城内的公告信息。
对用户输入的数据，系统进行严格的数据检验，尽可能排除人为的错误。
系统最大限度地实现了易维护性和易操作性。
系统运行稳定、安全可靠。
Course Design (e-commerce system) for typical database management system especially for e-commerce such as the flow of data is particularly large network management system must meet the user-friendly, operational flexibility design needs. In the design of the system should meet the following objectives : (2007-06-27, C#, 527KB, 下载40次)
[数据库编程] Visual_Basic_6.0_Database
《VISUAL BASIC 6数据库编程大全》配套源码
《VISUAL BASIC 6数据库编程大全》简洁而专业地指导Visual Basic 程序员如何利用微软的Visual Basic 企业版进行设计和创建数据库应用程序。内容覆盖了VB6程序员所要了解的八个方面，并为数据库程序员提供了经常会遇到的各种问题的必要解决方案。同时讲述了如何将这些技术结合在一起，创建正在莛发展的客户机/服务器，以及基于Web的应用程序。附带的光盘含盖了书中例举的程序代码，极大地方便读者学习和使用VB6进行程序开发和数据库编程。
"VISUAL BASIC 6 Database Programming Solutions" complementary source "VISUAL BASI C 6 Database Programming Solutions, "a concise and professional guidance Visual Basic programmer how to use Microsoft's V isual Basic Enterprise Edition for the design and creation of database applications. Cover the contents of VB6 programmers need to know about eight, and to provide a database programmers often encounter the problems need solutions. Also explains how to combine these technologies together, to create stalk of grass is the development of client/server, and the Web-based applications. Accompanying CD covered the book's code examples, great convenience for readers to learn and use VB6 procedures for the development and database programming. (2007-01-27, Visual Basic, 20KB, 下载33次)