private void ModifyNode(System.Xml.XmlNode node, int id, Vector v)
{
string sql = null;
if (node is XmlElement)
{
XmlElement ele = node as XmlElement;
sql = string.Format("UPDATE {0} SET EndCodeX='{1}', EndCodeY='{2}' WHERE id = {3}", tableName, 1, codeId, id);
SqlCommand cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
}
}
private void InsertNode(System.Xml.XmlNode node, int id, Vector v)
{
string sql = null;
if(node is XmlElement)
{
XmlElement ele = node as XmlElement;
string content = "";
if (ele.HasChildNodes && ele.FirstChild is XmlText) {
content = ele.InnerText;
}
sql = string.Format("INSERT INTO {0} VALUES(@id, @layer, @startX, @startY, @endX, @endY, @name, @type, @content)", tableName);
SqlCommand cmd = new SqlCommand(sql, con);
SqlParameter[] para = new SqlParameter[]{
new SqlParameter("@id", id),
new SqlParameter("@layer", layer),
new SqlParameter("@startX", 1),
new SqlParameter("@startY", codeId),
new SqlParameter("@endX", 1),
new SqlParameter("@endY", 1),
new SqlParameter("@name", ele.Name),
new SqlParameter("@type", 1),
new SqlParameter("@content", content),
};
cmd.Parameters.AddRange(para);
cmd.ExecuteNonQuery();
}
}
