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