某店积分更新记录管理

包括文档,设计,文档字数:9145,页数:37

摘  要
计算机诞生以来，对数据的管理一直是计算机应用中最为重要的环节，数据库管理系统便是这一环节中坚力量。在.NET平台推出以后，由于其通用语言基础结构和规范性，让不同语言开发的程序员们都能得心应手地在.NET平台下进行高效的程序开发，ADO.NET框架对数据库管理系统的访问控制是相当的灵活和方便，减少了程序员们操作数据库底层代码，让程序员的精力完全集中到逻辑代码开发之中。因此，采用.NET平台开发管理信息系统是一个明智的选择。
某店积分更新记录管理前台采用.NET,后台采用SQL 2000，语言使用C#。实现的系统功能是对用户消费和追加的积分进行更新，并对积分变化进行记录。程序模块读取临时积分表，通过返回临时积分表的数据对积分表，用户状态表，积分奖励记录表进行更新，并对积分累积记录表进行更新，系统着重于对更新失败和程序异常时进行处理。
关键词：计算机应用；数据库管理系统；积分更新记录；.NET平台；ADO.NET；C#；SQL2000
The Shop’s Integral Update Record Management
Abstract
Data management is always the most important link of the computer’s application, since the invention of the computer, and the database management system is a very important in this link. After the .NET was launched, for its common language structure and standard, programmers of all languages carry on the procedure high effectively under the .NET platform. The structure of ADO.NET give a flexible and suitable manage to the access control of database management system, this reduce the chance of operating lower layer code, and make programmer pay more attention to logical code development. Therefore it is wise to choice the .NET platform to development management information.
.NET is used as onstage，SQL 2000 is used as backstage and C# is used as developing language in the Integral to update records management. The function of system is to update the integral of consuming and producing, and carries on the record of the integral changing information. When the program module read the temporary integral table, it updated the integral table, the user condition table, the integral reward data sheet through returns the data of temporary integral table. This system pay more attention to dealing with update failure and procedure exceptionally when carried on processing.

Key words: Computer Applications; Database management system; Integral Update Record; .NET platform; ADO.NET; C#; SQL2000

目  录

1引 言 5
2模块需求分析 5
2.1模块功能需求 5
2.2客户对模块性能要求 5
2.3模块开发需求 5
3系统开发设计分析 6
3.1系统设计模式 6
3.2模块功能分析 6
3.2.1积分表的更新 6
3.2.2新入会员积分表的更新 6
3.2.3老用户卡片遗失情况下的更新 6
3.2.4当日积分变化进行记录 7
3.3程序流程及分析 7
3.4 模块的详细设计 7
3.4.1 模块主要对象的定义 8
3.4.2数据库结构设计 10
4模块的实现过程分析 13
4.1积分更新类具体实现 13
4.2积分累计记录类具体实现 17
5系统运行结果 19
5.1积分更新类测试结果 19
5.2积分累计记录更新类测试结果 23
结    论 25
参考文献 26
附    录 27
致    谢 36
声    明 37

相关论文