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