LỜI MỞ ĐẦU
!"#$%&'()
*+,-%".&'/
01*23 #45651
7,+8+5!9/:&;<=>
++0?1 @9,
@9#&'"AB@BB5C1
5("&D &6*E:#F<5E:#F5E:#F2!
2G5E:#F2 H,I8&'9
E1*)(",
J58#&'@9: @"&'
91&7AK*@:#AL,-+9M'#)1
#4,J+5NOP#
+++@&6#)M' :
@9+,I*Q5+RE!/ @ABNOP
<A&6*ST:#F2 4U2Q@#)&'
,T<R2.#?:6<=)9VM-W65
&7G*X2:RE *,
R<:6Y
-+Y
1
MỤC LỤC
2
Chương 1: Giới thiệu
I. Ích Lợi Khi Sử Dụng XML
- NOP+8 7AZ#5[ABNOPAZ#\&'#&Z
ZQ@NOP2,
- NOP+8:1Z&'@"C@W]PE
8:E!&'
- NOPAK8^AZ#)ZQ@_2:AL8
:<#F54@H
I*Q2 E:#F2 4@#2 [#F!'@ZE:#F
AB)E:#F<@,]:@q[AB6/A.5
p 5pAXA#C2_4#4@52
&' /E:#FAB452 4
"Q@!6/@5 &6*,
l Q@ D
g T:#F<[
g T:#F +62
g T:#F 4@
g T:#F:&7AK@9
f9&6*@9D
g`9@:AL[AB5ALp5CQ#'&7AK
@9[AB,
g`9@:!@ALA)&7[AB5A<0
") @9"1 0,
g`9+@<E<&7E:#F8E:#F
+8E8 ,
f9AZ#D
g ]Z#@:&'!!0 5&'!E:#F,
g N[#F&' "_,
2. Mô hình hoạt động nghiệp vụ của quản lý bán đĩa phim
-6;2 2_49@<+ 2_4R8#C5
+,Q@QA +4 05@<K 4
&2C6 AL*!8Q#'"
,
&7A@:&7!!&2 2:B#BA
45A 4iZ*5'@ !"
*!4@,
4
V4@\&'[Q@),W\&'+
M+4@&'2 ,o<*!4@R
54@\&'Q@Q#&'\&'[M++,
J4@2iDOG455CAL5G:545
,
gT:#F+6D
OM !4\&'Q+6,J+2iD
G+65G45#&'5G<5#Q@,
gT:#F:D
6
OM<[AB@9\&'@:,J:
2iDJ:5QqEC,
7
III. Thiết kế cơ sở dữ liệu
1. Mô hình phân cấp chức năng
2. Mô hình luồng dữ liệu mức khung cảnh
3. Mô hình dữ liệu mức đỉnh
8
4. Xác định các thực thể
J8 J0
-< OG<
n
V/X
WC
J: J:
OQq
TC
V4@ OG4
J
nG:
o8hV
j
v2 o+0w
o+`B
h`owkoj
O:
c O-I -Ihxj -## `o OG<
a nJR -Ihcbb
j
-## J<
y ] -Ihcxb
j
-## V/X
{ W]J-I -Ihccj -## W]J<
l:4@D
WJJ J
0
o8hV
j
v2 o+0w
o+`B
h`owkoj
O:
c O] -Ihxj -## `o OG4
a J]R -Ihaxbj -## J
y nWN -Ihcxbj -## nGWN
{ ]]R -Ihcbbj -## VCAL
x W] z -## W4
| u ]R#hc}5b
j
IV. Thiết kế và cài đặt chương trình
1. Các module chính
#JNOPhui@&6"5[5+5*!58
CNOP5PA#]uAR•j
class TaoXML
{
string strCon = " Data Source =.; Initial Catalog = QLDiaPhim; Integrated
Security = True";
public void taoXML(string sql, string bang, string _FileXML)
{
SqlConnection con = new SqlConnection(strCon);
con.Open();
SqlDataAdapter ad = new SqlDataAdapter(sql, con);
DataTable dt = new DataTable(bang);
ad.Fill(dt);
dt.WriteXml(Application.StartupPath + _FileXML,
XmlWriteMode.WriteSchema);
}
public DataTable loadDataGridView(string _FileXML)
{
DataTable dt = new DataTable();
string FilePath = Application.StartupPath + _FileXML;
if (File.Exists(FilePath))
{
//tao luong xu ly file xml
FileStream fsReadXML = new FileStream(FilePath, FileMode.Open);
//doc file xml vao datatable
dt.ReadXml(fsReadXML);
fsReadXML.Close();
}
{
string fileName = Application.StartupPath + _FileXML;
XmlDocument doc = new XmlDocument();
doc.Load(fileName);
XmlNode nodeCu= doc.SelectSingleNode(xml);
doc.DocumentElement.RemoveChild(nodeCu);
doc.Save(fileName);
}
catch
{
MessageBox.Show("lỗi");
}
}
public void sua(string FileXML, string sql, string xml, string bang)
{
XmlTextReader reader = new XmlTextReader(FileXML);
XmlDocument doc = new XmlDocument();
doc.Load(reader);
reader.Close();
XmlNode oldValue;
XmlElement root = doc.DocumentElement;
oldValue = root.SelectSingleNode(sql);
XmlElement newValue = doc.CreateElement(bang);
newValue.InnerXml = xml;
root.ReplaceChild(newValue, oldValue);
doc.Save(FileXML);
}
public void TimKiem(string _FileXML, string xml, DataGridView dgv)
{
14
{
DataTable dt = new DataTable();
dt = loadDataGridView(_FileXML);
dt.DefaultView.RowFilter = truongKiemTra + " ='" + giaTriKiemTra + "'";
if (dt.DefaultView.Count > 0)
return true;
return false;
}
public string txtMa(string tienTo, string _FileXML, string tenCot)
{
string txtMa = "";
DataTable dt = new DataTable();
dt =loadDataGridView(_FileXML);
int dem = dt.Rows.Count;
if (dem == 0)
{
txtMa = tienTo + "001";//HD001
}
else
{
int duoi = int.Parse(dt.Rows[dem - 1]
[tenCot].ToString().Substring(2, 3)) + 1;
string cuoi = "00" + duoi;
txtMa = tienTo + "" + cuoi.Substring(cuoi.Length - 3, 3);
15
}
return txtMa;
}
public bool KTMa(string _FileXML, string cotMa, string ma)
{
sql += "N'" + table.Rows[dong][j].ToString().Trim() + "',";
}
sql += "N'" + table.Rows[dong][table.Columns.Count -
1].ToString().Trim() + "'";
sql += ")";
exCuteNonQuery(sql);
}
public void Sua_Database(string tenBang, string _FileXML, string tenCot,
string giaTri)
{
string duongDan = _FileXML;
DataTable table = loadDataGridView(duongDan);
int dong = -1;
for (int i = 0; i < table.Rows.Count; i++)
{
if (table.Rows[i][tenCot].ToString().Trim() == giaTri)
{ dong = i; }
}
if (dong > -1)
16
{
string sql = "update " + tenBang + " set ";
for (int j = 0; j < table.Columns.Count-1; j++)
{
sql += table.Columns[j].ToString() + " = N'" + table.Rows[dong]
[j].ToString().Trim() + "', ";
}
sql += table.Columns[table.Columns.Count - 1].ToString() + " = N'" +
table.Rows[dong][table.Columns.Count - 1].ToString().Trim() + "' ";
sql += "where " + tenCot + "= '" + giaTri +"'";
DataTable table= loadDataGridView(duongDan);
for (int i = 0; i < table.Rows.Count; i++)
{
string sql = "insert into " + tenBang + " values(";
for (int j = 0; j < table.Columns.Count - 1; j++)
{
sql += "N'" + table.Rows[i][j].ToString().Trim() + "',";
}
sql += "N'" + table.Rows[i][table.Columns.Count -
1].ToString().Trim() + "'";
sql += ")";
exCuteNonQuery(sql);
}
17
}
public void TimKiemXSLT(string data,string tenFileXML,string tenfileXSLT)
{
XslCompiledTransform xslt = new XslCompiledTransform();
xslt.Load(""+tenfileXSLT+".xslt");
XsltArgumentList argList = new XsltArgumentList();
argList.AddParam("Data", "", data);
XmlWriter writer = XmlWriter.Create(""+tenFileXML+".html");
xslt.Transform(new XPathDocument("" + tenFileXML + ".xml"), argList,
writer);
writer.Close();
System.Diagnostics.Process.Start("" + tenFileXML + ".html");
}
}
AR*!8/#€R223NWPJ
!+6
<xsl:value-of select="MaHD"/>
</td>
18
<td>
<xsl:value-of select="MaDia"/>
</td>
<td>
<xsl:value-of select="SLMua"/>
</td>
<td>
<xsl:value-of select="ThanhTien"/>
</td>
</tr>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
NWPJ]`
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl=" /> xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-
prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>
<xsl:param name="Data"></xsl:param>
<xsl:template match="/NewDataSet">
<html>
</td>
<td>
<xsl:value-of select="HangSX"/>
</td>
<td>
<xsl:value-of select="DaoDien"/>
</td>
<td>
<xsl:value-of select="SoDia"/>
</td>
<td>
<xsl:value-of select="Gia"/>
</td>
</tr>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
NWPJ]Wn]
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl=" /> xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>
<xsl:param name="Data"></xsl:param>
<xsl:template match="/NewDataSet">
<html>
<body>
</tr>
</xsl:if>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
NWPJ-IR
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl=" /> xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>
<xsl:param name="Data"></xsl:param>
<xsl:template match="/NewDataSet">
<html>
<body>
<br />
<br />
<center>
<h1>DANH SÁCH NHÂN VIÊN</h1>
</center>
<br />
<br />
<table border="1" width="100%">
<tr>
<th>STT</th>
<th>Mã nhân viên</th>
<th>Họ và tên</th>
<th>Địa chỉ</th>
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl=" /> xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>
<xsl:param name="Data"></xsl:param>
<xsl:template match="/NewDataSet">
<html>
<body>
<br />
<br />
<center>
<h1>DANH SÁCH TÀI KHOẢN</h1>
</center>
<br />
<br />
<table border="1" width="100%">
<tr>
<th>STT</th>
<th>Tên tài khoản</th>
<th>Mật khẩu</th>
<th>quyền</th>
</tr>
<xsl:for-each select="TaiKhoan">
<xsl:if test="TaiKhoan[.=$Data]">
<tr>
<td>
<xsl:value-of select="position()"/>
</td>
<td>
<xsl:value-of select="TaiKhoan"/>
Copyright: Tài liệu đại học ©