XinYu_LZMES_Client/.svn/pristine/24/24592cb72399ef02a8f3025978fa83fda6ffc788.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 Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using System.Collections;

using CoreFS.CA06;
using System.Diagnostics;

namespace Core.LZMes.Client.QCM
{
    public partial class QCM030508 : FrmBase
    {
        public QCM030508()
        {
            InitializeComponent();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    this.DoQuery();
                    break;
                case "Export":
                    this.DoExport();
                    break;
                case "Save":
                    this.DoSave();
                    break;
            }
        }
        private void DoQuery()
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //待判信息
            {
                DoQueryMe();
            }
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                DoQueryRe();
            }
            if (this.ultraTabControl1.Tabs[2].Selected) //判定记录
            {
                DoQueryRe1();
            }
        }
        private void DoQueryMe()
        {
            try
            {
                this.dataSet3.Clear();
                string sbatchno = "";
                string ebatchno = "";
                if (checkBox3.Checked)
                {
                    sbatchno = this.textBox2.Text.Trim();
                    if (textBox1.Text.ToString() == "")
                    {
                        ebatchno = this.textBox2.Text.Trim();
                    }
                    else
                    {
                        ebatchno = this.textBox1.Text.Trim();
                    }
                }
                string ord_no = "";
                if (checkBox1.Checked)
                {
                    ord_no = textBox4.Text.Trim(); 
                }

                string ord_no2 = "";
                if(this.checkBox4.Checked){
                    ord_no2 = this.textBox3.Text.Trim();
                }
                /*if (!checkBox1.Checked && !checkBox3.Checked )
                {
                    MessageBox.Show("轧批号、计划订单号必须选择其中一个条件！");
                    return;
                }*/
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl";
                ccp.MethodName = "GetKcZReport1";
                ccp.ServerParams = new object[] { sbatchno, ebatchno, ord_no, ord_no2 };
                ccp.SourceDataTable = this.dataSet3.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        private void DoQueryRe()
        {
            try
            {
                this.dataSet2.Clear();
                string sbatchno = "";
                string ebatchno = "";
                if (checkBox3.Checked)
                {
                    sbatchno = this.textBox2.Text.Trim();
                    if (textBox1.Text.ToString() == "")
                    {
                        ebatchno = this.textBox2.Text.Trim();
                    }
                    else
                    {
                        ebatchno = this.textBox1.Text.Trim();
                    }
                }
                string ord_no = "";
                if (checkBox1.Checked)
                {
                    ord_no = textBox4.Text.Trim(); //轧辊单元
                }

                string ord_no2 = "";
                if (this.checkBox4.Checked)
                {
                    ord_no2 = this.textBox3.Text.Trim();
                }
                /*if (!checkBox1.Checked && !checkBox3.Checked)
                {
                    MessageBox.Show("轧批号、计划订单号必须选择其中一个条件！");
                    return;
                }*/
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl";
                ccp.MethodName = "GetKcHReport1";
                ccp.ServerParams = new object[] { sbatchno, ebatchno, ord_no, ord_no2 };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
            
        }

        private void DoQueryRe1()
        {
            try
            {
                this.dataSet7.Clear();
                string sbatchno = "";
                string ebatchno = "";
                if (checkBox3.Checked)
                {
                    sbatchno = this.textBox2.Text.Trim();
                    if (textBox1.Text.ToString() == "")
                    {
                        ebatchno = this.textBox2.Text.Trim();
                    }
                    else
                    {
                        ebatchno = this.textBox1.Text.Trim();
                    }
                }
                string ord_no = "";
                if (checkBox1.Checked)
                {
                    ord_no = textBox4.Text.Trim(); //轧辊单元
                }

                string ord_no2 = "";
                if (this.checkBox4.Checked)
                {
                    ord_no2 = this.textBox3.Text.Trim();
                }
                /*if (!checkBox1.Checked && !checkBox3.Checked)
                {
                    MessageBox.Show("轧批号、计划订单号必须选择其中一个条件！");
                    return;
                }*/
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl";
                ccp.MethodName = "GetBJReport1";
                ccp.ServerParams = new object[] { sbatchno, ebatchno, ord_no, ord_no2 };
                ccp.SourceDataTable = this.dataSet7.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }


        private void DoSave()
        {
            if (this.ultraTabControl1.Tabs[0].Selected)
            {
                foreach (UltraGridRow ugr in ultraGrid3.Rows)
                {
                    if (ugr.Cells["CHECK"].Text.ToString() == "True")
                    {
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl";
                        ccp.MethodName = "in_Judgereason";
                        ccp.ServerParams = new object[] { ugr.Cells["子板号"].Value.ToString(), ugr.Cells["JUDGE_REASON"].Text.ToString(),
                            ugr.Cells["JUDGE_REG"].Text.ToString(),ugr.Cells["PTIME"].Text.ToString(),ugr.Cells["COIL_STAT"].Text.ToString() };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        ugr.Cells["CHECK"].Value = "False";
                    }
                }
                MessageBox.Show("录入成功");
            }
            else if (this.ultraTabControl1.Tabs[1].Selected)
            {
                foreach (UltraGridRow ugr in ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHECK"].Text.ToString() == "True")
                    {
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl";
                        ccp.MethodName = "in_Judgereason";
                        ccp.ServerParams = new object[] { ugr.Cells["子板号"].Value.ToString(), ugr.Cells["JUDGE_REASON"].Text.ToString(),
                            ugr.Cells["JUDGE_REG"].Text.ToString(),ugr.Cells["PTIME"].Text.ToString(),ugr.Cells["COIL_STAT"].Text.ToString() };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        ugr.Cells["CHECK"].Value = "False";
                    }
                }
                MessageBox.Show("录入成功");
            }
            else if (this.ultraTabControl1.Tabs[2].Selected)
            {
                foreach (UltraGridRow ugr in ultraGrid2.Rows)
                {
                    if (ugr.Cells["CHECK"].Text.ToString() == "True")
                    {
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0302.QcmJudgePhysicalServiceImpl";
                        ccp.MethodName = "in_Judgereason";
                        ccp.ServerParams = new object[] { ugr.Cells["子板号"].Value.ToString(), ugr.Cells["JUDGE_REASON"].Text.ToString(),
                            ugr.Cells["JUDGE_REG"].Text.ToString(),ugr.Cells["PTIME"].Text.ToString(),ugr.Cells["COIL_STAT"].Text.ToString() };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        ugr.Cells["CHECK"].Value = "False";
                    }
                }
                MessageBox.Show("录入成功");
            }
        }
        private void DoExport()
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //待判信息
            {
                this.saveFileDialog1.FileName = "中板线待检信息";
                try
                {
                    if (this.ultraGrid3.Rows.Count == 0)
                    {
                        MessageBox.Show("没有可以导出的数据", "提示");
                        return;
                    }

                    if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                    {
                        string fName = this.saveFileDialog1.FileName;
                        this.ultraGridExcelExporter1.Export(this.ultraGrid3, fName);
                        Process.Start(fName);
                    }
                }
                catch (Exception ex)
                {
                    System.Diagnostics.Debug.WriteLine(ex.ToString());
                }
            }
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                this.saveFileDialog1.FileName = "厚板线待检信息";
                try
                {
                    if (this.ultraGrid1.Rows.Count == 0)
                    {
                        MessageBox.Show("没有可以导出的数据", "提示");
                        return;
                    }

                    if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                    {
                        string fName = this.saveFileDialog1.FileName;
                        this.ultraGridExcelExporter1.Export(this.ultraGrid1, fName);
                        Process.Start(fName);
                    }
                }
                catch (Exception ex)
                {
                    System.Diagnostics.Debug.WriteLine(ex.ToString());
                }
            }
            if (this.ultraTabControl1.Tabs[2].Selected) //判定记录
            {
                this.saveFileDialog1.FileName = "板加待检信息";
                try
                {
                    if (this.ultraGrid2.Rows.Count == 0)
                    {
                        MessageBox.Show("没有可以导出的数据", "提示");
                        return;
                    }

                    if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                    {
                        string fName = this.saveFileDialog1.FileName;
                        this.ultraGridExcelExporter1.Export(this.ultraGrid2, fName);
                        Process.Start(fName);
                    }
                }
                catch (Exception ex)
                {
                    System.Diagnostics.Debug.WriteLine(ex.ToString());
                }
            }
        }

        private void QCM030508_Load(object sender, EventArgs e)
        {
            this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
            this.ultraGrid3.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
            
        }

        

        private void checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            if (this.ultraTabControl1.Tabs[0].Selected)
            {
                foreach (UltraGridRow ugr in this.ultraGrid3.Rows.Where(p => p.IsFilteredOut == false).ToList())
                {
                    if (checkBox2.Checked)
                    {
                        ugr.Cells["CHECK"].Value = "True";
                    }
                    else
                    {
                        ugr.Cells["CHECK"].Value = "False";
                    }
                }
            }
            else if (this.ultraTabControl1.Tabs[1].Selected)
            {
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows.Where(p => p.IsFilteredOut == false).ToList())
                {
                    if (checkBox2.Checked)
                    {
                        ugr.Cells["CHECK"].Value = "True";
                    }
                    else
                    {
                        ugr.Cells["CHECK"].Value = "False";
                    }
                }
            }
            else 
            {
                foreach (UltraGridRow ugr in this.ultraGrid2.Rows.Where(p => p.IsFilteredOut == false).ToList())
                {
                    if (checkBox2.Checked)
                    {
                        ugr.Cells["CHECK"].Value = "True";
                    }
                    else
                    {
                        ugr.Cells["CHECK"].Value = "False";
                    }
                }
            }
           
        }

        private void ultraGrid3_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid3.ActiveRow;
                if (ugr.Cells["CHECK"].Text.ToString() == "True")
                {
                    ugr.Cells["CHECK"].Value = "False";
                }
                else
                {
                    ugr.Cells["CHECK"].Value = "True";
                }               
                              
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                if (ugr.Cells["CHECK"].Text.ToString() == "True")
                {
                    ugr.Cells["CHECK"].Value = "False";
                }
                else
                {
                    ugr.Cells["CHECK"].Value = "True";
                }     

            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {

        }

        private void ultraGrid1_AfterRowActivate22(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                if (ugr.Cells["CHECK"].Text.ToString() == "True")
                {
                    ugr.Cells["CHECK"].Value = "False";
                }
                else
                {
                    ugr.Cells["CHECK"].Value = "True";
                }

            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            this.ultraGrid1.ActiveRow = null;
        }

    }
}