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(); } }