XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM03/QCM0301.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.CA06;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using System.Diagnostics;

namespace Core.LZMes.Client.QCM
{
    public partial class QCM0301 : FrmBase
    {
        public QCM0301()
        {
            InitializeComponent();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case"Query":
                    this.DoQuery();
                    break;
                case "Judge":
                    this.Judge();
                    break;
                case "Cancel":
                    this.Cancel();
                    break;
                case "Export":
                    this.DoExport();
                    break;


            }
        }
        private void Judge()
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                List<string> list1 = new List<string>();
                if (ugr == null)
                    return;
                string heat_no = ugr.Cells["HEAT_NO"].Value.ToString();
                string material_no = ugr.Cells["MATERIAL_NO"].Value.ToString();
                string design_key = ugr.Cells["DESIGN_KEY"].Value.ToString();
                string grade_name = ugr.Cells["GRADE_NAME"].Value.ToString();
                string username = this.UserInfo.GetUserName();
                string assay_no = "";
                foreach (UltraGridRow ugrs in this.ultraGrid2.Rows)
                {
                    if (ugrs.Cells["CHECKBOX"].Text.ToString() == "True")
                    {
                        assay_no = ugrs.Cells["STD_TYPE"].Value.ToString();
                        list1.Add(assay_no);
                    }
                }
                if (list1.Count == 0)
                {
                    MessageBox.Show("请选择检验实绩!");
                    return;
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "JudgeByHuman1";
                ccp.ServerParams = new object[] { heat_no, material_no, design_key, username, grade_name, list1 };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode == -1)
                {
                    return;
                }
                ugr.Delete(false);
                MessageBox.Show("判定成功！");
            }
            catch (Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }
            
        }
        private void Cancel()
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid4.ActiveRow;
                if (ugr == null)
                    return;
                string inspection_lot = ugr.Cells["inspection_lot"].Value.ToString();
                string smp_no = ugr.Cells["smp_no"].Value.ToString();
                string username = this.UserInfo.GetUserName();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJudgeChemicalServiceImpl";
                ccp.MethodName = "CancelJudge";
                ccp.ServerParams = new object[] { inspection_lot,smp_no,username };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode == -1)
                {
                    return;
                }
                MessageBox.Show("取消判定成功！");
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }
        private void DoQuery()
        {
            if (this.ultraTabControl1.Tabs[0].Selected) //待判信息
            {
                DoQueryMe();
                this.ultraGrid1.DisplayLayout.Bands[0].PerformAutoResizeCards(true);
            }
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                DoQueryRe();
            }

        }


        //查询待判信息
        private void DoQueryMe()
        {
            try
            {
                if (comboBox1.SelectedIndex == 2)
                {
                    MessageBox.Show("请选择委托生成或者发送时间！");
                    return;
                }
                this.dataSet2.Clear();
                string heatno = textBox1.Text.Trim();
                string BOARD_NO = textBox2.Text.Trim();
                string design_key = textBox3.Text.Trim();
                string psc = textBox4.Text.Trim();
                string prodline = this.comboBox3.Text.ToString();
                string status = this.comboBox1.SelectedIndex.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "getRejudgeInfo";
                ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"),heatno, BOARD_NO, design_key, psc,"0",prodline,status };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp,CoreInvokeType.Internal);

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

        }
    
        //查询判定记录
        private void DoQueryRe()
        {
            try
            {
                if (comboBox1.SelectedIndex != 2)
                {
                    MessageBox.Show("请选择判定时间！");
                    return;
                }
                this.dataSet1.Clear();
                string heatno = textBox1.Text.Trim();
                string BOARD_NO = textBox2.Text.Trim();
                string design_key = textBox3.Text.Trim();
                string psc = textBox4.Text.Trim();
                string prodline = comboBox3.Text.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJudgeChemicalServiceImpl";
                ccp.MethodName = "GetJudgeChemRecord";
                ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyyMMdd"), this.dateTimePicker2.Value.ToString("yyyyMMdd"), heatno, BOARD_NO, design_key, psc,"0",prodline };
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }

        private void ultraGrid4_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid4.ActiveRow;
                if (ugr == null)
                    return;
                this.dataSet4.Clear();
                string cic_id = ugr.Cells["CIC_ID"].Value.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "GetChemeResult";
                ccp.ServerParams = new object[] { cic_id };
                ccp.SourceDataTable = this.dataSet4.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "GetCheme";
                ccp.ServerParams = new object[] { cic_id };
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                for (int i = 0; i < ccp.SourceDataTable.Rows.Count; i++)
                {
                    foreach (UltraGridRow ugr5 in this.ultraGrid5.Rows)
                    {
                        if (ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Value.ToString().Contains(ccp.SourceDataTable.Rows[i]["stdmin"].ToString()) && ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_code_s"].ToString()].Value.ToString().Contains(ccp.SourceDataTable.Rows[i]["stdmax"].ToString()))
                        {
                            if (ugr5.Cells.Contains(ccp.SourceDataTable.Rows[i]["phy_name_s"].ToString()))
                            {
                                ugr5.Cells[ccp.SourceDataTable.Rows[i]["phy_name_s"].ToString()].Appearance.BackColor = Color.Red;
                            }
                        }
                    }
                }
            }
            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 == null)
                    return;
                this.dataSet3.Clear();
                string design_key = ugr.Cells["DESIGN_KEY"].Value.ToString();
                string smp_no =  ugr.Cells["SMP_NO"].Value.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "GetChemeInfo";
                ccp.ServerParams = new object[] { design_key, smp_no };
                ccp.SourceDataTable = this.dataSet3.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                this.ultraGrid2.DisplayLayout.Bands[0].PerformAutoResizeCards(true);
                foreach (UltraGridRow ugs in this.ultraGrid2.Rows)
                {
                    ugs.Cells["CHECKBOX"].Value = ugs.Cells["CHECKBOXS"].Text.ToString();
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }

        private void QCM0301_Load(object sender, EventArgs e)
        {
            this.comboBox3.SelectedIndex = 0;
            this.comboBox1.SelectedIndex = 1;
            this.ultraGrid1.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
            this.ultraGrid4.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
            this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-7);
            DoQuery();
        }

        private void ultraTabControl1_Click(object sender, EventArgs e)
        {
            if (this.ultraTabControl1.Tabs[1].Selected) //判定记录
            {
                this.comboBox1.SelectedIndex = 2;
            }
            if (this.ultraTabControl1.Tabs[0].Selected) //判定记录
            {
                this.comboBox1.SelectedIndex = 1;
            }
        }

        private void DoExport()
        {
            try
            {
                if (this.ultraGrid4.Rows.Count == 0)
                {
                    MessageBox.Show("没有可以导出的数据", "提示");
                    return;
                }

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

    }
}