XinYu_LZMES_Client/.svn/pristine/dc/dc55871ff27cd4999e4a9845d15bf81560c50023.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 Infragistics.Win.UltraWinGrid;

namespace Core.LZMes.Client.UIB
{
    public partial class UIB030194 : FrmBase
    {
        public UIB030194()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
            }
        }

        public void DoQuery()
        {
            try
            {

                ArrayList al = new ArrayList();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "UIB.COM.ComDBQuery";
                ccp.MethodName = "doSimpleQuery";
                if (this.ultraTabControl1.SelectedTab.Text == "计划删除操作记录")
                {
                    if (this.comboBox1.SelectedIndex == 0)
                    {
                        al.Add("UIB030194_02.SELECT");
                    }
                    else
                    {
                        al.Add("UIB030194_03.SELECT");
                    }
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") + "000000");//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") + "999999");//日期
                    al.Add(this.textBox2.Text.ToString().Trim());

                    this.dataSet1.Tables["Table2"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table2"];
                }

                else if (this.ultraTabControl1.SelectedTab.Text == "实绩修改历史记录")
                {
                    al.Add("UIB030194_04.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") + "000000");//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") + "999999");//日期
                    al.Add(this.textBox1.Text.ToString().Trim());
                    al.Add(this.comboBox1.SelectedIndex);
                    al.Add(this.comboBox1.Text);



                    this.dataSet1.Tables["Table3"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table3"];
                }

                else if (this.ultraTabControl1.SelectedTab.Text == "返修过渡操作记录")
                {
                    al.Add("UIB030194_01.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") + "000000");//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") + "999999");//日期
                    al.Add(this.textBox1.Text.ToString().Trim());
                    al.Add(this.comboBox1.SelectedIndex);//产线

                    this.dataSet1.Tables["Table1"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table1"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "标签打印历史记录")
                {
                    al.Add("UIB030194_05.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd") + "000000");//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd") + "999999");//日期
                    al.Add(this.textBox1.Text.ToString().Trim());
                    al.Add(this.comboBox1.SelectedIndex);//产线

                    this.dataSet1.Tables["Table4"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table4"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text =="包装操作记录")
                {
                    if (this.comboBox1.SelectedIndex == 0)
                    {
                        al.Add("UIB030194_08.SELECT"); 
                    }
                    else if (this.comboBox1.SelectedIndex == 1)
                    {
                        al.Add("UIB030194_06.SELECT"); 
                    }
                    else {
                        al.Add("UIB030194_07.SELECT");
                    }
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.textBox1.Text.ToString().Trim());
                    this.dataSet1.Tables["Table5"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table5"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "磅房重量发送记录")
                {
                    al.Add("UIB030194_09.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.textBox1.Text.Trim());
                    this.dataSet1.Tables["Table6"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table6"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "待处理钢卷管理处理记录")
                {
                    al.Add("UIB030194_10.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.textBox1.Text.Trim());
                    this.dataSet1.Tables["Table7"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table7"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "热轧下发计划")
                {
                    al.Add("UIB030194_12.SELECT");
                    al.Add(this.textBox1.Text.Trim());
                    this.dataSet1.Tables["Table9"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table9"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "进程状态修改记录")
                {
                    al.Add("UIB030194_11.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.textBox1.Text.Trim());
                    al.Add(this.comboBox1.SelectedIndex);
                    this.dataSet1.Tables["Table8"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table8"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "充当改判")
                {
                    al.Add("UIB030194_13.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.textBox1.Text.Trim());
                    al.Add(this.comboBox1.SelectedIndex);
                    this.dataSet1.Tables["Table10"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table10"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "卷板明细退回")
                {
                    al.Add("UIB030194_14.SELECT");
                    al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd"));//日期
                    al.Add(this.textBox1.Text.Trim());
                    this.dataSet2.Tables["Table1"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet2.Tables["Table1"];
                }
                else if (this.ultraTabControl1.SelectedTab.Text == "板坯产出对应")
                {
                    al.Add("UIB030194_15.SELECT");
        
                    al.Add(this.textBox1.Text.Trim());
                    this.dataSet1.Tables["Table12"].Clear();
                    ccp.ServerParams = new object[] { al };
                    ccp.SourceDataTable = this.dataSet1.Tables["Table12"];
                }



                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

        private void ultraGrid1_InitializeLayout(object sender, InitializeLayoutEventArgs e)
        {

        }
        private void DoExport()
        {
            try
            {
                //this.ultraTabControl1.SelectedTab.Text;
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fileName = this.saveFileDialog1.FileName;
                    ultraGridExcelExporter1.Export(ultraGrid20, fileName);
                    System.Diagnostics.Process.Start(fileName);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

        }
        private void UIB030194_Load(object sender, EventArgs e)
        {
            try
            {
                this.comboBox1.SelectedIndex = 0;
            }
            catch (Exception ex)
            {
            }
        }

        private void ultraButton1_Click(object sender, EventArgs e)
        {
            this.DoExport();
        }

    

      
     

     
    }
}