Website: Email : Tel (: 0918.775.368
Đồ án tốt nghiệp Xây dựng hệ thống quản lý khách sạn E-Hotel
Mục lục
Phần a: lời nói đầu
Phần b: nội dung
Chơng 1: Mô tả bài toán và giảI pháp
quá trình hoạt động của khách sạn 5
1.
2. ! "
3. # !$ !%&
!'. (
%)#! ! *+
GiảI pháp kĩ thuật.**
1. ,-! ./ **
2. ,-!01 **
Chơng 22giới thiệu về ngôn ngữ lập trình *3
I. Tổ chức chơng trình của VB (Project) *3
II. Truy cập cơ sở dữ liệu từ xa bằng mô hình ADO *4
(ActiveX Data Object)
1 567895:6;':8:< -=> ?@.*4
2 ABC65 ( Active Data Object).*
III. Trình thiết kế môi trờng dữ liệu DED.*"
(Data Environment Designer)
1 D.*"
Website: Email : Tel (: 0918.775.368
Đồ án tốt nghiệp Xây dựng hệ thống quản lý khách sạn E-Hotel
3 8! E F 6G .
.*H
Chơng 32giới thiệu về Cơ sở dữ liệu *(
1. 7- . 19
2. IJ 33

*8! !0>;-………………………………….…4H
38![LF\01 …………….
….4(
4AB0[LG]^)01……………
*
AB0……………………………………….*
 ,M0\)> 4………………………………
Tµi liÖu tham kh¶o
Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
phÇn a: Lêi më ®Çu
_'[!L`)a%!\?
>0 BLba%.[)$'1TF!
\=)!\b !F!0L
_Ya!L$Y>!ZcB#Z
LX%VBd;dbYB>F'1N0
abUM#aYca%.[e0!M#a
-%Vc'-Jc MM%D%FZJ
_M%%F MfJ%SWZI
!Z!LcM%D!L'U`%b/
Z'[gb)B0BhUFIZc
M%DLb:F M%S$_
P=EScM%DZ['[!LIW0U
M#B0BZY
I;1-c0-%V !'bF!J)
BcM['U$%\20%PO'>) !i!
BEB0!MYb;j'h'!
!Ufb%PY=e0SM[>-%V
!'M%D%BkEjS0- 
MiJ%b## !

'`!B%W02'1%bc'1
!c'1%b>c'1%bBcc
Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
_ !-BY !2W !cZ\cB
DMcDl%W%c'10c'1tcZ
vWE1ZF%-Z


S¬ ®å quy tr×nh ®Æt phßng:
_O !
_/WE
n!D -=!U
Io/c#
_/B
pwDZ !
mxB
_/ wDf !
Ihb
p&
qx>!
2
'1%xbc
)
%c
p!' B
p-=!U
OV
8//N)
p!

# bJ:WEW) !7F/%rS
II. giảI pháp kĩ thuật

n!/0
m)#= \
n!D -=!
7
,Z0!MD#
x !/
NJO'>

n!D -=)pR
,Z0o/
qx>!
p&
TgxZ 8xgxZ
Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
3. Quy tr×nh phôc vô kh¸ch hµng trong thêi gian kh¸ch lu tró
t¹i kh¸ch s¹n
I$ !%& !'c  !WE'XM#
MD#c !''`J!MD###E) !7F
/%rS/!'XM#MD#) !X%Wf
!;F/## !W%/hb%! -\
) !
S¬ ®å quy tr×nh phôc vô kh¸ch
8JMD#
mB'XM#MD#
IhbB'XM#MD#
Website: Email : Tel (: 0918.775.368

- 8J8q}1Lq:++A~
- N0Y2•Mu'(Hc•Mu'AGc•Mu'3+++c
•Mu'nq
2. Gi¶i ph¸p hÖ thèng
0S\F) !'MrW
J28B0!U WEEb-
L!UbYE-F>
L-%Vb!B0Wb[F!W!
\N01ZMP%0%28!BY !c$W
) !c!!%MD#cB !'XM#!MD
#N01'`X%V!MP%0L2q!
 !c!;!!1 WMc
!cVc!M[k \F'dZ
Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
Ch¬ng 2: ng«n ng÷ lËp tr×nh
visualbasic
e'%7'$J>-JLPUM#
A'tt•Mu'7J L;%FW0%$%/
•Mu'e'%7'J;F/b!B#
lL!L!UM#
e/e'%7'%€IE•e'%‚!>UL
M0O$'XM#IPMTLB-'[J
0D\)PEM0clEWP1]
b T b D . Z  ?  D  \      W    I  E
•7'‚BP7'FBPbMk;?Y%/
>;JUFBP !%D'X!\
Ife'%7'*+Ze'%7'+Tb;h'WY!
!UcWEgb43;c -=!/W\
-=!Y LWe'%7'Q+b;h'F'1

2. Truy cập cơ sở dữ liệu từ xa bằng mô hình ADO (ActiveX
Data Object)
ABMkL/X%V>'?MP%0fB
$ 15678
2.1 ODBC 95:6;':8:<p-=> >'?
?@2%F;0!F%/UM#L 1Y>'?MP%0r
%FY L&d5678'` 1Z>'?
MP%0f
5678%243;*Q;
- 5678CM43;56786R:CM97F
YOMP%05678@'`;O!;-'2
Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
†':6R_28ƒJFOMP%05678M
lF$Mk
†R':6R_2n!%/!OMP%0'`bY$Mk
WF!\
†…%:6R_2n!%/FOMP%01/
56786:2m0 W!Y L5678TW0
1
2.2 M« h×nh ADO ( Active Data Object)
. 2.2.1 §iÒu khiÓn ADODC ( ADO Data Control)
q„:8:8%A'tC6568% 
Q+95mG67@
• Mét sè c¸c thuéc tÝnh:
-8:R‡•6R_‡IW 15678‚
-8MI:9n!D! LS%0@2M8MI;%:
Connection
Command
Parameter

Website: Email : Tel (: 0918.775.368
Đồ án tốt nghiệp Xây dựng hệ thống quản lý khách sạn E-Hotel
q:^:t:::'A'tC:n65;:3+
m;
* Khai báo và thiết lập :
6'C65678:c''C6567^:MR:
R:_:uC65678:
5:IW 15678
R:'_:uC6567^:':
R:'::9W;-_FM)S%0R:%:@
_L//MP%0F![ BEB
^:':2G::9': 6:%:: }M: @
*Phơng thức (Method):
8//2
_/Z2'CMM_:u
':%M'9W$@;LU!D


'}M:
RXMP%02
G::9}M:W;-R:W$!DE@
nMP%02'6:%::
;6DL2
'A:'
'A:m'
'A:_:
'A:q:'
'A:
IF\2
'75

F;->'?MP%0 b 1 1ZY
Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
;->'?MP%0 19'XM#Rm@ IgF
ML!S%0_2gS%0
 1FY;-MP%0LSMP
%0);-:F$cY/1Z
;-;0 S%0;d;F-%/1
  0 Z ;- MP %0   S %0    /    9'X  M#
CM:M@AF6Gb'`bO?;FZMZMB
0E?F%6R^
IPB$ MP%096G6@ Tb!%0
98M@L/!;->'?MP%0UZg
%0'`>UF^:M':LX%VMP%0;-Z
E)!>UF\c^:MR:>U'`W2
^RW%09 ‹:@
† 8!>U)^:MR:M
IW6G^RW%0CMM_:u
IW6G^RW%06:%::
IW6G^RW%0}M:
IW6G^RW%0…M“;LUY 0”
IW6G^RW%0A:…'
IW6G^RW%0A:m'
IW6G^RW%0A:q:'
IW6G^RW%0A:_:
IW6G^RW%0A:
† IF\2
IW6G^RW%075…
IW6G^RW%0G5…
IW6G^RW%0…%:‡“;LUY 0”


Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
IX'hM;':a;';%:a:uLF;-Z
#M:'L 'X%J&)F;-TO
8!;ZF;-MP%02
†WF$hWF$9%0Z!;-
T'|@Ft:%M:
IW$cOFMK B!Q \[;OP!cP'1-
-1
†8a LMP%0>UZ$F6:
pYMP%0!f$L%! LMP%0'2
pL AB- p\Z
: pV[
6[3;:
: pV[
6[Q+++;:
;: R1Wc[ 6*c3cH;:
M:y: _c!c,$ 6H;:
: IY0 6H;:
;: R1 6H;:
:'y 7%: 6*;
%:;„: 1b& -
• 8!%0
†A10F<F2o!D)$ !lF;-
);-Z-' ZZ!D>U)$0
;-0I$bcf !;-Z-%MJ
†A10F<Y2o$ !\);-Z-
%MJc!!D$ !);-ZL' ZZ
Y#;-0W0>'?MP%00I$b

:V1IA'tC:''cL!J;j>0
JO:K7G!S%0Rm8LD.
Website: Email : Tel (: 0918.775.368
§å ¸n tèt nghiÖp X©y dùng hÖ thèng qu¶n lý kh¸ch s¹n E-Hotel
!JMkLac//c‹!6GmL!
;-Zf!MP%0FY;-'|
3. MÉu biÓu ( Form):
mF1bb )MkL/LDMP%0c
Y L0[0FUM#8iLK;LcL
 FK;LLFA !D)MP%0h
4. B¸o biÓu ( Report):
mF1bb LD!\!chb!
MP%0bacL:F;!!WZ 
7!;LMkLJ! -' TbX%Vf;-f
JZ! -='2
]MP%0MZM!;-
]MP%0MZM
]RdMP%0Z LSMP%0Z 
'XM#ƒ!LhbMP%0WgZ 
]_MP%0hb/bW!L
BUL/b'[''!1W!
W;!;L
]MP%0)Y;-%WZkF%&;j
01;!;L\;!;L#J*cJ3
_0atPc{Pc LPc'1%b;-c!
i0;W!;!;Lb>-

5. Macro ( Macro)
mF1bD.FYF9!@J
&C:'''`[0L!UF'[ 0!De\M#L F

%W!MP%0%&bMLchcb%PS
1IW-%F0YOFfF;hPc\M#
•\%>‚c•%/>‚
Ib \02
2l'10
T¸c nh©n (actor): >J!9O@>9\@)MP%0f
01b:ƒIW!S-%FMf2• !
‚c•J‚…
p\02

tªn tiÕn tr×nh
Tªn t¸c nh©n