XinYu_LZMES_Client/.svn/pristine/f7/f70b3f6e634e910f67e412c30a775fab6affe07d.svn-base

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.CA06;
using System.Collections;
using System.Diagnostics;
using Infragistics.Win.UltraWinGrid;

namespace Core.LZMes.Client.UIC
{
    public partial class CUIC030130 : FrmBase
    {
        string sTime_1 = null;

        public string STime_1
        {
            set { sTime_1 = value; }
        }
        string eTime_1 = null;

        public string ETime_1
        {
            set { eTime_1 = value; }
        }
        string pLine_1 = null;

        public string PLine_1
        {
            set { pLine_1 = value; }
        }
        string flag_1 = null;

        public string Flag_1
        {
            set { flag_1 = value; }
        }

        public CUIC030130()
        {
            InitializeComponent();
        }

        private void DoQuery()
        {
            CoreClientParam ccp = new CoreClientParam();
            ArrayList al = new ArrayList();
            if (this.flag_1 == "待判（未判定）(t)")
            {
                this.Text = "待判（未判定）钢卷";
                al.Add("UIC010001_12.SELECT");

                al.Add(sTime_1);
                al.Add(eTime_1);
                dataSet1.Tables[0].Clear();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { al };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                return;
            }
            else if (flag_1 == "1.原料类(t)" || flag_1 == "连退表面缺陷量(t)" || flag_1 == "2.酸轧类(t)" || flag_1 == "3.连退类(t)" || flag_1 == "3.1连退平整花(t)"
                            || flag_1 == "3.2连退擦划伤(t)" || flag_1 == "3.3连退辊印/压印(痕)(t)" || flag_1 == "4.钢质类(t)" || flag_1 == "3.4连退其它(t)")
            {
                if (flag_1 == "连退表面缺陷量(t)")
                {
                    this.Text = "连退表面缺陷连退卷";
                    al.Add("UIC010001_13.SELECT");
                }
                
                else if (flag_1 == "1.原料类(t)")
                {
                    this.Text = "1.原料类非计划";
                    al.Add("UIC010001_14.SELECT");
                }
                else if (flag_1 == "2.酸轧类(t)")
                {
                    this.Text = "2.酸轧类非计划";
                    al.Add("UIC010001_15.SELECT");
                }
                else if (flag_1 == "3.连退类(t)")
                {
                    this.Text = "3.连退类非计划";
                    al.Add("UIC010001_16.SELECT");
                }
                else if (flag_1 == "4.钢质类(t)")
                {
                    this.Text = "3.连退类非计划";
                    al.Add("UIC010001_17.SELECT");
                }


                else if (flag_1 == "3.1连退平整花(t)")
                {
                    this.Text = "3.1连退平整花缺陷连退卷";
                    al.Add("UIC010001_17.SELECT");
                }
                else if (flag_1 == "3.2连退擦划伤(t)")
                {
                    this.Text = "3.2连退擦划伤缺陷连退卷";
                    al.Add("UIC010001_18.SELECT");
                }
                else if (flag_1 == "3.3连退辊印/压印(痕)(t)")
                {
                    this.Text = "3.3连退辊印/压印(痕)缺陷连退卷";
                    al.Add("UIC010001_19.SELECT");
                }
                else if (flag_1 == "3.4连退其它(t)")
                {
                    this.Text = "3.4连退其它缺陷连退卷";
                    al.Add("UIC010001_20.SELECT");
                }

                al.Add(sTime_1.Substring(0, 6) + "01");
                al.Add(eTime_1);
                dataSet1.Tables[1].Clear();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { al };
                ccp.SourceDataTable = this.dataSet1.Tables[1];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                return;
            }

            else if (flag_1 == "连退非计划总量(t)" || flag_1 == "连退卷一次命中率(%)")
            {
                if (flag_1 == "连退非计划总量(t)")
                {
                    this.Text = "非计划连退卷";
                    al.Add("UIC010001_21.SELECT");
                }
                else if (flag_1 == "连退卷一次命中率(%)")
                {
                    this.Text = "一次命中率连退卷";
                    al.Add("UIC010001_22.SELECT");
                }

                al.Add(sTime_1);
                al.Add(eTime_1);
                dataSet1.Tables[2].Clear();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                ccp.ServerParams = new object[] { al };
                ccp.SourceDataTable = this.dataSet1.Tables[2];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                return;
            }
        }
        private void DoExport()
        {
            UltraGrid ultra = null;
            if (ultraGrid1.Visible == true)
                ultra = ultraGrid1;
            //else if (ultraGrid2.Visible == true)
            //    ultra = ultraGrid2;
            //else
            //    ultra = ultraGrid3;

            if (ultra == null || ultra.Rows.Count == 0)
            {
                MessageBox.Show("没有可以导出的数据", "提示");
                return;
            }

            saveFileDialog1.FileName = this.Text;
            saveFileDialog1.Filter = "表格(*.xls)|*.xls";
            if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
            {
                string fName = this.saveFileDialog1.FileName;
                this.ultraGridExcelExporter1.Export(ultra, fName);
                Process.Start(fName);
            }
        }

        private void CUIC030130_Load(object sender, EventArgs e)
        {
            this.ultraDateTimeEditor1.Value = DateTime.ParseExact(sTime_1,"yyyyMMdd",null);
            this.ultraDateTimeEditor2.Value = DateTime.ParseExact(eTime_1, "yyyyMMdd", null);

            if (this.flag_1 == "待判（未判定）(t)")
            {
                ultraGrid1.Dock = DockStyle.Fill;
                ultraGrid2.Visible = false;
                ultraGrid3.Visible = false;
            }

            else if (flag_1 == "1.原料类(t)" || flag_1 == "连退表面缺陷量(t)" || flag_1 == "2.酸轧类(t)" || flag_1 == "3.连退类(t)" || flag_1 == "4.钢质类(t)" || flag_1 == "3.1连退平整花(t)" 
                                  || flag_1 == "3.2连退擦划伤(t)" || flag_1 == "3.3连退辊印/压印(痕)(t)" || flag_1 == "3.4连退其它(t)")
            {
                ultraGrid1.Visible = false;
                ultraGrid3.Visible = false;
                ultraGrid2.Dock = DockStyle.Fill;
            }
              
            else if (flag_1 == "连退非计划总量(t)" || flag_1 == "连退卷一次命中率(%)")
            {
                ultraGrid1.Visible = false;
                ultraGrid2.Visible = false;
                ultraGrid3.Dock = DockStyle.Fill;
                if (flag_1 == "连退非计划总量(t)")
                {
                    ultraGrid3.Rows.Band.Columns["FYCMZ_YY"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["JT_YCBMZYY"].Hidden = true;
                }
                else if (flag_1 == "连退卷一次命中率(%)")
                {
                    ultraGrid3.Rows.Band.Columns["FYCMZ_YY"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["JT_YCBMZYY"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["YN_FJH"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["FJHYY"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["JT_FJHYY"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["JHN_WEIGHT"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["LGYYFJH_WEIGHT"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["RZYYFJH_WEIGHT"].Hidden = true;
                    ultraGrid3.Rows.Band.Columns["SZYYFJH_WEIGHT"].Hidden = true;
                }
            }

            this.DoQuery();
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "btnExport":
                    DoExport();
                    break;
                default:
                    break;
            }
        }
    }
}