求助(基于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