VB+SQL 销售合同管理系统论文

浙江海洋学院毕业论文

目录

[摘要] ······························································································································ 2

一、概述 ··································································································································· 2 1．绪论 ····································································································································· 2 2．Visual Basic 开发工具 ······································································································ 2 3．SQL Server 2000 简介 ······································································································ 2

二、系统需求分析 ·········································································································· 3 三、系统总体设计 ·········································································································· 3

2、体系结构功能模块图： ····································································································· 3 1、用户管理功能模块关系图： ····························································································· 4 3、简单使用说明 ····················································································································· 4 ４、数据表设计 ······················································································································· 4 5、使用到的模块 ····················································································································· 6

三、详细设计 ·················································································································· 6

1、登录窗体 ····························································································································· 6 2、系统主界面 ························································································································· 8 3、产品管理模块设计 ············································································································· 8

3．1产品信息编辑窗体 ····················································································································· 8

3．2产品信息管理窗体，名称为Frmproductman。窗体布局如下： ····················· 9

4、合同管理模块设计 ··········································································································· 11 4．1合同信息编辑窗体 ··················································································································· 11 4．2合同信息管理窗体 ··················································································································· 13 4．３合同产品信息编辑窗体 ·········································································································· 15 5、合同费用管理模块设计 ··································································································· 16 5．1合同费用信息编辑窗体 ··········································································································· 16 ５．２合同费用信息管理窗体 ········································································································ 18 6．１合同收帐信息编辑窗体 ·········································································································· 19 6．２合同收帐信息管理窗体 ·········································································································· 21 7、合同统计管理模块 ··········································································································· 22 7．1创建视图 ··································································································································· 22 7.２合同成本利润统计月报 ············································································································· 22 ７．３合同成本利润统计年报表， ································································································ 23 8、用户信息管理模块设计 ··································································································· 24 8．１用户信息编辑窗体 ·················································································································· 24 8．２用户管理窗体 ·························································································································· 25

小结： ···························································································································· 27 参考文献： ···················································································································· 27

1