!This program cannot be run in DOS mode.
`.rsrc
@.reloc
y (s,
- 2s,
y as,
$ ks,
F &s1
R &s1
h Ks,
& "s,
h s,
h Ns,
F &s1
T &s1
b &s1
Y &s1
R &s1
R _s,
U ,s1
T &s1
Y &s1
[ &s1
b &s1
" Ps1
( (s1
( (s1
3 *s1
T `s,
Z -s,
, *s1
U ,s1
T &s1
Y &s1
[ &s1
b &s1
u Ss,
u !s,
! )s,
W %s1
V )s1
@ )s1
T )s1
[ &s1
R "s1
u )s,
u ]s,
7 Hs,
U ,s1
T &s1
Y &s1
[ &s1
b &s1
&+6rC@
r %s1
, *s1
K &s1
X &s1
M ,s1
P &s1
U &s1
T &s1
b &s1
U ,s1
T &s1
Y &s1
[ &s1
b &s1
5 (s1
; *s,
5 (s1
5 (s1
F &s1
h Ns,
0 ?s,
R "s1
u )s,
u ]s,
R &s1
Y &s1
T &s1
b &s1
F &s1
? -s1
A #s1
Q #s1
Q #s1
v4.0.30319
#Strings
label10
label11
txtGiamGia_TextChanged_1
txtSoLuong_TextChanged_1
IEnumerable`1
label1
panel1
button1
pictureBox1
groupBox1
label12
ToInt32
ptn_Sub2
label2
panel2
button2
LoadDataGridView2
pictureBox2
groupBox2
label13
pnlSub3
label3
panel3
label14
label4
panel4
label5
panel5
label6
label7
label8
label9
<Module>
<PrivateImplementationDetails>
tblCTHDB
btn_NXB
txtMaNXB
lbTraNXB
tblNXB
pnlNXB
frmNXB
cboNXB
txtNXB
dgvNXB
txtNamXB
tblCTHDN
get_jpSO
cboMaNV
txtMaNV
txtTenNV
tblCTHDX
dgvCTHDX
txtTacGia
lbGiamGia
txtGiamGia
txtGia
btnXoa
System.Data
exeData
GetData
btnSua
FromArgb
mscorlib
System.Collections.Generic
btn_DanhMuc
frmNXB_Load
add_Load
frmSach_Load
frmNhapSach_Load
frmXuatSach_Load
frmKhach_Load
frmTheLoai_Load
frmHoaDonBan_Load
frmNhanVien_Load
frmMain_Load
Login_Load
frmBaoCao_Load
frmThongTinKho_Load
textBox1_TextChanged
cboNXB_TextChanged
txtGia_TextChanged
add_TextChanged
txtSLKe_TextChanged
txtSoLuong_TextChanged
cboMaSach_TextChanged
txtSLKho_TextChanged
cboKieuXuat_TextChanged
lbTraNXB_LinkClicked
lbGiamGia_LinkClicked
add_LinkClicked
lbSachKho_LinkClicked
lbSachSapHet_LinkClicked
get_Enabled
set_Enabled
set_FormattingEnabled
set_Handled
set_DoubleBuffered
set_Selected
Synchronized
DataGridViewBand
DbCommand
SqlCommand
txtSLKe
lbTrenKe
Replace
FlatButtonAppearance
get_FlatAppearance
CreateInstance
defaultInstance
set_DataSource
set_AutoScaleMode
set_AutoCompleteMode
set_SizeMode
set_ColumnHeadersHeightSizeMode
DataGridViewColumnHeadersHeightSizeMode
PictureBoxSizeMode
set_AutoSizeColumnsMode
DataGridViewAutoSizeColumnsMode
set_AutoSizeRowsMode
DataGridViewAutoSizeRowsMode
set_EditMode
DataGridViewEditMode
set_Image
set_BackgroundImage
AddRange
pnl_Change
change
get_WhiteSmoke
DataTable
Enumerable
IDisposable
set_Visible
ToDouble
RuntimeTypeHandle
GetTypeFromHandle
FromFile
set_Title
DockStyle
set_BorderStyle
set_FormBorderStyle
set_FlatStyle
FontStyle
set_Name
get_FileName
DateTime
set_Multiline
set_ValidatingType
GetType
System.Core
get_Culture
set_Culture
resourceCulture
InternalDataCollectionBase
ButtonBase
ApplicationSettingsBase
TextBoxBase
Dispose
Reverse
EditorBrowsableState
set_WindowState
FormWindowState
add_MdiChildActivate
get_White
STAThreadAttribute
CompilerGeneratedAttribute
GuidAttribute
GeneratedCodeAttribute
DebuggerNonUserCodeAttribute
DebuggableAttribute
EditorBrowsableAttribute
ComVisibleAttribute
AssemblyTitleAttribute
AssemblyTrademarkAttribute
TargetFrameworkAttribute
AssemblyFileVersionAttribute
AssemblyConfigurationAttribute
AssemblyDescriptionAttribute
CompilationRelaxationsAttribute
AssemblyProductAttribute
AssemblyCopyrightAttribute
AssemblyCompanyAttribute
RuntimeCompatibilityAttribute
ToByte
get_Value
set_Value
get_SelectedValue
GetValue
ResetValue
get_Bisque
jXXj.exe
set_Size
btn_MiniSize
set_AutoSize
set_BorderSize
set_ClientSize
ISupportInitialize
get_PeachPuff
set_Tag
btnKhachHang
dgvHDBanHang
tblThongtinHang
ResetValuesHang
set_Padding
System.Runtime.Versioning
ToLongTimeString
ToShortDateString
ToString
GetString
Substring
disposing
System.Drawing
pnlSoLuong
txtSoLuong
OpenFileDialog
CommonDialog
ShowDialog
btn_Sach
cboMaSach
txtMaSach
lbTongSach
btnDanhSach
tblSach
frmSach
QuanLyBanSach
txtTenSach
frmNhapSach
frmXuatSach
dgvSach
cboMaKhach
txtMaKhach
frmKhach
txtTenKhach
dgvKhach
picAnh
txtAnh
ComputeStringHash
set_Width
get_Length
set_MaxLength
btn_TheLoai
txtMaTheLoai
tblTheLoai
frmTheLoai
cboTheLoai
txtTheLoai
dgvTheLoai
txtDienThoai
txtDiaChi
ketnoi
get_Black
button1_Click
button2_Click
btn_NXB_Click
dgvNXB_Click
btnXoa_Click
btnSua_Click
add_Click
btn_MiniSize_Click
btnDanhSach_Click
dgvSach_Click
btn_TheLoai_Click
btnThem_Click
btnTim_Click
btnIn_Click
btnOpen_Click
btnBo_Click
btn_Thoat_Click
btnDangXuat_Click
btnLuu_Click
btnHuy_Click
dgvCTHDX_DoubleClick
add_DoubleClick
dgvHDBanHang_DoubleClick
dgvHDNhap_DoubleClick
dgvNV_CellClick
add_CellClick
dgvKhach_CellClick
dgvTheLoai_CellClick
PerformClick
MenuClick
set_Dock
set_Mask
RunSqlDel
LinkLabel
System.ComponentModel
set_TopLevel
DataGridViewCell
get_SeaShell
get_Control
ContainerControl
ListControl
Program
btnThem
get_Item
get_SelectedItem
System
btnTim
cboTim
btn_Ban
frmHoaDonBan
resourceMan
get_Green
pnlTongTien
txtTongTien
txtThanhTien
btn_NhanVien
frmNhanVien
get_Linen
btnOpen
cboQuyen
set_ImageAlign
set_TextAlign
frmMain
set_Margin
DataGridViewColumn
lbHoaDon
LoadInfoHoaDon
MessageBoxIcon
Application
set_Location
System.Configuration
System.Globalization
System.Reflection
DataGridViewCellCollection
ControlCollection
DataGridViewColumnCollection
ObjectCollection
ArrangedElementCollection
DataRowCollection
DbConnection
SqlConnection
set_StartPosition
FormStartPosition
Exception
System.Data.Common
get_Maroon
get_Crimson
Button
add_DropDown
cboTim_DropDown
get_SaddleBrown
tblBaoCao
frmBaoCao
btnBaoCao
dgvBaoCao
FillCombo
CultureInfo
txtSLKho
lbTrongKho
lbSachKho
frmThongTinKho
btnKho
btnNhapKho
btnXuatKho
tiento
dgvHDNhap
txtGiaNhap
Bitmap
pnl_Top
set_TabStop
System.Linq
set_UseSystemPasswordChar
get_KeyChar
InvokeMember
set_ValueMember
set_DisplayMember
DbDataReader
SqlDataReader
ExecuteReader
sender
Binder
get_ResourceManager
ComponentResourceManager
DateTimePicker
LinkLabelLinkClickedEventHandler
DataGridViewCellEventHandler
KeyPressEventHandler
PaintEventHandler
System.CodeDom.Compiler
IContainer
set_IsMdiContainer
txtUser
set_Filter
DbDataAdapter
SqlDataAdapter
set_Anchor
set_BackgroundColor
set_ForeColor
get_BackColor
set_BackColor
set_UseVisualStyleBackColor
set_MouseOverBackColor
set_BorderColor
IEnumerator
GetEnumerator
Activator
.cctor
System.Diagnostics
System.Runtime.InteropServices
System.Runtime.CompilerServices
System.Resources
QuanLyBanSach.frmNXB.resources
QuanLyBanSach.frmSach.resources
QuanLyBanSach.frmNhapSach.resources
QuanLyBanSach.frmXuatSach.resources
QuanLyBanSach.frmKhach.resources
QuanLyBanSach.frmTheLoai.resources
QuanLyBanSach.frmHoaDonBan.resources
QuanLyBanSach.frmNhanVien.resources
QuanLyBanSach.frmMain.resources
QuanLyBanSach.Login.resources
QuanLyBanSach.frmBaoCao.resources
QuanLyBanSach.frmThongTinKho.resources
QuanLyBanSach.Properties.Resources.resources
DebuggingModes
QuanLyBanSach.Properties
EnableVisualStyles
AnchorStyles
GetTypes
GetFieldValues
ResetValues
BindingFlags
Settings
LinkLabelLinkClickedEventArgs
DataGridViewCellEventArgs
KeyPressEventArgs
PaintEventArgs
get_Cells
get_Controls
get_Items
System.Windows.Forms
get_Columns
set_AutoScaleDimensions
System.Collections
Functions
MessageBoxButtons
get_Chars
SystemColors
txtPass
QuanLyBanSach.Class
txtNamXB_KeyPress
txtGiamGia_KeyPress
txtGia_KeyPress
add_KeyPress
txtSoLuong_KeyPress
txtDienThoai_KeyPress
txtGiaNhap_KeyPress
components
get_Rows
set_AllowUserToAddRows
RemoveAt
Concat
GeMaLonNhat
lbSachChayNhat
set_Format
DateTimePickerFormat
btn_Thoat
btnDangXuat
cboKieuXuat
GetObject
lbSachSapHet
pnl_MenuLeft
set_Height
EndInit
BeginInit
GraphicsUnit
get_Default
SetCompatibleTextRenderingDefault
DialogResult
System.Data.SqlClient
HorizontalAlignment
ContentAlignment
InitializeComponent
get_Transparent
get_Current
add_Paint
pnl_ButtonMenu_Paint
set_Font
get_Count
Convert
System.Windows.Forms.Layout
SuspendLayout
set_BackgroundImageLayout
ResumeLayout
PerformLayout
MoveNext
get_Text
set_Text
get_ControlText
set_HeaderText
txtMatKhau
txtGhiChu
pnl_SubMenu
pnl_ButtonMenu
btnLuu
LoadDataGridView
get_Now
DataRow
get_CurrentRow
DataGridViewRow
set_TabIndex
set_SelectedIndex
set_FilterIndex
MessageBox
PictureBox
set_ControlBox
ComboBox
GroupBox
MaskedTextBox
txtDenNgay
txtNgay
txtTuNgay
ToArray
CreateKey
CheckKey
get_Assembly
set_ReadOnly
ExecuteNonQuery
op_Equality
op_Inequality
btnHuy
WrapNonExceptionThrows
QuanLyBanSach
Copyright
2021
$bc3ca0e1-9710-4c83-b640-0173781b7b0f
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
PADPADPa
ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-ZZ-Z
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
PADPADP
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
PADPADP
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
PADPADP
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
PADPADP
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
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=b03f5f7f11d50a3aPADPAD
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
IDATx^
wu,<gEsa
V$k?i~b
q}S :kL@X
fx++7N
w6XTE\
[wox8y
@W';w Wjb
?==79p
% /{#{6L4
W_% /}=
SU!cJ5
}j9jRH
pDs?hv5k
XBV}[v
g_0 SVoO
!+!MvE
WVZs</
oiM:"h9
:VU!em
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
UIDATx^
QN/aq|
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
IDATx^
Be@Q+.t
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
IDATx^
+*E)*6
QP?jkko
3.2}w\[t;
@]yM-nh^f
`dH@WKWI]K
U]5---
@C`mfg 5
nUuQ0YJ<
pN\6]4kk`
@D0Y fGD
"0mc6@
Q{j-_`
}7x]xf
9woRFC
Vl]EGO
~l6?wW
>yfjKY
,6)#03
8'/o;1
MFRud+
M@O!768
Hs[@SB[@}
>N^]]U-Mu#}
.:4C)F3f#,
-e>pkq
J/7b)+k
|B@:(d
{l27k[
Y=a7>O
8g%BzZK
zI/LY];
fbnLHno
YSSWENS
BwY!/G
-*O76N
BG@x;/
73N<^i
=1+/xm
|*MLJfKX
vA/s:o
SU&MRD
Pn.y`0R
Z?7~jp
\knMSQJt2
+1O_;>NR
3g_5iw
rh^v|!9
?OWY=rPx+
V:XNEnT
t?EY;M{}L5
amPy|`
u3^ihN
1eX -w
:|57+8X
Y-576j'Y<t
!Dv)@E
J=1$ #
8eV{4>
;ZZg; M
u&Fy7G
0=ZsMB5
Fph!&X
y+|NRef
>#E'0U
}[&h?`s
v?wP_gy
r5363y
zYClOF
*x2YR&
UDcRXy
<x^!OV
kL@%K{1H
GUO`soINnRJ8
+W\$S5
hnE{o#h
_^43T[b
f\LNVv
={^Z<;pP]s
a,|?*A
.N6dkSA L
? oaVq$
Tj,(g_
x<>zjh
'&z 4>
%d!iiif
`RVEEIhN
K,!P<|hx
x )g^7S*#
zjmlwj
#,>+`%2
6 dVzxWw
vnoV&YO
X? _=e
E!Ke:S
dqCgks0
{@Mu_F
50?Skl
M1 1]$U
CbD<EGT`eEV
kL@}&
@H&JhD
SX$^.j
,<X:53
dx.qkL
;JKA;@
2EsTSzZ
nerDtU
SD N&<s
/8,$1H
6a4p'W6
s:7m<"
yW&IAw
o*s 24
Of*qdnR
iu B{r=
BZKz&8
xET q(
;~JZ4$.3Y
ln>IOl
NB||y|B)
rEE4'";m|
U@|e~}T
P <F'R
`Mpk}>`
.$/ )5
@dvC)
<Rxe:B
R3g>\O
u5#)QNb~,
IDAT~W
\^4{vj
eLIi, QQ
(t@mGa}5
L-^ xN
N5<*Wy
52q8&,
{A{o`H$K^(
4)/"^'
<'.7,)
Tj.)9K
!xcj0NG
o5_[,gF
=#$;'''{
,cFthy
E-CcEU
lZDQ{]
3)1abdzi< 'paq
o6h}tt5
pfIbD8S
R/I@S3
9nllxy
ZLiJ4t
.4}KZ!
l||ZlL
}SXQdp
JDd}N.
gPAvNt5
w-4,YP
Me>[_x
i&5xZ(
Z.r re
2ATzIhM
<AN[OF
a\CsN#
JOk%hP
u{YMZsx3
-*_L9O
mk H_L"HD
}YNkkRYq]m=
A|QU<#
G;Lv:%
6FD $
^^)%J|
{sE7/zg(e
tqvkEAU
7aF<U+
w-fDt@
S7}`AZ8ir+?
$X/d&p
j{**\m
d RO3mS
gZIi?@
$$)jCP
HLCNY[Of
,><E\]
W(gps*
7dPs5tN
$bLz}$
$m.Na:K
+a'0aa
ppY<e}J
[O71SX7
CyI_}=L
]U3LVl!
a.%AiH
/ 8 _^
WCBkEC
_B-in1
Ts}Mc!
W\suOY
)jY??|y\n]
x"(_Fj}2
rj?KS`x"Z4
8!*>;+k
:e$>LhW7
40+3Y=
^~hrTqO
DnrPZuv~n|
gZlyl8
}ffD p
VK8:xV
nP29.<%
\-W8M;
%Y>5z2
>Qrx@
\t|NqYWh
$!ceN~
dn{Aml:( HhM
LHI;bM
g"F+&a
*FFo5Q
yldeI&
XxH=t>
Y 5SlS5
3o%zI4Q
cj}|A@^
SApa1G
j'APJb+
(_C;A}
hH7-QNU
zPN} |H
Z^Sj6Y
r2d 4GR@
L{J?<9`
-~oQZr
'>NN<pj
yr[@v
'cX5 L
9o(1of
.41l_7i
?2O/[
Jgb@\Q
_.;Yc@
->^hh|
$k#+~. 7
#J}j'`W~
H*RSGm
!!4zQ@,
m8O(\.
Y/K-fL\
|E3>,V
;xxZF@
#Xr' ]
jqCq)O|Du
[?O1 k
sZEUa8
q!,b%'
|4Fk\o4
t~1#dT
I9p PwB
9Q: *^wF*/
IW[h&m<-X
H,Y~5b
m $eTeI
ho<C:}3p6
QtqB<
"qb\q3]Cm
W5,n[Q~mRj
N7cjCk
j.:dK<
UcV;E
nw^~jx
V3&c`4JAYA0-
M^~tbO
Os{NhnUY
/JV\{P=
Q$0NdY
.x.w:5
l]E: 3
V5C<>E
e;2(lCM
ggKF%$
I}."H'
66@@26P
#H{W[1
<"{Yjli
t7CMKCR
B5JEEU
\Qij~z
C-YqR[i?
j|aKKz"d
%;8cjK-
lW6`W%
8Yv^e&
'2_E~
/&O8lyj
^+Z}/c
*0YWHJ
EW:`3V6
Nd~lkf
{Wjn!=
|zcv8o_
]gfS_X
uzqO>u
k/EqU;
rnBJxiz7h
US9Amq:ooR
}~m]n>
-'_]_t
VT6V=1
N_xQpD
&d:{5G_0
[vNqzs}
QfTc^u
G]ES|,
|_iE`d/
Y |,m+
%"sjFhZ
[=7t#(4-H(%
w k_Vb
4YW0]+
[rxle=h
'lx3f
1I4'P-
}Sz-Nxy
u8/"GB.
i~34S'
Oi;>.%
!A8AY\
^^v"+Qcn
Hwqf:n
S0auR[
_Zj+hhd
1PV%$S
foz+g4
Z34:g|
[*+.F/
[!h:Zq
KP=o/wK
E&urG.R>L
9iixMI
Kg+xFL_{P
'9=A.C
|8wr wf
ss5*NnI
XTSq:lv
?jdr?[
}=4?JQ5
GAy -z
%;:N2y
2B o#5
(BXDa(
j"26m!
40@Z,L"
!yYKWN
QTN Oj
i9EG\p[
-5l?]?
91(|vb
[#;'^q
&Q#QA5
+#Ix\^
frhEiIPP(
8O5u(U
z2&7":
RSet7Jl9
/-2333
n[wCw(Pc
/qwEdis
{2:W(`
Q+QvZtnXq
f5cc$;
8'.b2p
O{)J"Bq
%;z$y^
lks_(z>
7Db!T@oI%
@^^NE`
=[7Ytl
8}}|g{"
I"B? $
oWtV]P
'6KzrQ
O>,JS*vY
z>I1{j\
2f0>!(F
/ r}&>g
[=>v?6gx
`}lqN_
,0da<d
Pam|@'
|?j+Bk
:UMuYie
V"$5sq
rN <=/
G*-+t
T)7|39
H7E-@n
QTgDK_
no,!=)W
frViNF
PQ XHJ,n
|1dry+x
wiiQC3!
T3!iJ1v
7\(I#'
qk5<Ub
$P `R)
TdBISI
*#S|Fs
pnYehh(
5mj(ENU
jyG)9D
*5U5MEEU
DEeUMM
L_QeRH
`(LNwZ
9x@tpcBe
=h{=7nz
4789,W
|bFiK{]C
+rg-N}
N.=?M-}0ze[
L[zN.|:
>CmceO
42MN.#
Rirz|A@l]
OnkV2>2
MmNolw<n
DR"HyHgQ
2Xa8u2
f|[G1G}g
~O4a.Y
Vmfbl8+
qGaa:?3
A IHHxx
rk~XWOai
*CwpUKg
Sf|=:edy
St-:J__[
vmDig<%R
PUslGi#
'6.]F(
w g>4[
OG|=ezK
sx\;~J
g9^=uYI
l]tDOq
!G"2'P?
9:dtmO
f<iy)O_
oyWJ6m
Gx&@Qi
#pR^*9c
AkYnI9
%,gX*>^]
kd[veN
hFRB\\
ROH3ff
bo`GQA
`y]umz Nk
6(Kf%$]vT[
ETFP""*
]g=6PM
(>]wyB^^?}
tvMO=i
jVxxER
-k.(di
MSbo-\t
@Y~lRl
Q;:sW/n
Z/*]'2g
j:&$%i
#iJLiLv
xUKnS*
|s}owWxU
A]VEMC
jyKZ=&
Nl+k8N?
WJZMGEY
RB1X^K,
Uo=D0
2q0&/'
OP^; 01
ghrMc
NT(4OKF
4WKzx"
8)rKS|
n+lo8u
lz)UBag
f#Km-#
W~|=uk
IDAThi
`f2V(k>>
q?x!;}
NR!'#9
JI*8!f~M
o1G=)qq
ib1ErF
r|:BSDa
(61RJ*
?Zpr_w
`W_oPy
W[rl/M#^
wT< `>
EBz$KD
x4G+K&
,]|[4S
DZ%8vgM
|tY^qyE
CWnli]
oiVb}-
2hIRAnd_Ej
v[Ozf5
<L{7Sx
cTt@$U?qr
}}939$
Zz|8%j
]9GE#n
4xy X"
kEb+K:
$ U3J+B
??ydmxC
ikg?){
"T8Ah4
})_zHE;
eN>>E6!
Wc7uA"A*
N~8$5/
=+mFLkh
v[;5oz
^r\Pxs
!o ?0~
HnAiE0
?~<oIa
,yT!t^
1'jn;r
=g37"=j
I%BiEXw:
e %3'J
?]4vVi
m|x4*c
VR,!20ZA8
,r&k|_|c
$Pye#
y5'a/h(
Gof\^G
EVq+S>=*
dOT6^
wQT3J+
cj%/a:
]E9H^&
m+<?~V
BaVW%U.P
YEy*>O
p}8]_'
JE( GL
P a m{2lq
EVC);\E
@v`BEy
X%DGpN!r!%
<l/&jMR'
}ZbB"k
Y< `&$x
_E\:}]
%Y,Jq((
Z_yUU@Fe
n;ytuZ
30$_{2x
t$57Hq@
}_RZRQ
zoSGAN
Ix?#q6O
,>44yy
g)_8'{
*acSIO
9zT6g*
5ex?_ [`
=Q.,R)
so-\I4fU
zGn~0z
rAEfT,
ep33S*HY9
'G'[oW
X(#"xm.
X,:U:PTA
b`xN}:
=LGECS
7?)&H.
x%=U4y[
:B*i$4
-`,SP$a
#Wn8qJQ
9sffMQR
>^N]l(
G'R`qH#u
ssI: ^
.1F>cl2
L'9 p>s
%vL:Fq
G<-LKZ
.O9>>jA
o*7[W
$HSc$]I
`JKeYq9l
o"J?l[vnL.
A(Gs'X&
+V:c45
$qq$0$
wqLH!I
9k]JSY
u|Arxlff
5uu2g}
>~y?t'{
>na{:g
vNY}SK\T
ouzr]Eqo
*5mpP"
P|As>O
G('NVo
ThS!m~T
}X2f Zk
djjCyz
RjOXB)U
!ah)Hd
=+QZf]
[s}5mm
;Uq`3h\3
j~9%,1
ZUy//Zj^
O@^mX>
JMQG_m
SPUsYb
eX|"> 0
\6vU}Z
>V?]ic
JlM~c\{
q/|fkI
Bwd!`
yv, gA]
]q4key,.
Lo[~"
ngI jl
b81^d/"jQ
W^o fr
W3ED'PA)
@^]avs_Vfn
Mj:o8u2qx
A_bbhFo
L_>Ioul
][2u1'
zu#l p
o"/(=y
G4B5Uk
8Mb@v/EK
XAuoGn
7 nNOy
.J3,~q
|?ruRU
&]3t t
$$mzN40?
3}aXw@$\
w f5>u
|01!+@^
}q.O+q
0"[^j~
ZdN\i~T$
+St?<j;
@hAGEU
WhPVn0H
JeeoS?
sd 'g1
7V2&A3wQw*3c
$1y$mZbE
2No`&1y@
OY?1?g
7Skau@
{z.U{`
Gx.nNa
Q8+N2~
-ewu),3
,vr,O"
a79\re
`I"I9E
s&>37h
w/o;1F
]h[(MpJm
}4ct$o
X&=?C&~
q'q4'jg
}xlKYyk
faAUFw`
o$')P``'
}rKUMn
0#)Zh-H
(ihh((
OfFsrL
())i(tU
je;5S^=+
Mf)7|Hr
WmQzw{
59")SPw
j/):YQ
b3Z+*b U
+i[ZhtPR
']ljUV
W5=Uyz,pf`
tx7S-_
c{N0gt
Esc)1]
@Wm#=wGs`
ei>\7_L
}|jHl4
INE8{&
riX27;
Wi%4'N
;?R0d9
oF<rFw
/Zs620#
bt'x0-?
(paJ:{
<gAU+#
\#Ox~4
9#/cs@
6<Eb|/
enqNg"-s
j4W<$n
DzuKbW
_=TX?U
Dd &1
d],g|b
MafJOr
=6X2$f
FfV/jJ
<{O"=<
4p#Un?
j[O\I_
XT.gaz
i8O_%b~
[qhj2Sn
u"sv&!
6<?O7umv<
,s{uCiu,e9
0%ev+~gc
*<V4P}e"
]Ntk9b
s6+3[ij
?;M4?>
p%7d g
/meeDvF2-
>1ZVM%0q
qmr<'V
Dg-!39
yd ITt
sYx/SO
9~U+yk.
k#7g5>-z
ioPw=
>rEzlZ .
-hmO k
iqky{]
p #[62
gjTDIq@Q
F~|OX
NUZ4}7`BZ5
cf0lT_
I!5n4A=
tk<[o]'u
W\\XTw
:^vmHEm
9U{X_V
B{+r=%
[6l%GQ
Fpj!kNVQ
"Ce,yS
=%bh7K
E4!\(XG
&3tj1_3
1}B4ISz
P$aMwX4|+
a 0l[Ec
h~+dXs
)(sF'v
1$L=Nt
Eal"v&
6'3x '
`1u*g5*
@Nj8'5
B~@!Oj
4gEa*s
YUq4n2
Va3{!%
b?f8)rg
)*KPp<
rfc_I$
1?u$jkT
Cd<Y*V
1n;o\~
r6Wb<g.
"~u|GiRO
sMlTdIN}E
Gd=Y@\
hOCDa-
I<d q
Fgn, -
oPrj(i
3Tz^ m
f{gfG_
s^ilb@
o2E=|;
#8,R$X'
boCX[9
#6ss{,
!y`9[5
{/[XYc
(G&[s^m?O
$OoA/;
X}(Eki
'cX=n)o
k EF 04zH
MX)7wj#/b
t<"gs8
'*J3y>=
l>N|n"
3WUF2lF3
.RjFr|
?z 9e_
F#=o KS
KRg**-
cdv |\
|nOTA~]
$Zf1"0
(@)w";S
WXb3k9
WfjL9NS
RSDSrT
jXXj.pdb
SHA256
M}Z5x'
0>KGxn
dm[?cX
#"I,FD+$
$!HC`A0
&kOD0f
1Jq8q2F
P-~nmzL
oQE4&yF
gu|q!7
fT;MCZ
Q./0fl
j3u,fZ
d?\'YA5
uUP|Jv
..at s
G9P.B_
pu"JT>
@:?#2C
-\S!\u
_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>
SELECT SACH.TenSach, CHITIETHDBAN.GiaBan,CHITIETHDBAN.GiamGia,sum(SoLuong) as Soluong,sum(ThanhTien) as ThanhTien FROM HOADONBAN, CHITIETHDBAN, SACH WHERE CHITIETHDBAN.MaHoaDonBan = HOADONBAN.MaHoaDonBan and CHITIETHDBAN.MaSach = SACH.MaSach And NgayBan BETWEEN '
' AND '
' group by CHITIETHDBAN.GiaBan,SACH.TenSach,CHITIETHDBAN.GiamGia
Doanh thu
SELECT sum(ThanhTien) FROM HOADONBAN, CHITIETHDBAN, SACH WHERE CHITIETHDBAN.MaHoaDonBan = HOADONBAN.MaHoaDonBan and CHITIETHDBAN.MaSach = SACH.MaSach And NgayBan BETWEEN '
SELECT top 1 SACH.TenSach FROM HOADONBAN, CHITIETHDBAN, SACH WHERE CHITIETHDBAN.MaHoaDonBan = HOADONBAN.MaHoaDonBan and CHITIETHDBAN.MaSach = SACH.MaSach And NgayBan BETWEEN '
' group by CHITIETHDBAN.GiaBan,SACH.TenSach,CHITIETHDBAN.GiamGia order by sum(SoLuong) desc
SELECT top 1 HOADONBAN.MaHoaDonBan FROM HOADONBAN WHERE NgayBan BETWEEN '
' order by TongTien desc
txtTuNgay
Comic Sans MS
label2
txtDenNgay
label1
txtTongTien
label14
ng doanh thu
dgvBaoCao
UTM Cookies
btnTim
label3
lbSachChayNhat
label4
lbHoaDon
frmBaoCao
SELECT MaKhach, TenKhach FROM KHACH
MaKhach
TenKhach
SELECT MaNhanVien, TenNhanVien FROM NHANVIEN
MaNhanVien
TenNhanVien
SELECT MaSach, TenSach FROM SACH
MaSach
SELECT a.MaSach, b.TenSach, a.SoLuong, b.Gia, a.GiamGia,a.ThanhTien FROM CHITIETHDBAN AS a, SACH AS b WHERE a.MaHoaDonBan = N'
' AND a.MaSach=b.MaSach
SELECT NgayBan FROM HOADONBAN WHERE MaHoaDonBan = N'
SELECT TenNhanVien FROM NHANVIEN,HOADONBAN WHERE HOADONBAN.MaNhanVien = NHANVIEN.MaNhanVien AND MaHoaDonBan = N'
SELECT TenKhach FROM KHACH,HOADONBAN WHERE HOADONBAN.MaKhachHang = KHACH.MaKhach AND MaHoaDonBan = N'
SELECT TongTien FROM HOADONBAN WHERE MaHoaDonBan = N'
SELECT MaHoaDonBan FROM HOADONBAN WHERE MaHoaDonBan=N'
INSERT INTO HOADONBAN(MaHoaDonBan,MaNhanVien,MaKhachHang,NgayBan,TongTien) VALUES (N'
SELECT MaSach FROM CHITIETHDBAN WHERE MaSach=N'
' AND MaHoaDonBan = N'
SELECT SLKe FROM SACH WHERE MaSach = N'
INSERT INTO CHITIETHDBAN(MaHoaDonBan,MaSach,SoLuong,GiaBan,GiamGia,ThanhTien) VALUES(N'
UPDATE SACH SET SLKe =
WHERE MaSach= N'
UPDATE HOADONBAN SET TongTien =
WHERE MaHoaDonBan = N'
SELECT TenSach FROM SACH WHERE MaSach =N'
SELECT Gia FROM SACH WHERE MaSach =N'
SELECT GiamGia FROM SACH WHERE MaSach =N'
SELECT MaHoaDonBan FROM HOADONBAN
MaHoaDonBan
SELECT MaSach,SoLuong FROM CHITIETHDBAN WHERE MaHoaDonBan = N'
DELETE CHITIETHDBAN WHERE MaHoaDonBan=N'
DELETE HOADONBAN WHERE MaHoaDonBan=N'
SoLuong
ThanhTien
' AND MaSach = N'
groupBox1
Times New Roman
cboMaKhach
txtNgay
cboMaNV
label7
groupBox2
Chi ti
txtGiamGia
txtSoLuong
0000000
txtThanhTien
txtGia
cboMaSach
txtTenSach
label8
label9
label10
label11
label12
dgvHDBanHang
btnLuu
btnThem
btnHuy
label13
cboTim
frmHoaDonBan
SELECT * FROM KHACH
DiaChi
SoDienThoai
select top 1 MaKhach from KHACH order by MaKhach desc
INSERT INTO KHACH VALUES(N'
n ghi n
UPDATE KHACH SET TenKhach=N'
',DiaChi=N'
',SoDienThoai=N'
' WHERE MaKhach=N'
DELETE KHACH WHERE MaKhach=N'
txtDiaChi
txtTenKhach
txtMaKhach
label5
dgvKhach
pictureBox1
btnXoa
btnSua
txtDienThoai
frmKhach
Danh M
pnl_MenuLeft
pnl_ButtonMenu
pnlSub3
panel5
pnl_SubMenu
ptn_Sub2
panel4
panel2
panel3
pnl_Top
Snap ITC
btn_MiniSize
btn_Thoat
pnl_Change
btnXuatKho
btnNhapKho
btnKho
btnBaoCao
btn_TheLoai
btn_NXB
btnKhachHang
btn_Sach
btn_NhanVien
btnDangXuat
btn_DanhMuc
btn_Ban
frmMain
SELECT * FROM NHANVIEN
MatKhau
SELECT Anh FROM NHANVIEN WHERE MaNhanVien=N'
select top 1 MaNhanVien from NHANVIEN order by MaNhanVien desc
nh minh ho
UPDATE NHANVIEN SET TenNhanVien=N'
',Quyen=N'
',MatKhau=N'
',Anh=N'
' WHERE MaNhanVien=N'
Bitmap(*.bmp)|*.bmp|JPEG(*.jpg)|*.jpg|GIF(*.gif)|*.gif|All files(*.*)|*.*
INSERT INTO NHANVIEN(MaNhanVien,TenNhanVien,Quyen,MatKhau,DiaChi,SoDienThoai,Anh) VALUES(N'
DELETE NHANVIEN WHERE MaNhanVien=N'
txtMaNV
txtTenNV
cboQuyen
txtMatKhau
picAnh
btnOpen
txtAnh
frmNhanVien
SELECT MaNXB, TenNXB FROM NXB
TenNXB
SELECT a.MaSach, b.TenSach, a.SoLuong, a.GiaNhap,a.ThanhTien FROM CHITIETHDNHAP AS a, SACH AS b WHERE a.MaHoaDonNhap = N'
SELECT NgayNhap FROM HOADONNHAP WHERE MaHoaDonNHAP = N'
SELECT TenNhanVien FROM NHANVIEN,HOADONNHAP WHERE HOADONNHAP.MaNhanVien = NHANVIEN.MaNhanVien AND MaHoaDonNHAP = N'
SELECT TenNXB FROM NXB,HOADONNHAP WHERE HOADONNHAP.MaNXB = NXB.MaNXB AND MaHoaDonNHAP = N'
SELECT TongTien FROM HOADONNHAP WHERE MaHoaDonNHAP = N'
SELECT MaHoaDonNhap FROM HOADONNHAP WHERE MaHoaDonNhap=N'
INSERT INTO HOADONNHAP(MaHoaDonNHAP,MaNhanVien,NgayNhap,TongTien,MaNXB) VALUES (N'
SELECT MaSach FROM CHITIETHDNHAP WHERE MaSach=N'
' AND MaHoaDonNhap = N'
INSERT INTO CHITIETHDNHAP(MaHoaDonNhap,MaSach,SoLuong,GiaNhap,ThanhTien) VALUES(N'
SELECT SLKho FROM SACH WHERE MaSach = N'
UPDATE SACH SET SLKho =
UPDATE SACH SET GiaNhap =
SELECT TongTien FROM HOADONNHAP WHERE MaHoaDonNhap = N'
UPDATE HOADONNHAP SET TongTien =
WHERE MaHoaDonNhap = N'
SELECT MaHoaDonNhap FROM HOADONNHAP
MaHoaDonNhap
MaHoaDonNhao
SELECT MaSach,SoLuong FROM CHITIETHDNHAP WHERE MaHoaDonNhap = N'
DELETE CHITIETHDNHAP WHERE MaHoaDonNhap=N'
DELETE HOADONNHAP WHERE MaHoaDonNhap=N'
SELECT MaSach, TenSach FROM SACH where MaNXB =N'
cboNXB
dgvHDNhap
frmNhapSach
SELECT * FROM NXB
select top 1 MaNXB from NXB order by MaNXB desc
INSERT INTO NXB VALUES(N'
n NXB
UPDATE NXB SET TenNXB=N'
' WHERE MaNXB=N'
DELETE NXB WHERE MaNXB=N'
txtNXB
txtMaNXB
label6
dgvNXB
frmNXB
SELECT * from THELOAI
SELECT * from NXB
update SACH set TrangThai = N'H
ng' where SLKe = 0 and SLKho = 0
update SACH set TrangThai = N'' where SLKe != 0 or SLKho != 0
UPDATE SACH SET GiamGia = 10 WHERE MaSach in (Select CHITIETHDXUAT.MaSach from SACH , CHITIETHDXUAT, HOADONXUAT where CHITIETHDXUAT.MaXuat = HOADONXUAT.MaXuat and CHITIETHDXUAT.MaSach = SACH.MaSach and HOADONXUAT.KieuXuat = N'Xu
ch' and DATEDIFF(month, NgayXuat, GETDATE()) > 4)
MaTheLoai
TenTheLoai
SELECT * FROM SACH
Trong kho
TenSach
TacGia
GiaNhap
SELECT TenTheLoai FROM THELOAI WHERE MaTheLoai=N'
SELECT TenNXB FROM NXB WHERE MaNXB=N'
NamXuatBan
SELECT Anh FROM SACH WHERE MaSach=N'
select top 1 MaSach from SACH order by MaSach desc
nh minh ho
INSERT INTO SACH(MaSach,TenSach,Gia,TacGia, MaTheLoai,MaNXB,NamXuatBan,Anh,GiaNhap,SLKe,SLKho,TrangThai,GiamGia) VALUES(N'
,0,0,N'',0)
nh minh ho
cho S
UPDATE SACH SET TenSach=N'
',Gia=
,TacGia=N'
',MaTheLoai=N'
',MaNXB=N'
',NamXuatBan=
,Anh=N'
',GiaNhap=
WHERE MaSach=N'
DELETE SACH WHERE MaSach=N'
SELECT * from SACH WHERE 1=1
AND TenSach LIKE N'%
AND TacGia LIKE N'%
AND MaTheLoai LIKE N'%
AND MaNXB LIKE N'%
AND NamXuatBan =
n ghi tho
n ghi tho
txtMaSach
txtTacGia
dgvSach
btnDanhSach
cboTheLoai
txtNamXB
txtGiaNhap
frmSach
SELECT * FROM THELOAI
Ghi Ch
select top 1 MaTheLoai from THELOAI order by MaTheLoai desc
INSERT INTO THELOAI VALUES(N'
UPDATE THELOAI SET TenTheLoai=N'
',GhiChu=N'
' WHERE MaTheLoai=N'
DELETE THELOAI WHERE MaTheLoai=N'
GhiChu
txtGhiChu
txtTheLoai
txtMaTheLoai
dgvTheLoai
frmTheLoai
SELECT SUM(SLKho + SLKe) FROM SACH
SELECT SUM(SLKho) FROM SACH
SELECT SUM(SLKe) FROM SACH
Select MaSach,TenSach,SLKe,SLKho,GiamGia from SACH where SLKe <=3
SL kho
Select MaSach,TenSach,SLKe,SLKho,GiamGia from SACH where SLKho <=3
select MaSach,TenSach,SLKe,SLKho,GiamGia from SACH where GiamGia != 0
Select CHITIETHDXUAT.MaSach,TenSach,SLKe,SLKho,GiamGia from SACH , CHITIETHDXUAT, HOADONXUAT where CHITIETHDXUAT.MaXuat=HOADONXUAT.MaXuat and CHITIETHDXUAT.MaSach = SACH.MaSach and HOADONXUAT.KieuXuat = N'Xu
ch' and DATEDIFF(month, NgayXuat, GETDATE()) > 10
lbTongSach
panel1
Arial Narrow
lbTrenKe
lbTrongKho
Trong Kho
lbSachSapHet
lbSachKho
ch trong kho s
lbTraNXB
lbGiamGia
ang gi
frmThongTinKho
SELECT a.MaSach, b.TenSach, a.SoLuongXuat FROM CHITIETHDXUAT AS a, SACH AS b WHERE a.MaXuat = N'
SELECT a.MaSach, b.TenSach, a.SoLuongXuat,b.GiaNhap,a.ThanhTien FROM CHITIETHDXUAT AS a, SACH AS b WHERE a.MaXuat = N'
SELECT NgayXuat FROM HOADONXUAT WHERE MaXuat = N'
SELECT TenNhanVien FROM NHANVIEN,HOADONXUAT WHERE HOADONXUAT.MaNhanVien = NHANVIEN.MaNhanVien AND MaXuat = N'
SELECT TenNXB FROM NXB,HOADONXUAT WHERE HOADONXUAT.MaNXB = NXB.MaNXB AND MaXuat = N'
SELECT KieuXuat FROM HOADONXUAT WHERE MaXuat = N'
SELECT MaXuat FROM HOADONXUAT WHERE MaXuat=N'
INSERT INTO HOADONXUAT(MaXuat,MaNhanVien,KieuXuat,NgayXuat,TongTien,MaNXB) VALUES (N'
SELECT MaSach FROM CHITIETHDXUAT WHERE MaSach=N'
' AND MaXuat = N'
INSERT INTO CHITIETHDXUAT(MaXuat,MaSach,SoLuongXuat,ThanhTien,GiaXuat) VALUES(N'
UPDATE SACH SET SLKho = 0 WHERE MaSach= N'
UPDATE SACH SET SLKe = 0 WHERE MaSach= N'
SELECT TongTien FROM HOADONXUAT WHERE MaXuat = N'
UPDATE HOADONXUAT SET TongTien =
WHERE MaXuat = N'
SELECT SLKe FROM SACH WHERE MaSach =N'
SELECT SLKho FROM SACH WHERE MaSach =N'
SELECT GiaNhap FROM SACH WHERE MaSach =N'
SELECT MaXuat FROM HOADONXUAT
MaXuat
SELECT MaSach,SoLuongXuat FROM CHITIETHDXUAT WHERE MaXuat = N'
DELETE CHITIETHDXUAT WHERE MaXuat=N'
DELETE HOADONXUAT WHERE MaXuat=N'
SoLuongXuat
ng tin chung
cboKieuXuat
pnlSoLuong
txtSLKho
txtSLKe
dgvCTHDX
pnlTongTien
pnlNXB
frmXuatSach
ng tin!
SELECT * FROM NHANVIEN WHERE Quyen = '
' AND MatKhau = '
ng tin
pictureBox1.Image
txtUser
pictureBox2.Image
pictureBox2
txtPass
button1
button2
String1
m.Reflec
tion.Ass
$this.BackgroundImage
6A70534F
786675
QuanLyBanSach
QuanLyBanSach.Properties.Resources
Data Source=.;Initial Catalog=QuanLyNhaSach;Integrated Security=True
ng, kh
_{0}/{1}/{2}_
String1
$this.BackgroundImage
pictureBox1.Image
pictureBox2.Image
VS_VERSION_INFO
VarFileInfo
Translation
StringFileInfo
000004b0
Comments
CompanyName
FileDescription
QuanLyBanSach
FileVersion
1.0.0.0
InternalName
jXXj.exe
LegalCopyright
Copyright
2021
LegalTrademarks
OriginalFilename
jXXj.exe
ProductName
QuanLyBanSach
ProductVersion
1.0.0.0
Assembly Version
1.0.0.0