XinYu_LZMES_Client/Core.LZMes.Client.QCM/QCM03/QCM030807.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 QCM030807 : FrmBase
    {
        public QCM030807()
        {
            InitializeComponent();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case"Query":
                    this.DoQuery();
                    break;
                case "Affirm":
                    this.affirm();
                    break;
                case "Add":
                    this.Declare();
                    break;
                case "UnAdd":
                    this.UnDeclare();
                    break;
                case "Export":
                    this.DoExport();
                    break;
                case "Examine":
                    this.Examine();
                    break;
                case "Input":
                    this.Input();
                    break;
            }
        }
        private void affirm()
        {
            try
            {
                UltraGridRow ugr = this.ultraGrid2.ActiveRow;
                if (ugr == null)
                    return;
                string heat_no = ugr.Cells["HEAT_NO"].Value.ToString();
                string assay_no = ugr.Cells["ASSAY_NO"].Value.ToString();
                string pline_code = ugr.Cells["pline_code"].Value.ToString();
                ArrayList list1 = new ArrayList();
                list1.Add(heat_no);
                list1.Add(assay_no);
                list1.Add(pline_code);
                list1.Add(this.UserInfo.GetUserName());
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "UpdateChemeInfo";
                ccp.ServerParams = new object[] { list1 };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode == -1)
                {
                    return;
                }
                DoQuery();
                MessageBox.Show("修改成功！");
            }
            catch(Exception EX)
            {
                MessageBox.Show(EX.ToString());
            }  
        }

        private void Declare()
        {
            try
            {
                string prod_type = "";
                string tslx = "";
                string prod_line1 = "";
                QCM030608 frm = new QCM030608();
                frm.ob = this.ob;
                if (frm.ShowDialog() == DialogResult.OK)
                {
                    prod_type = frm.prod_type;
                    prod_line1 = frm.prod_line;
                    tslx = frm.tslx;
                }
                string optman;
                string slab_no;
                string opttype = "1";
                string prod_line = "";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text.ToString() == "True")
                    {
                        //string opttype = "1";
                        /*string prod_type = this.comboBox1.Text.ToString();
                        string tslx = this.comboBox2.Text.ToString();*/
                        //string prod_line = "";
                       if (comboBox3.Text.ToString() == "一炼钢")
                        {
                            prod_line = "4001LG0";
                         }
                        else if (comboBox3.Text.ToString() == "二炼钢")
                        {
                            prod_line = "4001LGX";
                         }
                        else
                        {
                            prod_line = "";
                         }
                        optman = this.UserInfo.GetUserName().ToString();
                        slab_no = ugr.Cells["BILLETNO"].Value.ToString();
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                        ccp.MethodName = "doApplyJudge";
                        ccp.ServerParams = new object[] { opttype, prod_type, tslx, prod_line, slab_no, optman };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        MessageBox.Show(ugr.Cells["BILLETNO"].Value.ToString() + "特殊放行申报成功");
                    }
                //UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                
               
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void UnDeclare()
        {
            try
            {
                string prod_type = "";
                string tslx = "";
                string prod_line1 = "";
                QCM030608 frm = new QCM030608();
                frm.ob = this.ob;
                if (frm.ShowDialog() == DialogResult.OK)
                {
                    prod_type = frm.prod_type;
                    prod_line1 = frm.prod_line;
                    tslx = frm.tslx;
                }
                if (prod_type == "" || prod_line1 == "" || tslx == "")
                {
                    return;
                }
                string optman;
                string slab_no;
                string opttype = "2";
                string prod_line = "";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text.ToString() == "True")
                    {
                        //UltraGridRow ugr = this.ultraGrid1.ActiveRow;
                        
                        /*string prod_type = this.comboBox1.Text.ToString();
                        string tslx = this.comboBox2.Text.ToString();*/

                        if (comboBox3.Text.ToString() == "一炼钢")
                        {
                            prod_line = "4001LG0";
                        }
                        else if (comboBox3.Text.ToString() == "二炼钢")
                        {
                            prod_line = "4001LGX";
                        }
                        else
                        {
                            prod_line = "";
                        }
                        optman = this.UserInfo.GetUserName().ToString();
                        slab_no = ugr.Cells["BILLETNO"].Value.ToString();
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                        ccp.MethodName = "doApplyJudge";
                        ccp.ServerParams = new object[] { opttype, prod_type, tslx, prod_line, slab_no, optman };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        MessageBox.Show(ugr.Cells["BILLETNO"].Value.ToString() + "特殊放行撤销申报成功");
                    }
                    
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void Examine()
        {
            try{
                string flag1 = "";
                QCM030609 frm = new QCM030609();
                frm.ob = this.ob;
                if (frm.ShowDialog() == DialogResult.OK)
                {
                    flag1 = frm.flag;
                    
                }
                if (flag1=="")
                {
                    return;
                }
                string optman;
                string slab_no;
                string flag ="";
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text.ToString() == "True")
                    {
                        if (flag1 == "通过")
                        {
                           flag = "Y";
                        }
                        else if (flag1 == "不通过")
                        {
                             flag = "N";
                        }
                        
                        optman = this.UserInfo.GetUserName().ToString();
                        slab_no = ugr.Cells["BILLETNO"].Value.ToString();
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                        ccp.MethodName = "ApplyJudgeCheck";//doApplyJudge
                        ccp.ServerParams = new object[] { slab_no, flag, optman };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        MessageBox.Show(ugr.Cells["BILLETNO"].Value.ToString() + "特殊放行审核成功");
                    }
                   
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void DoQuery()
        {
            DoQueryMe();
        }


        //查询待判信息
        private void DoQueryMe()
        {
            try
            {
                this.dataSet1.Clear();
                string heatno = this.textBox1.Text.Trim();
                string prod_line = "";
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "GetApplyJudgeInfo";
                ccp.SourceDataTable = this.dataSet1.Tables[0];
                if (comboBox3.Text.ToString() == "一炼钢")
                {
                    prod_line = "4001LG0";
                }
                else if (comboBox3.Text.ToString() == "二炼钢")
                {
                    prod_line = "4001LGX";
                }
                else
                {
                    prod_line = "";
                }
                ccp.ServerParams = new object[] { this.dateTimePicker1.Value.ToString("yyyy-MM-dd"), this.dateTimePicker2.Value.ToString("yyyy-MM-dd"), heatno, prod_line };
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }

        }

        private void QCM030803_Load(object sender, EventArgs e)
        {
            this.ultraGrid2.DisplayLayout.Override.FilterUIType = FilterUIType.HeaderIcons;
            this.dateTimePicker1.Value = System.DateTime.Now.AddDays(-3);
        }

        private void DoExport()
        {
            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 ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {

                UltraGridRow ugr = this.ultraGrid1.ActiveRow;

                this.textBox2.Text = ugr.Cells["JRYQ"].Value.ToString();
                this.textBox3.Text = ugr.Cells["ZJYQ"].Value.ToString();
                this.textBox4.Text = ugr.Cells["QYYQ"].Value.ToString();
                this.textBox5.Text = ugr.Cells["RCLYQ"].Value.ToString();
                this.textBox6.Text = ugr.Cells["BILLETNO"].Value.ToString();
                this.textBox7.Text = ugr.Cells["LGJUDGEYQ"].Value.ToString();
                this.textBox8.Text = ugr.Cells["CFPDYQ"].Value.ToString();
                this.dataSet2.Clear();
                string design_key = ugr.Cells["ORDERNO"].Value.ToString();
                string smp_no = ugr.Cells["HEATNO"].Value.ToString();
                string grade_name = ugr.Cells["LGPH"].Text.ToString();
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                ccp.MethodName = "GetLgRChemeInfo";
                ccp.ServerParams = new object[] { design_key, smp_no, grade_name };
                ccp.SourceDataTable = this.dataSet2.Tables[0];
                this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                UltraGridRow judge_row = null;
                int count1 = 0;
                List<string> s = new List<string>();
                foreach (UltraGridRow ugst in this.ultraGrid3.Rows)
                {
                    if (!ugst.Cells["STD_TYPE"].Text.ToString().Contains("标准") && !ugst.Cells["STD_TYPE"].Text.ToString().Contains("要求"))
                    {
                        judge_row = ugst;
                    }
                    if (judge_row != null)
                    {
                        foreach (UltraGridRow ugs in this.ultraGrid3.Rows)
                        {
                            if (!string.IsNullOrEmpty(ugs.Cells["STD_TYPE"].Text) && ugs.Cells["STD_TYPE"].Text.ToString() == "放行标准(熔炼)")
                            {
                                for (int i = 0; i < ugs.Cells.Count; i++)
                                {
                                    if (!string.IsNullOrEmpty(ugs.Cells[i].Text) && ugs.Cells[i].Text.ToString().Contains("  "))
                                    {
                                        string[] str_arr = ugs.Cells[i].Text.ToString().Replace("  ", "#").Split('#');
                                        if (str_arr.Length == 1)
                                        {
                                            if (str_arr[0].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text))
                                            {
                                                if (double.Parse(str_arr[0].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString()))
                                                {
                                                    //judge_row.Cells[i].Appearance.BackColor = Color.Red;
                                                    //judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red;
                                                    if (!s.Contains(judge_row.Cells[i].ToString()))
                                                    {
                                                        s.Add(judge_row.Cells[i].ToString());
                                                        count1++;
                                                    }
                                                }
                                            }
                                            else if (str_arr[0].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text))
                                            {
                                                if (double.Parse(str_arr[0].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString()))
                                                {
                                                    //judge_row.Cells[i].Appearance.BackColor = Color.Red;
                                                    //judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red;
                                                    if (!s.Contains(judge_row.Cells[i].ToString()))
                                                    {
                                                        s.Add(judge_row.Cells[i].ToString());
                                                        count1++;
                                                    }
                                                }
                                            }
                                        }
                                        else if (str_arr.Length == 2)
                                        {
                                            if (str_arr[0].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text))
                                            {
                                                if (double.Parse(str_arr[0].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString()))
                                                {
                                                    //judge_row.Cells[i].Appearance.BackColor = Color.Red;
                                                    //judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red;
                                                    if (!s.Contains(judge_row.Cells[i].ToString()))
                                                    {
                                                        s.Add(judge_row.Cells[i].ToString());
                                                        count1++;
                                                    }
                                                }
                                            }
                                            else if (str_arr[0].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text))
                                            {
                                                if (double.Parse(str_arr[0].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString()))
                                                {
                                                    //judge_row.Cells[i].Appearance.BackColor = Color.Red;
                                                    //judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red;
                                                    if (!s.Contains(judge_row.Cells[i].ToString()))
                                                    {
                                                        s.Add(judge_row.Cells[i].ToString());
                                                        count1++;
                                                    }

                                                }
                                            }
                                            if (str_arr[1].Contains("<=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text))
                                            {
                                                if (double.Parse(str_arr[1].Replace("<=", "")) < double.Parse(judge_row.Cells[i].Text.ToString()))
                                                {
                                                    //judge_row.Cells[i].Appearance.BackColor = Color.Red;
                                                    //judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red;
                                                    if (!s.Contains(judge_row.Cells[i].ToString()))
                                                    {
                                                        s.Add(judge_row.Cells[i].ToString());
                                                        count1++;
                                                    }
                                                }
                                            }
                                            else if (str_arr[1].Contains(">=") && !string.IsNullOrEmpty(judge_row.Cells[i].Text))
                                            {
                                                if (double.Parse(str_arr[1].Replace(">=", "")) > double.Parse(judge_row.Cells[i].Text.ToString()))
                                                {
                                                    //judge_row.Cells[i].Appearance.BackColor = Color.Red;
                                                    //judge_row.Cells["STD_TYPE"].Appearance.BackColor = Color.Red;
                                                    if (!s.Contains(judge_row.Cells[i].ToString()))
                                                    {
                                                        s.Add(judge_row.Cells[i].ToString());
                                                        count1++;
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
                if (count1 > 0)
                {
                    //this.label12.BackColor = Color.Red;
                    //this.label12.Text = "" + smp_no + "有" + count1 + "条元素成分不合格！";
                    //MessageBox.Show("" + smp_no + "有" + count1 + "条元素成分不合格！");
                }
                else
                {
                    this.label12.Text = "";
                }
                
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            
        }

        private void Input()
        {
            try
            {
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["CHK"].Text.ToString() == "True")
                    {

                        string jryq = this.textBox2.Text.ToString();
                        string zjyq = this.textBox3.Text.ToString();
                        string qyyq = this.textBox4.Text.ToString();
                        string rclyq = this.textBox5.Text.ToString();
                        string slab_no = ugr.Cells["BILLETNO"].Value.ToString();
                        string lgjudgeyq = this.textBox7.Text.ToString();
                        string cfpdyq = this.textBox8.Text.ToString();
                        CoreClientParam ccp = new CoreClientParam();
                        ccp.ServerName = "QCM.QCM03.QCM0301.QcmJhyElementsServiceImpl";
                        ccp.MethodName = "ApplyJudgeInput";
                        ccp.ServerParams = new object[] { slab_no, jryq, zjyq, qyyq, rclyq, lgjudgeyq, cfpdyq };
                        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                        if (ccp.ReturnCode == -1)
                        {
                            return;
                        }
                        MessageBox.Show(ugr.Cells["BILLETNO"].Value.ToString() + "特殊要求工艺录入成功");
                    }
                   
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                MessageBox.Show("系统出错，请联系管理人员", "警告");
            }
        }

        private void splitContainer2_Panel2_Paint(object sender, PaintEventArgs e)
        {

        }

        private void panel2_Paint(object sender, PaintEventArgs e)
        {

        }

    }
}