Professional Documents
Culture Documents
Lp:
Hc k:
Nhm:
Tn ti:
LT CD-DH KHMT1-K2
2
4
Xy dng websit bn hng my tnh
BO CO
BI TP LN
ti: Qun l d n xy dng website bn hng my tnh
trang 1
LI CM N
Nhm 4 Lp LT C H KHMT1 K2
trang 2
MC LC
A. CHUN B D N....................................................................................................................5
I. Phc tho d n.............................................................................................................................5
1. Gii thiu d n:.......................................................................................................................5
2. Mc ch v mc tiu...............................................................................................................5
3. Thi gian thc hin:.................................................................................................................5
4. Nhn lc tham gia:...................................................................................................................5
5. Phm vi:....................................................................................................................................6
6. Nhng ngi lin quan.............................................................................................................6
7. Ti nguyn................................................................................................................................6
8. Mc thi gian quan trng.........................................................................................................6
9. Kinh ph....................................................................................................................................6
10. Phn hiu chnh/ iu chnh...................................................................................................6
11. Ch k....................................................................................................................................7
II. Xc nh yu cu ca khch hng................................................................................................7
III. Ngun nhn lc d kin.............................................................................................................8
IV. c tnh chi ph d n................................................................................................................8
V. Mi trng trin khai..................................................................................................................9
B. KHI NG D N.....................................................................................................................9
I. Thnh lp nhm.............................................................................................................................9
II. Ci t mi trng trin khai......................................................................................................9
III. K hoch thi gian lm vic.......................................................................................................9
IV. Ma trn trch nhim..................................................................................................................10
V. c tnh chi tit chi ph d n....................................................................................................10
VI. Chi ph ngn sch.....................................................................................................................11
VIII. Xc nh ri ro ban u.........................................................................................................12
C. THC HIN D N....................................................................................................................13
I. Xc nh yu cu.........................................................................................................................13
1. Phn tch yu cu khch hng................................................................................................13
2. Phn tch yu cu....................................................................................................................17
3. Xc nh cc thc th v cc mi quan h gia chng...........................................................52
4. Xy dng s quan h thc th...........................................................................................58
II. Thit k v ci t modul...........................................................................................................66
III. Cc qui c chung khi ci t (Coding Conventions):............................................................93
1. Quy c khi t tn cc forms v cc iu khin.......................................................................93
3. Qui c khi t tn cc bng trong c s d liu , cc truy vn...............................................95
IV. Phn cng cng vic lp trnh (Code).......................................................................................96
D. KT THC D N......................................................................................................................98
I. Kt qu d n:.............................................................................................................................98
Nhm 4 Lp LT C H KHMT1 K2
trang 3
Nhm 4 Lp LT C H KHMT1 K2
trang 4
trang 5
trang 6
trang 7
Tin
(1000VND)
Ghi ch:
- Chi ph trn khng bao gm cc chi ph:
1. Chi ph mua sm trang thit b phn cng
- my tnh: 2 b (15 triu)
- ng k tn min (Domain Name), thu my ch (Web hosting): 2 triu.
2. Chi ph duy tr website: 2,5 triu / thng).
3. Chi ph bo tr h thng: 60 nghn/my/thng
- chi ph khc bao gm: chi ph i li,
Nhm 4 Lp LT C H KHMT1 K2
trang 8
B. KHI NG D N
I. Thnh lp nhm
- Nhm d n gm 3 thnh vin:
1. Nguyn Hong H
3. Trn Th Thm
Nhm 4 Lp LT C H KHMT1 K2
Mc thi gian
01/07 09/07/2009
Tham gia
Nhm
trang 9
5 ngy
10 ngy
10/07 - 14/07/2009
15/07- 24/07/2009
5 ngy
25/07 - 29/07/2009
2 ngy
30/07 - 31/07/2009
31 ngy = 1 thng
Hnh
Thm, H
(Hnh: 5 ngy)
Nhm
Nhm
Tch hp,
Xc nh Thit Ci t,
yu cu,
kim th kim th
k
phn tch
n v
h thng
P
C
P
P
P
P
C
C
P, A
A
P, A
C, A
Vn
hnh v
bo tr
P
P
P, A
Ghi ch:
- P: Thc hin
- A: Xt duyt
- C: tham gia ng gp
V. c tnh chi tit chi ph d n
n v tnh: 1.000VND
STT
1
2
3
4
5
Tin
cng,
M t cng vic
Tin
lng
Xc nh yu cu 2,250
Thit k
375
Ci t, kim th
2,125
n v
Tch hp, kim
1,250
th h thng
Vn hnh v bo
500
tr
Tng
6,500
Vn
Thit b,
Hun
phng nguyn
luyn
phm vt liu
Khc Tng
400
200
200
100
0
0
400
100
3,250
775
100
300
50
2,575
100
200
100
1,650
50
150
50
750
850
950
700
9,000
Ghi ch:
Nhm 4 Lp LT C H KHMT1 K2
trang 10
STT
1
2
3
4
5
Tin
cng,
M t cng vic
Tin
lng
Xc nh yu cu 2,250
Thit k
375
Ci t, kim th
2,125
n v
Tch hp, kim
1,250
th h thng
Vn hnh v bo
500
tr
Tng
6,500
Vn
Thit b,
Hun
phng nguyn
luyn
phm vt liu
Khc Tng
400
200
200
100
0
0
400
100
3,250
775
100
300
50
2,575
100
200
100
1,650
50
150
50
750
850
950
700
9,000
Nhm 4 Lp LT C H KHMT1 K2
trang 11
VIII. Xc nh ri ro ban u
Nhm 4 Lp LT C H KHMT1 K2
trang 12
Cao
40%
(KCN)
Cao
50%
(Cao)
TB
10%
(TB)
Cao
10%
(TB)
TB
50%
(KCN)
Thp
100%
(TB)
Cao
50%
(TB)
TB
20%
(TB)
TB
10%
(TB)
C. THC HIN D N
I. Xc nh yu cu
1. Phn tch yu cu khch hng
1.1. Cc chc nng ca h thng
Website thc hin cc chc nng chnh l:
1.1.1. Qun tr h thng:
- Qun l sn phm: Cung cp chc nng qun l cc sn phm hin c, lp
danh sch sn phm cn nhp.
- Qun l bn hng: h thng cung cp chc nng qun l cc giao dch bn ra
ca ca hng, thit lp cc n t hng, xy dng bo gi v cu hnh my dnh cho
khch hng.
- Qun l ho n: Cung cp chc nng x l trng thi ho n gip theo di
cng vic bn hng.
Nhm 4 Lp LT C H KHMT1 K2
trang 13
Nhm 4 Lp LT C H KHMT1 K2
trang 14
trang 15
trang 16
Nhm 4 Lp LT C H KHMT1 K2
trang 17
* Ch thch:
Nhm 4 Lp LT C H KHMT1 K2
trang 18
Post Conditions:
UC001
Login
Manager, Customer.
Chc nng ng nhp cho php ngi dng ng nhp
vo h thng s dng cc chc nng ca h thng.
Chc nng ny s c s dng khi ngi dng truy
cp vo website
Ngi dng c cp mt ti khon ng nhp.
1. H thng s a ra cc chc nng chnh ngi dng la
chn chc nng lm vic.
2. Mt phin lm vic ca ngi dng bt u t lc ng
nhp thnh cng cho n khi ng xut.
1. H thng s a ra trang ng nhp.
2. Ngi dng nhp tn vo ch c nhn l Username v
nhp mt khu vo ch c nhn l Password.
Normal Flow:
Alternative
Flows:
Exceptions:
bo li v yu cu ng nhp li.
Nu ti khon ng nhp hin ang c s dng, khi ng
nhp h thng s a ra thng bo ti khon hin ang s
Nhm 4 Lp LT C H KHMT1 K2
trang 19
UC002
Logout
AdminSystem, Manager, Customer.
Chc nng ng xut cho php ngi dng thot khi phin
giao dch ca mnh.
Chc nng ny s c s dng khi ngi dng nhp chut
vo mc Logout.
Ngi dng phi ang trong phin giao dch ca mnh.
1. H thng s dng phin lm vic ca ti khon hin ti.
2. H thng s chuyn v trang ch.
1. H thng s a ra yu cu xc nhn xem ngi dng c
thc s mun thot khi phin giao dch hin ti hay khng.
Normal Flow:
Nhm 4 Lp LT C H KHMT1 K2
trang 20
UC003.1
Manage Account
AdminSystem
Chc nng qun l ti khon gip cho ngi qun tr website
c th thm, sa, xa ti khon.
Chc nng ny s c s dng khi ngi dng chn vo
mc Manage Account trn trang AdminSystem.
Admin ng nhp thnh cng vo h thng.
H thng s chuyn n trang qun l ti khon ngi
dng la chn chc nng tng ng.
1. Nu ti khon ng nhp c quyn hn AdminSystem,
website s a ra form qun l ti khon vi y cc chc
nng: to ti khon mi, sa thng tin ti khon, i mt khu
ti khon, xa ti khon.
Normal Flow:
Alternative
Flows:
UC4. M t use-case Add Account:
Nhm 4 Lp LT C H KHMT1 K2
trang 21
UC003.2
Create Account
AdminSystem.
Chc nng to ti khon gip cho ngi qun l h thng c
th to mi mt ti khon cho ngi dng.
Chc nng ny s c s dng khi ngi dng chn vo
mc Add New Account trong trang qun l ti khon.
Ngi qun l h thng ang trong phin lm vic ca mnh.
Mt ti khon mi s c thm vo c s d liu.
1. H thng s a ra form to ti khon.
2. Ngi dng s nhp tn ti khon vo ch c nhn
Account name, nhp mt khu vo ch c nhn
Password, nhp mt khu xc nhn vo ch c nhn
Confirm password.
Normal Flow:
Alternative
Flows:
Nhm 4 Lp LT C H KHMT1 K2
trang 22
Exceptions:
hp l v yu cu nhp lai.
Nu ti khon mi trng tn vi mt ti khon c trong c
Special
Requirements:
ti khon cn sa cha.
2. Nu d liu nhp vo khng hp l, khi nhn nt
Save, h thng s a ra thng bo d liu nhp khng hp
l v yu cu nhp li.
Exceptions:
Special
Requirements:
UC003.4
Delete Account
AdminSystem.
Chc nng xa ti khon gip cho ngi dng c th xa
ti khon khi c s d liu.
Chc nng ny s c s dng khi ngi dng chn vo
mc Delete account trong form qun l ti khon.
Ngi qun l h thng ang trong phin lm vic ca
mnh.
Nhm 4 Lp LT C H KHMT1 K2
trang 24
Normal Flow:
Alternative
Flows:
Exceptions:
Special
Requirements:
UC004.1
Nhm 4 Lp LT C H KHMT1 K2
trang 25
Trigger:
Preconditions:
Post
Conditions:
Normal Flow:
UC004.2
Add Product
Manager.
Chc nng thm sn phm gip cho ngi dng c th thm
sn phm mi.
Trigger:
Chc nng ny s c s dng khi ngi dng chn vo
Nhm 4 Lp LT C H KHMT1 K2
trang 26
Preconditions:
Post Conditions:
Normal Flow:
Alternative
Flows:
Exceptions:
Special
Requirements:
Nhm 4 Lp LT C H KHMT1 K2
trang 27
UC004.3
Edit Product
Store Manager.
Chc nng sa thng tin sn phm gip cho ngi dng c
Description:
Trigger:
Preconditions:
Post Conditions:
Normal Flow:
Alternative
thay i.
1. Nu ngi dng khng nh du sn phm cn sa
Flows:
UC004.7
Find Product
Store Manager, Seller.
Chc nng tm kim sn phm gip cho ngi dng c th
tm kim mt sn phm bt k c trong kho.
Chc nng ny s c s dng khi ngi dng chn vo
mc Find product trong menu qun l sn phm.
Ngi qun l kho hoc ngi bn hng ang trong phin
lm vic.
H thng s a ra thng tin ca sn phm cn tm.
1. H thng s a ra form tm kim sn phm.
2. Ngi dng c th la chn tm theo tn sn phm
hoc m sn phm bng cch nhn chut vo hp la chn
tm kim trong form. Mc nh h thng s s dng chc
nng tm kim theo tn sn phm.
3. Sau khi la chn kiu tm kim theo tn hoc m sn
Nhm 4 Lp LT C H KHMT1 K2
trang 29
Exceptions:
Special
Requirements:
vo tm kim.
Nhm 4 Lp LT C H KHMT1 K2
trang 30
UC005
Built Configuration
Customer.
Chc nng xy dng cu hnh my gip cho ngi bn hng
Description:
Trigger:
Preconditions:
Post Conditions:
Normal Flow:
Alternative
Flows:
Exceptions:
Special
Requirements:
Nhm 4 Lp LT C H KHMT1 K2
trang 31
UC006.1
Order
Customer
Chc nng t hng cho php dng c th to v chnh sa
cc n t hng ca mi khch hng.
Chc nng ny s c s dng khi ngi dng chn vo
mc Order.
Khch hng c ti khon v Login thnh cng
H thng s chuyn sang trang t hng.
1. Nu ng nhp thnh cng, h thng s a ra trang
t hng vi y cc chc nng: thm n hng, sa thng
Normal Flow:
Alternative
Flows:
Exceptions:
Special
Requirements:
Nhm 4 Lp LT C H KHMT1 K2
trang 32
UC006.2
Create Order
Customer
Chc nng thm n hng cho php ngi dng c th to
Description:
Trigger:
Preconditions:
Post Conditions:
Normal Flow:
Nhm 4 Lp LT C H KHMT1 K2
trang 33
Exceptions:
Special
Requirements:
l v yu cu nhp li.
Nu n hng tn ti trong c s d liu, h thng s a
ra thng bo n hng tn ti.
D liu nhp phi hp l: tn khch hng khng c php
cha k t c bit, s in thoi khng c cha k ch
hoc k t c bit
UC006.3
Edit Orders information
Customer.
Chc nng sa n hng cho php ngi dng c th sa
cha thng tin ca cc n hng ca mnh.
Chc nng ny s c s dng khi ngi dng nhn vo
nt Edit trong form t hng.
Khch hng c ti khon, ng nhp thnh cng v
c n t hng cha thanh ton.
H thng s lu thng tin mi ca n hng c sa vo
c s d liu.
Normal Flow:
1. H thng s a ra form sa thng tin n t
Nhm 4 Lp LT C H KHMT1 K2
trang 34
Exceptions:
Special
Requirements:
Nhm 4 Lp LT C H KHMT1 K2
trang 35
UC006.4
Delete Order
Customer
Chc nng xa n hng cho php ngi dng c th xa
n hng khi c s d liu.
Chc nng ny s c s dng khi ngi dng nhn vo
mc Delete trong form qun l t hng.
Ngi qun l ha n ang trong phin lm vic.
Mt n hng s b xa khi c s d liu.
1. H thng s a ra form xa n hng.
2. Danh sch cc n hng s c lit k ra ngi
dng la chn xa.
3. Nu khng tm thy n hng cn xa, ngi dng
c th s dng chc nng Find Order trong form qun l t
Normal Flow:
hng.
4. Ngi dng nh du chn n hng cn xa v
nhn nt Delete.
5. Nu chn Yes, h thng s a ra yu cu xc nhn
c chc chn hay khng. Nu chn Yes, h thng s xa
n hng nh du khi c s d liu, nu chn No, n
hng s khng b xa.
Nhm 4 Lp LT C H KHMT1 K2
trang 36
UC006.5
List Order
Actors:
Manager
Chc nng xem danh sch n hng gip cho ngi dng
Description:
Trigger:
Preconditions:
Post Conditions:
Normal Flow:
Nhm 4 Lp LT C H KHMT1 K2
trang 37
Exceptions:
Special
Requirements:
UC17. M t use-case Find Order:
Use Case ID:
Use Case Name:
Actors:
UC006.6
Find Order
Manager
Nhm 4 Lp LT C H KHMT1 K2
trang 38
Alternative
trng n hng.
1. Nu ngi dng khng nhp thng tin vo tm kim v
Flows:
Requirements:
c cha k t c bit.
trang 40
cu chn n hng cn x l.
Flows:
Exceptions:
Special
c lp ri.
Ch cho php chuyn n hng tnh trng c hang
Requirements:
thnh ha n.
UC006.9
Change Orders status
Manager.
Chc nng thay i tnh trng n hng cho php ngi
dng c th thay i tnh trng ca n hng khi cn thit.
Chc nng ny s s dng khi ngi dng nhn vo mc
Change Status trong form qun l t hng.
Ngi qun l ha n hoc ngi qun l kho ang trong
phin lm vic.
Post Conditions: Tnh trng ca mt n hng s c thay i.
Normal Flow:
1. H thng s a ra danh sch cc n hng ngi dng
la chn.
Nhm 4 Lp LT C H KHMT1 K2
trang 41
Alternative
Flows:
Exceptions:
Ch ti khon c quyn hn Store Manager mi c th thay
Special
Requirements:
trang 42
Preconditions:
Manager.
Chc nng qun l ha n nhp gip cho ngi dng c th
lp v in ha n bn hng cho khch hng.
Chc nng ny s c s dng khi ngi dng nhn vo
menu Out Bill trn menu Manage Bill.
1. Ngi qun l ha n ang trong phin lm vic ca
mnh.
2. Ngi qun l ha n nhn vo menu Out Bill trn
Alternative
Flows:
Exceptions:
Special
Requirements:
UC21. M t use-case List Bill
Nhm 4 Lp LT C H KHMT1 K2
trang 43
UC008.4
List Bill
Manager.
Chc nng xem danh sch ha n gip cho ngi dng c
Description:
Trigger:
Preconditions:
liu.
Chc nng ny s c s dng khi ngi dng nhn vo
mc Show Bill List trong menu qun l ha n xut.
Ngi qun l ha n ang trong phin lm vic ca mnh.
Ngi qun l ha n nhn vo mc Show Bill List
Alternative
Flows:
UC22. M t use-case Search Bill:
Nhm 4 Lp LT C H KHMT1 K2
trang 44
Preconditions:
UC008.5
Search bill
Manager.
Chc nng tm kim ha n xut gip cho ngi dng c
th tm kim ha n mun x l.
Chc nng ny s c s dng khi ngi dng nhn vo
nt Find trong form tm kim ha n xut.
1. Ngi qun l ha n ang trong phin lm vic ca
mnh.
2. Ngi qun l ha n nhn vo nt Find trong form tm
kim ha n xut.
Post Conditions: H thng s a ra thng tin ca ha n c tm kim.
Nu tm thy ha n, h thng s cho hin th thng tin chi
Normal Flow:
tit ca ha n .
Alternative
Nu khng tm thy ha n, h thng s a ra thng bo
Flows:
Exceptions:
Special
khng tm thy ha n .
Requirements:
UC23. M t use-case Save feedback information:
Use Case ID:
Use Case Name:
Actors:
UC0013.1
Save feedback information
Manger.
Chc nng thm thng tin phn hi gip cho ngi dng c
Description:
Nhm 4 Lp LT C H KHMT1 K2
trang 45
Preconditions:
Alternative
Flows:
Exceptions:
Special
Requirements:
UC24. M t use-case Show feedback information:
Use Case ID:
Use Case Name:
Actors:
Description:
Trigger:
Preconditions:
UC0013.2
Show feedback information
Manger.
Chc nng lit k thng tin phn hi gip cho ngi dng c
th xem c cc thng tin phn hi c trong c s d liu.
Chc nng ny s c s dng khi ngi dng nhn vo
mc Show Feedback Information trn menu Feedback.
1. Ngi qun l ca hng ang trong phin lm vic.
2. Ngi qun l ca hng chn mc Show Feedback
trang 46
Alternative
Flows:
Exceptions:
Special
Requirements:
Nhm 4 Lp LT C H KHMT1 K2
trang 47
Nhm 4 Lp LT C H KHMT1 K2
trang 48
Nhm 4 Lp LT C H KHMT1 K2
trang 49
Nhm 4 Lp LT C H KHMT1 K2
trang 50
Nhm 4 Lp LT C H KHMT1 K2
trang 51
Nhm 4 Lp LT C H KHMT1 K2
trang 52
Nhm 4 Lp LT C H KHMT1 K2
trang 53
Kiu d liu
Int
Datetime
Nvarchar
Nvarchar
Bit
Kch thc
4
8
50
50
1
TB_ActionDetails
Tn trng Kiu d liu Kch thc Rng buc Ghi ch
DetailID
Int
4
Kha chnh
ActionDate Datetime
8
NOT NULL
UserName
Nvarchar
50
NOT NULL
IpName
Nvarchar
50
NOT NULL
ActionEx
Nvarchar
255
NOT NULL
DetailInfo
Nvarchar
255
NOT NULL
TB_Group
Tn trng Kiu d liu Kch thc Rng buc Ghi ch
GroupID
Int
4
Kha chnh
GroupName Nvarchar
50
NOT NULL
GroupDesc Nvarchar
255
NOT NULL
Status
Bit
1
NOT NULL
Nhm 4 Lp LT C H KHMT1 K2
trang 54
TB_Member
Tn trng Kiu d liu
UserName
Varchar
Password
Varchar
Fullname
Nvarchar
Sex
Bit
Position
Nvarchar
Email
Varchar
Phone
Varchar
Mobile
Varchar
Fax
Varchar
Address
Nvarchar
Company
Nvarchar
CreateDate Datetime
ModifiedDate Datetime
UserModified Nvarchar
GroupID
Int
Status
Bit
Kch thc
50
50
50
1
50
255
50
50
50
255
255
8
8
50
4
1
Nhm 4 Lp LT C H KHMT1 K2
trang 55
Kch thc
10
50
4
TB_Function_Action
Kiu
d
Tn trng
Kch thc
liu
FActionID
Int
4
FActionName Nvarchar
4
FActionOrder Int
8
Rng buc
Ghi ch
Kha chnh
NOT NULL
NOT NULL
TB_Function
Tn trng
Kiu
liu
FunctionID
Int
FunctionName Varchar
FGroupID
Int
FActionID
Int
TB_Function_Member
Tn trng Kiu d liu
FMemberID Int
FunctionID Int
GroupID
Int
Ghi ch
4
50
Kha chnh
NOT NULL
Kha ngoi
Kha ngoi
Kch thc
10
50
50
Rng buc
Kha chnh
Kha ngoi
Kha ngoi
Ghi ch
Ghi ch
TB_Category
Tn trng
Kiu
liu
CategoryID
Int
CategoryName Nvarchar
Status
Bit
10
10
1
Kha chnh
NOT NULL
NOT NULL
Nhm 4 Lp LT C H KHMT1 K2
trang 56
time
Float
Bit
8
1
Ghi ch
NOT NULL
NOT NULL
Nhm 4 Lp LT C H KHMT1 K2
trang 57
TB_Product
Tn trng Kiu d liu Kch thc Rng buc
ProductID
Varchar
50
Kha chnh
SubCategoryI Int
4
Kha ngoi
D
ProductName
Describe
Processor
Chipset
Memory
HardDrive
OpticalDrive
Display
Graphic
Webcam
Wireless
Bluetooth
Reader
Software
Warranty
Weight
Quantity
Sold
Price
Status
Nvarchar
Nvarchar
Varchar
Varchar
Varchar
Varchar
Varchar
Varchar
Varchar
Bit
Bit
Bit
Bit
Nvarchar
Nvarchar
Varchar
Int
Int
Float
Bit
50
1000
50
50
50
50
50
50
50
1
1
1
1
50
50
50
4
4
8
1
Ghi ch
NOT NULL
NOT NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
Nhm 4 Lp LT C H KHMT1 K2
trang 58
Kch thc
4
50
50
50
50
50
255
50
50
255
50
50
8
1
TB_Order
Tn trng
OrderID
CustomerID
Address
Distric
City
OrderDate
Status
Kiu d liu
Varchar
Int
Nvarchar
Nvarchar
Nvarchar
Datetime
Bit
Kch thc
4
4
255
50
50
8
1
TB_OrderDetails
Tn trng Kiu d liu
OrderID
Int
ProductID
Varchar
UnitPrice
Float
Quantity
Int
Discount
Float
Kch thc
4
50
50
50
50
TB_Feedback
Tn trng Kiu d liu Kch thc Rng buc
FeedbackID Int
4
Kha chnh
Nhm 4 Lp LT C H KHMT1 K2
Ghi ch
trang 59
Nvarchar
Varchar
Datetime
Bit
TB_Banner
Tn trng Kiu d liu
BannerID
Int
BannerName Nvarchar
BannerDesc Nvarchar
BannerUrl
Varchar
BannerSize Int
Width
Int
Height
Int
StartDate
Datetime
EndDate
Datetime
CreateDate Datetime
Status
Bit
TB_Category_News
Tn trng Kiu d liu
CatNewsID Int
CatName
Nvarchar
Parent
Int
CatOrder
Int
Status
Bit
TB_News
Tn trng
NewsID
CatNews_ID
Subject
Describe
Content
Author
Source
CreateDate
Image
Status
Kiu d liu
Int
Varchar
Float
Int
Float
Nvarchar
Nvarchar
Datetime
Varchar
Bit
255
255
8
50
NOT NULL
NOT NULL
NOT NULL
NOT NULL
Kch thc
4
50
255
255
4
4
4
8
8
8
1
Kch thc
4
255
4
4
1
Kch thc
4
50
255
255
2000
50
50
8
255
1
Nhm 4 Lp LT C H KHMT1 K2
trang 60
Nhm 4 Lp LT C H KHMT1 K2
trang 61
Thnh phn
Tn truy cp
Mt khu
Trng nhp tn
Trng nhp mt khu
Button [ng nhp]
M t
Nhn ca nhp tn ng nhp.
Nhn ca nhp mt khu.
Qun tr vin nhp tn truy cp vo y
Ni nhp mt khu tng ng
Tin hnh x l vic ng nhp trang
Nhm 4 Lp LT C H KHMT1 K2
trang 62
Login
-
System.Web.UI.WebControls.Button btnLogin
System.Web.UI.WebControls.TextBox txtPassword
System.Web.UI.WebControls.TextBox txtUserName
bntLogin_Click() : void
Thnh phn
Danh sch
Thm mi
Sa
Xa
Chn
M t
Danh sch tn v m t nhm.
Chc nng thm nhm thnh vin
Click ng link t tn nhm
Xa nhm thnh vin
Chn nhm tng ng x l nt
Nhm 4 Lp LT C H KHMT1 K2
trang 63
Nhm 4 Lp LT C H KHMT1 K2
trang 64
class MemberGroupList
MemberGroupList
-
System.Web.UI.WebControls.Button btn_MemberGroup_AddNew
System.Web.UI.WebControls.Button btn_MemberGroup_Delete: int
System.Web.UI.WebControls.GridView GV_MemberGroup_List
+
+
+
+
btn_MemberGroup_AddNew_Click() : void
btn_MemberGroup_Delete_Click() : void
DeleteMemberGroupList() : void
GetMemberGroupList() : void
Nhm 4 Lp LT C H KHMT1 K2
trang 65
Thnh phn
Tn nhm
M t
Hot ng
Danh sch
Thm mi
Quay li
M t
Tn nhm thnh vin cn to.
M t chc v ca nhm.
Chn active hay khng
Danh sch quyn hn cho nhm.
Thc thi vic thm mi vo d liu.
Quay li trang trc
Nhm 4 Lp LT C H KHMT1 K2
trang 66
MemberGroup_AddNew
-
System.Web.UI.WebControls.Button btn_BackNew
System.Web.UI.WebControls.Button btn_MemberGroupAddNew
btn_InsertMemberGroup()
: void
Nhm 4 Lp+ LT
C H KHMT1
K2
+
+
btn_MemberGroupAddNew_Click() : void
MemberGroup_AddNew() : void
trang 67
Thnh phn
Danh sch
Tm kim
M t
Danh sch tn ti khon
Tm kim thnh vin theo nhm ,
Thm mi
Xa
Checkbox
Combo box
tn
Chc nng thm nhm thnh vin
Xa nhm thnh vin
Chn nhm tng ng x l nt
Chn nhm thnh vin tng ng
Nhm 4 Lp LT C H KHMT1 K2
trang 68
Nhm 4 Lp LT C H KHMT1 K2
trang 69
Nhm 4 Lp LT C H KHMT1 K2
trang 70
Member_List
-
System.Web.UI.WebControls.Button btn_Member_AddNew
System.Web.UI.WebControls.Button btn_Member_Delete
System.Web.UI.WebControls.Button btn_MemberSearch
System.Web.UI.WebControls.Dropdownlist DDL_GroupMember
System.Web.UI.WebControls.Dropdownlist DDL_Status
System.Web.UI.WebControls.GridView GV_MemberList
System.Web.UI.WebControls.TextBox txtSearch
+
+
+
+
+
btn_Member_AddNew_Click() : void
btn_MemberSearch_Click() : void
DeleteMember() : void
GetMemberList() : void
MemberGroupList() : void
Nhm 4 Lp LT C H KHMT1 K2
trang 71
Thnh phn
Thm mi
Quay li
M t
Thc thi vic thm mi vo d liu.
Quay li trang trc
Nhm 4 Lp LT C H KHMT1 K2
trang 72
Nhm 4 Lp LT C H KHMT1 K2
trang 73
Member_AddNew
-
System.Web.UI.WebControls.Button btnBack_AddNew
System.Web.UI.WebControls.Button btnMember_AddNew
System.Web.UI.WebControls.CheckBox chkIsActive
System.Web.UI.WebControls.DropDownList ddl_GroupMember
System.Web.UI.WebControls.DropDownList ddl_Sex
System.Web.UI.WebControls.TextBox txtAddress
System.Web.UI.WebControls.TextBox txtCompany
System.Web.UI.WebControls.TextBox txtEmail
System.Web.UI.WebControls.TextBox txtFax
System.Web.UI.WebControls.TextBox txtFullName
System.Web.UI.WebControls.TextBox txtPassword
System.Web.UI.WebControls.TextBox txtPosi
System.Web.UI.WebControls.TextBox txtTel
System.Web.UI.WebControls.TextBox txtUserName
+
+
+
InsertMember() : void
Member_AddNew_Click() : void
MemberGroupList() : void
Nhm 4 Lp LT C H KHMT1 K2
trang 74
Thnh phn
i mt khu
M t
Chuyn trang i mt khu ti
Sa
Quay li
khon
Thc thi vic thm mi vo d liu.
Quay li trang trc
Nhm 4 Lp LT C H KHMT1 K2
trang 75
Member_Edit
-
System.Web.UI.WebControls.Button btn_Member_Edit
System.Web.UI.WebControls.Button bntChangePass
System.Web.UI.WebControls.Button btn_Back_Edit
System.Web.UI.WebControls.CheckBox chkIsActive
System.Web.UI.WebControls.Dropdownlist DDL_GroupMember
System.Web.UI.WebControls.Dropdownlist DDL_Sex
System.Web.UI.WebControls.TextBox txt_UserName
System.Web.UI.WebControls.TextBox txtAddress
System.Web.UI.WebControls.TextBox txtCompany
System.Web.UI.WebControls.TextBox txtEmail
System.Web.UI.WebControls.TextBox txtFax
System.Web.UI.WebControls.TextBox txtFullName
System.Web.UI.WebControls.TextBox txtMobi
System.Web.UI.WebControls.TextBox txtPosi
System.Web.UI.WebControls.TextBox txtTel
+
+
+
+
+
EditMember() : void
GetMemberInfo() : void
Member_Edit_Click() : void
MemberGroupList() : void
Page_Load() : void
Nhm 4 Lp LT C H KHMT1 K2
trang 76
Thnh phn
Thng tin
Lu
ng
M t
Nhp mt khu mi
Thay i thng tin trong d liu
ng trang hin thi
Nhm 4 Lp LT C H KHMT1 K2
trang 77
MemberChangePassw ord
-
System.Web.UI.WebControls.Button btn_CloseChangPass
System.Web.UI.WebControls.Button btn_SaveChangPass
System.Web.UI.WebControls.TextBox txt_NewPass
System.Web.UI.WebControls.TextBox txt_OldPass
System.Web.UI.WebControls.TextBox txt_RePassNew
Save_ChangePass_Click() : void
Nhm 4 Lp LT C H KHMT1 K2
trang 78
Nhm 4 Lp LT C H KHMT1 K2
trang 79
Thnh phn
Email ng nhp
Mt khu
Checkbox
M t
Nhp email thnh vin
Nhp mt khu ti khon
Lu li thng tin ng nhp cho ln
sau
Button [ng nhp] Tin hnh x l vic ng nhp
trang
Nhm 4 Lp LT C H KHMT1 K2
trang 80
Nhm 4 Lp LT C H KHMT1 K2
trang 81
Thnh phn
Textbox
Button [ng k]
M t
Nhp thng tin ti khon
Tin hnh x l to ti khon cho
Button [Hy b]
user
Hy b thng tin ti khon
Nhm 4 Lp LT C H KHMT1 K2
trang 82
Nhm 4 Lp LT C H KHMT1 K2
trang 83
Thnh phn
Thng tin
Button [t hng]
M t
Thng tin chi tit sn phm
Tin hnh x l a sn phm vo
gi hng
trang 84
Thnh phn
Textbox
Button [Xa]
hng
Button [Cp nht Tin hnh update s lng tng sn
li]
Button [Tip tc]
phm
Quay li trang sn phm chn
Button [t hng]
hang
Checkout gi hng
M t
S lng ca mi sn phm
Xa sn phm tng ng trong gi
Nhm 4 Lp LT C H KHMT1 K2
trang 85
Nhm 4 Lp LT C H KHMT1 K2
trang 86
Nhm 4 Lp LT C H KHMT1 K2
trang 87
Nhm 4 Lp LT C H KHMT1 K2
trang 88
setName(string strName)
{
this.name = strName;
}
public void searchAccountByName()
{
}
+ Cc bin c t tn cng theo quy tc trn
ch ci vit tt ca kiu d liu + tn bin (c tnh m t)
Nhm 4 Lp LT C H KHMT1 K2
trang 89
intAge;
tblAccount
FROM
tblAccount
WHERE userID = 2
Nhm 4 Lp LT C H KHMT1 K2
trang 90
N4
STT
1
2
cng
vic
M t
Ngy bt u
Ngy kt thc
vin
quan
Thit k giao
din
Xy
Thnh
10/07/2009
14/07/2009
10/07/2009
Hon thnh
Hon thnh
ang lm
Thm
ang lm
Thm,
Hnh
H
H
Thm,
Hnh
Thm
H
Hnh
trang 91
ang lm
ang lm
ang lm
ang lm
ang lm
ang lm
H
Hnh,
Thm
H
H
Nhm 4 Lp LT C H KHMT1 K2
trang 92
ang lm
ang lm
ang lm
ang lm
Nhm 4 Lp LT C H KHMT1 K2
trang 93
STT
Tn cng vic
M t
Nhm 4 Lp LT C H KHMT1 K2
Tnh trng
Mc
hon thnh
Nhm
Hon thnh
100%
Hnh
Hon thnh
100%
Hon thnh
100%
ang lm
80%
Thm
Thm, Hnh
H
H
Thm, Hnh
Thm
H
H
Hnh, Thm
H
H
ang lm
ang lm
ang lm
ang lm
ang lm
ang lm
ang lm
ang lm
ang lm
ang lm
ang lm
75%
75%
80%
80%
80%
50%
60%
75%
85%
90%
50%
trang 94
v kim th
thng
Vn hnh v bo
tr
Nhm
Cha lm
0%
Nhm
Cha lm
0%
2. Chi ph thc t
-1
-2
Ngn
sch
c tnh
c
duyt
-3
-4
1
2
3
4
5
Xc nh yu cu
Thit k
Ci t, kim th n v
Tch hp, kim th h thng
Vn hnh v bo tr
Tng
3,250
775
2,575
1,650
750
9,000
S
hiu
M t cng vic
cng vic
Nhm 4 Lp LT C H KHMT1 K2
3,250
775
2,575
1,650
750
9,000
% honc
Thc Lm
thnh
php chichi
chi/chi cnTng
(today) (today) (today) d
-5
100%
100%
50%
0%
0%
-6
(4)x(5)
3,250
775
1,288
0
0
5,313
trang 95
-7
2,900
650
2,000
0
0
5,550
-8
(7)-(6)
-350
-125
713
0
0
238
-9
(4)+(8)
2,900
650
3,288
1,650
750
9,238
trang 96
Nhm 4 Lp LT C H KHMT1 K2
trang 97