lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/DecisionAssistant/AnalyzedOrderSelectionFilmFormMain.cs

using LYFZ.Model;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Windows.Forms.DataVisualization.Charting;

namespace LYFZ.Software.MainBusiness.DecisionAssistant
{
    public partial class AnalyzedOrderSelectionFilmFormMain : LYFZ.Software.UI.DecisionAssistant.AnalyzedOrderSelectionFilmFormMain
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        List<ModelImagePostionAction> actionList = new List<ModelImagePostionAction>();
        public AnalyzedOrderSelectionFilmFormMain()
        {
            this.Load += AnalyzedOrderSelectionFilmFormMain_Load;
            this.Shown += AnalyzedOrderSelectionFilmFormMain_Shown;
            this.btnQuery.Click += btnQuery_Click;
            this.btnSaveAs.Click += btnSaveAs_Click;
            this.btnColseed.Click += btnColseed_Click;
            this.chkComparedStartUp.Click += chkComparedStartUp_Click;
            this.chkOrderType.Click += chkOrderType_Click;
            this.chkOrderClass.Click += chkOrderClass_Click;
            this.dtDataTimeStart.Leave += dtDataTimeStart_Leave;
            this.dtDataTimeStartCompared.Leave += dtDataTimeStartCompared_Leave;
            this.cmbtreevDisplayItem.ComboBoxTree_NodeMouseClick += cmbtreevDisplayItem_ComboBoxTree_NodeMouseClick;
            this.cmbtreevDisplayMethod.ComboBoxTree_NodeMouseClick += cmbtreevDisplayMethod_ComboBoxTree_NodeMouseClick;
            this.Resize += AnalyzedOrderSelectionFilmFormMain_Resize;
            this.PictImage.MouseDoubleClick += PictImage_DoubleClick;
        }

        void PictImage_DoubleClick(object sender, MouseEventArgs e)
        {
            ModelImagePostionAction action = actionList.Find(p => p.MouseX <= e.Location.X && e.Location.X <= (p.MouseX + p.MouseWidth)
                                                             &&
                                                             p.MouseY <= e.Location.Y && e.Location.Y <= (p.MouseY + p.MouseHeight));
            if (action != null)
            {
                LYFZ.Software.MainBusiness.DecisionAssistant.SetSmallForm.AnalyzedOrderDetailSmallForm detailForm = new SetSmallForm.AnalyzedOrderDetailSmallForm();
                detailForm.BindDataGridView(action);
                detailForm.ShowDialog();
                //MessageBox.Show("内容！");
            }
        }
        bool IsFristLoad = true;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AnalyzedOrderSelectionFilmFormMain_Load(object sender, EventArgs e)
        {
            this.panelQueryCompared.Visible = false;
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindGroupStoreName(this.cmbtreevStoreName, StrGroupKeyCode: "stA10", StrKeyCode: "stA21", IsShowAllText: false);
            this.dtDataTimeStart.DateValue = SDateTime.Now.ToString("yyyy-MM") + "-01";
            this.dtDataTimeEnd.DateValue = Convert.ToDateTime(this.dtDataTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbtreevDisplayItem, "0:选片次数,1:加挑次数,2:加挑总额,3:加挑均值", IsSplit: true);
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.BindComboxTreeView(this.cmbtreevDisplayMethod, "Pie:饼形图,Column:柱状图", IsSplit: true);
            this.cmbtreevDisplayItem.TagFindText("0");
            this.cmbtreevDisplayMethod.TagFindText("Pie");
        }
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AnalyzedOrderSelectionFilmFormMain_Shown(object sender, EventArgs e)
        {
            bool b = LYFZ.Software.MainBusiness.VersionControl.StaticVersion.UIFunctionVersion(VersionControl.VersionFunctionEnum.决策助手选片分析);
            if (!b)
            {
                this.Close();
                return;
            }
            this.chart1.Focus();
            this.chart1.ChartAreas[0].CursorX.IsUserEnabled = true;
            this.chart1.ChartAreas[0].CursorX.IsUserSelectionEnabled = true;
            this.chart1.ChartAreas[0].AxisX.ScaleView.Zoomable = true;
            this.chart1.ChartAreas[0].AxisX.ScrollBar.IsPositionedInside = false;//将滚动内嵌到坐标轴中            
            this.chart1.ChartAreas["ChartArea1"].AxisX.ScrollBar.Size = 20;// 设置滚动条的大小            
            this.chart1.ChartAreas["ChartArea1"].AxisX.ScrollBar.ButtonStyle = ScrollBarButtonStyles.All;// 设置滚动条的按钮的风格，下面代码是将所有滚动条上的按钮都显示出来            
            this.chart1.ChartAreas["ChartArea1"].AxisX.ScaleView.SmallScrollSize = double.NaN;// 设置自动放大与缩小的最小量
            this.chart1.ChartAreas["ChartArea1"].AxisX.ScaleView.SmallScrollMinSize = 2;

            this.chart2.Focus();
            this.chart2.ChartAreas[0].CursorX.IsUserEnabled = true;
            this.chart2.ChartAreas[0].CursorX.IsUserSelectionEnabled = true;
            this.chart2.ChartAreas[0].AxisX.ScaleView.Zoomable = true;
            this.chart2.ChartAreas[0].AxisX.ScrollBar.IsPositionedInside = false;//将滚动内嵌到坐标轴中            
            this.chart2.ChartAreas["ChartArea1"].AxisX.ScrollBar.Size = 20;// 设置滚动条的大小            
            this.chart2.ChartAreas["ChartArea1"].AxisX.ScrollBar.ButtonStyle = ScrollBarButtonStyles.All;// 设置滚动条的按钮的风格，下面代码是将所有滚动条上的按钮都显示出来            
            this.chart2.ChartAreas["ChartArea1"].AxisX.ScaleView.SmallScrollSize = double.NaN;// 设置自动放大与缩小的最小量
            this.chart2.ChartAreas["ChartArea1"].AxisX.ScaleView.SmallScrollMinSize = 2;


            this.PublicFunctionRows();
            this.IsFristLoad = false;
            

           
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnQuery_Click(object sender, EventArgs e)
        {
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 另存为
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnSaveAs_Click(object sender, EventArgs e)
        {
            string StrFilleName = Convert.ToDateTime(this.dtDataTimeStart.DateValue).ToString("yyyy年MM月dd日") + " — " + Convert.ToDateTime(this.dtDataTimeEnd.DateValue).ToString("yyyy年MM月dd日") + " 选片情况分析表";
            if (this.chkComparedStartUp.Checked)
            { StrFilleName = this.dtDataTimeStart.DateValue.Trim() + "—" + this.dtDataTimeEnd.DateValue.Trim() + " 与 " + this.dtDataTimeStartCompared.DateValue.Trim() + "—" + this.dtDateTimeEndCompared.DateValue.Trim() + " 选片情况对比分析表"; }
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.DownloadSaveAs(this.PictImage.Image, StrFilleName: StrFilleName);
        }
        /// <summary>
        /// 关闭
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnColseed_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        /// <summary>
        /// 启动对比
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkComparedStartUp_Click(object sender, EventArgs e)
        {
            if (this.chkComparedStartUp.Checked)
            {
                this.panelQueryCompared.Visible = true;
                if (!string.IsNullOrEmpty(this.dtDataTimeStartCompared.DateValue.Trim()) && !string.IsNullOrEmpty(this.dtDateTimeEndCompared.DateValue.Trim()))
                { this.PublicFunctionRows(); }
            }
            else
            {
                this.panelQueryCompared.Visible = false;
                this.PublicFunctionRows();
            }
        }
        /// <summary>
        /// 订单类型
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkOrderType_Click(object sender, EventArgs e)
        {
            this.chkOrderClass.Checked = false;
            this.chkOrderType.Checked = true;
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 订单类别
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void chkOrderClass_Click(object sender, EventArgs e)
        {
            this.chkOrderType.Checked = false;
            this.chkOrderClass.Checked = true;
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 开始日期离开事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dtDataTimeStart_Leave(object sender, EventArgs e)
        {
            this.dtDataTimeEnd.DateValue = Convert.ToDateTime(this.dtDataTimeStart.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
        }
        /// <summary>
        /// 开始日期离开事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dtDataTimeStartCompared_Leave(object sender, EventArgs e)
        {
            this.dtDateTimeEndCompared.DateValue = Convert.ToDateTime(this.dtDataTimeStartCompared.DateValue).AddMonths(1).AddSeconds(-1).ToString("yyyy-MM-dd");
        }
        /// <summary>
        /// 显示项目
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cmbtreevDisplayItem_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            this.PublicFunctionView();
        }
        /// <summary>
        /// 显示方式
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void cmbtreevDisplayMethod_ComboBoxTree_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
        {
            this.PublicFunctionView();
        }
        /// <summary>
        /// 窗体大小发生变化
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void AnalyzedOrderSelectionFilmFormMain_Resize(object sender, EventArgs e)
        {
            switch (this.panelQueryCompared.Location.Y)
            {
                case 1: this.flowLayoutPanel1.Height = 35; break;
                case 35: this.flowLayoutPanel1.Height = 70; break;
            }
            if (this.IsFristLoad)
            {
                this.panelEx6.Width = this.panelEx3.Width / 2;
            }
        }

        void SetPostionData(string ordType, string columType, Rectangle rectangle, string where, string startTime, string endTime)
        {
            ModelImagePostionAction actionModel = null;

            string StrType = "";
            if (this.chkOrderType.Checked)
            { StrType = "Ord_Type,dbo.fn_CheckOrderType(Ord_Type) AS Ord_TypeText,"; }
            else
            { StrType = "Ord_OrderClass AS Ord_Type,Ord_OrderClass AS Ord_TypeText,"; }

            
            string SqlSelect = @"";
            SqlSelect = "with t AS " +
           "(" +
           "    select Pay_OrdNumber,Cus_Name as '客户名称',Cus_Telephone as '联系电话','' as '套系名称',Sum(Pay_AmountOf) AS Pay_AmountOf ,Sc_ClassName as 付款方式 from tb_ErpPayment  left join tempTB_AggregationCustomer on GP_OrderNumber=Pay_OrdNumber left join tb_ErpSystemCategory on Sc_ClassCode=Pay_PaymentMethod   where Pay_Category = '后期收款' And Pay_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ' And Pay_Type = 0 Group By Pay_OrdNumber,Sc_ClassName,Cus_Name,Cus_Telephone " +
           ")" +
           ",tA AS " +
           "(" +
           "select Ord_Number,Cus_Name as '客户名称',Cus_Telephone as '联系电话',Ord_SeriesName as '套系名称'," + StrType + "tb_ErpOrderDigital.ID,isnull((select Sum(Plu_Amount) from tb_ErpPlusPickItems Where Plu_OrdViceNumber = Ordv_ViceNumber And Plu_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ'),0) AS Plu_Amount," +
           "isnull(Pay_AmountOf,0) AS Plu_Paid,付款方式 " +
           "from tb_ErpOrderDigital Left Join tb_ErpOrder on Ord_Number = Ordv_Number  left join tempTB_AggregationCustomer on GP_OrderNumber=Ord_Number  Left Join t on Pay_OrdNumber = Ord_Number " +
           "where Ord_Type = '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Ordv_FilmSelectionTime", startTime, endTime) +
           LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop") + " " +
           ")" +
           ",tB AS " +
           "(" +
           "select Ord_Number,Cus_Name as '客户名称',Cus_Telephone as '联系电话',Ord_SeriesName as '套系名称'," + StrType + "tb_ErpOrderDigital.ID,isnull((select Sum(Plu_Amount) from tb_ErpPlusPickItems Where Plu_OrdNumber = Ordv_Number And Plu_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ'),0) AS Plu_Amount," +
           "isnull(Pay_AmountOf,0) AS Plu_Paid,付款方式 " +
           "from tb_ErpOrderDigital Left Join tb_ErpOrder on Ord_Number = Ordv_Number  left join tempTB_AggregationCustomer on GP_OrderNumber=Ord_Number  Left Join t on Pay_OrdNumber = Ord_Number " +
           "where Ord_Type <> '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Ordv_FilmSelectionTime", startTime, endTime) +
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop") + " " +
           ")" +
           ",tC AS " +
           "(" +
           "select * from tA UNION ALL select * from tB " +
           ")" +
           @"select 
	            Ord_Number as 订单号,客户名称,联系电话,套系名称,Ord_typeText as 订单类型, sum(plu_Amount) as 加挑金额,sum(plu_paid) as 已收金额,付款方式
            from 
	            tC 
           ";

            //string SqlSelect = @"";
            string sqlWhere = " tC.Ord_typeText='" + columType + @"'  group by
             Ord_Number,Ord_Type,Ord_typeText,付款方式,客户名称,联系电话,套系名称 ";

            actionModel = new ModelImagePostionAction()
            {
                OrdType = ordType,
                ColumType = columType,
                MouseX = rectangle.X,
                MouseY = rectangle.Y,
                MouseWidth = rectangle.Width,
                MouseHeight = rectangle.Height,
                SqlData = SqlSelect + " where " + sqlWhere
            };
            actionModel.OrdTitle = this.UcNavigationTool.LabTitle;
            if (actionModel != null)
            {
                actionList.Add(actionModel);
            }

        }


        Hashtable htDataView = new Hashtable();
        Hashtable htDataViewDb = new Hashtable();
        /// <summary>
        /// 创建行
        /// </summary>
        private void PublicFunctionRows()
        {
            actionList.Clear();
            #region 处理数据前判断
            if (this.chkComparedStartUp.Checked)
            {
                if (string.IsNullOrEmpty(this.dtDataTimeStart.DateValue.Trim()) && string.IsNullOrEmpty(this.dtDataTimeEnd.DateValue.Trim()))
                { MessageBoxCustom.Show("对比前日期段不能为空"); return; }
                if (Convert.ToDateTime(this.dtDataTimeEnd.DateValue) < Convert.ToDateTime(this.dtDataTimeStart.DateValue))
                { MessageBoxCustom.Show("对比前开始日期不能大于结束日期"); return; }

                if (string.IsNullOrEmpty(this.dtDataTimeStartCompared.DateValue.Trim()) && string.IsNullOrEmpty(this.dtDateTimeEndCompared.DateValue.Trim()))
                { MessageBoxCustom.Show("对比后日期段不能为空"); return; }
                if (Convert.ToDateTime(this.dtDateTimeEndCompared.DateValue) < Convert.ToDateTime(this.dtDataTimeStartCompared.DateValue))
                { MessageBoxCustom.Show("对比后开始日期不能大于结束日期"); return; }

                if (Convert.ToDateTime(this.dtDateTimeEndCompared.DateValue.Trim()) > Convert.ToDateTime(this.dtDataTimeStart.DateValue.Trim()))
                { MessageBoxCustom.Show("对比后的结束日期不能大于对比前的开始日期"); return; }
            }
            else
            {
                if (string.IsNullOrEmpty(this.dtDataTimeStart.DateValue.Trim()) && string.IsNullOrEmpty(this.dtDataTimeEnd.DateValue.Trim()))
                { MessageBoxCustom.Show("日期段不能为空"); return; }
                if (Convert.ToDateTime(this.dtDataTimeEnd.DateValue) < Convert.ToDateTime(this.dtDataTimeStart.DateValue))
                { MessageBoxCustom.Show("开始日期不能大于结束日期"); return; }
            }
            this.IsFristLoad = true;
            this.AnalyzedOrderSelectionFilmFormMain_Resize(this, null);
            this.IsFristLoad = false;
            this.actionList.Clear();
            this.htDataView.Clear();
            this.htDataViewDb.Clear();
            #endregion

            Bitmap newBmp = new Bitmap(this.PictImage.Width, 900);
            Graphics g = Graphics.FromImage(newBmp);
            g.Clear(System.Drawing.Color.White);
            Brush b = Brushes.Black;
            Pen p = LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.PenborderColor;
            Font ft12b = new Font("微软雅黑", 12);
            Font ft11b = new Font("微软雅黑", 11);
            Font ft11 = new Font("微软雅黑", 11, FontStyle.Italic);
            if (this.chkComparedStartUp.Checked)
            {
                ft12b = new Font("微软雅黑", 11);
                ft11b = new Font("微软雅黑", 10);
                ft11 = new Font("微软雅黑", 10, FontStyle.Italic);
            }
            Font ft15 = new Font("微软雅黑", 15);

            int TopAdd = 7;
            int LeftWidth = 30;
            int TableWidth = newBmp.Width - LeftWidth * 2;
            int ColumnWidth1 = 130;
            if (this.chkComparedStartUp.Checked)
            { ColumnWidth1 = 75; }
            int TableHeoght = 300 - 60;
            int RowHeight = TableHeoght / 7;

            string StrTypeTextNull = "        ";
            if (this.chkComparedStartUp.Checked)
            { StrTypeTextNull = "      "; }
            string StrTimeStrat = this.dtDataTimeStart.DateValue.Trim();
            string StrTimeEnd = this.dtDataTimeEnd.DateValue.Trim();
            string ExecuteSql = "";
            string StrType = "";
            if (this.chkOrderType.Checked)
            { StrType = "Ord_Type,dbo.fn_CheckOrderType(Ord_Type) AS Ord_TypeText,"; }
            else
            { StrType = "Ord_OrderClass AS Ord_Type,Ord_OrderClass AS Ord_TypeText,"; }
            ExecuteSql = "with t AS " +
            "(" +
            "select Pay_OrdNumber,Sum(Pay_AmountOf) AS Pay_AmountOf from tb_ErpPayment where Pay_Category = '后期收款' And Pay_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ' And Pay_Type = 0 Group By Pay_OrdNumber" +
            ")" +
            ",tA AS " +
            "(" +
            "select " + StrType + "tb_ErpOrderDigital.ID,isnull((select Sum(Plu_Amount) from tb_ErpPlusPickItems Where Plu_OrdViceNumber = Ordv_ViceNumber And Plu_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ'),0) AS Plu_Amount," +
            "isnull(Pay_AmountOf,0) AS Plu_Paid " +
            "from tb_ErpOrderDigital Left Join tb_ErpOrder on Ord_Number = Ordv_Number Left Join t on Pay_OrdNumber = Ord_Number " +
            "where Ord_Type = '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Ordv_FilmSelectionTime", StrTimeStrat, StrTimeEnd) +
            LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop") + " " +
            ")" +
            ",tB AS " +
            "(" +
            "select " + StrType + "tb_ErpOrderDigital.ID,isnull((select Sum(Plu_Amount) from tb_ErpPlusPickItems Where Plu_OrdNumber = Ordv_Number And Plu_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ'),0) AS Plu_Amount," +
            "isnull(Pay_AmountOf,0) AS Plu_Paid " +
            "from tb_ErpOrderDigital Left Join tb_ErpOrder on Ord_Number = Ordv_Number Left Join t on Pay_OrdNumber = Ord_Number " +
            "where Ord_Type <> '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Ordv_FilmSelectionTime", StrTimeStrat, StrTimeEnd) +
             LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop") + " " +
            ")" +
            ",tC AS " +
            "(" +
            "select * from tA UNION ALL select * from tB " +
            ")" +
            "select Ord_Type,Ord_TypeText,Count(Ord_TypeText) AS CountID,Sum(Plu_Amount) AS Plu_Amount,Sum(Plu_Paid) AS Plu_Paid," +
            "(select Count(Ord_TypeText) from tC AS tt where tt.Ord_TypeText = tC.Ord_TypeText And Plu_Amount is not null And Plu_Amount > 0) AS CountPID " +
            "from tC Group by Ord_Type,Ord_TypeText";

            DataSet dsData = orbll.GetView_Custom(ExecuteSql);
            DataTable dtOrderCount = dsData.Tables["ds"];
            if (!this.chkComparedStartUp.Checked)
            {
                this.panelEx6.Visible = false;
                #region 无启动对比
                int ColumnWidth2 = (TableWidth - ColumnWidth1) / 6;
                int ColumnWidth3 = (TableWidth - ColumnWidth1) / 6;
                int ColumnWidth4 = (TableWidth - ColumnWidth1) / 6;
                int ColumnWidth5 = (TableWidth - ColumnWidth1) / 6;
                int ColumnWidth6 = (TableWidth - ColumnWidth1) / 6;
                int ColumnWidth7 = (TableWidth - ColumnWidth1) / 6;
                int ForTopLoad = 30;
                string StrValue = Convert.ToDateTime(this.dtDataTimeStart.DateValue).ToString("yyyy年MM月dd日") + " — " + Convert.ToDateTime(this.dtDataTimeEnd.DateValue).ToString("yyyy年MM月dd日") + " 选片情况分析表";
                SizeF sizef = g.MeasureString(StrValue, ft15);
                int FtHeigth = Convert.ToInt32(sizef.Height);
                int FtWidth = Convert.ToInt32(sizef.Width) + 1;
                Rectangle rec = new Rectangle(TableWidth / 2 - FtWidth / 2, ForTopLoad, FtWidth, FtHeigth);
                g.DrawString(StrValue, ft15, b, rec);//画消费法规
                ForTopLoad = rec.Y + rec.Height;

                decimal TotalOrderCount = 0;
                decimal TotalOrderCountPlus = 0;
                decimal TotalPlusAmount = 0;
                decimal TotalPlusPaid = 0;
                for (int i = 0; i < dtOrderCount.Rows.Count; i++)
                {
                    string StrViewText = "";
                    #region 标题
                    if (i == 0)
                    {
                        Rectangle rec1 = new Rectangle(LeftWidth, ForTopLoad, TableWidth, RowHeight);
                        g.DrawRectangle(p, rec1);//画标题矩形

                        Rectangle recBackColor1 = new Rectangle(rec1.X + 1, rec1.Y + 1, rec1.Width - 1, rec1.Height - 1);
                        g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.backColortitle, recBackColor1);//画标题矩形

                        Rectangle rec1_1 = new Rectangle(rec1.X, rec1.Y + TopAdd, ColumnWidth1, RowHeight);
                        g.DrawString("", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec1_1);
                        Point p11_1 = new Point(rec1.X + ColumnWidth1, rec1.Y);
                        Point p11_2 = new Point(rec1.X + ColumnWidth1, rec1.Y + rec1.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p11_1, p11_2);

                        Rectangle rec2_1 = new Rectangle(p11_1.X + ColumnWidth2 / 2 - 30, p11_1.Y + TopAdd, ColumnWidth2, RowHeight);
                        g.DrawString("选片次数", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec2_1);
                        Point p21_1 = new Point(p11_1.X + ColumnWidth2, rec1.Y);
                        Point p21_2 = new Point(p11_1.X + ColumnWidth2, rec1.Y + rec1.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p21_1, p21_2);

                        Rectangle rec3_1 = new Rectangle(p21_1.X + ColumnWidth3 / 2 - 30, p21_1.Y + TopAdd, ColumnWidth3, RowHeight);
                        g.DrawString("加挑次数", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec3_1);
                        Point p31_1 = new Point(p21_1.X + ColumnWidth3, rec1.Y);
                        Point p31_2 = new Point(p21_1.X + ColumnWidth3, rec1.Y + rec1.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p31_1, p31_2);

                        Rectangle rec4_1 = new Rectangle(p31_1.X + ColumnWidth4 / 2 - 25, p31_1.Y + TopAdd, ColumnWidth4, RowHeight);
                        g.DrawString("加挑率", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec4_1);
                        Point p41_1 = new Point(p31_1.X + ColumnWidth4, rec1.Y);
                        Point p41_2 = new Point(p31_1.X + ColumnWidth4, rec1.Y + rec1.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p41_1, p41_2);

                        Rectangle rec5_1 = new Rectangle(p41_1.X + ColumnWidth5 / 2 - 30, p41_1.Y + TopAdd, ColumnWidth5, RowHeight);
                        g.DrawString("加挑总额", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec5_1);
                        Point p51_1 = new Point(p41_1.X + ColumnWidth5, rec1.Y);
                        Point p51_2 = new Point(p41_1.X + ColumnWidth5, rec1.Y + rec1.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p51_1, p51_2);

                        Rectangle rec6_1 = new Rectangle(p51_1.X + ColumnWidth6 / 2 - 30, p51_1.Y + TopAdd, ColumnWidth6, RowHeight);
                        g.DrawString("加挑均值", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec6_1);
                        Point p61_1 = new Point(p51_1.X + ColumnWidth6, rec1.Y);
                        Point p61_2 = new Point(p51_1.X + ColumnWidth6, rec1.Y + rec1.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p61_1, p61_2);

                        Rectangle rec7_1 = new Rectangle(p61_1.X + ColumnWidth7 / 2 - 30, p61_1.Y + TopAdd, ColumnWidth7, RowHeight);
                        g.DrawString("实收金额", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec7_1);
                    }
                    #endregion

                    #region 内容
                    Rectangle rec1A = new Rectangle(LeftWidth, ForTopLoad + RowHeight * (i + 1), TableWidth, RowHeight);
                    g.DrawRectangle(p, rec1A);//画标题矩形

                    Rectangle rec1AColor1 = new Rectangle(rec1A.X + 1, rec1A.Y + 1, rec1A.Width - 1, rec1A.Height - 1);
                    if ((i % 2) > 0)
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brSingle, rec1AColor1); }
                    else
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brDouble, rec1AColor1); }

                    Rectangle rec1A_1 = new Rectangle(rec1A.X + 35, rec1A.Y + TopAdd, ColumnWidth1, RowHeight);
                    g.DrawString(dtOrderCount.Rows[i]["Ord_TypeText"].ToString().Trim(), ft11b, b, rec1A_1);
                    Point p11A_1 = new Point(rec1A.X + ColumnWidth1, rec1A.Y);
                    Point p11A_2 = new Point(rec1A.X + ColumnWidth1, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11A_1, p11A_2);

                    //选片次数
                    decimal OrderCount = Convert.ToDecimal(dtOrderCount.Rows[i]["CountID"]);
                    TotalOrderCount += OrderCount;
                    Rectangle rec2A_1 = new Rectangle(p11A_1.X + ColumnWidth2 / 2 - 8, p11A_1.Y + TopAdd, ColumnWidth2, RowHeight);
                    g.DrawString(OrderCount.ToString(), ft11, b, rec2A_1);
                    Point p21A_1 = new Point(p11A_1.X + ColumnWidth2, rec1A.Y);
                    Point p21A_2 = new Point(p11A_1.X + ColumnWidth2, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21A_1, p21A_2);
                    StrViewText += OrderCount + "|";
                    SetPostionData("", dtOrderCount.Rows[i]["Ord_TypeText"].ToString(), rec2A_1, "", StrTimeStrat, StrTimeEnd);

                    //加挑次数
                    decimal OrderCountPlus = Convert.ToDecimal(dtOrderCount.Rows[i]["CountPID"]);
                    TotalOrderCountPlus += OrderCountPlus;
                    Rectangle rec3A_1 = new Rectangle(p21A_1.X + ColumnWidth2 / 2 - 8, p21A_1.Y + TopAdd, ColumnWidth3, RowHeight);
                    g.DrawString(OrderCountPlus.ToString(), ft11, b, rec3A_1);
                    Point p31A_1 = new Point(p21A_1.X + ColumnWidth3, rec1A.Y);
                    Point p31A_2 = new Point(p21A_1.X + ColumnWidth3, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31A_1, p31A_2);
                    StrViewText += LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountPlus) + "|";
                    SetPostionData("", dtOrderCount.Rows[i]["Ord_TypeText"].ToString(), rec3A_1, "", StrTimeStrat, StrTimeEnd);

                    //加挑率
                    string StrPercentage = "0%";
                    if (OrderCount > 0)
                    { StrPercentage = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero((OrderCountPlus / OrderCount * 100).ToString("0.00")) + "%"; }
                    sizef = g.MeasureString(StrPercentage.ToString().Trim(), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec4A_1 = new Rectangle(p31A_1.X + ColumnWidth4 - FtWidth - ColumnWidth4 / 3, p31A_1.Y + TopAdd, ColumnWidth4, RowHeight);
                    g.DrawString(StrPercentage, ft11, b, rec4A_1);
                    Point p41A_1 = new Point(p31A_1.X + ColumnWidth4, rec1A.Y);
                    Point p41A_2 = new Point(p31A_1.X + ColumnWidth4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p41A_1, p41A_2);
                    SetPostionData("", dtOrderCount.Rows[i]["Ord_TypeText"].ToString(), rec4A_1, "", StrTimeStrat, StrTimeEnd);

                    //加挑总额
                    decimal PlusAmount = Convert.ToDecimal(dtOrderCount.Rows[i]["Plu_Amount"]);
                    sizef = g.MeasureString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(PlusAmount), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    TotalPlusAmount += PlusAmount;
                    Rectangle rec5A_1 = new Rectangle(p41A_1.X + ColumnWidth5 - FtWidth - ColumnWidth5 / 3, p41A_1.Y + TopAdd, ColumnWidth5, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(PlusAmount), ft11, b, rec5A_1);
                    Point p51A_1 = new Point(p41A_1.X + ColumnWidth5, rec1A.Y);
                    Point p51A_2 = new Point(p41A_1.X + ColumnWidth5, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p51A_1, p51A_2);
                    StrViewText += PlusAmount + "|";
                    SetPostionData("", dtOrderCount.Rows[i]["Ord_TypeText"].ToString(), rec5A_1, "", StrTimeStrat, StrTimeEnd);

                    //加挑已收款
                    decimal AverageValue = 0;
                    if (OrderCountPlus > 0)
                    { AverageValue = Convert.ToDecimal((PlusAmount / OrderCountPlus).ToString("0.00")); }
                    sizef = g.MeasureString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(AverageValue), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec6A_1 = new Rectangle(p51A_1.X + ColumnWidth6 - FtWidth - ColumnWidth6 / 3, p51A_1.Y + TopAdd, ColumnWidth6, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(AverageValue), ft11, b, rec6A_1);
                    Point p61A_1 = new Point(p51A_1.X + ColumnWidth6, rec1A.Y);
                    Point p61A_2 = new Point(p51A_1.X + ColumnWidth6, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p61A_1, p61A_2);
                    StrViewText += AverageValue + "|";
                    SetPostionData("", dtOrderCount.Rows[i]["Ord_TypeText"].ToString(), rec6A_1, "", StrTimeStrat, StrTimeEnd);

                    sizef = g.MeasureString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(dtOrderCount.Rows[i]["Plu_Paid"]), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec7A_1 = new Rectangle(p61A_1.X + ColumnWidth7 / 2, p61A_1.Y + TopAdd, ColumnWidth7, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(dtOrderCount.Rows[i]["Plu_Paid"]), ft11, b, rec7A_1);
                    TotalPlusPaid += Convert.ToDecimal(dtOrderCount.Rows[i]["Plu_Paid"]);
                    SetPostionData("", dtOrderCount.Rows[i]["Ord_TypeText"].ToString(), rec7A_1, "", StrTimeStrat, StrTimeEnd);

                    htDataView[dtOrderCount.Rows[i]["Ord_TypeText"].ToString().Trim()] = StrViewText.TrimEnd('|');
                    #endregion
                }
                if (dtOrderCount.Rows.Count > 1)
                {
                    this.panelEx3.Visible = true;
                    this.panelEx2.Dock = DockStyle.Top;
                    #region 总结
                    Rectangle rec1B = new Rectangle(LeftWidth, ForTopLoad + RowHeight * (dtOrderCount.Rows.Count + 1), TableWidth, RowHeight);
                    g.DrawRectangle(p, rec1B);//画标题矩形

                    Rectangle rec1BColor1 = new Rectangle(rec1B.X + 1, rec1B.Y + 1, rec1B.Width - 1, rec1B.Height - 1);
                    if ((dtOrderCount.Rows.Count % 2) > 0)
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brSingle, rec1BColor1); }
                    else
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brDouble, rec1BColor1); }

                    Rectangle rec1B_1 = new Rectangle(rec1B.X + 34, rec1B.Y + TopAdd, ColumnWidth1, RowHeight);
                    g.DrawString("总" + StrTypeTextNull + "计", ft11b, b, rec1B_1);
                    Point p11B_1 = new Point(rec1B.X + ColumnWidth1, rec1B.Y);
                    Point p11B_2 = new Point(rec1B.X + ColumnWidth1, rec1B.Y + rec1B.Height);
                    g.DrawLine(p, p11B_1, p11B_2);

                    Rectangle rec2B_1 = new Rectangle(p11B_1.X + ColumnWidth2 / 2 - 8, p11B_1.Y + TopAdd, ColumnWidth2, RowHeight);
                    g.DrawString(TotalOrderCount.ToString().Trim(), ft11, b, rec2B_1);
                    Point p21B_1 = new Point(p11B_1.X + ColumnWidth2, rec1B.Y);
                    Point p21B_2 = new Point(p11B_1.X + ColumnWidth2, rec1B.Y + rec1B.Height);
                    g.DrawLine(p, p21B_1, p21B_2);

                    sizef = g.MeasureString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalOrderCountPlus), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec3B_1 = new Rectangle(p21B_1.X + ColumnWidth3 / 2 - 8, p21B_1.Y + TopAdd, ColumnWidth3, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalOrderCountPlus), ft11, b, rec3B_1);
                    Point p31B_1 = new Point(p21B_1.X + ColumnWidth3, rec1B.Y);
                    Point p31B_2 = new Point(p21B_1.X + ColumnWidth3, rec1B.Y + rec1B.Height);
                    g.DrawLine(p, p31B_1, p31B_2);

                    string StrPercentage = "0%";
                    if (TotalOrderCount > 0)
                    { StrPercentage = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero((TotalOrderCountPlus / TotalOrderCount * 100).ToString("0.00")) + "%"; }
                    sizef = g.MeasureString(StrPercentage.ToString(), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec4B_1 = new Rectangle(p31B_1.X + ColumnWidth4 - FtWidth - (ColumnWidth4 / 6) * 2, p31B_1.Y + TopAdd, ColumnWidth4, RowHeight);
                    g.DrawString(StrPercentage.ToString(), ft11, b, rec4B_1);
                    Point p41B_1 = new Point(p31B_1.X + ColumnWidth4, rec1B.Y);
                    Point p41B_2 = new Point(p31B_1.X + ColumnWidth4, rec1B.Y + rec1B.Height);
                    g.DrawLine(p, p41B_1, p41B_2);

                    sizef = g.MeasureString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalPlusAmount), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec5B_1 = new Rectangle(p41B_1.X + ColumnWidth5 - FtWidth - (ColumnWidth5 / 6) * 2, p41B_1.Y + TopAdd, ColumnWidth5, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalPlusAmount), ft11, b, rec5B_1);
                    Point p51B_1 = new Point(p41B_1.X + ColumnWidth5, rec1B.Y);
                    Point p51B_2 = new Point(p41B_1.X + ColumnWidth5, rec1B.Y + rec1B.Height);
                    g.DrawLine(p, p51B_1, p51B_2);

                    decimal TotalAverageValue = 0;
                    if (TotalOrderCountPlus > 0)
                    { TotalAverageValue = Convert.ToDecimal((TotalPlusAmount / TotalOrderCountPlus).ToString("0.00")); }
                    sizef = g.MeasureString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalAverageValue), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec6B_1 = new Rectangle(p51B_1.X + ColumnWidth6 - FtWidth - (ColumnWidth6 / 6) * 2, p51B_1.Y + TopAdd, ColumnWidth6, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalAverageValue), ft11, b, rec6B_1);
                    Point p61B_1 = new Point(p51B_1.X + ColumnWidth6, rec1B.Y);
                    Point p61B_2 = new Point(p51B_1.X + ColumnWidth6, rec1B.Y + rec1B.Height);
                    g.DrawLine(p, p61B_1, p61B_2);

                    sizef = g.MeasureString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalPlusPaid), ft11);
                    FtWidth = Convert.ToInt32(sizef.Width) + 1;
                    Rectangle rec7B_1 = new Rectangle(p61B_1.X + ColumnWidth7 / 2, p61B_1.Y + TopAdd, ColumnWidth7, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalPlusPaid), ft11, b, rec7B_1);
                    #endregion
                }
                else
                {
                    this.panelEx3.Visible = false;
                    this.panelEx2.Dock = DockStyle.Fill;
                }
                #endregion
            }
            else
            {
                this.panelEx6.Visible = true;
                string StrTimeStratDb = this.dtDataTimeStartCompared.DateValue.Trim();
                string StrTimeEndDb = this.dtDateTimeEndCompared.DateValue.Trim();
                ExecuteSql = "with tA AS " +
                "(" +
                "select " + StrType + "tb_ErpOrderDigital.ID,isnull((select Sum(Plu_Amount) from tb_ErpPlusPickItems Where Plu_OrdViceNumber = Ordv_ViceNumber And Plu_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ'),0) AS Plu_Amount " +
                "from tb_ErpOrderDigital Left Join tb_ErpOrder on Ord_Number = Ordv_Number Left Join tb_ErpUser on User_EmployeeID = Ordv_FilmSelectionName " +
                "where Ord_Type = '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Ordv_FilmSelectionTime", StrTimeStratDb, StrTimeEndDb) +
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop") + " " +
                ")" +
                ",tB AS " +
                "(" +
                "select " + StrType + "tb_ErpOrderDigital.ID,isnull((select Sum(Plu_Amount) from tb_ErpPlusPickItems Where Plu_OrdNumber = Ordv_Number And Plu_TwoPinsCategory = 'BEBCABBAAHFCJBJGJ'),0) AS Plu_Amount " +
                "from tb_ErpOrderDigital Left Join tb_ErpOrder on Ord_Number = Ordv_Number " +
                "where Ord_Type <> '1' " + LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetDateTime("Ordv_FilmSelectionTime", StrTimeStratDb, StrTimeEndDb) +
                LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.GetGroupQueryWhere(this.cmbtreevStoreName, "Ord_DividedShop") + " " +
                ")" +
                ",tC AS " +
                "(" +
                "select * from tA UNION ALL select * from tB " +
                ")" +
                "select Ord_Type,Ord_TypeText,Count(Ord_TypeText) AS CountID,Sum(Plu_Amount) AS Plu_Amount," +
                "(select Count(Ord_TypeText) from tC AS tt where tt.Ord_TypeText = tC.Ord_TypeText And Plu_Amount is not null And Plu_Amount > 0) AS CountPID " +
                "from tC Group by Ord_Type,Ord_TypeText";
                DataSet dsDataDb = orbll.GetView_Custom(ExecuteSql);
                DataTable dtOrderCountDb = dsDataDb.Tables["ds"];

                #region 启动对比
                int ColumnWidth2 = (TableWidth - ColumnWidth1) / 5;
                int ColumnWidth3 = (TableWidth - ColumnWidth1) / 5;
                int ColumnWidth4 = (TableWidth - ColumnWidth1) / 5;
                int ColumnWidth5 = (TableWidth - ColumnWidth1) / 5;
                int ColumnWidth6 = (TableWidth - ColumnWidth1) / 5;
                int ColumnWidthSplit2 = ColumnWidth2 / 3;
                int ColumnWidthSplit3 = ColumnWidth3 / 3;
                int ColumnWidthSplit4 = ColumnWidth4 / 3;
                int ColumnWidthSplit5 = ColumnWidth5 / 3;
                int ColumnWidthSplit6 = ColumnWidth6 / 3;

                int ForTopLoad = 15;
                string StrValue = StrTimeStrat + "—" + StrTimeEnd + " 与 " + StrTimeStratDb + "—" + StrTimeEndDb + " 选片情况对比分析表";
                SizeF sizef = g.MeasureString(StrValue, ft15);
                int FtHeigth = Convert.ToInt32(sizef.Height);
                int FtWidth = Convert.ToInt32(sizef.Width) + 1;
                Rectangle rec = new Rectangle(TableWidth / 2 - FtWidth / 2, ForTopLoad, FtWidth, FtHeigth);
                g.DrawString(StrValue, ft15, b, rec);//画消费法规
                ForTopLoad = rec.Y + rec.Height;

                decimal TotalOrderCount = 0;
                decimal TotalOrderCountPuls = 0;
                decimal TotalPlusAmount = 0;
                //decimal TotalAverageValue = 0;

                decimal TotalOrderCountDb = 0;
                decimal TotalOrderCountPulsDb = 0;
                decimal TotalPlusAmountDb = 0;
                //decimal TotalAverageValueDb = 0;
                Hashtable htData = new Hashtable();
                for (int i = 0; i < dtOrderCount.Rows.Count; i++)
                {
                    htData[dtOrderCount.Rows[i]["Ord_Type"].ToString().Trim()] = dtOrderCount.Rows[i]["Ord_TypeText"].ToString().Trim();
                }
                for (int i = 0; i < dtOrderCountDb.Rows.Count; i++)
                {
                    htData[dtOrderCountDb.Rows[i]["Ord_Type"].ToString().Trim()] = dtOrderCountDb.Rows[i]["Ord_TypeText"].ToString().Trim();
                }
                int forCount = 0;
                foreach (DictionaryEntry item in htData)
                {
                    string StrViewText = "";
                    string StrViewTextDb = "";
                    #region 标题
                    if (forCount == 0)
                    {
                        Rectangle rec1 = new Rectangle(LeftWidth, ForTopLoad, TableWidth, RowHeight * 2);
                        g.DrawRectangle(p, rec1);//画标题矩形

                        Rectangle recBackColor1 = new Rectangle(rec1.X + 1, rec1.Y + 1, rec1.Width - 1, rec1.Height - 1);
                        g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.backColortitle, recBackColor1);//画标题矩形

                        ForTopLoad = rec1.Y + rec1.Height;
                        Point p1_1 = new Point(rec1.X + ColumnWidth1, rec1.Y + RowHeight);
                        Point p1_2 = new Point(rec1.X + TableWidth, rec1.Y + RowHeight);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p1_1, p1_2);

                        Rectangle rec1_1 = new Rectangle(rec1.X, rec1.Y + TopAdd, ColumnWidth1, RowHeight);
                        g.DrawString("", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec1_1);
                        Point p11_1 = new Point(rec1.X + ColumnWidth1, rec1.Y);
                        Point p11_2 = new Point(rec1.X + ColumnWidth1, rec1.Y + RowHeight);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p11_1, p11_2);

                        Rectangle rec2_1 = new Rectangle(p11_1.X + ColumnWidth2 / 2 - 30, p11_1.Y + TopAdd, ColumnWidth2, RowHeight);
                        g.DrawString("选片次数", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec2_1);
                        Point p21_1 = new Point(p11_1.X + ColumnWidth2, rec1.Y);
                        Point p21_2 = new Point(p11_1.X + ColumnWidth2, rec1.Y + RowHeight);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p21_1, p21_2);

                        Rectangle rec3_1 = new Rectangle(p21_1.X + ColumnWidth3 / 2 - 30, p21_1.Y + TopAdd, ColumnWidth3, RowHeight);
                        g.DrawString("加挑次数", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec3_1);
                        Point p31_1 = new Point(p21_1.X + ColumnWidth3, rec1.Y);
                        Point p31_2 = new Point(p21_1.X + ColumnWidth3, rec1.Y + RowHeight);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p31_1, p31_2);

                        Rectangle rec4_1 = new Rectangle(p31_1.X + ColumnWidth4 / 2 - 25, p31_1.Y + TopAdd, ColumnWidth4, RowHeight);
                        g.DrawString("加挑率", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec4_1);
                        Point p41_1 = new Point(p31_1.X + ColumnWidth4, rec1.Y);
                        Point p41_2 = new Point(p31_1.X + ColumnWidth4, rec1.Y + RowHeight);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p41_1, p41_2);

                        Rectangle rec5_1 = new Rectangle(p41_1.X + ColumnWidth5 / 2 - 30, p41_1.Y + TopAdd, ColumnWidth5, RowHeight);
                        g.DrawString("加挑总额", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec5_1);
                        Point p51_1 = new Point(p41_1.X + ColumnWidth5, rec1.Y);
                        Point p51_2 = new Point(p41_1.X + ColumnWidth5, rec1.Y + RowHeight);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p51_1, p51_2);

                        Rectangle rec6_1 = new Rectangle(p51_1.X + ColumnWidth6 / 2 - 30, p51_1.Y + TopAdd, ColumnWidth6, RowHeight);
                        g.DrawString("加挑均值", ft12b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec6_1);




                        sizef = g.MeasureString("测试测", ft11b);
                        FtWidth = Convert.ToInt32(sizef.Width) + 1;
                        Rectangle rec1AB = new Rectangle(p1_1.X, p1_1.Y, TableWidth - ColumnWidth1 + 1, RowHeight);
                        g.DrawRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, rec1AB);//画标题矩形

                        Rectangle rec2AB_1 = new Rectangle(rec1AB.X + (ColumnWidthSplit2 - FtWidth) / 2, rec1AB.Y + TopAdd, ColumnWidthSplit2, RowHeight);
                        g.DrawString("对比前", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec2AB_1);
                        Point p21AB_1 = new Point(rec1AB.X + ColumnWidthSplit2, rec1AB.Y);
                        Point p21AB_2 = new Point(rec1AB.X + ColumnWidthSplit2, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p21AB_1, p21AB_2);

                        Rectangle rec3AB_1 = new Rectangle(p21AB_1.X + (ColumnWidthSplit2 - FtWidth) / 2, p21AB_1.Y + TopAdd, ColumnWidthSplit2, RowHeight);
                        g.DrawString("对比后", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec3AB_1);
                        Point p31AB_1 = new Point(p21AB_1.X + ColumnWidthSplit2, rec1AB.Y);
                        Point p31AB_2 = new Point(p21AB_1.X + ColumnWidthSplit2, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p31AB_1, p31AB_2);

                        Rectangle rec4AB_1 = new Rectangle(p31AB_1.X + (ColumnWidthSplit2 - FtWidth) / 2, p31AB_1.Y + TopAdd, ColumnWidth2 - ColumnWidthSplit2 * 2, RowHeight);
                        g.DrawString("增长率", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec4AB_1);
                        Point p41AB_1 = new Point(p31AB_1.X + ColumnWidth2 - ColumnWidthSplit2 * 2, rec1AB.Y);
                        Point p41AB_2 = new Point(p31AB_1.X + ColumnWidth2 - ColumnWidthSplit2 * 2, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p41AB_1, p41AB_2);

                        Rectangle rec1BB_1 = new Rectangle(p41AB_1.X + (ColumnWidthSplit3 - FtWidth) / 2, p41AB_1.Y + TopAdd, ColumnWidthSplit3, RowHeight);
                        g.DrawString("对比前", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec1BB_1);
                        Point p11BB_1 = new Point(p41AB_1.X + ColumnWidthSplit3, rec1AB.Y);
                        Point p11BB_2 = new Point(p41AB_1.X + ColumnWidthSplit3, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p11BB_1, p11BB_2);

                        Rectangle rec2BB_1 = new Rectangle(p11BB_1.X + (ColumnWidthSplit3 - FtWidth) / 2, p11BB_1.Y + TopAdd, ColumnWidthSplit3, RowHeight);
                        g.DrawString("对比后", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec2BB_1);
                        Point p21BB_1 = new Point(p11BB_1.X + ColumnWidthSplit3, rec1AB.Y);
                        Point p21BB_2 = new Point(p11BB_1.X + ColumnWidthSplit3, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p21BB_1, p21BB_2);

                        Rectangle rec3BB_1 = new Rectangle(p21BB_1.X + (ColumnWidthSplit3 - FtWidth) / 2, p21BB_1.Y + TopAdd, ColumnWidth3 - ColumnWidthSplit3 * 2, RowHeight);
                        g.DrawString("增长率", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec3BB_1);
                        Point p31BB_1 = new Point(p21BB_1.X + (ColumnWidth3 - ColumnWidthSplit3 * 2), rec1AB.Y);
                        Point p31BB_2 = new Point(p21BB_1.X + (ColumnWidth3 - ColumnWidthSplit3 * 2), rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p31BB_1, p31BB_2);

                        Rectangle rec4BB_1 = new Rectangle(p31BB_1.X + (ColumnWidthSplit4 - FtWidth) / 2, p31BB_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                        g.DrawString("对比前", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec4BB_1);
                        Point p41BB_1 = new Point(p31BB_1.X + ColumnWidthSplit4, rec1AB.Y);
                        Point p41BB_2 = new Point(p31BB_1.X + ColumnWidthSplit4, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p41BB_1, p41BB_2);

                        Rectangle rec1CB_1 = new Rectangle(p41BB_1.X + (ColumnWidthSplit4 - FtWidth) / 2, p41BB_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                        g.DrawString("对比后", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec1CB_1);
                        Point p11CB_1 = new Point(p41BB_1.X + ColumnWidthSplit4, rec1AB.Y);
                        Point p11CB_2 = new Point(p41BB_1.X + ColumnWidthSplit4, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p11CB_1, p11CB_2);

                        Rectangle rec2CB_1 = new Rectangle(p11CB_1.X + (ColumnWidthSplit4 - FtWidth) / 2, p11CB_1.Y + TopAdd, ColumnWidth4 - ColumnWidthSplit4 * 2, RowHeight);
                        g.DrawString("增长率", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec2CB_1);
                        Point p21CB_1 = new Point(p11CB_1.X + (ColumnWidth4 - ColumnWidthSplit4 * 2), rec1AB.Y);
                        Point p21CB_2 = new Point(p11CB_1.X + (ColumnWidth4 - ColumnWidthSplit4 * 2), rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p21CB_1, p21CB_2);

                        Rectangle rec3CB_1 = new Rectangle(p21CB_1.X + (ColumnWidthSplit4 - FtWidth) / 2, p21CB_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                        g.DrawString("对比前", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec3CB_1);
                        Point p31CB_1 = new Point(p21CB_1.X + ColumnWidthSplit4, rec1AB.Y);
                        Point p31CB_2 = new Point(p21CB_1.X + ColumnWidthSplit4, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p31CB_1, p31CB_2);

                        Rectangle rec4CB_1 = new Rectangle(p31CB_1.X + (ColumnWidthSplit5 - FtWidth) / 2, p31CB_1.Y + TopAdd, ColumnWidthSplit5, RowHeight);
                        g.DrawString("对比后", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec4CB_1);
                        Point p41CB_1 = new Point(p31CB_1.X + ColumnWidthSplit5, rec1AB.Y);
                        Point p41CB_2 = new Point(p31CB_1.X + ColumnWidthSplit5, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p41CB_1, p41CB_2);

                        Rectangle rec1DB_1 = new Rectangle(p41CB_1.X + (ColumnWidthSplit5 - FtWidth) / 2, p41CB_1.Y + TopAdd, ColumnWidth5 - ColumnWidthSplit5 * 2, RowHeight);
                        g.DrawString("增长率", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec1DB_1);
                        Point p11DB_1 = new Point(p41CB_1.X + (ColumnWidth5 - ColumnWidthSplit5 * 2), rec1AB.Y);
                        Point p11DB_2 = new Point(p41CB_1.X + (ColumnWidth5 - ColumnWidthSplit5 * 2), rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p11DB_1, p11DB_2);

                        Rectangle rec2DB_1 = new Rectangle(p11DB_1.X + (ColumnWidthSplit6 - FtWidth) / 2, p11DB_1.Y + TopAdd, ColumnWidthSplit6, RowHeight);
                        g.DrawString("对比前", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec2DB_1);
                        Point p21DB_1 = new Point(p11DB_1.X + ColumnWidthSplit6, rec1AB.Y);
                        Point p21DB_2 = new Point(p11DB_1.X + ColumnWidthSplit6, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p21DB_1, p21DB_2);

                        Rectangle rec3DB_1 = new Rectangle(p21DB_1.X + (ColumnWidthSplit6 - FtWidth) / 2, p21DB_1.Y + TopAdd, ColumnWidth6 - ColumnWidthSplit6 * 2, RowHeight);
                        g.DrawString("对比后", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec3DB_1);
                        Point p31DB_1 = new Point(p21DB_1.X + ColumnWidthSplit6, rec1AB.Y);
                        Point p31DB_2 = new Point(p21DB_1.X + ColumnWidthSplit6, rec1AB.Y + rec1AB.Height);
                        g.DrawLine(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.ptitle, p31DB_1, p31DB_2);

                        Rectangle rec4DB_1 = new Rectangle(p31DB_1.X + (ColumnWidthSplit6 - FtWidth) / 2, p31DB_1.Y + TopAdd, ColumnWidth6 - ColumnWidthSplit6 * 2, RowHeight);
                        g.DrawString("增长率", ft11b, LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.btitle, rec4DB_1);
                    }
                    #endregion

                    #region 内容
                    DataRow[] dtRowCount = dtOrderCount.Select("Ord_Type = '" + item.Key.ToString().Trim() + "'");
                    DataRow[] dtRowCountDb = dtOrderCountDb.Select("Ord_Type = '" + item.Key.ToString().Trim() + "'");

                    Rectangle rec1A = new Rectangle(LeftWidth, ForTopLoad + RowHeight * forCount, TableWidth, RowHeight);
                    g.DrawRectangle(p, rec1A);//画标题矩形

                    Rectangle rec1AColor1 = new Rectangle(rec1A.X + 1, rec1A.Y + 1, rec1A.Width - 1, rec1A.Height - 1);
                    if ((forCount % 2) > 0)
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brSingle, rec1AColor1); }
                    else
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brDouble, rec1AColor1); }

                    Rectangle rec1A_1 = new Rectangle(rec1A.X + 10, rec1A.Y + TopAdd, ColumnWidth1, RowHeight);
                    g.DrawString(item.Value.ToString().Trim(), ft11b, b, rec1A_1);
                    Point p11A_1 = new Point(rec1A.X + ColumnWidth1, rec1A.Y);
                    Point p11A_2 = new Point(rec1A.X + ColumnWidth1, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11A_1, p11A_2);

                    #region 选片次数
                    decimal OrderCount = 0;
                    decimal OrderCountDb = 0;
                    if (dtRowCount.Length > 0)
                    { OrderCount = Convert.ToDecimal(dtRowCount[0]["CountID"]); }
                    if (dtRowCountDb.Length > 0)
                    { OrderCountDb = Convert.ToDecimal(dtRowCountDb[0]["CountID"]); }
                    TotalOrderCount += OrderCount;
                    TotalOrderCountDb += OrderCountDb;
                    StrViewText += OrderCount + "|";
                    StrViewTextDb += OrderCountDb + "|";
                    Rectangle rec2A_1 = new Rectangle(p11A_1.X + 3, p11A_1.Y + TopAdd, ColumnWidthSplit2, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCount), ft11, b, rec2A_1);
                    Point p21A_1 = new Point(p11A_1.X + ColumnWidthSplit2, rec1A.Y);
                    Point p21A_2 = new Point(p11A_1.X + ColumnWidthSplit2, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21A_1, p21A_2);
                    SetPostionData("", item.Value.ToString(), rec2A_1, "", StrTimeStrat, StrTimeEnd);

                    Rectangle rec3A_1 = new Rectangle(p21A_1.X + 3, p21A_1.Y + TopAdd, ColumnWidthSplit2, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountDb), ft11, b, rec3A_1);
                    Point p31A_1 = new Point(p21A_1.X + ColumnWidthSplit2, rec1A.Y);
                    Point p31A_2 = new Point(p21A_1.X + ColumnWidthSplit2, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31A_1, p31A_2);
                    SetPostionData("", item.Value.ToString(), rec3A_1, "", StrTimeStratDb, StrTimeEndDb);

                    string StrPercentage = "";
                    if (OrderCountDb > 0)
                    { StrPercentage = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((OrderCount - OrderCountDb) / OrderCountDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec4A_1 = new Rectangle(p31A_1.X + 3, p31A_1.Y + TopAdd, ColumnWidth2 - ColumnWidthSplit2 * 2, RowHeight);
                    g.DrawString(StrPercentage.Trim(), ft11, b, rec4A_1);
                    Point p41A_1 = new Point(p31A_1.X + ColumnWidth2 - ColumnWidthSplit2 * 2, rec1A.Y);
                    Point p41A_2 = new Point(p31A_1.X + ColumnWidth2 - ColumnWidthSplit2 * 2, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p41A_1, p41A_2);
                    #endregion

                    #region 加挑次数
                    decimal OrderCountPuls = 0;
                    decimal OrderCountPulsDb = 0;
                    if (dtRowCount.Length > 0)
                    { OrderCountPuls = Convert.ToDecimal(dtRowCount[0]["CountPID"]); }
                    if (dtRowCountDb.Length > 0)
                    { OrderCountPulsDb = Convert.ToDecimal(dtRowCountDb[0]["CountPID"]); }
                    TotalOrderCountPuls += OrderCountPuls;
                    TotalOrderCountPulsDb += OrderCountPulsDb;
                    StrViewText += OrderCountPuls + "|";
                    StrViewTextDb += OrderCountPulsDb + "|";
                    Rectangle rec1B_1 = new Rectangle(p41A_1.X + 3, p41A_1.Y + TopAdd, ColumnWidthSplit3, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountPuls), ft11, b, rec1B_1);
                    Point p11B_1 = new Point(p41A_1.X + ColumnWidthSplit3, rec1A.Y);
                    Point p11B_2 = new Point(p41A_1.X + ColumnWidthSplit3, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11B_1, p11B_2);
                    SetPostionData("", item.Value.ToString(), rec1B_1, "", StrTimeStrat, StrTimeEnd);

                    Rectangle rec2B_1 = new Rectangle(p11B_1.X + 3, p11B_1.Y + TopAdd, ColumnWidthSplit3, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountPulsDb), ft11, b, rec2B_1);
                    Point p21B_1 = new Point(p11B_1.X + ColumnWidthSplit3, rec1A.Y);
                    Point p21B_2 = new Point(p11B_1.X + ColumnWidthSplit3, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21B_1, p21B_2);
                    SetPostionData("", item.Value.ToString(), rec2B_1, "", StrTimeStratDb, StrTimeEndDb);

                    string StrPercentage2 = "";
                    if (OrderCountPulsDb > 0)
                    { StrPercentage2 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((OrderCountPuls - OrderCountPulsDb) / OrderCountPulsDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec3B_1 = new Rectangle(p21B_1.X + 3, p21B_1.Y + TopAdd, ColumnWidth3 - ColumnWidthSplit3 * 2, RowHeight);
                    g.DrawString(StrPercentage2, ft11, b, rec3B_1);
                    Point p31B_1 = new Point(p21B_1.X + (ColumnWidth3 - ColumnWidthSplit3 * 2), rec1A.Y);
                    Point p31B_2 = new Point(p21B_1.X + (ColumnWidth3 - ColumnWidthSplit3 * 2), rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31B_1, p31B_2);
                    #endregion

                    #region 加挑率
                    decimal OrderCountAverage = 0;
                    if (OrderCountPuls > 0)
                    { OrderCountAverage = Convert.ToDecimal((OrderCountPuls / OrderCount * 100).ToString("0.00")); }
                    Rectangle rec4B_1 = new Rectangle(p31B_1.X + 3, p31B_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountAverage) + "%", ft11, b, rec4B_1);
                    Point p41B_1 = new Point(p31B_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p41B_2 = new Point(p31B_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p41B_1, p41B_2);
                    SetPostionData("", item.Value.ToString(), rec4B_1, "", StrTimeStrat, StrTimeEnd);

                    decimal OrderCountPulsAverage = 0;
                    if (OrderCountDb > 0)
                    { OrderCountPulsAverage = Convert.ToDecimal((OrderCountPulsDb / OrderCountDb * 100).ToString("0.00")); }
                    Rectangle rec1C_1 = new Rectangle(p41B_1.X + 3, p41B_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountPulsDb) + "%", ft11, b, rec1C_1);
                    Point p11C_1 = new Point(p41B_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p11C_2 = new Point(p41B_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11C_1, p11C_2);
                    SetPostionData("", item.Value.ToString(), rec1C_1, "", StrTimeStratDb, StrTimeEndDb);

                    string StrPercentage3 = "";
                    if (OrderCountPulsAverage > 0)
                    { StrPercentage3 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((OrderCountAverage - OrderCountPulsAverage) / OrderCountPulsAverage * 100).ToString("0.00")) + "%"; }
                    Rectangle rec2C_1 = new Rectangle(p11C_1.X + 3, p11C_1.Y + TopAdd, ColumnWidth4 - ColumnWidthSplit4 * 2, RowHeight);
                    g.DrawString(StrPercentage3, ft11, b, rec2C_1);
                    Point p21C_1 = new Point(p11C_1.X + (ColumnWidth4 - ColumnWidthSplit4 * 2), rec1A.Y);
                    Point p21C_2 = new Point(p11C_1.X + (ColumnWidth4 - ColumnWidthSplit4 * 2), rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21C_1, p21C_2);
                    #endregion

                    #region 加挑金额
                    decimal PlusAmount = 0;
                    decimal PlusAmountDb = 0;
                    if (dtRowCount.Length > 0)
                    {
                        if (!string.IsNullOrEmpty(dtRowCount[0]["Plu_Amount"].ToString().Trim()))
                        { PlusAmount = Convert.ToDecimal(dtRowCount[0]["Plu_Amount"]); }
                    }
                    if (dtRowCountDb.Length > 0)
                    {
                        if (!string.IsNullOrEmpty(dtRowCountDb[0]["Plu_Amount"].ToString().Trim()))
                        { PlusAmountDb = Convert.ToDecimal(dtRowCountDb[0]["Plu_Amount"]); }
                    }
                    TotalPlusAmount += PlusAmount;
                    TotalPlusAmountDb += PlusAmountDb;
                    StrViewText += PlusAmount + "|";
                    StrViewTextDb += PlusAmountDb + "|";
                    Rectangle rec3C_1 = new Rectangle(p21C_1.X + 3, p21C_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(PlusAmount), ft11, b, rec3C_1);
                    Point p31C_1 = new Point(p21C_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p31C_2 = new Point(p21C_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31C_1, p31C_2);
                    SetPostionData("", item.Value.ToString(), rec3C_1, "", StrTimeStrat, StrTimeEnd);

                    Rectangle rec4C_1 = new Rectangle(p31C_1.X + 3, p31C_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(PlusAmountDb), ft11, b, rec4C_1);
                    Point p41C_1 = new Point(p31C_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p41C_2 = new Point(p31C_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p41C_1, p41C_2);
                    SetPostionData("", item.Value.ToString(), rec4C_1, "", StrTimeStratDb, StrTimeEndDb);

                    string StrPercentage4 = "";
                    if (PlusAmountDb > 0)
                    { StrPercentage4 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((PlusAmount - PlusAmountDb) / PlusAmountDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec1D_1 = new Rectangle(p41C_1.X + 3, p41C_1.Y + TopAdd, ColumnWidth5 - ColumnWidthSplit5 * 2, RowHeight);
                    g.DrawString(StrPercentage4, ft11, b, rec1D_1);
                    Point p11D_1 = new Point(p41C_1.X + (ColumnWidth5 - ColumnWidthSplit5 * 2), rec1A.Y);
                    Point p11D_2 = new Point(p41C_1.X + (ColumnWidth5 - ColumnWidthSplit5 * 2), rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11D_1, p11D_2);
                    #endregion

                    #region 加挑均值
                    decimal AverageValue = PlusAmount - OrderCountPuls;
                    decimal AverageValueDb = PlusAmountDb - OrderCountPulsDb;
                    StrViewText += AverageValue + "|";
                    StrViewTextDb += AverageValueDb + "|";
                    Rectangle rec2D_1 = new Rectangle(p11D_1.X + 3, p11D_1.Y + TopAdd, ColumnWidthSplit6, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(AverageValue), ft11, b, rec2D_1);
                    Point p21D_1 = new Point(p11D_1.X + ColumnWidthSplit6, rec1A.Y);
                    Point p21D_2 = new Point(p11D_1.X + ColumnWidthSplit6, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21D_1, p21D_2);
                    SetPostionData("", item.Value.ToString(), rec2D_1, "", StrTimeStrat, StrTimeEnd);

                    Rectangle rec3D_1 = new Rectangle(p21D_1.X + 3, p21D_1.Y + TopAdd, ColumnWidth6 - ColumnWidthSplit6 * 2, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(AverageValueDb), ft11, b, rec3D_1);
                    Point p31D_1 = new Point(p21D_1.X + ColumnWidthSplit6, rec1A.Y);
                    Point p31D_2 = new Point(p21D_1.X + ColumnWidthSplit6, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31D_1, p31D_2);
                    SetPostionData("", item.Value.ToString(), rec3D_1, "", StrTimeStratDb, StrTimeEndDb);

                    string StrPercentage5 = "";
                    if (AverageValueDb > 0)
                    { StrPercentage5 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((AverageValue - AverageValueDb) / AverageValueDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec4D_1 = new Rectangle(p31D_1.X + 3, p31D_1.Y + TopAdd, ColumnWidth6 - ColumnWidthSplit6 * 2, RowHeight);
                    g.DrawString(StrPercentage5, ft11, b, rec4D_1);
                    #endregion
                    forCount++;
                    #endregion

                    htDataView[item.Value.ToString().Trim()] = StrViewText.TrimEnd('|');
                    htDataViewDb[item.Value.ToString().Trim()] = StrViewTextDb.TrimEnd('|');
                }
                if (htData.Count > 1)
                {
                    this.panelEx3.Visible = true;
                    this.panelEx2.Dock = DockStyle.Top;
                    #region 总结
                    Rectangle rec1A = new Rectangle(LeftWidth, ForTopLoad + RowHeight * htData.Count, TableWidth, RowHeight);
                    g.DrawRectangle(p, rec1A);//画标题矩形

                    Rectangle rec1AColor1 = new Rectangle(rec1A.X + 1, rec1A.Y + 1, rec1A.Width - 1, rec1A.Height - 1);
                    if ((htData.Count % 2) > 0)
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brSingle, rec1AColor1); }
                    else
                    { g.FillRectangle(LYFZ.Software.MainBusiness.DoorCityProcess.PublicGraphics.brDouble, rec1AColor1); }

                    Rectangle rec1A_1 = new Rectangle(rec1A.X + 10, rec1A.Y + TopAdd, ColumnWidth1, RowHeight);
                    g.DrawString("总" + StrTypeTextNull + "计", ft11b, b, rec1A_1);
                    Point p11A_1 = new Point(rec1A.X + ColumnWidth1, rec1A.Y);
                    Point p11A_2 = new Point(rec1A.X + ColumnWidth1, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11A_1, p11A_2);

                    #region 选片次数
                    Rectangle rec2A_1 = new Rectangle(p11A_1.X + 3, p11A_1.Y + TopAdd, ColumnWidthSplit2, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalOrderCount), ft11, b, rec2A_1);
                    Point p21A_1 = new Point(p11A_1.X + ColumnWidthSplit2, rec1A.Y);
                    Point p21A_2 = new Point(p11A_1.X + ColumnWidthSplit2, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21A_1, p21A_2);

                    Rectangle rec3A_1 = new Rectangle(p21A_1.X + 3, p21A_1.Y + TopAdd, ColumnWidthSplit2, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalOrderCountDb), ft11, b, rec3A_1);
                    Point p31A_1 = new Point(p21A_1.X + ColumnWidthSplit2, rec1A.Y);
                    Point p31A_2 = new Point(p21A_1.X + ColumnWidthSplit2, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31A_1, p31A_2);

                    string StrPercentage = "";
                    if (TotalOrderCountDb > 0)
                    { StrPercentage = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((TotalOrderCount - TotalOrderCountDb) / TotalOrderCountDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec4A_1 = new Rectangle(p31A_1.X + 3, p31A_1.Y + TopAdd, ColumnWidth2 - ColumnWidthSplit2 * 2, RowHeight);
                    g.DrawString(StrPercentage.Trim(), ft11, b, rec4A_1);
                    Point p41A_1 = new Point(p31A_1.X + ColumnWidth2 - ColumnWidthSplit2 * 2, rec1A.Y);
                    Point p41A_2 = new Point(p31A_1.X + ColumnWidth2 - ColumnWidthSplit2 * 2, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p41A_1, p41A_2);
                    #endregion

                    #region 加挑次数
                    Rectangle rec1B_1 = new Rectangle(p41A_1.X + 3, p41A_1.Y + TopAdd, ColumnWidthSplit3, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalOrderCountPuls), ft11, b, rec1B_1);
                    Point p11B_1 = new Point(p41A_1.X + ColumnWidthSplit3, rec1A.Y);
                    Point p11B_2 = new Point(p41A_1.X + ColumnWidthSplit3, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11B_1, p11B_2);

                    Rectangle rec2B_1 = new Rectangle(p11B_1.X + 3, p11B_1.Y + TopAdd, ColumnWidthSplit3, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalOrderCountPulsDb), ft11, b, rec2B_1);
                    Point p21B_1 = new Point(p11B_1.X + ColumnWidthSplit3, rec1A.Y);
                    Point p21B_2 = new Point(p11B_1.X + ColumnWidthSplit3, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21B_1, p21B_2);

                    string StrPercentage2 = "";
                    if (TotalOrderCountPulsDb > 0)
                    { StrPercentage2 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((TotalOrderCountPuls - TotalOrderCountPulsDb) / TotalOrderCountPulsDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec3B_1 = new Rectangle(p21B_1.X + 3, p21B_1.Y + TopAdd, ColumnWidth3 - ColumnWidthSplit3 * 2, RowHeight);
                    g.DrawString(StrPercentage2, ft11, b, rec3B_1);
                    Point p31B_1 = new Point(p21B_1.X + (ColumnWidth3 - ColumnWidthSplit3 * 2), rec1A.Y);
                    Point p31B_2 = new Point(p21B_1.X + (ColumnWidth3 - ColumnWidthSplit3 * 2), rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31B_1, p31B_2);
                    #endregion

                    #region 加挑率
                    decimal OrderCountAverage = 0;
                    if (TotalOrderCount > 0)
                    { OrderCountAverage = Convert.ToDecimal((TotalOrderCountPuls / TotalOrderCount * 100).ToString("#.00")); }
                    Rectangle rec4B_1 = new Rectangle(p31B_1.X + 3, p31B_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountAverage) + "%", ft11, b, rec4B_1);
                    Point p41B_1 = new Point(p31B_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p41B_2 = new Point(p31B_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p41B_1, p41B_2);

                    decimal OrderCountPulsAverage = 0;
                    if (TotalOrderCountDb > 0)
                    { OrderCountPulsAverage = Convert.ToDecimal((TotalOrderCountPulsDb / TotalOrderCountDb * 100).ToString("0.00")); }
                    Rectangle rec1C_1 = new Rectangle(p41B_1.X + 3, p41B_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(OrderCountPulsAverage) + "%", ft11, b, rec1C_1);
                    Point p11C_1 = new Point(p41B_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p11C_2 = new Point(p41B_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11C_1, p11C_2);

                    string StrPercentage3 = "";
                    if (OrderCountPulsAverage > 0)
                    { StrPercentage3 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((OrderCountAverage - OrderCountPulsAverage) / OrderCountPulsAverage * 100).ToString("0.00")) + "%"; }
                    Rectangle rec2C_1 = new Rectangle(p11C_1.X + 3, p11C_1.Y + TopAdd, ColumnWidth4 - ColumnWidthSplit4 * 2, RowHeight);
                    g.DrawString(StrPercentage3, ft11, b, rec2C_1);
                    Point p21C_1 = new Point(p11C_1.X + (ColumnWidth4 - ColumnWidthSplit4 * 2), rec1A.Y);
                    Point p21C_2 = new Point(p11C_1.X + (ColumnWidth4 - ColumnWidthSplit4 * 2), rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21C_1, p21C_2);
                    #endregion

                    #region 加挑金额
                    Rectangle rec3C_1 = new Rectangle(p21C_1.X + 3, p21C_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalPlusAmount), ft11, b, rec3C_1);
                    Point p31C_1 = new Point(p21C_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p31C_2 = new Point(p21C_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31C_1, p31C_2);

                    Rectangle rec4C_1 = new Rectangle(p31C_1.X + 3, p31C_1.Y + TopAdd, ColumnWidthSplit4, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalPlusAmountDb), ft11, b, rec4C_1);
                    Point p41C_1 = new Point(p31C_1.X + ColumnWidthSplit4, rec1A.Y);
                    Point p41C_2 = new Point(p31C_1.X + ColumnWidthSplit4, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p41C_1, p41C_2);

                    string StrPercentage4 = "";
                    if (TotalPlusAmountDb > 0)
                    { StrPercentage4 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((TotalPlusAmount - TotalPlusAmountDb) / TotalPlusAmountDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec1D_1 = new Rectangle(p41C_1.X + 3, p41C_1.Y + TopAdd, ColumnWidth5 - ColumnWidthSplit5 * 2, RowHeight);
                    g.DrawString(StrPercentage4, ft11, b, rec1D_1);
                    Point p11D_1 = new Point(p41C_1.X + (ColumnWidth5 - ColumnWidthSplit5 * 2), rec1A.Y);
                    Point p11D_2 = new Point(p41C_1.X + (ColumnWidth5 - ColumnWidthSplit5 * 2), rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p11D_1, p11D_2);
                    #endregion

                    #region 加挑均值
                    decimal TotalAverageValue = 0;
                    if (TotalOrderCountPuls > 0)
                    { TotalAverageValue = (TotalPlusAmount / TotalOrderCountPuls); }
                    Rectangle rec2D_1 = new Rectangle(p11D_1.X + 3, p11D_1.Y + TopAdd, ColumnWidthSplit6, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalAverageValue.ToString("0.00")), ft11, b, rec2D_1);
                    Point p21D_1 = new Point(p11D_1.X + ColumnWidthSplit6, rec1A.Y);
                    Point p21D_2 = new Point(p11D_1.X + ColumnWidthSplit6, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p21D_1, p21D_2);

                    decimal TotalAverageValueDb = 0;
                    if (TotalOrderCountPulsDb > 0)
                    { TotalAverageValueDb = (TotalPlusAmountDb / TotalOrderCountPulsDb); }
                    Rectangle rec3D_1 = new Rectangle(p21D_1.X + 3, p21D_1.Y + TopAdd, ColumnWidth5 - ColumnWidthSplit6 * 2, RowHeight);
                    g.DrawString(LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(TotalAverageValueDb.ToString("0.00")), ft11, b, rec3D_1);
                    Point p31D_1 = new Point(p21D_1.X + ColumnWidthSplit6, rec1A.Y);
                    Point p31D_2 = new Point(p21D_1.X + ColumnWidthSplit6, rec1A.Y + rec1A.Height);
                    g.DrawLine(p, p31D_1, p31D_2);

                    string StrPercentage5 = "";
                    if (TotalAverageValueDb > 0)
                    { StrPercentage5 = LYFZ.BLL.OtherCommonModel.RemoveLastExcessZero(((TotalAverageValue - TotalAverageValueDb) / TotalAverageValueDb * 100).ToString("0.00")) + "%"; }
                    Rectangle rec4D_1 = new Rectangle(p31D_1.X + 3, p31D_1.Y + TopAdd, ColumnWidth5 - ColumnWidthSplit6 * 2, RowHeight);
                    g.DrawString(StrPercentage5, ft11, b, rec4D_1);
                    #endregion
                    #endregion
                }
                else
                {
                    this.panelEx3.Visible = false;
                    this.panelEx2.Dock = DockStyle.Fill;
                }
                #endregion
            }
            this.PictImage.Image = newBmp;

            this.PublicFunctionView();
        }
        /// <summary>
        /// 创建图表
        /// </summary>
        private void PublicFunctionView()
        {
            this.chart1.Titles.Clear();
            this.chart1.Series.Clear();
            this.chart2.Series.Clear();
            this.chart2.Titles.Clear();
            Series tempseries = null;
            if (this.htDataView.Count > 1)
            {
                #region 无启用对比
                if (this.cmbtreevDisplayMethod.Tag.ToString().Trim() == "Column")
                {
                    this.chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = false;
                    #region 柱状图
                    this.chart1.Legends["Legend1"].Enabled = true;
                    int forCount = 0;
                    foreach (DictionaryEntry item in htDataView)
                    {
                        string[] StrArray = item.Value.ToString().Trim().Split('|');
                        string StrValue = StrArray[Convert.ToInt32(this.cmbtreevDisplayItem.Tag)].Trim();
                        if (Convert.ToDecimal(StrValue) != 0)
                        {
                            tempseries = new Series(item.Key.ToString().Trim());
                            tempseries.ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), this.cmbtreevDisplayMethod.Tag.ToString());
                            this.chart1.Series.Add(tempseries);
                            this.chart1.Series[forCount].Color = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.myChartsColor[forCount];
                            this.chart1.Series[forCount].Points.Clear();
                            this.chart1.Series[forCount].ToolTip = item.Key.ToString().Trim();
                            this.chart1.ChartAreas["ChartArea1"].AxisX.Interval = htDataView.Count;//x轴数据显示间隔

                            tempseries.Points.AddXY("0", StrValue);
                            if (Convert.ToDecimal(StrValue) > 0)
                            { tempseries.Points[0].IsValueShownAsLabel = true; }
                            forCount++;
                        }
                    }
                    #endregion
                }
                else if (this.cmbtreevDisplayMethod.Tag.ToString().Trim() == "Pie")
                {
                    this.chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                    #region 饼形图
                    if (this.chkComparedStartUp.Checked)
                    {
                        string StrTitlesDb = this.dtDataTimeStart.DateValue.Trim() + " — " + this.dtDataTimeEnd.DateValue.Trim() + " 图表";
                        this.chart1.Titles.Add(StrTitlesDb);
                    }
                    this.chart1.Legends["Legend1"].Enabled = true;
                    tempseries = new Series();
                    tempseries.ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), this.cmbtreevDisplayMethod.Tag.ToString());
                    this.chart1.Series.Add(tempseries);
                    this.chart1.Series[0]["PieLabelStyle"] = "Outside";//将文字移到外侧
                    this.chart1.Series[0]["PieLineColor"] = "Black";//绘制黑色的连线。

                    List<string> xData = new List<string>();
                    List<double> yData = new List<double>();
                    int forCount = 0;
                    foreach (DictionaryEntry item in htDataView)
                    {
                        string[] StrArray = item.Value.ToString().Trim().Split('|');
                        string StrValue = StrArray[Convert.ToInt32(this.cmbtreevDisplayItem.Tag)].Trim();
                        if (Convert.ToDecimal(StrValue) != 0)
                        {
                            this.chart1.Series[0].Color = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.myChartsColor[forCount];
                            this.chart1.Series[0].Points.Clear();
                            this.chart1.Series[0].ToolTip = item.Key.ToString().Trim()+ "：" + StrValue;
                            xData.Add(item.Key.ToString().Trim() + "：" + StrValue);
                            yData.Add(Convert.ToDouble(StrValue));
                            forCount++;
                        }
                    }
                    this.chart1.Series[0].Points.DataBindXY(xData, yData);
                    #endregion
                }
                #endregion
            }
            if (this.chkComparedStartUp.Checked)
            {
                if (this.htDataViewDb.Count > 1)
                {
                    #region 启用对比
                    if (this.cmbtreevDisplayMethod.Tag.ToString().Trim() == "Column")
                    {
                        this.chart2.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = false;
                        #region 柱状图
                        this.chart2.Legends["Legend1"].Enabled = true;
                        int forCount = 0;
                        foreach (DictionaryEntry item in htDataViewDb)
                        {
                            string[] StrArray = item.Value.ToString().Trim().Split('|');
                            string StrValue = StrArray[Convert.ToInt32(this.cmbtreevDisplayItem.Tag)].Trim();
                            if (Convert.ToDecimal(StrValue) != 0)
                            {
                                tempseries = new Series(item.Key.ToString().Trim());
                                tempseries.ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), this.cmbtreevDisplayMethod.Tag.ToString());
                                this.chart2.Series.Add(tempseries);
                                this.chart2.Series[forCount].Color = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.myChartsColor[forCount];
                                this.chart2.Series[forCount].Points.Clear();
                                this.chart2.Series[forCount].ToolTip = item.Key.ToString().Trim();
                                this.chart2.ChartAreas["ChartArea1"].AxisX.Interval = htDataViewDb.Count;//x轴数据显示间隔

                                tempseries.Points.AddXY("0", StrValue);
                                if (Convert.ToDecimal(StrValue) > 0)
                                { tempseries.Points[0].IsValueShownAsLabel = true; }
                                forCount++;
                            }
                        }
                        #endregion
                    }
                    else if (this.cmbtreevDisplayMethod.Tag.ToString().Trim() == "Pie")
                    {
                        this.chart2.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
                        #region 饼形图
                        string StrTitlesDb = this.dtDataTimeStartCompared.DateValue.Trim() + " — " + this.dtDateTimeEndCompared.DateValue.Trim() + " 图表";
                        this.chart2.Titles.Add(StrTitlesDb);
                        this.chart2.Legends["Legend1"].Enabled = false;
                        tempseries = new Series();
                        tempseries.ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), this.cmbtreevDisplayMethod.Tag.ToString());
                        this.chart2.Series.Add(tempseries);
                        this.chart2.Series[0]["PieLabelStyle"] = "Outside";//将文字移到外侧
                        this.chart2.Series[0]["PieLineColor"] = "Black";//绘制黑色的连线。

                        List<string> xData = new List<string>();
                        List<double> yData = new List<double>();
                        int forCount = 0;
                        foreach (DictionaryEntry item in htDataViewDb)
                        {
                            string[] StrArray = item.Value.ToString().Trim().Split('|');
                            string StrValue = StrArray[Convert.ToInt32(this.cmbtreevDisplayItem.Tag)].Trim();
                            if (Convert.ToDecimal(StrValue) != 0)
                            {
                                this.chart2.Series[0].Color = LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.myChartsColor[forCount];
                                this.chart2.Series[0].Points.Clear();
                                this.chart2.Series[0].ToolTip = item.Key.ToString().Trim()+ "：" + StrValue;
                                xData.Add(item.Key.ToString().Trim() + "：" + StrValue);
                                yData.Add(Convert.ToDouble(StrValue));
                                forCount++;
                            }
                        }
                        this.chart2.Series[0].Points.DataBindXY(xData, yData);
                        #endregion
                    }
                    #endregion
                }
            }
        }
    }
}