/// <summary> /// 得到大小分 /// </summary> /// <param name="Html"></param> /// <param name="Count"></param> /// <returns></returns> public string Get500Wanhilo_list(string Html, out int Count) { int IStart = 0; int ILen = 0; Count = 0; string MainWin = string.Empty; string Mainlose = string.Empty; string MatchDate = string.Empty; string StopSellTime = string.Empty; string MatchNumber = string.Empty; string Game = string.Empty; string MainTeam = string.Empty; string GuestTeam = string.Empty; string Big = string.Empty; string Small = string.Empty; string BigSmallscore = string.Empty; StringBuilder sb = new StringBuilder(); Other.GetStrScope(Html, "<DIV CLASS=\"dc_hs\"", "<DIV CLASS=\"dc_r\"", out IStart, out ILen); if (ILen == 0) { return ""; } Html = Html.Substring(IStart, ILen); string[] days = Html.Split(new string[] { "<DIV CLASS=\"dc_hs\"" }, StringSplitOptions.RemoveEmptyEntries); string[] rows = null; string[] tds = null; string date = string.Empty; Clutch clu = new Clutch(); for (int i = 0; i < days.Length; i++) { rows = days[i].Split(new string[] { "</TR>" }, StringSplitOptions.RemoveEmptyEntries); date = clu.GetDate(rows[0]); for (int j = 0; j < rows.Length; j++) { tds = rows[j].Split(new string[] { "</TD>" }, StringSplitOptions.RemoveEmptyEntries); if (tds.Length == 13) { MatchNumber = clu.getHtmlText(tds[0], 2); Game = clu.getHtmlText(tds[1], 2); MainTeam = clu.getHtmlText(tds[5], 4); GuestTeam = clu.getHtmlText(tds[3], 2); StopSellTime = GetDateTime(tds[2].Substring(tds[2].IndexOf("match_time"))) + ":00"; MatchDate = GetDateTime(tds[2]) + ":00"; Big = clu.getHtmlText(tds[9], 2) == "" ? "0" : clu.getHtmlText(tds[9], 2); Small = clu.getHtmlText(tds[10], 2) == "" ? "0" : clu.getHtmlText(tds[10], 2); BigSmallscore = clu.getHtmlText(tds[4], 2) == "" ? "0" : clu.getHtmlText(tds[4], 2); sb.Append(" exec P_BasketDXFgg '" + MainTeam + "','" + GuestTeam + "','" + MatchNumber + "','" + Game + "','" + MatchDate + "','" + StopSellTime + "'," + Big + "," + Small + "," + BigSmallscore + ", 0 ,'';"); sb.Append(" Update T_MatchBasket set bigsmallscore = '" + BigSmallscore + "' where ID = (select MatchID from T_PassRateBasket where MatchNumber = '" + MatchNumber + "')"); } } } return sb.ToString(); }
/// <summary> /// 得到过关让分胜负 /// </summary> /// <param name="Html"></param> /// <param name="Count"></param> /// <returns></returns> public string Get500Wanhdc_vp(string Html, out int Count) { int IStart = 0; int ILen = 0; Count = 0; StringBuilder sb = new StringBuilder(); sb.Append(" delete T_SingleRateBasket where StopSellTime<GETDATE(); update T_SingleRateBasket set IsHdc = 0 ; "); Other.GetStrScope(Html, "<DIV CLASS=\"dc_hs\"", "<DIV CLASS=\"dc_r\"", out IStart, out ILen); Html = Html.Substring(IStart, ILen); string LetMainLose = string.Empty; string LetMainWin = string.Empty; string letscore = string.Empty; string MatchDate = string.Empty; string StopSellTime = string.Empty; string MatchNumber = string.Empty; string Game = string.Empty; string MainTeam = string.Empty; string GuestTeam = string.Empty; string[] days = Html.Split(new string[] { "<DIV CLASS=\"dc_hs\"" }, StringSplitOptions.RemoveEmptyEntries); string[] rows = null; string[] tds = null; Clutch clu = new Clutch(); for (int i = 0; i < days.Length; i++) { rows = days[i].Split(new string[] { "</TR>" }, StringSplitOptions.RemoveEmptyEntries); for (int j = 0; j < rows.Length; j++) { tds = rows[j].Split(new string[] { "</TD>" }, StringSplitOptions.RemoveEmptyEntries); if (tds.Length == 13) { MatchNumber = clu.getHtmlText(tds[0], 2); Game = clu.getHtmlText(tds[1], 2); MainTeam = clu.getHtmlText(tds[5], 4); GuestTeam = clu.getHtmlText(tds[3], 2); StopSellTime = GetDateTime(tds[2].Substring(tds[2].IndexOf("match_time"))) + ":00"; MatchDate = GetDateTime(tds[2]) + ":00"; letscore = clu.getHtmlText(tds[4], 4); LetMainLose = clu.getHtmlText(tds[9], 2) == "" ? "0" : clu.getHtmlText(tds[9], 2); LetMainWin = clu.getHtmlText(tds[10], 2) == "" ? "0" : clu.getHtmlText(tds[10], 2); sb.Append(" exec P_BasketRfSfdg '" + MainTeam + "','" + GuestTeam + "','" + MatchNumber + "','" + Game + "','" + MatchDate + "','" + StopSellTime + "'," + LetMainLose + "," + LetMainWin + ",0, 0,'" + letscore + "',0, '';"); sb.Append("update T_SingleRateBasket set LetScore= '" + letscore + "' where MatchNumber= '" + MatchNumber + "' ; "); } } } return sb.ToString(); }
/// <summary> /// 得到过关胜分差 /// </summary> /// <param name="Html"></param> /// <param name="Count"></param> /// <returns></returns> public string Get500Wanwnm_list(string Html, out int Count) { int IStart = 0; int ILen = 0; Count = 0; StringBuilder sb = new StringBuilder(); sb.Append(" delete T_PassRateBasket where StopSellTime<GETDATE(); update T_PassRateBasket set IsWnm = 0 ; "); string DifferGuest1_5 = string.Empty; string DifferGuest6_10 = string.Empty; string DifferGuest11_15 = string.Empty; string DifferGuest16_20 = string.Empty; string DifferGuest21_25 = string.Empty; string DifferGuest26 = string.Empty; string DifferMain1_5 = string.Empty; string DifferMain6_10 = string.Empty; string DifferMain11_15 = string.Empty; string DifferMain16_20 = string.Empty; string DifferMain21_25 = string.Empty; string DifferMain26 = string.Empty; string MatchDate = string.Empty; string StopSellTime = string.Empty; string MatchNumber = string.Empty; string Game = string.Empty; string MainTeam = string.Empty; string GuestTeam = string.Empty; Other.GetStrScope(Html, "<DIV CLASS=\"dc_hs\"", "<DIV CLASS=\"dc_r\"", out IStart, out ILen); Html = Html.Substring(IStart, ILen); string[] days = Html.Split(new string[] { "<DIV CLASS=\"dc_hs\"" }, StringSplitOptions.RemoveEmptyEntries); string[] rows = null; string[] rows_1 = null; string[] tds = null; string[] tds_1 = null; Clutch clu = new Clutch(); for (int i = 0; i < days.Length; i++) { rows = Html.Split(new string[] { "ZID" }, StringSplitOptions.RemoveEmptyEntries); for (int j = 0; j < rows.Length; j++) { tds = rows[j].Split(new string[] { "</TD>" }, StringSplitOptions.RemoveEmptyEntries); if (tds.Length == 14) { rows_1 = rows[j + 1].Split(new string[] { "</TR>" }, StringSplitOptions.RemoveEmptyEntries); tds_1 = rows_1[0].Split(new string[] { "</TD>" }, StringSplitOptions.RemoveEmptyEntries); MatchNumber = clu.getHtmlText(tds[0], 2); Game = clu.getHtmlText(tds[1], 2); MainTeam = clu.getHtmlText(tds_1[0], 4); GuestTeam = clu.getHtmlText(tds[3], 4); StopSellTime = GetDateTime(tds[2].Substring(tds[2].IndexOf("match_time"))) + ":00"; MatchDate = GetDateTime(tds[2]) + ":00"; DifferGuest1_5 = clu.getHtmlText(tds[7], 2) == "" ? "0" : clu.getHtmlText(tds[7], 2); DifferMain1_5 = clu.getHtmlText(tds_1[2], 2) == "" ? "0" : clu.getHtmlText(tds_1[2], 2); DifferGuest6_10 = clu.getHtmlText(tds[8], 2) == "" ? "0" : clu.getHtmlText(tds[8], 2); DifferMain6_10 = clu.getHtmlText(tds_1[3], 2) == "" ? "0" : clu.getHtmlText(tds_1[3], 2); DifferGuest11_15 = clu.getHtmlText(tds[9], 2) == "" ? "0" : clu.getHtmlText(tds[9], 2); DifferMain11_15 = clu.getHtmlText(tds_1[4], 2) == "" ? "0" : clu.getHtmlText(tds_1[4], 2); DifferGuest16_20 = clu.getHtmlText(tds[10], 2) == "" ? "0" : clu.getHtmlText(tds[10], 2); DifferMain16_20 = clu.getHtmlText(tds_1[5], 2) == "" ? "0" : clu.getHtmlText(tds_1[5], 2); DifferGuest21_25 = clu.getHtmlText(tds[11], 2) == "" ? "0" : clu.getHtmlText(tds[11], 2); DifferMain21_25 = clu.getHtmlText(tds_1[6], 2) == "" ? "0" : clu.getHtmlText(tds_1[6], 2); DifferGuest26 = clu.getHtmlText(tds[12], 2) == "" ? "0" : clu.getHtmlText(tds[12], 2); DifferMain26 = clu.getHtmlText(tds_1[7], 2) == "" ? "0" : clu.getHtmlText(tds_1[7], 2); sb.Append(" exec P_BasketSfcgg '" + MainTeam + "','" + GuestTeam + "','" + MatchNumber + "','" + Game + "','" + MatchDate + "','" + StopSellTime + "'," + DifferGuest1_5 + "," + DifferGuest6_10 + "," + DifferGuest11_15 + "," + DifferGuest16_20 + "," + DifferGuest21_25 + "," + DifferGuest26 + ","); sb.Append(DifferMain1_5 + "," + DifferMain6_10 + "," + DifferMain11_15 + "," + DifferMain16_20 + "," + DifferMain21_25 + "," + DifferMain26 + ", 0, '';"); } } } return sb.ToString(); }