MES_Client/TGMES/Core.StlMes.Client.Judge/Controls/QcmZgChemPhyCtrl.cs

using Core.StlMes.Client.Judge.Commons;
using Core.StlMes.Client.Judge.Models;
using CoreFS.CA06;
using Infragistics.Win.UltraWinTabControl;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Windows.Forms;

namespace Core.StlMes.Client.Judge.Controls
{
    public partial class QcmZgChemPhyCtrl : UserControl
    {
        private QcmJhyPhyResultCtrl _jhyPhyResultCtrl;

        public QcmJhyPhyResultCtrl JhyPhyResultCtrl
        {
            get { return _jhyPhyResultCtrl; }
            set { _jhyPhyResultCtrl = value; }
        }
        private QcmJhyPhySplineCtrl _jhyPhySplineCtrl;

        public QcmJhyPhySplineCtrl JhyPhySplineCtrl
        {
            get { return _jhyPhySplineCtrl; }
            set { _jhyPhySplineCtrl = value; }
        }

        private QcmJhyElementsCtrl _jhyElementsCtrl;

        public QcmJhyElementsCtrl JhyElementsCtrl
        {
            get { return _jhyElementsCtrl; }
            set { _jhyElementsCtrl = value; }
        }

        private Dal _d;
        //private FaceFileCtrl _faceFileCtrl;
        private DetectInfoCtrl _detectInfoCtrl;
        private CraftOrdDesignStdDicCtrl _stdDicCtrl;
        private SpecInfoCtrl _specInfoCtrl;
        private WaterInfoCtrl _waterInfoCtrl;
        private CraftOrdDesignStdWicCtrl _stdWicCtrl;
        private ProcessInfoNewCtrl _processInfoCtrl;
        private ProcessInfoCtrl _processInfoOldCtrl;
        private QcmPhyRclInfo _phyRclInfoCtrl;
        private TwistinglyInfoCtrl _twistinglyInfoCtrl;
        private PassInfoCtrl _passInfoCtrl;
        private PipeCheckConsignPhySscCtrl _pipePhyCtrl;
        private PathInfoCtrl _pathInfoCtrl;
        private ThreaderInfoCtrl _threaderInfoCtrl;
        private HreadInfoCtrl _hreadInfoCtrl;
        private MeasureInfoCtrl _measureInfoCtrl;
        private BundlingInfoCtrl _bundlingInfoCtrl;
        private ChamferingInfoCtrl _chamferingInfoCtrl;
        private FinalCheckInfoCtrl _finalCheckInfoCtrl;
        private FaceInfoCtrl _faceInfoCtrl;
        private CouplingInspectionInfoCtrl _inspectionInfoCtrl;
        private CouplingPhosphateInfoCtrl _phospateInfoCtrl;
        private CouplingPressInfoCtrl _pressInfoCtrl;
        private CouplingSandBlastInfoCtrl _sandBlastInfoCtrl;
        private CouplingThinspectInfoCtrl _thinspectInfoCtrl;
        private CouplingProductionCtrl _productionInfoCtrl;
        private CouplingRemanenceCtrl _remanenceCtrl;
        private bool _showProcess = false;
        private string _frmFlag = "";
        private string _processCode = "";

        public QcmZgChemPhyCtrl(Control container, OpeBase ob, bool showProcess, string frmFlag, string processCode)
        {
            InitializeComponent();
            _frmFlag = frmFlag;
            _showProcess = showProcess;
            _processCode = processCode;
            _d = new Dal(ob);
            _jhyPhySplineCtrl = new QcmJhyPhySplineCtrl(frmFlag, "phy", splitContainer1.Panel1, ob);
            _jhyPhySplineCtrl.Dock = DockStyle.Fill;
            _jhyPhySplineCtrl.UltraGrid1.AfterRowActivate += jhyPhySplineCtrl_AfterRowActivate;
            if (_processCode != "F" && frmFlag != "zc")
            {
                _jhyPhySplineCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["lotNoGroup"].Hidden = true;
            }
            _jhyPhyResultCtrl = new QcmJhyPhyResultCtrl(splitContainer1.Panel2, ob, showProcess);
            _jhyElementsCtrl = new QcmJhyElementsCtrl(splitContainer1.Panel2, ob, showProcess);

            container.Controls.Add(this);
            this.Dock = DockStyle.Fill;
            _faceInfoCtrl = new FaceInfoCtrl(ultraTabPageControl9, ob, processCode);
            _detectInfoCtrl = new DetectInfoCtrl(ultraTabPageControl8, ob, processCode);
            _detectInfoCtrl.Height = 170;
            _detectInfoCtrl.Dock = DockStyle.Top;
            _stdDicCtrl = new CraftOrdDesignStdDicCtrl(ultraTabPageControl8, ob);
            _specInfoCtrl = new SpecInfoCtrl(ultraTabPageControl10, ob, showProcess, _processCode);
            _waterInfoCtrl = new WaterInfoCtrl(ultraTabPageControl11, ob, showProcess);
            _waterInfoCtrl.Dock = DockStyle.Top;
            _waterInfoCtrl.Height = 170;
            _stdWicCtrl = new CraftOrdDesignStdWicCtrl(ultraTabPageControl11, ob);
            _processInfoCtrl = new ProcessInfoNewCtrl(ultraTabPageControl12, ob, _processCode);
            _processInfoOldCtrl = new ProcessInfoCtrl(ultraTabPageControl29, ob, showProcess);
            _twistinglyInfoCtrl = new TwistinglyInfoCtrl(ultraTabPageControl14, ob);
            _passInfoCtrl = new PassInfoCtrl(ultraTabPageControl15, ob);
            _pipePhyCtrl = new PipeCheckConsignPhySscCtrl(ultraTabPageControl16, ob);
            _pathInfoCtrl = new PathInfoCtrl(ultraTabPageControl20, ob);
            _threaderInfoCtrl = new ThreaderInfoCtrl(ultraTabPageControl21, ob);
            _hreadInfoCtrl = new HreadInfoCtrl(ultraTabPageControl22, ob);
            _measureInfoCtrl = new MeasureInfoCtrl(ultraTabPageControl23, ob);
            _bundlingInfoCtrl = new BundlingInfoCtrl(ultraTabPageControl24, ob);
            _chamferingInfoCtrl = new ChamferingInfoCtrl(ultraTabPageControl25, ob);
            _finalCheckInfoCtrl = new FinalCheckInfoCtrl(ultraTabPageControl17, ob);
            _inspectionInfoCtrl = new CouplingInspectionInfoCtrl(ultraTabPageControl18, ob);
            _phospateInfoCtrl = new CouplingPhosphateInfoCtrl(ultraTabPageControl19, ob);
            _pressInfoCtrl = new CouplingPressInfoCtrl(ultraTabPageControl26, ob);
            _sandBlastInfoCtrl = new CouplingSandBlastInfoCtrl(ultraTabPageControl27, ob);
            _thinspectInfoCtrl = new CouplingThinspectInfoCtrl(ultraTabPageControl28, ob);
            _productionInfoCtrl = new CouplingProductionCtrl(ultraTabPageControl30, ob);
            _remanenceCtrl = new CouplingRemanenceCtrl(ultraTabPageControl31, ob);
            _phyRclInfoCtrl = new QcmPhyRclInfo(ob);
            this.ultraTabPageControl13.Controls.Add(_phyRclInfoCtrl);
            _phyRclInfoCtrl.Dock = DockStyle.Fill;

            //绑定科室中的控件
            BindPhyItem();
        }

        void jhyPhySplineCtrl_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                this.Cursor = Cursors.WaitCursor;
                switch (ultraTabControl2.ActiveTab.Key)
                {
                    case "phy":
                        string ordLnPk = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("ordLnPk");
                        string ordLnDlyPk = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("ordLnDlyPk");
                        string craftSeq = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("craftSeq");
                        string mscPline = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("mscPline");
                        string phyCodeMin = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("phyCodeMin");
                        string sampleId = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("sampleId");
                        string sampleNo = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("sampleNo");
                        string judgeStoveNo = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("judgeStoveNo");
                        string batchNo = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("batchNo");
                        string pic = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("pic");
                        string lotNo = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("lotNo");
                        string stoveNo = _jhyPhySplineCtrl.UltraGrid1.GetActiveRowValue("stoveNo");
                        var row = _jhyPhySplineCtrl.UltraGrid1.ActiveRow;
                        string craftSource = row.GetValue("craftSource");
                        if (pic.StartsWith("PIC"))
                        {
                            // 理化实绩查询检验项
                            _jhyPhyResultCtrl.QueryByBatchNo(lotNo, judgeStoveNo, batchNo, ordLnPk, ordLnDlyPk, craftSeq,
                                       mscPline, _processCode, pic, phyCodeMin, sampleId, sampleNo, craftSource, stoveNo);
                            _jhyPhyResultCtrl.BringToFront();
                        }
                        else
                        {
                            _jhyElementsCtrl.QueryCraftResultByBatchNo(stoveNo, judgeStoveNo, batchNo, ordLnPk, ordLnDlyPk, craftSeq, mscPline,
                                _processCode, pic, sampleId, sampleNo, craftSource);
                            _jhyElementsCtrl.BringToFront();
                        }
                        break;
                    default:
                        DataTable dtPhy = _d.GetTableByXmlId("JdgComBasePhyB.getPhyCodeByDept", ultraTabControl2.ActiveTab.Key);

                        string[] phys = dtPhy.Rows.Cast<DataRow>().Select(a => a["phyCode"].ToString()).ToArray();
                        UltraTabPageControl page = (UltraTabPageControl)ultraTabControl2.ActiveTab.TabPage;
                        if (page.Controls.Count > 0)
                        {
                            QcmJhyPhySplineCtrl splineCtrl = (QcmJhyPhySplineCtrl)((SplitContainer)page.Controls[0]).Panel1.Controls[0];
                            if (splineCtrl.UltraGrid1.ActiveRow != null)
                            {
                                string ordLnPk2 = splineCtrl.UltraGrid1.GetActiveRowValue("ordLnPk");
                                string ordLnDlyPk2 = splineCtrl.UltraGrid1.GetActiveRowValue("ordLnDlyPk");
                                string craftSeq2 = splineCtrl.UltraGrid1.GetActiveRowValue("craftSeq");
                                string mscPline2 = splineCtrl.UltraGrid1.GetActiveRowValue("mscPline");
                                string phyCodeMin2 = splineCtrl.UltraGrid1.GetActiveRowValue("phyCodeMin");
                                string sampleNo2 = splineCtrl.UltraGrid1.GetActiveRowValue("sampleNo");
                                string sampleId2 = splineCtrl.UltraGrid1.GetActiveRowValue("sampleId");
                                string lotNo2 = splineCtrl.UltraGrid1.GetActiveRowValue("lotNo");
                                string judgeStoveNo2 = splineCtrl.UltraGrid1.GetActiveRowValue("judgeStoveNo");
                                string batchNo2 = splineCtrl.UltraGrid1.GetActiveRowValue("batchNo");
                                string pic2 = splineCtrl.UltraGrid1.GetActiveRowValue("pic");
                                string craftSource2 = splineCtrl.UltraGrid1.GetActiveRowValue("craftSource");
                                string stoveNo2 = splineCtrl.UltraGrid1.GetActiveRowValue("stoveNo");
                                if (ultraTabControl2.ActiveTab.Key == "002001007010")
                                {
                                    QcmJhyElementsCtrl chemResultCtrl = (QcmJhyElementsCtrl)((SplitContainer)page.Controls[0]).Panel2.Controls[0];
                                    chemResultCtrl.QueryCraftResultByBatchNo(stoveNo2, judgeStoveNo2, batchNo2, ordLnPk2, ordLnDlyPk2, craftSeq2, mscPline2, _processCode,
                                                                           pic2, sampleId2, sampleNo2, craftSource2);
                                }
                                else
                                {
                                    QcmJhyPhyResultCtrl phyResultCtrl = (QcmJhyPhyResultCtrl)((SplitContainer)page.Controls[0]).Panel2.Controls[0];
                                    phyResultCtrl.QueryByBatchNo(lotNo2, judgeStoveNo2, batchNo2, ordLnPk2, ordLnDlyPk2, craftSeq2,
                                        mscPline2, _processCode, pic2, phyCodeMin2, sampleId2, sampleNo2, craftSource2, stoveNo2);
                                }
                                PhyFileCtrl phyFileCtrl = (PhyFileCtrl)((SplitContainer)page.Controls[0]).Panel1.Controls[1];
                                phyFileCtrl.Query(sampleId2, ultraTabControl2.ActiveTab.Key);
                            }
                        }
                        break;
                }
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        private void BindPhyItem()
        {
            //for (int i = ultraTabControl2.Tabs.Count - 1; i > 0; i--)
            //{
            //    if (ultraTabControl2.Tabs[i].Text.Contains("判定")) continue;
            //    ultraTabControl1.Tabs.Remove(ultraTabControl1.Tabs[i]);
            //}
            foreach (var tab in ultraTabControl2.Tabs)
            {
                if (tab.Key == "phy") continue;
                if (tab.Key == "002001007010")
                {
                    //SplitContainer split = new SplitContainer();
                    //tab.TabPage.Controls.Add(split);
                    //split.Dock = DockStyle.Fill;
                    //split.Orientation = Orientation.Horizontal;
                    //split.SplitterDistance = 70;
                    //split.FixedPanel = FixedPanel.Panel1;
                    //_jhyElementsCtrl = new QcmJhyElementsCtrl(split.Panel2, _d.Ob, false);
                    //ChemFileCtrl phyFileCtrl = new ChemFileCtrl(split.Panel1, _d.Ob, false);
                    //phyFileCtrl.Dock = DockStyle.Fill;
                    //phyFileCtrl.SendToBack();
                    //phyFileCtrl.Name = "phyFileCtrl";
                    SplitContainer split = new SplitContainer();
                    tab.TabPage.Controls.Add(split);
                    split.Dock = DockStyle.Fill;
                    split.Orientation = Orientation.Horizontal;
                    split.SplitterDistance = 160;
                    split.FixedPanel = FixedPanel.Panel1;
                    PhyFileCtrl chemFileCtrl = new PhyFileCtrl(split.Panel1, _d.Ob);
                    chemFileCtrl.Dock = DockStyle.Right;
                    chemFileCtrl.Width = 400;

                    QcmJhyPhySplineCtrl jhyPhySplineCtrl = new QcmJhyPhySplineCtrl(_frmFlag, tab.Key, split.Panel1, _d.Ob);
                    jhyPhySplineCtrl.Dock = DockStyle.Fill;
                    jhyPhySplineCtrl.UltraGrid1.AfterRowActivate += jhyPhySplineCtrl_AfterRowActivate;
                    if (_processCode != "F" && _frmFlag != "zc")
                    {
                        jhyPhySplineCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["lotNoGroup"].Hidden = true;
                    }
                    jhyPhySplineCtrl.BringToFront();

                    QcmJhyElementsCtrl jhyElementsCtrl = new QcmJhyElementsCtrl(split.Panel2, _d.Ob, _showProcess);
                }
                else
                {
                    if (tab.Key == "detec" || tab.Key == "face" || tab.Key == "spec" || tab.Key == "water" || tab.Key == "process" || tab.Key == "processOld" || tab.Key == "twistingly"
                       || tab.Key == "rclInfo" || tab.Key == "passInfo" || tab.Key == "ssc" || tab.Key == "applyDetail" || tab.Key == "bcPassFlow"
                       || tab.Key == "zcPassFlow") return;
                    SplitContainer split = new SplitContainer();
                    //Panel panel = new Panel();
                    tab.TabPage.Controls.Add(split);
                    //panel.Dock = DockStyle.Top;
                    //panel.Height = 100;
                    split.Dock = DockStyle.Fill;
                    split.Orientation = Orientation.Horizontal;
                    split.SplitterDistance = 160;
                    split.FixedPanel = FixedPanel.Panel1;
                    PhyFileCtrl phyFileCtrl = new PhyFileCtrl(split.Panel1, _d.Ob);
                    phyFileCtrl.Dock = DockStyle.Right;
                    phyFileCtrl.Name = "phyFileCtrl";
                    phyFileCtrl.Width = 300;

                    QcmJhyPhySplineCtrl jhyPhySplineCtrl = new QcmJhyPhySplineCtrl(_frmFlag, tab.Key, split.Panel1, _d.Ob);
                    jhyPhySplineCtrl.Dock = DockStyle.Fill;
                    jhyPhySplineCtrl.UltraGrid1.AfterRowActivate += jhyPhySplineCtrl_AfterRowActivate;
                    if (_processCode != "F" && _frmFlag != "zc")
                    {
                        jhyPhySplineCtrl.UltraGrid1.DisplayLayout.Bands[0].Columns["lotNoGroup"].Hidden = true;
                    }
                    jhyPhySplineCtrl.BringToFront();

                    QcmJhyPhyResultCtrl jhyPhyResultCtrl = new QcmJhyPhyResultCtrl(split.Panel2, _d.Ob, false);
                    jhyPhyResultCtrl.Name = "jhyPhyResultCtrl";
                }
            }
        }

        private List<QcmZgChemPhyCtrlQueryParm> _parms = new List<QcmZgChemPhyCtrlQueryParm>();
        private bool _isLgQuery = false;
        private List<DataRow> _applys = null;
        private DataRow _zcApply = null;
        private string _passApplyNo = "";
        private string _phyProcess = "";

        public void QueryLg(List<DataRow> applys, DataRow zcApply, string phyProcess, string passApplyNo)
        {
            _isLgQuery = true;
            _applys = applys;
            _zcApply = zcApply;
            _passApplyNo = passApplyNo;
            _phyProcess = phyProcess;
            ClearData(false);
            ClearTabTag();
            _parms = new List<QcmZgChemPhyCtrlQueryParm>();
            for (int i = 0; i < applys.Count; i++)
            {
                DataRow apply = applys[i];
                GetLgParm(apply, zcApply, phyProcess, passApplyNo, false);
                //if (apply["ordLnDlyPk"].ToString().StartsWith("ZZB") && _frmFlag == "zc")
                //{
                //    parm = GetLgParm(apply, apply, phyProcess, passApplyNo, false);
                //}
                //else
                //{

                //}
            }
            SetTabTag();

            foreach (QcmZgChemPhyCtrlQueryParm parm in _parms)
            {
                QueryLg(parm);
            }
        }

        private QcmZgChemPhyCtrlQueryParm GetLgParm(DataRow apply, DataRow zcApply, string phyProcess, string passApplyNo, bool clearData)
        {
            QcmZgChemPhyCtrlQueryParm p = new QcmZgChemPhyCtrlQueryParm();
            p.phyProcess = phyProcess;
            p.passApplyNo = passApplyNo;
            p.clearData = clearData;
            p.ordLnDlyPk = apply["ordLnDlyPk"].ToString();
            p.craftSeq = apply["craftSeq"].ToString();
            p.mscPline = apply["indexSeq"].ToString();
            p.processCode = apply["processCode"].ToString();
            p.pic = apply["pic"].ToString();
            p.cic = apply["cic"].ToString();
            JudgeCraftParam cp = GetCraftParam(apply, zcApply, _d);
            p.ordLnPk = cp.OrdLnPk;
            p.craftSeq = cp.CraftSeq;
            p.mscPline = cp.MscPline;
            p.cic = cp.Cic;
            p.pic = cp.Pic;
            p.judgeStoveNo = apply["judgeStoveNo"].ToString();
            p.batchNo = apply["batchNo"].ToString();
            p.stoveNo = zcApply == null ? apply["stoveNo"].ToString() : zcApply["stoveNo"].ToString();
            p.applyCode = apply["jugdeApplyCode"].ToString();
            //p.upHeatPlanNo = apply["upperHeatplanId"].ToString();
            foreach (UltraTab tab in ultraTabControl2.Tabs)
            {
                if (tab.Key == "phy" || tab.Key == "face" || tab.Key == "applyDetail" || tab.Key == "zcPassFlow")
                {
                    tab.Tag = "True";
                }
            }
            if (ultraTabControl2.ActiveTab == null) return p;
            //DataRow zgApply = GetZgJudgeApply(applyCode, judgeStoveNo, batchNo, processCode, upHeatPlanNo, phyProcess);
            //if (zgApply == null)
            //{
            //    return p;
            //}
            //p.apply = zgApply;
            p.zcApply = zcApply;
            p.zcIsAllScrap = zcApply == null ? "" : zcApply["isAllScrap"].ToString();
            p.zcApplayCode = zcApply == null ? "" : zcApply["jugdeApplyCode"].ToString();
            p.zcJudgeStoveNo = zcApply == null ? "" : zcApply["judgeStoveNo"].ToString();
            p.zcBatchNo = zcApply == null ? "" : zcApply["batchNo"].ToString();
            p.lgJudgeStoveNo = QcmJhyPhySplineCtrl.GetLgJudgeStoveNo(apply["loadJudgeStoveNo"].ToString(), _d.Ob);
            DataRow drGpApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryGpApplyByJudgeStoveNo2", p.lgJudgeStoveNo);
            if (drGpApply != null)
            {
                if (drGpApply["auditResult"].ToString() != "" && drGpApply["auditResult"].ToString() != "407501")
                {
                    //ultraTabControl2.Tabs["passInfo"].Visible = true;
                    ultraTabControl2.Tabs["passInfo"].Tag = "True";
                }
                else
                {
                    //ultraTabControl2.Tabs["passInfo"].Visible = false;
                }
            }
            else
            {
                //ultraTabControl2.Tabs["passInfo"].Visible = false;
            }

            _parms.Add(p);
            return p;
        }

        private void QueryLg(QcmZgChemPhyCtrlQueryParm p)
        {
            //List<string[]> zpStoveBatchNos = new List<string[]>();
            //if (apply != null && apply["zpMLh"].ToString() != "")
            //{
            //    zpStoveBatchNos = getZpJudgeStoveNoM(processCode, judgeStoveNo);
            //}
            if (ultraTabControl2.ActiveTab == null) return;
            switch (ultraTabControl2.ActiveTab.Key)
            {
                case "phy":
                    //_jhyPhyResultCtrl.ClearData();
                    //_jhyElementsCtrl.ClearData();
                    _jhyPhySplineCtrl.QueryLg(p.ordLnPk, p.ordLnDlyPk, p.craftSeq, p.mscPline, p.stoveNo, p.lgJudgeStoveNo, p.cic, p.zcApplayCode,
                        p.zcJudgeStoveNo, p.zcBatchNo, p.zcIsAllScrap, p.clearData);
                    break;
                case "face":
                    _faceInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.zpMLh);
                    break;
                case "passInfo":
                    _passInfoCtrl.QueryLg(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "002001007010":
                    QcmJhyElementsCtrl jhyElemetCtrl = (QcmJhyElementsCtrl)((SplitContainer)ultraTabControl2.ActiveTab.TabPage.Controls[0]).Panel2.Controls[0];
                    jhyElemetCtrl.ClearData();
                    QcmJhyPhySplineCtrl jhyPhySplineCtrl2 = (QcmJhyPhySplineCtrl)((SplitContainer)ultraTabControl2.ActiveTab.TabPage.Controls[0]).Panel1.Controls[0];
                    jhyPhySplineCtrl2.ClearData();
                    jhyPhySplineCtrl2.QueryLg(p.ordLnPk, p.ordLnDlyPk, p.craftSeq, p.mscPline, p.stoveNo, p.lgJudgeStoveNo, p.cic, p.zcApplayCode,
                        p.zcJudgeStoveNo, p.zcBatchNo, p.zcIsAllScrap, p.clearData);
                    break;
            }
        }

        private DataRow GetZgJudgeApply(string judgeApplyCode, string judgeStoveNo, string batchNo, string processCode, string heatPlanNo, string phyProcess)
        {
            DataRow drApply = null;
            if (judgeApplyCode == "")
            {
                drApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo2", judgeStoveNo, batchNo, processCode, heatPlanNo);
            }
            else
            {
                drApply = _d.GetRowByXmlId("QcmZgJugdeApplyDAL.QueryByBatchNo", judgeApplyCode, judgeStoveNo, batchNo);
            }

            if (processCode.ToCharArray()[0] <= 'D')
            {
                return drApply;
            }
            else
            {
                string loadJudgeStoveNo = "";
                string loadBatchNo = "";
                string upHeatPlanNo = "";
                if (drApply == null)
                {
                    loadJudgeStoveNo = judgeStoveNo;
                    loadBatchNo = batchNo;
                    upHeatPlanNo = heatPlanNo;
                }
                else
                {
                    loadJudgeStoveNo = drApply["loadJudgeStoveNo"].ToString();
                    loadBatchNo = drApply["loadBatchNo"].ToString();
                    upHeatPlanNo = drApply["upperHeatplanId"].ToString();
                }
                char cProcessCode = (char)(processCode.ToCharArray()[0] - 1);
                return GetZgJudgeApply("", loadJudgeStoveNo, loadBatchNo, cProcessCode.ToString(), upHeatPlanNo, phyProcess);
            }
        }

        public void QueryZc(List<DataRow> applys, DataRow zcApply, string passApplyNo)
        {
            _isLgQuery = false;
            _applys = applys;
            _zcApply = zcApply;
            _passApplyNo = passApplyNo;
            ClearData(false);
            ClearTabTag();
            _parms = new List<QcmZgChemPhyCtrlQueryParm>();
            for (int i = 0; i < applys.Count; i++)
            {
                DataRow apply = applys[i];
                GetParm(null, apply, zcApply, passApplyNo, false);
            }
            SetTabTag();

            foreach (QcmZgChemPhyCtrlQueryParm parm in _parms)
            {
                Query(parm);
            }
        }

        public QcmZgChemPhyCtrlQueryParm GetParm(DataTable consign, DataRow apply, DataRow zcApply, string passApplyNo, bool clearData)
        {
            if (clearData)
            {
                _parms.Clear();
            }
            QcmZgChemPhyCtrlQueryParm p = new QcmZgChemPhyCtrlQueryParm();
            p.zcApply = zcApply;
            p.consing = consign;
            p.apply = apply;
            p.passApplyNo = passApplyNo;
            p.clearData = clearData;

            DataRow dataRow = null;
            if (apply != null)
            {
                dataRow = apply;
            }
            else
            {
                dataRow = consign.Rows[0];
            }

            //if (dataRow != null && dataRow["ordLnDlyPk"].ToString().StartsWith("ZZB"))
            //{
            //    DataRow drPlnSaleOrd = _d.GetRowByXmlId("JdgPlnSaleOrd.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
            //    p.ordLnPk = drPlnSaleOrd["ordLnPk"].ToString();
            //    p.proOrdLnPk = drPlnSaleOrd["ordLnPk"].ToString();
            //}
            //else
            //{
            //    if (zcApply != null && zcApply["isAllScrap"].ToString() == "4")
            //    {
            //        DataRow drPlnSaleOrd = _d.GetRowByXmlId("JdgSlmOrderLineDelivery.getOrdLnPkByDlyPk", zcApply["ordLnDlyPk"].ToString());
            //        p.ordLnPk = drPlnSaleOrd["ordLnPk"].ToString();
            //    }
            //    else
            //    {
            //        DataRow drPlnSaleOrd = _d.GetRowByXmlId("JdgPlnSaleOrd.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
            //        if (drPlnSaleOrd == null) return p;
            //        p.ordLnPk = drPlnSaleOrd["ordLnPk"].ToString();
            //    }
            //    DataRow drPlnSaleOrd2 = _d.GetRowByXmlId("JdgSlmOrderLineDelivery.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
            //    p.proOrdLnPk = drPlnSaleOrd2["ordLnPk"].ToString();
            //}

            //if (apply != null && apply["isAllScrap"].ToString() == "4")
            //{
            //    DataRow drPlnSaleOrd2 = _d.GetRowByXmlId("JdgSlmOrderLineDelivery.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
            //    p.proOrdLnPk = drPlnSaleOrd2["ordLnPk"].ToString();
            //}
            //else
            //{
            //    DataRow drPlnSaleOrd2 = _d.GetRowByXmlId("JdgPlnSaleOrd.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
            //    p.proOrdLnPk = drPlnSaleOrd2["ordLnPk"].ToString();
            //}

            p.ordLnDlyPk = dataRow["ordLnDlyPk"].ToString();
            p.craftSeq = dataRow["craftSeq"].ToString();
            p.mscPline = dataRow["indexSeq"].ToString();
            p.processCode = dataRow["processCode"].ToString();
            p.pic = dataRow["pic"].ToString();
            p.cic = dataRow["cic"].ToString();
            p.dic = apply == null ? "" : apply["dic"].ToString();
            p.wic = apply == null ? "" : apply["wic"].ToString();
            p.sic = apply == null ? "" : apply["sic"].ToString();
            p.zcIsAllScrap = zcApply == null ? "" : zcApply["isAllScrap"].ToString();
            p.zcApplayCode = zcApply == null ? "" : zcApply["jugdeApplyCode"].ToString();
            p.zcJudgeStoveNo = zcApply == null ? "" : zcApply["judgeStoveNo"].ToString();
            p.zcBatchNo = zcApply == null ? "" : zcApply["batchNo"].ToString();

            JudgeCraftParam cp = GetCraftParam(dataRow, zcApply, _d);
            p.ordLnPk = cp.OrdLnPk;
            p.craftSeq = cp.CraftSeq;
            p.mscPline = cp.MscPline;
            p.cic = cp.Cic;
            p.pic = cp.Pic;
            p.proOrdLnPk = dataRow["proOrdLnDlyPk"].ToString() == ""? "": getOrdLnPkByDlyPk(dataRow["proOrdLnDlyPk"].ToString(), _d);

            p.steelStanard = dataRow["steelStandrad"].ToString();
            p.judgeStoveNo = dataRow["judgeStoveNo"].ToString();
            p.batchNo = dataRow["batchNo"].ToString();
            p.lotNo = dataRow["lotNo"].ToString();
            p.lotNoGroup = dataRow["lotNoGroup"].ToString();
            p.stoveNo = dataRow["stoveNo"].ToString();
            p.produccode = dataRow["produccode"].ToString();
            p.steelcode = dataRow["steelcode"].ToString();
            p.gradecode = dataRow["gradecode"].ToString();
            p.gradename = dataRow["gradename"].ToString();
            p.plineCode = dataRow["plineCode"].ToString();
            p.applyCode = apply == null ? "" : apply["jugdeApplyCode"].ToString();
            p.proOrderId = apply == null ? "" : apply["proOrderId"].ToString();
            p.gxPlanNo = apply == null ? "" : apply["gxPlanNo"].ToString();
            p.heatPlanNo = apply == null ? "" : apply["heatPlanNo"].ToString();
            p.checkNo = dataRow["checkNo"].ToString();
            p.loadJudgeStoveNo = apply == null ? "" : dataRow["loadJudgeStoveNo"].ToString();
            p.craftProcess = dataRow["likuProcessCode"].ToString() == "" ? dataRow["processCode"].ToString() : dataRow["processCode"].ToString();
            p.zpMLh = apply == null ? "" : apply["zpMLh"].ToString();

            List<string[]> zpStoveBatchNos = new List<string[]>();
            if (apply != null && apply["zpMLh"].ToString() != "")
            {
                zpStoveBatchNos = getZpJudgeStoveNoM(p.processCode, p.judgeStoveNo);
            }

            //显示或隐藏tab页
            HidenTab(p.ordLnPk, p.ordLnDlyPk, p.craftSeq, p.mscPline, p.processCode, p.pic, consign, apply, clearData);

            _parms.Add(p);
            return p;
        }

        public static JudgeCraftParam GetCraftParam(DataRow dataRow, DataRow zcApply, Dal d)
        {
            JudgeCraftParam a = new JudgeCraftParam();

            DataRow plnSaleord;
            DataRow productInfo = null;
            if (zcApply != null) 
            {
                productInfo = d.GetRowByXmlId("JdgComBaseProduct.getByPk", zcApply["produccode"].ToString());
            }
            if ((zcApply == null || zcApply["ordLnDlyPk"].ToString().StartsWith("ZZB")
                || productInfo != null && (productInfo["producType"].ToString() == "C" || productInfo["producType"].ToString() == "D"
                        || productInfo["producType"].ToString() == "E"))
                && dataRow["ordLnDlyPk"].ToString().StartsWith("ZZB"))
            {
                plnSaleord = d.GetRowByXmlId("JdgPlnSaleOrd.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
                a.OrdLnDlyPk = dataRow["ordLnDlyPk"].ToString();
                a.OrdLnPk = plnSaleord != null? plnSaleord["ordLnPk"].ToString():"";
                a.CraftSeq = dataRow["craftSeq"].ToString();
                a.MscPline = dataRow["indexSeq"].ToString();
                a.Pic = dataRow["pic"].ToString();
                a.Cic = dataRow["cic"].ToString();
            }
            else
            {
                if (zcApply == null)
                {
                    plnSaleord = d.GetRowByXmlId("JdgSlmOrderLineDelivery.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
                    a.OrdLnDlyPk = dataRow["ordLnDlyPk"].ToString();
                    a.OrdLnPk = plnSaleord != null ? plnSaleord["ordLnPk"].ToString() : "";
                    a.CraftSeq = dataRow["craftSeq"].ToString();
                    a.MscPline = dataRow["indexSeq"].ToString();
                    a.Pic = dataRow["pic"].ToString();
                    a.Cic = dataRow["cic"].ToString();
                }
                else
                {
                    if (productInfo["producType"].ToString() == "C" || productInfo["producType"].ToString() == "D"
                        || productInfo["producType"].ToString() == "E")
                    {
                        plnSaleord = d.GetRowByXmlId("JdgSlmOrderLineDelivery.getOrdLnPkByDlyPk", dataRow["ordLnDlyPk"].ToString());
                        a.OrdLnDlyPk = dataRow["ordLnDlyPk"].ToString();
                        a.OrdLnPk = plnSaleord != null ? plnSaleord["ordLnPk"].ToString() : "";
                        a.CraftSeq = dataRow["craftSeq"].ToString();
                        a.MscPline = dataRow["indexSeq"].ToString();
                        a.Pic = dataRow["pic"].ToString();
                        a.Cic = dataRow["cic"].ToString();
                    }
                    else
                    {
                        plnSaleord = d.GetRowByXmlId("JdgSlmOrderLineDelivery.getOrdLnPkByDlyPk", zcApply["ordLnDlyPk"].ToString());
                        a.OrdLnDlyPk = zcApply["ordLnDlyPk"].ToString();
                        a.OrdLnPk = plnSaleord != null ? plnSaleord["ordLnPk"].ToString() : "";
                        a.CraftSeq = zcApply["craftSeq"].ToString();
                        a.MscPline = zcApply["indexSeq"].ToString();
                        a.Pic = zcApply["pic"].ToString();
                        a.Cic = zcApply["cic"].ToString();
                        DataRow stdMinPic = d.GetRowByXmlId("CraftOrdDesignStdPic.getNkMinPic", a.OrdLnPk, a.CraftSeq, a.MscPline,
                            dataRow["processCode"].ToString());
                        a.Pic = stdMinPic["pic"].ToString();
                    }
                }
            }

            return a;
        }

        public static string getOrdLnPkByDlyPk(string ordLnDlyPk, Dal d)
        {
            if (ordLnDlyPk.StartsWith("ZZB"))
            {
                DataRow drSaleord = d.GetRowByXmlId("JdgPlnSaleOrd.getOrdLnPkByDlyPk", ordLnDlyPk);
                return drSaleord["ordLnPk"].ToString();
            }
            else
            {
                DataRow drSaleord = d.GetRowByXmlId("JdgSlmOrderLineDelivery.getOrdLnPkByDlyPk", ordLnDlyPk);
                return drSaleord["ordLnPk"].ToString();
            }
        }

        public void Query(QcmZgChemPhyCtrlQueryParm p)
        {
            if (ultraTabControl2.ActiveTab == null) return;


            switch (ultraTabControl2.ActiveTab.Key)
            {
                case "phy":
                    //_jhyPhySplineCtrl.ClearData();
                    //_jhyPhyResultCtrl.ClearData();
                    //_jhyElementsCtrl.ClearData();
                    if (p.apply != null)
                    {
                        _jhyPhySplineCtrl.QueryColligate(p.applyCode, p.stoveNo, p.judgeStoveNo, p.batchNo, p.mscPline, p.cic, p.pic, p.ordLnPk, p.ordLnDlyPk,
                            p.craftSeq, p.proOrdLnPk, p.zcIsAllScrap, new string[] { }, p.zcApplayCode, p.zcJudgeStoveNo, p.zcBatchNo, p.clearData);
                        //_jhyPhySplineCtrl.Query(lotNo, lotNoGroup, stoveNo, judgeStoveNo, batchNo, _ordLnPk, _ordLnDlyPk, _craftSeq, _mscPline, processCode, _pic, new string[] { },
                        //    _cic, "phy", steelStanard, craftSource, produccode, steelcode, plineCode, processOrdLnPk, craftProcess, zcApply);
                    }
                    else
                    {
                        _jhyPhySplineCtrl.QueryPhy(p.checkNo, p.ordLnPk, p.ordLnDlyPk, p.processCode, p.craftSeq, p.mscPline, p.cic, p.pic,
                            p.craftProcess, new string[] { });
                    }
                    break;
                case "detec":
                    _detectInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.zpMLh, p.clearData);
                    _stdDicCtrl.Query(p.ordLnPk, p.craftSeq, p.mscPline, p.processCode);
                    break;
                case "spec":
                    _specInfoCtrl.QueryByBatchNo(p.judgeStoveNo, p.batchNo, p.zpMLh, p.clearData);
                    break;
                case "face":
                    _faceInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.zpMLh);
                    break;
                case "water":
                    _waterInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.processCode, p.clearData);
                    _stdWicCtrl.Query(p.ordLnPk, p.craftSeq, p.mscPline, p.processCode);
                    break;
                case "process":
                    if (p.processCode == "G")
                    {
                        _processInfoCtrl.Query(p.applyCode, p.judgeStoveNo, p.batchNo, p.zpMLh, p.ordLnPk,
                            p.craftSeq, p.mscPline, p.processCode, p.plineCode, p.clearData);
                    }
                    break;
                case "processOld":
                    if (p.processCode == "G")
                    {
                        _processInfoOldCtrl.Query(p.applyCode, p.judgeStoveNo, p.batchNo, p.clearData);
                    }
                    break;
                case "twistingly":
                    if (p.processCode == "G")
                    {
                        _twistinglyInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    }
                    break;
                case "passInfo":
                    _passInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.processCode, p.clearData);
                    break;
                case "ssc":
                    _pipePhyCtrl.Query(p.applyCode, p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "path":
                    _pathInfoCtrl.Query(p.processCode, p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "threader":
                    _threaderInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "hread":
                    _hreadInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "measure":
                    _measureInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "bundling":
                    _bundlingInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "chamfering":
                    _chamferingInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "finalCheck":
                    _finalCheckInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.plineCode, p.clearData);
                    break;
                case "jgDetect":
                    _inspectionInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.proOrderId, p.clearData);
                    break;
                case "jgCoat":
                    _phospateInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.proOrderId, p.clearData);
                    break;
                case "jgPress":
                    _pressInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.proOrderId, p.clearData);
                    break;
                case "jgSandBlast":
                    _sandBlastInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.proOrderId, p.clearData);
                    break;
                case "jgThinspect":
                    _thinspectInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.proOrderId, p.clearData);
                    break;
                case "jgProduction":
                    _productionInfoCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "jgRemanence":
                    _remanenceCtrl.Query(p.judgeStoveNo, p.batchNo, p.clearData);
                    break;
                case "rclInfo":
                    string[] checkNos = p.checkNo.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
                    _phyRclInfoCtrl.ClearData();
                    if (checkNos.Length > 0)
                    {
                        _phyRclInfoCtrl.Query(checkNos, p.judgeStoveNo, p.batchNo, p.clearData);
                    }
                    break;
                case "002001007010":
                    QcmJhyElementsCtrl jhyElemetCtrl = (QcmJhyElementsCtrl)((SplitContainer)ultraTabControl2.ActiveTab.TabPage.Controls[0]).Panel2.Controls[0];
                    jhyElemetCtrl.ClearData();
                    QcmJhyPhySplineCtrl jhyPhySplineCtrl2 = (QcmJhyPhySplineCtrl)((SplitContainer)ultraTabControl2.ActiveTab.TabPage.Controls[0]).Panel1.Controls[0];
                    jhyPhySplineCtrl2.ClearData();
                    if (p.apply != null)
                    {
                        jhyPhySplineCtrl2.QueryColligate(p.applyCode, p.stoveNo, p.judgeStoveNo, p.batchNo, p.mscPline, p.cic, p.pic, p.ordLnPk, p.ordLnDlyPk,
                            p.craftSeq, p.proOrdLnPk, p.zcIsAllScrap, new string[] { "HX" }, p.zcApplayCode, p.zcJudgeStoveNo,
                            p.zcBatchNo, p.clearData);
                    }
                    else
                    {
                        jhyPhySplineCtrl2.QueryPhy(p.checkNo, p.ordLnPk, p.ordLnDlyPk, p.processCode, p.craftSeq, p.mscPline, p.cic, p.pic,
                            p.craftProcess, new string[] { "HX" });
                    }

                    break;
                default:
                    DataTable dtPhy = _d.GetTableByXmlId("JdgComBasePhyB.getPhyCodeByDept", ultraTabControl2.ActiveTab.Key);
                    string[] phys = dtPhy.Rows.Cast<DataRow>().Select(a => a["phyCode"].ToString()).ToArray();
                    QcmJhyPhyResultCtrl jhyPhyResultCtrl = (QcmJhyPhyResultCtrl)((SplitContainer)ultraTabControl2.ActiveTab.TabPage.Controls[0]).Panel2.Controls[0];
                    jhyPhyResultCtrl.ClearData();
                    QcmJhyPhySplineCtrl jhyPhySplineCtrl = (QcmJhyPhySplineCtrl)((SplitContainer)ultraTabControl2.ActiveTab.TabPage.Controls[0]).Panel1.Controls[0];
                    //jhyPhySplineCtrl.ClearData();
                    if (p.apply != null)
                    {
                        jhyPhySplineCtrl.QueryColligate(p.applyCode, p.stoveNo, p.judgeStoveNo, p.batchNo, p.mscPline, p.cic, p.pic, p.ordLnPk, p.ordLnDlyPk,
                            p.craftSeq, p.proOrdLnPk, p.zcIsAllScrap, phys, p.zcApplayCode, p.zcJudgeStoveNo, p.zcBatchNo, p.clearData);
                    }
                    else
                    {
                        jhyPhySplineCtrl.QueryPhy(p.checkNo, p.ordLnPk, p.ordLnDlyPk, p.processCode, p.craftSeq, p.mscPline, p.cic, p.pic,
                            p.craftProcess, phys);
                    }
                    break;
            }
        }

        private List<string[]> getZpJudgeStoveNoM(string processCode, string zpJudgeStoveNo)
        {
            string[] judgeBatchs = new string[2];
            DataTable dt = null;
            switch (processCode)
            {
                case "D":
                    dt = _d.GetTableByXmlId("JdgMilOfflineGroup.getOldJudgeStoveNo", zpJudgeStoveNo);
                    break;
                case "E":
                    dt = _d.GetTableByXmlId("JdgVrpGroupResult.getOldJudgeStoveNo", zpJudgeStoveNo);
                    break;
                case "F":
                    dt = _d.GetTableByXmlId("JdgHttGroupResult.getOldJudgeStoveNo", zpJudgeStoveNo);
                    break;
                case "G":
                    dt = _d.GetTableByXmlId("JdgMchGroupResult.getOldJudgeStoveNo", zpJudgeStoveNo);
                    break;
            }

            List<string[]> zpStoveBatchs = new List<string[]>();
            foreach (DataRow dr in dt.Rows)
            {
                zpStoveBatchs.Add(new string[] { dr["judgeStoveNo"].ToString(), dr["batchNo"].ToString() });
            }

            return zpStoveBatchs;
        }

        public void ClearTabTag()
        {
            foreach (UltraTab tab in ultraTabControl2.Tabs)
            {
                tab.Tag = null;
            }
        }

        private bool _isSetTab = false;
        public void SetTabTag()
        {
            _isSetTab = true;
            try
            {
                foreach (UltraTab tab in ultraTabControl2.Tabs)
                {
                    if (tab.Tag == null)
                    {
                        tab.Visible = false;
                    }
                    else
                    {
                        tab.Visible = true;
                    }
                }
            }
            finally
            {
                _isSetTab = false;
            }
        }

        private void HidenTab(string ordLnPk, string ordLnDlyPk, string craftSeq, string mscPline, string processCode,
            string pic, DataTable consign, DataRow apply, bool clearData)
        {
            if (clearData)
            {
                ClearTabTag();
            }
            DataRow drChemCnt = null;
            DataRow drPhyCnt = null;
            if (consign == null)
            {
                drChemCnt = _d.GetRowByXmlId("CraftOrdDesignStdCic.getChemCnt", ordLnPk, craftSeq, "", mscPline, processCode);
                drPhyCnt = _d.GetRowByXmlId("CraftOrdDesignStdPic.getPhyCnt", ordLnPk, craftSeq, processCode, "", mscPline);
            }
            else
            {
                string craftSource = consign.Rows[0]["craftSource"].ToString();
                drChemCnt = _d.GetRowByXmlId("CraftOrdDesignStdCic.getChemCnt", ordLnPk, craftSeq, craftSource, mscPline, processCode);
                drPhyCnt = _d.GetRowByXmlId("CraftOrdDesignStdPic.getPhyCnt", ordLnPk, craftSeq, processCode, craftSource, mscPline);
            }
            if (drChemCnt["count"].ToString() == "0")
            {
                //ultraTabControl2.Tabs["002001007010"].Tag = "True";
                //if (ultraTabControl2.Tabs["002001007010"].Tag == null) ultraTabControl2.Tabs["002001007010"].Visible = false;
            }
            else
            {
                ultraTabControl2.Tabs["002001007010"].Tag = "True";
                //ultraTabControl2.Tabs["002001007010"].Visible = true;
                //ultraTabControl2.Tabs["002001007010"].Tag = "1";
            }
            if (drChemCnt["count"].ToString() == "0" && drPhyCnt["count"].ToString() == "0" && consign == null)
            {
                //ultraTabControl2.Tabs["phy"].Visible = ultraTabControl2.Tabs["phy"].Tag != null;
            }
            else
            {
                //ultraTabControl2.Tabs["phy"].Visible = true;
                ultraTabControl2.Tabs["phy"].Tag = "True";
            }
            if (drPhyCnt["count"].ToString() == "0" && consign == null)
            {
                //if(ultraTabControl2.Tabs["002001007020"].Tag == null) ultraTabControl2.Tabs["002001007020"].Visible = false;
                //if(ultraTabControl2.Tabs["002001007013"].Tag == null) ultraTabControl2.Tabs["002001007013"].Visible = false;
                //if(ultraTabControl2.Tabs["002001007015"].Tag == null) ultraTabControl2.Tabs["002001007015"].Visible = false;
                //if(ultraTabControl2.Tabs["002001007014"].Tag == null) ultraTabControl2.Tabs["002001007014"].Visible = false;
                //if(ultraTabControl2.Tabs["002001007009"].Tag == null) ultraTabControl2.Tabs["002001007009"].Visible = false;
            }
            else
            {
                DataTable dtPhyDept = _d.GetTableByXmlId("JdgComBasePhyC.getPhyDept", ordLnDlyPk, craftSeq, mscPline, processCode, pic);
                if (dtPhyDept.Select("phyDeptid LIKE '%002001007020%'").Length == 0)
                {
                    //if(ultraTabControl2.Tabs["002001007020"].Tag == null) ultraTabControl2.Tabs["002001007020"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["002001007020"].Visible = true;
                    ultraTabControl2.Tabs["002001007020"].Tag = "True";
                }
                if (dtPhyDept.Select("phyDeptid like '%002001007013%'").Length == 0)
                {
                    //if(ultraTabControl2.Tabs["002001007013"].Tag == null) ultraTabControl2.Tabs["002001007013"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["002001007013"].Visible = true;
                    ultraTabControl2.Tabs["002001007013"].Tag = "True";
                }
                if (dtPhyDept.Select("phyDeptid like '%002001007015%'").Length == 0)
                {
                    //if(ultraTabControl2.Tabs["002001007015"].Tag == null) ultraTabControl2.Tabs["002001007015"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["002001007015"].Visible = true;
                    ultraTabControl2.Tabs["002001007015"].Tag = "True";
                }
                if (dtPhyDept.Select("phyDeptid like '%002001007014%'").Length == 0)
                {
                    //if(ultraTabControl2.Tabs["002001007014"].Tag == null) ultraTabControl2.Tabs["002001007014"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["002001007014"].Visible = true;
                    ultraTabControl2.Tabs["002001007014"].Tag = "True";
                }
                if (dtPhyDept.Select("phyDeptid like '%002001007009%'").Length == 0)
                {
                    //if(ultraTabControl2.Tabs["002001007009"].Tag == null) ultraTabControl2.Tabs["002001007009"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["002001007009"].Visible = true;
                    ultraTabControl2.Tabs["002001007009"].Tag = "True";
                }
            }
            if (apply != null)
            {

                //if (apply["faceResultPath"].ToString() == "")
                //{
                //    //ultraTabControl2.Tabs["face"].Visible = false;
                //}
                //else
                //{
                //    ultraTabControl2.Tabs["face"].Tag = "True";
                //}
                ultraTabControl2.Tabs["face"].Tag = "True";
                if (apply["specResultPath"].ToString() == "")
                {
                    //if(ultraTabControl2.Tabs["spec"].Tag == null) ultraTabControl2.Tabs["spec"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["spec"].Visible = true;
                    ultraTabControl2.Tabs["spec"].Tag = "True";
                }
                if (apply["testingGrade"].ToString() == "" && apply["testingGrade1"].ToString() == "" 
                    && apply["DIC"].ToString() == "")
                {
                    //if(ultraTabControl2.Tabs["detec"].Tag == null) ultraTabControl2.Tabs["detec"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["detec"].Visible = true;
                    ultraTabControl2.Tabs["detec"].Tag = "True";
                }
                if (apply["holdtimeTime"].ToString() == "")
                {
                    //if(ultraTabControl2.Tabs["water"].Tag == null) ultraTabControl2.Tabs["water"].Visible = false;
                }
                else
                {
                    //ultraTabControl2.Tabs["water"].Visible = true;
                    ultraTabControl2.Tabs["water"].Tag = "True";
                }

                //if (apply["processCode"].ToString() == "G")
                //{
                //    //ultraTabControl2.Tabs["process"].Visible = true;
                //    ultraTabControl2.Tabs["process"].Tag = "True";
                //    ultraTabControl2.Tabs["processOld"].Tag = "True";
                //    // ultraTabControl2.Tabs["twistingly"].Visible = true;
                //    ultraTabControl2.Tabs["twistingly"].Tag = "True";
                //}
                //else
                //{
                //    //if(ultraTabControl2.Tabs["process"].Tag == null) ultraTabControl2.Tabs["process"].Visible = false;
                //    //if(ultraTabControl2.Tabs["twistingly"].Tag == null) ultraTabControl2.Tabs["twistingly"].Visible = false;
                //}
                if (apply["auditResult"].ToString() != "" && apply["auditResult"].ToString() != "407501" || apply["instancyFlag"].ToString() == "1")
                {
                    //ultraTabControl2.Tabs["passInfo"].Visible = true;
                    ultraTabControl2.Tabs["passInfo"].Tag = "True";
                }
                else
                {
                    //if(ultraTabControl2.Tabs["passInfo"].Tag == null) ultraTabControl2.Tabs["passInfo"].Visible = false;
                }

                //SSC
                bool existSsc = false;
                DataTable dtSmp = _d.GetTableByXmlId("JdgCraftOrdDesignStdPicSmp.getRate", ordLnPk, craftSeq, mscPline, processCode, pic);
                foreach (DataRow drSmp in dtSmp.Rows)
                {
                    string phyCodeMin = drSmp["phyCodeMin"].ToString();
                    if (phyCodeMin == "C0030" || phyCodeMin == "C0031" || phyCodeMin == "C0032" || phyCodeMin == "C0033"
                        || phyCodeMin == "C0133" || phyCodeMin == "C0147")
                    {
                        existSsc = true;
                        break;
                    }
                }
                if (!existSsc)
                {
                    DataTable dtFdSmp = _d.GetTableByXmlId("JdgCraftOrdDesignStdPicSmp.getFdRate", ordLnPk, craftSeq);
                    foreach (DataRow drFdSmp in dtFdSmp.Rows)
                    {
                        if (drFdSmp["processCode"].ToString() != processCode) continue;
                        string phyCodeMin = drFdSmp["phyCodeMin"].ToString();
                        if (phyCodeMin == "C0030" || phyCodeMin == "C0031" || phyCodeMin == "C0032" || phyCodeMin == "C0033"
                            || phyCodeMin == "C0133" || phyCodeMin == "C0147")
                        {
                            existSsc = true;
                            break;
                        }
                    }
                }
                if (existSsc)
                {
                    //ultraTabControl2.Tabs["ssc"].Visible = true;
                    ultraTabControl2.Tabs["ssc"].Tag = "True";
                }
                else
                {
                    //if(ultraTabControl2.Tabs["ssc"].Tag == null) ultraTabControl2.Tabs["ssc"].Visible = false;
                }
            }
            if (processCode == "G" && apply != null)
            {
                ultraTabControl2.Tabs["process"].Tag = "True";
                ultraTabControl2.Tabs["processOld"].Tag = "True";
                //ultraTabControl2.Tabs["water"].Visible = true;
                ultraTabControl2.Tabs["water"].Tag = "True";
                //ultraTabControl2.Tabs["twistingly"].Visible = true;
                ultraTabControl2.Tabs["twistingly"].Tag = "True";
                //ultraTabControl2.Tabs["path"].Visible = true;
                ultraTabControl2.Tabs["path"].Tag = "True";
                //ultraTabControl2.Tabs["threader"].Visible = true;
                ultraTabControl2.Tabs["threader"].Tag = "True";
                //ultraTabControl2.Tabs["hread"].Visible = true;
                ultraTabControl2.Tabs["hread"].Tag = "True";
                //ultraTabControl2.Tabs["measure"].Visible = true;
                ultraTabControl2.Tabs["measure"].Tag = "True";
                //ultraTabControl2.Tabs["bundling"].Visible = true;
                ultraTabControl2.Tabs["bundling"].Tag = "True";
                //ultraTabControl2.Tabs["chamfering"].Visible = true;
                ultraTabControl2.Tabs["chamfering"].Tag = "True";
                //ultraTabControl2.Tabs["finalCheck"].Visible = true;
                ultraTabControl2.Tabs["finalCheck"].Tag = "True";
                ultraTabControl2.Tabs["jgProduction"].Tag = "True";
                ultraTabControl2.Tabs["jgRemanence"].Tag = "True";
            }

            if (processCode == "H")
            {
                //ultraTabControl2.Tabs["face"].Visible = ultraTabControl2.Tabs["face"].Tag != null;
            }
            if (processCode == "H" && apply != null)
            {
                ultraTabControl2.Tabs["face"].Tag = null;
                //ultraTabControl2.Tabs["jgDetect"].Visible = true;
                ultraTabControl2.Tabs["jgDetect"].Tag = "True";
                //ultraTabControl2.Tabs["jgCoat"].Visible = true;
                ultraTabControl2.Tabs["jgCoat"].Tag = "True";
                //ultraTabControl2.Tabs["jgPress"].Visible = true;
                ultraTabControl2.Tabs["jgPress"].Tag = "True";
                //ultraTabControl2.Tabs["jgSandBlast"].Visible = true;
                ultraTabControl2.Tabs["jgSandBlast"].Tag = "True";
                //ultraTabControl2.Tabs["jgThinspect"].Visible = true;
                ultraTabControl2.Tabs["jgThinspect"].Tag = "True";
            }
            else
            {
                //if(ultraTabControl2.Tabs["jgDetect"].Tag == null) ultraTabControl2.Tabs["jgDetect"].Visible = false;
                //if(ultraTabControl2.Tabs["jgCoat"].Tag == null) ultraTabControl2.Tabs["jgCoat"].Visible = false;
                //if(ultraTabControl2.Tabs["jgPress"].Tag == null) ultraTabControl2.Tabs["jgPress"].Visible = false;
                //if(ultraTabControl2.Tabs["jgSandBlast"].Tag == null) ultraTabControl2.Tabs["jgSandBlast"].Visible = false;
                //if(ultraTabControl2.Tabs["jgThinspect"].Tag == null) ultraTabControl2.Tabs["jgThinspect"].Visible = false;
            }

            //热处理制度暂时屏蔽
            //DataRow drIsRcl = _d.GetRowByXmlId("QcmJhyPhyresultDAL.queryIsrcl", checkNo, judgeStoveNo, batchNo, processCode);
            bool showRclInfo = false;
            if (consign != null)
            {
                DataRow drBilletSampleCnt = _d.GetRowByXmlId("CraftOrdDesignStdPic.getBilletSampleCnt", ordLnPk, craftSeq, processCode, consign.Rows[0]["craftSource"].ToString());
                if (drBilletSampleCnt["count"].ToString() != "0")
                {
                    showRclInfo = true;
                }
            }
            else
            {
                DataRow drBilletSampleCnt = _d.GetRowByXmlId("CraftOrdDesignStdPic.getBilletSampleCnt", ordLnPk, craftSeq, processCode, "0");
                if (drBilletSampleCnt["count"].ToString() != "0")
                {
                    showRclInfo = true;
                }
                DataRow drBilletSampleCntFd = _d.GetRowByXmlId("CraftOrdDesignStdPic.getBilletSampleCnt", ordLnPk, craftSeq, processCode, "1");
                if (drBilletSampleCntFd["count"].ToString() != "0")
                {
                    showRclInfo = true;
                }
            }
            if (showRclInfo)
            {
                //ultraTabControl2.Tabs["rclInfo"].Visible = true;
                ultraTabControl2.Tabs["rclInfo"].Tag = "True";
            }
            else
            {
                // ultraTabControl2.Tabs["rclInfo"].Visible = false && ultraTabControl2.Tabs["rclInfo"].Tag == null;
            }

            if (clearData)
            {
                SetTabTag();
            }
        }

        private void ultraTabControl2_SelectedTabChanged(object sender, SelectedTabChangedEventArgs e)
        {
            try
            {
                if (_isSetTab) return;
                this.Cursor = Cursors.WaitCursor;
                if (_parms.Count == 0) return;
                ClearData(false);
                foreach (QcmZgChemPhyCtrlQueryParm parm in _parms)
                {
                    if (_isLgQuery)
                    {

                        QueryLg(parm);
                    }
                    else
                    {
                        Query(parm);
                    }
                }
            }
            finally
            {
                this.Cursor = Cursors.Default;
            }
        }

        public void ClearParms()
        {
            _parms.Clear();
        }

        public void ClearData(bool parmsClear)
        {
            _jhyPhySplineCtrl.ClearData();
            _jhyPhyResultCtrl.ClearData();
            _jhyElementsCtrl.ClearData();
            _detectInfoCtrl.ClearData();
            _stdDicCtrl.ClearData();
            _faceInfoCtrl.ClearData();
            _specInfoCtrl.ClearData();
            _waterInfoCtrl.ClearData();
            _stdWicCtrl.ClearData();
            _processInfoCtrl.ClearData();
            _processInfoOldCtrl.ClearData();
            _phyRclInfoCtrl.ClearData();
            _twistinglyInfoCtrl.ClearData();
            _passInfoCtrl.ClearData();
            _pipePhyCtrl.ClearData();
            _pathInfoCtrl.ClearData();
            _threaderInfoCtrl.ClearData();
            _hreadInfoCtrl.ClearData();
            _measureInfoCtrl.ClearData();
            _bundlingInfoCtrl.ClearData();
            _chamferingInfoCtrl.ClearData();
            _finalCheckInfoCtrl.ClearData();
            _inspectionInfoCtrl.ClearData();
            _phospateInfoCtrl.ClearData();
            _pressInfoCtrl.ClearData();
            _sandBlastInfoCtrl.ClearData();
            _thinspectInfoCtrl.ClearData();
            _productionInfoCtrl.ClearData();
            _remanenceCtrl.ClearData();
            if (parmsClear)
            {
                _parms.Clear();
            }

            foreach (var tab in ultraTabControl2.Tabs)
            {
                if (tab.Key == "002001007020" || tab.Key == "002001007013" || tab.Key == "002001007015" || tab.Key == "002001007014"
                    || tab.Key == "002001007009")
                {
                    QcmJhyPhyResultCtrl phyResultCtrl = (QcmJhyPhyResultCtrl)((SplitContainer)tab.TabPage.Controls[0]).Panel2.Controls[0];
                    phyResultCtrl.ClearData();
                    PhyFileCtrl phyFileCtrl = (PhyFileCtrl)((SplitContainer)tab.TabPage.Controls[0]).Panel1.Controls[1];
                    phyFileCtrl.ClearData();
                    QcmJhyPhySplineCtrl jhyPhySplineCtrl = (QcmJhyPhySplineCtrl)((SplitContainer)tab.TabPage.Controls[0]).Panel1.Controls[0];
                    jhyPhySplineCtrl.ClearData();
                }
            }
        }

        public class QcmZgChemPhyCtrlQueryParm
        {
            public DataTable consing;
            public DataRow apply;
            public DataRow zcApply;
            public bool clearData;
            public bool isLgQuery = false;
            public string phyProcess = "";
            public string ordLnPk = "";
            public string ordLnDlyPk = "";
            public string craftSeq = "";
            public string mscPline = "";
            public string processCode = "";
            public string pic = "";
            public string cic = "";
            public string proOrdLnPk = ""; //某个工序送判表对应的OrdLnPk
            public string dic = "";
            public string wic = "";
            public string sic = "";
            public string zcIsAllScrap = "";
            public string zcApplayCode = "";
            public string zcJudgeStoveNo = "";
            public string zcBatchNo = "";
            public string steelStanard = "";
            public string judgeStoveNo = "";
            public string batchNo = "";
            public string lotNo = "";
            public string lotNoGroup = "";
            public string stoveNo = "";
            public string lgJudgeStoveNo = "";
            public string produccode = "";
            public string steelcode = "";
            public string gradecode = "";
            public string gradename = "";
            public string plineCode = "";
            public string applyCode = "";
            public string proOrderId = "";
            public string gxPlanNo = "";
            public string heatPlanNo = "";
            public string checkNo = "";
            public string loadJudgeStoveNo = "";
            public string craftProcess = "";
            public string passApplyNo = "";
            public string upHeatPlanNo = "";
            public string zpMLh = "";
        }
    }
}