发布时间:2012/9/18 16:52:50 作者:王洪迪1,冯健生2,董玉德1,杨兵1,邢美1 【字体:
大 中 小】
王洪迪1,冯健生2,董玉德1,杨兵1,邢美1
(1.合肥工业大学机械与汽车工程学院,安徽合肥 230009;2.佛山万喜电器燃气具有限公司,广东佛山 528306)
摘要:分析了目前我国中小型制造企业的进销存的特点,针对某燃气具企业设计了基于ASP.NET的进销存系统。采用B/S模式进行三层分布式体系结构设计,充分利用了其业务扩展和维护简单方便、开发简单、共享性强的特点;开发语言使用当前流行的C#;数据库使用与.NET紧密结合的SQL Server数据库;用E-R图设计了系统的数据模型,进一步为系统设计相关数据库表;在系统实现过程中使用了水晶报表、Ajax等关键技术,并且以各种单据的形式对企业的各个业务进行支持,实现了采购管理、库存管理、销售管理等功能,使企业在进销存方面的管理更加规范,提高了运营效率。实践证明该系统结构灵活,布局统一,可以根据实际需要加以修改移植到其它企业使用。
关键词:进销存;ASP.NET;C#;数据库
中图分类号:F253.4 文献标识码:A 文章编号:1006-0316 (2012) 09-0042-04
The design of stocking selling and storing system in gas appliance enterprises based on .NET
WANG Hong-di1,FENG Jian-sheng2,DONG Yu-de1,YANG Bing1,XING Mei1
( 1.School of Machinery and Automobile Engineering,Hefei University of Technology,Hefei230009,China;2.Foshan the Wanxi Electric and Gas Stove Co.,Ltd.,Foshan528306,China )
Abstract:Analysising of the characteristics of the present, China's small and medium-sized manufacturing enterprises Invoicing ,designed for gas appliances enterprises based on the ASP.NET stocking selling and storing system, using the B / S mode for three-tier distributed architecture design, full use the feature of its easy business expansion and maintaining, developing simply, the strength of share characteristics.The System use the popular C# for development language and the SQL Server database closely with. NET for database. Designing the data model of the system with E-R diagram,then further designing system'database table. Using Crystal Reports, Ajax and other key technologies in the process of system implementation,and to form a variety of documents to support various business enterprises, the system achieve the purchasing management, inventory management, sales management and other functions, so standardizing the management of stocking selling and storing in enterprises, improving the operational efficiency. Practice has proved that the structural flexibility of the system, the layout of unity,it can be modified according to actual needs to port to other businesses to use.
Keywords:stocking selling and storing system;asp.net;C#;database
———————————————
收稿日期:2012-03-03
作者简介:王洪迪(1984-),男,安徽宿州人,硕士研究生,主要研究方向为企业数字化管理与管理可视化。