摘要
本课题是以一个百货连锁总部的商品信息管理为基础，结合集团商品部工作的实际需求，详细阐述了《商品信息管理系统》软件设计、开发的全过程，并对技术难点作出分析，提出解决方法。使“商品信息管理系统”最终具有数据维护、数据检索和报表处理的功能。
本系统后台以Adaptive Server Anywhere 6.0（ASA6.0）作为数据库系统的客户端软件，前台采用基于C/S的应用系统开发工具Power Builder7.0，从而快捷方便的实现了系统的开发。
本系统主要功能模块有：
数据维护：实现新建、修改、删除、存储功能
数据检索：实现按不同要求分类模糊查询，组合查询功能
报表处理：根据查询方式不同，选择输出检索信息
本系统将信息检索作为研究重点，力求通过关键字段实现模糊检索功能，使信息查询更加简单灵活，即使第一次接触系统的人也可轻松操作，快速的找到所需信息。同时，在操作界面的设计上，按照数据间的关系在同一界面中系统根据不同操作激活相应操作对象，使直观视觉上更加符合传统习惯。此外本系统以下拉数据窗口（DropDownDW）方式为数据编辑风格，从而保证了数据录入的规范性，比传统的下拉列表框方式更加灵活简便。
关键字：商品档案、信息管理系统、数据检索、操作界面
Abstract
This project is based on the Products Information Management System of a chain stores head office, and focusing on the software development for products basic information management,with a view of the practical requirements of the business in Merchandising Department. This study will explain in detail the whole process of the software design and development of the <<Products Information Management System>>, the technical difficulties will be analyzed, and the solution will be raised here. Finally, integrate the following functions into this system: Datum Maintenance, searches and report forms processing.
Client/Server(C/S) mode has been used in the system.The client software of the host database system is "Adaptive Server Anywhere 6.0(ASA6.0)", and using the "Power Builder 7.0" application developement tools in the front end, which facilities the development of the whole system.
The main function modules are made up of the following:
.Datum Maintenance: with "New","Modify","Delete","Save" functions
.Datum Searches: with "Fuzzy search","Combined search" functions
.Report forms Processing: filter the search result according to search mode.
This system emphasizes on the information searching, trys to realize the fuzzy search function by the KEY fields, which will simplify the searching work, user friendly and allowed easy acessment.As to the user interfaces, the system can activate the appropriate object according to different operations, considering the relationship among datums, which makes it looks more accordant with the traditional style. Besides, the DATA EDIT STYLE of the system is "DropDownDataWindow", which ensure the normative of data recording, and it is more flexible compare to the traditional style.
KEY WORDS:
Products Basic Information,Datum Searches ,Information Management System, UI(User Interface).
