public static void InitHanhanCategory(string htmlContent) { HtmlDocument document = new HtmlDocument(); document.LoadHtml(htmlContent); var categoryPath = "//div[@class='filter-item clearfix']"; var categoryNodes = document.DocumentNode.SelectNodes(categoryPath); if (categoryNodes != null && categoryNodes.Count > 0) { foreach (var node in categoryNodes) { var rootNode = node.ChildNodes.FindFirst("label"); if (rootNode != null) { MangaCategory temp = new MangaCategory(); temp.SourceType = MangaCategorySourceType.憨憨漫画; temp.RootCategory = rootNode.InnerHtml; var categoryNode = node.ChildNodes.FindFirst("ul").ChildNodes; foreach (var subNode in categoryNode) { var aTag = subNode.ChildNodes.FindFirst("a"); if (aTag != null) { var url = aTag.Attributes["href"].Value.Trim(); var name = aTag.InnerHtml.Trim(); if (!string.IsNullOrEmpty(url) && !string.IsNullOrEmpty(name)) { url = url.Substring(url.IndexOf("/list/") + "/list/".Length); temp.Url = string.IsNullOrEmpty(url) ? "" : url.Substring(0, url.LastIndexOf("/")); temp.Category = name; MangaDatabaseHelper.InsertMangaCategory(temp); } } } } } } }
public static int InsertMangaCategory(MangaCategory entity) { var sql = "INSERT INTO MangaCategory (SourceType, RootCategory, Category, Url) VALUES (@SourceType, @RootCategory, @Category, @Url )"; return(Execute(ConnectionStrings.Manga, sql, entity)); }
public static int InsertMangaCategory(MangaCategory entity) { var sql = string.Format("INSERT INTO MangaCategory (SourceType, RootCategory, Category, Url) VALUES ({0}, '{1}', '{2}', '{3}' )", (int)entity.SourceType, entity.RootCategory, entity.Category, entity.Url); return(SqlHelper.ExecuteNonQuery(con, CommandType.Text, sql)); }