historyanalyse.cs

我自己开发的双色球预测软件

            {
                //查询历史中奖纪录
                strSQL = "SELECT TOP " + LatelyAnnalNum + " ID,BoxNo as 奖球盒号,AwardDateNo as 开奖期号," +
                    "AwardNo as 中奖号,Total as 球值总和,EvenNum as 奇数个数,OddNum as 偶数个数," +
                    "BigNum as 大数个数,SmallNum as 小数个数,FirstNum as 一区个数,SecondNum as 二区个数," +
                    "Thirdnum as 三区个数,JoinGroupNum as 连号组数,MantissagroupNum as 同尾组数," +
                    "SamenessNum as 同号数,FirstAward as 一等奖,SecondAward as 二等奖 FROM TwinColorBall " +
                    " ORDER BY AwardDateNo DESC";
                return dbObj.GetSQLDataSet(strSQL, "TwinColorBall");
            }
            catch (Exception ex)
            {
                throw new Exception("在查询中奖历史记录时出错，系统给出的信息是：" + ex.Message);
            }
        }
        #endregion

        #region//查询篮球中奖情况
        /// <summary>
        /// 根据参数查询指定数量的蓝球中奖号
        /// </summary>
        /// <param name="LatelyAnnalNum">返回记录条数</param>
        /// <returns>返回ArrayList{开奖期号，蓝球号}</returns>
        public ArrayList GetBlueData(int LatelyAnnalNum)
        {
            string strSQL;
            string[] temp;
            string col2;
            ArrayList resultArray;

            col2 = "";
            resultArray = new ArrayList();
            try
            {
                //查询历史中奖纪录
                strSQL = "SELECT TOP " + LatelyAnnalNum + " AwardDateNo," +
                    " AwardNo FROM TwinColorBall " +
                    " ORDER BY AwardDateNo DESC ";
                OleDbDataReader dr = dbObj.GetSQLDataReader(strSQL);
                
                while (dr.Read())
                {
                    temp = new string[2];
                    temp[0] = dr.GetValue(0).ToString();

                    col2 = dr.GetValue(1).ToString();
                    //取出蓝球号码（两位）
                    col2 = col2.Substring(col2.Trim().Length - 2).Replace('-', '0');
                    temp[1] = col2;
                    resultArray.Add(temp);
                }
                dr.Close();
                return resultArray;
            }
            catch (Exception ex)
            {
                throw new Exception("在查询蓝球中奖记录时出错，系统给出的信息是：" + ex.Message);
            } 
        }

        /// <summary>
        /// 根据参数查询所有的蓝球中奖号
        /// </summary>
        /// <returns>返回ArrayList{开奖期号，蓝球号}</returns>
        public ArrayList GetBlueData()
        {
            string strSQL;
            string[] temp;
            string col2;
            ArrayList resultArray;

            col2 = "";
            resultArray = new ArrayList();
            try
            {
                //查询历史中奖纪录
                strSQL = "SELECT AwardDateNo," +
                    " AwardNo FROM TwinColorBall " +
                    " ORDER BY AwardDateNo ASC";
                OleDbDataReader dr = dbObj.GetSQLDataReader(strSQL);

                while (dr.Read())
                {
                    temp = new string[2];
                    temp[0] = dr.GetValue(0).ToString();
                    //if(dr.GetValue(0).ToString()=="2007133")
                    //{
                    //    col2 = dr.GetValue(1).ToString();
                    //}
                    col2 = dr.GetValue(1).ToString();
                    //取出蓝球号码（两位）
                    col2 = col2.Substring(col2.Trim().Length - 2).Replace('-', '0');
                    temp[1] = col2;
                    resultArray.Add(temp);
                }
                dr.Close();
                return resultArray;
            }
            catch (Exception ex)
            {
                throw new Exception("在查询所有蓝球中奖记录时出错，系统给出的信息是：" + ex.Message);
            }
        }

        /// <summary>
        /// 统计篮球号码出现的频率
        /// </summary>
        /// <param name="blueBallNo">篮球号码</param>
        /// <param name="statNum">统计期数</param>
        /// <returns>成功返回ArrayList{中奖期号，间隔期数}</returns>
        public ArrayList GetBlueFrequency(string blueBallNo, int statNum)
        {
            ArrayList tempArray;
            ArrayList rsultArray;
            string[][] temp;
            int frequency;

            frequency =0;
            rsultArray = new ArrayList();
            try
            {
                tempArray = GetBlueData(statNum);
                temp = new string[tempArray.Count][];
                tempArray.CopyTo(temp);

                for (int i = 0; i < temp.Length; i++)
                {
                    if (temp[i][1].ToString() != blueBallNo)
                    {
                        //不是当前统计篮球则累加频率
                        frequency += 1;
                        if (i == temp.Length-1)
                        {
                            string[] middle ={ temp[i][0].ToString(), frequency.ToString() };

                            rsultArray.Add(middle);
                            frequency = 0;    
                        }
                    }
                    else
                    {
                        //是当前统计篮球则添加到结果数组中
                        string[] middle ={ temp[i][0].ToString(), frequency.ToString() };

                        rsultArray.Add(middle);
                        frequency = 0;
                    }
                }
            }
            catch (Exception)
            { 

            }
            return rsultArray;
        }

        #endregion

        #region//查询篮球中奖情况
        /// <summary>
        /// 根据参数查询指定数量的红球中奖号
        /// </summary>
        /// <param name="LatelyAnnalNum">返回记录条数</param>
        /// <returns>返回ArrayList{开奖期号，奖球号７位}</returns>
        public ArrayList GetRedData(int LatelyAnnalNum)
        {
            string strSQL;
            string[] temp;
            string col2;
            ArrayList resultArray;

            col2 = "";
            resultArray = new ArrayList();
            try
            {
                //查询历史中奖纪录
                strSQL = "SELECT TOP " + LatelyAnnalNum + " AwardDateNo," +
                    " AwardNo FROM TwinColorBall " +
                    " ORDER BY AwardDateNo DESC ";
                OleDbDataReader dr = dbObj.GetSQLDataReader(strSQL);

                while (dr.Read())
                {
                    temp = new string[2];
                    temp[0] = dr.GetValue(0).ToString();

                    col2 = dr.GetValue(1).ToString();
                    temp[1] = col2;
                    resultArray.Add(temp);
                }
                dr.Close();
                return resultArray;
            }
            catch (Exception ex)
            {
                throw new Exception("在查询奖球中奖记录时出错，系统给出的信息是：" + ex.Message);
            }
        }
        #endregion

        #region//统计最近LatelyAnnalNum期各数字出现的频率
        /// <summary>
        /// 统计最近LatelyAnnalNum期各数字出现的频率
        /// </summary>
        /// <param name="LatelyAnnalNum">统计最近的期数</param>
        /// <returns>成功返回各数字出现的频率数组</returns>
        public ArrayList GetFrequency(int LatelyAnnalNum)
        {
            string strSql;
            int col1;
            string col2;
            ArrayList tempArray;
            ArrayList resultArray;
            //int[][] result;
            int[] temp;

            col1 = 0;
            col2 = "";
            
            tempArray = new ArrayList();
            resultArray = new ArrayList();
            try
            { 
                strSql ="SELECT TOP " + LatelyAnnalNum +" AwardDateNo,AwardNo " +
                    " FROM TwinColorBall " +
                    " ORDER BY AwardDateNo DESC";
                OleDbDataReader dr = dbObj.GetSQLDataReader(strSql);

                while (dr.Read())
                {
                    temp = new int[7];
                    col1 = int.Parse(dr.GetValue(0).ToString());
                    col2 = dr.GetValue(1).ToString();
                    tempArray = ConversionArray(col2);
                    tempArray.Insert(0, col1);
                    tempArray.CopyTo(temp);
                    resultArray.Add(temp);
                }
                dr.Close();
                //result =new int [resultArray .Count ][];
                //resultArray .CopyTo(result);
                return resultArray;
            }
            catch (Exception ex)
            {
                throw new Exception("在统计出现频率时出错，系统给出的信息是：" + ex.Message);
            }
        }
        #endregion

        #region//把字符中奖号转换为整型ArrayList
        /// <summary>
        /// 把字符中奖号转换为整型ArrayList
        /// </summary>
        /// <param name="str">字符型中奖号（中间用‘－’分割）</param>
        /// <returns>成功返回整型的ArrayList</returns>
        public ArrayList ConversionArray(string str)
        {
            int SIX;
            string[] temp;
            ArrayList tempArray;

            SIX =6;
            temp=new string [6];
            tempArray = new ArrayList();

            temp = str.Split('-');
            for (int i = 0; i < SIX; i++)
            {
                tempArray.Add(int.Parse ( temp[i].ToString ()));
            }
            return tempArray;
        }
        #endregion

        #region//转换中奖数组为字符串
        /// <summary>
        /// 转换中奖数组为字符串
        /// </summary>
        /// <param name="awardNo">奖号数组</param>
        /// <returns>返回中奖号字符串</returns>
        public string ConversionAwardNo(int[] awardNo)
        {
            string strAwardNo;

            strAwardNo = awardNo[0].ToString();
            for (int i = 1; i < awardNo.Length; i++)
            {
                strAwardNo = strAwardNo + "-" + awardNo[i].ToString();
            }
            
            return strAwardNo;
        }
        #endregion

    }
}