| 编程中国 | 业界新闻 | 技术文章 | 视频教程 | 下载频道 | 程序源码 | 个人空间 | 编程论坛
全能ASP/PHP/ASP.NET主机,支持月付专业 MSSQL 数据库空间,支持月付专业 MySQL 数据库空间,支持月付学习型 ASP/PHP/ASP.NET 主机 30元/年
高端软件开发 = 年薪十万不是梦赛孚耐:软件保护加密专家身份认证令牌USB KEY 
共有 382 人关注过本帖
标题:求助(基于VB.
收藏  订阅  推荐  打印 
tammy
Rank: 1
等级:新手上路
帖子:10
积分:200
注册:2007-10-8
求助(基于VB.

朋友们帮帮忙,我在大马留学,我刚接触VB。NET不久,老师就给一个这个assignment,这让我不知道该怎么下手,高手们帮下拉,会的就帮下忙, 关于超市的系统

CASE STUDY

You are asked to develop a Visual Basic.Net program for a Supermarket. It should allow the cashier to receive the products from customers and generate a sales receipt. Each item has its own product code. Your program should allow the cashier to select the product code from the system and display the price. Once all items have been selected, your program should generate a customer’s sales receipt. Your program should have the following product category in the database such as:

v Dairy Productsv Vegetablesv Soft Drinksv Household Productsv Fruitsv Biscuitsv Toiletriesv Baby Products

Each product category has a unique product code as listed below:

Product-Category

Product Code

Dairy Products

1

Vegetables

2

Soft Drinks

3

Household Products

4

Fruits

5

Biscuits

6

Toiletteries

7

Baby Products

8

Your program should have the following modules:

1. Login Module

The login module is used by the systems administrator and cashier to access the system. This module should allow the systems administrator to add new staff, update and delete records.

Table Name :

Login

Field Name

Data Type

Username – Primary Key

Text

Password

Text -Min 8 characters

Name

Text

DOB

Date

Email

Text

2. Product Module

This module should allow the systems administrator to add, update and delete products from the database. You should have a search function to search for a product category. You should also be able to add more product categories into the database.

Table Name :

Product

Field Name

Data Type

PCode – Primary Key

Integer

ProductCategory

Text

Table Name :

ProductType

Field Name

Data Type

No – Primary Key

Autonumber

PCode - Foreign Key

Integer

Typecode

Integer

Description

Text

Cost

Currency

3. Payment Module

The payment module allows the cashier to key in the product code and display the total cost to be paid by the customer. A receipt is generated once all items have been keyed into the system. Furthermore, a discount of 15% is given to customers who purchase an amount of RM100 and above.

Table Name :

Payment

Field Name

Data Type

Counter

Autonumber

TransactionNo

Integer

TypeCode – Primary Key

Text

Description

Text

Cost

Currency

Date

Date / Time

4. Report Module

This module is used to print the following hardcopy:

a) Receipt which is given to the customer once they have made their payment. (See Appendix A).

b) Cash Collection Report for a given date range e.g monthly or weekly cash flow (see Appendix B).

Appendix A

a) Sample Receipt

TPM Supermarket

Receipt

Transaction No : 1

Date : 3/5/2007

PCode TypeCode Description Cost

7 111 Shampoo 10.00

7 112 Soap 5.00

3 113 Coke 2.20

Total 17.20

Discount (%) 0

Nett Total 17.20

Thank You

Please Come Again

Appendix B

b) Sample Cash Collection Report

TPM Supermarket

Month: September

Cash Flow for the month of September: RM 2000

搜索更多相关主题的帖子: STRONG  留学  Roman  
2007-10-8 22:07
mrseventeen
Rank: 1
等级:新手上路
帖子:13
积分:230
注册:2007-10-9


天啊~~英文没过6级看不懂,过了6级还不大懂~!
2007-10-9 17:14
xiaoyutou
Rank: 1
等级:新手上路
帖子:23
积分:340
注册:2007-3-29

看不懂!

凡事由其自然,遇了处之泰然,得意之时淡然,失意之时坦然,艰辛曲折必然,历尽沧桑悟然。
2007-10-9 17:16
luanjinling
Rank: 1
等级:新手上路
帖子:16
积分:260
注册:2007-10-9

这是关于超市及数据库系统的,表中有些内容是应当在数据库中表现的,如NAME等
2007-10-9 17:38
fangjian77
Rank: 1
等级:新手上路
帖子:8
积分:180
注册:2007-7-6
回复:(tammy)求助(基于VB.

真是厉害脚色啊.
2007-10-9 20:27
tammy
Rank: 1
等级:新手上路
帖子:10
积分:200
注册:2007-10-8
回复:(mrseventeen)[em03][em03][em03]天啊~~英文没...

朋友们,帮下忙拉, 这个就是 超市的管理系统, 你们有做过的,就让我借鉴一下拉, 帮帮拉, 这个做业也就是用VB.net和ACCESS 联合的, 大家懂的话,就帮下忙, 回国请你们吃大餐, 哈哈哈谢谢拉

2007-10-11 15:31
tammy
Rank: 1
等级:新手上路
帖子:10
积分:200
注册:2007-10-8

4楼,,恩, 表格里的就是数据库的内容, 你懂的话就帮帮拉
2007-10-11 15:37
purana
Rank: 12Rank: 12Rank: 12
来自:广东-广州
等级:版主
威望:66
帖子:6040
积分:61390
注册:2005-6-17

这都是基础呗..
找到教程都有讲到的.

我的msn: myfend@hotmail.com
2007-10-11 15:39
tammy
Rank: 1
等级:新手上路
帖子:10
积分:200
注册:2007-10-8

我是想找个相似的内容,然后我就知道到底应该从哪里入手!!!!!!!!我就接触一个月啊,这么难的作业就出来拉, 伤心!!!!

2007-10-11 19:59
purana
Rank: 12Rank: 12Rank: 12
来自:广东-广州
等级:版主
威望:66
帖子:6040
积分:61390
注册:2005-6-17

那你就直接跟你的导师说吧.


我的msn: myfend@hotmail.com
2007-10-11 20:05
关于我们 | 广告合作 | 编程中国 | 清除Cookies | Archiver | WAP | TOP

编程中国 版权所有,并保留所有权利。鲁ICP备08000592号
Powered by Discuz, Processed in 0.121779 second(s), 9 queries.
Copyright©2004-2008, BCCN.NET, All Rights Reserved