MES_Client/TGMES/Core.StlMes.Client.SaleOrder/Control/CraftOrdDesignStdPicCtrl.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Core.StlMes.Client.SaleOrder.BLL;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Qcm;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win.UltraWinEditors;
using Core.Mes.Client.Comm.Server;
using CoreFS.SA06;
using Infragistics.Win;
using Core.Mes.Client.Comm.Control;

namespace Core.StlMes.Client.SaleOrder.Control
{
    public partial class CraftOrdDesignStdPicCtrl : UserControl
    {
        private CraftOrdDesignStdPicBLL _designStdPicBLL;
        private CraftOrdDesignMscPlBLL _designMscPlBLL;
        private CraftOrdDesignMscPlPrcBLL _designMscPlPrcBLL;
        private OpeBase _ob;

        private UltraComboEditor Pics = new UltraComboEditor();

        public CraftOrdDesignStdPicCtrl(System.Windows.Forms.Control container, OpeBase ob)
        {
            InitializeComponent();
            _ob = ob;
            _designStdPicBLL = new CraftOrdDesignStdPicBLL(ob);
            _designMscPlBLL = new CraftOrdDesignMscPlBLL(ob);
            _designMscPlPrcBLL = new CraftOrdDesignMscPlPrcBLL(ob);
            container.Controls.Add(this);
            this.Dock = DockStyle.Fill;
            LoadBaseData();
        }

        private void LoadBaseData()
        {
            QcmBaseCommon.InitSignMin(ultraComSignMin);
            QcmBaseCommon.InitSignMax(ultraComSignMax);
            //初始化理化检验项大类
            ultraComPhyMax.DropDownListWidth = -1;
            QcmBaseQuery.NitializeDropDownBox(ultraComPhyMax, "com.steering.pss.qcm.ComBaseQuery.geComBasePhyRStd", "PHY_TYPE", "PHY_CODE", false, _ob);
            //初始化结箍名称
            QcmBaseQuery.NitializeJG(ultraComJG, true, _ob);
            //初始化限制规格
            QcmBaseCommon.InitDropUltraComEditor(ultraComSize, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4003", "BASENAME", _ob, true);
            //交货标准
            QcmBaseCommon.InitDropUltraComEditor(ultraComboDelivery, "com.steering.pss.qcm.ComBaseQuery.geComBaseInfo4060", "BASENAME", _ob, true);
            //内控标准

            UltraGridBand ugc = entityGrid1.DisplayLayout.Bands[0];
            //附加标准
            UltraComboEditor uceAddStdCon = new UltraComboEditor();
            this.Controls.Add(uceAddStdCon);
            uceAddStdCon.Visible = false;
            QcmBaseCommon.InitDropUltraComEditor(uceAddStdCon, "com.steering.pss.qcm.ComMaterial.getAddCondition", "BASENAME", _ob, false);
            entityGrid1.DisplayLayout.Bands[0].Columns["AddstdconCode"].EditorComponent = uceAddStdCon;
            entityGrid1.DisplayLayout.Bands[0].Columns["AddstdconCode"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;

            ClsBaseInfo.SetComboItemHeight(uceAddStdCon);

            this.Controls.Add(Pics);
            Pics.Visible = false;

            //多标准选择分类
            UltraComboEditor uceMultStd = new UltraComboEditor();
            this.Controls.Add(uceMultStd);
            uceMultStd.Visible = false;
            QcmBaseCommon.InitDropUltraComEditor(uceMultStd, "com.steering.pss.qcm.ComMaterial.getMultStd", "BASENAME", _ob, true);
            entityGrid1.DisplayLayout.Bands[0].Columns["StdChoose"].EditorComponent = uceMultStd;
            entityGrid1.DisplayLayout.Bands[0].Columns["StdChoose"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            ClsBaseInfo.SetComboItemHeight(uceMultStd);
        }

        /// <summary>
        /// 查询质量设计理化
        /// </summary>
        /// <param name="designStdPicEntity"></param>
        public void Query(CraftOrdDesignStdPicEntity designStdPicEntity)
        {
            this.CraftOrdDesignStdPicEntityBindingSource.DataSource = _designStdPicBLL.Query(designStdPicEntity);
        }

        private string designKey = "";
        private string[] _parms;
        /// <summary>
        /// 查询质量设计理化
        /// </summary>
        /// <param name="designStdPicEntity"></param>
        public void QueryByDesignKeyPic(string[] parms)
        {
            designKey = parms[0];
            _parms = parms;
            var data =  _designStdPicBLL.QueryByDesignKeyPic(parms);

            var list = data.Select(p => p.Pic).Distinct().ToList();
            if (list.Count > 1)
            {
                Pics.DataSource = data.Select(p => p.Pic).Distinct().ToList();
                QcmBaseQuery.BindColumn(Pics, "Pic", entityGrid1.DisplayLayout.Bands[0]);
            }

            this.CraftOrdDesignStdPicEntityBindingSource.DataSource = data;
            //UltraComboEditor cmb = new UltraComboEditor();
            foreach (var row in entityGrid1.Rows)
            {
                GridEdite(row);
                if (row.GetValue("CraftSource") == "0")
                {
                    row.Cells["Chk"].Value = null;
                    row.Cells["Chk"].Activation = Activation.ActivateOnly;
                    row.Update();
                }
                //if (cmb.ValueList.FindString(row.GetValue("Pic")) == -1)
                //{
                //    cmb.ValueList.ValueListItems.Add(row.GetValue("Pic"));
                //}
            }

            //cmb.DisplayStyle = EmbeddableElementDisplayStyle.WindowsVista;
            //entityGrid1.DisplayLayout.Bands[0].Columns["Pic"].EditorComponent = cmb;
            //entityGrid1.DisplayLayout.Bands[0].Columns["Pic"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
        }

        public void Clear()
        {
            this.CraftOrdDesignStdPicEntityBindingSource.Clear();
        }

        public void Save()
        {
            List<CraftOrdDesignStdPicEntity> parms = new List<CraftOrdDesignStdPicEntity>();
            var rows = entityGrid1.Rows.Where(a=>a.GetValue("Chk") == "True");
            foreach (var row in rows)
            {
                var parm = EntityHelper.CopyEntity<CraftOrdDesignStdPicEntity>(row.ListObject);
                if (parm.MscPline == "")
                {
                    MessageUtil.ShowWarning("请选择制程！");
                    row.SetCellActive("MscPline");
                    return;
                }
                //if (parm.ProcessDescC == "")
                //{
                //    MessageUtil.ShowWarning("请选择二级工序！");
                //    row.SetCellActive("ProcessDescC");
                //    return;
                //}
                if (parm.Pic == "")
                {
                    MessageUtil.ShowWarning("请选择理化索引码！");
                    row.SetCellActive("Pic");
                    return;
                }
                if (parm.PhyNameMax == "")
                {
                    MessageUtil.ShowWarning("请选择检验项！");
                    row.SetCellActive("PhyNameMax");
                    return;
                }
                if (parm.PhyNameMin == "")
                {
                    MessageUtil.ShowWarning("请选择试样组！");
                    row.SetCellActive("PhyNameMin");
                    return;
                }
                if (parm.PhyName == "")
                {
                    MessageUtil.ShowWarning("请选择检验项目！");
                    row.SetCellActive("PhyName");
                    return;
                }

                if (parm.StdminSign == "=" && (parm.StdmaxSign != "" || parm.Stdmax != ""))
                {
                    MessageUtil.ShowWarning("标准范围下限符号为'=',不能存在上限！");
                    row.SetCellActive("Stdmax");
                    return;
                }

                if (parm.Isjudge == true)
                {
                    if (parm.StdminSign.Equals("") && parm.StdmaxSign.Equals(""))
                    {
                        MessageUtil.ShowWarning("请选择标准范围(默认)下限符号或者上限符号！");
                        row.SetCellActive("StdminSign");
                        return;
                    }
                }
                if (!parm.StdminSign.Equals("") && parm.Stdmin.Equals(""))
                {
                    MessageUtil.ShowWarning("请输入标准范围(默认)下限值！");
                    row.SetCellActive("Stdmin");
                    return;
                }
                if (parm.StdminSign.Equals("") && !parm.Stdmin.Equals(""))
                {
                    MessageUtil.ShowWarning("请选择标准范围(默认)下限符号！");
                    row.SetCellActive("StdminSign");
                    return;
                }
                if (!parm.StdmaxSign.Equals("") && parm.Stdmax.Equals(""))
                {
                    MessageUtil.ShowWarning("请输入标准范围(默认)上限值！");
                    row.SetCellActive("Stdmax");
                    return;
                }
                if (parm.StdmaxSign.Equals("") && !parm.Stdmax.Equals(""))
                {
                    MessageUtil.ShowWarning("已有标准范围(默认)上限值，请选择标准范围(默认)上限符号！");
                    row.SetCellActive("StdmaxSign");
                    return;
                }
                if (parm.PhyType == false)
                {
                    if (!parm.Stdmin.Equals("") && !StringUtil.IsNumber(parm.Stdmin) && !parm.StdminSign.Equals("="))
                    {
                        MessageUtil.ShowWarning("标准范围(默认)下限值由数字组成！");
                        row.SetCellActive("Stdmin");
                        return;
                    }
                    if (!parm.Stdmax.Equals("") && !StringUtil.IsNumber(parm.Stdmax))
                    {
                        MessageUtil.ShowWarning("标准范围(默认)上限值由数字组成！");
                        row.SetCellActive("Stdmax");
                        return;
                    }
                }
                else
                {
                    if (!parm.Stdmin.Equals("") && !parm.StdminSign.Equals("=") && !QcmBaseCommon.CheckCompositeFormula(parm.Stdmin))
                    {
                        MessageUtil.ShowWarning("标准范围(默认)下限值，输入公式不合法，请重新输入！");
                        row.SetCellActive("Stdmin");
                        return;
                    }
                    if (!parm.Stdmax.Equals("") && !QcmBaseCommon.CheckCompositeFormula(parm.Stdmax))
                    {
                        MessageUtil.ShowWarning("标准范围(默认)上限值，输入公式不合法，请重新输入！");
                        row.SetCellActive("Stdmax");
                        return;
                    }
                }


                if (!parm.Stdmin.Equals(""))
                {
                    if (parm.Stdmin.StartsWith("."))
                        parm.Stdmin = "0" + parm.Stdmin;
                }
                if (!parm.Stdmax.Equals(""))
                {
                    if (parm.Stdmax.StartsWith("."))
                        parm.Stdmax = "0" + parm.Stdmax;
                }
                if (!parm.Stdmin.Equals("") && !parm.Stdmax.Equals("")) //&& Convert.ToDouble(stdmin) > Convert.ToDouble(stdmax)
                {
                    int i = QcmBaseInfo.CheckStdData(parm.StdminSign, parm.StdmaxSign, parm.Stdmin, parm.Stdmax);
                    if (i == 0)
                    {
                        MessageUtil.ShowWarning("输入的数据不完整！");
                        return;
                    }
                    if (i == 1)
                    {
                        MessageUtil.ShowWarning("标准范围(默认)下限值与上限值相等，上下限符号请选择<=和>=！");
                        row.SetCellActive("StdminSign");
                        return;
                    }
                    if (i == 2)
                    {
                        MessageUtil.ShowWarning("标准范围(默认)下限值不能大于上限值！");
                        row.SetCellActive("Stdmin");
                        return;
                    }

                }

                if (parm.JudgeBasis.Equals(""))
                {
                    MessageUtil.ShowWarning("判断依据不能为空！");
                    row.SetCellActive("JudgeBasis");
                    return;
                }

                if (parm.StdminSign2 == "=" && (parm.StdmaxSign2 != "" || parm.Stdmax2 != ""))
                {
                    MessageUtil.ShowWarning("标准范围(二)下限符号为'=',不能存在上限！");
                    row.SetCellActive("Stdmax2");
                    return;
                }

                if (parm.StdChoose != "")    //取大/小值
                {
                    if (parm.StdminSign2.Equals("") && parm.StdmaxSign2.Equals(""))
                    {
                        MessageUtil.ShowWarning("请选择标准范围(二)下限符号或者上限符号！");
                        row.SetCellActive("StdminSign2");
                        return;
                    }

                    if (!parm.StdminSign2.Equals("") && parm.Stdmin2.Equals(""))
                    {
                        MessageUtil.ShowWarning("请输入标准范围(二)下限值！");
                        row.SetCellActive("Stdmin2");
                        return;
                    }
                    if (parm.StdminSign2.Equals("") && !parm.Stdmin2.Equals(""))
                    {
                        MessageUtil.ShowWarning("标准范围(默认)不存在下限符号，则标准范围(二)下限不能存在值！");
                        row.SetCellActive("Stdmin2");
                        return;
                    }
                    if (!parm.StdmaxSign2.Equals("") && parm.Stdmax2.Equals(""))
                    {
                        MessageUtil.ShowWarning("请输入标准范围(二)上限值！");
                        row.SetCellActive("Stdmax2");
                        return;
                    }
                    if (parm.StdmaxSign2.Equals("") && !parm.Stdmax2.Equals(""))
                    {
                        MessageUtil.ShowWarning("标准范围(默认)不存在上限符号，则标准范围(二)上限不能存在值！");
                        row.SetCellActive("Stdmax2");
                        return;
                    }

                    if (parm.PhyType == false)
                    {
                        if (!parm.Stdmin2.Equals("") && !StringUtil.IsNumber(parm.Stdmin2) && !parm.StdminSign2.Equals("="))
                        {
                            MessageUtil.ShowWarning("标准范围(二)下限值由数字组成！");
                            row.SetCellActive("Stdmin2");
                            return;
                        }
                        if (!parm.Stdmax2.Equals("") && !StringUtil.IsNumber(parm.Stdmax2))
                        {
                            MessageUtil.ShowWarning("标准范围(二)上限值由数字组成！");
                            row.SetCellActive("Stdmax2");
                            return;
                        }
                    }
                    else
                    {
                        if (!parm.Stdmin2.Equals("") && !parm.StdminSign2.Equals("=") && !StringUtil.IsNumber(parm.Stdmin2)
                            && !QcmBaseCommon.CheckCompositeFormula(parm.Stdmin2))
                        {
                            MessageUtil.ShowWarning("标准范围(二)下限值输入公式不合法，请重新输入！");
                            row.SetCellActive("Stdmin2");
                            return;
                        }
                        if (!parm.Stdmax2.Equals("") && !StringUtil.IsNumber(parm.Stdmax2) && !QcmBaseCommon.CheckCompositeFormula(parm.Stdmax2))
                        {
                            MessageUtil.ShowWarning("标准范围(二)上限值输入公式不合法，请重新输入！");
                            row.SetCellActive("Stdmax2");
                            return;
                        }
                    }


                    if (!parm.Stdmin2.Equals(""))
                    {
                        if (parm.Stdmin2.StartsWith("."))
                            parm.Stdmin2 = "0" + parm.Stdmin2;
                    }
                    if (!parm.Stdmax2.Equals(""))
                    {
                        if (parm.Stdmax2.StartsWith("."))
                            parm.Stdmax2 = "0" + parm.Stdmax2;
                    }
                    if (!parm.Stdmin2.Equals("") && !parm.Stdmax2.Equals("")) //&& Convert.ToDouble(stdmin2) > Convert.ToDouble(stdmax2)
                    {
                        int i = QcmBaseInfo.CheckStdData(parm.StdminSign2, parm.StdmaxSign2, parm.Stdmin2, parm.Stdmax2);
                        if (i == 0)
                        {
                            MessageUtil.ShowWarning("输入的数据不完整！");
                            return;
                        }
                        if (i == 1)
                        {
                            MessageUtil.ShowWarning("标准范围(二)下限值与上限值相等，上下限符号请选择<=和>=！");
                            row.SetCellActive("StdminSign2");
                            return;
                        }
                        if (i == 2)
                        {
                            MessageUtil.ShowWarning("标准范围(二)下限值不能大于上限值！");
                            row.SetCellActive("Stdmin2");
                            return;
                        }
                    }
                }

                if (parm.SizeMinSign2 == "=" && (parm.SizeMaxSign2 != "" || parm.SizeMax2 != ""))
                {
                    MessageUtil.ShowWarning("限制规格(一)下限符号为'=',不能存在上限！");
                    row.SetCellActive("SizeMax2");
                    return;
                }

                if (parm.SizeMinSign == "=" && (parm.SizeMaxSign != "" || parm.SizeMax != ""))
                {
                    MessageUtil.ShowWarning("限制规格(二)下限符号为'=',不能存在上限！");
                    row.SetCellActive("SizeMax");
                    return;
                }

                if (!parm.SpecJg.Equals("") && !parm.SpecJgDesc.Equals("-1"))
                {
                    if (!parm.SizeName2.Equals("") || !parm.SizeName.Equals(""))
                    {
                        MessageUtil.ShowWarning("接箍描述与限制规格不能同时存在！");
                        row.SetCellActive("SpecJg");
                        return;
                    }
                }

                if (!parm.SizeName2.Equals(""))
                {
                    if (parm.SizeMinSign2.Equals("") && parm.SizeMaxSign2.Equals(""))
                    {
                        MessageUtil.ShowWarning("请选择限制规格(一)下限符号或者上限符号！");
                        row.SetCellActive("SizeMinSign2");
                        return;
                    }
                    if (!parm.SizeMinSign2.Equals("") && parm.SizeMin2.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(一)下限符号，下限值不能为空！");
                        row.SetCellActive("SizeMin2");
                        return;
                    }
                    if (parm.SizeMinSign2.Equals("") && !parm.SizeMin2.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(一)下限值，下限符号不能为空！");
                        row.SetCellActive("SizeMinSign2");
                        return;
                    }
                    if (!parm.SizeMaxSign2.Equals("") && parm.SizeMax2.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(一)上限符号，上限值不能为空！");
                        row.SetCellActive("SizeMax2");
                        return;
                    }
                    if (parm.SizeMaxSign2.Equals("") && !parm.SizeMax2.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(一)上限值，上限符号不能为空！");
                        row.SetCellActive("SizeMaxSign2");
                        return;
                    }
                    if (!parm.SizeMin2.Equals("") && !StringUtil.IsNumber(parm.SizeMin2) && !parm.SizeMinSign2.Equals("="))
                    {
                        MessageUtil.ShowWarning("限制规格(一)下限值由数字组成！");
                        row.SetCellActive("SizeMin2");
                        return;
                    }
                    if (!parm.SizeMax2.Equals("") && !StringUtil.IsNumber(parm.SizeMax2))
                    {
                        MessageUtil.ShowWarning("限制规格(一)上限值由数字组成！");
                        row.SetCellActive("SizeMax2");
                        return;
                    }
                    if (!parm.SizeMin2.Equals("") && !parm.SizeMax2.Equals("")) //&& Convert.ToDouble(size_max2) < Convert.ToDouble(size_min2)
                    {
                        int i = QcmBaseInfo.CheckStdData(parm.SizeMinSign2, parm.SizeMaxSign2, parm.SizeMin2, parm.SizeMax2);
                        if (i == 0)
                        {
                            MessageUtil.ShowWarning("输入的数据不完整！");
                            return;
                        }
                        if (i == 1)
                        {
                            MessageUtil.ShowWarning("限制规格(一)下限值与上限值相等，上下限符号请选择<=和>=！");
                            row.SetCellActive("SizeMinSign2");
                            return;
                        }
                        if (i == 2)
                        {
                            MessageUtil.ShowWarning("限制规格(一)下限值不能大于上限值！");
                            row.SetCellActive("SizeMin2");
                            return;
                        }
                    }
                }
                else
                {
                    if (parm.SizeMaxSign2 != "" || parm.SizeMinSign2 != "" || parm.SizeMin2 != "" || parm.SizeMax2 != "")
                    {
                        MessageUtil.ShowWarning("限制规格(一)描述不存在！");
                        row.SetCellActive("SizeCode2");
                        return;
                    }
                }

                if (!parm.SizeMin2.Equals(""))
                {
                    if (parm.SizeMin2.StartsWith("."))
                        parm.SizeMin2 = "0" + parm.SizeMin2;
                }
                if (!parm.SizeMax2.Equals(""))
                {
                    if (parm.SizeMax2.StartsWith("."))
                        parm.SizeMax2 = "0" + parm.SizeMax2;
                }

                if (!parm.SizeName.Equals(""))
                {
                    if (parm.SizeMinSign.Equals("") && parm.SizeMaxSign.Equals(""))
                    {
                        MessageUtil.ShowWarning("限制规格(二)下限符号与上限符号必须存在一项！");
                        row.SetCellActive("SizeMinSign");
                        return;
                    }
                    if (!parm.SizeMinSign.Equals("") && parm.SizeMin.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(二)下限符号，下限值不能为空！");
                        row.SetCellActive("SizeMin");
                        return;
                    }
                    if (parm.SizeMinSign.Equals("") && !parm.SizeMin.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(二)下限值，下限符号不能为空！");
                        row.SetCellActive("SizeMinSign");
                        return;
                    }
                    if (!parm.SizeMaxSign.Equals("") && parm.SizeMax.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(二)上限符号，上限值不能为空！");
                        row.SetCellActive("SizeMax");
                        return;
                    }
                    if (parm.SizeMaxSign.Equals("") && !parm.SizeMax.Equals(""))
                    {
                        MessageUtil.ShowWarning("存在限制规格(二)上限值，上限符号不能为空！");
                        row.SetCellActive("SizeMaxSign");
                        return;
                    }
                    if (!parm.SizeMax.Equals("") && !StringUtil.IsNumber(parm.SizeMax))
                    {
                        MessageUtil.ShowWarning("限制规格(二)上限值由数字组成！");
                        row.SetCellActive("SizeMax");
                        return;
                    }
                    if (!parm.SizeMin.Equals("") && !StringUtil.IsNumber(parm.SizeMin) && !parm.SizeMinSign.Equals("="))
                    {
                        MessageUtil.ShowWarning("限制规格(二)下限值由数字组成！");
                        row.SetCellActive("SizeMin");
                        return;
                    }
                    if (!parm.SizeMin.Equals("") && !parm.SizeMax.Equals(""))  //&& Convert.ToDouble(size_max) < Convert.ToDouble(size_min)
                    {
                        int i = QcmBaseInfo.CheckStdData(parm.SizeMinSign, parm.SizeMaxSign, parm.SizeMin, parm.SizeMax);
                        if (i == 0)
                        {
                            MessageUtil.ShowWarning("输入的数据不完整！");
                            return;
                        }
                        if (i == 1)
                        {
                            MessageUtil.ShowWarning("限制规格(二)下限值与上限值相等，上下限符号请选择<=和>=！");
                            row.SetCellActive("SizeMinSign");
                            return;
                        }
                        if (i == 2)
                        {
                            MessageUtil.ShowWarning("限制规格(二)下限值不能大于上限值！");
                            row.SetCellActive("SizeMin");
                            return;
                        }
                    }
                }
                else
                {
                    if (parm.SizeMaxSign != "" || parm.SizeMinSign != "" || parm.SizeMin != "" || parm.SizeMax != "")
                    {
                        MessageUtil.ShowWarning("限制规格(二)描述不存在！");
                        row.SetCellActive("SizeCode");
                        return;
                    }
                }

                if (!parm.SizeName2.Equals("") && !parm.SizeName.Equals("") && parm.SizeName.Equals(parm.SizeName2))
                {
                    MessageUtil.ShowWarning("限制规格(一)与限制规格(二)描述不能相同！");
                    row.SetCellActive("SizeCode");
                    return;
                }
                if (!parm.SizeMax.Equals(""))
                {
                    if (parm.SizeMax.StartsWith("."))
                        parm.SizeMax = "0" + parm.SizeMax;
                }
                if (!parm.SizeMin.Equals(""))
                {
                    if (parm.SizeMin.StartsWith("."))
                        parm.SizeMin = "0" + parm.SizeMin;
                }

                if (parm.Addcondition != "")  //存在附加标准约束  
                {
                    if (parm.AddstdconCode == "")
                    {
                        MessageUtil.ShowWarning("请选择附加标准项！");
                        row.SetCellActive("AddstdconCode");
                        return;
                    }

                    if (parm.AddstdMinSign == "=" && (parm.AddstdMaxSign != "" || parm.AddstdMax != ""))
                    {
                        MessageUtil.ShowWarning("附加标准范围下限符号为'=',不能存在上限！");
                        row.SetCellActive("AddstdMax");
                        return;
                    }

                    if (parm.AddstdMinSign.Equals("") && parm.AddstdMaxSign.Equals(""))
                    {
                        MessageUtil.ShowWarning("请选择附加标准范围下限符号或者上限符号！");
                        row.SetCellActive("AddstdMinSign");
                        return;
                    }

                    if (!parm.AddstdMinSign.Equals("") && parm.AddstdMin.Equals(""))
                    {
                        MessageUtil.ShowWarning("请输入附加标准范围下限值！");
                        row.SetCellActive("AddstdMin");
                        return;
                    }
                    if (parm.AddstdMinSign.Equals("") && !parm.AddstdMin.Equals(""))
                    {
                        MessageUtil.ShowWarning("请选择附加标准范围下限符号！");
                        row.SetCellActive("AddstdMinSign");
                        return;
                    }
                    if (!parm.AddstdMinSign.Equals("") && parm.AddstdMin.Replace("Value", "1").CompileFormula() == null)
                    {
                        MessageUtil.ShowWarning("附加标准范围下限值，只能包含附加标准符号'Value'！");
                        row.SetCellActive("AddstdMin");
                        return;
                    }
                    if (!parm.AddstdMaxSign.Equals("") && parm.AddstdMax.Equals(""))
                    {
                        MessageUtil.ShowWarning("请输入附加标准范围上限值！");
                        row.SetCellActive("AddstdMax");
                        return;
                    }
                    if (!parm.AddstdMaxSign.Equals("") && parm.AddstdMax.Replace("Value", "1").CompileFormula() == null)
                    {
                        MessageUtil.ShowWarning("附加标准范围上限值，只能包含附加标准符号'Value'！");
                        row.SetCellActive("AddstdMax");
                        return;
                    }
                    if (parm.AddstdMaxSign.Equals("") && !parm.AddstdMax.Equals(""))
                    {
                        MessageUtil.ShowWarning("已有附加标准范围上限值，请选择附加标准范围上限符号！");
                        row.SetCellActive("AddstdMaxSign");
                        return;
                    }

                    if (!parm.AddstdMin.Equals(""))
                    {
                        if (parm.AddstdMin.StartsWith("."))
                            parm.AddstdMin = "0" + parm.AddstdMin;
                    }
                    if (!parm.AddstdMax.Equals(""))
                    {
                        if (parm.AddstdMax.StartsWith("."))
                            parm.AddstdMax = "0" + parm.AddstdMax;
                    }
                    if (!parm.AddstdMin.Equals("") && !parm.AddstdMax.Equals(""))//&& Convert.ToDouble(addstd_min) > Convert.ToDouble(addstd_max)
                    {
                        int i = QcmBaseInfo.CheckStdData(parm.AddstdMinSign, parm.AddstdMaxSign, parm.AddstdMin, parm.AddstdMax);
                        if (i == 0)
                        {
                            MessageUtil.ShowWarning("输入的数据不完整！");
                            return;
                        }
                        if (i == 1)
                        {
                            MessageUtil.ShowWarning("附加标准范围下限值与上限值相等，上下限符号请选择<=和>=！");
                            row.SetCellActive("AddstdMinSign");
                            return;
                        }
                        if (i == 2)
                        {
                            MessageUtil.ShowWarning("附加标准范围下限值不能大于上限值！");
                            row.SetCellActive("AddstdMin");
                            return;
                        }
                    }
                }
                
                parm.CreateName = CoreUserInfo.UserInfo.GetUserName();
                parm.UpdateName = CoreUserInfo.UserInfo.GetUserName();
                parm.DeleteName = CoreUserInfo.UserInfo.GetUserName();
                parm.SpeclFl = "2";
                parm.DesginKey = designKey;
                parms.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认保存？") == DialogResult.No)
            {
                return;
            }
            _designStdPicBLL.Save(parms);
            MessageUtil.ShowTips("保存成功！");
            QueryByDesignKeyPic(_parms);
        }

        public void Delete()
        {
            List<CraftOrdDesignStdPicEntity> parms = new List<CraftOrdDesignStdPicEntity>();
            var rows = entityGrid1.Rows.Where(a => a.GetValue("Chk") == "True");
            foreach (var row in rows)
            {
                var parm = EntityHelper.CopyEntity<CraftOrdDesignStdPicEntity>(row.ListObject);
                parm.CreateName = CoreUserInfo.UserInfo.GetUserName();
                parm.UpdateName = CoreUserInfo.UserInfo.GetUserName();
                parm.DeleteName = CoreUserInfo.UserInfo.GetUserName();
                parm.SpeclFl = "2";
                parm.DesginKey = designKey;
                parms.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认删除？") == DialogResult.No)
            {
                return;
            }
            _designStdPicBLL.Delete(parms);
            MessageUtil.ShowTips("删除成功！");
        }

        private void entityGrid1_CellChange(object sender, CellEventArgs e)
        {
            entityGrid1.UpdateData();
            var ugr = e.Cell.Row;
            string deliverystate = ugr.Cells["DELIVERYSTATE"].Value.ToString();
            ugr.Cells["SizeName2"].Value = ugr.Cells["SizeCode2"].Text;
            ugr.Cells["SizeName"].Value = ugr.Cells["SizeCode"].Text;
            ugr.Cells["SpecJgDesc"].Value = ugr.Cells["SpecJg"].Text;
            GridEdite(e.Cell.Row);
        }

        private void GridEdite(UltraGridRow row)
        {
            if (row.GetValue("Chk") == "True")
            {
                foreach (UltraGridCell cell in row.Cells)
                {
                    if (cell.Column.CellActivation == Activation.AllowEdit)
                    {
                        cell.Activation = Activation.AllowEdit;
                    }
                }
            }
            else
            {
                foreach (UltraGridCell cell in row.Cells)
                {
                    if (cell.Column.Key == "Chk") continue;
                    if (cell.Column.CellActivation == Activation.AllowEdit)
                    {
                        cell.Activation = Activation.ActivateOnly;
                    }
                }
            }
        }

        private void entityGrid1_AfterRowInsert(object sender, RowEventArgs e)
        {
            //将增加行的是否必选项置为默认选择 和 复合元素选择项置为默认不选
            e.Row.Cells["PhyType"].Value = false;
            e.Row.Cells["BilletSample"].Value = false;
            e.Row.Cells["JudgeBasis"].Value = "D";
            e.Row.Cells["IsJudge"].Value = true;
            e.Row.Cells["IsQuote"].Value = true;
            e.Row.Cells["CraftSource"].Value = "1";
            e.Row.Cells["SpeclFl"].Value = "2";

            DataRow dr = _designStdPicBLL.GetPhyMaxByPhyMin(_parms[4]);
            if (dr != null)
            {
                e.Row.Cells["PhyCodeMin"].Value = _parms[4];
                e.Row.Cells["PhyNameMin"].Value = dr["PHY_NAME_MIN"].ToString();
                e.Row.Cells["PhyCodeMax"].Value = dr["PHY_CODE_MAX"].ToString();
                e.Row.Cells["PhyNameMax"].Value = dr["PHY_NAME_MAX"].ToString();
                
            }
        }

        private void ultraTextEditor3_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow row = entityGrid1.ActiveRow;
            string key = entityGrid1.ActiveCell.Column.Key;
            if (key == "MscPline")
            {
                DataTable dt = _designMscPlBLL.QueryMscPlineProcess(designKey);
                dt.Columns["MSC_PLINE"].Caption = "制程号";
                dt.Columns["WHOLE_BACKLOG"].Caption = "全程途径码";
                dt.Columns["WHOLE_BACKLOG_DESC"].Caption = "全程途径描述";
                dt.Columns["PROCESS_DESC"].Caption = "工序";
                dt.Columns["PROCESS_DESC_C"].Caption = "二级工序";
                dt.Columns["PIC"].Caption = "理化内控索引码";

                DataTable dtNew = dt.Clone();
                foreach (DataRow dr in dt.Rows)
                {
                    string[] pics = dr["PIC"].ToString().Split(',');
                    foreach (string pic in pics)
                    {
                        DataRow drNew = dtNew.NewRow();
                        drNew["MSC_PLINE"] = dr["MSC_PLINE"];
                        drNew["WHOLE_BACKLOG"] = dr["WHOLE_BACKLOG"];
                        drNew["WHOLE_BACKLOG_DESC"] = dr["WHOLE_BACKLOG_DESC"];
                        drNew["PROCESS_DESC"] = dr["PROCESS_DESC"];
                        drNew["PROCESS_DESC_C"] = dr["PROCESS_DESC_C"];
                        drNew["PROCESS_CODE"] = dr["PROCESS_CODE"];
                        drNew["PROCESS_CODE_C"] = dr["PROCESS_CODE_C"];
                        drNew["PIC"] = pic.Trim();
                        dtNew.Rows.Add(drNew);
                    }
                }
                BaseInfoPopup popup = new BaseInfoPopup(dtNew, "MSC_PLINE", "CIC", "SIC", "DIC", "WIC", "GIC", "PROCESS_CODE", "PROCESS_CODE_C");
                GridHelper.RefreshAndAutoSize(popup.UltraGrid1);
                popup.LabelTextBox1.Caption = "制程号";
                if (popup.ShowDialog() == DialogResult.OK)
                {
                    row.SetValue("MscPline", popup.ChoicedRow.GetValue("MSC_PLINE"));
                    row.SetValue("ProcessDescC", popup.ChoicedRow.GetValue("PROCESS_DESC_C"));
                    row.SetValue("ProcessCodeC", popup.ChoicedRow.GetValue("PROCESS_CODE_C"));
                    row.SetValue("ProcessDesc", popup.ChoicedRow.GetValue("PROCESS_DESC"));
                    row.SetValue("ProcessCode", popup.ChoicedRow.GetValue("PROCESS_CODE"));
                    row.SetValue("Pic", popup.ChoicedRow.GetValue("PIC"));
                }
            }
            else if (key == "ProcessDescC")
            {
                string mscPline = entityGrid1.ActiveRow.GetValue("MscPline");
                DataTable dt = _designMscPlPrcBLL.queryProcess(designKey, mscPline);
                dt.Columns["PROCESS_DESC"].Caption = "工序";
                dt.Columns["PROCESS_DESC_C"].Caption = "二级工序";
                BaseInfoPopup popup = new BaseInfoPopup(dt, "PROCESS_DESC_C", "PROCESS_CODE", "PROCESS_CODE_C");
                popup.LabelTextBox1.Caption = "二级工序";
                if (popup.ShowDialog() == DialogResult.OK)
                {
                    row.SetValue("ProcessDescC", popup.ChoicedRow.GetValue("PROCESS_DESC_C"));
                    row.SetValue("ProcessCodeC", popup.ChoicedRow.GetValue("PROCESS_CODE_C"));
                    row.SetValue("ProcessDesc", popup.ChoicedRow.GetValue("PROCESS_DESC"));
                    row.SetValue("ProcessCode", popup.ChoicedRow.GetValue("PROCESS_CODE"));
                }
            }
            else if (key == "Pic")
            {
                string mscPline = entityGrid1.ActiveRow.GetValue("MscPline");
                string processCode = entityGrid1.ActiveRow.GetValue("ProcessCode");
                DataTable dt = _designMscPlPrcBLL.queryProcessNkIndex(designKey, mscPline, processCode);
                dt.Columns["PIC"].Caption = "理化内控索引码";
                BaseInfoPopup popup = new BaseInfoPopup(dt, "PIC", "CIC", "SIC", "DIC", "WIC", "GIC");
                popup.LabelTextBox1.Caption = "理化内控索引码";
                if (popup.ShowDialog() == DialogResult.OK)
                {
                    row.SetValue("Pic", popup.ChoicedRow.GetValue("PIC"));
                }
            }
            else if (entityGrid1.ActiveCell.Column.Key == "PhyNameMax")
            {
                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") == entityGrid1.ActiveRow.GetValue("PhyCodeMax"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });

                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    entityGrid1.ActiveRow.SetValue("PhyNameMax", baseInfoPopup.ChoicedRow.GetValue("PHY_TYPE"));
                    entityGrid1.ActiveRow.SetValue("PhyCodeMax", baseInfoPopup.ChoicedRow.GetValue("PHY_CODE"));
                    entityGrid1.ActiveRow.SetValue("PhyNameMin", "");
                    entityGrid1.ActiveRow.SetValue("PhyCodeMin", "");
                    entityGrid1.ActiveRow.SetValue("PhyName", "");
                    entityGrid1.ActiveRow.SetValue("PhyCode", "");
                    entityGrid1.ActiveRow.SetValue("ItemNameF", "");
                    entityGrid1.ActiveRow.SetValue("ItemCodeF", "");
                    entityGrid1.ActiveRow.SetValue("ItemNameS", "");
                    entityGrid1.ActiveRow.SetValue("ItemCodeS", "");
                    entityGrid1.ActiveRow.SetValue("ItemNameW", "");
                    entityGrid1.ActiveRow.SetValue("ItemCodeW", "");
                }
            }
            else if (entityGrid1.ActiveCell.Column.Key == "PhyNameMin")
            {
                string phyCodeMax = entityGrid1.ActiveRow.GetValue("PhyCodeMax");
                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") == entityGrid1.ActiveRow.GetValue("PhyCodeMin"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    entityGrid1.ActiveRow.SetValue("PhyNameMin", baseInfoPopup.ChoicedRow.GetValue("PHY_TYPE"));
                    entityGrid1.ActiveRow.SetValue("PhyCodeMin", baseInfoPopup.ChoicedRow.GetValue("PHY_CODE"));
                    entityGrid1.ActiveRow.SetValue("PhyName", "");
                    entityGrid1.ActiveRow.SetValue("PhyCode", "");
                    entityGrid1.ActiveRow.SetValue("ItemNameF", "");
                    entityGrid1.ActiveRow.SetValue("ItemCodeF", "");
                    entityGrid1.ActiveRow.SetValue("ItemNameS", "");
                    entityGrid1.ActiveRow.SetValue("ItemCodeS", "");
                    entityGrid1.ActiveRow.SetValue("ItemNameW", "");
                    entityGrid1.ActiveRow.SetValue("ItemCodeW", "");
                }
            }
            else if (entityGrid1.ActiveCell.Column.Key == "PhyName")
            {
                string phyCodeMax = entityGrid1.ActiveRow.GetValue("PhyCodeMax");
                string phyCodeMin = entityGrid1.ActiveRow.GetValue("PhyCodeMin");
                if (phyCodeMax == "")
                {
                    MessageUtil.ShowWarning("请选择检验大项");
                    entityGrid1.ActiveRow.Cells["PhyNameMax"].Activate();
                    return;
                }
                else if (phyCodeMin == "")
                {
                    MessageUtil.ShowWarning("请选择试样组");
                    entityGrid1.ActiveRow.Cells["PhyNameMin"].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") == entityGrid1.ActiveRow.GetValue("PhyCode"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    entityGrid1.ActiveRow.SetValue("PhyName", baseInfoPopup.ChoicedRow.GetValue("PHY_NAME"));
                    entityGrid1.ActiveRow.SetValue("PhyCode", baseInfoPopup.ChoicedRow.GetValue("PHY_CODE"));
                    entityGrid1.ActiveRow.SetValue("ItemNameW", "");
                    entityGrid1.ActiveRow.SetValue("ItemCodeW", "");
                }
            }
            else if (entityGrid1.ActiveCell.Column.Key == "ItemNameF")
            {
                string phyTypeC = entityGrid1.ActiveRow.GetValue("PhyCodeMin");
                if (phyTypeC == "")
                {
                    MessageUtil.ShowWarning("请选择试样组");
                    entityGrid1.ActiveRow.Cells["PhyNameMin"].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 = "试验尺寸";
                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") == entityGrid1.ActiveRow.GetValue("ItemCodeF")
                        && a.GetValue("ITEM_CODE_C") == entityGrid1.ActiveRow.GetValue("ItemCodeS"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    entityGrid1.ActiveRow.SetValue("ItemNameF", baseInfoPopup.ChoicedRow.GetValue("ITEM_NAME_F"));
                    entityGrid1.ActiveRow.SetValue("ItemCodeF", baseInfoPopup.ChoicedRow.GetValue("ITEM_CODE_F"));
                    entityGrid1.ActiveRow.SetValue("ItemNameS", baseInfoPopup.ChoicedRow.GetValue("ITEM_NAME_C"));
                    entityGrid1.ActiveRow.SetValue("ItemCodeS", baseInfoPopup.ChoicedRow.GetValue("ITEM_CODE_C"));
                }
            }
            else if (entityGrid1.ActiveCell.Column.Key == "ItemNameW")
            {
                string phyCode = entityGrid1.ActiveRow.GetValue("PhyCode");
                if (phyCode == "")
                {
                    MessageUtil.ShowWarning("请选择检验项");
                    entityGrid1.ActiveRow.Cells["PhyName"].Activate();
                    return;
                }
                DataTable dt = ServerHelper.GetData("com.steering.pss.qcm.ComBaseQuery.geComBasePhyRPos",
                    new object[] { phyCode }, _ob);
                dt.Columns["ITEM_NAME_W"].Caption = "试验温度";
                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") == entityGrid1.ActiveRow.GetValue("ItemCodeW"));
                    if (rows.Count() > 0)
                    {
                        rows.First().Activate();
                    }
                });
                if (baseInfoPopup.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                {
                    entityGrid1.ActiveRow.SetValue("ItemNameW", baseInfoPopup.ChoicedRow.GetValue("ITEM_NAME_W"));
                    entityGrid1.ActiveRow.SetValue("ItemCodeW", baseInfoPopup.ChoicedRow.GetValue("ITEM_CODE_W"));
                }
            }
        }
    }
}