55128.cn_kjh.55128.cn_m.55128.cn/CP55128/CB.TrendChart/LotteryTrendChart/FCQLCTrend.cs

using System;
using System.Collections.Generic;
using System.Text;

using CB.Common;
using CB.Data;
using CB.Entity;
using CB.Interface;
using CB.Interface.Infrastructure;

namespace CB.TrendChart.LotteryTrendChart
{
    /// <summary>
    /// 福彩七乐彩走势图生成工具
    /// </summary>
    public class FCQLCTrend
    {

        public static int Cid = 5;//Cid用于设置样式值

        /// <summary>
        /// 生成走势图，生成当前term数据及以后数据
        /// by JNswins 2015-06-10
        /// </summary>
        /// <param name="chartId">走势图ID</param>
        /// <param name="chartType">走势图类型</param>
        /// <param name="term">需要生成走势图期数</param>
        /// <param name="LotterySearchField">彩种开奖数据额外查询条件</param>
        /// <returns></returns>
        public static Tuple<bool, string> CreateTrendChart(int chartId, TrendChartType chartType, long term, LotterySearchField fields = null)
        {
            //获取走势图项及配置数据
            var trendChartItem = TrendChartItemService.ToListByChartId(chartId, chartType);
            if (null == trendChartItem || 0 >= trendChartItem.Count)
                return new Tuple<bool, string>(false, string.Format("未找到【ChartId={0}】走势图的项配置数据", chartId));

            int count = trendChartItem.Count;
            IList<IChartItem<FCQLCInfo>> chartItem = new List<IChartItem<FCQLCInfo>>(count);
            IList<ChartCssConfigInfo> cssConfig = new List<ChartCssConfigInfo>(count);
            foreach (var item in trendChartItem)
            {
                //实例化项类型
                chartItem.Add(TrendChartUtils.GetTrendChartInterface<FCQLCInfo>(item.ClassName));
                //获取项CSS配置信息
                cssConfig.Add(ChartCssConfigService.Get(item.ChartCssId));
            }

            //各项初始化
            for (int i = 0; i < count; i++)
            {
                trendChartItem[i].Cid = Cid;
                chartItem[i].Init(cssConfig[i], trendChartItem[i]);
            }

            //大于等于term开奖数据
            IList<FCQLCInfo> ListToEnd = FCQLCService.GetListToEnd(term, fields);

            if (null == ListToEnd || 0 >= ListToEnd.Count)
                return new Tuple<bool, string>(false, "未找到有效开奖数据");

            int j = 0;
            TrendChartData entity = null;
            var ResultEntity = new TrendChartData
            {
                ChartId = chartId,
                Term = term,
                ChartType = chartType,
                LocalMiss = new string[count],
                LastMiss = new string[count],
                AllMaxMiss = new string[count],
                AllAvgMiss = new string[count],
                AllTimes = new string[count]
            };
            foreach (var currentData in ListToEnd)
            {
                //根据参数term期数获取近两期开奖信息TOP 2 [Term]<=term  ORDER BY [Term] DESC
                IList<FCQLCInfo> list = FCQLCService.ToListForTrend(currentData.Term, fields);

                FCQLCInfo info = null,lastinfo=null;
                info = list[0];
                if (2 == list.Count)
                {
                    //取当前期数的上一期的走势图信息及遗漏数据
                    lastinfo = list[1];
                    entity = ResultEntity;
                    if (0 == j)
                        entity = FCQLCTrendChartDataService.GetTrendChartDataByTerm(chartId, chartType, list[1].Term);
                }

                bool yes = true;
                var sp = new StringBuilder(20000);
                sp.Append("<tr>");
                for (int i = 0; i < count; i++)
                {
                    //初始化遗漏数据(根据上期结果集计算_entity)
                    chartItem[i].MissDataInit(entity, i);
                    //计算项值及遗漏计算
                    yes = yes && chartItem[i].SetItemValue(info,lastinfo);
                    if (yes)
                    {
                        //结果集赋值
                        ResultEntity.LocalMiss[i] = chartItem[i].GetMissData(MissDataType.LocalMiss);
                        ResultEntity.LastMiss[i] = chartItem[i].GetMissData(MissDataType.LastMiss);
                        ResultEntity.AllMaxMiss[i] = chartItem[i].GetMissData(MissDataType.AllMaxMiss);
                        ResultEntity.AllAvgMiss[i] = chartItem[i].GetMissData(MissDataType.AllAvgMiss);
                        ResultEntity.AllTimes[i] = chartItem[i].GetMissData(MissDataType.AllTimes);

                        sp.Append(chartItem[i].GetFomartString("<td {0}>{1}</td>"));
                    }
                }
                sp.Append("</tr>");
                if (null != entity)
                    ResultEntity.RecordCount = entity.RecordCount + 1;
                else
                    ResultEntity.RecordCount = 1;

                ResultEntity.Term = currentData.Term;
                ResultEntity.HtmlData = sp.ToString();
                if (!yes)
                { return new Tuple<bool, string>(false, string.Format("无效开奖数据：数据生成截止期数为【term={0}】", ResultEntity.Term)); }
                yes = yes && DatabaseProvider.GetDbProvider<IFCQLCTrendChartDataService>().Save(ResultEntity);
                if (!yes)
                { return new Tuple<bool, string>(false, string.Format("数据保存出错：数据保存截止期数为【term={0}】", ResultEntity.Term)); }
                j++;
            }
            return new Tuple<bool, string>(true, string.Format("正常生成完毕,截止期数为：Term={0}", ListToEnd[ListToEnd.Count - 1].Term));
        }

        /// <summary>
        /// 预览走势图，默认显示近30期数据 (实时计算生成)
        /// </summary>
        /// <param name="chartId"></param>
        /// <param name="chartType"></param>
        /// <param name="term"></param>
        /// <param name="fields"></param>
        /// <returns></returns>
        public static string PreViewTrendChart(int chartId, TrendChartType chartType, LotterySearchField fields = null)
        {
            var list = FCQLCService.GetListToEnd(0, fields);
            if (null == list || 0 >= list.Count)
                return "";

            //获取走势图项及配置数据
            var trendChartItem = TrendChartItemService.ToListByChartId(chartId, chartType);
            if (null == trendChartItem || 0 >= trendChartItem.Count)
                return "";
            int count = trendChartItem.Count;
            IList<IChartItem<FCQLCInfo>> chartItem = new List<IChartItem<FCQLCInfo>>(count);
            IList<ChartCssConfigInfo> cssConfig = new List<ChartCssConfigInfo>(count);
            foreach (var item in trendChartItem)
            {
                //实例化项类型
                chartItem.Add(TrendChartUtils.GetTrendChartInterface<FCQLCInfo>(item.ClassName));
                //获取项CSS配置信息
                cssConfig.Add(ChartCssConfigService.Get(item.ChartCssId));
            }

            //项初始化
            for (int i = 0; i < count; i++)
            {
                trendChartItem[i].Cid = Cid;
                chartItem[i].Init(cssConfig[i], trendChartItem[i]);
            }

            var sp = new StringBuilder(20000);
            int record = list.Count;
            int topSize = null == fields ? 30 : fields.TopSize;
            if (30 > topSize)
                topSize = 30;
            for (int i = 0; i < record; i++)
            {
                for (int j = count - 1; j >= 0; j--)
                {
                    chartItem[j].SetItemValue(list[i]);
                }
                if (i >= record - topSize)
                {
                    sp.Append("<tr>");
                    for (int j = 0; j < count; j++)
                    {
                        sp.Append(chartItem[j].GetFomartString("<td {0}>{1}</td>"));
                    }
                    sp.Append("</tr>");
                }
            }

            return sp.ToString();
        }

        #region 生成走势图 已注释 by JNswins 2015-06-11
        ///// <summary>
        ///// 生成走势图
        ///// </summary>
        ///// <param name="chartId">走势图ID</param>
        ///// <param name="chartType">走势图类型</param>
        ///// <param name="term">需要生成走势图期数</param>
        ///// <param name="MultiTerm">true：生成term期数及以后期数的走势图及遗漏数据;false：仅生成当前期走势图及遗漏数据</param>
        ///// <param name="IsZS">true：生成组三数据;false：全部数据</param>
        ///// <returns></returns>
        //public static bool CreateTrendChart(int chartId, TrendChartType chartType, long term, int week, bool MultiTerm = false, bool IsZS = false)
        //{
        //    if (MultiTerm)
        //        return CreateCurrentToEndTrendChart(chartId, chartType, term);
        //    return CreateCurrentTrendChart(chartId, chartType, term);
        //}

        ///// <summary>
        ///// 生成当前期走势图
        ///// </summary>
        ///// <param name="chartId"></param>
        ///// <param name="chartType"></param>
        ///// <param name="term"></param>
        ///// <returns></returns>
        //private static bool CreateCurrentTrendChart(int chartId, TrendChartType chartType, long term)
        //{
        //    //获取走势图项及配置数据
        //    var trendChartItem = TrendChartItemService.ToListByChartId(chartId, chartType);
        //    if (null == trendChartItem || 0 >= trendChartItem.Count)
        //        return false;
        //    int count = trendChartItem.Count;
        //    IList<IChartItem<FCQLCInfo>> chartItem = new List<IChartItem<FCQLCInfo>>(count);
        //    IList<ChartCssConfigInfo> cssConfig = new List<ChartCssConfigInfo>(count);
        //    foreach (var item in trendChartItem)
        //    {
        //        //实例化项类型
        //        chartItem.Add(TrendChartUtils.GetTrendChartInterface<FCQLCInfo>(item.ClassName));
        //        //获取项CSS配置信息
        //        cssConfig.Add(ChartCssConfigService.Get(item.ChartCssId));
        //    }
        //    //根据参数term期数获取近两期开奖信息TOP 2 [Term]<=term  ORDER BY [Term] DESC
        //    var list = FCQLCService.ToListForTrend(term);
        //    FCQLCInfo info = null;
        //    TrendChartData entity = null;
        //    if (null == list || 0 >= list.Count)
        //        return false;
        //    info = list[0];
        //    if (2 == list.Count)
        //    {
        //        //取当前期数的上一期的走势图信息及遗漏数据
        //        entity = FCQLCTrendChartDataService.GetTrendChartDataByTerm(chartId, chartType, list[1].Term);
        //    }

        //    var ResultEntity = new TrendChartData
        //    {
        //        ChartId = chartId,
        //        Term = term,
        //        ChartType = chartType,
        //        LocalMiss = new string[count],
        //        LastMiss = new string[count],
        //        AllMaxMiss = new string[count],
        //        AllAvgMiss = new string[count],
        //        AllTimes = new string[count]
        //    };

        //    var sp = new StringBuilder(20000);
        //    sp.Append("<tr>");
        //    for (int i = 0; i < count; i++)
        //    {
        //        //项初始化
        //        chartItem[i].Init(cssConfig[i], trendChartItem[i]);
        //        //初始化遗漏数据(根据上期结果集计算_entity)
        //        chartItem[i].MissDataInit(entity, i);
        //        //计算项值及遗漏计算
        //        chartItem[i].SetItemValue(info);
        //        //结果集赋值
        //        ResultEntity.LocalMiss[i] = chartItem[i].GetMissData(MissDataType.LocalMiss);
        //        ResultEntity.LastMiss[i] = chartItem[i].GetMissData(MissDataType.LastMiss);
        //        ResultEntity.AllMaxMiss[i] = chartItem[i].GetMissData(MissDataType.AllMaxMiss);
        //        ResultEntity.AllAvgMiss[i] = chartItem[i].GetMissData(MissDataType.AllAvgMiss);
        //        ResultEntity.AllTimes[i] = chartItem[i].GetMissData(MissDataType.AllTimes);

        //        sp.Append(chartItem[i].GetFomartString("<td {0}>{1}</td>"));
        //    }
        //    sp.Append("</tr>");
        //    if (entity != null)
        //        ResultEntity.RecordCount = entity.RecordCount + 1;
        //    else
        //        ResultEntity.RecordCount = 1;
        //    ResultEntity.HtmlData = sp.ToString();
        //    return DatabaseProvider.GetDbProvider<IFCQLCTrendChartDataService>().Save(ResultEntity);
        //}

        ///// <summary>
        ///// 生成当期走势图以及后面走势图
        ///// </summary>
        ///// <param name="chartId"></param>
        ///// <param name="chartType"></param>
        ///// <param name="term"></param>
        ///// <returns></returns>
        //private static bool CreateCurrentToEndTrendChart(int chartId, TrendChartType chartType, long term)
        //{
        //    //当期以及以后数据 
        //    var ListToEnd = FCQLCService.GetListToEnd(term);
        //    if (null == ListToEnd || ListToEnd.Count <= 0)
        //        return false;


        //    //获取走势图项及配置数据
        //    var trendChartItem = TrendChartItemService.ToListByChartId(chartId, chartType);
        //    if (null == trendChartItem || 0 >= trendChartItem.Count)
        //        return false;
        //    int count = trendChartItem.Count;
        //    IList<IChartItem<FCQLCInfo>> chartItem = new List<IChartItem<FCQLCInfo>>(count);
        //    IList<ChartCssConfigInfo> cssConfig = new List<ChartCssConfigInfo>(count);
        //    foreach (var item in trendChartItem)
        //    {
        //        //实例化项类型
        //        chartItem.Add(TrendChartUtils.GetTrendChartInterface<FCQLCInfo>(item.ClassName));
        //        //获取项CSS配置信息
        //        cssConfig.Add(ChartCssConfigService.Get(item.ChartCssId));
        //    }

        //    //项初始化
        //    for (int i = 0; i < count; i++)
        //    {
        //        chartItem[i].Init(cssConfig[i], trendChartItem[i]);
        //    }

        //    foreach (var currentData in ListToEnd)
        //    {
        //        //根据参数term期数获取近两期开奖信息TOP 2 [Term]<=term  ORDER BY [Term] DESC
        //        var list = FCQLCService.ToListForTrend(currentData.Term);
        //        FCQLCInfo info = null;
        //        TrendChartData entity = null;
        //        if (null == list || 0 >= list.Count)
        //            continue;
        //        info = list[0];
        //        if (2 == list.Count)
        //        {
        //            //取当前期数的上一期的走势图信息及遗漏数据
        //            entity = FCQLCTrendChartDataService.GetTrendChartDataByTerm(chartId, chartType, list[1].Term);
        //        }

        //        var ResultEntity = new TrendChartData
        //        {
        //            ChartId = chartId,
        //            Term = currentData.Term,
        //            ChartType = chartType,
        //            LocalMiss = new string[count],
        //            LastMiss = new string[count],
        //            AllMaxMiss = new string[count],
        //            AllAvgMiss = new string[count],
        //            AllTimes = new string[count]
        //        };

        //        var sp = new StringBuilder(20000);
        //        sp.Append("<tr>");
        //        for (int i = 0; i < count; i++)
        //        {
        //            //初始化遗漏数据(根据上期结果集计算_entity)
        //            chartItem[i].MissDataInit(entity, i);
        //            //计算项值及遗漏计算
        //            chartItem[i].SetItemValue(info);
        //            //结果集赋值
        //            ResultEntity.LocalMiss[i] = chartItem[i].GetMissData(MissDataType.LocalMiss);
        //            ResultEntity.LastMiss[i] = chartItem[i].GetMissData(MissDataType.LastMiss);
        //            ResultEntity.AllMaxMiss[i] = chartItem[i].GetMissData(MissDataType.AllMaxMiss);
        //            ResultEntity.AllAvgMiss[i] = chartItem[i].GetMissData(MissDataType.AllAvgMiss);
        //            ResultEntity.AllTimes[i] = chartItem[i].GetMissData(MissDataType.AllTimes);

        //            sp.Append(chartItem[i].GetFomartString("<td {0}>{1}</td>"));
        //        }
        //        sp.Append("</tr>");
        //        if (entity != null)
        //            ResultEntity.RecordCount = entity.RecordCount + 1;
        //        else
        //            ResultEntity.RecordCount = 1;
        //        ResultEntity.HtmlData = sp.ToString();
        //        DatabaseProvider.GetDbProvider<IFCQLCTrendChartDataService>().Save(ResultEntity);
        //    }
        //    return true;
        //}

        #endregion

        #region 生成预览走势图（直接生成）已注释 by JNswins 2015-06-11

        ///// <summary>
        ///// 预览当期走势图以及后面走势图
        ///// </summary>
        ///// <param name="chartId"></param>
        ///// <param name="chartType"></param>
        ///// <param name="term"></param>
        ///// <returns></returns>
        //public static string PreViewCurrentToEndTrendChart(int chartId, TrendChartType chartType)
        //{
        //    StringBuilder sp = new StringBuilder(20000);
        //    //当期以及以后数据 
        //    var ListToEnd = FCQLCService.GetListToEnd(0, null);
        //    if (null == ListToEnd || ListToEnd.Count <= 0)
        //        return "";

        //    //获取走势图项及配置数据
        //    var trendChartItem = TrendChartItemService.ToListByChartId(chartId, chartType);
        //    if (null == trendChartItem || 0 >= trendChartItem.Count)
        //        return "";
        //    int count = trendChartItem.Count;
        //    IList<IChartItem<FCQLCInfo>> chartItem = new List<IChartItem<FCQLCInfo>>(count);
        //    IList<ChartCssConfigInfo> cssConfig = new List<ChartCssConfigInfo>(count);
        //    foreach (var item in trendChartItem)
        //    {
        //        //实例化项类型
        //        chartItem.Add(TrendChartUtils.GetTrendChartInterface<FCQLCInfo>(item.ClassName));
        //        //获取项CSS配置信息
        //        cssConfig.Add(ChartCssConfigService.Get(item.ChartCssId));
        //    }

        //    //项初始化
        //    for (int i = 0; i < count; i++)
        //    {
        //        chartItem[i].Init(cssConfig[i], trendChartItem[i]);
        //    }

        //    for (int j = 0; j < ListToEnd.Count; j++)
        //    {
        //        if (j < ListToEnd.Count - 31)
        //        {
        //            for (int i = 0; i < count; i++)
        //            {
        //                //计算项值及遗漏计算
        //                chartItem[i].SetItemValue(ListToEnd[j]);
        //            }
        //        }
        //        else
        //        {
        //            sp.Append("<tr>");
        //            for (int i = 0; i < count; i++)
        //            {
        //                //计算项值及遗漏计算
        //                chartItem[i].SetItemValue(ListToEnd[j]);
        //                sp.Append(chartItem[i].GetFomartString("<td {0}>{1}</td>"));
        //            }
        //            sp.Append("</tr>");
        //        }
        //    }
        //    return sp.ToString();
        //}

        #endregion
    }
}