using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.Collections;
using Core.StlMes.Client.YdmPipeManage.Controls;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using com.steering.pss.ydm.entity;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmPipeManage.Dialog;
using Core.StlMes.Client.YdmPipeManage.Entity;
using Infragistics.Excel;
using Core.StlMes.Client.YdmPipeManage.Tool;
using Core.StlMes.Client.YdmBase;
using Core.Mes.Client.Comm.Format;


namespace Core.StlMes.Client.YdmPipeManage
{
    public partial class frmPipeMagement : FrmBase
    {
        private string[] _salgPersion;

        public frmPipeMagement()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private string[] myValidDataPurviewIds;
        /// <summary>
        /// 数据权限
        /// </summary>
        public string[] MyValidDataPurviewIds
        {
            get { return myValidDataPurviewIds; }
            set { myValidDataPurviewIds = value; }
        }

        private string fromForm = "1";

        /// <summary>
        /// 什么事件打开此窗体 1代表合同利库管理界面 2代表由合同提报管理界面"利库"按钮请求打开 3等于合同提报管理界面“审核利库”按钮打开
        /// </summary>
        public string FromForm
        {
            get { return fromForm; }
            set { fromForm = value; }
        }

        private ArrayList listParm;

        /// <summary>
        /// 打开窗体传过来的参数
        /// </summary>
        public ArrayList ListParm
        {
            get { return listParm; }
            set { listParm = value; }
        }

        private string ordSaleOrg;
        /// <summary>
        /// 合同属于的销售组织（并非登陆人员）
        /// </summary>
        public string OrdSaleOrg
        {
            get { return ordSaleOrg; }
            set { ordSaleOrg = value; }
        }

        private string ordLnDlyPk = "";
        /// <summary>
        /// 交货行PK
        /// </summary>
        public string OrdLnDlyPk
        {
            get { return ordLnDlyPk; }
            set { ordLnDlyPk = value; }
        }

        private void frmPipeMagement_Load(object sender, EventArgs e)
        {
            if (FromForm == "2")
            {
                this.ValidDataPurviewIds = MyValidDataPurviewIds;
                this.UltraPanel1.Visible = false;
                this.ultraGroupBox5.Visible = true;
                this.splitContainer1.Panel2Collapsed = false;
                this.Query();
                this.DoQueryDelivyByOrdLnDlyPk(this.OrdLnDlyPk);
            }
            else if (FromForm == "3")
            {
                this.ValidDataPurviewIds = MyValidDataPurviewIds;
                this.UltraPanel1.Visible = false;
                DoQueryMatByOrdLnDlyPk(this.OrdLnDlyPk);
            }
            this.txtSpec.Enabled = false;
            _salgPersion = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob);
            UserInfo.SaleOrg = ClsBaseInfo.GetSaleOrg(UserInfo.GetDeptid().Trim());
            StorInfo();
            InitComboDrop();
            EntityHelper.ShowGridCaption<DelivyEntity>(ultraGridDelivy.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<MatZcMEntity>(ultraGridManagement.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<MatZcMEntity>(this.ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<MatZcMEntity>(this.ultraGrid3.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<HistoryRecordEntity>(ultraGridHistoryManage.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<HistoryRecordEntity>(ultraGrid2.DisplayLayout.Bands[0]);
            //setColumnReadOnly(ultraGridManagement);
            setColumnReadOnly(ultraGridDelivy);
            setColumnReadOnly(ultraGridHistoryManage);

            InitCellPosition(ultraGridHistoryManage, new ArrayList { "OrderSeq", "OrderSeqNo", "ActLen", "ActCount", "ActWeight",
                "ActTheoryWeight", "ActLenMin", "ActLenMax", "BatchNo" });
            InitCellPosition(ultraGridDelivy, new ArrayList { "OrderSeq", "DeliveryNo", "DelvryQty", "Planweight", "PlanNum",
                "Paydownweight", "PaydownNum", "MonomerBranch", "MonomerTon", "LikuBranch", "LikuTon","WgtEstmt","SendCount","SendWeight" });
            GridColumnSum(ultraGridManagement, new string[] { "ActCount", "ActWeight", "ActTheoryWight" });
            BaseMethod.setUltraGridColumnMaxInput(ultraGridManagement, new string[] { "ActWeight", "ActTheoryWight" });
            BaseMethod.setUltraGridColumnMaxInput(ultraGridDelivy, new string[] { "Planweight", "Paydownweight", "MonomerTon", "LikuTon" });

            RegStartTime.Value = DateTime.Parse(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).ToString());
            DateTime d1 = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
            RegEndTime.Value = DateTime.Parse(d1.AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd") + " 23:59:59");

            InitBindColumn();
        }

        private void InitBindColumn()
        {

            //材料状态
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150101", "材料产出等待");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150102", "材料管理封锁");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150103", "材料质量封锁");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150104", "材料可编计划");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150105", "材料已编计划");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150106", "材料为余材");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150201", "材料产出等待（未综合判定）");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150202", "材料产出（已综合判定");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150203", "材料为余材（已综合判定）");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150204", "材料脱单余材(销售组织脱单)");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150301", "材料可编提单");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150302", "材料已编提单");
            this.ultraGridManagement.DisplayLayout.ValueLists[0].ValueListItems.Add("80150303", "销售出厂");

            //材料类别
            this.ultraGridManagement.DisplayLayout.ValueLists[1].ValueListItems.Add("801401", "在制品");
            this.ultraGridManagement.DisplayLayout.ValueLists[1].ValueListItems.Add("801402", "成品");
            this.ultraGridManagement.DisplayLayout.ValueLists[1].ValueListItems.Add("801403", "商品");

            //质量封锁标识
            this.ultraGridManagement.DisplayLayout.ValueLists[2].ValueListItems.Add("0", "未封锁");
            this.ultraGridManagement.DisplayLayout.ValueLists[2].ValueListItems.Add("2", "质量封锁");

            //管理封锁标识
            this.ultraGridManagement.DisplayLayout.ValueLists[3].ValueListItems.Add("0", "未封锁");
            this.ultraGridManagement.DisplayLayout.ValueLists[3].ValueListItems.Add("1", "管理封锁");

            
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("801701", "超合同量");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("801702", "无合同");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("801703", "按合同");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("801704", "退货");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("801705", "压库");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("801706", "合同长尺");
            this.ultraGrid1.DisplayLayout.ValueLists[0].ValueListItems.Add("801707", "合同短尺");


            //质量封锁标识
            this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("0", "未封锁");
            this.ultraGrid1.DisplayLayout.ValueLists[1].ValueListItems.Add("2", "质量封锁");

            //管理封锁标识
            this.ultraGrid1.DisplayLayout.ValueLists[2].ValueListItems.Add("0", "未封锁");
            this.ultraGrid1.DisplayLayout.ValueLists[2].ValueListItems.Add("1", "管理封锁");

            this.ultraGridHistoryManage.DisplayLayout.ValueLists[0].ValueListItems.Add("801701", "超合同量");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[0].ValueListItems.Add("801702", "无合同");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[0].ValueListItems.Add("801703", "按合同");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[0].ValueListItems.Add("801704", "退货");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[0].ValueListItems.Add("801705", "压库");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[0].ValueListItems.Add("801706", "合同长尺");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[0].ValueListItems.Add("801707", "合同短尺");

            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801801", "合同变更");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801802", "超交货期");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801803", "超载甩量");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801804", "成品备库");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801805", "质量异议待处理");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801806", "合同短尺");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801807", "合同取消");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801808", "合同改制");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801809", "异地质量异议待处理");
            this.ultraGridHistoryManage.DisplayLayout.ValueLists[1].ValueListItems.Add("801810", "超合同量");
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "QueryMag":
                    Query();
                    break;
                case "QueryOrder":
                    if (this.FromForm == "2")
                    {
                        DoQueryDelivyByOrdLnDlyPk(this.OrdLnDlyPk);
                    }
                    else
                    {
                        DoQueryDelivy();
                    }
                    break;
                case "QueryMat":
                    if (this.FromForm == "3")
                    {
                        DoQueryMatByOrdLnDlyPk(this.OrdLnDlyPk);
                    }
                    else
                    {
                        DoQueryMat();
                    }
                    break;
                case "QueryMomner":
                    QueryMomner();
                    break;
                case "Monomer":
                    Monomer();
                    break;
                case "Liku":
                    Liku();
                    break;
                case "DoForceGp":
                    DoForceGp();
                    break;
                case "DoForceLiku":
                    DoForceLiku();
                    break;
                case"SeqLiku":
                    seqLiku();
                    break;
                case"SeqMonomer":
                    seqMonomer();
                    break;
                case "Export":
                    Export();
                    break;
                case "Export1":
                    Export1();
                    break;
                case "cancelMonomer":
                    cancelMonomer();
                    break;
                case "InsertOrderSeqNo":
                    InsertOrderSeqNo();
                    break;
                case "CheckMat":
                    CheckMat();
                    break;
                case "NoCheckMat":
                    NoCheckMat();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 按支利库
        /// </summary>
        private void seqLiku()
        {
            this.ultraGridManagement.UpdateData();
            this.ultraGridDelivy.UpdateData();
            UltraGridRow uRow = this.ultraGridManagement.ActiveRow;
            if (uRow == null)
            {
                return;
            }
            IQueryable<UltraGridRow> checkOrderRows = ultraGridDelivy.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkOrderRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要利库的交货行!");
                return;
            }
            else if (checkOrderRows.Count() > 1)
            {
                MessageUtil.ShowWarning("只能选择一条需要利库的交货行!");
                return;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["ZbsFlag"].Text == "3")
            {
                MessageUtil.ShowTips("当前数据无合同状态，没有质保书，不能利库!");
                return;
            }
            string mangageMentLenmin = this.ultraGridManagement.ActiveRow.Cells["ActLenMin"].Value.ToString();//物料上下限
            string mangageMentLenMax = this.ultraGridManagement.ActiveRow.Cells["ActLenMax"].Value.ToString();
            string divLenmin = this.ultraGridDelivy.ActiveRow.Cells["LenMin"].Value.ToString();//合同上下限
            string divLenMax = this.ultraGridDelivy.ActiveRow.Cells["LenMax"].Value.ToString();
            if (this.ultraGridManagement.ActiveRow.Cells["Producname"].Text.Contains("坯") || this.ultraGridManagement.ActiveRow.Cells["Producname"].Text == "")
            {

            }
            else
            {
                if (!checkDorce())
                {
                    return;
                }
            }
            DelivyEntity delivyEntity = (DelivyEntity)checkOrderRows.ToArray()[0].ListObject;
            MatZcMEntity matZcTity = (MatZcMEntity)uRow.ListObject;
            matZcTity.MatStatus = uRow.Cells["MatStatus"].Value.ToString();
            //if (!UserInfo.SaleOrg.Equals(matZcTity.BelongCode) && !UserInfo.GetUserName().Equals("admin"))
            //{
            //    MessageUtil.ShowTips("物料不在您所在的销售组织，请所属权转移!");
            //    return;
            //}
            FrmLikuSeq frmSp = new FrmLikuSeq(ob, matZcTity, delivyEntity.OrdLnDlyPk, UserInfo.GetUserName(), CustomInfo);
            frmSp.ShowDialog();
            if (frmSp.disOk.Equals("1"))
            {
                frmSp.Close();
                Query();
            }
        }
        

        /// <summary>
        /// 审核通过
        /// </summary>
        private void CheckMat()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要审核的记录!");
                return;
            }
            ArrayList parm = new ArrayList();
            foreach (UltraGridRow ugr in checkRows)
            {
                MatZcMEntity matZcMEntity = (MatZcMEntity)ugr.ListObject;
                string _matZcMEntity = JSONFormat.Format(matZcMEntity);
                parm.Add(_matZcMEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "doCheckMat";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {

                if (ccp.ReturnInfo.Equals("审核成功!"))
                {
                    if (fromForm == "1")
                        DoQueryMat();
                    else if (fromForm == "3")
                        this.DoQueryMatByOrdLnDlyPk(this.OrdLnDlyPk);
                }
                MessageUtil.ShowTips(ccp.ReturnInfo);

            }
        }
        /// <summary>
        /// 审核不通过
        /// </summary>
        private void NoCheckMat()
        {
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要审核的记录!");
                return;
            }
            int cou = checkRows.GroupBy(a => new { or = a.Cells["OrderNo"].Value.ToString(), or2 = a.Cells["OrderSeq"].Value.ToString() }).Count();
            if (cou > 1)
            {
                MessageUtil.ShowTips("不同合同号和合同行号不能同时进行审核不通过!");
                return;
            }
            ArrayList parm = new ArrayList();
            foreach (UltraGridRow ugr in checkRows)
            {
                MatZcMEntity matZcMEntity = (MatZcMEntity)ugr.ListObject;
                string _matZcMEntity = JSONFormat.Format(matZcMEntity);
                parm.Add(_matZcMEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "doNoCheckMat";
            ccp.ServerParams = new object[] { parm, this.UserInfo.GetUserName() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {

                if (ccp.ReturnInfo.Equals("审核成功!"))
                {
                    if (fromForm == "1")
                        DoQueryMat();
                    else if (fromForm == "3")
                        this.DoQueryMatByOrdLnDlyPk(this.OrdLnDlyPk);
                }
                MessageUtil.ShowTips(ccp.ReturnInfo);

            }
        }
        /// <summary>
        /// 查询脱单记录
        /// </summary>
        private void QueryMomner()
        {
            ArrayList paramList = new ArrayList();
            string orderNo = "";
            string stoveNo = "";
            string producFlag = "";
            string MapStatus = "";
            String belongName = "";
            string specName = "";
            
            if (ChcOrderNo.Checked)
            {
                orderNo = TextOrderNo.Text.Trim();
            }
            if (ChcStoveNo.Checked)
            {
                stoveNo = TextStoveNo.Text.Trim();
            }
            if (ChcProducFlag.Checked && DropProducFlag.Value != null)
            {
                producFlag = DropProducFlag.Value.ToString();
            }
            if (ChcMatStatus.Checked && DropMapStatus.Value != null)
            {

                MapStatus = DropMapStatus.Value.ToString();
            }
            if (chkSpec.Checked)
            {
                specName = this.txtSpec.Text.Trim();
            }
            
            paramList.Add(orderNo);
            paramList.Add(stoveNo);
            paramList.Add(producFlag);
            paramList.Add(MapStatus);
            paramList.Add(belongName);
            paramList.Add(specName);
            
            List<HistoryRecordEntity> listSource = EntityHelper.GetData<HistoryRecordEntity>(
             "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryHistoryMomner", new object[] { paramList, _salgPersion,this.CustomInfo }, this.ob);
            historyMomnerbindingSource.DataSource = listSource;
        }

        /// <summary>
        /// 商品查询
        /// </summary>
        private void DoQueryMat()
        {
            ArrayList paramList = new ArrayList();
            string orderNo = "";
            string stoveNo = "";
            string warehous = "";//仓库号
            string producFlag = "";
            string MapStatus = "";
            String belongName = "";
            string specName = "";
            if (ChcOrderNo.Checked)
            {
                orderNo = TextOrderNo.Text.Trim();
            }
            if (ChcStoveNo.Checked)
            {
                stoveNo = TextStoveNo.Text.Trim();
            }
            if (ChcWarehous.Checked && DropWarehous.Value != null)
            {
                warehous = DropWarehous.Value.ToString();
            }
            //if (ChcProducFlag.Checked && DropProducFlag.Value != null)
            //{
            //    producFlag = DropProducFlag.Value.ToString();
            //}
            //if (ChcMatStatus.Checked && DropMapStatus.Value != null)
            //{

            //    MapStatus = DropMapStatus.Value.ToString();
            //}
            if (chkSpec.Checked)
            {
                specName = this.txtSpec.Text.ToString().Trim();
            }
            string[] sarOrg = YdmBaseClass.Section(this.ValidDataPurviewIds, this.ob);
            paramList.Add(orderNo);
            paramList.Add(stoveNo);
            paramList.Add(warehous);
            // paramList.Add(producFlag);
            // paramList.Add(MapStatus);
            //paramList.Add(belongName);
            paramList.Add(specName);
            List<MatZcMEntity> listSource = EntityHelper.GetData<MatZcMEntity>(
             "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMatMentS", new object[] { paramList, sarOrg,this.CustomInfo }, this.ob);
            // MatZcTdMEntitybindingSource.DataSource = listSource;
            bindingSource1.DataSource = listSource;
        }

        /// <summary>
        /// 通过交货行PK值-商品查询
        /// </summary>
        /// <param name="ordLnDLyPk"></param>
        private void DoQueryMatByOrdLnDlyPk(string ordLnDLyPk)
        {
            string[] sarOrg = YdmBaseClass.Section(this.ValidDataPurviewIds, this.ob);

            List<MatZcMEntity> listSource = EntityHelper.GetData<MatZcMEntity>(
             "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMatMentSByOrdLnDlyPk", new object[] { sarOrg, ordLnDLyPk }, this.ob);
            bindingSource1.DataSource = listSource;
        }



        /// <summary>
        /// 撤销脱单
        /// </summary>
        private void cancelMonomer()
        {

            UltraGridRow row = ultraGridHistoryManage.ActiveRow;
            ArrayList parm = new ArrayList();
            if (row == null && row.Index < 0)
            {
                MessageUtil.ShowTips("请勾选需要操作的数据");
                return;
            }
            string ordLinDlyPk = row.Cells["ordLnDlyPk"].Text;
            string ordLinPk = row.Cells["OrdLnPk"].Text;
            string ordPk = row.Cells["OrdPk"].Text;
            string orderNo = row.Cells["orderNo"].Text;
            string heatNo = row.Cells["judgeStoveNo"].Text;
            string bacthNo = row.Cells["batchNo"].Text;
            string groupNo = row.Cells["batchGroudNo"].Text;
            parm.Add(ordLinDlyPk);
            parm.Add(orderNo);
            parm.Add(heatNo);
            parm.Add(bacthNo);
            parm.Add(groupNo);
            parm.Add(ordLinPk);
            parm.Add(ordPk);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "cancelMonomer";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    QueryHistoryManagent();
                }
            }
        }
        /// <summary>
        /// 绑定仓库号
        /// </summary>
        private void StorInfo()
        {
            BaseMethod.InitStorage(DropWarehous, CustomInfo, this.ValidDataPurviewIds, this.ob);
        }

        private void Export1()
        {
            GridHelper.ulGridToExcel(ultraGrid3, "非标准物料信息");
            GridHelper.ulGridToExcel(ultraGridManagement, "标准物料信息");
        }

        private void Export()
        {
            if (ultraTabControl1.ActiveTab.Key.Equals("1"))
            {
                GridHelper.ulGridToExcel(ultraGridManagement, "成品物料信息");
            }
            else if (ultraTabControl1.ActiveTab.Key.Equals("2"))
            {
                GridHelper.ulGridToExcel(ultraGridHistoryManage, "历史信息");
            }
            else
            {
                GridHelper.ulGridToExcel(ultraGrid1, "商品物料信息");
            }
        }

        private void Query()
        {
            if (ultraTabControl1.ActiveTab.Key.Equals("1"))
            {
                if (this.FromForm == "2")
                {
                    //合同提报管理界面
                    QueryMatInfo(ListParm, OrdSaleOrg);
                }
                else
                {
                    QueryMag();
                }
            }
            else if (ultraTabControl1.ActiveTab.Key.Equals("2"))
            {
                QueryHistoryManagent();
            }
        }

        /// <summary>
        /// 销售管理-合同提报管理-利库调用界面的材料查询
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="saleOrg"></param>
        private void QueryMatInfo(ArrayList parm, string saleOrg)
        {
            List<MatZcMEntity> listSource = new List<MatZcMEntity>();
            if (this.CustomInfo.Equals("120504"))
            {
                listSource = EntityHelper.GetData<MatZcMEntity>(
                "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMatInfo120504", new object[] { parm, saleOrg }, this.ob);
            }
            else {
                listSource = EntityHelper.GetData<MatZcMEntity>(
                "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMatInfo", new object[] { parm, saleOrg }, this.ob);
            }
            matZcMEntityBindingSource.DataSource = listSource;
            List<MatZcMEntity> listSource1 = EntityHelper.GetData<MatZcMEntity>(
          "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMatInfo1", new object[] { parm, saleOrg }, this.ob);

            List<MatZcMEntity> listSource2 = new List<MatZcMEntity>();
            foreach (MatZcMEntity mat in listSource1)
            {
                if (listSource.Where(p => p.StdName.Equals(mat.StdName)).ToList().Count() >= 1)
                {
                    continue;
                }
                listSource2.Add(mat);
            }
            matZcMEntityBindingSource1.DataSource = listSource2;
        }

        /// <summary>
        /// 查询物料(成品)
        /// </summary>
        private void QueryMag()
        {
            ArrayList paramList = new ArrayList();
            string orderNo = "";
            string stoveNo = "";
            string warehous = "";//仓库号
            string producFlag = "";
            string MapStatus = "";
            String belongName = "";
            string specName = "";
            if (ChcOrderNo.Checked)
            {
                orderNo = TextOrderNo.Text.Trim();
            }
            if (ChcStoveNo.Checked)
            {
                stoveNo = TextStoveNo.Text.Trim();
            }
            if (ChcWarehous.Checked && DropWarehous.Value != null)
            {
                warehous = DropWarehous.Value.ToString();
            }
            //if (ChcProducFlag.Checked && DropProducFlag.Value != null)
            //{
            //    producFlag = DropProducFlag.Value.ToString();
            //}
            //if (ChcMatStatus.Checked && DropMapStatus.Value != null)
            //{

            //    MapStatus = DropMapStatus.Value.ToString();
            //}
            if (chkSpec.Checked)
            {
                specName = this.txtSpec.Text.ToString().Trim();
            }
            string[] storges = BaseMethod.WarehousePermissions(CustomInfo, this.ValidDataPurviewIds, this.ob);
            //paramList.Add(orderNo);
            paramList.Add(stoveNo);
            paramList.Add(warehous);
            //paramList.Add(producFlag);
            //paramList.Add(MapStatus);
            //paramList.Add(belongName);
            paramList.Add(specName);
            List<MatZcMEntity> listSource = EntityHelper.GetData<MatZcMEntity>(
             "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMatMent", new object[] { paramList, _salgPersion,this.CustomInfo }, this.ob);
            matZcMEntityBindingSource.DataSource = listSource;
        }

        /// <summary>
        /// 查询历史信息
        /// </summary>
        private void QueryHistoryManagent()
        {
            ArrayList paramList = new ArrayList();
            string orderNo = "";
            string stoveNo = "";
            string producFlag = "";
            string MapStatus = "";
            String belongName = "";
            string specName = "";
            string startTime = "";
            string endTime = "";
            if (chkInputTim.Checked)
            {
                startTime = this.RegStartTime.Value.ToString();
                endTime = this.RegEndTime.Value.ToString();
            }
            if (ChcOrderNo.Checked)
            {
                orderNo = TextOrderNo.Text.Trim();
            }
            if (ChcStoveNo.Checked)
            {
                stoveNo = TextStoveNo.Text.Trim();
            }
            if (ChcProducFlag.Checked && DropProducFlag.Value != null)
            {
                producFlag = DropProducFlag.Value.ToString();
            }
            if (ChcMatStatus.Checked && DropMapStatus.Value != null)
            {

                MapStatus = DropMapStatus.Value.ToString();
            }
            if (chkSpec.Checked)
            {
                specName = this.txtSpec.Text.Trim();
            }
            paramList.Add(orderNo);
            paramList.Add(stoveNo);
            paramList.Add(producFlag);
            paramList.Add(MapStatus);
            paramList.Add(belongName);
            paramList.Add(specName);
            List<HistoryRecordEntity> listSource = EntityHelper.GetData<HistoryRecordEntity>(
             "com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryHistoryMatMent", new object[] { paramList, _salgPersion, this.CustomInfo, startTime,endTime }, this.ob);
            historyRecordEntityBindingSource.DataSource = listSource;
        }

        /// <summary>
        /// 验证Checked是否勾选，显示控件可编辑 打勾表示可编辑，不打勾表示不可编辑
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ChcCheckedChanged(object sender, EventArgs e)
        {
            if (ChcOrderNo.Checked)
            {
                TextOrderNo.ReadOnly = false;
            }
            else
            {
                TextOrderNo.ReadOnly = true;
            }
            if (ChcStoveNo.Checked)
            {
                TextStoveNo.ReadOnly = false;
            }
            else
            {
                TextStoveNo.ReadOnly = true;
            }
            if (ChcWarehous.Checked)
            {
                DropWarehous.ReadOnly = false;
            }
            else
            {
                DropWarehous.ReadOnly = true;
            }
            if (ChcProducFlag.Checked)
            {
                DropProducFlag.ReadOnly = false;
            }
            else
            {
                DropProducFlag.ReadOnly = true;
            }
            if (ChcMatStatus.Checked)
            {
                DropMapStatus.ReadOnly = false;
            }
            else
            {
                DropMapStatus.ReadOnly = true;
            }
            //if (chkSpec.Checked)
            //{
            //    txtSpec.ReadOnly = false;
            //}
            //else
            //{
            //    txtSpec.ReadOnly = false;
            //}

        }
        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            ultraGridManagement.UpdateData();
            UltraGridRow ugr = this.ultraGridManagement.ActiveRow;
            if (this.ultraGridManagement.Rows.Count <= 0) return;
            if (ugr == null) return;
            string ordLnDlyPk = "";
            if (ugr.GetCellValue("OrdLnDlyPk") != null)
            {
                ordLnDlyPk = ugr.GetCellValue("OrdLnDlyPk").ToString();
            }
        }

        /// <summary>
        /// 2015-07-28
        /// </summary>
        private void InitComboDrop()
        {
            //初始化材料类别
            DataTable dtProducFlag = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMaterialSTyle", new object[] { }, this.ob);
            DropProducFlag.DataSource = dtProducFlag;
            DropProducFlag.DisplayMember = "BASENAME";
            DropProducFlag.ValueMember = "BASECODE";
            //初始化材料状态
            DataTable dtMapStatus = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMagement.queryMaterialStatus", new object[] { }, this.ob);
            DropMapStatus.DataSource = dtMapStatus;
            DropMapStatus.DisplayMember = "BASENAME";
            DropMapStatus.ValueMember = "BASECODE";

        }

        /// <summary>
        /// 合同查询
        /// </summary>
        /// <param name="ordLnDlyPk"></param>
        private void DoQueryDelivy()
        {
            ultraGridManagement.UpdateData();
            IQueryable<UltraGridRow> checkRows = ultraGridManagement.Rows.AsQueryable().Where(" CHC = 'True'");
            String orderNo = "";
            if (ChcOrderNo.Checked)
            {
                orderNo = TextOrderNo.Text.Trim();
            }
            if (orderNo.Length == 0 && checkRows.Count() != 1)
            {
                MessageUtil.ShowWarning("请选择唯一的物料记录!");
                return;

            }
            MatZcMEntity matZcEntity = new MatZcMEntity();
            foreach (UltraGridRow ugr in checkRows)
            {
                matZcEntity = (MatZcMEntity)ugr.ListObject;
            }
            List<DelivyEntity> listSource = EntityHelper.GetData<DelivyEntity>(
              "com.steering.pss.ydm.pipemanage.FrmPipeMagement.getDelivyInfo", new object[] { matZcEntity, orderNo, YdmBaseClass.Section(this.ValidDataPurviewIds, ob) }, ob);
            delivyEntityBindingSource.DataSource = listSource;
        }

        /// <summary>
        /// 合同查询
        /// </summary>
        /// <param name="ordLnDlyPk"></param>
        private void DoQueryDelivyByOrdLnDlyPk(string ordLnDlyPk)
        {
            List<DelivyEntity> listSource = EntityHelper.GetData<DelivyEntity>(
              "com.steering.pss.ydm.pipemanage.FrmPipeMagement.getDelivyInfoByOrdLnDlyPk", new object[] { ordLnDlyPk, YdmBaseClass.Section(this.ValidDataPurviewIds, ob),this.fromForm }, ob);
            delivyEntityBindingSource.DataSource = listSource;
        }

        /// <summary>
        /// 按支脱单
        /// </summary>
        private void seqMonomer()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null)
            {
                return;
            }
            if (uRow.Cells["LockFlag"].Text.Equals("质量封锁"))
            {
                MessageUtil.ShowTips("此物料有质量封锁，不可擅动!");
                return;
            }
            if (uRow.Cells["MngLockFlag"].Text.Equals("管理封锁"))
            {
                MessageUtil.ShowTips("此物料有管理封锁，不可擅动!");
                return;
            }
            MatZcMEntity matZcTity = (MatZcMEntity)uRow.ListObject;
            string[] arr = YdmBaseClass.Section(this.ValidDataPurviewIds, ob);


            FrmMonerSeq frmSp = new FrmMonerSeq(ob, matZcTity,UserInfo.GetUserName(), UserInfo.GetDeptid(), arr);
            frmSp.ShowDialog();
            if (frmSp.disOk.Equals("1"))
            {
                frmSp.Close();
                DoQueryMat();
            }
        }

        /// <summary>
        /// 脱单操作
        /// </summary>
        private void Monomer()
        {
            this.ultraGrid1.UpdateData();
            int n = 0;
            IQueryable<UltraGridRow> checkRows = ultraGrid1.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要脱单记录!");
                return;
            }
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(row.Cells["CHC"].Text) == true)
                {
                    n++;
                }
            }
            //if (n > 1)
            //    MessageUtil.ShowWarning("不允许多条同时脱单!");
            //    return;
            //}
            int cou = checkRows.GroupBy(a => new { or = a.Cells["OrderNo"].Value.ToString(), or2 = a.Cells["OrderSeq"].Value.ToString() }).Count();
            if (cou > 1)
            //{
            {
                MessageUtil.ShowTips("不同合同号和合同行号不能同时脱单!");
                return;
            }
            MatZcMEntity matZcMEntityOne = null;
            ArrayList paramList = new ArrayList();
            foreach (UltraGridRow ugr in checkRows)
            {
                MatZcMEntity matZcMEntity = (MatZcMEntity)ugr.ListObject;
                if (matZcMEntityOne != null)
                {
                    //if (matZcMEntityOne.OrdLnPk != matZcMEntity.OrdLnPk || matZcMEntityOne.OrderSeq != matZcMEntity.OrderSeq)
                    //{
                    //    MessageUtil.ShowWarning("不同合同行不能同时脱单!");
                    //    return;
                    //}
                }
                if (ugr.Cells["LockFlag"].Text.Equals("质量封锁"))
                {
                    MessageUtil.ShowTips("此物料有质量封锁，不可擅动!");
                    return;
                }
                if (ugr.Cells["MngLockFlag"].Text.Equals("管理封锁"))
                {
                    MessageUtil.ShowTips("此物料有管理封锁，不可擅动!");
                    return;
                }
                if (!StringUtil.IsInt(ugr.Cells["tdActCount"].Text))
                {
                    MessageUtil.ShowTips("脱单支数请输入整数!");
                    return;
                }
                if (!matZcMEntity.ProductFlag.Equals("商品"))
                {
                    MessageUtil.ShowWarning("不是商品阶段的物料,不能脱单!");
                    return;
                }
                matZcMEntityOne = matZcMEntity;
                string _matZcMEntity = JSONFormat.Format(matZcMEntity);
                paramList.Add(_matZcMEntity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否脱单?") == DialogResult.No)
            {
                return;
            }
            MonomerDialog monomerDialog = new MonomerDialog(ob);
            monomerDialog.ShowDialog();
            string monomerExplain = monomerDialog.monomerExplain;
            string monomerFinishedProduct = monomerDialog.momomerFinishedProduct;
            if (monomerExplain.Length == 0)
            {
                return;
            }
            string[] arr = YdmBaseClass.Section(this.ValidDataPurviewIds, ob);
            string isRolling = monomerDialog.isRolling;
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "monomer";
            ccp.ServerParams = new object[] { paramList, monomerExplain, isRolling, UserInfo.GetUserName(), UserInfo.GetDeptid(), arr, monomerFinishedProduct };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {

                if (ccp.ReturnInfo.Equals("脱单成功!"))
                {
                    DoQueryMat();
                    UltraGridLocation(ultraGrid1, new string[] { "BatchNo", "JudgeStoveNo", "BatchGroudNo" },
                        new string[] { matZcMEntityOne.BatchNo, matZcMEntityOne.JudgeStoveNo, matZcMEntityOne.BatchGroudNo });
                }
                MessageUtil.ShowTips(ccp.ReturnInfo);

            }
        }

        /// <summary>
        /// 新增合同交货行
        /// </summary>
        private void InsertOrderSeqNo()
        {
            this.ultraGrid2.UpdateData();
            IQueryable<UltraGridRow> checkRows = ultraGrid2.Rows.AsQueryable().Where(" CHK = 'True'");
            double sumWgt = 0.0;
            if (checkRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要补量的脱单记录!");
                return;
            }
            int cou = checkRows.GroupBy(a => new { or = a.Cells["OrderNo"].Value.ToString(), or2 = a.Cells["OrderSeq"].Value.ToString() }).Count();
            if (cou > 1)
            {
                MessageUtil.ShowTips("不同合同号和合同行号的脱单记录不能同时补量!");
                return;
            }
            foreach (UltraGridRow row in checkRows)
            {
                sumWgt = sumWgt + double.Parse(row.Cells["ActWeight"].Value.ToString());
            }
            ArrayList paramList = new ArrayList();
            if (double.Parse(this.ultraNumericEditor1.Value.ToString2()) < 0 || double.Parse(this.ultraNumericEditor1.Value.ToString2()) > sumWgt)
            {
                MessageUtil.ShowTips("新增交货行的量不能小于0也不能大于合同脱单总量!");
                return;
            }
            foreach (UltraGridRow ugr in checkRows)
            {
                HistoryRecordEntity matZcMEntity = (HistoryRecordEntity)ugr.ListObject;
                string _matZcMEntity = JSONFormat.Format(matZcMEntity);
                paramList.Add(_matZcMEntity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否补量?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "insertOrderSeqNo";
            ccp.ServerParams = new object[] { paramList, UserInfo.GetUserName(), UserInfo.GetDeptid(), this.ultraNumericEditor1.Value.ToString2() };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {

                if (ccp.ReturnInfo.Equals("补量成功!"))
                {
                    QueryMomner();
                    this.ultraNumericEditor1.Value = "0";
                }
                MessageUtil.ShowTips(ccp.ReturnInfo);

            }
        }

        /// <summary>
        /// 强制利库
        /// </summary>
        private void DoForceLiku()
        {
            ultraGridManagement.UpdateData();
            ultraGridDelivy.UpdateData();
            string batchNo = "";
            string judgeStoveNo = "";
            string batchGroudNo = "";
            string staus = "";
            int n = 0;
            IQueryable<UltraGridRow> checkMagRows = ultraGridManagement.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择利库的物料信息!");
                return;
            }
            if (int.Parse(this.ultraGridManagement.ActiveRow.Cells["lkActCount"].Text) > int.Parse(this.ultraGridManagement.ActiveRow.Cells["actCount"].Text))
            {
                MessageUtil.ShowTips("利库支数不能大于库存支数!");
                return;
            }
            ArrayList magList = new ArrayList();
            foreach (UltraGridRow ugr in checkMagRows)
            {
                if (!StringUtil.IsInt(ugr.Cells["lkActCount"].Text))
                {
                    MessageUtil.ShowTips("利库支数请输入整数!");
                    return;
                }
                //if (ugr.Cells["ZbsFlag"].Text == "3")
                //{
                //    MessageUtil.ShowTips("当前数据无合同状态，没有质保书，不能利库!");
                //    return;
                //}
                if (!ugr.Cells["ProductFlag"].Text.Equals("成品"))
                {
                    MessageUtil.ShowWarning("不是成品阶段的物料,不能利库!");
                    return;
                }
                MatZcMEntity matZcMEntity = (MatZcMEntity)ugr.ListObject;
                batchNo = matZcMEntity.BatchNo;
                judgeStoveNo = matZcMEntity.JudgeStoveNo;
                batchGroudNo = matZcMEntity.BatchGroudNo;
                staus = matZcMEntity.ProductFlag;
                magList.Add(matZcMEntity);
                DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMagement.getCount", new object[] { matZcMEntity }, ob);
                if (int.Parse(ds.Rows[0]["ACOUNT"].ToString()) != int.Parse(matZcMEntity.ActCount.ToString()))
                {
                    MessageUtil.ShowTips("物料信息发生了变化,请刷新页面!");
                    return;
                }
                if (matZcMEntity.LockFlag.ToString() != "0" || matZcMEntity.MngLockFlag.ToString() != "0")
                {
                    MessageUtil.ShowTips("物料被封锁,不允许利库!");
                    return;
                }
                if (matZcMEntity.Producname.Equals("连铸圆坯"))
                {
                    continue;
                }
                //if (!UserInfo.SaleOrg.Equals(matZcMEntity.BelongCode) && !UserInfo.GetUserName().Equals("admin"))
                //{
                //    MessageUtil.ShowTips("物料不在您所在的销售组织，请所属权转移!");
                //    return;
                //}
                n++;

            }
            if (n > 1)
            {
                MessageUtil.ShowTips("合同利库时不允许多条物料同时利库!");
                return;
            }
            IQueryable<UltraGridRow> checkOrderRows = ultraGridDelivy.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkOrderRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要利库的交货行!");
                return;
            }
            else if (checkOrderRows.Count() > 1)
            {
                MessageUtil.ShowWarning("只能选择一条需要利库的交货行!");
                return;
            }
            string mangageMentLenmin = this.ultraGridManagement.ActiveRow.Cells["ActLenMin"].Value.ToString();//物料上下限
            string mangageMentLenMax = this.ultraGridManagement.ActiveRow.Cells["ActLenMax"].Value.ToString();
            string divLenmin = this.ultraGridDelivy.ActiveRow.Cells["LenMin"].Value.ToString();//合同上下限
            string divLenMax = this.ultraGridDelivy.ActiveRow.Cells["LenMax"].Value.ToString();
            //if ((this.ultraGridManagement.ActiveRow.Cells["produccode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["produccode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["steelcode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["steelcode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["specCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["specCode"].Text.ToString()))
            //{
            //    MessageUtil.ShowTips("产品信息不一致,不能强制利库!");
            //    return;
            //}
            if (this.ultraGridManagement.ActiveRow.Cells["Producname"].Text.Contains("坯") || this.ultraGridManagement.ActiveRow.Cells["Producname"].Text == "")
            {

            }
            else
            {
                if (!checkDorce())
                {
                    return;
                }
            }
            string ordStr = "合同号：" + this.ultraGridDelivy.ActiveRow.Cells["ORDERNO"].Value.ToString() + "/" + this.ultraGridDelivy.ActiveRow.Cells["ORDERSEQ"].Value.ToString() + " 交货行号：" + this.ultraGridDelivy.ActiveRow.Cells["DELIVERYNO"].Value.ToString();

            //合同行提报锁定的！
            DataTable lockDt1 = ServerHelper.GetData("com.steering.pss.sale.order.DAL.SlmOrderLineLockDAL.getOrderLineLock", new object[] { this.ultraGridDelivy.ActiveRow.Cells["ORDLNPK"].Value.ToString() }, this.ob);
            if (lockDt1 != null && lockDt1.Rows.Count > 0)
            {
                if (lockDt1.Rows[0][0].ToString() == "1" && this.ultraGridDelivy.ActiveRow.Cells["DeliveryStatus"].Value.ToString2().Equals("生效"))
                {
                    MessageUtil.ShowWarning(ordStr + "该合同行提报排产被锁定请重新审批合同价格!不允许利库! ");
                    return;
                }
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否强制利库") == DialogResult.No)
            {
                return;
            }
            DelivyEntity delivyEntity = (DelivyEntity)checkOrderRows.ToArray()[0].ListObject;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "doForceLiku";
            ccp.ServerParams = new object[] { magList, delivyEntity.OrdLnDlyPk, UserInfo.GetUserName(),FromForm ,this.CustomInfo, matNoList};
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("强制利库成功!"))
                {
                    Query();
                    UltraGridLocation(ultraGridManagement, new string[] { "BatchNo", "JudgeStoveNo", "BatchGroudNo" },
                               new string[] { batchNo, judgeStoveNo, batchGroudNo });
                    matNoList = new ArrayList();
                }
            }
        }


        public bool checkDorce()
        {
            if (this.ultraGridManagement.ActiveRow.Cells["produccode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["produccode"].Text.ToString())
            {
                MessageUtil.ShowTips("品名不一致,不允许强制利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["steelcode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["steelcode"].Text.ToString())
            {
                MessageUtil.ShowTips("钢级不一致,不允许强制利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["specCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["specCode"].Text.ToString())
            {
                MessageUtil.ShowTips("规格不一致,不允许强制利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["modelCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["modelCode"].Text.ToString())
            {
                MessageUtil.ShowTips("扣型不一致,不允许利库!");
                return false;
            }
            //if ("2".Equals(fromForm) && this.ultraGridManagement.ActiveRow.Cells["StdName"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["StdName"].Text.ToString())
            //{
            //    MessageUtil.ShowTips("标准不一致,不允许利库!");
            //    return false;
            //}
            return true;
        }

        /// <summary>
        /// 合同利库
        /// </summary>
        private void Liku()
        {
            ultraGridManagement.UpdateData();
            ultraGridDelivy.UpdateData();
            string batchNo = "";
            string judgeStoveNo = "";
            string batchGroudNo = "";
            string staus = "";
            int n = 0;
            IQueryable<UltraGridRow> checkMagRows = ultraGridManagement.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择利库的物料信息!");
                return;
            }
            if (int.Parse(this.ultraGridManagement.ActiveRow.Cells["lkActCount"].Text) > int.Parse(this.ultraGridManagement.ActiveRow.Cells["actCount"].Text))
            {
                MessageUtil.ShowTips("利库支数不能大于库存支数!");
                return;
            }

            ArrayList magList = new ArrayList();
            foreach (UltraGridRow ugr in checkMagRows)
            {
                if (!StringUtil.IsInt(ugr.Cells["lkActCount"].Text))
                {
                    MessageUtil.ShowTips("利库支数请输入整数!");
                    return;
                }
                if (ugr.Cells["ZbsFlag"].Text == "3")
                {
                    MessageUtil.ShowTips("当前数据无合同状态，没有质保书，不能利库!");
                    return;
                }
                if (!ugr.Cells["ProductFlag"].Text.Equals("成品"))
                {
                    MessageUtil.ShowWarning("不是成品阶段的物料,不能利库!");
                    return;
                }
                MatZcMEntity matZcMEntity = (MatZcMEntity)ugr.ListObject;
                batchNo = matZcMEntity.BatchNo;
                judgeStoveNo = matZcMEntity.JudgeStoveNo;
                batchGroudNo = matZcMEntity.BatchGroudNo;
                staus = matZcMEntity.ProductFlag;
                magList.Add(matZcMEntity);
                DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMagement.getCount", new object[] { matZcMEntity }, ob);
                if (int.Parse(ds.Rows[0]["ACOUNT"].ToString()) != int.Parse(matZcMEntity.ActCount.ToString()))
                {
                    MessageUtil.ShowTips("物料信息发生了变化,请刷新页面!");
                    return;
                }
                if (matZcMEntity.LockFlag.ToString() != "0" || matZcMEntity.MngLockFlag.ToString() != "0")
                {
                    MessageUtil.ShowTips("物料被封锁,不允许利库!");
                    return;
                }
                //if (!UserInfo.SaleOrg.Equals(matZcMEntity.BelongCode) && !UserInfo.GetUserName().Equals("admin"))
                //{
                //    MessageUtil.ShowTips("物料不在您所在的销售组织，请所属权转移!");
                //    return;
                //}
                n++;

            }
            if (n > 1)
            {
                MessageUtil.ShowTips("合同利库时不允许多条物料同时利库!");
                return;
            }
            IQueryable<UltraGridRow> checkOrderRows = ultraGridDelivy.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkOrderRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要利库的交货行!");
                return;
            }
            else if (checkOrderRows.Count() > 1)
            {
                MessageUtil.ShowWarning("只能选择一条需要利库的交货行!");
                return;
            }
            string mangageMentLenmin = this.ultraGridManagement.ActiveRow.Cells["ActLenMin"].Value.ToString();//物料上下限
            string mangageMentLenMax = this.ultraGridManagement.ActiveRow.Cells["ActLenMax"].Value.ToString();
            string divLenmin = this.ultraGridDelivy.ActiveRow.Cells["LenMin"].Value.ToString();//合同上下限
            string divLenMax = this.ultraGridDelivy.ActiveRow.Cells["LenMax"].Value.ToString();
            if (this.ultraGridManagement.ActiveRow.Cells["Producname"].Text.Contains("坯") || this.ultraGridManagement.ActiveRow.Cells["Producname"].Text == "")
            {

            }
            else
            {
                if (!checkData(mangageMentLenmin, mangageMentLenMax, divLenmin, divLenMax))
                {
                    return;
                }
            }
            
            //if ((this.ultraGridManagement.ActiveRow.Cells["produccode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["produccode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["steelcode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["steelcode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["specCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["specCode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["stdStyle"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["stdStyle"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["modelCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["modelCode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["JudgeStdName"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["StdName"].Text.ToString()))
            //{
            //    MessageUtil.ShowTips("产品信息不一致,不能利库!");
            //    return;
            //}
            //if (!compareToValue(double.Parse(mangageMentLenmin), double.Parse(divLenmin), double.Parse(divLenMax)) && !compareToValue(double.Parse(mangageMentLenMax), double.Parse(divLenmin), double.Parse(divLenMax)))
            //{
            //    MessageUtil.ShowTips("长度上下限不一致,不能利库!");
            //    return;

            //}
            string ordStr = "合同号：" + this.ultraGridDelivy.ActiveRow.Cells["ORDERNO"].Value.ToString() + "/" + this.ultraGridDelivy.ActiveRow.Cells["ORDERSEQ"].Value.ToString() + " 交货行号：" + this.ultraGridDelivy.ActiveRow.Cells["DELIVERYNO"].Value.ToString();

            //合同行提报锁定的！
            DataTable lockDt1 = ServerHelper.GetData("com.steering.pss.sale.order.DAL.SlmOrderLineLockDAL.getOrderLineLock", new object[] { this.ultraGridDelivy.ActiveRow.Cells["ORDLNPK"].Value.ToString() }, this.ob);
            if (lockDt1 != null && lockDt1.Rows.Count > 0)
            {
                if (lockDt1.Rows[0][0].ToString() == "1" && this.ultraGridDelivy.ActiveRow.Cells["DeliveryStatus"].Value.ToString2().Equals("生效"))
                {
                    MessageUtil.ShowWarning(ordStr + "该合同行提报排产被锁定请重新审批合同价格!不允许利库! ");
                    return;
                }
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否利库") == DialogResult.No)
            {
                return;
            }
            DelivyEntity delivyEntity = (DelivyEntity)checkOrderRows.ToArray()[0].ListObject;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "Liku";
            ccp.ServerParams = new object[] { magList, delivyEntity.OrdLnDlyPk, UserInfo.GetUserName(), FromForm, this.CustomInfo, matNoList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("利库成功!"))
                {
                    Query();
                    UltraGridLocation(ultraGridManagement, new string[] { "BatchNo", "JudgeStoveNo", "BatchGroudNo" },
                        new string[] { batchNo, judgeStoveNo, batchGroudNo });
                    matNoList = new ArrayList();
                }
            }

        }
        

        /// <summary>
        /// 强制改判
        /// </summary>
        private void DoForceGp()
        {
            ultraGridManagement.UpdateData();
            ultraGridDelivy.UpdateData();
            string batchNo = "";
            string judgeStoveNo = "";
            string batchGroudNo = "";
            string staus = "";
            int n = 0;
            IQueryable<UltraGridRow> checkMagRows = ultraGridManagement.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择改判的物料信息!");
                return;
            }
            if (int.Parse(this.ultraGridManagement.ActiveRow.Cells["lkActCount"].Text) > int.Parse(this.ultraGridManagement.ActiveRow.Cells["actCount"].Text))
            {
                MessageUtil.ShowTips("改判支数不能大于库存支数!");
                return;
            }

            ArrayList magList = new ArrayList();
            foreach (UltraGridRow ugr in checkMagRows)
            {
                if (!StringUtil.IsInt(ugr.Cells["lkActCount"].Text))
                {
                    MessageUtil.ShowTips("改判支数请输入整数!");
                    return;
                }
                if (ugr.Cells["ZbsFlag"].Text == "3")
                {
                    MessageUtil.ShowTips("当前数据无合同状态，没有质保书，不能改判!");
                    return;
                }
                if (!ugr.Cells["ProductFlag"].Text.Equals("成品"))
                {
                    MessageUtil.ShowWarning("不是成品阶段的物料,不能改判!");
                    return;
                }
                MatZcMEntity matZcMEntity = (MatZcMEntity)ugr.ListObject;
                batchNo = matZcMEntity.BatchNo;
                judgeStoveNo = matZcMEntity.JudgeStoveNo;
                batchGroudNo = matZcMEntity.BatchGroudNo;
                staus = matZcMEntity.ProductFlag;
                magList.Add(matZcMEntity);
                DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeMagement.getCount", new object[] { matZcMEntity }, ob);
                if (int.Parse(ds.Rows[0]["ACOUNT"].ToString()) != int.Parse(matZcMEntity.ActCount.ToString()))
                {
                    MessageUtil.ShowTips("物料信息发生了变化,请刷新页面!");
                    return;
                }
                if (matZcMEntity.LockFlag.ToString() != "0" || matZcMEntity.MngLockFlag.ToString() != "0")
                {
                    MessageUtil.ShowTips("物料被封锁,不允许改判!");
                    return;
                }
                //if (!UserInfo.SaleOrg.Equals(matZcMEntity.BelongCode) && !UserInfo.GetUserName().Equals("admin"))
                //{
                //    MessageUtil.ShowTips("物料不在您所在的销售组织，请所属权转移!");
                //    return;
                //}
                n++;

            }
            if (n > 1)
            {
                MessageUtil.ShowTips("合同改判时不允许多条物料同时改判!");
                return;
            }
            IQueryable<UltraGridRow> checkOrderRows = ultraGridDelivy.Rows.AsQueryable().Where(" CHC = 'True'");
            if (checkOrderRows.Count() == 0)
            {
                MessageUtil.ShowWarning("请选择需要改判的交货行!");
                return;
            }
            else if (checkOrderRows.Count() > 1)
            {
                MessageUtil.ShowWarning("只能选择一条需要改判的交货行!");
                return;
            }
            string mangageMentLenmin = this.ultraGridManagement.ActiveRow.Cells["ActLenMin"].Value.ToString();//物料上下限
            string mangageMentLenMax = this.ultraGridManagement.ActiveRow.Cells["ActLenMax"].Value.ToString();
            string divLenmin = this.ultraGridDelivy.ActiveRow.Cells["LenMin"].Value.ToString();//合同上下限
            string divLenMax = this.ultraGridDelivy.ActiveRow.Cells["LenMax"].Value.ToString();
            //if ((this.ultraGridManagement.ActiveRow.Cells["produccode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["produccode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["steelcode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["steelcode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["specCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["specCode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["stdStyle"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["stdStyle"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["modelCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["modelCode"].Text.ToString()) || (this.ultraGridManagement.ActiveRow.Cells["JudgeStdName"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["StdName"].Text.ToString()))
            //{
            //    MessageUtil.ShowTips("产品信息不一致,不能利库!");
            //    return;
            //}
            //if (!compareToValue(double.Parse(mangageMentLenmin), double.Parse(divLenmin), double.Parse(divLenMax)) && !compareToValue(double.Parse(mangageMentLenMax), double.Parse(divLenmin), double.Parse(divLenMax)))
            //{
            //    MessageUtil.ShowTips("长度上下限不一致,不能利库!");
            //    return;

            //}
            string ordStr = "合同号：" + this.ultraGridDelivy.ActiveRow.Cells["ORDERNO"].Value.ToString() + "/" + this.ultraGridDelivy.ActiveRow.Cells["ORDERSEQ"].Value.ToString() + " 交货行号：" + this.ultraGridDelivy.ActiveRow.Cells["DELIVERYNO"].Value.ToString();

            //合同行提报锁定的！
            DataTable lockDt1 = ServerHelper.GetData("com.steering.pss.sale.order.DAL.SlmOrderLineLockDAL.getOrderLineLock", new object[] { this.ultraGridDelivy.ActiveRow.Cells["ORDLNPK"].Value.ToString() }, this.ob);
            if (lockDt1 != null && lockDt1.Rows.Count > 0)
            {
                if (lockDt1.Rows[0][0].ToString() == "1" && this.ultraGridDelivy.ActiveRow.Cells["DeliveryStatus"].Value.ToString2().Equals("生效"))
                {
                    MessageUtil.ShowWarning(ordStr + "该合同行提报排产被锁定请重新审批合同价格!不允许改判! ");
                    return;
                }
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否改判") == DialogResult.No)
            {
                return;
            }
            DelivyEntity delivyEntity = (DelivyEntity)checkOrderRows.ToArray()[0].ListObject;

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmPipeMagement";
            ccp.MethodName = "GaiPan";
            ccp.ServerParams = new object[] { magList, delivyEntity.OrdLnDlyPk, UserInfo.GetUserName(), FromForm, this.CustomInfo, matNoList };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("改判成功!"))
                {
                    Query();
                    UltraGridLocation(ultraGridManagement, new string[] { "BatchNo", "JudgeStoveNo", "BatchGroudNo" },
                        new string[] { batchNo, judgeStoveNo, batchGroudNo });
                    matNoList = new ArrayList();
                }
            }

        }

        public bool checkData(string mangageMentLenmin, string mangageMentLenMax, string divLenmin, string divLenMax)
        {
            if (this.ultraGridManagement.ActiveRow.Cells["produccode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["produccode"].Text.ToString())
            {
                MessageUtil.ShowTips("品名不一致,不允许利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["steelcode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["steelcode"].Text.ToString())
            {
                MessageUtil.ShowTips("钢级不一致,不允许利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["specCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["specCode"].Text.ToString())
            {
                MessageUtil.ShowTips("规格不一致,不允许利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["modelCode"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["modelCode"].Text.ToString())
            {
                MessageUtil.ShowTips("扣型不一致,不允许利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["StdName"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["StdName"].Text.ToString()
                    && this.ultraGridManagement.ActiveRow.Cells["JudgeStdName"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["StdName"].Text.ToString())
            {
                MessageUtil.ShowTips("标准不一致,不允许利库!");
                return false;
            }
            if (this.ultraGridManagement.ActiveRow.Cells["stdStyle"].Text.ToString() != this.ultraGridDelivy.ActiveRow.Cells["stdStyle"].Text.ToString())
            {
                MessageUtil.ShowTips("标准类别不一致,不允许利库!");
                return false;
            }
            if (!compareToValue(double.Parse(divLenmin), double.Parse(divLenMax), double.Parse(mangageMentLenmin)) && !compareToValue(double.Parse(divLenmin), double.Parse(divLenMax), double.Parse(mangageMentLenMax)))
            {
                MessageUtil.ShowTips("长度上下限不一致,不允许利库!");
                return false;
            }
            return true;
        }
        /// <summary>
        /// 判断值在某范围内
        /// </summary>
        /// <param name="min"></param>
        /// <param name="max"></param>
        /// <param name="value"></param>
        /// <returns></returns>
        private bool compareToValue(double min, double max, double value)
        {
            if (value >= min && max >= value)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 设置列只可读
        /// </summary>
        /// <param name="ugr">UltraGrid</param>
        /// <param name="columns">列数组</param>
        private void setColumnReadOnly(UltraGrid ugr)
        {
            foreach (UltraGridColumn ugc in ugr.DisplayLayout.Bands[0].Columns)
            {
                if (!ugc.Key.Equals("CHC"))
                {
                    ugc.CellActivation = Activation.ActivateOnly;
                }
            }
        }

        /// <summary>
        /// 定位
        /// </summary>
        /// <param name="ug"></param>
        /// <param name="keys"></param>
        /// <param name="values"></param>
        private void UltraGridLocation(UltraGrid ug, String[] keys, String[] values)
        {
            if (ug.Rows.Count == 0)
            {
                return;
            }
            if (keys.Length == 0 || values.Length == 0 || values.Length != keys.Length)
            {
                return;
            }
            foreach (UltraGridRow ugr in ug.Rows)
            {
                Boolean flag = true;
                for (int i = 0; i < keys.Length; i++)
                {
                    if (!ugr.Cells[keys[i]].ToString().Equals(values[i]))
                    {
                        flag = false;
                    }
                }
                if (flag == true)
                {

                    ugr.Activate();
                    return;
                }
            }
        }

        private void InitCellPosition(UltraGrid ug, ArrayList columnsKeys)
        {
            foreach (UltraGridColumn ugc in ug.DisplayLayout.Bands[0].Columns)
            {
                if (columnsKeys.Contains(ugc.Key.ToString()))
                {
                    ugc.CellAppearance.TextHAlign = Infragistics.Win.HAlign.Right;
                }

            }
        }

        /// <summary>
        /// 列求和
        /// </summary>
        /// <param name="ug">UltraGrid</param>
        /// <param name="columnKeys">列数组</param>
        private void GridColumnSum(UltraGrid ug, string[] columnKeys)
        {
            if (columnKeys.Length == 0)
            {
                return;
            }
            for (int i = 0; i < columnKeys.Length; i++)
            {
                SummarySettings summary = ug.DisplayLayout.Bands[0].Summaries.Add(SummaryType.Sum, ug.DisplayLayout.Bands[0].Columns[columnKeys[i]], SummaryPosition.UseSummaryPositionColumn);
                //summary.ToolTipText = string.Format("Sum of column{0}.",summary.SourceColumn.Header.Caption);
                summary.DisplayFormat = "{0}";
                summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Right;
            }
        }

        private void frmPipeMagement_Shown(object sender, EventArgs e)
        {
            if (FromForm == "2")
            {
                ultraTabControl1.Tabs[1].Visible = false;
                ultraTabControl1.Tabs[2].Visible = false;
                ultraTabControl1.Tabs[3].Visible = false;
                return;
            }
            else if (FromForm == "3")
            {
                ultraTabControl1.Tabs[0].Visible = false;
                ultraTabControl1.Tabs[2].Visible = false;
                ultraTabControl1.Tabs[3].Visible = false;
                return;
            }
            chkInputTim.Visible = false;
            RegStartTime.Visible = false;
            RegEndTime.Visible = false;
            label3.Visible = false;
            if (toolMenu.Toolbars[0].Tools.Exists("SeqMonomer"))
            {
                if (toolMenu.Toolbars[0].Tools["SeqMonomer"] != null) { toolMenu.Toolbars[0].Tools["SeqMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
            if (toolMenu.Toolbars[0].Tools.Exists("cancelMonomer"))
            {
                if (toolMenu.Toolbars[0].Tools["cancelMonomer"] != null) { toolMenu.Toolbars[0].Tools["cancelMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
            if (toolMenu.Toolbars[0].Tools.Exists("QueryMat"))
            {
                if (toolMenu.Toolbars[0].Tools["QueryMat"] != null) { toolMenu.Toolbars[0].Tools["QueryMat"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Monomer"))
            {
                if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.False; }
            }

            if (toolMenu.Toolbars[0].Tools.Exists("QueryMomner"))
            {
                if (toolMenu.Toolbars[0].Tools["QueryMomner"] != null) { toolMenu.Toolbars[0].Tools["QueryMomner"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
            if (toolMenu.Toolbars[0].Tools.Exists("InsertOrderSeqNo"))
            {
                if (toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"] != null) { toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"].InstanceProps.Visible = DefaultableBoolean.False; }
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CheckMat"))
            {
                if (toolMenu.Toolbars[0].Tools["CheckMat"] != null)
                {
                    toolMenu.Toolbars[0].Tools["CheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
            if (toolMenu.Toolbars[0].Tools.Exists("NoCheckMat"))
            {
                if (toolMenu.Toolbars[0].Tools["NoCheckMat"] != null)
                {
                    toolMenu.Toolbars[0].Tools["NoCheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null)
            {
                return;
            }
            if (e.Tab.Key.Equals("1"))
            {
                //if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Caption = "物料查询"; }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMag"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Caption = "物料查询"; }
                }
                //if (toolMenu.Toolbars[0].Tools["QueryOrder"] != null) { toolMenu.Toolbars[0].Tools["QueryOrder"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryOrder"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryOrder"] != null) { toolMenu.Toolbars[0].Tools["QueryOrder"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                //if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Monomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                //if (toolMenu.Toolbars[0].Tools["Liku"] != null) { toolMenu.Toolbars[0].Tools["Liku"].InstanceProps.Visible = DefaultableBoolean.True; }
                if (toolMenu.Toolbars[0].Tools.Exists("Liku"))
                {
                    if (toolMenu.Toolbars[0].Tools["Liku"] != null) { toolMenu.Toolbars[0].Tools["Liku"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                
                if (toolMenu.Toolbars[0].Tools.Exists("cancelMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["cancelMonomer"] != null) { toolMenu.Toolbars[0].Tools["cancelMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqLiku"] != null) { toolMenu.Toolbars[0].Tools["SeqLiku"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqMonomer"] != null) { toolMenu.Toolbars[0].Tools["SeqMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoForceLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["DoForceLiku"] != null) { toolMenu.Toolbars[0].Tools["DoForceLiku"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMat")) { toolMenu.Toolbars[0].Tools["QueryMat"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Visible = DefaultableBoolean.True; }

                if (toolMenu.Toolbars[0].Tools.Exists("QueryMomner"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMomner"] != null) { toolMenu.Toolbars[0].Tools["QueryMomner"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("InsertOrderSeqNo"))
                {
                    if (toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"] != null) { toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["CheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["CheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                    }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoCheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["NoCheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["NoCheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                    }
                }
                chkInputTim.Visible = false;
                RegStartTime.Visible = false;
                RegEndTime.Visible = false;
                label3.Visible = false;
            }
            else if (e.Tab.Key.Equals("2"))
            {

                if (toolMenu.Toolbars[0].Tools.Exists("QueryMag"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Caption = "历史查询"; }
                }
                //if (toolMenu.Toolbars[0].Tools["QueryOrder"] != null) { toolMenu.Toolbars[0].Tools["QueryOrder"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryOrder"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryOrder"] != null) { toolMenu.Toolbars[0].Tools["QueryOrder"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                //if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Monomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Liku"))
                {
                    if (toolMenu.Toolbars[0].Tools["Liku"] != null) { toolMenu.Toolbars[0].Tools["Liku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                //if (toolMenu.Toolbars[0].Tools["Liku"] != null) { toolMenu.Toolbars[0].Tools["Liku"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("cancelMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["cancelMonomer"] != null) { toolMenu.Toolbars[0].Tools["cancelMonomer"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoForceLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["DoForceLiku"] != null) { toolMenu.Toolbars[0].Tools["DoForceLiku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMat"] != null) { toolMenu.Toolbars[0].Tools["QueryMat"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMag"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMomner"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMomner"] != null) { toolMenu.Toolbars[0].Tools["QueryMomner"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("InsertOrderSeqNo"))
                {
                    if (toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"] != null) { toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqLiku"] != null) { toolMenu.Toolbars[0].Tools["SeqLiku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqMonomer"] != null) { toolMenu.Toolbars[0].Tools["SeqMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["CheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["CheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                    }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoCheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["NoCheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["NoCheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                    }
                }
                chkInputTim.Visible = true;
                RegStartTime.Visible = true;
                RegEndTime.Visible = true;
                label3.Visible = true;

            }
            else if (e.Tab.Key.Equals("3"))
            {
                //if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMag"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                //if (toolMenu.Toolbars[0].Tools["QueryOrder"] != null) { toolMenu.Toolbars[0].Tools["QueryOrder"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryOrder"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryOrder"] != null) { toolMenu.Toolbars[0].Tools["QueryOrder"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Monomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                //if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.True; }
                //if (toolMenu.Toolbars[0].Tools["Liku"] != null) { toolMenu.Toolbars[0].Tools["Liku"].InstanceProps.Visible = DefaultableBoolean.False; }
                if (toolMenu.Toolbars[0].Tools.Exists("Liku"))
                {
                    if (toolMenu.Toolbars[0].Tools["Liku"] != null) { toolMenu.Toolbars[0].Tools["Liku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("cancelMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["cancelMonomer"] != null) { toolMenu.Toolbars[0].Tools["cancelMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoForceLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["DoForceLiku"] != null) { toolMenu.Toolbars[0].Tools["DoForceLiku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMat"] != null) { toolMenu.Toolbars[0].Tools["QueryMat"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMomner"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMomner"] != null) { toolMenu.Toolbars[0].Tools["QueryMomner"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("InsertOrderSeqNo"))
                {
                    if (toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"] != null) { toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqLiku"] != null) { toolMenu.Toolbars[0].Tools["SeqLiku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqMonomer"] != null) { toolMenu.Toolbars[0].Tools["SeqMonomer"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["CheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["CheckMat"].InstanceProps.Visible = DefaultableBoolean.True;
                    }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoCheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["NoCheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["NoCheckMat"].InstanceProps.Visible = DefaultableBoolean.True;
                    }
                }
                chkInputTim.Visible = false;
                RegStartTime.Visible = false;
                RegEndTime.Visible = false;
                label3.Visible = false;
            }
            else
            {

                if (toolMenu.Toolbars[0].Tools.Exists("QueryMag"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMag"] != null) { toolMenu.Toolbars[0].Tools["QueryMag"].InstanceProps.Visible = DefaultableBoolean.False; }
                }

                if (toolMenu.Toolbars[0].Tools.Exists("QueryOrder"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryOrder"] != null) { toolMenu.Toolbars[0].Tools["QueryOrder"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Monomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["Monomer"] != null) { toolMenu.Toolbars[0].Tools["Monomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }

                if (toolMenu.Toolbars[0].Tools.Exists("Liku"))
                {
                    if (toolMenu.Toolbars[0].Tools["Liku"] != null) { toolMenu.Toolbars[0].Tools["Liku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("cancelMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["cancelMonomer"] != null) { toolMenu.Toolbars[0].Tools["cancelMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoForceLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["DoForceLiku"] != null) { toolMenu.Toolbars[0].Tools["DoForceLiku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMat"] != null) { toolMenu.Toolbars[0].Tools["QueryMat"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryMomner"))
                {
                    if (toolMenu.Toolbars[0].Tools["QueryMomner"] != null) { toolMenu.Toolbars[0].Tools["QueryMomner"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("InsertOrderSeqNo"))
                {
                    if (toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"] != null) { toolMenu.Toolbars[0].Tools["InsertOrderSeqNo"].InstanceProps.Visible = DefaultableBoolean.True; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqLiku"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqLiku"] != null) { toolMenu.Toolbars[0].Tools["SeqLiku"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("SeqMonomer"))
                {
                    if (toolMenu.Toolbars[0].Tools["SeqMonomer"] != null) { toolMenu.Toolbars[0].Tools["SeqMonomer"].InstanceProps.Visible = DefaultableBoolean.False; }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["CheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["CheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                    }
                }
                if (toolMenu.Toolbars[0].Tools.Exists("NoCheckMat"))
                {
                    if (toolMenu.Toolbars[0].Tools["NoCheckMat"] != null)
                    {
                        toolMenu.Toolbars[0].Tools["NoCheckMat"].InstanceProps.Visible = DefaultableBoolean.False;
                    }
                }
                chkInputTim.Visible = false;
                RegStartTime.Visible = false;
                RegEndTime.Visible = false;
                label3.Visible = false;
            }

        }

        private void chkSpec_CheckedChanged(object sender, EventArgs e)
        {
            this.txtSpec.Enabled = this.chkSpec.Checked;
        }

        private void TextStoveNo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                if (ultraTabControl1.SelectedTab.Key == "3")
                {
                    DoQueryMat();
                }
                else
                {
                    Query();
                }
            }
        }

        private void txtSpec_KeyDown(object sender, KeyEventArgs e)
        {
            if (ultraTabControl1.SelectedTab.Key == "3")
            {
                DoQueryMat();
            }
            else
            {
                Query();
            }
        }

        private void TextOrderNo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                if (ultraTabControl1.SelectedTab.Key == "1")
                {
                    DoQueryDelivy();
                }
                else if (ultraTabControl1.SelectedTab.Key == "3")
                {
                    DoQueryMat();
                }
                else if (ultraTabControl1.SelectedTab.Key == "2")
                {
                    QueryMomner();
                }
                else if (ultraTabControl1.SelectedTab.Key == "4")
                {
                    QueryMomner();
                }
            }
        }

        private void ultraGridDelivy_CellChange(object sender, CellEventArgs e)
        {
            ultraGridDelivy.Update();
            if (e.Cell.Column.Key == "CHC")
            {
                //    foreach (UltraGridRow ur in ultraGridDelivy.Rows)
                //    {
                //        if (ur.Cells["CHC"].Text == "True")
                //        {
                //            ur.Appearance.BackColor = System.Drawing.Color.YellowGreen;
                //        }
                //        else
                //        {
                //            ur.Appearance.BackColor = System.Drawing.Color.White;
                //        }
                //    }
                //}
                if (e.Cell.Text == "True")
                {
                    ultraGridDelivy.ActiveRow.Appearance.BackColor = System.Drawing.Color.Yellow;
                }
                else
                {
                    ultraGridDelivy.ActiveRow.Appearance.BackColor = System.Drawing.Color.White;
                }
            }

        }

        private void ultraGrid1_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGrid1.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHC"].Value = true;
                }
            }
        }

        private void ultraGrid2_CellChange(object sender, CellEventArgs e)
        {
            this.ultraGrid2.UpdateData();
            if (Convert.ToBoolean(e.Cell.Row.Cells["CHK"].Value).ToString() == "True")
            {
                if (ultraNumericEditor1.Value.ToString2() == "")
                {
                    ultraNumericEditor1.Value = (0 + double.Parse(e.Cell.Row.Cells["ActWeight"].Value.ToString())).ToString();
                }
                else
                {
                    ultraNumericEditor1.Value = (double.Parse(ultraNumericEditor1.Value.ToString()) + double.Parse(e.Cell.Row.Cells["ActWeight"].Value.ToString())).ToString();
                }
            }
            else
            {
                if (ultraNumericEditor1.Value.ToString2() != "")
                {
                    if (double.Parse(ultraNumericEditor1.Value.ToString()) > 0)
                    {
                        if (Convert.ToBoolean(e.Cell.Row.Cells["CHK"].Value).ToString() == "False")
                        {
                            ultraNumericEditor1.Value = (double.Parse(ultraNumericEditor1.Value.ToString2()) - double.Parse(e.Cell.Row.Cells["ActWeight"].Value.ToString())).ToString();
                        }
                    }
                }
            }
        }

        private void chkInputTim_CheckedChanged(object sender, EventArgs e)
        {
            this.RegStartTime.Enabled = this.RegEndTime.Enabled = this.chkInputTim.Checked;
        }

        private ArrayList matNoList = new ArrayList();

        private void chkMatNo_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            UltraGridRow row = this.ultraGridManagement.ActiveRow;
            if (row == null)
            {
                return;
            }
            MatZcMEntity matEntity = (MatZcMEntity)row.ListObject;
            FrmMatNo frm = new FrmMatNo(matEntity, ob,this.fromForm);
            frm.ShowDialog();
            matNoList = frm.matNoList;
            row.Cells["LkactCount"].Value = frm.acount.ToString();
        }


        //int iSelectG1Row = -1;

        //private void ultraGridManagement_CellChange(object sender, CellEventArgs e)
        //{
        //    this.ultraGridManagement.UpdateData();
        //    iSelectG1Row = -1;
        //    if (ultraGridManagement.Rows.Count == 1)
        //    {
        //        ultraGridManagement.Rows[0].Cells["CHC"].Value = true;
        //    }
        //    else
        //    {
        //        if (e.Cell.Column.Key.ToString().ToUpper() == "CHC")
        //        {
        //            if (e.Cell.Value.ToString().ToUpper() == "TRUE")
        //            {
        //                if (iSelectG1Row != -1)
        //                    ultraGridManagement.Rows[iSelectG1Row].Cells["CHC"].Value = false;
        //                iSelectG1Row = e.Cell.Row.Index;
        //            }
        //            else
        //            {
        //                iSelectG1Row = -1;
        //            }
        //        }
        //    }
        //}
        //int iSelectG2Row = -1;
        //private void ultraGridDelivy_CellChange(object sender, CellEventArgs e)
        //{
        //    this.ultraGridDelivy.UpdateData();
        //    //if (ultraGridDelivy.Rows.Count == 1)
        //    //{
        //    //    ultraGridDelivy.Rows[0].Cells["CHC"].Value = true;
        //    //    ultraGridDelivy.DisplayLayout.Override.ActiveRowAppearance.BackColor = Color.Orange;
        //    //}
        //    //else
        //    //{
        //        if (e.Cell.Column.Key.ToString().ToUpper() == "CHC")
        //        {
        //            //if (e.Cell.Value.ToString().ToUpper() == "TRUE")
        //            //{
        //            //    if (iSelectG2Row != -1)
        //            //        ultraGridDelivy.Rows[iSelectG2Row].Cells["CHC"].Value = false;
        //            //    iSelectG2Row = e.Cell.Row.Index;
        //            //    ultraGridDelivy.DisplayLayout.Override.ActiveRowAppearance.BackColor = Color.Orange;
        //            //}
        //            if (e.Cell.Value.ToString().ToUpper() == "TRUE")
        //            {
        //                if (iSelectG2Row != -1)
        //                    ultraGridDelivy.Rows[iSelectG2Row].Cells["CHC"].Value = false;
        //                iSelectG2Row = e.Cell.Row.Index;
        //                ultraGridDelivy.ActiveRow.Appearance.BackColor = System.Drawing.Color.Orange;
        //            }
        //            else
        //            {
        //                iSelectG2Row = -1;
        //                ultraGridDelivy.ActiveRow.Appearance.BackColor = System.Drawing.Color.Yellow;
        //            }
        //        }
        //    //}
        //}





    }
}