/// <summary> /// 获取字幕组信息 /// </summary> /// <returns></returns> public async Task <DTeam[]> GetTeamAsync() { List <DTeam> listTeams = new List <DTeam>(); string url = "/topics/advanced-search"; string html = await Common.DownloadHtmlAsync(_httpClient, url); HtmlDocument doc = new HtmlDocument(); doc.LoadHtml(html); HtmlNodeCollection teamNodes = doc.DocumentNode.SelectNodes("//select[@name='team_id']/option"); if (teamNodes == null || teamNodes.Count <= 0) { return(null); } foreach (var team in teamNodes) { DTeam dTeam = new DTeam() { Id = Convert.ToInt64(team.Attributes["value"].Value), Name = team.InnerText }; listTeams.Add(dTeam); } listTeams.RemoveAt(0); return(listTeams.ToArray()); }
private DTeam InstantiateTeam(SqlCmdExt cmd) { var team = new DTeam { Id = cmd.GetInt("Id"), Name = cmd.GetString("Name"), League = GetLeague(cmd.GetInt("LeagueId")) }; return(team); }
public bool TeamExists(DTeam team) { try { var existingTeam = db.GetTeam(team.Name, team.League.Id); } catch (Exception e) { return(false); } return(true); }
/* ******************************************************* * */ public void AddTeam(DTeam team) { using (var cmd = new SqlCmdExt(_connectionString)) { cmd.CreateCmd(@" INSERT INTO Team (Name, LeagueId) VALUES (@Name, @LeagueId) "); cmd.SetInArg("@Name", team.Name); cmd.SetInArg("@LeagueId", team.League.Id); cmd.ExecuteInsertUpdateDelete(); } }
private DPost[] ToModels(string html) { List <DPost> models = new List <DPost>(); HtmlDocument doc = new HtmlDocument(); doc.LoadHtml(html); HtmlNodeCollection trNodes = doc.DocumentNode.SelectNodes("//tbody/tr"); if (trNodes == null) { return(null); } foreach (var tr in trNodes) { HtmlNodeCollection tdNodes = tr.SelectNodes(".//td"); //时间 string time = tdNodes[0].FirstChild.InnerText.Trim(); //string datetime = tdNodes[0].SelectSingleNode("./span").InnerText.Trim(); //分类 string category = tdNodes[1].SelectSingleNode("./a//font").InnerText.Trim(); string categoryHref = tdNodes[1].SelectSingleNode("./a").Attributes["href"].Value; string categoryId = categoryHref.Substring(categoryHref.LastIndexOf("/")).Replace("/", ""); //团队 HtmlNode teamNode = tdNodes[2].SelectSingleNode("./span/a"); string team = ""; string teamHref = ""; string teamId = ""; if (teamNode != null) { team = teamNode.InnerText.Trim(); teamHref = teamNode.Attributes["href"].Value.Trim(); teamId = teamHref.Substring(teamHref.LastIndexOf("/")).Replace("/", ""); } //番剧相关 string title = tdNodes[2].SelectSingleNode("./a").InnerText.Trim(); string htmlId = tdNodes[2].SelectSingleNode("./a").Attributes["href"].Value.Replace(".html", ""); htmlId = htmlId.Substring(htmlId.LastIndexOf("/") + 1); string downloadArrow = tdNodes[3].SelectSingleNode("./a").Attributes["href"].Value; string size = tdNodes[4].InnerText; string userName = tdNodes[8].InnerText; string userId = tdNodes[8].SelectSingleNode("./a").Attributes["href"].Value.Replace("/topics/list/user_id/", ""); DCategory dCategory = new DCategory() { Id = long.Parse(categoryId), Name = category }; DTeam dTeam = new DTeam() { Id = string.IsNullOrEmpty(teamId) ? null : (long?)long.Parse(teamId), Name = team }; models.Add(new DPost { Id = Guid.NewGuid().ToString(), UserId = Convert.ToInt64(userId), UserName = userName, Category = dCategory, DateTime = time, DownloadArrow = downloadArrow, FileSize = size, Team = dTeam, Title = title, HtmlId = htmlId }); } return(models.ToArray()); }
public void AddTeam(DTeam team) { }
public bool TeamExists(DTeam team) { return(false); }
public void AddTeam(DTeam team) { db.AddTeam(team); }