MES_Client/TGMES/Core.StlMes.Client.BuyBillet/RptProductionVelocity.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.SA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Tool;
//using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinTree;
using Infragistics.Win.UltraWinChart;
using CoreFS.CA06;
using System.Net;
using Infragistics.UltraChart.Shared.Styles;
using Infragistics.UltraChart.Resources.Appearance;
using Infragistics.UltraChart.Core.Layers;


using System.Collections;

namespace Core.StlMes.Client.BuyBillet
{
    public partial class RptProductionVelocity : FrmBase
    {

        private string[] columnchartpoint, piechartpoint, columnchartpoint_qj;
        private bool isnew = false, isnew_qj = false;
        private DataTable kfdataTable, dtqry1, kfdataTable_qj;
        private int days;
        private Dictionary<string, Color> sclsdrcorlorsdictionary = new Dictionary<string, Color>();
        private Dictionary<string, Color> mycorlorsdictionary = new Dictionary<string, Color>();
        private Dictionary<string, string> mynamedictionary = new Dictionary<string, string>();
        private int myLineThickness = 3;
        public RptProductionVelocity()
        {
            InitializeData();
            InitializeComponent();
        }

        private void RptProductionVelocity_Load(object sender, EventArgs e)
        {
            this.rptdate.Value = DateTime.Today;
            this.todate.Value = DateTime.Today;
            this.fromdate.Value = DateTime.Today.AddYears(-1);
            sclskf_month.Value = DateTime.Today;
            if (DateTime.Today.Day == 1)
            {
                scls_fromdate.Value = DateTime.Today.AddDays(-1);
            }
            else
            {
                scls_fromdate.Value = DateTime.Today.AddDays(-DateTime.Today.Day + 1);
            }
            this.scls_todate.Value = DateTime.Today;

            //getchart();
            //getpiechart();
            //kfdata = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_KF", new object[] {}, this.ob);
        }

       

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":
                    if (ultraTabControl1.ActiveTab.Key == "scls")
                    {
                        getscls();
                    }
                    else if (ultraTabControl1.ActiveTab.Key == "scls_qj")
                    {
                        //getcharttest();
                        getscls_qj();
                    }
                    else if (ultraTabControl1.ActiveTab.Key == "scls_kf")
                    {
                        getscls_kf();
                    }
                    else if (ultraTabControl1.ActiveTab.Key == "sczq")
                    {
                        getsczq();
                    }
                    else if (ultraTabControl1.ActiveTab.Key == "htzq")
                    {
                        gethtzq();
                    }
                    break;
                case "Export":
                    Export();
                    break;
                case "Close":
                    this.Close();
                    break;

            }
        }

        private void InitializeData()
        {
            mycorlorsdictionary.Add("DC", Color.Aqua);
            mycorlorsdictionary.Add("QX", Color.Blue);
            mycorlorsdictionary.Add("DSP", Color.Yellow);
            mycorlorsdictionary.Add("DPD", Color.Gold);
            mycorlorsdictionary.Add("LXWT", Color.Fuchsia);
            mycorlorsdictionary.Add("LXFX", Color.Red);
            mycorlorsdictionary.Add("FP", Color.Chocolate);
            mycorlorsdictionary.Add("PJ", Color.Green);

            mynamedictionary.Add("DC", "待产");
            mynamedictionary.Add("QX", "清线");
            mynamedictionary.Add("DSP", "待判（未送判）");
            mynamedictionary.Add("DPD", "待判（未判定）");
            mynamedictionary.Add("LXWT", "离线（未委托）");
            mynamedictionary.Add("LXFX", "离线（未返线）");
            mynamedictionary.Add("FP", "废品");
            mynamedictionary.Add("PJ", "平均");

            sclsdrcorlorsdictionary.Add("1", Color.YellowGreen);
            sclsdrcorlorsdictionary.Add("2", Color.DodgerBlue);
            sclsdrcorlorsdictionary.Add("3", Color.LightYellow);
            sclsdrcorlorsdictionary.Add("4", Color.Orange);
            sclsdrcorlorsdictionary.Add("5", Color.Red);

        }

        private void getcharttest()
        {
            UltraChart_scls_qj.Visible = true;
            DataTable dt = new DataTable();
            dt.Columns.Add("Date", typeof(string));
            dt.Columns.Add("2009-08-03", typeof(double));
            dt.Columns.Add("2009-08-04", typeof(double));
            dt.Columns.Add("2009-08-05", typeof(double));
            dt.Columns.Add("2009-08-06", typeof(double));
            dt.Columns.Add("2009-08-07", typeof(double));
            // dt.Columns.Add("Rating", typeof(double));


            dt.Rows.Add(new object[] { "待产", 100, 80, 90, 70, 117 });
            dt.Rows.Add(new object[] { "清线", 0, 40, 50, 100, 60 });
            /* dt.Rows.Add(new object[] { "2009-08-04"});
             dt.Rows.Add(new object[] { "2009-08-05"});
             dt.Rows.Add(new object[] { "2009-08-06"});
             dt.Rows.Add(new object[] { "2009-08-07"});*/
            /*
            dt.Rows.Add(new object[] { "2009-08-03", 119, 2 });
            dt.Rows.Add(new object[] { "2009-08-04", 118, 3 });
            dt.Rows.Add(new object[] { "2009-08-05", 117, 2 });
            dt.Rows.Add(new object[] { "2009-08-06", 119, 2 });
            dt.Rows.Add(new object[] { "2009-08-07", 117, 3 });*/

            UltraChart_scls_qj.ChartType = ChartType.LineChart; ;


            UltraChart_scls_qj.Data.DataSource = dt;
            UltraChart_scls_qj.Data.IncludeColumn(0, false);


            UltraChart_scls_qj.Axis.X.Labels.Orientation = TextOrientation.Custom;
            UltraChart_scls_qj.Axis.X.Labels.OrientationAngle = 80;
            UltraChart_scls_qj.Axis.X.Labels.VerticalAlign = StringAlignment.Far;


            UltraChart_scls_qj.Axis.X2.Visible = false;
            UltraChart_scls_qj.Data.DataBind();

        }
        private void mytest()
        {
            UltraChart_scls_qj.Visible = true;
            UltraChart_scls_qj.ChartType = ChartType.Composite;

            NumericSeries stackSeries1 = new NumericSeries();
            stackSeries1.Label = "Stack One";
            stackSeries1.Points.Add(new NumericDataPoint(1.0, "A", false));
            stackSeries1.Points.Add(new NumericDataPoint(2.0, "B", false));
            stackSeries1.Points.Add(new NumericDataPoint(3.0, "C", false));

            NumericSeries stackSeries2 = new NumericSeries();
            stackSeries2.Label = "Stack Two";
            stackSeries2.Points.Add(new NumericDataPoint(4.0, "D", false));
            stackSeries2.Points.Add(new NumericDataPoint(5.0, "E", false));
            stackSeries2.Points.Add(new NumericDataPoint(6.0, "F", false));

            NumericSeries lineSeries1 = new NumericSeries();
            lineSeries1.Points.Add(new NumericDataPoint(7.0, "G", false));
            lineSeries1.Points.Add(new NumericDataPoint(8.0, "H", false));
            lineSeries1.Points.Add(new NumericDataPoint(9.0, "I", false));

            NumericSeries lineSeries2 = new NumericSeries();
            lineSeries2.Points.Add(new NumericDataPoint(8.0, "J", false));
            lineSeries2.Points.Add(new NumericDataPoint(7.0, "K", false));
            lineSeries2.Points.Add(new NumericDataPoint(6.0, "L", false));

            ChartArea area = new ChartArea();

            AxisItem xAxisForStackBar = new AxisItem();
            xAxisForStackBar.OrientationType = AxisNumber.X_Axis;
            xAxisForStackBar.DataType = AxisDataType.Numeric;
            xAxisForStackBar.Extent = 10;
            xAxisForStackBar.Labels.ItemFormatString = "<DATA_VALUE:0.0>";
            xAxisForStackBar.TickmarkStyle = AxisTickStyle.Smart;

            AxisItem yAxisForStackBar = new AxisItem();
            yAxisForStackBar.OrientationType = AxisNumber.Y_Axis;
            yAxisForStackBar.DataType = AxisDataType.String;
            yAxisForStackBar.SetLabelAxisType = SetLabelAxisType.GroupBySeries;
            yAxisForStackBar.Labels.SeriesLabels.FormatString = "<SERIES_LABEL>";

            AxisItem xAxisForLine = new AxisItem();
            xAxisForLine.OrientationType = AxisNumber.X_Axis;
            xAxisForLine.DataType = AxisDataType.String;
            xAxisForLine.SetLabelAxisType = SetLabelAxisType.ContinuousData;
            xAxisForLine.Labels.ItemFormatString = "<ITEM_LABEL>";


            AxisItem yAxisForLine = new AxisItem();
            yAxisForLine.OrientationType = AxisNumber.Y_Axis;
            yAxisForLine.DataType = AxisDataType.Numeric;
            yAxisForLine.Extent = 10;
            yAxisForLine.Labels.ItemFormatString = "<DATA_VALUE:0.0>";
            yAxisForLine.TickmarkStyle = AxisTickStyle.Smart;

            area.Axes.Add(xAxisForStackBar);
            area.Axes.Add(yAxisForStackBar);
            area.Axes.Add(xAxisForLine);
            area.Axes.Add(yAxisForLine);

            ChartLayerAppearance stackBarLayer = new ChartLayerAppearance();
            stackBarLayer.ChartType = ChartType.StackBarChart;
            stackBarLayer.Series.Add(stackSeries1);
            stackBarLayer.Series.Add(stackSeries2);
            stackBarLayer.ChartArea = area;
            stackBarLayer.AxisX = xAxisForStackBar;
            stackBarLayer.AxisY = yAxisForStackBar;

            ChartLayerAppearance lineLayer = new ChartLayerAppearance();
            lineLayer.ChartType = ChartType.LineChart;
            lineLayer.Series.Add(lineSeries1);
            lineLayer.Series.Add(lineSeries2);
            lineLayer.ChartArea = area;
            lineLayer.AxisX = xAxisForLine;
            lineLayer.AxisY = yAxisForLine;

            UltraChart_scls_qj.CompositeChart.ChartAreas.Add(area);
            UltraChart_scls_qj.CompositeChart.ChartLayers.Add(stackBarLayer);
            UltraChart_scls_qj.CompositeChart.ChartLayers.Add(lineLayer);
        }
        private void Export()
        {
            if (ultraTabControl1.ActiveTab.Key == "scls")
            {
                string title = "生产流速——";
                if (rB_dc.Checked)
                {
                    title += rB_dc.Text;
                }
                else if (rB_qx.Checked)
                {
                    title += rB_qx.Text;
                }
                else if (rB_dpsp.Checked)
                {
                    title += rB_dpsp.Text;
                }
                else if (rB_dppd.Checked)
                {
                    title += rB_dppd.Text;
                }
                else if (rB_lxwt.Checked)
                {
                    title += rB_lxwt.Text;
                }
                else if (rB_lxfx.Checked)
                {
                    title += rB_lxfx.Text;
                }
                else if (rB_fp.Checked)
                {
                    title += rB_fp.Text;
                }
                GridHelper.ulGridToExcel(ultraGrid_scls, title);

            }
            else if (ultraTabControl1.ActiveTab.Key == "scls_kf")
            {
                string title = "生产流速——";
                title += "扣分表";
                GridHelper.ulGridToExcel(ultraGrid_scls_kf, title);
            }
            else if (ultraTabControl1.ActiveTab.Key == "sczq" && ultraTabControl2.ActiveTab.Key == "tab_pz")
            {
                GridHelper.ulGridToExcel(ultraGrid_pzwl, "生产周期(品种)");
            }
            else if (ultraTabControl1.ActiveTab.Key == "sczq" && ultraTabControl2.ActiveTab.Key == "tab_wl")
            {
                GridHelper.ulGridToExcel(ultraGrid_pzwl, "生产周期(物料)");
            }
            else if (ultraTabControl1.ActiveTab.Key == "sczq" && ultraTabControl2.ActiveTab.Key == "tab_pzwl")
            {
                GridHelper.ulGridToExcel(ultraGrid_pzwl, "生产周期(品种+物料)");
            }
            else if (ultraTabControl1.ActiveTab.Key == "htzq")
            {
                GridHelper.ulGridToExcel(ultraGrid_htzq, ultraTabControl1.ActiveTab.Text);
            }
            else
            {
                MessageBox.Show("没有要导出的数据！");
            }
        }

        private void getsczq()
        {
            WaitingForm2 wf = new WaitingForm2("正在加载数据,请稍候....");
            try
            {
                string mydate1 = ((DateTime)this.fromdate.Value).ToString("yyyy-MM-dd");
                string mydate2 = ((DateTime)this.todate.Value).ToString("yyyy-MM-dd");
                if (ultraTabControl2.ActiveTab.Key == "tab_pz")
                {
                    if (dataTable3.Rows.Count > 0)
                        dataTable3.Rows.Clear();
                    /*ultraGrid_pzwl.Visible = false;
                    ultraGrid_wl.Visible = false;
                    ultraGrid_pz.Dock = DockStyle.Fill;
                    ultraGrid_pz.Visible = true;*/
                    DataTable dtqry1 = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_SCLS_PZ", new object[] { mydate1, mydate2 }, this.ob);
                    GridHelper.CopyDataToDatatable(ref dtqry1, ref dataTable3, true);
                    RefreshSetting(ultraGrid_pz, ((DateTime)this.rptdate.Value).ToString("yyyy年M月d日"));
                }
                else if (ultraTabControl2.ActiveTab.Key == "tab_wl")
                {
                    if (dataTable4.Rows.Count > 0)
                        dataTable4.Rows.Clear();
                    /*ultraGrid_pz.Visible = false;
                    ultraGrid_pzwl.Visible = false;
                    ultraGrid_wl.Dock = DockStyle.Fill;
                    ultraGrid_wl.Visible = true;*/
                    DataTable dtqry2 = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_SCLS_WL", new object[] { mydate1, mydate2 }, this.ob);
                    GridHelper.CopyDataToDatatable(ref dtqry2, ref this.dataTable4, true);
                    RefreshSetting(ultraGrid_wl, ((DateTime)this.rptdate.Value).ToString("yyyy年M月d日"));
                }
                else if (ultraTabControl2.ActiveTab.Key == "tab_pzwl")
                {
                    if (dataTable2.Rows.Count > 0)
                        dataTable2.Rows.Clear();
                    if (dataTable1.Rows.Count > 0)
                        dataTable1.Rows.Clear();
                    /*ultraGrid_pz.Visible = false;
                    ultraGrid_wl.Visible = false;
                    ultraGrid_pzwl.Dock = DockStyle.Fill;
                    ultraGrid_pzwl.Visible = true;*/
                    DataTable dtqry1 = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_SCLS_PZ", new object[] { mydate1, mydate2 }, this.ob);
                    DataTable dtqry2 = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_SCLS_WL", new object[] { mydate1, mydate2 }, this.ob);
                    GridHelper.CopyDataToDatatable(ref dtqry1, ref this.dataTable1, true);
                    GridHelper.CopyDataToDatatable(ref dtqry2, ref this.dataTable2, true);
                    RefreshSetting(ultraGrid_pzwl, ((DateTime)this.rptdate.Value).ToString("yyyy年M月d日"));
                }
                wf.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                wf.Close();
            }
        }
        public static void RefreshSetting(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid, string mydate)
        {
            ultraGrid.DataBind();

            foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
            {
                //band.Header.Caption = "生产周期";
                foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                {
                    if (column.Key != "material_no" && column.Key != "material_name")
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                }
                if (band.Key == "Table2" || band.Key == "Relation1")
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in band.GetRowEnumerator(Infragistics.Win.UltraWinGrid.GridRowType.DataRow))
                    {
                        if (row.Cells["material_no"].Text != "")
                        {
                            row.Cells["material_no"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.Button;
                            row.Cells["material_no"].ButtonAppearance.Cursor = Cursors.Hand;
                            row.Cells["material_no"].ToolTipText = "点击查看炉数据！";
                        }
                    }
                }
            }

            ultraGrid.Refresh();

        }
        private void getscls_kf()
        {
            string mydate1 = ((DateTime)this.sclskf_month.Value).ToString("yyyy-MM-") + "01";
            days = (DateTime.DaysInMonth(((DateTime)this.sclskf_month.Value).Year, ((DateTime)this.sclskf_month.Value).Month));
            string mydate2 = ((DateTime)this.sclskf_month.Value).ToString("yyyy-MM-") + Convert.ToString(100 + days).Substring(1, 2);


            WaitingForm2 wf = new WaitingForm2("正在加载数据,请稍候....");
            try
            {
                if (dataTable6.Rows.Count > 0)
                    dataTable6.Rows.Clear();
                if (dataTable5.Rows.Count > 0)
                    dataTable5.Rows.Clear();

                string mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_TotalKF";
                DataTable dtqry1 = new DataTable();

                dtqry1 = ServerHelper.GetData(mymethodid, new object[] { mydate1, mydate2 }, this.ob);
                DataTable dtqry = dtqry1.Clone();
                dtqry.Columns["kf"].DataType = typeof(decimal);
                dtqry.Columns["qz"].DataType = typeof(decimal);
                dtqry.Columns["kfqz"].DataType = typeof(decimal);
                foreach (DataRow dr in dtqry1.Rows)
                {
                    dtqry.ImportRow(dr);
                }

                DataTable dtqrytotalkf = dataTable5.Clone();
                DataView dvtotalkf = dtqry.DefaultView;
                dvtotalkf.Sort = "area_code";
                DataTable dttotal = dvtotalkf.ToTable(true, "area");//注：其中ToTable（）的第一个参数为是否DISTINCT
                DataTable dtqrydetailkf = dataTable6.Clone();
                DataView dvdetail = dtqry.DefaultView;
                dvdetail.Sort = "area_code,dept,processcode,pline_name";
                DataTable dtdetail = dvdetail.ToTable(true, "area", "dept", "processcode", "pline_name");//注：其中ToTable（）的第一个参数为是否DISTINCT

                if (dttotal.Rows.Count == 0)
                {
                    MessageBox.Show("没有查到数据！");
                }
                else
                {
                    DataView dvcreatetime = dtqry.DefaultView;
                    dvcreatetime.Sort = "createdate,area,dept,processcode,pline_name";
                    foreach (DataRow dr in dttotal.Rows)
                    {
                        DataRow myrow = dtqrytotalkf.NewRow();
                        myrow["area"] = dr["area"];

                        dvcreatetime.RowFilter = "area='" + dr["area"].ToString() + "'";
                        DataTable dt = dvcreatetime.ToTable();
                        foreach (DataColumn col in dtqrytotalkf.Columns)
                        {
                            if (col.Caption.Contains("日"))
                            {
                                string selectstr = "createdate='" + ((DateTime)this.sclskf_month.Value).ToString("yyyy-MM-") + col.ColumnName + "'";
                                if (!(dt.Compute("sum(kfqz)", selectstr) is System.DBNull))
                                {
                                    decimal kfqz = (decimal)dt.Compute("sum(kfqz)", selectstr);
                                    decimal kf = (decimal)dt.Compute("sum(kf)", selectstr);
                                    if (kf > 0)
                                    {
                                        myrow[col.ColumnName] = Math.Round(kfqz / kf, 1);
                                    }
                                }
                            }
                            else if (col.Caption.Contains("平均"))
                            {
                                string selectstr = "1=1";
                                if (!(dt.Compute("sum(kfqz)", selectstr) is System.DBNull))
                                {
                                    decimal kfqz = (decimal)dt.Compute("sum(kfqz)", selectstr);
                                    decimal kf = (decimal)dt.Compute("sum(kf)", selectstr);
                                    if (kf > 0)
                                    {
                                        myrow[col.ColumnName] = Math.Round(kfqz / kf, 1);
                                    }
                                }
                            }
                        }
                        dtqrytotalkf.Rows.Add(myrow);
                    }
                    foreach (DataRow dr in dtdetail.Rows)
                    {
                        DataRow myrow = dtqrydetailkf.NewRow();
                        myrow["area"] = dr["area"];
                        myrow["dept"] = dr["dept"];
                        myrow["processcode"] = dr["processcode"];
                        myrow["pline_name"] = dr["pline_name"];
                        myrow["dept_processcode"] = dr["area"].ToString() + dr["dept"].ToString() + dr["processcode"].ToString();

                        dvcreatetime.RowFilter = "area='" + dr["area"].ToString() + "' and pline_name='" + dr["pline_name"] + "'";
                        DataTable dt = dvcreatetime.ToTable();
                        foreach (DataColumn col in dtqrydetailkf.Columns)
                        {
                            if (col.Caption.Contains("日"))
                            {
                                string selectstr = "createdate='" + ((DateTime)this.sclskf_month.Value).ToString("yyyy-MM-") + col.ColumnName + "'";
                                if (!(dt.Compute("sum(kfqz)", selectstr) is System.DBNull))
                                {
                                    decimal kfqz = (decimal)dt.Compute("sum(kfqz)", selectstr);
                                    decimal kf = (decimal)dt.Compute("sum(kf)", selectstr);
                                    if (kf > 0)
                                    {
                                        myrow[col.ColumnName] = Math.Round(kfqz / kf, 1);
                                    }
                                }
                            }
                            else if (col.Caption.Contains("平均"))
                            {
                                string selectstr = "1=1";
                                if (!(dt.Compute("sum(kfqz)", selectstr) is System.DBNull))
                                {
                                    decimal kfqz = (decimal)dt.Compute("sum(kfqz)", selectstr);
                                    decimal kf = (decimal)dt.Compute("sum(kf)", selectstr);
                                    if (kf > 0)
                                    {
                                        myrow[col.ColumnName] = Math.Round(kfqz / kf, 1);
                                    }
                                }
                            }
                        }
                        dtqrydetailkf.Rows.Add(myrow);
                    }
                    summarykf(dtqrydetailkf);
                }
                GridHelper.CopyDataToDatatable(ref dtqrytotalkf, ref this.dataTable5, true);
                GridHelper.CopyDataToDatatable(ref dtqrydetailkf, ref this.dataTable6, true);
                setgridcolunm_kf(ultraGrid_scls_kf);
                wf.Close();

            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                wf.Close();
            }

        }
        private void summarykf(DataTable dtqry)
        {
            string area = dtqry.Rows[0]["area"].ToString();
            string dept = dtqry.Rows[0]["dept"].ToString();
            string processcode = dtqry.Rows[0]["processcode"].ToString();
            string pline = dtqry.Rows[0]["pline_name"].ToString();
            int row_count = dtqry.Rows.Count;
            int pline_count = 0, processcode_count = 0;
            for (int row_index = 0; row_index < row_count; row_index++)
            {
                DataRow dr = dtqry.Rows[row_index];
                //dr["dept_processcode"] = dr["area"].ToString() + dr["dept"].ToString() + dr["processcode"].ToString();
                if (area + dept != dr["area"].ToString() + dr["dept"].ToString())
                {
                    if (processcode_count != pline_count && pline_count > 1)
                    {
                        addsummry(dtqry, area, area + dept + processcode, dept, processcode, "小计", row_index);
                        row_index++;
                        row_count++;
                    }
                    if (processcode_count > 1)
                    {
                        addsummry(dtqry, area, area + dept + processcode, dept, "合计", "", row_index);
                        row_index++;
                        row_count++;
                    }
                    pline_count = 0;
                    processcode_count = 0;
                }
                else if (area + dept == dr["area"].ToString() + dr["dept"].ToString() && processcode != dr["processcode"].ToString())
                {
                    if (pline_count > 1)
                    {
                        addsummry(dtqry, area, area + dept + processcode, dept, processcode, "小计", row_index);
                        row_index++;
                        row_count++;
                    }
                    pline_count = 0;

                }
                area = dtqry.Rows[row_index]["area"].ToString();
                dept = dtqry.Rows[row_index]["dept"].ToString();
                processcode = dtqry.Rows[row_index]["processcode"].ToString();
                pline = dtqry.Rows[row_index]["pline_name"].ToString();
                pline_count++;
                processcode_count++;
            }
            if (pline_count > 1)
            {
                addsummry(dtqry, area, area + dept + processcode, dept, processcode, "小计", -1);
            }
            if (processcode_count > 1)
            {
                addsummry(dtqry, area, area + dept + processcode, dept, "合计", "", -1);
            }
        }
        private void addsummry(DataTable dt, string area, string dept_processcode, string dept, string processcode, string pline_name, int row_index)
        {
            DataRow myrow = dt.NewRow();
            myrow["area"] = area;
            myrow["dept_processcode"] = area + dept + processcode;
            myrow["dept"] = dept;
            myrow["processcode"] = processcode;
            myrow["pline_name"] = pline_name;
            foreach (DataColumn col in dt.Columns)
            {
                string selectstr = "";
                if (pline_name == "小计")
                    selectstr = "dept_processcode='" + dept_processcode + "' and pline_name<>'小计' and pline_name<>''";
                else if (processcode == "合计")
                    selectstr = "area='" + area + "' and dept='" + dept + "' and pline_name<>'小计' and pline_name<>''";
                if (col.Caption.Contains("日") || col.Caption.Contains("平均"))
                {
                    string sql = "avg([" + col.ColumnName + "])";
                    if (!(dt.Compute(sql, selectstr) is System.DBNull))
                    {
                        decimal pjz = (decimal)dt.Compute(sql, selectstr);
                        if (pjz > 0)
                        {
                            myrow[col.ColumnName] = Math.Round(pjz, 1);
                        }
                    }
                }
            }
            if (row_index == -1)
                dt.Rows.Add(myrow);
            else
                dt.Rows.InsertAt(myrow, row_index);

        }

        private void setgridcolunm_kf(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid)
        {
            ultraGrid.DisplayLayout.Bands[0].Groups[0].Header.Caption = ((DateTime)this.sclskf_month.Value).ToString("yyyy") + "年" + Convert.ToInt32(((DateTime)this.sclskf_month.Value).ToString("MM")).ToString() + "月扣分";
            foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn col in band.Columns)
                {
                    if (col.Header.Caption.Contains("日") && Convert.ToInt32(col.Key) > days)
                    {
                        col.Hidden = true;
                    }
                    col.Header.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
                    if (col.Header.Caption.Contains("日") || col.Header.Caption.Contains("平均"))
                    {
                        col.CellAppearance.TextHAlign = Infragistics.Win.HAlign.Right;
                    }
                    col.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                }
                if (band.Index == 1)
                {
                    CustomMergedCellEvaluator merge = new CustomMergedCellEvaluator("dept_processcode");
                    band.Columns["processcode"].MergedCellEvaluator = merge;
                }
                int i = 0;

                decimal min = 0, max = 0;
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in band.GetRowEnumerator(Infragistics.Win.UltraWinGrid.GridRowType.DataRow))
                {
                    if (band.Index == 1 && row.Cells["pline_name"].Text == "小计")
                    {
                        row.Cells["pline_name"].Appearance.BackColor = Color.LightYellow;
                        for (int j = 3; j < band.Columns.Count; j++)
                        {
                            row.Cells[i].Appearance.BackColor = Color.LemonChiffon;
                        }
                    }
                    else if (band.Index == 1 && row.Cells["processcode"].Text == "合计")
                    {
                        row.Cells["processcode"].Appearance.BackColor = Color.LemonChiffon; ;
                        row.Cells["pline_name"].Appearance.BackColor = Color.LemonChiffon; ;
                        for (int j = 3; j < band.Columns.Count; j++)
                        {
                            row.Cells[i].Appearance.BackColor = Color.LightYellow; ;
                        }
                    }
                    else
                    {

                        foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn col in band.Columns)
                        {
                            if (col.Header.Caption.Contains("日") && row.Cells[col].Text != "")
                            {
                                decimal myvalue = Convert.ToDecimal(row.Cells[col].Text);
                                if (myvalue > max)
                                {
                                    max = myvalue;

                                }
                                if (myvalue < min || min == 0)
                                {
                                    min = myvalue;
                                }
                            }
                        }

                    }
                }
                if (min < max)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in band.GetRowEnumerator(Infragistics.Win.UltraWinGrid.GridRowType.DataRow))
                    {
                        foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn col in band.Columns)
                        {
                            if (col.Header.Caption.Contains("日") && row.Cells[col].Text == max.ToString())
                            {
                                row.Cells[col].Appearance.ForeColor = Color.Red;
                                row.Cells[col].Appearance.FontData.Bold = Infragistics.Win.DefaultableBoolean.True;
                                row.Cells[col].Appearance.BackColor = Color.LightGoldenrodYellow;
                            }
                            else if (col.Header.Caption.Contains("日") && row.Cells[col].Text == min.ToString())
                            {
                                row.Cells[col].Appearance.FontData.Bold = Infragistics.Win.DefaultableBoolean.True;
                                row.Cells[col].Appearance.BackColor = Color.PaleGreen;
                            }
                        }
                    }
                }

            }
            //ultraGrid.Refresh();
        }


        private void getscls()
        {

            WaitingForm2 wf = new WaitingForm2("正在加载数据,请稍候....");
            try
            {
                string mydate = ((DateTime)this.rptdate.Value).ToString("yyyy-MM-dd");
                string mymethodid = "", sign = "";
                DataTable dtqry = new DataTable();
                if (rB_dc.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_DC";
                    sign = "DC";
                    isnew = true;
                }
                else if (rB_qx.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_QX";
                    sign = "QX";
                    isnew = true;
                }
                else if (rB_dpsp.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_DPSP";
                    sign = "DPSP";
                    isnew = true;
                }
                else if (rB_dppd.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_DPPD";
                    sign = "DPPD";
                    isnew = true;
                }
                else if (rB_lxwt.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_LXWT";
                    sign = "LXWT";
                    isnew = true;
                }
                else if (rB_lxfx.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_LXFX";
                    sign = "LXFX";
                    isnew = true;
                }
                else if (rB_fp.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_FP";
                    sign = "FP";
                    isnew = true;
                }
                if (mymethodid != "")
                {
                    dtqry = ServerHelper.GetData(mymethodid, new object[] { mydate }, this.ob);
                    wf.Close();

                    DataTable dtqry1 = dtqry.Clone();
                    dtqry1.Columns["kf"].DataType = typeof(decimal);
                    dtqry1.Columns["qz"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("dc_hours") >= 0)
                        dtqry1.Columns["dc_hours"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("dc_days") >= 0)
                        dtqry1.Columns["dc_days"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("PLN_OUTSINGLE_NUM") >= 0)
                        dtqry1.Columns["PLN_OUTSINGLE_NUM"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("PLN_OUTSINGLE_W") >= 0)
                        dtqry1.Columns["PLN_OUTSINGLE_W"].DataType = typeof(decimal);
                    foreach (DataRow dr in dtqry.Rows)
                    {
                        dtqry1.ImportRow(dr);
                    }
                    if (dtqry1.Rows.Count > 0)
                    {
                        UltraColumnChart_scls.Visible = true;
                        UltraPieChart_scls.Visible = true;
                        ultraGrid_scls.DataSource = dtqry1;
                        setgridcolunmName(ultraGrid_scls, sign);
                        //RefreshAndAutoSize(ultraGrid_scls);

                        DataTable dtqry2 = dtqry1.Copy();
                        DataView dv = dtqry2.DefaultView;
                        dv.RowFilter = "kf>0";
                        dtqry2 = dv.ToTable();

                        getproccestree(ultraTree_scls, dtqry2);
                        setchartpoints(dtqry2);
                        //getcolumnchart_scls("大工序", UltraColumnChart_scls, dtqry, "DGX");
                        //getpiechart_scls(UltraColumnChart_scls.Series[0].Label, UltraPieChart_scls, dtqry, "DGX");
                        getcolumnchart_scls(ultraTree_scls.Nodes[0].Text, UltraColumnChart_scls, dtqry2, "DGX");
                        getpiechart_scls(ultraTree_scls.Nodes[0].Nodes[0].Text, UltraPieChart_scls, dtqry2, "DGX");
                        ultraTree_scls.Nodes[0].Selected = true;
                        isnew = false;
                    }
                    else
                    {
                        ultraTree_scls.Nodes.Clear();
                        ultraGrid_scls.DataSource = null;
                        UltraColumnChart_scls.Visible = false;
                        UltraPieChart_scls.Visible = false;
                        this.alert("没有数据！");
                    }
                }

            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                wf.Close();
            }
        }
        private void getscls_qj()
        {
            WaitingForm2 wf = new WaitingForm2("正在加载数据,请稍候....");
            try
            {
                string mydate1 = ((DateTime)this.scls_fromdate.Value).ToString("yyyy-MM-dd");
                string mydate2 = ((DateTime)this.scls_todate.Value).ToString("yyyy-MM-dd");

                string mymethodid = "com.steering.rpt.scls.SCLS.getSCLS_TotalKF";
                DataTable dtqry = new DataTable();

                dtqry = ServerHelper.GetData(mymethodid, new object[] { mydate1, mydate2 }, this.ob);
                string mysql = "";
                if (cB_dcqj.Checked == false)
                    mysql += mysql == "" ? "sign<>'DC'" : " and sign<>'DC'";
                if (cB_qxqj.Checked == false)
                    mysql += mysql == "" ? "sign<>'QX'" : " and sign<>'QX'";
                if (cB_dpspqj.Checked == false)
                    mysql += mysql == "" ? "sign<>'DSP'" : " and sign<>'DSP'";
                if (cB_dppdqj.Checked == false)
                    mysql += mysql == "" ? "sign<>'DPD'" : " and sign<>'DPD'";
                if (cB_lxwtqj.Checked == false)
                    mysql += mysql == "" ? "sign<>'LXWT'" : " and sign<>'LXWT'";
                if (cB_lxfxqj.Checked == false)
                    mysql += mysql == "" ? "sign<>'LXFX'" : " and sign<>'LXFX'";
                if (cB_fpqj.Checked == false)
                    mysql += mysql == "" ? "sign<>'FP'" : " and sign<>'FP'";

                DataView dv = dtqry.DefaultView;
                dv.RowFilter = mysql;
                dtqry = dv.ToTable();

                dtqry1 = new DataTable();
                dtqry1 = dtqry.Clone();
                dtqry1.Columns["kf"].DataType = System.Type.GetType("System.Int32");
                DataView dvdetail = dtqry.DefaultView;
                dvdetail.Sort = "createdate,processcode,dept,pline_name";
                foreach (DataRow dr in dtqry.Rows)
                {
                    dtqry1.ImportRow(dr);
                }
                DataView dvtree = dtqry.DefaultView;
                dvtree.Sort = "processcode,dept,pline_name";
                DataTable dttree = dvtree.ToTable(true, "processcode", "dept", "dept_code", "pline_code", "pline_name");//注：其中ToTable（）的第一个参数为是否DISTINCT
                if (dtqry1.Rows.Count > 0)
                {
                    getproccestree(ultraTree_scls_qj, dttree, "qj");
                    wf.Close();
                    isnew_qj = true;
                    ultraTree_scls_qj.Nodes[0].Selected = true;
                    UltraChart_scls_qj.Visible = true;
                    getlinechart_scls_qj(UltraChart_scls_qj, dtqry1, "DGX");
                    isnew_qj = false;
                    
                }
                else
                {
                    ultraTree_scls_qj.Nodes.Clear();
                    UltraChart_scls_qj.Visible = false;
                    this.alert("没有数据！");
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                wf.Close();
            }
        }

        private void setchartpoints(DataTable myData)
        {
            DataTable copyData = myData.Copy();
            DataView dataView = copyData.DefaultView;
            //kfdataTable.Rows.Clear();
            dataView.Sort = "kf";
            kfdataTable = dataView.ToTable(true, "kf");

            piechartpoint = new String[kfdataTable.Rows.Count];
            columnchartpoint = new String[kfdataTable.Rows.Count];
            int i = 0;
            foreach (DataRow myrow in kfdataTable.Rows)
            {
                string selectstr = "kf=" + myrow["kf"].ToString();
                if (rB_dc.Checked)
                {
                    piechartpoint[i] = (myData.Select(selectstr).Length == 0 ? "" : myData.Select(selectstr)[0]["kfsm"].ToString().Replace("流速-待产，", ""));
                }
                else if (rB_qx.Checked)
                {
                    piechartpoint[i] = (myData.Select(selectstr).Length == 0 ? "" : myData.Select(selectstr)[0]["kfsm"].ToString().Replace("流速-清线，", ""));
                }
                else if (rB_dpsp.Checked)
                {
                    piechartpoint[i] = (myData.Select(selectstr).Length == 0 ? "" : myData.Select(selectstr)[0]["kfsm"].ToString().Replace("流速-待判-送判，", ""));
                }
                else if (rB_dppd.Checked)
                {
                    piechartpoint[i] = (myData.Select(selectstr).Length == 0 ? "" : myData.Select(selectstr)[0]["kfsm"].ToString().Replace("流速-送判-判定，", ""));
                }
                else if (rB_lxwt.Checked)
                {
                    piechartpoint[i] = (myData.Select(selectstr).Length == 0 ? "" : myData.Select(selectstr)[0]["kfsm"].ToString().Replace("流速-离线-委托，", ""));
                }
                else if (rB_lxfx.Checked)
                {
                    piechartpoint[i] = (myData.Select(selectstr).Length == 0 ? "" : myData.Select(selectstr)[0]["kfsm"].ToString().Replace("流速-离线-返线（仅除锈），", "").Replace("流速-离线-返线，", ""));
                }
                else if (rB_fp.Checked)
                {
                    piechartpoint[i] = (myData.Select(selectstr).Length == 0 ? "" : myData.Select(selectstr)[0]["kfsm"].ToString().Replace("流速-废品，", ""));
                }
                columnchartpoint[i] = piechartpoint[i];//.Replace("不扣分", "").Replace("扣1分", "").Replace("扣2分", "");
                i++;
            }
        }



        private void getcolumnchart_scls(string title, UltraChart mychart, DataTable myData, string sign)
        {
            string myselectstr = "";

            // 在此处放置用户代码以初始化页面   

            //step1:Change the ChartType property to "Composite."   
            mychart.ChartType = ChartType.Composite;
            mychart.TitleTop.Font = new System.Drawing.Font("Microsoft Sans Serif", 9F, System.Drawing.FontStyle.Bold);
            mychart.TitleTop.Text = title;
            if (rB_dc.Checked)
                mychart.TitleBottom.Text = rB_dc.Text + "扣分炉数";
            else if (rB_qx.Checked)
                mychart.TitleBottom.Text = rB_qx.Text + "扣分炉数";
            else if (rB_dpsp.Checked)
                mychart.TitleBottom.Text = rB_dpsp.Text + "扣分炉数";
            else if (rB_dppd.Checked)
                mychart.TitleBottom.Text = rB_dppd.Text + "扣分炉数";
            else if (rB_lxwt.Checked)
                mychart.TitleBottom.Text = rB_lxwt.Text + "扣分炉数";
            else if (rB_lxfx.Checked)
                mychart.TitleBottom.Text = rB_lxfx.Text + "扣分炉数";
            else if (rB_fp.Checked)
                mychart.TitleBottom.Text = rB_fp.Text + "扣分炉数";

            //step2:Add a ChartArea to the ChartAreas collection.    
            ChartArea myChartArea = new ChartArea();
            myChartArea.BoundsMeasureType = MeasureType.Percentage;
            myChartArea.Bounds = new Rectangle(0, 10, 100, 80);
            myChartArea.Border.Thickness = 0;


            mychart.CompositeChart.ChartAreas.Add(myChartArea);


            //step3:Add some Axes to the ChartArea.    
            AxisItem axisX = new AxisItem();
            axisX.OrientationType = AxisNumber.X_Axis;
            axisX.DataType = AxisDataType.String;
            axisX.SetLabelAxisType = SetLabelAxisType.GroupBySeries;
            axisX.Labels.ItemFormatString = "<ITEM_LABEL>";
            axisX.Labels.Visible = false;
            axisX.Labels.Orientation = TextOrientation.VerticalLeftFacing;

            AxisItem axisY = new AxisItem();
            axisY.OrientationType = AxisNumber.Y_Axis;
            axisY.DataType = AxisDataType.Numeric;
            axisY.Labels.ItemFormatString = "<DATA_VALUE:0.#>";

            axisY.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Near;
            //axisY.Labels.VerticalAlign = System.Drawing.StringAlignment.Near;

            /*AisItem axisY1 = new AxisItem();
            axisY1.OrientationType = AxisNumber.Y2_Axis;
            axisY1.DataType = AxisDataType.Numeric;
            axisY1.TickmarkStyle = AxisTickStyle.Percentage;
            axisY1.TickmarkPercentage = 10; 
            axisY1.Labels.ItemFormatString = "<DATA_VALUE:#>";
            axisY1.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Near;
            */

            myChartArea.Axes.Add(axisX);
            myChartArea.Axes.Add(axisY);
            //ChartArea.Axes.Add(axisY1);



            //step4:Add some data series to the Series collection.
            string series_Label = "", selectstr, Point_value;

            DataView mydataview = myData.DefaultView;
            if (sign == "DGX")
            {
                series_Label = getprocess(myData.Rows[0]["processcode"].ToString());
                myselectstr = "processcode='" + myData.Rows[0]["processcode"].ToString() + "'";
            }
            else if (sign == "GX-BM")
            {
                mydataview.RowFilter = "processcode='" + ultraTree_scls.ActiveNode.Key + "'";
                mydataview.Sort = "processcode,dept_code";
                myData = mydataview.ToTable();
                series_Label = myData.Rows[0]["dept"].ToString();
                myselectstr = "dept_code='" + myData.Rows[0]["dept_code"].ToString() + "'";
            }
            else if (sign == "BM-CX")
            {
                mydataview.RowFilter = "processcode+dept_code='" + ultraTree_scls.ActiveNode.Key + "'";
                mydataview.Sort = "processcode,dept_code,pline_code";
                myData = mydataview.ToTable();
                series_Label = myData.Rows[0]["pline_name"].ToString();
                myselectstr = "pline_code='" + myData.Rows[0]["pline_code"].ToString() + "'";
            }

            NumericSeries series = new NumericSeries();



            series.Points.Clear();
            int i = 0;
            Color[] mycorlors = new Color[kfdataTable.Rows.Count];
            foreach (DataRow mykfrow in kfdataTable.Rows)
            {
                mycorlors[i] = sclsdrcorlorsdictionary[mykfrow["kf"].ToString()];
                if (columnchartpoint[i] != "")
                {
                    selectstr = myselectstr + " and kf=" + mykfrow["kf"].ToString();
                    Point_value = myData.Compute("count(kf)", selectstr).ToString();
                    if (Point_value == "")
                        Point_value = "0";
                    series.Points.Add(new NumericDataPoint(Convert.ToDouble(Point_value), columnchartpoint[i], false));
                }
                i++;
            }


            series.Label = series_Label;
            mychart.Data.MinValue = 0;
            mychart.CompositeChart.Series.Add(series);

            //step5:Add a chart layer. 
            ChartLayerAppearance myColumnLayer = new ChartLayerAppearance();
            myColumnLayer.ChartType = ChartType.ColumnChart;
            myColumnLayer.ChartArea = myChartArea;
            myColumnLayer.AxisX = axisX;
            myColumnLayer.AxisY = axisY;
            // myColumnLayer.AxisY2 = axisY1;
            myColumnLayer.Series.Clear();

            myColumnLayer.Series.Add(series);

            foreach (DataRow myrow in myData.Rows)
            {
                if (sign == "DGX")
                {
                    series_Label = getprocess(myrow["processcode"].ToString());

                }
                else if (sign == "GX-BM")
                {
                    series_Label = myrow["dept"].ToString();
                }
                else if (sign == "BM-CX")
                {
                    series_Label = myrow["pline_name"].ToString();
                }
                if (series.Label != series_Label)
                {
                    series = new NumericSeries();
                    series.Label = series_Label;

                    if (sign == "DGX")
                    {
                        myselectstr = "processcode='" + myrow["processcode"].ToString() + "'";
                    }
                    else if (sign == "GX-BM")
                    {
                        myselectstr = "dept_code='" + myrow["dept_code"].ToString() + "'";
                    }
                    else if (sign == "BM-CX")
                    {
                        myselectstr = "pline_code='" + myrow["pline_code"].ToString() + "'";
                    }

                    i = 0;
                    foreach (DataRow mykfrow in kfdataTable.Rows)
                    {
                        if (columnchartpoint[i] != "")
                        {
                            selectstr = myselectstr + " and kf=" + mykfrow["kf"].ToString();
                            Point_value = myData.Compute("count(kf)", selectstr).ToString();
                            if (Point_value == "")
                                Point_value = "0";
                            series.Points.Add(new NumericDataPoint(Convert.ToDouble(Point_value), columnchartpoint[i], false));
                        }
                        i++;
                    }
                    mychart.CompositeChart.Series.Add(series);
                    myColumnLayer.Series.Add(series);
                }
            }
            if (myColumnLayer.Series.Count > 4)
            {
                myColumnLayer.AxisX.Labels.SeriesLabels.Orientation = TextOrientation.Custom;//.VerticalLeftFacing;
                myColumnLayer.AxisX.Labels.SeriesLabels.OrientationAngle = 250;
                myColumnLayer.AxisX.Labels.SeriesLabels.Flip = true;
            }
            mychart.CompositeChart.ChartLayers.Clear();
            mychart.ColorModel.ModelStyle = ColorModels.CustomLinear;
            mychart.ColorModel.CustomPalette = mycorlors;
            mychart.CompositeChart.ChartLayers.Add(myColumnLayer);

            //step6:Add a legend to the chart.    
            //CompositeLegend myLegend = new CompositeLegend();   
            //CompositeLegend a = new CompositeLegend();   
            Infragistics.UltraChart.Resources.Appearance.CompositeLegend myLegend = new Infragistics.UltraChart.Resources.Appearance.CompositeLegend();
            //Infragistics.UltraChart.Resources.Appearance.CompositeLegendAppearance       

            myLegend.ChartLayers.Add(myColumnLayer);
            myLegend.Bounds = new Rectangle(20, 90, 60, 8);
            myLegend.BoundsMeasureType = MeasureType.Percentage;
            myLegend.PE.ElementType = PaintElementType.Gradient;
            myLegend.PE.FillGradientStyle = GradientStyle.ForwardDiagonal;
            //myLegend.PE.Fill = Color.CornflowerBlue;
            myLegend.PE.Fill = Color.FloralWhite;
            myLegend.PE.FillStopColor = Color.Transparent;
            myLegend.Border.CornerRadius = 10;
            myLegend.Border.Thickness = 0;

            mychart.CompositeChart.Legends.Clear();
            mychart.CompositeChart.Legends.Add(myLegend);

        }

        private void getlinechart_scls_qj(UltraChart mychart, DataTable myData, string sign)
        {
            mychart.TitleBottom.Text = ((DateTime)this.scls_fromdate.Value).ToString("yyyy-MM-dd") + " - " + ((DateTime)this.scls_todate.Value).ToString("yyyy-MM-dd") + "区间生产流速扣分图";


            DataView mydataview = myData.DefaultView;
            if (sign == "DGX")
            {
                mydataview.RowFilter = "processcode='" + ultraTree_scls_qj.ActiveNode.Key + "'";
                mydataview.Sort = "createdate";
                myData = mydataview.ToTable();
                mychart.TitleTop.Text = getprocess(myData.Rows[0]["processcode"].ToString());
            }
            else if (sign == "GX-BM")
            {
                mydataview.RowFilter = "processcode+dept_code='" + ultraTree_scls_qj.ActiveNode.Key + "'";
                mydataview.Sort = "createdate";
                myData = mydataview.ToTable();
                mychart.TitleTop.Text = getprocess(myData.Rows[0]["processcode"].ToString()) + "：" + myData.Rows[0]["dept"];
            }
            else if (sign == "BM-CX")
            {
                mydataview.RowFilter = "pline_code='" + ultraTree_scls_qj.ActiveNode.Key + "'";
                mydataview.Sort = "createdate";
                myData = mydataview.ToTable();
                mychart.TitleTop.Text = getprocess(myData.Rows[0]["processcode"].ToString()) + " - " + myData.Rows[0]["dept"] + "：" + myData.Rows[0]["pline_name"].ToString();
            }

            DataView dvls = myData.DefaultView;
            dvls.Sort = "signxh";
            DataTable dtls = dvls.ToTable(true, "sign");//注：其中ToTable（）的第一个参数为是否DISTINCT
            dtls.Columns["sign"].MaxLength = 50;
            DataView dvdate = myData.DefaultView;
            dvdate.Sort = "createdate";
            DataTable dtdate = dvls.ToTable(true, "createdate");//注：其中ToTable（）的第一个参数为是否DISTINCT

            foreach (DataRow daterow in dtdate.Rows)
            {
                dtls.Columns.Add(daterow["createdate"].ToString(), typeof(decimal));
            }

            Color[] mycorlors = new Color[dtls.Rows.Count + 1];
            int i_color = 0;
            foreach (DataRow myrow in dtls.Rows)
            {
                mycorlors[i_color] = mycorlorsdictionary[myrow["sign"].ToString()];
                i_color++;
                string selectstr = "sign='" + myrow["sign"].ToString() + "'";
                foreach (DataRow daterow in dtdate.Rows)
                {
                    string myselectstr = " and createdate='" + daterow["createdate"].ToString() + "'";
                    string value = myData.Compute("sum(kf)", selectstr + myselectstr).ToString();
                    myrow[daterow["createdate"].ToString()] = value != "" ? Convert.ToDecimal(value) : 0;
                }
                myrow["sign"] = mynamedictionary[myrow["sign"].ToString()];
            }
            if (i_color > 1)
            {
                mycorlors[i_color] = mycorlorsdictionary["PJ"]; ;
                DataRow mynewrow = dtls.NewRow();
                mynewrow["sign"] = mynamedictionary["PJ"];
                foreach (DataRow daterow in dtdate.Rows)
                {
                    string value = dtls.Compute("avg([" + daterow["createdate"].ToString() + "])", "").ToString();
                    mynewrow[daterow["createdate"].ToString()] = value != "" ? Math.Round(Convert.ToDecimal(value), 0) : 0;
                }
                dtls.Rows.Add(mynewrow);
            }
            if (rB_line.Checked)
            {
                mychart.ChartType = ChartType.LineChart;
                mychart.LineChart.Thickness = 2;

            }
            else if (rB_Radar.Checked)
            {
                mychart.ChartType = ChartType.RadarChart;
                mychart.RadarChart.LineThickness = myLineThickness;
            }
            //mychart.Axis.Y.LogBase= 10;
            mychart.Axis.Y.LogZero = -50;

            mychart.Data.DataSource = dtls;
            UltraChart_scls_qj.Data.IncludeColumn(0, false);
            UltraChart_scls_qj.Data.MinValue = 0;
            UltraChart_scls_qj.Data.UseMinMax = true;
            UltraChart_scls_qj.Data.ZeroAligned = true;
            /*foreach (ChartTextAppearance mylinetext in UltraChart_scls_qj.LineChart.ChartText)
            {
                mylinetext.ItemFormatString = "<ITEM_LABEL>";
                mylinetext.Visible = true;
            }*/
            UltraChart_scls_qj.ColorModel.ModelStyle = ColorModels.CustomLinear;
            UltraChart_scls_qj.ColorModel.CustomPalette = mycorlors;



            mychart.Axis.X.Labels.Orientation = TextOrientation.Custom;
            mychart.Axis.X.Labels.OrientationAngle = 80;
            mychart.Axis.X.Labels.VerticalAlign = StringAlignment.Far;
            //mychart.Axis.X.Labels.Flip = false;

            mychart.Data.DataBind();

        }



        private void getpiechart_scls(string title, UltraChart mychart, DataTable myData, string sign)
        {


            //创建绘图区域
            ChartArea myChartArea = new ChartArea();
            myChartArea.BoundsMeasureType = MeasureType.Percentage;
            myChartArea.Bounds = new Rectangle(0, 0, 100, 80);
            myChartArea.Border.Thickness = 0;
            //表明ChartArea绘图区域占整个UltraChart的比例：宽100%，高80%，位置呢从左顶点(0,0)起
            //创建X轴线
            AxisItem xAxis = new AxisItem();
            xAxis.axisNumber = AxisNumber.X_Axis;
            xAxis.Labels.Visible = false;
            xAxis.Labels.Orientation = TextOrientation.VerticalLeftFacing;
            xAxis.DataType = AxisDataType.String;
            xAxis.SetLabelAxisType = SetLabelAxisType.GroupBySeries;
            xAxis.Labels.ItemFormatString = "<ITEM_LABEL>";
            xAxis.Extent = 10;
            //此处Extent决定着X轴线偏离绘图区域边界的大小，恰当设置轴线的Extent值可以调整图表区域的大小
            //控件默认数据绑定
            //Infragistics.UltraChart.Resources.Util.DemoSetup(UltraChart2);
            //Infragistics的UltraChart为其每个图表类型定制了完美的数据，这可以从其图表向导里看到。
            //我们并没有指定图表的数据，但是我们所设置好图表属性后，生成的图表默认就绑定了些数据，
            //这就是控件所定制而来。
            //图表轴向间距：可以按百分比控制设置

            string selectstr = "";
            if (sign == "DGX")
            {
                selectstr = "processcode='" + title.Substring(0, 1) + "'";
            }
            else if (sign == "GX-BM")
            {
                selectstr = "processcode='" + UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) + "' and dept='" + title + "'";
            }
            else if (sign == "BM-CX")
            {
                selectstr = "pline_name='" + title + "'";
            }
            selectstr += " and kf>0";
            NumericSeries series = new NumericSeries();
            double total = Convert.ToDouble(myData.Compute("count(kf)",selectstr ).ToString() == "" ? "0" : myData.Compute("count(kf)", selectstr).ToString());

            int i = 0,j=0;
            Color[] mycorlors = new Color[kfdataTable.Rows.Count];
            foreach (DataRow mykfrow in kfdataTable.Rows)
            {
                mycorlors[i] = sclsdrcorlorsdictionary[mykfrow["kf"].ToString()];
                if (columnchartpoint[i] != "")
                {
                    double P_value = 0,P_valuep = 0;
                    String Point_value = myData.Compute("count(kf)", selectstr + " and kf=" + mykfrow["kf"].ToString()).ToString();
                    if (Point_value == "")
                        Point_value = "0";
                    else
                    {
                        P_valuep = Math.Round(Convert.ToDouble(Point_value) / total * 100, 2);
                        P_value = Convert.ToDouble(Point_value);
                    }
                    NumericDataPoint datapoint = new NumericDataPoint(P_value, piechartpoint[i] + "(共：" + Point_value + "炉次，占：" + P_valuep.ToString() + "%)", false);
                    //datapoint.Label = Point_value + "(" + P_value.ToString() + ")";
                    series.Points.Add(datapoint);

                }
                i++;
            }

            mychart.CompositeChart.Series.Clear();
            mychart.CompositeChart.Series.Add(series);

            //step5:Add a chart layer. 
            /*ChartLayerAppearance mypieLayer = new ChartLayerAppearance();
            mypieLayer.ChartType = ChartType.PieChart;
            mypieLayer.ChartArea = myChartArea;
            mypieLayer.Series.Add(series);*/

            mychart.TitleTop.Text = title;
            if (rB_dc.Checked)
                mychart.TitleBottom.Text = rB_dc.Text;
            else if (rB_qx.Checked)
                mychart.TitleBottom.Text = rB_qx.Text;
            else if (rB_dpsp.Checked)
                mychart.TitleBottom.Text = rB_dpsp.Text;
            else if (rB_dppd.Checked)
                mychart.TitleBottom.Text = rB_dppd.Text;
            else if (rB_lxwt.Checked)
                mychart.TitleBottom.Text = rB_lxwt.Text;
            else if (rB_lxfx.Checked)
                mychart.TitleBottom.Text = rB_lxfx.Text;
            else if (rB_fp.Checked)
                mychart.TitleBottom.Text = rB_fp.Text;


            mychart.Axis.Y.TickmarkStyle = AxisTickStyle.Percentage;
            mychart.Axis.Y.TickmarkPercentage = 10;
            //图表轴向间距：可以按照指定数据间隔设置
            mychart.Axis.Y.TickmarkStyle = AxisTickStyle.DataInterval;
            mychart.Axis.Y.TickmarkInterval = 15;
            //设置图表轴向标签倾角
            mychart.Axis.X.Labels.Orientation = Infragistics.UltraChart.Shared.Styles.TextOrientation.Custom;
            mychart.Axis.X.Labels.OrientationAngle = 240;
            mychart.Axis.X.Labels.Flip = true;
            //在饼图上显示提示信息来代替显示数据百分比值
            mychart.PieChart.Labels.Format = Infragistics.UltraChart.Shared.Styles.PieLabelFormat.ItemLabel;
            mychart.PieChart.Labels.FormatString = "<ITEM_LABEL>";

            mychart.CompositeChart.ChartAreas.Clear();
            mychart.ColorModel.ModelStyle = ColorModels.CustomLinear;
            mychart.ColorModel.CustomPalette = mycorlors;
            mychart.CompositeChart.ChartAreas.Add(myChartArea);

            Infragistics.UltraChart.Resources.Appearance.CompositeLegend myLegend = new Infragistics.UltraChart.Resources.Appearance.CompositeLegend();
            //Infragistics.UltraChart.Resources.Appearance.CompositeLegendAppearance               
            //myLegend.ChartLayers.Add(mypieLayer);
            myLegend.Bounds = new Rectangle(2, 90, 36, 6);
            myLegend.BoundsMeasureType = MeasureType.Percentage;
            myLegend.PE.ElementType = PaintElementType.Gradient;
            myLegend.PE.FillGradientStyle = GradientStyle.ForwardDiagonal;
            myLegend.PE.Fill = Color.CornflowerBlue;
            myLegend.PE.FillStopColor = Color.Transparent;
            myLegend.Border.CornerRadius = 10;
            myLegend.Border.Thickness = 0;

            mychart.CompositeChart.Legends.Add(myLegend);




        }


        private DataTable getprocesssum(DataTable dt)
        {
            DataTable dtResult = new DataTable();
            dtResult.Columns.Add("processcode", Type.GetType("System.String"));
            dtResult.Columns.Add("kf", Type.GetType("System.String"));
            dtResult.Columns.Add("kfsm", Type.GetType("System.String"));


            DataTable dtName = dt.DefaultView.ToTable(true, "processcode", "kf");
            for (int i = 0; i < dtName.Rows.Count; i++)
            {
                DataRow[] rows = dt.Select("processcode='" + dtName.Rows[i][0] + "' and kf=" + dtName.Rows[i][1] + "");
                //temp用来存储筛选出来的数据
                DataTable temp = dtResult.Clone();
                foreach (DataRow row in rows)
                {
                    temp.Rows.Add(row.ItemArray);
                }

                DataRow dr = dtResult.NewRow();
                dr["processcode"] = dtName.Rows[i]["processcode"].ToString();
                dr["kf"] = temp.Compute("sum(kf)", "");
                dr["kfsm"] = temp.Compute("max(kfsm)", "");
                dtResult.Rows.Add(dr);

            }
            return dtResult;
        }

        /// <summary>
        /// 刷新Grid数据并根据数据调整Grid列宽
        /// </summary>
        /// <param name="ultraGrid">需要处理的Grid</param>
        public static void RefreshAndAutoSize(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid)
        {
            try
            {
                ultraGrid.DataBind();

                foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                    {
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                    }
                }

                ultraGrid.Refresh();
            }
            catch { }
        }
        private string getprocess(string processcode)
        {
            switch (processcode)
            {
                case "A":
                    return processcode + "-炼钢";
                case "B":
                    return processcode + "-铸造";
                case "D":
                    return processcode + "-轧管";
                case "E":
                    return processcode + "-镦拔扩";
                case "F":
                    return processcode + "-热处理";
                case "G":
                    return processcode + "-加工";
                default:
                    return "";
            }
        }
        private void getproccestree(UltraTree myultraTree, DataTable mytable, String sign = "")
        {
            myultraTree.Nodes.Clear();
            myultraTree.NodeConnectorColor = System.Drawing.SystemColors.ControlDark;
            UltraTreeNode treeNode, processNode, deptNode, plineNode;
            string processkey, deptkey, plinekey;
            if (mytable.Rows.Count > 0)
            {
                treeNode = new UltraTreeNode();
                if (sign == "")
                {
                    treeNode.Key = "1";
                    treeNode.Text = "大工序";
                    AddTreeNode(myultraTree, treeNode, null);
                }

                processkey = mytable.Rows[0]["processcode"].ToString();
                deptkey = mytable.Rows[0]["processcode"].ToString() + mytable.Rows[0]["dept_code"].ToString();
                plinekey = mytable.Rows[0]["pline_code"].ToString();
                processNode = new UltraTreeNode();
                processNode.Key = processkey;
                processNode.Text = getprocess(processkey);
                if (sign == "")
                {
                    AddTreeNode(myultraTree, processNode, treeNode);
                }
                else
                {
                    AddTreeNode(myultraTree, processNode, null);
                }
                deptNode = new UltraTreeNode();
                deptNode.Key = deptkey;
                deptNode.Text = mytable.Rows[0]["dept"].ToString();
                AddTreeNode(myultraTree, deptNode, processNode);
                plineNode = new UltraTreeNode();
                plineNode.Key = plinekey;
                plineNode.Text = mytable.Rows[0]["pline_name"].ToString();
                AddTreeNode(myultraTree, plineNode, deptNode);

                foreach (DataRow myrow in mytable.Rows)
                {
                    processkey = myrow["processcode"].ToString();
                    deptkey = myrow["processcode"].ToString() + myrow["dept_code"].ToString();
                    plinekey = myrow["pline_code"].ToString();
                    if (plineNode.Key != plinekey && deptNode.Key == deptkey && processNode.Key == processkey)
                    {
                        plineNode = new UltraTreeNode();
                        plineNode.Key = myrow["pline_code"].ToString();
                        plineNode.Text = myrow["pline_name"].ToString();
                        AddTreeNode(myultraTree, plineNode, deptNode);
                    }
                    if (deptNode.Key != deptkey && processNode.Key == processkey)
                    {
                        deptNode = new UltraTreeNode();
                        deptNode.Key = myrow["processcode"].ToString() + myrow["dept_code"].ToString();
                        deptNode.Text = myrow["dept"].ToString();
                        AddTreeNode(myultraTree, deptNode, processNode);
                        plineNode = new UltraTreeNode();
                        plineNode.Key = myrow["pline_code"].ToString();
                        plineNode.Text = myrow["pline_name"].ToString();
                        AddTreeNode(myultraTree, plineNode, deptNode);
                    }
                    if (processNode.Key != processkey)
                    {
                        processNode = new UltraTreeNode();
                        processNode.Key = myrow["processcode"].ToString();
                        processNode.Text = getprocess(processNode.Key);
                        if (sign == "")
                        {
                            AddTreeNode(myultraTree, processNode, treeNode);
                        }
                        else
                        {
                            AddTreeNode(myultraTree, processNode, null);
                        }
                        deptNode = new UltraTreeNode();
                        deptNode.Key = myrow["processcode"].ToString() + myrow["dept_code"].ToString();
                        deptNode.Text = myrow["dept"].ToString();
                        AddTreeNode(myultraTree, deptNode, processNode);
                        plineNode = new UltraTreeNode();
                        plineNode.Key = myrow["pline_code"].ToString();
                        plineNode.Text = myrow["pline_name"].ToString();
                        AddTreeNode(myultraTree, plineNode, deptNode);
                    }
                }
            }
        }

        private void getchart()
        {
            // 在此处放置用户代码以初始化页面   
            //step1:Change the ChartType property to "Composite."   
            UltraColumnChart_scls.Visible = true;
            this.UltraColumnChart_scls.ChartType = ChartType.Composite;
            //step2:Add a ChartArea to the ChartAreas collection.    
            ChartArea myChartArea = new ChartArea();
            this.UltraColumnChart_scls.CompositeChart.ChartAreas.Add(myChartArea);
            //step3:Add some Axes to the ChartArea.    

            AxisItem axisX = new AxisItem();
            axisX.OrientationType = AxisNumber.X_Axis;
            axisX.DataType = AxisDataType.String;
            axisX.SetLabelAxisType = SetLabelAxisType.GroupBySeries;
            axisX.Labels.ItemFormatString = "<ITEM_LABEL>";
            axisX.Labels.Orientation = TextOrientation.VerticalLeftFacing;
            AxisItem axisY = new AxisItem();
            axisY.OrientationType = AxisNumber.Y_Axis;
            axisY.DataType = AxisDataType.Numeric;
            axisY.Labels.ItemFormatString = "<DATA_VALUE:0.#>";
            myChartArea.Axes.Add(axisX); myChartArea.Axes.Add(axisY);
            //step4:Add some data series to the Series collection.    
            NumericSeries seriesA = GetNumericSeriesBound();
            NumericSeries seriesB = GetNumericSeriesUnBound();
            this.UltraColumnChart_scls.CompositeChart.Series.Add(seriesA);
            this.UltraColumnChart_scls.CompositeChart.Series.Add(seriesB);
            //step5:Add a chart layer.    
            ChartLayerAppearance myColumnLayer = new ChartLayerAppearance();
            myColumnLayer.ChartType = ChartType.StackColumnChart;//.ColumnChart;   
            myColumnLayer.ChartArea = myChartArea;
            myColumnLayer.AxisX = axisX;
            myColumnLayer.AxisY = axisY;
            myColumnLayer.Series.Add(seriesA);
            myColumnLayer.Series.Add(seriesB);
            this.UltraColumnChart_scls.CompositeChart.ChartLayers.Add(myColumnLayer);
            //step6:Add a legend to the chart.    
            //CompositeLegend myLegend = new CompositeLegend();   
            //CompositeLegend a = new CompositeLegend();   
            Infragistics.UltraChart.Resources.Appearance.CompositeLegend myLegend = new Infragistics.UltraChart.Resources.Appearance.CompositeLegend();
            //Infragistics.UltraChart.Resources.Appearance.CompositeLegendAppearance   myLegend = new CompositeLegendAppearance();   
            myLegend.ChartLayers.Add(myColumnLayer);
            myLegend.Bounds = new Rectangle(0, 75, 20, 25);
            myLegend.BoundsMeasureType = MeasureType.Percentage;
            myLegend.PE.ElementType = PaintElementType.Gradient;
            myLegend.PE.FillGradientStyle = GradientStyle.ForwardDiagonal;
            myLegend.PE.Fill = Color.CornflowerBlue;
            myLegend.PE.FillStopColor = Color.Transparent;
            myLegend.Border.CornerRadius = 10;
            myLegend.Border.Thickness = 0;

            this.UltraColumnChart_scls.CompositeChart.Legends.Add(myLegend);

        }
        private DataTable GetData()
        {
            DataTable table = new DataTable();
            table.Columns.Add("Label Column", Type.GetType("System.String"));
            table.Columns.Add("Value Column", Type.GetType("System.Double"));
            table.Columns.Add("Another Value Column", Type.GetType("System.Double"));
            table.Rows.Add(new object[] { "Point A", 1.0, 3.0 });
            table.Rows.Add(new object[] { "Point B", 2.0, 2.0 });
            table.Rows.Add(new object[] { "Point C", 3.0, 1.0 });
            table.Rows.Add(new object[] { "Point D", 4.0, 2.0 });
            table.Rows.Add(new object[] { "Point E", 5.0, 3.0 });
            return table;
        }


        /// <summary>  /// 绑定数据，数据库  /// </summary>  
        private NumericSeries GetNumericSeriesBound()
        {
            NumericSeries series = new NumericSeries();
            series.Label = "Series A";
            DataTable table = GetData();
            series.Data.DataSource = table;
            series.Data.LabelColumn = "Label Column";
            series.Data.ValueColumn = "Value Column";
            return series;
        }
        /// <summary>  /// 绑定数据  /// </summary>  
        private NumericSeries GetNumericSeriesUnBound()
        {
            NumericSeries series = new NumericSeries();
            series.Label = "Series B";
            series.Points.Add(new NumericDataPoint(5.0, "Point A", false));
            series.Points.Add(new NumericDataPoint(4.0, "Point B", false));
            series.Points.Add(new NumericDataPoint(3.0, "Point C", false));
            series.Points.Add(new NumericDataPoint(2.0, "Point D", false));
            series.Points.Add(new NumericDataPoint(1.0, "Point E", false));
            return series;
        }


        private void getpiechart()
        {
            UltraPieChart_scls.Visible = true;
            //创建绘图区域
            ChartArea myChartArea = new ChartArea();
            myChartArea.BoundsMeasureType = MeasureType.Percentage;
            myChartArea.Bounds = new Rectangle(0, 0, 100, 80);
            myChartArea.Border.Thickness = 0;
            //表明ChartArea绘图区域占整个UltraChart的比例：宽100%，高80%，位置呢从左顶点(0,0)起
            //创建X轴线
            AxisItem xAxis = new AxisItem();
            xAxis.axisNumber = AxisNumber.X_Axis;
            xAxis.Labels.Orientation = TextOrientation.VerticalLeftFacing;

            xAxis.DataType = AxisDataType.String;
            xAxis.SetLabelAxisType = SetLabelAxisType.GroupBySeries;
            xAxis.Labels.ItemFormatString = "<ITEM_LABEL>";
            xAxis.Extent = 10;
            //此处Extent决定着X轴线偏离绘图区域边界的大小，恰当设置轴线的Extent值可以调整图表区域的大小
            //控件默认数据绑定
            //Infragistics.UltraChart.Resources.Util.DemoSetup(UltraChart2);
            //Infragistics的UltraChart为其每个图表类型定制了完美的数据，这可以从其图表向导里看到。
            //我们并没有指定图表的数据，但是我们所设置好图表属性后，生成的图表默认就绑定了些数据，
            //这就是控件所定制而来。
            //图表轴向间距：可以按百分比控制设置
            NumericSeries series = new NumericSeries();
            /*series.Points.Add(new NumericDataPoint(10, "扣2分", false));
            series.Points.Add(new NumericDataPoint(20, "扣1分", false));
            series.Points.Add(new NumericDataPoint(70, "正常", false));*/
            double total = 62 + 41 + 188;

            series.Points.Add(new NumericDataPoint(62 / total * 100, "扣2分", false));
            series.Points.Add(new NumericDataPoint(41 / total * 100, "扣1分", false));
            series.Points.Add(new NumericDataPoint(188 / total * 100, "正常", false));


            //series.Points.Add(new NumericDataPoint(10, "Up", false));
            //series.Points.Add(new NumericDataPoint(15, "Warning", false));
            //series.Points.Add(new NumericDataPoint(20, "Critical", false));
            //series.Points.Add(new NumericDataPoint(24, "Down", false));
            //series.Points.Add(new NumericDataPoint(15, "Unknown", false));
            //series.Points.Add(new NumericDataPoint(1, "Unreachable", false));

            UltraPieChart_scls.CompositeChart.Series.Add(series);

            /*series = new NumericSeries();
            total = 77 + 55 + 208;
            series.Points.Add(new NumericDataPoint(77 / total * 100, "扣2分", false));
            series.Points.Add(new NumericDataPoint(55 / total * 100, "扣1分", false));
            series.Points.Add(new NumericDataPoint(208 / total * 100, "正常", false));
            UltraPieChart_dc.CompositeChart.Series.Add(series);*/

            UltraPieChart_scls.TitleTop.Text = "轧管";

            UltraPieChart_scls.Axis.Y.Labels.Visible = false;
            UltraPieChart_scls.Axis.Y.TickmarkStyle = AxisTickStyle.Percentage;
            UltraPieChart_scls.Axis.Y.TickmarkPercentage = 10;
            //图表轴向间距：可以按照指定数据间隔设置
            UltraPieChart_scls.Axis.Y.TickmarkStyle = AxisTickStyle.DataInterval;
            UltraPieChart_scls.Axis.Y.TickmarkInterval = 15;
            //设置图表轴向标签倾角
            UltraPieChart_scls.Axis.X.Labels.Orientation = Infragistics.UltraChart.Shared.Styles.TextOrientation.Custom;
            UltraPieChart_scls.Axis.X.Labels.OrientationAngle = 240;
            UltraPieChart_scls.Axis.X.Labels.Flip = true;
            //在饼图上显示提示信息来代替显示数据百分比值
            UltraPieChart_scls.PieChart.Labels.Format = Infragistics.UltraChart.Shared.Styles.PieLabelFormat.ItemLabel;
            UltraPieChart_scls.PieChart.Labels.FormatString = "<ITEM_LABEL>";
            UltraPieChart_scls.PieChart.Labels.Visible = false;
            UltraPieChart_scls.CompositeChart.ChartAreas.Add(myChartArea);

            Infragistics.UltraChart.Resources.Appearance.CompositeLegend myLegend = new Infragistics.UltraChart.Resources.Appearance.CompositeLegend();
            myLegend.Bounds = new Rectangle(0, 75, 20, 25);
            myLegend.BoundsMeasureType = MeasureType.Percentage;
            myLegend.PE.ElementType = PaintElementType.Gradient;
            myLegend.PE.FillGradientStyle = GradientStyle.ForwardDiagonal;
            myLegend.PE.Fill = Color.CornflowerBlue;
            myLegend.PE.FillStopColor = Color.Transparent;
            myLegend.Border.CornerRadius = 10;
            myLegend.Border.Thickness = 0;
            this.UltraPieChart_scls.CompositeChart.Legends.Add(myLegend);



        }


        private void AddTreeNode(UltraTree myUltraTree, UltraTreeNode node, UltraTreeNode parentnode)
        {
            if (parentnode != null)
            {
                parentnode.Nodes.Add(node);
            }
            else
            {
                myUltraTree.Nodes.Add(node);
            }
        }


        private void setgridcolunmName(Infragistics.Win.UltraWinGrid.UltraGrid ultraGrid, String sign)
        {
            Dictionary<string, string> gridcolunmnames = new Dictionary<string, string>();
            if (sign == "DC")
            {
                gridcolunmnames.Add("PROCESSCODE", "大工序");
                gridcolunmnames.Add("AREA", "区域");
                gridcolunmnames.Add("AREA_CODE", "区域代码");
                gridcolunmnames.Add("DEPT", "部门");
                gridcolunmnames.Add("DEPT_CODE", "部门代码");
                gridcolunmnames.Add("PLINE_NAME", "产线名称");
                gridcolunmnames.Add("PLINE_CODE", "产线代码");
                gridcolunmnames.Add("HEAT_PLAN_NO", "本工序炉计划ID");
                gridcolunmnames.Add("JUDGE_STOVE_NO", "判定炉号");
                gridcolunmnames.Add("CREATE_TIME", "炉计划创建时间");
                gridcolunmnames.Add("BJ_TIME", "比较时间");
                gridcolunmnames.Add("DC_HOURS", "待产小时数");
                gridcolunmnames.Add("DC_DAYS", "待产天数");
                gridcolunmnames.Add("KF", "扣分");
                gridcolunmnames.Add("KFSM", "扣分说明");
                gridcolunmnames.Add("PLANSTATUS", "计划状态");
                gridcolunmnames.Add("ORDERNO", "合同号");
                gridcolunmnames.Add("CREATETIME", "创建时间");

                gridcolunmnames.Add("SPEC_NAME", "规格");
                gridcolunmnames.Add("STEELNAME", "钢级");
                gridcolunmnames.Add("PRODUCNAME", "品种");
                gridcolunmnames.Add("MODEL_DESC", "扣型");
                gridcolunmnames.Add("PLN_OUTSINGLE_NUM", "支数");
                gridcolunmnames.Add("PLN_OUTSINGLE_W", "重量");
                gridcolunmnames.Add("QZ", "权重");
                gridcolunmnames.Add("cl_status".ToUpper(), "已处理否");
            }
            else if (sign == "QX")
            {
                gridcolunmnames.Add("PROCESSCODE", "大工序");
                gridcolunmnames.Add("AREA", "区域");
                gridcolunmnames.Add("AREA_CODE", "区域代码");
                gridcolunmnames.Add("DEPT", "部门");
                gridcolunmnames.Add("DEPT_CODE", "部门代码");
                gridcolunmnames.Add("PLINE_NAME", "产线名称");
                gridcolunmnames.Add("PLINE_CODE", "产线代码");
                gridcolunmnames.Add("HEAT_PLAN_NO", "本工序炉计划ID");
                gridcolunmnames.Add("JUDGE_STOVE_NO", "判定炉号");
                gridcolunmnames.Add("feed_heat_no".ToUpper(), "上料炉号");
                gridcolunmnames.Add("feed_time".ToUpper(), "上料时间");
                gridcolunmnames.Add("FX_time".ToUpper(), "返线时间");
                gridcolunmnames.Add("BJ_TIME", "比较时间");
                gridcolunmnames.Add("DC_HOURS", "在线小时数");
                gridcolunmnames.Add("DC_DAYS", "在线天数");
                gridcolunmnames.Add("KF", "扣分");
                gridcolunmnames.Add("KFSM", "扣分说明");
                gridcolunmnames.Add("ORDERNO", "合同号");
                gridcolunmnames.Add("nowork_times_days".ToUpper(), "某天非工作小时");
                gridcolunmnames.Add("nowork_times_days_desc".ToUpper(), "某天非工作小时说明");
                gridcolunmnames.Add("nowork_times".ToUpper(), "每天非工作小时说明");
                gridcolunmnames.Add("nowork_times_desc".ToUpper(), "每天非工作小时说明");
                gridcolunmnames.Add("nowork_days".ToUpper(), "非工作日天数");
                gridcolunmnames.Add("nowork_days_desc".ToUpper(), "非工作日说明");
                gridcolunmnames.Add("CREATETIME", "创建时间");
                gridcolunmnames.Add("QZ", "权重");
                gridcolunmnames.Add("cl_status".ToUpper(), "已处理否");
            }
            else if (sign == "DPSP")
            {
                gridcolunmnames.Add("PROCESSCODE", "大工序");
                gridcolunmnames.Add("AREA", "区域");
                gridcolunmnames.Add("AREA_CODE", "区域代码");
                gridcolunmnames.Add("DEPT", "部门");
                gridcolunmnames.Add("DEPT_CODE", "部门代码");
                gridcolunmnames.Add("PLINE_NAME", "产线名称");
                gridcolunmnames.Add("PLINE_CODE", "产线代码");
                gridcolunmnames.Add("HEAT_PLAN_NO", "本工序炉计划ID");
                gridcolunmnames.Add("JUDGE_STOVE_NO", "判定炉号");
                gridcolunmnames.Add("batch_no".ToUpper(), "批号");
                gridcolunmnames.Add("in_time".ToUpper(), "入库时间");
                gridcolunmnames.Add("sp_time".ToUpper(), "送判时间");
                gridcolunmnames.Add("BJ_TIME", "比较时间");
                gridcolunmnames.Add("DC_HOURS", "待送判小时数");
                gridcolunmnames.Add("DC_DAYS", "待送判天数");
                gridcolunmnames.Add("KF", "扣分");
                gridcolunmnames.Add("KFSM", "扣分说明");
                gridcolunmnames.Add("ORDERNO", "合同号");
                gridcolunmnames.Add("CREATETIME", "创建时间");
                gridcolunmnames.Add("QZ", "权重");
                gridcolunmnames.Add("cl_status".ToUpper(), "已处理否");
            }
            else if (sign == "DPPD")
            {
                gridcolunmnames.Add("PROCESSCODE", "大工序");
                gridcolunmnames.Add("AREA", "区域");
                gridcolunmnames.Add("AREA_CODE", "区域代码");
                gridcolunmnames.Add("DEPT", "部门");
                gridcolunmnames.Add("DEPT_CODE", "部门代码");
                gridcolunmnames.Add("PLINE_NAME", "产线名称");
                gridcolunmnames.Add("PLINE_CODE", "产线代码");
                gridcolunmnames.Add("HEAT_PLAN_NO", "本工序炉计划ID");
                gridcolunmnames.Add("JUDGE_STOVE_NO", "判定炉号");
                gridcolunmnames.Add("batch_no".ToUpper(), "批号");
                gridcolunmnames.Add("sp_time".ToUpper(), "送判时间");
                gridcolunmnames.Add("pd_time".ToUpper(), "判定时间");
                gridcolunmnames.Add("BJ_TIME", "比较时间");
                gridcolunmnames.Add("DC_HOURS", "待判定小时数");
                gridcolunmnames.Add("DC_DAYS", "待判定天数");
                gridcolunmnames.Add("KF", "扣分");
                gridcolunmnames.Add("KFSM", "扣分说明");
                gridcolunmnames.Add("ORDERNO", "合同号");
                gridcolunmnames.Add("CREATETIME", "创建时间");
                gridcolunmnames.Add("QZ", "权重");
                gridcolunmnames.Add("cl_status".ToUpper(), "已处理否");
            }
            else if (sign == "LXWT")
            {
                gridcolunmnames.Add("PROCESSCODE", "大工序");
                gridcolunmnames.Add("AREA", "区域");
                gridcolunmnames.Add("AREA_CODE", "区域代码");
                gridcolunmnames.Add("DEPT", "部门");
                gridcolunmnames.Add("DEPT_CODE", "部门代码");
                gridcolunmnames.Add("PLINE_NAME", "产线名称");
                gridcolunmnames.Add("PLINE_CODE", "产线代码");
                gridcolunmnames.Add("HEAT_PLAN_NO", "本工序炉计划ID");
                gridcolunmnames.Add("JUDGE_STOVE_NO", "判定炉号");
                gridcolunmnames.Add("batch_no".ToUpper(), "批号");
                gridcolunmnames.Add("offline_time".ToUpper(), "离线时间");
                gridcolunmnames.Add("BJ_TIME", "比较时间");
                gridcolunmnames.Add("DC_HOURS", "待委托小时数");
                gridcolunmnames.Add("DC_DAYS", "待委托天数");
                gridcolunmnames.Add("KF", "扣分");
                gridcolunmnames.Add("KFSM", "扣分说明");
                gridcolunmnames.Add("ORDERNO", "合同号");
                gridcolunmnames.Add("CREATETIME", "创建时间");
                gridcolunmnames.Add("QZ", "权重");
                gridcolunmnames.Add("cl_status".ToUpper(), "已处理否");
            }
            else if (sign == "LXFX")
            {
                gridcolunmnames.Add("PROCESSCODE", "大工序");
                gridcolunmnames.Add("AREA", "区域");
                gridcolunmnames.Add("AREA_CODE", "区域代码");
                gridcolunmnames.Add("DEPT", "部门");
                gridcolunmnames.Add("DEPT_CODE", "部门代码");
                gridcolunmnames.Add("PLINE_NAME", "产线名称");
                gridcolunmnames.Add("PLINE_CODE", "产线代码");
                gridcolunmnames.Add("HEAT_PLAN_NO", "本工序炉计划ID");
                gridcolunmnames.Add("JUDGE_STOVE_NO", "判定炉号");
                gridcolunmnames.Add("batch_no".ToUpper(), "批号");
                gridcolunmnames.Add("wg_time".ToUpper(), "委托完工时间");
                gridcolunmnames.Add("BJ_TIME", "比较时间");
                gridcolunmnames.Add("DC_HOURS", "待上线小时数");
                gridcolunmnames.Add("DC_DAYS", "待上线天数");
                gridcolunmnames.Add("KF", "扣分");
                gridcolunmnames.Add("KFSM", "扣分说明");
                gridcolunmnames.Add("ORDERNO", "合同号");
                gridcolunmnames.Add("CREATETIME", "创建时间");
                gridcolunmnames.Add("QZ", "权重");
                gridcolunmnames.Add("cl_status".ToUpper(), "已处理否");
            }
            else if (sign == "FP")
            {
                gridcolunmnames.Add("PROCESSCODE", "大工序");
                gridcolunmnames.Add("AREA", "区域");
                gridcolunmnames.Add("AREA_CODE", "区域代码");
                gridcolunmnames.Add("DEPT", "部门");
                gridcolunmnames.Add("DEPT_CODE", "部门代码");
                gridcolunmnames.Add("PLINE_NAME", "产线名称");
                gridcolunmnames.Add("PLINE_CODE", "产线代码");
                gridcolunmnames.Add("HEAT_PLAN_NO", "本工序炉计划ID");
                gridcolunmnames.Add("JUDGE_STOVE_NO", "判定炉号");
                gridcolunmnames.Add("batch_no".ToUpper(), "批号");
                gridcolunmnames.Add("in_time".ToUpper(), "废品入库时间");
                gridcolunmnames.Add("BJ_TIME", "比较时间");
                gridcolunmnames.Add("DC_HOURS", "待返废小时数");
                gridcolunmnames.Add("DC_DAYS", "待返废天数");
                gridcolunmnames.Add("KF", "扣分");
                gridcolunmnames.Add("KFSM", "扣分说明");
                gridcolunmnames.Add("ORDERNO", "合同号");
                gridcolunmnames.Add("CREATETIME", "创建时间");
                gridcolunmnames.Add("QZ", "权重");
                gridcolunmnames.Add("cl_status".ToUpper(), "已处理否");
            }
            else if (sign == "SCZQ_PZ")
            {
                gridcolunmnames.Add("produccode", "品种代码");
                gridcolunmnames.Add("producname", "品种名称");
                gridcolunmnames.Add("minwhole_backlog", "最短全工序流程码");
                gridcolunmnames.Add("maxwhole_backlog", "最长全工序流程码");
                gridcolunmnames.Add("countmaterial_no", "记录数");
                gridcolunmnames.Add("minworkhours", "最短生产周期");
                gridcolunmnames.Add("maxworkhours", "最长生产周期");
                gridcolunmnames.Add("avgworkhours", "平均生产周期");
                gridcolunmnames.Add("STDDEVworkhours", "生产周期标准差");
                gridcolunmnames.Add("STDDEV_SAMPworkhours", "生产周期样本标准差");
                gridcolunmnames.Add("VAR_POPworkhours", "生产周期方差");
                gridcolunmnames.Add("VAR_SAMPworkhours", "生产周期样本方差");
            }
            else if (sign == "SCZQ_WL")
            {
                gridcolunmnames.Add("produccode", "品种代码");
                gridcolunmnames.Add("producname", "品种名称");
                gridcolunmnames.Add("material_no", "物料码");
                gridcolunmnames.Add("material_name", "物料名");
                gridcolunmnames.Add("minwhole_backlog", "最短全工序流程码");
                gridcolunmnames.Add("maxwhole_backlog", "最长全工序流程码");
                gridcolunmnames.Add("countmaterial_no", "记录数");
                gridcolunmnames.Add("minworkhours", "最短生产周期");
                gridcolunmnames.Add("maxworkhours", "最长生产周期");
                gridcolunmnames.Add("avgworkhours", "平均生产周期");
                gridcolunmnames.Add("STDDEVworkhours", "生产周期标准差");
                gridcolunmnames.Add("STDDEV_SAMPworkhours", "生产周期样本标准差");
                gridcolunmnames.Add("VAR_POPworkhours", "生产周期方差");
                gridcolunmnames.Add("VAR_SAMPworkhours", "生产周期样本方差");
            }

            ultraGrid.DataBind();
            ultraGrid.DisplayLayout.Bands[0].Header.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
            ultraGrid.DisplayLayout.Bands[0].Header.Appearance.FontData.Name = "宋体";
            ultraGrid.DisplayLayout.Bands[0].Header.Appearance.FontData.SizeInPoints = 18;
            if (rB_dc.Checked)
            {
                ultraGrid.DisplayLayout.Bands[0].Header.Caption = rB_dc.Text;
            }
            else if (rB_qx.Checked)
            {
                ultraGrid.DisplayLayout.Bands[0].Header.Caption = rB_qx.Text;
            }
            else if (rB_dpsp.Checked)
            {
                ultraGrid.DisplayLayout.Bands[0].Header.Caption = rB_dpsp.Text;
            }
            else if (rB_dppd.Checked)
            {
                ultraGrid.DisplayLayout.Bands[0].Header.Caption = rB_dppd.Text;
            }
            else if (rB_lxwt.Checked)
            {
                ultraGrid.DisplayLayout.Bands[0].Header.Caption = rB_lxwt.Text;
            }
            else if (rB_lxfx.Checked)
            {
                ultraGrid.DisplayLayout.Bands[0].Header.Caption = rB_lxfx.Text;
            }
            else if (rB_fp.Checked)
            {
                ultraGrid.DisplayLayout.Bands[0].Header.Caption = rB_fp.Text;
            }
            if (gridcolunmnames != null && (sign == "DC" || sign == "QX" || sign == "DPSP" || sign == "DPPD"
                || sign == "LXWT" || sign == "LXFX" || sign == "FP" || sign == "SCZQ_PZ" || sign == "SCZQ_WL"))
            {
                ultraGrid.DisplayLayout.UseFixedHeaders = true;
                foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid.DisplayLayout.Bands)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                    {
                        column.Header.Caption = gridcolunmnames[column.Key].ToString();
                        if (column.Key == "AREA_CODE" || column.Key == "DEPT_CODE" || column.Key == "PLINE_CODE")
                        {
                            column.Hidden = true;
                        }
                        if (column.Key == "JUDGE_STOVE_NO")
                        {
                            for (int i = column.Index; i >= 0; i--)
                            {
                                band.Columns[i].Header.Fixed = true;
                            }
                        }
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                    }
                }


            }
            ultraGrid.Refresh();
        }

        private void ultraTree_scls_AfterSelect(object sender, SelectEventArgs e)
        {
            if (ultraTree_scls.ActiveNode != null && isnew == false)
            {
                DataTable dtqry2 = ((DataTable)ultraGrid_scls.DataSource).Copy();

                DataView dv = dtqry2.DefaultView;
                dv.RowFilter = "kf>0";
                dtqry2 = dv.ToTable();


                UltraTreeNode mynode = ultraTree_scls.ActiveNode;

                string columncharttitle = mynode.Text, piecharttitle = "";
                if (rB_dc.Checked)
                {
                    columncharttitle += "(" + rB_dc.Text + ")";
                    piecharttitle = rB_dc.Text;
                }
                else if (rB_qx.Checked)
                {
                    columncharttitle += "(" + rB_qx.Text + ")";
                    piecharttitle = rB_qx.Text;
                }
                else if (rB_dpsp.Checked)
                {
                    columncharttitle += "(" + rB_dpsp.Text + ")";
                    piecharttitle = rB_dpsp.Text;
                }
                else if (rB_dppd.Checked)
                {
                    columncharttitle += "(" + rB_dppd.Text + ")";
                    piecharttitle = rB_dppd.Text;
                }
                else if (rB_lxwt.Checked)
                {
                    columncharttitle += "(" + rB_lxwt.Text + ")";
                    piecharttitle = rB_lxwt.Text;
                }
                else if (rB_lxfx.Checked)
                {
                    columncharttitle += "(" + rB_lxfx.Text + ")";
                    piecharttitle = rB_lxfx.Text;
                }
                else if (rB_fp.Checked)
                {
                    columncharttitle += "(" + rB_fp.Text + ")";
                    piecharttitle = rB_fp.Text;
                }
                if ((UltraColumnChart_scls.TitleTop.Text.ToString() != mynode.Text || UltraColumnChart_scls.TitleBottom.Text.ToString() != piecharttitle) && mynode.Key == "1")
                {
                    getcolumnchart_scls(mynode.Text, UltraColumnChart_scls, dtqry2, "DGX");
                    getpiechart_scls(mynode.Nodes[0].Text, UltraPieChart_scls, dtqry2, "DGX");
                }
                else if ((UltraColumnChart_scls.TitleTop.Text.ToString() != mynode.Text || UltraColumnChart_scls.TitleBottom.Text.ToString() != piecharttitle)
                    && (mynode.Key == "A" || mynode.Key == "B" || mynode.Key == "D"
                    || mynode.Key == "E" || mynode.Key == "F" || mynode.Key == "G"))
                {
                    getcolumnchart_scls(mynode.Text.ToString(), UltraColumnChart_scls, dtqry2, "GX-BM");
                    getpiechart_scls(mynode.Nodes[0].Text, UltraPieChart_scls, dtqry2, "GX-BM");
                }
                else if ((UltraColumnChart_scls.TitleTop.Text.ToString() != mynode.Text || UltraColumnChart_scls.TitleBottom.Text.ToString() != piecharttitle)
                    && (mynode.Key.Substring(0, 1) == "A" || mynode.Key.Substring(0, 1) == "B"
                    || mynode.Key.Substring(0, 1) == "D" || mynode.Key.Substring(0, 1) == "E"
                    || mynode.Key.Substring(0, 1) == "F" || mynode.Key.Substring(0, 1) == "G"))
                {
                    getcolumnchart_scls(mynode.Parent.Text + "：" + mynode.Text.ToString(), UltraColumnChart_scls, dtqry2, "BM-CX");
                    getpiechart_scls(mynode.Nodes[0].Text, UltraPieChart_scls, dtqry2, "BM-CX");
                }
            }

        }


        private void UltraColumnChart_scls_DataItemOver(object sender, Infragistics.UltraChart.Shared.Events.ChartDataEventArgs e)
        {
            if (e.RowLabel != UltraPieChart_scls.TitleTop.Text)
            {
                UltraTreeNode mynode = ultraTree_scls.ActiveNode;
                DataTable dtqry = ((DataTable)ultraGrid_scls.DataSource).Copy();
                //e.RowLabel
                //getcolumnchart_dc(ultraTree_dc.ActiveNode.ToString(), UltraColumnChart_dc, dtqry, "");
                if (UltraColumnChart_scls.TitleTop.Text == "大工序")
                {
                    getpiechart_scls(e.RowLabel, UltraPieChart_scls, dtqry, "DGX");
                }
                else if (UltraColumnChart_scls.TitleTop.Text == mynode.Text && (UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "A" || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "B"
                    || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "D" || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "E"
                    || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "F" || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "G"))
                {
                    getpiechart_scls(e.RowLabel, UltraPieChart_scls, dtqry, "GX-BM");
                }
                else if (UltraColumnChart_scls.TitleTop.Text != mynode.Text && (UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "A" || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "B"
                    || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "D" || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "E"
                    || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "F" || UltraColumnChart_scls.TitleTop.Text.Substring(0, 1) == "G"))
                {
                    getpiechart_scls(e.RowLabel, UltraPieChart_scls, dtqry, "BM-CX");
                }
            }
        }

        private void UltraColumnChart_scls_ChartDataClicked(object sender, Infragistics.UltraChart.Shared.Events.ChartDataEventArgs e)
        {
            UltraTreeNode mynode = ultraTree_scls.ActiveNode;
            if (ultraTree_scls.ActiveNode.Text == "大工序" || ultraTree_scls.ActiveNode.Text.Substring(0, 2) == "A-"
                || ultraTree_scls.ActiveNode.Text.Substring(0, 2) == "B-" || ultraTree_scls.ActiveNode.Text.Substring(0, 2) == "D-"
                || ultraTree_scls.ActiveNode.Text.Substring(0, 2) == "E-" || ultraTree_scls.ActiveNode.Text.Substring(0, 2) == "F-"
                || ultraTree_scls.ActiveNode.Text.Substring(0, 2) == "G-" || ultraTree_scls.ActiveNode.Parent.Text.Substring(0, 2) == "A-"
                || ultraTree_scls.ActiveNode.Parent.Text.Substring(0, 2) == "B-" || ultraTree_scls.ActiveNode.Parent.Text.Substring(0, 2) == "D-"
                || ultraTree_scls.ActiveNode.Parent.Text.Substring(0, 2) == "E-" || ultraTree_scls.ActiveNode.Parent.Text.Substring(0, 2) == "F-"
                || ultraTree_scls.ActiveNode.Parent.Text.Substring(0, 2) == "G-")
            {
                foreach (UltraTreeNode childnode in mynode.Nodes)
                {
                    if (childnode.Text == e.RowLabel)
                    {
                        ultraTree_scls.ActiveNode = childnode;
                        childnode.Selected = true;
                        break;
                    }
                }
            }
        }
        private void getdata(bool isgetdate)
        {
            if (isgetdate)
            {
                getscls();
            }
        }
        private void rB_dc_CheckedChanged(object sender, EventArgs e)
        {
            getdata(rB_dc.Checked);
        }

        private void rB_qx_CheckedChanged(object sender, EventArgs e)
        {
            getdata(rB_qx.Checked);
        }

        private void rB_dpsp_CheckedChanged(object sender, EventArgs e)
        {
            getdata(rB_dpsp.Checked);
        }

        private void rB_dppd_CheckedChanged(object sender, EventArgs e)
        {
            getdata(rB_dppd.Checked);
        }

        private void rB_lxwt_CheckedChanged(object sender, EventArgs e)
        {
            getdata(rB_lxwt.Checked);
        }

        private void rB_lxfx_CheckedChanged(object sender, EventArgs e)
        {
            getdata(rB_lxfx.Checked);
        }

        private void rB_fp_CheckedChanged(object sender, EventArgs e)
        {
            getdata(rB_fp.Checked);
        }








        private void ultraTree_scls_qj_AfterSelect(object sender, SelectEventArgs e)
        {
            if (ultraTree_scls_qj.ActiveNode != null && isnew_qj == false)
            {
                UltraTreeNode mynode = ultraTree_scls_qj.ActiveNode;

                if (UltraChart_scls_qj.TitleTop.Text.ToString() != mynode.Text)
                {
                    if (mynode.Key.Length == 1)
                        getlinechart_scls_qj(UltraChart_scls_qj, dtqry1, "DGX");
                    else if (mynode.Parent.Key.Length == 1)
                        getlinechart_scls_qj(UltraChart_scls_qj, dtqry1, "GX-BM");
                    else
                        getlinechart_scls_qj(UltraChart_scls_qj, dtqry1, "BM-CX");
                }
            }
        }

        private void ultraGrid_wl_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (e.Cell.Column.Key == "material_no")
            {
                string mydate1 = ((DateTime)this.fromdate.Value).ToString("yyyy-MM-dd");
                string mydate2 = ((DateTime)this.todate.Value).ToString("yyyy-MM-dd");
                DataTable mytable = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_SCLS_L", new object[] { mydate1, mydate2, e.Cell.Text }, this.ob);
                if (mytable.Rows.Count > 0)
                {
                    RptProduction_detail mypopup = new RptProduction_detail(mytable, "品名：" + e.Cell.Row.Cells["producname"].Text + "，物料：" + e.Cell.Row.Cells["material_name"].Text, "流程码");
                    mypopup.ShowDialog();
                }
            }

        }

        private void ultraGrid_pzwl_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            if (e.Cell.Column.Key == "material_no")
            {
                string mydate1 = ((DateTime)this.fromdate.Value).ToString("yyyy-MM-dd");
                string mydate2 = ((DateTime)this.todate.Value).ToString("yyyy-MM-dd");
                DataTable mytable = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getSCLS_SCLS_L", new object[] { mydate1, mydate2, e.Cell.Text }, this.ob);
                if (mytable.Rows.Count > 0)
                {
                    RptProduction_detail mypopup = new RptProduction_detail(mytable, "品名：" + e.Cell.Row.Cells["producname"].Text + "，物料：" + e.Cell.Row.Cells["material_name"].Text, "流程码");
                    mypopup.ShowDialog();
                }
            }
        }



        public class CustomMergedCellEvaluator : Infragistics.Win.UltraWinGrid.IMergedCellEvaluator
        {
            private string primaryKey;
            ///   
            /// 获取或设置合并列的主键列的绑定名称  
            ///   
            public string PrimaryKey
            {
                get { return primaryKey; }
                set { primaryKey = value; }
            }
            ///   
            /// CustomMergedCellEvaluator 的构造函数  
            ///   
            /// 主键列的绑定名称  
            public CustomMergedCellEvaluator(string primaryKey)
            {
                this.primaryKey = primaryKey;
            }
            #region IMergedCellEvaluator 成员
            public bool ShouldCellsBeMerged(Infragistics.Win.UltraWinGrid.UltraGridRow row1, Infragistics.Win.UltraWinGrid.UltraGridRow row2, Infragistics.Win.UltraWinGrid.UltraGridColumn column)
            {
                //确认逻辑：如果是主键列，自动合并，否则通过联合主键来合并  
                if (column.MergedCellStyle == Infragistics.Win.UltraWinGrid.MergedCellStyle.Always)
                {
                    if (string.IsNullOrEmpty(this.primaryKey))
                    {
                        return row1.GetCellText(column) == row2.GetCellText(column);
                    }
                    if ((row1.GetCellValue(row1.Cells[this.primaryKey].Column).ToString() == row2.GetCellValue(row1.Cells[this.primaryKey].Column).ToString()) && (row1.GetCellText(column) == row2.GetCellText(column)))
                    {
                        return true;
                    }
                }
                return false;
            }
            #endregion
        }


        private void getcolumnchart_scls_qj(UltraChart mychart, DataTable myData, string sign)
        {
            string myselectstr = "";

            // 在此处放置用户代码以初始化页面   

            //step1:Change the ChartType property to "Composite."   
            mychart.ChartType = ChartType.Composite;
            mychart.TitleTop.Font = new System.Drawing.Font("Microsoft Sans Serif", 9F, System.Drawing.FontStyle.Bold);

            /*if (rB_dc_qj.Checked)
                mychart.TitleBottom.Text = rB_dc_qj.Text;
            else if (rB_qx_qj.Checked)
                mychart.TitleBottom.Text = rB_qx_qj.Text;
            else if (rB_dpsp_qj.Checked)
                mychart.TitleBottom.Text = rB_dpsp_qj.Text;
            else if (rB_dppd_qj.Checked)
                mychart.TitleBottom.Text = rB_dppd_qj.Text;
            else if (rB_lxwt_qj.Checked)
                mychart.TitleBottom.Text = rB_lxwt_qj.Text;
            else if (rB_lxfx_qj.Checked)
                mychart.TitleBottom.Text = rB_lxfx_qj.Text;
            else if (rB_fp_qj.Checked)
                mychart.TitleBottom.Text = rB_fp_qj.Text;*/

            //step2:Add a ChartArea to the ChartAreas collection.    
            ChartArea myChartArea = new ChartArea();
            myChartArea.BoundsMeasureType = MeasureType.Percentage;
            myChartArea.Bounds = new Rectangle(0, 10, 100, 80);
            myChartArea.Border.Thickness = 0;


            mychart.CompositeChart.ChartAreas.Add(myChartArea);


            //step3:Add some Axes to the ChartArea.    
            AxisItem axisX = new AxisItem();
            axisX.OrientationType = AxisNumber.X_Axis;
            axisX.DataType = AxisDataType.String;
            axisX.StripLines.Interval = 15;
            axisX.TickmarkStyle = AxisTickStyle.Smart;
            //axisX.Margin.ResetFar();
            axisX.SetLabelAxisType = SetLabelAxisType.GroupBySeries;



            axisX.Labels.ItemFormatString = "<ITEM_LABEL>";
            axisX.Labels.Orientation = TextOrientation.VerticalLeftFacing;
            axisX.Labels.OrientationAngle = 80;
            axisX.Labels.Visible = false;
            axisX.Labels.SeriesLabels.Orientation = TextOrientation.Custom;//.VerticalLeftFacing;
            axisX.Labels.SeriesLabels.OrientationAngle = 250;
            axisX.Labels.SeriesLabels.Flip = true;


            /*axisX.LineThickness = 1;
            axisX.MajorGridLines.AlphaLevel = ((byte)(255));
            axisX.MajorGridLines.Color = System.Drawing.Color.Gainsboro;
            axisX.MajorGridLines.DrawStyle = Infragistics.UltraChart.Shared.Styles.LineDrawStyle.Dot;
            axisX.MajorGridLines.Thickness = 1;
            axisX.MajorGridLines.Visible = true;*/



            AxisItem axisY = new AxisItem();
            axisY.OrientationType = AxisNumber.Y_Axis;
            axisY.DataType = AxisDataType.Numeric;
            axisY.Labels.ItemFormatString = "<DATA_VALUE:0.#>";

            axisY.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Near;
            //axisY.Labels.VerticalAlign = System.Drawing.StringAlignment.Near;

            AxisItem axisY1 = new AxisItem();
            axisY1.OrientationType = AxisNumber.Y2_Axis;
            axisY1.DataType = AxisDataType.Numeric;
            axisY1.TickmarkStyle = AxisTickStyle.Percentage;
            axisY1.TickmarkPercentage = 10;
            axisY1.Labels.ItemFormatString = "<DATA_VALUE:0.#>";
            axisY1.Labels.SeriesLabels.VerticalAlign = System.Drawing.StringAlignment.Near;


            myChartArea.Axes.Add(axisX);
            myChartArea.Axes.Add(axisY);
            myChartArea.Axes.Add(axisY1);


            //step4:Add some data series to the Series collection.
            string series_Label = "", selectstr, Point_value;

            DataView mydataview = myData.DefaultView;
            if (sign == "DGX")
            {
                mydataview.RowFilter = "processcode='" + ultraTree_scls_qj.ActiveNode.Key + "'";
                mydataview.Sort = "createtime";
                myData = mydataview.ToTable();
                mychart.TitleTop.Text = getprocess(myData.Rows[0]["processcode"].ToString());
                series_Label = myData.Rows[0]["createtime"].ToString().Substring(0, 10);
            }
            else if (sign == "GX-BM")
            {
                mydataview.RowFilter = "processcode+dept_code='" + ultraTree_scls_qj.ActiveNode.Key + "'";
                mydataview.Sort = "createtime";
                myData = mydataview.ToTable();
                mychart.TitleTop.Text = getprocess(myData.Rows[0]["processcode"].ToString()) + "：" + myData.Rows[0]["dept"];
                series_Label = myData.Rows[0]["createtime"].ToString().Substring(0, 10);
            }
            else if (sign == "BM-CX")
            {
                mydataview.RowFilter = "pline_code='" + ultraTree_scls_qj.ActiveNode.Key + "'";
                mydataview.Sort = "createtime";
                myData = mydataview.ToTable();
                mychart.TitleTop.Text = getprocess(myData.Rows[0]["processcode"].ToString()) + " - " + myData.Rows[0]["dept"] + "：" + myData.Rows[0]["pline_name"].ToString();
                series_Label = myData.Rows[0]["createtime"].ToString().Substring(0, 10);
            }

            myselectstr = " createtime like '" + series_Label + "%'";
            NumericSeries series = new NumericSeries();
            NumericSeries lineSeries = new NumericSeries();



            series.Points.Clear();
            string myLabel = series_Label;
            int i = 0, hj = 0;
            foreach (DataRow mykfrow in kfdataTable_qj.Rows)
            {
                if (columnchartpoint_qj[i] != "")
                {
                    selectstr = myselectstr + " and kf=" + mykfrow["kf"].ToString();
                    Point_value = myData.Compute("count(kf)", selectstr).ToString();
                    if (Point_value == "")
                        Point_value = "0";
                    series.Points.Add(new NumericDataPoint(Convert.ToDouble(Point_value), columnchartpoint_qj[i], false));
                    lineSeries.Points.Add(new NumericDataPoint(Convert.ToDouble(Point_value), columnchartpoint_qj[i], false));

                }
                i++;
            }

            series.Label = series_Label;
            mychart.Data.MinValue = 0;
            //mychart.CompositeChart.Series.Add(series);

            //step5:Add a chart layer. 
            ChartLayerAppearance myColumnLayer = new ChartLayerAppearance();
            myColumnLayer.ChartType = ChartType.StackColumnChart;//.ColumnChart;
            myColumnLayer.ChartArea = myChartArea;
            myColumnLayer.AxisX = axisX;
            myColumnLayer.AxisY = axisY;
            myColumnLayer.AxisY2 = axisY1;

            myColumnLayer.Series.Clear();
            myColumnLayer.Series.Add(series);


            ChartLayerAppearance lineLayer = new ChartLayerAppearance();
            lineLayer.ChartType = ChartType.LineChart;
            lineLayer.AxisX = axisX;
            lineLayer.AxisY = axisY;
            lineLayer.AxisY2 = axisY1;
            lineLayer.ChartArea = myChartArea;
            lineLayer.Series.Clear();
            lineLayer.Series.Add(lineSeries);

            foreach (DataRow myrow in myData.Rows)
            {
                /*series = new NumericSeries();
                series.Points.Add(new NumericDataPoint(Convert.ToDouble(0), "", false));
                series.Points.Add(new NumericDataPoint(Convert.ToDouble(0), "", false));
                series.Label = "";
                mychart.CompositeChart.Series.Add(series);
                myColumnLayer.Series.Add(series);)*/

                series_Label = myrow["createtime"].ToString().Substring(0, 10);
                if (myLabel != series_Label)
                {
                    series = new NumericSeries();
                    lineSeries = new NumericSeries();

                    myLabel = series_Label;
                    series.Label = series_Label;
                    myselectstr = myselectstr = " createtime like '" + series_Label + "%'";
                    i = 0;
                    foreach (DataRow mykfrow in kfdataTable_qj.Rows)
                    {
                        if (columnchartpoint_qj[i] != "")
                        {
                            selectstr = myselectstr + " and kf=" + mykfrow["kf"].ToString();
                            Point_value = myData.Compute("count(kf)", selectstr).ToString();
                            if (Point_value == "")
                                Point_value = "0";
                            series.Points.Add(new NumericDataPoint(Convert.ToDouble(Point_value), columnchartpoint_qj[i], false));
                            lineSeries.Points.Add(new NumericDataPoint(Convert.ToDouble(Point_value), columnchartpoint_qj[i], false));
                        }
                        i++;
                    }
                    //mychart.CompositeChart.Series.Add(series);
                    myColumnLayer.Series.Add(series);
                    lineLayer.Series.Add(lineSeries);

                }
            }
            mychart.CompositeChart.ChartLayers.Clear();
            mychart.CompositeChart.ChartLayers.Add(myColumnLayer);
            mychart.CompositeChart.ChartLayers.Add(lineLayer);

            //step6:Add a legend to the chart.    
            //CompositeLegend myLegend = new CompositeLegend();   
            //CompositeLegend a = new CompositeLegend();   

            Infragistics.UltraChart.Resources.Appearance.CompositeLegend myLegend = new Infragistics.UltraChart.Resources.Appearance.CompositeLegend();

            myLegend.ChartLayers.Add(myColumnLayer);
            myLegend.Bounds = new Rectangle(2, 90, 10, 9);
            myLegend.BoundsMeasureType = MeasureType.Percentage;
            myLegend.PE.ElementType = PaintElementType.Gradient;
            myLegend.PE.FillGradientStyle = GradientStyle.ForwardDiagonal;
            myLegend.PE.Fill = Color.CornflowerBlue;
            myLegend.PE.FillStopColor = Color.Transparent;
            myLegend.Border.CornerRadius = 10;
            myLegend.Border.Thickness = 0;

            mychart.CompositeChart.Legends.Clear();
            mychart.CompositeChart.Legends.Add(myLegend);

        }
        private void getsclsline(bool isgetdate)
        {
            if (isgetdate)
            {
                if (ultraTree_scls_qj.ActiveNode != null)
                {
                    UltraTreeNode mynode = ultraTree_scls_qj.ActiveNode;
                    if (mynode.Key.Length == 1)
                        getlinechart_scls_qj(UltraChart_scls_qj, dtqry1, "DGX");
                    else if (mynode.Parent.Key.Length == 1)
                        getlinechart_scls_qj(UltraChart_scls_qj, dtqry1, "GX-BM");
                    else
                        getlinechart_scls_qj(UltraChart_scls_qj, dtqry1, "BM-CX");
                }
                else
                    getscls_qj();
            }
        }
        private void rB_line_CheckedChanged(object sender, EventArgs e)
        {
            getsclsline(rB_line.Checked);
        }

        private void rB_Radar_CheckedChanged(object sender, EventArgs e)
        {
            getsclsline(rB_Radar.Checked);
        }

        private void setcB()
        {
            int i = 0,j=0;
            CheckBox[] mycB=new CheckBox[7];
            if (!cB_dcqj.Checked)
                i++;
            else
            {
                mycB[j]=cB_dcqj;
                j++;
            }
            if (!cB_qxqj.Checked)
                i++;
            else
            {
                mycB[j]=cB_qxqj;
                j++;
            }
            if (!cB_dpspqj.Checked)
                i++;
            else
            {
                mycB[j]=cB_dpspqj;
                j++;
            }
            if (!cB_dppdqj.Checked)
                i++;
            else
            {
                mycB[j]=cB_dppdqj;
                j++;
            }
            if (!cB_lxwtqj.Checked)
                i++;
            else
            {
                mycB[j]=cB_lxwtqj;
                j++;
            }
            if (!cB_lxfxqj.Checked)
                i++;
            else
            {
                mycB[j]=cB_lxfxqj;
                j++;
            }
            if (!cB_fpqj.Checked)
                i++;
            else
            {
                mycB[j]=cB_fpqj;
                j++;
            }
            if (i == 6)
                mycB[0].Enabled = false;
            else if (i == 5)
            {
                foreach (CheckBox cb in mycB)
                {
                    if (cb!=null && cb.Enabled == false)
                        cb.Enabled = true;
                }
            }


        }

        private void cB_dcqj_CheckedChanged(object sender, EventArgs e)
        {
                setcB();
        }

        private void cB_qxqj_CheckedChanged(object sender, EventArgs e)
        {
                setcB();
        }

        private void cB_dpspqj_CheckedChanged(object sender, EventArgs e)
        {
                setcB();
        }

        private void cB_dppdqj_CheckedChanged(object sender, EventArgs e)
        {
                setcB();
        }

        private void cB_lxwtqj_CheckedChanged(object sender, EventArgs e)
        {
                setcB();
        }

        private void cB_lxfxqj_CheckedChanged(object sender, EventArgs e)
        {
                setcB();
        }

        private void cB_fpqj_CheckedChanged(object sender, EventArgs e)
        {
                setcB();
        }


        private void getupdatescls()
        {
            WaitingForm2 wf = new WaitingForm2("正在更新最新数据,请稍候....");
            try
            {
                string mydate = ((DateTime)this.rptdate.Value).ToString("yyyy-MM-dd");
                string mymethodid = "", sign = "";
                DataTable dtqry = new DataTable();
                if (rB_dc.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getUpdateDC";
                    sign = "DC";
                }
                else if (rB_qx.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getUpdateQX";
                    sign = "QX";
                }
                else if (rB_dpsp.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getUpdateDPSP";
                    sign = "DPSP";
                }
                else if (rB_dppd.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getUpdateDPPD";
                    sign = "DPPD";
                }
                else if (rB_lxwt.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getUpdateLXWT";
                    sign = "LXWT";
                }
                else if (rB_lxfx.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getUpdateLXFX";
                    sign = "LXFX";
                }
                else if (rB_fp.Checked)
                {
                    mymethodid = "com.steering.rpt.scls.SCLS.getUpdateFP";
                    sign = "FP";
                }
                if (mymethodid != "")
                {
                    dtqry = ServerHelper.GetData(mymethodid, new object[] { mydate }, this.ob);
                    wf.Close();
                    DataTable dtqry1 = dtqry.Clone();
                    dtqry1.Columns["kf"].DataType = typeof(decimal);
                    dtqry1.Columns["qz"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("dc_hours") >= 0)
                        dtqry1.Columns["dc_hours"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("dc_days") >= 0)
                        dtqry1.Columns["dc_days"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("PLN_OUTSINGLE_NUM") >= 0)
                        dtqry1.Columns["PLN_OUTSINGLE_NUM"].DataType = typeof(decimal);
                    if (dtqry1.Columns.IndexOf("PLN_OUTSINGLE_W") >= 0)
                        dtqry1.Columns["PLN_OUTSINGLE_W"].DataType = typeof(decimal);
                    foreach (DataRow dr in dtqry.Rows)
                    {
                        dtqry1.ImportRow(dr);
                    }
                    ultraGrid_scls.DataSource = dtqry1;
                    setgridcolunmName(ultraGrid_scls, sign);
                }
            }
            catch (Exception e)
            {
                wf.Close();
                MessageBox.Show(e.Message);
            }
            finally
            {
            }
        }

        private void contextMenuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            if (e.ClickedItem.Text == "更新最新数据" && ((DateTime)this.rptdate.Value).ToString("yyyy-MM-dd") == DateTime.Today.ToString("yyyy-MM-dd"))
                getupdatescls();
        }

        private void gethtzq()
        {
            WaitingForm2 wf = new WaitingForm2("正在加载数据,请稍候....");
            try
            {
                DataTable dtqry1 = ServerHelper.GetData("com.steering.rpt.scls.SCLS.getHTZQ", new object[] { overdate.Value.ToString() }, this.ob);
                DataTable dtqry2 = dtqry1.Clone();
                foreach (DataColumn dc in dtqry2.Columns)
                {
                    if (dc.ColumnName.IndexOf("支") >= 0 || dc.ColumnName.IndexOf("重量") >= 0 || dc.ColumnName.IndexOf("吨") >= 0 || dc.ColumnName.IndexOf("天") >= 0)
                    {
                        dc.DataType = typeof(decimal);
                    }
                }
                foreach (DataRow dr in dtqry1.Rows)
                {
                    dtqry2.ImportRow(dr);
                }
                ultraGrid_htzq.DataSource = dtqry2;
                foreach (Infragistics.Win.UltraWinGrid.UltraGridBand band in ultraGrid_htzq.DisplayLayout.Bands)
                {
                    foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn column in band.Columns)
                    {
                        if (column.Key.IndexOf("支") >= 0 || column.Key.IndexOf("吨") >= 0 || column.Key.IndexOf("重量") >= 0 || column.Key.IndexOf("天") >= 0)
                        {
                            column.CellAppearance.TextHAlign=Infragistics.Win.HAlign.Right;
                        }
                        column.PerformAutoResize(Infragistics.Win.UltraWinGrid.PerformAutoSizeType.AllRowsInBand);
                    }
                }

                //setgridcolunmName(ultraGrid_htzq, "htzq"); 

                wf.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                wf.Close();
            }
        }
    }

}