historyanalyse.cs

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

//**************************************************************************************************************
//* 本模块主要功能：
//*
//* 版权: zsjt
//* 作者: 赵现发
//* Email:[e-mail]
//* 时间: 2008年12月1日
//* (******* 请保留以上信息 *******)
//**************************************************************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using System.Collections ;
using System.Data;
using System.Data.OleDb;

namespace DataAccessLayer
{
    //历史中奖数据分析
    class HistoryAnalyse : BaseAccessObj
    {
        private static ArrayList historyDatas;    //历史中奖数据集合
        private HistoryData awardData;            //中奖数据

        #region//构造函数
        //构造函数
        public HistoryAnalyse(OLEDBAccessObj dbObj)
            : base(dbObj)
        {
            historyDatas = new ArrayList();
        }
        //构造函数
        //public HistoryAnalyse()
        //{
        //    historyDatas = new ArrayList();
        //}
        #endregion

        #region//属性函数
        public HistoryData AwardData
        {
            get { return awardData; }
            set { awardData = value; }
        }
        public static ArrayList HistoryDatas
        {
            get { return historyDatas; }
            //set { historyDatas = value; }
        }
        #endregion

        #region//功能区
        /// <summary>
        /// 添加中奖数据
        /// </summary>
        /// <param name="awardData">开奖数据对象</param>
        /// <returns>添加成功返回true,否则返回false</returns>
        public Boolean Add(HistoryData awardData)
        {
            string strSql;
            string strAwardNo;

            strAwardNo ="";
            for(int i=0;i<awardData .AwardNo .Length ;i++)
            {
                if(i==awardData .AwardNo .Length -1)
                {
                    strAwardNo +=awardData.AwardNo[i].ToString ();
                }
                else
                {
                    strAwardNo +=awardData.AwardNo[i].ToString ()+ "-";
                }
            }
            try
            {
                strSql = "INSERT INTO TwinColorBall(BoxNo,AwardDateNo,AwardNo,Total,EvenNum,OddNum," +
                    "BigNum,SmallNum,FirstNum,SecondNum,Thirdnum,JoinGroupNum,MantissagroupNum," +
                    "SamenessNum,FirstAward,SecondAward) VALUES(" +
                    awardData.BoxNo + "," +
                    awardData.DataNo + ",'" +
                    strAwardNo + "'," +
                    awardData.Sum + "," +
                    awardData.EvenNum + "," +
                    awardData.OddNum + "," +
                    awardData.BigNum + "," +
                    awardData.SmallNum + "," +
                    awardData.FirstNum + "," +
                    awardData.SecondNum + "," +
                    awardData.ThirdNum + "," +
                    awardData.JoinGroupNum + "," +
                    awardData.MantissaGroupNum + "," +
                    awardData.SamenessNum + "," +
                    awardData.Firstaward + "," +
                    awardData.Secondaward + ")";

                if (this.dbObj.ExecSQLCommand(strSql) > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception ex)
            {
                throw new Exception("在添加中奖数据时出错，系统给出的信息是：" + ex.Message);
            }
        }
        /// <summary>
        /// 修改数据
        /// </summary>
        /// <param name="awardData">历史中奖数据</param>
        /// <returns>成功返回true,否则返回false</returns>
        public Boolean Modify(HistoryData awardData)
        {
            string strAwardNo;
            string strSql;

            strAwardNo = ConversionAwardNo(awardData.AwardNo);
            strSql = "UPDATE TwinColorBall SET BoxNo=" + awardData .BoxNo + ",AwardDateNo=" +awardData .DataNo  +
                ",AwardNo='" + strAwardNo + "',Total=" +awardData .Sum + ",EvenNum=" + awardData .EvenNum  + 
                ",OddNum=" + awardData .OddNum  + ",BigNum=" + awardData .BigNum  + ",SmallNum=" + awardData .SmallNum  +
                ",FirstNum=" + awardData .FirstNum + ",SecondNum=" + awardData .SecondNum +
                ",Thirdnum=" + awardData .ThirdNum + ",JoinGroupNum=" + awardData .JoinGroupNum + 
                ",MantissagroupNum=" +awardData .MantissaGroupNum  + ",SamenessNum=" + awardData .SamenessNum  +
                ",FirstAward=" + awardData .Firstaward + ",SecondAward=" + awardData .Secondaward  + 
                " WHERE id=" + awardData.ID;
            if (this.dbObj.ExecSQLCommand(strSql) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 根据开奖期号删除中奖号码信息
        /// </summary>
        /// <param name="awardDateNo">开奖期号</param>
        /// <returns>删除成功返回true,否则返回false</returns>
        public Boolean Del(int awardDateNo)
        {
            string strSql;

            strSql = "DELETE * FROM TwinColorBall WHERE AwardDateNo=" + awardDateNo;
            if (this.dbObj.ExecSQLCommand(strSql) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 查询所有历史中奖数据
        /// </summary>
        /// <returns></returns>
        public OleDbDataReader GetHistoryData()
        {
            string strSql;

            strSql = "SELECT Id,BoxNo,AwardDateNo,AwardNo,Total,EvenNum,OddNum," +
                    "BigNum,SmallNum,FirstNum,SecondNum,Thirdnum,JoinGroupNum,MantissagroupNum," +
                    "SamenessNum,FirstAward,SecondAward FROM TwinColorBall ORDER BY AwardDateNo DESC";

            OleDbDataReader dr = dbObj.GetSQLDataReader(strSql);
            return dr;
        }
        /// <summary>
        /// 返回前N条记录历史中奖记录
        /// </summary>
        /// <param name="topNum">前N条记录</param>
        /// <returns>成功返回前N条历史中奖记录</returns>
        public OleDbDataReader GetHistoryData(int topNum)
        {
            string strSql;

            strSql = "SELECT TOP " + topNum.ToString() + " Id,BoxNo,AwardDateNo,AwardNo,Total,EvenNum,OddNum," +
                    "BigNum,SmallNum,FirstNum,SecondNum,Thirdnum,JoinGroupNum,MantissagroupNum," +
                    "SamenessNum,FirstAward,SecondAward FROM TwinColorBall ORDER BY AwardDateNo DESC";

            OleDbDataReader dr = dbObj.GetSQLDataReader(strSql);
            return dr;
        }
        /// <summary>
        /// 根据年号和记录数来返回记录
        /// </summary>
        /// <param name="Year">年号</param>
        /// <param name="topNum">前topNum条记录</param>
        /// <returns>成功则返回某年的前topNum条记录</returns>
        public OleDbDataReader GetHistoryData(int Year,int topNum)
        {
            string strSql;

            strSql = "SELECT TOP " + topNum.ToString() + " Id,BoxNo,AwardDateNo,AwardNo,Total,EvenNum,OddNum," +
                    "BigNum,SmallNum,FirstNum,SecondNum,Thirdnum,JoinGroupNum,MantissagroupNum," +
                    "SamenessNum,FirstAward,SecondAward FROM TwinColorBall " + 
                    "WHERE ((AwardBall/1000)=" + Year  +") " +
                    " ORDER BY AwardDateNo DESC";

            OleDbDataReader dr = dbObj.GetSQLDataReader(strSql);
            return dr;
        }
        /// <summary>
        /// 返回当前中奖
        /// </summary>
        /// <param name="awardDateNo">中奖期号</param>
        /// <returns>返回中奖结果</returns>
        public HistoryData GetAwardData(int awardDateNo)
        {
            string strSql;
            HistoryData awardData;
            string [] iTemp;

            iTemp = new string[7];
            awardData = new HistoryData();
            strSql = "SELECT Id,BoxNo,AwardDateNo,AwardNo,Total,EvenNum,OddNum," +
                    "BigNum,SmallNum,FirstNum,SecondNum,Thirdnum,JoinGroupNum,MantissagroupNum," +
                    "SamenessNum,FirstAward,SecondAward FROM TwinColorBall " + 
                    " WHERE AwardDateNo="+ awardDateNo + 
                    " ORDER BY AwardDateNo DESC";

            OleDbDataReader dr = dbObj.GetSQLDataReader(strSql);
            if (dr.Read())
            {
                awardData.ID = int.Parse(dr.GetValue(0).ToString());
                awardData .BoxNo  =int.Parse (dr.GetValue (1).ToString ());
                awardData .DataNo=int.Parse (dr.GetValue (2).ToString ());
                iTemp = dr.GetValue(3).ToString().Split('-');
                for (int i = 0; i < iTemp.Length; i++)
                {
                    awardData.AwardNo[i] = int.Parse(iTemp[i].ToString());
                }
                awardData.Sum = int.Parse(dr.GetValue(4).ToString());
                awardData.EvenNum = int.Parse(dr.GetValue(5).ToString());
                awardData.OddNum = int.Parse(dr.GetValue(6).ToString());
                awardData.BigNum = int.Parse(dr.GetValue(7).ToString());
                awardData.SmallNum = int.Parse(dr.GetValue(8).ToString());
                awardData.FirstNum = int.Parse(dr.GetValue(9).ToString());
                awardData.SecondNum = int.Parse(dr.GetValue(10).ToString());
                awardData.ThirdNum = int.Parse(dr.GetValue(11).ToString());
                awardData.JoinGroupNum = int.Parse(dr.GetValue(12).ToString());
                awardData.MantissaGroupNum = int.Parse(dr.GetValue(13).ToString());
                awardData.SamenessNum = int.Parse(dr.GetValue(14).ToString());
                awardData.Firstaward = int.Parse(dr.GetValue(15).ToString());
                awardData.Secondaward = int.Parse(dr.GetValue(16).ToString());
            }
            dr.Close();
            return awardData ;
        }
        /// <summary>
        /// 根据期号获得奖号
        /// </summary>
        /// <param name="awardDateNo">期号</param>
        /// <returns>成功返回奖号，失败返回空字符</returns>
        public string  GetAwardNo(int awardDateNo)
        {
            string strSql;
            string strTemp;

            strTemp = "";
            try
            {
                strSql = "SELECT AwardNo FROM TwinColorBall " +
                        " WHERE AwardDateNo=" + awardDateNo;
                        
                OleDbDataReader dr = dbObj.GetSQLDataReader(strSql);
                if (dr.Read() && dr.GetValue(0).ToString().Trim().Length != 0)
                {
                    strTemp = dr.GetValue(0).ToString();
                }
                dr.Close();

                return strTemp;
            }
            catch (Exception ex)
            {
                throw new Exception("不存在此记录，系统给出的信息是：" + ex.Message);
            }
        }
        #endregion

        #region//查询历史中奖纪录信息
        /// <summary>
        /// 查询历史中奖纪录信息
        /// </summary>
        /// <param name="LatelyAnnalNum">返回记录条数</param>
        /// <returns>成功返回最近latelyannalnum条记录</returns>
        public DataSet GetLatelyData(int LatelyAnnalNum)
        {
            string strSQL;
            try