/// <summary> /// 开始更新网址数据 /// </summary> public void LoadWebsiteXML() { try { string path = Application.StartupPath + @"\XML\WebsiteList.xml"; if (!File.Exists(path)) return; XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(path); XmlNodeList tabNodes = xmlDoc.SelectNodes("WebsiteList/TabType"); if (tabNodes != null && tabNodes.Count > 0) { //清空网址表 dmData.ClearWebsiteData(); string type = string.Empty; Website website = null; foreach (XmlNode node in tabNodes) { type = node.Attributes[1].Value; foreach (XmlNode cNode in node.ChildNodes) { website = new Website(); website.Name = cNode.Attributes[0].Value; website.Type = type; website.Index = cNode.Attributes[1].Value; website.Url = cNode.Attributes[2].Value; website.IconPath = cNode.Attributes[3].Value; //插入数据库 dmData.InsertWebsiteData(website); } } } } catch(Exception ex) { log.WriteLog(ex.ToString()); } }
public int InsertWebsiteData(Website website) { int result = 0; try { string sql = "INSERT INTO t_website(WebOrder,Type,Name,URL)values(@WebOrder,@Type,@Name,@URL)"; SQLiteParameter[] parameters = new SQLiteParameter[]{ new SQLiteParameter("@WebOrder",website.Index), new SQLiteParameter("@Type",website.Type), new SQLiteParameter("@Name",website.Name), new SQLiteParameter("@URL",website.Url) }; SqlAction action = new SqlAction(); result = action.IntQuery(sql, parameters); } catch (Exception ex) { log.WriteLog(ex.ToString()); } return result; }