数据库管理系统设计.doc

" " " " " " " "后台主界面及功能说明： " " " " " " " " " " " " " " " " " " " " " " " " "图1 " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " " "2.1、基本设置： 在基本设置中可以对商品信息、商品调价、供货商、客户、员工、操作员、会员、 " " " " "仓库进行设置 " " " " " " " " " " " " " " "2.1.1、商品信息 " " " " " " " " " " " " " " " " " " " "在基本设置模块中点击"商品信息"进入商品信息界面如图2 " " " " " " " " " "图 2 " " " " "在商品信息窗口中左边是商品类别，右边列表中是该类别对应的商品。在某一类别上点击鼠标右键， " " " " "可以新增类别，重命名和删除类别。新增的类别是属于所选类别的下一级，如果类别下有商品存在则 " " " " "该类别是不能被删除的。在类别名称后的文本框中可以输入类别名称或类别简码来查询需要的类别。 " " " " "在商品列表中点击"增加"按钮打开增加商品界面如图3 " " " " "图 3 " " " " "在商品信息这一部分输入新增商品的所有信息，点击"保存"按钮即可把该商品保存到右边的已存商品 " " " " "中，保存后可以继续输入下一种商品。在"已存商品"中可以点击鼠标右键对选中的商品进行删除或删 " " " " "除全部已存的商品。如果商品增加完后可以直接点"退出"按钮。退出增加商品窗口后会在商品列表中 " " " " "看刚才增加的商品。如果要修改商品，先选中要修改的商品，点击"修改"按钮打开商品修改界面，在 " " " " "商品修改界面中修改相应的信息点击"保存"即可。点击"删除"按钮即可以把选中的商品删除，该商品 " " " " "发生过业务则是不能删除的。 " " " " "如何建立期初库存商品，在系统中如果没有进行业务来往，当点击"商品信息"按钮的时候，系统会提 " " " " "示是打开商品信息还是建立期初库存商品粮。打开库存商品期初建帐窗口如图4。 " " " " " " " " " "图4 " " " " "在窗口中的商品信息中可以看到所有已经增加过的商品信息，在右边的库库商品中选择仓库，可以看 " " " " "到该仓库中的商品。在商品信息中可以选择中一种商品点击"增加到仓库"在出现的窗口中输入期初数 " " " " "据和成本价，这样就可以建立该商品在指定仓库的初期帐。 " " " " " " " " " " " " " " "2.1.2、供货商设置 " " " " " " " " " " " " " " " " " " " " " " " " "图 5 " " " " "在基本设置模块中点击"供货商信息"按钮打开供货商信息窗口如图5。在窗口中可以看到所有的供货商" " " " "。点击"增加"按钮打开增加供货商窗口，输入供货商的信息，供货商名称不能重复。如果该供货商有 " " " " "期初金额就在"期初应收"后输入相应的金额。如果选择中"默认供货商"在采购进货和采购退货打开窗 " " " " "口的时候显示的为该供货商，默认供货商只能有一个。点击"修改"按钮可以修改选中的供货商信息。 " " " " "如果该供货有业务发生，则不能再修改期初实付金额。点击"删除"按钮可以删除选中的供货商，如果 " " " " "该供货商有业务发生则不能删除。系统有一个"普通供货商"是不能被删除的。点击"查找"按钮打开供 " " " " "货商查询窗口，输入相应的条件查询不同的供货商信息。点击"全部"按钮可以列出所有的供货商信息 " " " " "。 " " " " " " " " " " " " " " "2.1.3、客户设置 " " " " " " " " " " " " " " " " " " " " " " " " "图 6 " " " " "在基本设置模块中点击"客户信息"按钮打开客户信息窗口如图6。在窗口中可以看到所有的客户。点击" " " " ""增加"按钮打开增加客户窗口，输入客户的信息，客户名称不能重复。如果该客户有期初金额则在"期" " " " "初应收"后输入相应金额。如果选择中"默认客户"在商品销售和顾客退货打开窗口的时候显示的为该客" " " " "户，默认客户只能有一个。点击"修改"按钮可以修改选中的客户信息。如果该客户有业务发生则不能 " " " " "修改期初应收金额。点击"删除"按钮可以删除选中的客户，如果该客户有业务发生则不能删除。系统 " " " " "有一个"普通客户"是不能被