XinYu_LZMES_Client/Core.LZMes.Client.UIB/B03/UIB030220.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 System.Collections;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;

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

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

        string strLine = null;
        public void DoQuery()
        {
            ArrayList al = new ArrayList();
            //if(this.ultraTabControl1.Name)
            //MessageBox.Show(this.ultraTabControl1.Tabs.c);
            DataTable dt = null;
            if (this.ultraTabControl1.Tabs[0].Selected)//判定结果查询
            {
                if (this.comboBox1.Text == "热轧")
                {

                    al.Add("UIB030220_HOST_01.SELECT");
                    return;   //未用到直接返回20151128

                }
                else if (this.comboBox1.Text == "酸轧")
                {
                    al.Add("UIB030220_SUAN_01.SELECT");
                }
                else if(this.comboBox1.Text == "连退")
                {
                    al.Add("UIB030220_LIAN_01.SELECT");
                }
                this.dataSet1.Tables["coil"].Clear();
                dt = this.dataSet1.Tables["coil"];
            }
            else if (this.ultraTabControl1.Tabs[1].Selected)//判定历史记录查询
            {
                if (this.comboBox1.Text == "酸轧")
                {
                    al.Add("UIB030220_SUAN_HISDCS.SELECT");//判定历史记录
                }
                else if (this.comboBox1.Text == "连退")
                {
                    al.Add("UIB030220_LIAN_HISDCS.SELECT");
                }
                this.dataSet1.Tables["HIS"].Clear();
                dt = this.dataSet1.Tables["HIS"];
            }
            else//带判钢卷查询
            {
                if (this.comboBox1.Text == "酸轧")
                {
                    al.Add("UIB030220_SUAN_02.SELECT");//待判卷
                }
                else if (this.comboBox1.Text == "连退")
                {
                    al.Add("UIB030220_LIAN_02.SELECT");//待判卷
                }
                this.dataSet1.Tables["DaiPan"].Clear();
                dt = this.dataSet1.Tables["DaiPan"];
            }

            if (this.ultraTabControl1.Tabs[0].Selected || this.ultraTabControl1.Tabs[1].Selected)
            {
                OperateConditionRecode.WriteCondition("UIB030220_STLGRD", this.specStlGrd.Text);
                OperateConditionRecode.WriteCondition("UIB030220_COILS", this.coilStat.Text);
                OperateConditionRecode.WriteCondition("UIB030220_COILE", this.coilEnd.Text);
                OperateConditionRecode.WriteCondition("UIB030220_ORD", this.ordText.Text);


                al.Add(this.ultraDateTimeEditor1.DateTime.ToString("yyyyMMddHHmmss"));
                al.Add(this.ultraDateTimeEditor2.DateTime.ToString("yyyyMMdd" + "999999"));
                al.Add(this.coilStat.Text.Trim());
                al.Add(this.coilEnd.Text.Trim() == "" ? this.coilStat.Text.Trim() : this.coilEnd.Text.Trim());
                al.Add(this.ordText.Text.Trim() == "" ? "1" : this.ordText.Text.Trim());
                al.Add(this.ordText.Text.Trim() == "" ? "1" : this.ordText.Text.Trim());
                al.Add(this.specStlGrd.Text.Trim());
            }
            //this.dataSet1.Tables["coil"].Clear();
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "UIB.COM.ComDBQuery";
            ccp.MethodName = "doSimpleQuery";
            ccp.ServerParams = new object[] { al };
            ccp.SourceDataTable =dt ;//this.dataSet1.Tables["coil"];
            this.ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);

            strLine = this.comboBox1.Text;
            if (this.ultraTabControl1.Tabs[0].Selected)
            {
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (ugr.Cells["TOT_DEC_GRD"].Text == "2")
                    {
                        ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                    }
                }
            }
        }

        public void DoExport()
        {
            try
            {
                if (this.saveFileDialog1.ShowDialog(this) == DialogResult.OK)
                {
                    string fName = this.saveFileDialog1.FileName;
                    if (this.ultraTabControl1.Tabs[0].Selected)
                    {
                        this.ultraGridExcelExporter1.Export(this.ultraGrid1, fName);
                    }
                    else if (this.ultraTabControl1.Tabs[1].Selected)
                    {
                        this.ultraGridExcelExporter1.Export(this.ultraGrid5, fName);
                    }
                    else
                    {
                        this.ultraGridExcelExporter1.Export(this.ultraGrid6, fName);
                    }
                    System.Diagnostics.Process.Start(fName);
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }

        public void DoSave()//取消综合判定
        {
            try
            {
                if (!this.ultraTabControl1.Tabs[0].Selected)
                {
                    return;
                }
                if (MessageBox.Show("确认取消判定？", "提示", MessageBoxButtons.OKCancel) == DialogResult.Cancel)
                    return;

                ArrayList al = new ArrayList();
                CoreClientParam ccp = new CoreClientParam();
                foreach (UltraGridRow ugr in this.ultraGrid1.Rows)
                {
                    if (Convert.ToBoolean(ugr.Cells["CHK"].Text))
                    {
                        Hashtable ht = new Hashtable();
                        ht.Add("i1", ugr.Cells["COIL_NO"].Text);
                        ht.Add("i2", this.UserInfo.GetUserID());
                        ht.Add("o3", "");
                        ccp.ServerName = "UIB.COM.ComDBProcedure";
                        ccp.MethodName = "doXmlProcedure";
                        if (strLine == "酸轧")
                        {
                            ccp.ServerParams = new object[] { "UIB030220_SUAN_01.CALL", ht };
                        }
                        else if (strLine == "连退")
                        {
                            ccp.ServerParams = new object[] { "UIB030220_LIAN_01.CALL", ht };
                        }
                        else
                        {
                            MessageBox.Show("错误操作！" , "警告");
                            return;
                        }
                        this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    }
                }

                this.DoQuery();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }

        }

        private void UIB030220_Load(object sender, EventArgs e)
        {
            this.comboBox1.SelectedIndex = 1;
            this.specStlGrd.Text=OperateConditionRecode.ReadCondition("UIB030220_STLGRD");
            this.coilStat.Text = OperateConditionRecode.ReadCondition("UIB030220_COILS");
            this.coilEnd.Text = OperateConditionRecode.ReadCondition("UIB030220_COILE");
            this.ordText.Text = OperateConditionRecode.ReadCondition("UIB030220_ORD");
        }

        private void button1_Click(object sender, EventArgs e)
        {
            UIB010301 frm = new UIB010301();
            frm.ob = this.ob;
            frm.OrderNO  = "312009032101";
            frm.OrderSEQ = "002";
            frm.ShowDialog();
        }

        private void ultraGrid1_AfterCellActivate(object sender, EventArgs e)
        {
            try
            {
                if (this.ultraGrid1.ActiveCell.Column.Key == "ORD_NO")//链接到品质设计结果查询
                {
                    UIB010301 frm = new UIB010301();
                    frm.ob = this.ob;
                    frm.OrderNO = this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text;
                    frm.OrderSEQ = this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text;
                    frm.ShowDialog();
                }
                else if (this.ultraGrid1.ActiveCell.Column.Key == "COIL_NO")//查询钢卷详细信息
                {
                    ArrayList list = new ArrayList();

                    //成分
                    ArrayList al = new ArrayList();
                    list.Add(al);
                    al.Add("UIB030220_CHEM.SELECT");
                    al.Add(this.ultraGrid1.ActiveRow.Cells["SLAB_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["SLAB_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);

                    //材质
                    al = new ArrayList();
                    list.Add(al);
                    al.Add("UIB030220_QLTY.SELECT");
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["SMP_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["SMP_CUT_LOC"].Text);

                    //其它
                    al = new ArrayList();
                    list.Add(al);
                    al.Add("UIB030220_OTHERS.SELECT");
                    al.Add(this.ultraGrid1.ActiveRow.Cells["COIL_THK"].Text);//厚度
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);

                    al.Add(this.ultraGrid1.ActiveRow.Cells["COIL_WTH"].Text);//宽度
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);

                    al.Add(this.ultraGrid1.ActiveRow.Cells["COIL_INDIA"].Text);//内径
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);

                    al.Add(this.ultraGrid1.ActiveRow.Cells["ACT_WGT"].Text);//重量
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);

                    al.Add(this.ultraGrid1.ActiveRow.Cells["EXTSHAPE_QUALITY"].Text);//外观
                    al.Add(this.ultraGrid1.ActiveRow.Cells["CR_DK1"].Text);//缺陷
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);

                    al.Add(this.ultraGrid1.ActiveRow.Cells["PACKAGE_LEVEL"].Text);//包装
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);

                    al.Add(this.ultraGrid1.ActiveRow.Cells["PROC_DEC_RST"].Text);//切边
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_NO"].Text);
                    al.Add(this.ultraGrid1.ActiveRow.Cells["ORD_SEQ"].Text);
                    //this.dataSet1.Tables[1].Clear();
                    CoreClientParam ccp = new CoreClientParam();
                    ccp.ServerName = "UIB.COM.ComDBQuery";
                    ccp.MethodName = "doContinuousQluery";
                    ccp.ServerParams = new object[] { list };
                    CoreClientParam ccpList = this.ExecuteQuery(ccp, CoreInvokeType.Internal);
                    if (ccpList.ReturnInfo.Length == 0)
                    {
                        ArrayList aList = ccpList.ReturnObject as ArrayList;
                        if (aList[0] != null)
                        {
                            this.dataSet1.Tables["ingr"].Clear();
                            System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[0] as System.Collections.ArrayList, this.dataSet1.Tables["ingr"]);
                            tab0.TableName = "ingr";
                            this.dataSet1.Tables["ingr"].Merge(tab0);
                        }

                        if (aList[1] != null)
                        {
                            this.dataSet1.Tables["qlty"].Clear();
                            System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[1] as System.Collections.ArrayList, this.dataSet1.Tables["qlty"]);
                            tab0.TableName = "qlty";
                            this.dataSet1.Tables["qlty"].Merge(tab0);
                        }

                        if (aList[2] != null)
                        {
                            this.dataSet1.Tables["other"].Clear();
                            System.Data.DataTable tab0 = Common.FixDBManager.ConvertToDataTable(aList[2] as System.Collections.ArrayList, this.dataSet1.Tables["other"]);
                            tab0.TableName = "other";
                            this.dataSet1.Tables["other"].Merge(tab0);
                        }
                    }
                }//end else if
                //成分判断
                foreach (UltraGridRow ugr in this.ultraGrid2.Rows)
                {
                    double min = Convert.ToDouble(ugr.Cells["CHEM_MIN"].Text == "" ? "0" : ugr.Cells["CHEM_MIN"].Text);
                    double max = Convert.ToDouble(ugr.Cells["CHEM_MAX"].Text == "" ? "9999" : ugr.Cells["CHEM_MAX"].Text);
                    double value = Convert.ToDouble(ugr.Cells["CHEM_VAL"].Text == "" ? "-1" : ugr.Cells["CHEM_VAL"].Text);
                    if (value < min || value > max)
                    {
                        ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                    }
                    if (value == -1)//缺少实际值
                    {
                        ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                    }
                }
                //材质判断
                foreach (UltraGridRow ugr in this.ultraGrid3.Rows)
                {
                    double min = Convert.ToDouble(ugr.Cells["QLTY_MIN"].Text == "" ? "0" : ugr.Cells["QLTY_MIN"].Text);
                    double max = Convert.ToDouble(ugr.Cells["QLTY_MAX"].Text == "" ? "9999" : ugr.Cells["QLTY_MAX"].Text);
                    double value = Convert.ToDouble(ugr.Cells["QLTY_VAL_WK"].Text == "" ? "-1" : ugr.Cells["QLTY_VAL_WK"].Text);

                    if (value < min || value > max)
                    {
                        ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                    }
                    if (value == -1)//缺少实际值
                    {
                        ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                    }
                }
                //其它判断
                foreach (UltraGridRow ugr in this.ultraGrid4.Rows)
                {
                    string name = ugr.Cells["T_NAME"].Text.Trim();
                    if ("外观" == name)
                    {
                        //不相等显示红色
                        string waiguan = ugr.Cells["T_MIN"].Text;
                        if (waiguan != null && waiguan != "" && !waiguan.Equals("0") && String.Compare(waiguan, ugr.Cells["T_VALUE"].Text) > 0)
                        {
                            ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                        }
                        continue;
                    }
                    else if ("内径" == name)
                    {
                        //不相等显示红色
                        string india = ugr.Cells["T_MIN"].Text;
                        if (india != null && india != "" && !india.Equals("0") && !india.Equals(ugr.Cells["T_VALUE"].Text))
                        {
                            ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                        }
                        continue;
                    }
                    else if ("包装" == name)
                    {
                        if ("不包装".Equals(ugr.Cells["T_MIN"].Text) && "XX".Equals(ugr.Cells["T_VALUE"].Text))
                        { }
                        else
                        {
                            //不相等显示红色
                            if (!ugr.Cells["T_MIN"].Text.Equals(ugr.Cells["T_VALUE"].Text))
                            {
                                ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                            }
                        }
                        continue;
                    }
                    else if ("切边" == name)
                    {
                        if ("Y".Equals(ugr.Cells["T_MIN"].Text) && "2".Equals(ugr.Cells["T_VALUE"].Text))
                        {
                                ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                            
                        }
                        continue;
                    }


                    double min = Convert.ToDouble(ugr.Cells["T_MIN"].Text == "" ? "0" : ugr.Cells["T_MIN"].Text);
                    double max = Convert.ToDouble(ugr.Cells["T_MAX"].Text == "" ? "99999" : ugr.Cells["T_MAX"].Text);
                    double value = Convert.ToDouble(ugr.Cells["T_VALUE"].Text == "" ? "-1" : ugr.Cells["T_VALUE"].Text);
                    
                    
                    if (value < min || value > max)
                    {
                        ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                    }
                    if (value == -1)//缺少实际值
                    {
                        ugr.Appearance.ForeColor = Color.Red;//字体显示红色
                    }
                }
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
            }
        }
    }
}