Esempio n. 1
0
        /// <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();
        }
Esempio n. 2
0
        /// <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();
        }
Esempio n. 3
0
        /// <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();
        }