XinYu_LG2MES/ClientSolution/Core.LgMes.Client.Report/frmSetStatisticsMode.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Core.Mes.Client.Common;
using CoreFS.CA06;
using Infragistics.Win.UltraWinDataSource;
using Infragistics.Win.UltraWinGrid;
using System.Collections;

namespace Core.LgMes.Client.Report
{
    public partial class  frmSetStatisticsMode : Core.Mes.Client.Common.frmStyleBase
    {

        public UltraGrid ultraMain;
        public bool blColse = false;
        public Hashtable htMode = new Hashtable();
        public bool blSelect =false;

        public frmSetStatisticsMode(ref UltraGrid ultragrid)
        {
            ultraMain = ultragrid;
            InitializeComponent();
        }

        private void frmSetStatisticsMode_Load(object sender, EventArgs e)
        {
            InitializeColumn();
        }

        private void InitializeColumn()
        {
            //定义存放汇总方式(0:标题,1:计数,2:合计,3:平均,4:最大,5:最小)
            string[] strOpt = new string[6];
            int intCount = 0;
            try
            {                
                

                for (int i = 0; i < ultraMain.DisplayLayout.Bands[0].Columns.Count; i++)
                {
                    if (!String.IsNullOrEmpty(ultraMain.DisplayLayout.Bands[0].Columns[i].Header.Caption)                        
                        && ultraMain.DisplayLayout.Bands[0].Columns[i].Hidden == false)
                    {                        
                        ultraDataSource1.Rows.Add(new object[] {false,
                                                            ultraMain.DisplayLayout.Bands[0].Columns[i].Header.Column.Key,
                                                            ultraMain.DisplayLayout.Bands[0].Columns[i].Header.Caption,
                                                            false,true,true,true,true,true,
                                                            ultraMain.DisplayLayout.Bands[0].Columns[i].RowLayoutColumnInfo.OriginY,
                                                            ultraMain.DisplayLayout.Bands[0].Columns[i].RowLayoutColumnInfo.OriginX
                                                            });
                        if (ultraMain.DisplayLayout.Bands[0].Columns[i].Tag != null)
                        {
                            strOpt[0] = ultraMain.DisplayLayout.Bands[0].Columns[i].Tag.ToString().Substring(0, 1);
                            strOpt[1] = ultraMain.DisplayLayout.Bands[0].Columns[i].Tag.ToString().Substring(1, 1);
                            strOpt[2] = ultraMain.DisplayLayout.Bands[0].Columns[i].Tag.ToString().Substring(2, 1);
                            strOpt[3] = ultraMain.DisplayLayout.Bands[0].Columns[i].Tag.ToString().Substring(3, 1);
                            strOpt[4] = ultraMain.DisplayLayout.Bands[0].Columns[i].Tag.ToString().Substring(4, 1);
                            strOpt[5] = ultraMain.DisplayLayout.Bands[0].Columns[i].Tag.ToString().Substring(5, 1);

                            ultraDataSource1.Rows[intCount][0] = true;
                            ultraDataSource1.Rows[intCount][3] = strOpt[0] == "1" ? "true" : "false";
                            ultraDataSource1.Rows[intCount][4] = strOpt[1] == "1" ? "true" : "false";
                            ultraDataSource1.Rows[intCount][5] = strOpt[2] == "1" ? "true" : "false";
                            ultraDataSource1.Rows[intCount][6] = strOpt[3] == "1" ? "true" : "false";
                            ultraDataSource1.Rows[intCount][7] = strOpt[4] == "1" ? "true" : "false";
                            ultraDataSource1.Rows[intCount][8] = strOpt[5] == "1" ? "true" : "false";
                        }
                        intCount++;
                    }                    
                }
                
            }
            catch
            {
            }
        }       

        private void ultlbarTools_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "SAVE":
                    SaveStatisticsMode();
                    if (blSelect == false)
                    {
                        MessageBox.Show("没有选择要汇总的项目名称，请选择！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                    else
                    {
                        this.Close();
                    }
                    break;              
                case "All":
                    InitializeSelect(true);
                    break;
                case "Cancel":
                    InitializeSelect(false);
                    break;
                case "EXIT":
                    this.Close();
                    break;
            }
        }
        
        /// <summary>
        /// 全选或全部取消
        /// </summary>
        /// <param name="blValue"></param>
        private void InitializeSelect(bool blValue)
        {
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow row in this.ultragridMode.Rows)
            {
                row.Cells["FLAG"].Value = blValue;
                if (blValue == false) row.Update();
            }
        }

        /// <summary>
        /// 保存设置汇总方式
        /// </summary>
        private void SaveStatisticsMode()
        {           
            
            for (int i = 0; i < ultragridMode.Rows.Count; i++)
            {
                if (ultragridMode.Rows[i].Cells["FLAG"].Text == "True")
                {
                    if(htMode.Contains(ultragridMode.Rows[i].Cells["COLUMNNAME"].Value.ToString()))
                        htMode.Remove(ultragridMode.Rows[i].Cells["COLUMNNAME"].Value.ToString());
                    htMode.Add( ultragridMode.Rows[i].Cells["COLUMNNAME"].Value.ToString(),
                                (ultragridMode.Rows[i].Cells["TITLE"].Text.ToString().ToUpper() == "TRUE" ? "1" : "0").ToString() +
                                (ultragridMode.Rows[i].Cells["COUNT"].Text.ToString().ToUpper() == "TRUE" ? "1" : "0").ToString() +
                                (ultragridMode.Rows[i].Cells["SUM"].Text.ToString().ToUpper() == "TRUE" ? "1" : "0").ToString() +
                                (ultragridMode.Rows[i].Cells["AVG"].Text.ToString().ToUpper() == "TRUE" ? "1" : "0").ToString() +
                                (ultragridMode.Rows[i].Cells["MAX"].Text.ToString().ToUpper() == "TRUE" ? "1" : "0").ToString() +
                                (ultragridMode.Rows[i].Cells["MIN"].Text.ToString().ToUpper() == "TRUE" ? "1" : "0").ToString()
                    );
                    blSelect=true;
                }
            }
        }

        private void frmSetStatisticsMode_FormClosing(object sender, FormClosingEventArgs e)
        {
            blColse = true;
        }   
    }
}