MES_Client/TGMES/Core.StlMes.Client.Judge/Forms/QcmZbsInfoInput.cs

using Core.Mes.Client.Comm;
using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Judge.Controls;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.Judge.Forms
{
    public partial class QcmZbsInfoInput : FrmBase
    {
        public QcmZbsInfoInput()
        {
            InitializeComponent();
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "Add":
                    Add();
                    break;
                case "Update":
                    Update();
                    break;
                case "Delete":
                    Delete();
                    break;
                case "savePhyInfo":
                    savePhyInfo();
                    break;
                case "DeletePhyInfo":
                    DeletePhyInfo();
                    break;
                case "saveChemInfo":
                    saveChemInfo();
                    break;
                case "DeleteChemInfo":
                    DeleteChemInfo();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }


        private void Query()
        {
            string judgeNo = "";
            string orderStart = "";
            string orderEnd = "";
            if (ckJudgeNo.Checked)
                judgeNo = utJudgeNo.Text.Trim();
            if (uchkDate.Checked)
            {
                orderStart = udtStart.DateTime.ToString("yyyy-MM-dd") + " 00:00:01";
                orderEnd = udtEnd.DateTime.ToString("yyyy-MM-dd") + " 23:59:59";
            }
            else
            {
                orderStart = "1000-01-01 00:00:01";
                orderEnd = "9999-12-31 23:59:59";
            }
            DataTable dt = ServerHelper.GetData("com.steering.pss.judge.DAL.ZbsInfoInput.getZbsInfo", new Object[] { judgeNo, orderStart, orderEnd }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.zbsInfo, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid1);
        }

        private void Add()
        {
            ZbsChooseBillInfo choose = new ZbsChooseBillInfo(this.ob);
            choose.ShowDialog();
            if (choose.CloseEvent.Equals("Add"))
            {
                this.Query();
            }
        }
        private void Update()
        {
            try
            {
                ultraGrid1.UpdateData();
                if (ultraGrid1.ActiveRow == null)
                    return;
                UltraGridRow row = ultraGrid1.ActiveRow;
                if ("".Equals(row.Cells["JUDGE_STOVE_NO"].Value.ToString()))
                {
                    MessageUtil.ShowTips("判定炉号不能为空");
                    return;
                }
                if ("".Equals(row.Cells["BATCH_NO"].Value.ToString()))
                {
                    MessageUtil.ShowTips("批号不能为空");
                    return;
                }
                DateTime date = new DateTime();
                if (!DateTime.TryParse(row.Cells["CREATE_TIME"].Value.ToString(), out date))
                {
                    MessageUtil.ShowTips("创建时间错误");
                    return;
                }
                ArrayList list = new ArrayList();

                list.Add(row.Cells["ACT_COUNT"].Value.ToString());
                list.Add(row.Cells["ACT_THEORY_WEIGHT"].Value.ToString());
                list.Add(row.Cells["ACT_WEIGHT"].Value.ToString());
                list.Add(row.Cells["BATCH_NO"].Value.ToString());
                list.Add(row.Cells["CHEM_RESULT"].Value.ToString());
                list.Add(row.Cells["CREATE_NAME"].Value.ToString());
                list.Add(row.Cells["CREATE_TIME"].Value.ToString());
                list.Add(row.Cells["CUSTM_ORDER_NO"].Value.ToString());
                list.Add(row.Cells["CUSTOMER_NM"].Value.ToString());
                list.Add(row.Cells["CUSTOMER_NO"].Value.ToString());
                list.Add(row.Cells["CUT_NUM"].Value.ToString());
                list.Add(row.Cells["DELIVERY_STATE_CODE"].Value.ToString());
                list.Add(row.Cells["DELIVERY_STATE_NAME"].Value.ToString());
                list.Add(row.Cells["DETECT_RESULT"].Value.ToString());
                list.Add(row.Cells["DETECT_RESULT2"].Value.ToString());
                list.Add(row.Cells["FACE_RESULT"].Value.ToString());
                list.Add(row.Cells["FLAG"].Value.ToString());
                list.Add(row.Cells["GRADECODE"].Value.ToString());
                list.Add(row.Cells["GRADENAME"].Value.ToString());
                list.Add(row.Cells["JUDGE_RESULT"].Value.ToString());
                list.Add(row.Cells["JUDGE_STOVE_NO"].Value.ToString());
                list.Add(row.Cells["LEN_DESC"].Value.ToString());
                list.Add(row.Cells["LEN_MAX"].Value.ToString());
                list.Add(row.Cells["LEN_MIN"].Value.ToString());
                list.Add(row.Cells["LEN_MIN_MAX_UNIT"].Value.ToString());
	            list.Add(row.Cells["LEN_NO"].Value.ToString());
                list.Add(row.Cells["LEN_UNIT"].Value.ToString());
                list.Add(row.Cells["LOT_NO"].Value.ToString());
                list.Add(row.Cells["LOT_NO_GROUP"].Value.ToString());
                list.Add(row.Cells["MEMO"].Value.ToString());
                list.Add(row.Cells["MODEL_CODE"].Value.ToString());
                list.Add(row.Cells["MODEL_DESC"].Value.ToString());
                list.Add(row.Cells["ORDER_NO"].Value.ToString());
                list.Add(row.Cells["ORDER_SEQ"].Value.ToString());
                list.Add(row.Cells["ORDER_SPEC_CODE"].Value.ToString());
                list.Add(row.Cells["ORDER_SPEC_DESC"].Value.ToString());
                list.Add(row.Cells["ORD_LN_DLY_PK"].Value.ToString());
                list.Add(row.Cells["ORD_LN_PK"].Value.ToString());
                list.Add(row.Cells["OUTPUT_STD_NO"].Value.ToString());
                list.Add(row.Cells["PHY_RESULT"].Value.ToString());
                list.Add(row.Cells["PLINE_CODE"].Value.ToString());
                list.Add(row.Cells["PROCESS_DESC"].Value.ToString());
                list.Add(row.Cells["PROCESS_DESC"].Text);
                list.Add(row.Cells["PROCESS_RESULT"].Value.ToString());
                list.Add(row.Cells["PRODUCCODE"].Value.ToString());
                list.Add(row.Cells["PRODUCNAME"].Value.ToString());
                list.Add(row.Cells["RECEIV_NM"].Value.ToString());
                list.Add(row.Cells["RECEIV_NO"].Value.ToString());
                list.Add(row.Cells["SPEC_CODE"].Value.ToString());
                list.Add(row.Cells["SPEC_NAME"].Value.ToString());
                list.Add(row.Cells["SPEC_RESULT"].Value.ToString());
                list.Add(row.Cells["STD_CODE"].Value.ToString());
                list.Add(row.Cells["STD_NAME"].Value.ToString());
                list.Add(row.Cells["STD_STYLE"].Value.ToString());
                list.Add(row.Cells["STD_STYLE_DESC"].Value.ToString());
                list.Add(row.Cells["STEELCODE"].Value.ToString());
                list.Add(row.Cells["STEELNAME"].Value.ToString());
                list.Add(row.Cells["STOVE_NO"].Value.ToString());
                list.Add(row.Cells["USE_CODE"].Value.ToString());
                list.Add(row.Cells["USE_DESC"].Value.ToString());
                list.Add(row.Cells["WATER_RESULT"].Value.ToString());
                list.Add(row.Cells["WO_ID"].Value.ToString());
                list.Add(row.Cells["ZBS_ADD_ASK_DESC"].Value.ToString());
                list.Add(row.Cells["ZBS_MEMO"].Value.ToString());
                list.Add(row.Cells["ZBS_MEMO_JG"].Value.ToString());
                list.Add(row.Cells["ZBS_ID"].Value.ToString());
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.judge.DAL.ZbsInfoInput";
                ccp.MethodName = "saveZbsInfo";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                }
                else
                {
                    return;
                }
                MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                Query();
            }
            catch (Exception ex)
            {
                MessageBox.Show("保存失败,原因:" + ex.Message);
            }
            Query();
        }

        private void Delete()
        {
            if (ultraGrid1.ActiveRow==null)
                return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.judge.DAL.ZbsInfoInput";
            ccp.MethodName = "doDeleteZbsInfo";
            ccp.ServerParams = new object[] { ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
            }
            else
            {
                return;
            }
            MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            Query();
        }

        private void QueryChemInfo()
        {
            if (ultraGrid1.ActiveRow == null)
                return;
            DataTable dt = ServerHelper.GetData("com.steering.pss.judge.DAL.ZbsInfoInput.getChemInfo", new Object[] { ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString() }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.zbsChem, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid3);
        }

        private void saveChemInfo()
        {
            try
            {
                ultraGrid3.UpdateData();
                if (ultraGrid1.ActiveRow == null)
                    return;
                if (ultraGrid3.Rows.Count <= 0)
                    return;
                ArrayList parm = new ArrayList();
                foreach (UltraGridRow row in ultraGrid3.Rows)
                {
                    ArrayList list = new ArrayList();
                    list.Add(ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString());
                    list.Add(ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString());
                    list.Add(row.Cells["SAMPLE_NO"].Value.ToString());
                    list.Add(row.Cells["PROCESS_CODE"].Value.ToString());
                    list.Add(row.Cells["CHEM_TYPE"].Value.ToString());
                    list.Add(row.Cells["CHEM_NAME"].Value.ToString());
                    list.Add(row.Cells["CHEM_VALUE"].Value.ToString());
                    list.Add(row.Cells["NK_MIN"].Value.ToString());
                    list.Add(row.Cells["NK_MAX"].Value.ToString());
                    list.Add("1");
                    list.Add(row.Cells["JF_MIN"].Value.ToString());
                    list.Add(row.Cells["JF_MAX"].Value.ToString());
                    list.Add("1");
                    list.Add(row.Cells["ROUND"].Value.ToString());
                    list.Add(row.Cells["SAMPLE_ID"].Value.ToString());
                    list.Add(ultraGrid1.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    parm.Add(list);
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.judge.DAL.ZbsInfoInput";
                ccp.MethodName = "saveChemInfo";
                ccp.ServerParams = new object[] { parm, ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                }
                else
                {
                    return;
                }
                MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                Query();
            }
            catch (Exception ex)
            {
                MessageBox.Show("保存失败,原因:" + ex.Message);
            }
        }

        private void DeleteChemInfo()
        {
            if (ultraGrid1.ActiveRow == null)
                return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.judge.DAL.ZbsInfoInput";
            ccp.MethodName = "DeleteChemInfo";
            ccp.ServerParams = new object[] { ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString(),
            ultraGrid3.ActiveRow.Cells["ZBS_SEQ"].Value.ToString()};
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
            }
            else
            {
                return;
            }
            MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            Query();
        }

        private void QueryPhyInfo()
        {
            if (ultraGrid1.ActiveRow == null)
                return;
            DataTable dt = ServerHelper.GetData("com.steering.pss.judge.DAL.ZbsInfoInput.getPhyInfo", new Object[] { ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString() }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.zbsPhy, true);
            GridHelper.RefreshAndAutoSize(this.ultraGrid2);
        }

        private void savePhyInfo()
        {
            try
            {
                ultraGrid2.UpdateData();
                if (ultraGrid1.ActiveRow == null)
                    return;
                if (ultraGrid2.Rows.Count <= 0)
                    return;
                ArrayList parm = new ArrayList();
                foreach (UltraGridRow row in ultraGrid2.Rows)
                {
                    if ("".Equals(row.Cells["SAMPLE_NO"].Value.ToString()))
                    {
                        MessageUtil.ShowTips("试样号不能为空");
                        return;
                    }
                    if ("".Equals(row.Cells["PROCESS_CODE"].Value.ToString()))
                    {
                        MessageUtil.ShowTips("工序代码不能为空");
                        return;
                    }
                    if ("".Equals(row.Cells["PHY_CODE_MAX"].Value.ToString()))
                    {
                        MessageUtil.ShowTips("检验大项不能为空");
                        return;
                    }
                    if ("".Equals(row.Cells["PHY_CODE_MIN"].Value.ToString()))
                    {
                        MessageUtil.ShowTips("试样组不能为空");
                        return;
                    }
                    if ("".Equals(row.Cells["PHY_CODE"].Value.ToString()))
                    {
                        MessageUtil.ShowTips("检验项不能为空");
                        return;
                    }
                    ArrayList list = new ArrayList();
                    list.Add(ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString());
                    list.Add(ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString());
                    list.Add(row.Cells["AUDIT_NAME"].Value.ToString());
                    //list.Add(row.Cells["AUDIT_TIME"].Value.ToString());
                    list.Add(row.Cells["AVERAGE"].Value.ToString());
                    list.Add(row.Cells["AVERAGE_VALUE_F"].Value.ToString());
                    list.Add(row.Cells["CHECK_NAME"].Value.ToString());

                    list.Add(row.Cells["CHECK_TEMP"].Value.ToString());
                    //list.Add(row.Cells["CHECK_TIME"].Value.ToString());
                    list.Add(row.Cells["DEVICE_NAME"].Value.ToString());
                    list.Add(row.Cells["DEVICE_NO"].Value.ToString());
                    list.Add(row.Cells["FORMUAL_NAME"].Value.ToString());

                    list.Add(row.Cells["FORMUAL_NO"].Value.ToString());
                    list.Add(row.Cells["HARDNESS_TYPE"].Value.ToString());
                    list.Add(row.Cells["ISRCL"].Value.ToString());
                    list.Add("");
                    list.Add("");
                    //list.Add(row.Cells["IS_DEFECT"].Value.ToString());
                    //list.Add(row.Cells["IS_GOOD"].Value.ToString());

                    list.Add(row.Cells["ITEM_CODE_F"].Value.ToString());
                    list.Add(row.Cells["ITEM_CODE_S"].Value.ToString());
                    list.Add(row.Cells["ITEM_CODE_W"].Value.ToString());
                    list.Add(row.Cells["ITEM_NAME_F"].Value.ToString());
                    list.Add(row.Cells["ITEM_NAME_S"].Value.ToString());

                    list.Add(row.Cells["ITEM_NAME_W"].Value.ToString());
                    list.Add(row.Cells["JF_ADD_CONDITION"].Value.ToString());
                    list.Add(row.Cells["JF_ADD_JUDGE_BASIS"].Value.ToString());
                    list.Add(row.Cells["JF_ADD_MAX"].Value.ToString());
                    list.Add(row.Cells["JF_ADD_MIN"].Value.ToString());

                    list.Add(row.Cells["JF_JUDGE_BASIS"].Value.ToString());
                    list.Add(row.Cells["JF_MAX"].Value.ToString());
                    list.Add(row.Cells["JF_MIN"].Value.ToString());
                    list.Add("1");
                    //list.Add(row.Cells["JF_TOL_QUALIFIED"].Value.ToString());
                    list.Add(row.Cells["NK_ADD_CONDITION"].Value.ToString());

                    list.Add(row.Cells["NK_ADD_JUDGE_BASIS"].Value.ToString());
                    list.Add(row.Cells["NK_ADD_MAX"].Value.ToString());
                    list.Add(row.Cells["NK_ADD_MIN"].Value.ToString());
                    list.Add(row.Cells["NK_JUDGE_BASIS"].Value.ToString());
                    list.Add(row.Cells["NK_MAX"].Value.ToString());

                    list.Add(row.Cells["NK_MIN"].Value.ToString());
                    list.Add("1");
                    //list.Add(row.Cells["NK_TOL_QUALIFIED"].Value.ToString());
                    list.Add(row.Cells["PHY_CODE"].Value.ToString());
                    list.Add(row.Cells["PHY_CODE_DIR"].Value.ToString());
                    list.Add(row.Cells["PHY_CODE_MAX"].Value.ToString());

                    list.Add(row.Cells["PHY_CODE_MIN"].Value.ToString());
                    list.Add(row.Cells["PHY_NAME"].Value.ToString());
                    list.Add(row.Cells["PHY_NAME_DIR"].Value.ToString());
                    list.Add(row.Cells["PHY_NAME_MAX"].Value.ToString());
                    list.Add(row.Cells["PHY_NAME_MIN"].Value.ToString());

                    list.Add(row.Cells["PROCESS_CODE"].Value.ToString());
                    list.Add(row.Cells["REMARK"].Value.ToString());
                    list.Add(row.Cells["SAMPLE_ID"].Value.ToString());
                    list.Add(row.Cells["SAMPLE_NO"].Value.ToString());
                    list.Add(row.Cells["SAMPLE_SIZE"].Value.ToString());

                    list.Add(row.Cells["SAMPLE_STYLE"].Value.ToString());
                    list.Add(row.Cells["SIZE_DESC"].Value.ToString());
                    list.Add(row.Cells["VALUE1"].Value.ToString());
                    list.Add(row.Cells["VALUE10"].Value.ToString());
                    list.Add(row.Cells["VALUE11"].Value.ToString());

                    list.Add(row.Cells["VALUE12"].Value.ToString());
                    list.Add(row.Cells["VALUE13"].Value.ToString());
                    list.Add(row.Cells["VALUE14"].Value.ToString());
                    list.Add(row.Cells["VALUE15"].Value.ToString());
                    list.Add(row.Cells["VALUE2"].Value.ToString());

                    list.Add(row.Cells["VALUE3"].Value.ToString());
                    list.Add(row.Cells["VALUE4"].Value.ToString());
                    list.Add(row.Cells["VALUE5"].Value.ToString());
                    list.Add(row.Cells["VALUE6"].Value.ToString());
                    list.Add(row.Cells["VALUE7"].Value.ToString());

                    list.Add(row.Cells["VALUE8"].Value.ToString());
                    list.Add(row.Cells["VALUE9"].Value.ToString());
                    list.Add(row.Cells["VALUE_F2"].Value.ToString());
                    list.Add(row.Cells["VALUE_F3"].Value.ToString());
                    list.Add(row.Cells["VALUE_KSI"].Value.ToString());
                    list.Add(row.Cells["VALUE_PSI"].Value.ToString());
                    parm.Add(list);
                }
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.pss.judge.DAL.ZbsInfoInput";
                ccp.MethodName = "savePhyInfo";
                ccp.ServerParams = new object[] { parm, ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString() };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp != null)
                {
                    if (ccp.ReturnCode == -1)
                    {
                        MessageUtil.ShowWarning(ccp.ReturnInfo);
                        return;
                    }
                }
                else
                {
                    return;
                }
                MessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                Query();
            }
            catch (Exception ex)
            {
                MessageBox.Show("保存失败,原因:" + ex.Message);
            }
            
        }

        private void DeletePhyInfo()
        {
            if (ultraGrid1.ActiveRow == null)
                return;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.judge.DAL.ZbsInfoInput";
            ccp.MethodName = "DeletePhyInfo";
            ccp.ServerParams = new object[] { ultraGrid1.ActiveRow.Cells["ZBS_ID"].Value.ToString() ,
            ultraGrid2.ActiveRow.Cells["ZBS_SEQ"].Value.ToString()};
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
            }
            else
            {
                return;
            }
            MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            Query();
        }


        private void QcmZbsInfoInput_Load(object sender, EventArgs e)
        {
            //默认查询当前日期-1月——当前日期数据。
            udtStart.DateTime = Convert.ToDateTime(DateTime.Now.AddMonths(-1).ToShortDateString());
            udtEnd.DateTime = Convert.ToDateTime(DateTime.Now.ToShortDateString());
            ValueList list1 = new ValueList();
            ValueListItem[] items1 = new ValueListItem[] {
                new ValueListItem("0", "熔炼成分"),
                new ValueListItem("1", "成品成分"),
            };
            list1.ValueListItems.AddRange(items1);
            ultraGrid3.DisplayLayout.Bands[0].Columns["CHEM_TYPE"].ValueList = list1;

            ValueList list2 = new ValueList();
            ValueListItem[] items2 = new ValueListItem[] {
                new ValueListItem("0", "否"),
                new ValueListItem("1", "是"),
            };
            list2.ValueListItems.AddRange(items2);
            ultraGrid2.DisplayLayout.Bands[0].Columns["ISRCL"].ValueList = list2;

            ValueList list3 = new ValueList();
            ValueListItem[] items3 = new ValueListItem[] {
                new ValueListItem("A", "炼钢"),
                new ValueListItem("D", "轧制"),
                new ValueListItem("A", "热处理"),
                new ValueListItem("G", "加工"),
            };
            list3.ValueListItems.AddRange(items3);
            ultraGrid1.DisplayLayout.Bands[0].Columns["PROCESS_DESC"].ValueList = list3;

            DataTable dtChem = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407401" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["CHEM_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtChem);
            DataTable dtPhy = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407402" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["PHY_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtPhy);
            DataTable dtFace = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407406" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["FACE_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtFace);
            DataTable dtSpec = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407403" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["SPEC_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtSpec);
            DataTable dtDetect = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407404" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["DETECT_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtDetect);
            DataTable dtWater = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407405" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["WATER_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtWater);
            DataTable dtProcess = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407408" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["PROCESS_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtProcess);
            DataTable dtJudge = ServerHelper.GetData("com.steering.pss.glbusiness.GlOrderManage.getBaseInfo", new object[] { "407407" }, this.ob);
            ultraGrid1.DisplayLayout.Bands[0].Columns["JUDGE_RESULT"].ValueList = ComHelper.List_GetBaseInfo(dtJudge);

            DataTable dt = ServerHelper.GetData("com.steering.pss.judge.DAL.ZbsInfoInput.getPlineInfo", new Object[] {  }, this.ob);
            ValueListItem[] items4 = new ValueListItem[dt.Rows.Count];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ValueListItem item = new ValueListItem();
                item.DataValue = dt.Rows[i]["pline_code"].ToString();
                item.DisplayText = dt.Rows[i]["pline_name"].ToString();
                items4[i] = item;
            }
            ValueList valueList = new ValueList();
            valueList.ValueListItems.AddRange(items4);
            ultraGrid1.DisplayLayout.Bands[0].Columns["PLINE_CODE"].ValueList = valueList;

        }


        private void ckJudgeNo_CheckedChanged(object sender, EventArgs e)
        {
            if (ckJudgeNo.Checked)
                utJudgeNo.ReadOnly = false;
            else
                utJudgeNo.ReadOnly = true;
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            zbsChem.Clear();
            zbsPhy.Clear();
            QueryChemInfo();
            QueryPhyInfo();
        }

        private void ultraTextEditor3_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
                if (ultraGrid2.ActiveCell.Column.Key == "PHY_NAME_MAX")
            {
                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.geComBasePhyRStd", null, ob);
                dt.Columns["PHY_TYPE"].Caption = "检验大项";
                BaseInfoPopup baseInfoPopup = new BaseInfoPopup(dt, "PHY_TYPE", "PHY_CODE");
                baseInfoPopup.Text = "检验大项";
                baseInfoPopup.LabelTextBox1.Caption = "检验大项";
                baseInfoPopup.Shown += new EventHandler((c, d) =>
                {
                    IQueryable<UltraGridRow> rows = baseInfoPopup.ultraGrid1.Rows.AsQueryable().Where(
                    a => a.GetValue("PHY_CODE") == ultraGrid2.ActiveRow.GetValue("PHY_CODE_MAX"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });

                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid2.ActiveRow.SetValue("PHY_NAME_MAX", baseInfoPopup.ChoicedRow.GetValue("PHY_TYPE"));
                    ultraGrid2.ActiveRow.SetValue("PHY_CODE_MAX", baseInfoPopup.ChoicedRow.GetValue("PHY_CODE"));
                    ultraGrid2.ActiveRow.SetValue("PHY_NAME_MIN", "");
                    ultraGrid2.ActiveRow.SetValue("PHY_CODE_MIN", "");
                    ultraGrid2.ActiveRow.SetValue("PHY_NAME", "");
                    ultraGrid2.ActiveRow.SetValue("PHY_CODE", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_F", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_F", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_W", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_W", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_S", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_S", "");
                }
            }
            else if (ultraGrid2.ActiveCell.Column.Key == "PHY_NAME_MIN")
            {
                string phyCodeMax = ultraGrid2.ActiveRow.GetValue("PHY_CODE_MAX");
                if (phyCodeMax == "")
                {
                    MessageUtil.ShowWarning("请选检验大项！");
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.geComBasePhyC", new object[] { phyCodeMax }, ob);
                dt.Columns["PHY_TYPE"].Caption = "试样组";
                BaseInfoPopup baseInfoPopup = new BaseInfoPopup(dt, "PHY_TYPE", "PHY_CODE");
                baseInfoPopup.Text = "试样组";
                baseInfoPopup.LabelTextBox1.Caption = "试样组";
                baseInfoPopup.Shown += new EventHandler((c, d) =>
                {
                    IQueryable<UltraGridRow> rows = baseInfoPopup.ultraGrid1.Rows.AsQueryable().Where(
                        a => a.GetValue("PHY_CODE") == ultraGrid2.ActiveRow.GetValue("PHY_CODE_MIN"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid2.ActiveRow.SetValue("PHY_NAME_MIN", baseInfoPopup.ChoicedRow.GetValue("PHY_TYPE"));
                    ultraGrid2.ActiveRow.SetValue("PHY_CODE_MIN", baseInfoPopup.ChoicedRow.GetValue("PHY_CODE"));
                    ultraGrid2.ActiveRow.SetValue("PHY_NAME", "");
                    ultraGrid2.ActiveRow.SetValue("PHY_CODE", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_F", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_F", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_S", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_S", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_W", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_W", "");
                }
            }
            else if (ultraGrid2.ActiveCell.Column.Key == "PHY_NAME")
            {
                string phyCodeMax = ultraGrid2.ActiveRow.GetValue("PHY_CODE_MAX");
                string phyCodeMin = ultraGrid2.ActiveRow.GetValue("PHY_CODE_MIN");
                if (phyCodeMax == "")
                {
                    MessageUtil.ShowWarning("请选择检验大项");
                    ultraGrid2.ActiveRow.Cells["PHY_NAME_MAX"].Activate();
                    return;
                }
                else if (phyCodeMin == "")
                {
                    MessageUtil.ShowWarning("请选择试样组");
                    ultraGrid2.ActiveRow.Cells["PHY_NAME_MIN"].Activate();
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.geComBasePhy", new object[] { phyCodeMax, phyCodeMin }, ob);
                dt.Columns["PHY_NAME"].Caption = "检验项";
                BaseInfoPopup baseInfoPopup = new BaseInfoPopup(dt, "PHY_NAME", "PHY_CODE");
                baseInfoPopup.Text = "检验项";
                baseInfoPopup.LabelTextBox1.Caption = "检验项";
                baseInfoPopup.Shown += new EventHandler((c, d) =>
                {
                    IQueryable<UltraGridRow> rows = baseInfoPopup.ultraGrid1.Rows.AsQueryable().Where(
                        a => a.GetValue("PHY_CODE") == ultraGrid2.ActiveRow.GetValue("PHY_CODE"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid2.ActiveRow.SetValue("PHY_NAME", baseInfoPopup.ChoicedRow.GetValue("PHY_NAME"));
                    ultraGrid2.ActiveRow.SetValue("PHY_CODE", baseInfoPopup.ChoicedRow.GetValue("PHY_CODE"));
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_W", "");
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_W", "");
                }
                if (baseInfoPopup.ChoicedRow.GetValue("PHY_CODE") == "P0618" || baseInfoPopup.ChoicedRow.GetValue("PHY_CODE") == "P0619")
                {
                    ultraGrid2.ActiveRow.SetValue("STDMIN_SIGN", "=");
                    ultraGrid2.ActiveRow.SetValue("STDMIN", "否");
                }
            }
            else if (ultraGrid2.ActiveCell.Column.Key == "ITEM_NAME_F")
            {
                string phyTypeC = ultraGrid2.ActiveRow.GetValue("PHY_CODE_MIN");
                if (phyTypeC == "")
                {
                    MessageUtil.ShowWarning("请选择试样组");
                    ultraGrid2.ActiveRow.Cells["PHY_NAME_MIN"].Activate();
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.geComBasePhyRItem",
                    new object[] { phyTypeC }, ob);
                dt.Columns["ITEM_NAME_F"].Caption = "试验方向";
                dt.Columns["ITEM_NAME_C"].Caption = "试验尺寸";
                if (ultraGrid2.ActiveRow.GetValue("PHY_CODE_MAX") == "R0001")
                {
                    dt.DefaultView.RowFilter = "ITEM_CODE_F IS NOT NULL";
                }
                if (ultraGrid2.ActiveRow.GetValue("PHY_CODE_MAX") == "R0002")
                {
                    dt.DefaultView.RowFilter = "ITEM_CODE_C IS NOT NULL AND ITEM_CODE_F IS NOT NULL";
                }
                BaseInfoPopup baseInfoPopup = new BaseInfoPopup(dt, "ITEM_NAME_F", "ITEM_CODE_F", "ITEM_CODE_C");
                baseInfoPopup.Text = "试验选择";
                baseInfoPopup.LabelTextBox1.Caption = "试验方向";
                baseInfoPopup.Shown += new EventHandler((c, d) =>
                {
                    IQueryable<UltraGridRow> rows = baseInfoPopup.ultraGrid1.Rows.AsQueryable().Where(
                        a => a.GetValue("ITEM_CODE_F") == ultraGrid2.ActiveRow.GetValue("ITEM_CODE_F")
                        && a.GetValue("ITEM_CODE_C") == ultraGrid2.ActiveRow.GetValue("ITEM_CODE_S"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_F", baseInfoPopup.ChoicedRow.GetValue("ITEM_NAME_F"));
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_F", baseInfoPopup.ChoicedRow.GetValue("ITEM_CODE_F"));
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_S", baseInfoPopup.ChoicedRow.GetValue("ITEM_NAME_C"));
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_S", baseInfoPopup.ChoicedRow.GetValue("ITEM_CODE_C"));
                }
            }
            else if (ultraGrid2.ActiveCell.Column.Key == "ITEM_NAME_W")
            {
                string phyCode = ultraGrid2.ActiveRow.GetValue("PHY_CODE");
                if (phyCode == "")
                {
                    MessageUtil.ShowWarning("请选择检验项");
                    ultraGrid2.ActiveRow.Cells["PHY_NAME"].Activate();
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.geComBasePhyRPos",
                    new object[] { phyCode }, ob);
                dt.Columns["ITEM_NAME_W"].Caption = "试验温度";
                if (ultraGrid2.ActiveRow.GetValue("PHY_CODE_MAX") == "R0001")
                {
                    dt.DefaultView.RowFilter = "ITEM_CODE_W IS NOT NULL";
                }
                BaseInfoPopup baseInfoPopup = new BaseInfoPopup(dt, "ITEM_NAME_W", "ITEM_CODE_W");
                baseInfoPopup.Text = "试验选择";
                baseInfoPopup.LabelTextBox1.Caption = "试验温度";
                baseInfoPopup.Shown += new EventHandler((c, d) =>
                {
                    IQueryable<UltraGridRow> rows = baseInfoPopup.ultraGrid1.Rows.AsQueryable().Where(
                        a => a.GetValue("ITEM_CODE_W") == ultraGrid2.ActiveRow.GetValue("ITEM_CODE_W"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    ultraGrid2.ActiveRow.SetValue("ITEM_NAME_W", baseInfoPopup.ChoicedRow.GetValue("ITEM_NAME_W"));
                    ultraGrid2.ActiveRow.SetValue("ITEM_CODE_W", baseInfoPopup.ChoicedRow.GetValue("ITEM_CODE_W"));
                }
            }
        }

        private void ultraGrid2_AfterRowInsert(object sender, RowEventArgs e)
        {
            ultraGrid2.ActiveRow.SetValue("ISRCL", "0");
        }
    }
}