MES_Client/TGMES/Core.StlMes.Client.YdmPipeManage/成品产权转移/FrmFinishAfrim.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmBase;
using Core.StlMes.Client.YdmPipeManage.Dialog;
using Core.StlMes.Client.YdmPipeManage.Entity;
using Core.StlMes.Client.YdmPipeManage.Tool;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.YdmPipeManage
{
    public partial class FrmFinishAfrim : FrmBase
    {
        public FrmFinishAfrim()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
        }
        UltraComboEditor uceFinished = new UltraComboEditor();
        private void FrmFinishAfrim_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            this.cmbDate.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.cmbEndDate.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");

            this.dtSatrtTim.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.dtEndTim.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");

            this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");

            this.changeStartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.changeEndTim.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");

            dtBathYear.Value = DateTime.Parse(DateTime.Today.ToString("yyyy-MM"));

            YdmBaseClass.InitComboEditor(cmbStorage, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
            YdmBaseClass.InitComboEditor(cmbStorageStr, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getStorageDetail", "STORAGE_NO", this.ob, false);
            YdmBaseClass.BindColumn(cmbStorageStr, "STORAGE_NO", this.Controls, this.ultraGrid4, 0);
            
            YdmBaseClass.InitComboEditor(uceFinished, "com.steering.pss.ydm.pipemanage.CorePipeInTemp.getFinishedProduct", "BASECODE", this.ob, false);
            YdmBaseClass.BindColumn(uceFinished, "FINISHPRO_MOLD", this.Controls, this.ultraGrid4, 0);

            EntityHelper.ShowGridCaption<QcmZgJugdeApplyEntity>(this.ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnSaleordEntity>(this.ultraGrid2.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<YdmZcInlistEntity>(this.ultraGrid3.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<YdmZcChangebelongEntity>(this.ultraGrid5.DisplayLayout.Bands[0]);
            EntityHelper.setColumnShowOrHidden(this.ultraGrid3, new string[] { "OrderType", "ProcessDesc", "ProcessCdoe" }, false);

            InitBindColumn();
        }
        private void InitBindColumn()
        {

            //材料状态
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150101", "材料产出等待");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150102", "材料管理封锁");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150103", "材料质量封锁");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150104", "材料可编计划");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150105", "材料已编计划");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150106", "材料为余材");

            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150201", "材料产出等待（未综合判定）");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150202", "材料产出（已综合判定");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150203", "材料为余材（已综合判定）");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150204", "材料脱单余材(销售组织脱单)");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150205", "材料缴库余材(销售组织缴库)");

            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150301", "材料可编提单");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150302", "材料已编提单");
            this.ultraGrid4.DisplayLayout.ValueLists[0].ValueListItems.Add("80150303", "销售出厂");
            //string[] arr = new string[3] { "801501", "801502", "801503" };
            //DataTable dt = ClsLoad.GetValueListDataTable(arr, this.ob);
            //this.ultraGrid2.DisplayLayout.Bands[0].Columns["MAT_STATUS"].ValueList = ClsLoad.GeneralValuelist(ref dt, "BASECODE", "BASENAME");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801701", "非计划入");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801702", "无合同");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801703", "按计划入");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801704", "钢管退货");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801705", "压库");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801706", "合同长尺");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("801707", "合同短尺");

            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802201", "超合同量");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802202", "合同长尺");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802203", "合同短尺");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802204", "生产压库");
            this.ultraGrid4.DisplayLayout.ValueLists[1].ValueListItems.Add("802205", "合同正尺");
        }

        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQueryJudge();
                    break;
                case"QueryInList":
                    doQueryInList();
                    break;
                case "Query2":
                    QueryPipedData();
                    break;
                case"QueryChange":
                    doQueryChangeData();
                    break;
                case "DoFrim":
                    doFrim1();
                    break;
                case "updateCarryOverDate":
                    updateCarryOverDate();
                    break;
                case "canceDoFrim":
                    canceDoFrim();
                    break;
                case "updateMemo":
                    updatePipMemo();
                    break;
                case "updateFinishedProduct":
                    updateFinishedProduct();
                    break;
                case "updateStoreNo":
                    updateStoreNo();
                    break;
                case "adjustStoreButress":
                    adjustStoreButress();
                    break;
                case "getRealTimeStore":
                    //getRealTimeStore();
                    break;
                case"updateBelong":
                    updateBelong();
                    break;
                case"ChangePass":
                    changePass();
                    break;
                case"changeNoPass":
                    changeNoPass();
                    break;
                case "Export":
                    Export();
                    break;
                case "QRJSH":
                    doQRJSH();
                    break;
                case "QXJSH":
                    doQXJSH();
                    break;
                case "Close":
                    this.Close();
                    break;

            }
        }

        /// <summary>
        /// 确认接收
        /// </summary>
        private void doQRJSH()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null) return;
            QcmZgJugdeApplyEntity entity = (QcmZgJugdeApplyEntity)uRow.ListObject;
            string qcmEntity = JSONFormat.Format(entity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "doQRJSH";
            ccp.ServerParams = new object[] { qcmEntity, UserInfo.GetUserName() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("确认接收成功!"))
                {
                    doQueryJudge();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        /// <summary>
        /// 取消接收
        /// </summary>
        private void doQXJSH()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null) return;
            QcmZgJugdeApplyEntity entity = (QcmZgJugdeApplyEntity)uRow.ListObject;
            string qcmEntity = JSONFormat.Format(entity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "doQXJSH";
            ccp.ServerParams = new object[] { qcmEntity, UserInfo.GetUserName() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("取消接收成功!"))
                {
                    doQueryJudge();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        
        /// <summary>
        /// 审批通过
        /// </summary>
        private void changePass()
        {
            this.ultraGrid5.UpdateData();
            UltraGridRow uRow = this.ultraGrid5.ActiveRow;
            if (uRow == null) return;
            YdmZcChangebelongEntity ydmTity = (YdmZcChangebelongEntity)uRow.ListObject;
            string ydmEntity = JSONFormat.Format(ydmTity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "changePass";
            ccp.ServerParams = new object[] { ydmEntity, UserInfo.GetUserName(),this.CustomInfo };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("审批成功!"))
                {
                    doQueryChangeData();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        /// <summary>
        ///审批不通过
        /// </summary>
        private void changeNoPass()
        {
            this.ultraGrid5.UpdateData();
            UltraGridRow uRow = this.ultraGrid5.ActiveRow;
            if (uRow == null) return;
            YdmZcChangebelongEntity ydmTity = (YdmZcChangebelongEntity)uRow.ListObject;
            string ydmEntity = JSONFormat.Format(ydmTity);
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "changeNoPass";
            ccp.ServerParams = new object[] { ydmEntity,UserInfo.GetUserName() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("审批成功!"))
                {
                    doQueryChangeData();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 转移所属权
        /// </summary>
        private void updateBelong()
        {
            this.ultraGrid4.UpdateData();
            int m = 0;
            foreach (UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    m++;
                }
            }
            if (m < 1)
            {
                MessageUtil.ShowTips("请选择需要操作的数据!");
                return;
            }
            if (this.ultraBelong.Value.ToString2() == "")
            {
                MessageUtil.ShowTips("转移所属权时请指定所属权单位!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    if (uRow.Cells["PRODUCT_FLAG"].Value.ToString() == "商品")
                    {
                        MessageUtil.ShowTips("商品不允许进行所属权转移!");
                        return;
                    }
                    ArrayList list = new ArrayList();
                    list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_NO"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim());
                    list.Add(uRow.Cells["UNIT"].Text.Trim());
                    list.Add(uRow.Cells["BELONG_CODE"].Text);
                    list.Add(uRow.Cells["BELONG_NAME"].Text);
                    list.Add(uRow.Cells["PRODUCT_FLAG"].Text);
                    parmList.Add(list);
                }
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "updateBelong";
            ccp.ServerParams = new object[] { parmList, UserInfo.GetUserName(), this.ultraBelong.Value.ToString2(), this.ultraBelong.Text.ToString2(),this.CustomInfo };
            ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("转移成功!"))
                {
                    QueryPipedData();
                }
            }

        }
        /// <summary>
        /// 撇支调整位置
        /// </summary>
        private void adjustStoreButress()
        {
            ultraGrid4.UpdateData();
            int n = 0;
            int m = -1;
            ArrayList list = new ArrayList();
            string heatNo = "";
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    heatNo = uRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
                    list.Add(uRow.Cells["JUDGE_STOVE_NO"].Value.ToString());
                    list.Add(uRow.Cells["BATCH_NO"].Value.ToString());
                    list.Add(uRow.Cells["BATCH_GROUD_NO"].Value.ToString());
                    if (uRow.Cells["PRODUCT_FLAG"].Value.ToString().Equals("商品"))
                    {
                        list.Add("801403");
                    }
                    else
                    {
                        list.Add("801402");
                    }
                    list.Add(uRow.Cells["ORDER_NO"].Value.ToString());
                    list.Add(uRow.Cells["ORDER_SEQ"].Value.ToString());
                    list.Add(uRow.Cells["ORDER_SEQ_NO"].Value.ToString());
                    list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString());
                    list.Add(uRow.Cells["MAT_STATUS"].Value.ToString());
                    n++;
                    m = uRow.Index;
                }
            }
            if (n < 1)
            {
                MessageUtil.ShowTips("请选择主信息进行批量调整位置!");
                return;
            }
            if (n > 1)
            {
                MessageUtil.ShowTips("批量调整位置不允许多条调整库存位置!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否批量修改选择数据的库存位置?") == DialogResult.No)
            {
                return;
            }
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipupdateStoreButress.selectMatStu", new object[] { list }, ob);
            if (int.Parse(dt.Rows[0]["ACOUNT"].ToString()) > 0)
            {
                MessageUtil.ShowTips("此炉【" + heatNo + "】物料状态有改变,不允许调整位置!");
                return;
            }
            DataTable ds = new DataTable();
            ds.Clear();
            ds = dataTable2.Clone();
            ds.ImportRow(dataTable2.Rows[m]);
            frmPipeMoveStoreButress moveButress = new frmPipeMoveStoreButress(this.ob);
            moveButress.Dt = ds;
            moveButress.ShowDialog();
            if (moveButress.buttonValue == "1")
            {
                QueryPipedData();
                MessageUtil.ShowTips("修改成功!");
            }
        }
        /// <summary>
        /// 修改库存位置
        /// </summary>
        private void updateStoreNo()
        {
            ultraGrid4.UpdateData();
            ArrayList parmList = new ArrayList();
            string userName = UserInfo.GetUserName();
            int m = 0;
            int n = 0;
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    if (uRow.Cells["STORAGE_NO"].Text.Trim() == "")
                    {
                        n++;
                    }
                    m++;
                }
            }
            if (m < 1)
            {
                MessageUtil.ShowTips("请选择需要操作的数据!");
                return;
            }
            if (n > 0)
            {
                MessageUtil.ShowTips("仓库名称不能为空!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的数据?") == DialogResult.No)
            {
                return;
            }
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    if (uRow.Cells["MAT_STATUS"].Value.ToString() != "80150301" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150202" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150203" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150204" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150205")
                    {
                        MessageUtil.ShowTips("材料状态已被改变,不允许修改库存地点!");
                        return;
                    }
                    ArrayList list = new ArrayList();
                    list.Add(uRow.Cells["STORAGE_NO"].Value.ToString());
                    //list.Add(uceReson.Value.ToString());
                    list.Add(uRow.Cells["ORDER_NO"].Text.Trim());
                    list.Add(uRow.Cells["ORDER_SEQ"].Text.Trim());
                    list.Add(uRow.Cells["ORDER_SEQ_NO"].Text.Trim());
                    list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_NO"].Text.Trim());
                    list.Add(uRow.Cells["PRODUCNAME"].Text.Trim());
                    //list.Add(uRow.Cells["STD_NAME"].Text.Trim());
                    list.Add(uRow.Cells["STEELNAME"].Text.Trim());
                    list.Add(uRow.Cells["SPEC_NAME"].Text.Trim());
                    list.Add(uRow.Cells["MODEL_DESC"].Text.Trim());
                    list.Add(userName);
                    list.Add(uRow.Cells["ACT_LEN_MIN"].Text.Trim());
                    list.Add(uRow.Cells["ACT_LEN_MAX"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim());
                    if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品")
                    {
                        list.Add("801403");
                    }
                    else if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "成品")
                    {
                        list.Add("801402");
                    }
                    else
                    {
                        list.Add("801401");
                    }
                    list.Add(uRow.Cells["IN_MOLD"].Value.ToString2());
                    list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString2());
                    list.Add(uRow.Cells["UNIT"].Value.ToString2());
                    parmList.Add(list);
                }
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "updateStoreNo";
            ccp.ServerParams = new object[] { parmList };
            ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    QueryPipedData();
                    
                }
            }
        }

        private void Export()
        {
            if (ultraTabControl1.SelectedTab.Key == "0")
            {
                GridHelper.ulGridToExcel(ultraGrid1, "判定数据");
            }
            else if (ultraTabControl1.SelectedTab.Key == "2")
            {
                GridHelper.ulGridToExcel(ultraGrid4, "库存实绩明细");
            }
            else if(ultraTabControl1.SelectedTab.Key == "1")
            {
                GridHelper.ulGridToExcel(ultraGrid3, "缴库实绩明细");
            }
            else if (ultraTabControl1.SelectedTab.Key == "3")
            {
                GridHelper.ulGridToExcel(ultraGrid5, "转移所属权明细");
            }
        }
        /// <summary>
        /// 修改产品区分
        /// </summary>
        private void updateFinishedProduct()
        {
            ultraGrid4.UpdateData();
            ArrayList parmList = new ArrayList();
            string userName = UserInfo.GetUserName();
            int m = 0;
            foreach (UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    m++;
                }
            }
            if (m < 1)
            {
                MessageUtil.ShowTips("请选择需要操作的数据!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的数据?") == DialogResult.No)
            {
                return;
            }
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品")
                    {
                        MessageUtil.ShowTips("材料类别为商品的,不允许修改成品区分!");
                        return;
                    }
                    ArrayList list = new ArrayList();

                    list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_NO"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim());
                    

                    if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品")
                    {
                        list.Add("801403");
                    }
                    else if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "成品")
                    {
                        list.Add("801402");
                    }
                    else
                    {
                        list.Add("801401");
                    }
                    list.Add(uRow.Cells["PIPMEMO"].Value.ToString());
                    list.Add(uRow.Cells["IN_MOLD"].Value.ToString());
                    list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString2());
                    parmList.Add(list);
                }
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "updateFinishedProduct";
            ccp.ServerParams = new object[] { parmList };
            ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {

                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    QueryPipedData();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 修改入库备注
        /// </summary>
        private void updatePipMemo()
        {
            ultraGrid4.UpdateData();
            ArrayList parmList = new ArrayList();
            string userName = UserInfo.GetUserName();
            int m = 0;
            foreach (UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    m++;
                }
            }
            if (m < 1)
            {
                MessageUtil.ShowTips("请选择需要操作的数据!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改选择的数据?") == DialogResult.No)
            {
                return;
            }
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid4.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    if (uRow.Cells["MAT_STATUS"].Value.ToString() != "80150301" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150202" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150203" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150204" && uRow.Cells["MAT_STATUS"].Value.ToString() != "80150205")
                    {
                        MessageUtil.ShowTips("材料状态已被改变,不允许修改入库备注!");
                        return;
                    }
                    ArrayList list = new ArrayList();
                    list.Add(uRow.Cells["PIPMEMO"].Value.ToString());
                    //list.Add(uceReson.Value.ToString());
                    list.Add(uRow.Cells["ORDER_NO"].Text.Trim());
                    list.Add(uRow.Cells["ORDER_SEQ"].Text.Trim());
                    list.Add(uRow.Cells["ORDER_SEQ_NO"].Text.Trim());
                    list.Add(uRow.Cells["JUDGE_STOVE_NO"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_NO"].Text.Trim());
                    list.Add(uRow.Cells["PRODUCNAME"].Text.Trim());
                    //list.Add(uRow.Cells["STD_NAME"].Text.Trim());
                    list.Add(uRow.Cells["STEELNAME"].Text.Trim());
                    list.Add(uRow.Cells["SPEC_NAME"].Text.Trim());
                    list.Add(uRow.Cells["MODEL_DESC"].Text.Trim());
                    list.Add(userName);
                    list.Add(uRow.Cells["ACT_LEN_MIN"].Text.Trim());
                    list.Add(uRow.Cells["ACT_LEN_MAX"].Text.Trim());
                    list.Add(uRow.Cells["BATCH_GROUD_NO"].Text.Trim());
                    if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "商品")
                    {
                        list.Add("801403");
                    }
                    else if (uRow.Cells["PRODUCT_FLAG"].Text.Trim() == "成品")
                    {
                        list.Add("801402");
                    }
                    else
                    {
                        list.Add("801401");
                    }
                    list.Add(uRow.Cells["IN_MOLD"].Value.ToString2());
                    list.Add(uRow.Cells["FINISHPRO_MOLD"].Value.ToString2());
                    list.Add(uRow.Cells["UNIT"].Text.ToString2());
                    parmList.Add(list);
                }
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "updatePipMemo";
            ccp.ServerParams = new object[] { parmList };
            ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    QueryPipedData();
                }
            }
        }
        /// <summary>
        /// 查询库存信息
        /// </summary>
        private void QueryPipedData()
        {
            ArrayList pram = new ArrayList();
            string intimeStart = "";     //缴库起始时间
            string intimeEnd = "";     //缴库结束时间
            string stoveno = "";      //炉号
            string order = "";
            string supplyUnit = this.CustomInfo;
            if (ultraCheckEditor5.Checked)
            {
                intimeStart = StartTime.Value.ToString();
                intimeEnd = EndTime.Value.ToString();
            }
            if (chkJudge.Checked)
            {
                if (cmbJudge.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("炉号不能为空，请选择！");
                    return;
                }
                stoveno = cmbJudge.Text.Trim();
            }
            if (chkOrder.Checked)
            {
                if (cmbOrder.Text.Trim() == "")
                {
                    MessageUtil.ShowTips("合同号不能为空，请选择！");
                    return;
                }
                order = cmbOrder.Text.Trim();
            }
            if (DateTime.Parse(StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString()))
            {
                MessageUtil.ShowTips("开始时间不能大于结束时间！");
                return;
            }
            

            
            pram.Add(stoveno);
            pram.Add(order);
            string userName = UserInfo.GetUserName();
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob);

            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.queryMat", new object[] { pram, arr, intimeStart, intimeEnd, supplyUnit}, this.ob);//MatData
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
            if (toolMenu == null)
            {
                return;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("updateMemo") && supplyUnit.Equals("120504"))
            {
                this.ultraGrid4.DisplayLayout.Bands[0].Columns["UNIT"].EditorComponent = this.chkMatNo;
            }
            
        }
        /// <summary>
        /// 获取实时库存
        /// </summary>
        private void getRealTimeStore()
        {
            string time = DateTime.Now.ToString("dd");
            string bathYear = DateTime.Now.AddMonths(1).ToString("yyyyMM");
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            //if (!time.Equals("26"))
            //{
            //    MessageUtil.ShowTips("此按钮只允许每月26号进行操作!");
            //    return;
            //}
            DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.selectNowInial", new object[] { arr, bathYear }, ob);
            if (int.Parse(ds.Rows[0][0].ToString()) > 0)
            {
            }
            else
            {
                MessageUtil.ShowTips("无本月期初数据,不允许获取期初库存!");
                return;
            }

            int count = ServerHelper.SetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.getRealTimeStore", new object[] { arr, bathYear,this.CustomInfo }, ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("获取实时期末库存成功!");
            }

        }
        /// <summary>
        /// 查询未审批数据
        /// </summary>
        private void doQueryChangeData()
        {
            string jugeNo = "";
            string startTim = "";
            string endTim = "";
            string valueFlag = "";
            if (this.changeJudgeChk.Checked && this.changeJudgeTxt.Text.Trim() != "")
            {
                jugeNo = this.changeJudgeTxt.Text.Trim();
            }
            if (this.changeTimChk.Checked)
            {
                if (DateTime.Parse(this.changeStartTime.Value.ToString()) > DateTime.Parse(this.changeEndTim.Value.ToString()))
                {
                    MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!");
                    return;
                }
                else
                {
                    startTim = this.changeStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                    endTim = this.changeEndTim.Value.ToString("yyyy-MM-dd HH:mm:ss");
                }
            }

            valueFlag = this.ultraOptionSet2.CheckedItem.DataValue.ToString();
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob);
            ArrayList list = new ArrayList();
            list.Add(jugeNo);

            List<YdmZcChangebelongEntity> listSource = EntityHelper.GetData<YdmZcChangebelongEntity>(
            "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryChangeData", new object[] { list, startTim, endTim, valueFlag, arr }, this.ob);
            ydmZcChangebelongEntityBindingSource.DataSource = listSource;
        }
        /// <summary>
        /// 查询判定信息
        /// </summary>
        private void doQueryJudge()
        {
            string jugeNo = "";
            string startTim = "";
            string endTim = "";
            string valueFlag = "";
            string orderNo = "";
            string supplyUnit = this.CustomInfo;
            if (this.chkJudgeStoveNo.Checked && this.uteJudgeStoveNo.Text.Trim() != "")
            {
                jugeNo = this.uteJudgeStoveNo.Text.Trim();
            }
            if (this.chkOrderNo1.Checked && this.chkOrderNo1.Text.Trim() != "")
            {
                orderNo = this.uteOrderNo.Text.Trim();
            }
            if (this.chkDate.Checked)
            {
                if (DateTime.Parse(cmbDate.Value.ToString()) > DateTime.Parse(this.cmbEndDate.Value.ToString()))
                {
                    MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!");
                    return;
                }
                else
                {
                    startTim = this.cmbDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
                    endTim = this.cmbEndDate.Value.ToString("yyyy-MM-dd HH:mm:ss");
                }
            }

            valueFlag = this.ultraOptionSet1.CheckedItem.DataValue.ToString();
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob);
            ArrayList list = new ArrayList();
            list.Add(jugeNo);
            PlnSaleordEntitybindingSource.Clear();
            List<QcmZgJugdeApplyEntity> listSource = EntityHelper.GetData<QcmZgJugdeApplyEntity>(
            "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryApplyJudge", new object[] { list, startTim, endTim, valueFlag, arr, supplyUnit, orderNo }, this.ob);
            QcmZgJugdeApplyEntitybindingSource.DataSource = listSource;
        }
        /// <summary>
        /// 查询缴库实绩
        /// </summary>
        private void doQueryInList()
        {
            string heatNo = "";
            string orderNo = "";
            string startTim = "";
            string endTim = "";
            string bathYear = "";
            string supplyUnit = this.CustomInfo;
            ArrayList list = new ArrayList();
            if (this.chkTim.Checked)
            {
                startTim = this.dtSatrtTim.Value.ToString("yyyy-MM-dd");
                endTim = this.dtEndTim.Value.ToString("yyyy-MM-dd");
            }
            if (this.chkJudgeNo1.Checked)
            {
                if (this.txtJudgeNo1.Text == "")
                {
                    MessageUtil.ShowTips("请输入判定炉号!");
                    return;
                }
                else
                {
                    heatNo = this.txtJudgeNo1.Text.Trim();
                }
            }
            if (chkOrderNo.Checked)
            {
                if (this.txtOrderNo.Text == "")
                {
                    MessageUtil.ShowTips("请输入合同号!");
                    return;
                }
                else
                {
                    orderNo = this.txtOrderNo.Text.Trim();
                }
            }
            if (chkBathYear.Checked)
            {
                bathYear = this.dtBathYear.Value.ToString("yyyyMM");
            }
            list.Add(heatNo);
            list.Add(orderNo);
            list.Add(bathYear);
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, this.ob);
            List<YdmZcInlistEntity> listSource = EntityHelper.GetData<YdmZcInlistEntity>(
            "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryInList", new object[] { list, startTim, endTim, arr, supplyUnit}, this.ob);
            ydmZcInlistEntityBindingSource.DataSource = listSource;
        }
        /// <summary>
        /// 确认
        /// </summary>
        private void doFrim()
        {
            this.ultraGrid1.UpdateData();
            this.ultraGrid2.UpdateData();
            string orderUnit = "";//长度单位
            double dbOrderMax = 0;//合同订货量上限
            double reckonWgt = 0;//估算量上限
            string gSwgt = "";//合同估算总量
            string pipSwgt = "";//合同缴库总量
            string dSwgt = "";//订货总量
            double strWgt = 0;//炉重
            double endWgt = 0;//已缴库量
            double orderWgt = 0;//合同量
            string buttonValue = "";//返回的按钮值
            string frmcount = "";//返回的支数
            string frmWgt = "";//返回的重量值
            string[] wgtList = new string[3];
            string frmFinishedCode = "";
            string finishproMold = "";//成品区分
            string orderType = "";
            string storageNo = "";
            //string storageNo = this.cmbStorage.Value.ToString2();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            UltraGridRow orderRow = this.ultraGrid2.ActiveRow;
            if (uRow == null)
            {
                return;
            }
            if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("B")
                && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" || uRow.Cells["InStorageFlag"].Text.ToString2() == ""))
            {
                if (MessageUtil.ShowYesNoAndQuestion("成品判定为合同超量,是否继续缴库?") == DialogResult.No)
                {
                    return;
                }
            }
            if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("C") 
                && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" ||  uRow.Cells["InStorageFlag"].Text.ToString2() == ""))
            {
                if (MessageUtil.ShowYesNoAndQuestion("成品判定为非正尺超量,是否继续缴库?") == DialogResult.No)
                {
                    return;
                }
            }
            //if (storageNo == "")
            //{
            //    MessageUtil.ShowTips("请选择缴库仓库!");
            //    return;
            //}
            strWgt = double.Parse(uRow.Cells["ActWeight"].Text.ToString());
            QcmZgJugdeApplyEntity qcmZgEntity = (QcmZgJugdeApplyEntity)uRow.ListObject;

            if (orderRow != null)
            {
                orderType = doQueryOrderType(orderRow.Cells["OrderNo"].Text.Trim());
                //if (orderType.Equals("120103"))
                //{
                //    MessageUtil.ShowTips("该合同为研发合同,不允许缴库!");
                //    return;
                //}
                //else if (orderType.Equals("120104"))
                //{
                //    MessageUtil.ShowTips("该合同为预排合同,只允许缴库成成品!");
                //    return;
                //}

                orderUnit = orderRow.Cells["OrderUnit"].Text.Trim();
                endWgt = double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3());// 已缴库量
                orderWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3());
                string strRANGE_MIN = orderRow.Cells["DelvryRangeMin"].Text.Trim();//交货量差下限
                string strRANGE_MAX = orderRow.Cells["DelvryRangeMax"].Text.Trim();//交货量差上限
                double dbQtyMin = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) - double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MIN) / 100);//合同行下限值
                double dbQtyMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//合同行上限值
                double dbJhMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//交货量差上限值
                if (orderUnit.Contains("支") || orderUnit.Equals("吨"))
                {
                    dbOrderMax = double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);
                }
                else if (orderUnit.Contains("磅"))
                {
                    dbOrderMax = Math.Round(double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 * (double.Parse(strRANGE_MAX) / 100), 3);
                }
                wgtList = getOrderWgt(orderRow.Cells["OrderNo"].Text.ToString());
                if (wgtList.Length > 0)
                {
                    gSwgt = wgtList[0];
                    pipSwgt = wgtList[1];
                    dSwgt = wgtList[2];
                }
                if (orderUnit.Equals("吨") || orderUnit.Equals("支") || orderUnit.Contains("磅"))
                {
                    if (endWgt > dbOrderMax)
                    {
                        if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No)
                        {
                            return;
                        }
                        frmBatchesPip frm = new frmBatchesPip(ob);
                        frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                        frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                        if (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0)
                        {
                            frm.SxWgt = "0";
                        }
                        else
                        {
                            frm.SxWgt = (dbQtyMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                        }
                        frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                        frm.ShowDialog();
                        buttonValue = frm.buttonValue;
                        frmcount = frm.count;
                        frmWgt = frm.outWgt;
                        frmFinishedCode = frm.finishedProduct;
                        if (!frm.flag)
                        {
                            return;
                        }


                        if (buttonValue == "0")
                        {
                            return;
                        }
                        if (buttonValue == "2")
                        {
                            if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                            {
                                MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                return;
                            }
                            if (double.Parse(frmWgt) + endWgt > dbOrderMax)
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                            if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                        }
                        if (buttonValue == "1")
                        {
                            if ((strWgt + endWgt) > dbOrderMax)
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                            if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                        }
                    }
                    else
                    {
                        if ((strWgt + endWgt) > dbOrderMax)
                        {
                            frmBatchesPip frm = new frmBatchesPip(ob);
                            frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                            frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                            frm.SxWgt = (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                            frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                            frm.ShowDialog();
                            buttonValue = frm.buttonValue;
                            frmcount = frm.count;
                            frmWgt = frm.outWgt;
                            frmFinishedCode = frm.finishedProduct;
                            if (!frm.flag)
                            {
                                return;
                            }


                            if (buttonValue == "0")
                            {
                                return;
                            }
                            if (buttonValue == "2")
                            {
                                if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                                {
                                    MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                    return;
                                }
                                if (double.Parse(frmWgt) + endWgt > dbOrderMax)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                            if (buttonValue == "1")
                            {
                                if ((strWgt + endWgt) > dbOrderMax)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                        }
                        else
                        {
                            frmcount = qcmZgEntity.ActCount.ToString2();
                        }
                    }
                }
                else if (orderUnit.Equals("英尺") || orderUnit.Equals("米"))
                {
                    if (orderRow.Cells["Orderweight"].Value.ToString() == "")
                    {
                        MessageUtil.ShowTips("此合同【" + uRow.Cells["ProOrderNo"].Text + "】是以英尺为交货单位!,估算量为空不能缴库!");
                        return;
                    }
                    reckonWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) * (double.Parse(strRANGE_MAX) / 100);//估算量上限
                    if (endWgt > reckonWgt)
                    {
                        if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No)
                        {
                            return;
                        }
                        frmBatchesPip frm = new frmBatchesPip(ob);
                        frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                        frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                        if (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0)
                        {
                            frm.SxWgt = "0";
                        }
                        else
                        {
                            frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                        }

                        frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                        frm.ShowDialog();
                        buttonValue = frm.buttonValue;
                        frmcount = frm.count;
                        frmWgt = frm.outWgt;
                        frmFinishedCode = frm.finishedProduct;
                        if (!frm.flag)
                        {
                            return;
                        }


                        if (buttonValue == "0")
                        {
                            return;
                        }
                        if (buttonValue == "2")
                        {
                            if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                            {
                                MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                return;
                            }
                            if (double.Parse(frmWgt) + endWgt > reckonWgt)
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                            if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                        }
                        if (buttonValue == "1")
                        {
                            if ((strWgt + endWgt) > reckonWgt)
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                            if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                        }
                    }
                    else
                    {
                        if ((strWgt + endWgt) > reckonWgt)
                        {
                            frmBatchesPip frm = new frmBatchesPip(ob);
                            frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                            frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                            frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                            frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                            frm.ShowDialog();
                            buttonValue = frm.buttonValue;
                            frmcount = frm.count;
                            frmWgt = frm.outWgt;
                            frmFinishedCode = frm.finishedProduct;
                            if (!frm.flag)
                            {
                                return;
                            }


                            if (buttonValue == "0")
                            {
                                return;
                            }
                            if (buttonValue == "2")
                            {
                                if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                                {
                                    MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                    return;
                                }
                                if (double.Parse(frmWgt) + endWgt > reckonWgt)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                            if (buttonValue == "1")
                            {
                                if ((strWgt + endWgt) > reckonWgt)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                        }
                        else
                        {
                            frmcount = qcmZgEntity.ActCount.ToString2();
                        }
                    }
                }
                if (buttonValue == "1")
                {
                    finishproMold = "801703";
                    frmcount = qcmZgEntity.ActCount.ToString3();
                }
                else if (buttonValue == "2")
                {
                    finishproMold = "801701";
                }
            }
            else
            {
                frmcount = "-1";
            }
            string qcmEntity = JSONFormat.Format(qcmZgEntity);
            PlnSaleordEntity plnSaleEntity = new PlnSaleordEntity();
            if (orderRow != null)
            {
                plnSaleEntity = (PlnSaleordEntity)orderRow.ListObject;
            }
            string plnOrderEntity = JSONFormat.Format(plnSaleEntity);

            if (this.CustomInfo.Equals("120501") && !qcmZgEntity.ProOrderNo.StartsWith(plnSaleEntity.OrderNo))
            {
                MessageUtil.ShowTips("生产合同与缴库合同不一致，无法缴库!");
                return;
            }

            ArrayList parmList = new ArrayList();
            parmList.Add(storageNo);//仓库号
            parmList.Add(finishproMold);//入库区分
            parmList.Add(this.txt_Ks.Value.ToString2());//捆数
            parmList.Add(this.txtMemo.Text);//入库备注
            parmList.Add(this.UserInfo.GetUserName());
            parmList.Add(this.UserInfo.GetDeptid());
            parmList.Add(this.UserInfo.GetDepartment());
            parmList.Add(ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob));
            parmList.Add(ClsBaseInfo.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob));
            parmList.Add(frmcount.ToString3());

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "doFrim";
            ccp.ServerParams = new object[] { qcmEntity, plnOrderEntity, parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("缴库成功!"))
                {
                    doQueryJudge();
                    this.txt_Ks.Value = "0";
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }

        }

        private void doFrim1()
        {
            this.ultraGrid1.UpdateData();
            this.ultraGrid2.UpdateData();
            string orderUnit = "";//长度单位
            double dbOrderMax = 0;//合同订货量上限
            double reckonWgt = 0;//估算量上限
            string gSwgt = "";//合同估算总量
            string pipSwgt = "";//合同缴库总量
            string dSwgt = "";//订货总量
            double strWgt = 0;//炉重
            double endWgt = 0;//已缴库量
            double orderWgt = 0;//合同量
            string buttonValue = "";//返回的按钮值
            string frmcount = "";//返回的支数
            string frmWgt = "";//返回的重量值
            string[] wgtList = new string[3];
            string frmFinishedCode = "";
            string finishproMold = "";//成品区分
            string orderType = "";
            string storageNo = "";
            //string storageNo = this.cmbStorage.Value.ToString2();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            UltraGridRow orderRow = this.ultraGrid2.ActiveRow;
            if (uRow == null)
            {
                return;
            }
            if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("B")
                && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" || uRow.Cells["InStorageFlag"].Text.ToString2() == ""))
            {
                if (MessageUtil.ShowYesNoAndQuestion("成品判定为合同超量,是否继续缴库?") == DialogResult.No)
                {
                    return;
                }
            }
            if (this.CustomInfo.Equals("120501") && uRow.Cells["InStorageType"].Text.ToString().Equals("C")
                && (uRow.Cells["InStorageFlag"].Text.ToString2() == "0" || uRow.Cells["InStorageFlag"].Text.ToString2() == ""))
            {
                if (MessageUtil.ShowYesNoAndQuestion("成品判定为非正尺超量,是否继续缴库?") == DialogResult.No)
                {
                    return;
                }
            }
            //if (storageNo == "")
            //{
            //    MessageUtil.ShowTips("请选择缴库仓库!");
            //    return;
            //}
            strWgt = double.Parse(uRow.Cells["ActWeight"].Text.ToString());
            QcmZgJugdeApplyEntity qcmZgEntity = (QcmZgJugdeApplyEntity)uRow.ListObject;

            if (orderRow != null)
            {
                orderType = doQueryOrderType(orderRow.Cells["OrderNo"].Text.Trim());
                //if (orderType.Equals("120103"))
                //{
                //    MessageUtil.ShowTips("该合同为研发合同,不允许缴库!");
                //    return;
                //}
                //else if (orderType.Equals("120104"))
                //{
                //    MessageUtil.ShowTips("该合同为预排合同,只允许缴库成成品!");
                //    return;
                //}

                orderUnit = orderRow.Cells["OrderUnit"].Text.Trim();
                endWgt = double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3());// 已缴库量
                orderWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3());// 估算量
                string strRANGE_MIN = orderRow.Cells["DelvryRangeMin"].Text.Trim();//交货量差下限
                string strRANGE_MAX = orderRow.Cells["DelvryRangeMax"].Text.Trim();//交货量差上限
                double dbQtyMin = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) - double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MIN) / 100);//合同行下限值
                double dbQtyMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//合同行上限值
                double dbJhMax = double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);//交货量差上限值
               
                string strSHRT_LEN_RATO = orderRow.Cells["ShrtLenRato"].Text.Trim().ToString3();//短尺率
                string strLONG_LEN_RATO = orderRow.Cells["LongLenRato"].Text.Trim().ToString3();//长尺率
                double dbShrtLenRato = orderWgt * (double.Parse(strSHRT_LEN_RATO) / 100);//短尺上限
                double dbLongLenRato = orderWgt * (double.Parse(strLONG_LEN_RATO) / 100);//长尺上限
                string shortest = orderRow.Cells["SHORTEST"].Text.Trim().ToString2();//短尺最短
                string longest = orderRow.Cells["LONGEST"].Text.Trim().ToString2();//长尺最长

                bool normalRuler = true; // 是否按正常尺缴库

                if (double.Parse(orderRow.Cells["lengthmax"].Value.ToString3()) - double.Parse(uRow.Cells["ActLenMax"].Text.ToString3()) > 2
                    || double.Parse(uRow.Cells["ActLenMax"].Text.ToString3()) - double.Parse(orderRow.Cells["lengthmax"].Value.ToString3()) > 2
                    || double.Parse(orderRow.Cells["lengthmin"].Value.ToString3()) - double.Parse(uRow.Cells["ActLenMin"].Text.ToString3()) > 2
                    || double.Parse(uRow.Cells["ActLenMin"].Text.ToString3()) - double.Parse(orderRow.Cells["lengthmin"].Value.ToString3()) > 2)
                {
                    if (MessageUtil.ShowYesNoAndQuestion("长度差值大于2,是否按正常尺继续缴库?") == DialogResult.No)
                    {
                        normalRuler = true;
                    }
                    else {
                        txtMemo.Text = "";
                        normalRuler = false;
                    }
                }

                if (uRow.Cells["InLengthType"].Text.ToString2().Equals("短尺") || uRow.Cells["InLengthType"].Text.ToString2().Equals("长尺") && normalRuler)
                {
                    bool flag = false;
                    if (!string.IsNullOrEmpty(shortest) &&  double.Parse(uRow.Cells["ActLenMax"].Text.ToString3()) <= double.Parse(shortest.ToString3()))
                    {
                        flag = true;
                        if (MessageUtil.ShowYesNoAndQuestion("此合同行长度小于短尺最短,是否继续缴库?") == DialogResult.No)
                        {
                            return;
                        }
                    }
                    if (!string.IsNullOrEmpty(longest) && double.Parse(uRow.Cells["ActLenMin"].Text.ToString3()) >= double.Parse(longest.ToString3()))
                    {
                        flag = true;
                        if (MessageUtil.ShowYesNoAndQuestion("此合同行长度大于长尺最长,是否继续缴库?") == DialogResult.No)
                        {
                            return;
                        }
                    }

                    if (orderUnit.Contains("支") || orderUnit.Equals("吨"))
                    {
                        dbOrderMax = double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);
                    }
                    else if (orderUnit.Contains("磅"))
                    {
                        dbOrderMax = Math.Round(double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 * (double.Parse(strRANGE_MAX) / 100), 3);
                    }
                    if (endWgt > dbOrderMax)
                    {
                        frmcount = "-3";
                        if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No)
                        {
                            return;
                        }
                        frmBatchesPip frm = new frmBatchesPip(ob);
                        frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                        frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                        if (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0)
                        {
                            frm.SxWgt = "0";
                        }
                        else
                        {
                            frm.SxWgt = (dbQtyMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                        }
                        frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                        frm.ShowDialog();
                        buttonValue = frm.buttonValue;
                        frmcount = frm.count;
                        frmWgt = frm.outWgt;
                        frmFinishedCode = frm.finishedProduct;
                        if (!frm.flag)
                        {
                            return;
                        }
                        finishproMold = "801701";
                        if (buttonValue == "1")
                        {
                            if ((strWgt + endWgt) > dbOrderMax)
                            {
                                if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                {
                                    return;
                                }
                            }
                            frmcount = qcmZgEntity.ActCount.ToString3();
                        }
                    } else if (double.Parse(strSHRT_LEN_RATO) <= 0 && double.Parse(strLONG_LEN_RATO) <= 0)
                    {
                        frmcount = "-2";
                    } 
                    else {
                        frmcount = qcmZgEntity.ActCount.ToString3();
                    }

                    if (double.Parse(strSHRT_LEN_RATO) <= 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("短尺"))
                    {
                        frmcount = "-2";
                        if (MessageUtil.ShowYesNoAndQuestion("此合同行短尺率为零,是否继续缴库?") == DialogResult.No)
                        {
                            return;
                        }
                    }
                    if (double.Parse(strLONG_LEN_RATO) <= 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("长尺"))
                    {
                        frmcount = "-2";
                        if (MessageUtil.ShowYesNoAndQuestion("此合同行长尺率为零,是否继续缴库?") == DialogResult.No)
                        {
                            return;
                        }
                    }
                    if (!flag && finishproMold != "801701" && double.Parse(strSHRT_LEN_RATO) > 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("短尺"))
                    {
                        endWgt = double.Parse(orderRow.Cells["Paydownweightshort"].Value.ToString());
                        dbOrderMax = dbShrtLenRato;
                        if (strWgt + endWgt > dbShrtLenRato)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("此合同行短尺缴库量已超出短尺率上限,是否继续缴库?") == DialogResult.No)
                            {
                                return;
                            }
                            frmBatchesPip frm = new frmBatchesPip(ob,"2");
                            frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                            frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                            if (dbShrtLenRato - endWgt < 0)
                            {
                                frm.SxWgt = "0";
                            }
                            else
                            {
                                frm.SxWgt = (dbShrtLenRato - endWgt).ToString();
                            }
                            frm.PipWgt = orderRow.Cells["Paydownweightshort"].Value.ToString3();
                            frm.ShowDialog();
                            buttonValue = frm.buttonValue;
                            frmcount = frm.count;
                            frmWgt = frm.outWgt;
                            frmFinishedCode = frm.finishedProduct;
                            if (!frm.flag)
                            {
                                return;
                            }
                        }
                    }
                    else if (!flag && finishproMold != "801701" && double.Parse(strLONG_LEN_RATO) > 0 && uRow.Cells["InLengthType"].Text.ToString2().Equals("长尺"))
                    {
                        endWgt = double.Parse(orderRow.Cells["Paydownweightlong"].Value.ToString());
                        dbOrderMax = dbShrtLenRato;
                        if (strWgt + endWgt > dbShrtLenRato)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("此合同行长尺缴库量已超出长尺率上限,是否继续缴库?") == DialogResult.No)
                            {
                                return;
                            }
                            frmBatchesPip frm = new frmBatchesPip(ob,"2");
                            frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                            frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                            if (dbShrtLenRato - endWgt < 0)
                            {
                                frm.SxWgt = "0";
                            }
                            else
                            {
                                frm.SxWgt = (dbShrtLenRato - endWgt).ToString();
                            }
                            frm.PipWgt = orderRow.Cells["Paydownweightlong"].Value.ToString3();
                            frm.ShowDialog();
                            buttonValue = frm.buttonValue;
                            frmcount = frm.count;
                            frmWgt = frm.outWgt;
                            frmFinishedCode = frm.finishedProduct;
                            if (!frm.flag)
                            {
                                return;
                            }
                        }
                    }
                    if (flag)
                    {
                        frmcount = "-1";
                    }

                    if (buttonValue == "0")
                    {
                        return;
                    }
                    if (buttonValue == "2")
                    {
                        if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                        {
                            MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                            return;
                        }
                        if (double.Parse(frmWgt) + endWgt > dbOrderMax)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行量差上线,是否继续缴库?") == DialogResult.No)
                            {
                                return;
                            }
                        }
                    }
                    if (buttonValue == "1")
                    {
                        if ((strWgt + endWgt) > dbOrderMax)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                            {
                                return;
                            }
                        }
                        frmcount = qcmZgEntity.ActCount.ToString3();
                    }
                }
                else {
                    if (orderUnit.Contains("支") || orderUnit.Equals("吨"))
                    {
                        dbOrderMax = double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * (double.Parse(strRANGE_MAX) / 100);
                    }
                    else if (orderUnit.Contains("磅"))
                    {
                        dbOrderMax = Math.Round(double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 + double.Parse(orderRow.Cells["OrderQty"].Value.ToString()) * 0.45359 / 1000 * (double.Parse(strRANGE_MAX) / 100), 3);
                    }
                    wgtList = getOrderWgt(orderRow.Cells["OrderNo"].Text.ToString());
                    if (wgtList.Length > 0)
                    {
                        gSwgt = wgtList[0];
                        pipSwgt = wgtList[1];
                        dSwgt = wgtList[2];
                    }
                    if (orderUnit.Equals("吨") || orderUnit.Equals("支") || orderUnit.Contains("磅"))
                    {
                        if (endWgt > dbOrderMax)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No)
                            {
                                return;
                            }
                            frmBatchesPip frm = new frmBatchesPip(ob);
                            frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                            frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                            if (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0)
                            {
                                frm.SxWgt = "0";
                            }
                            else
                            {
                                frm.SxWgt = (dbQtyMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                            }
                            frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                            frm.ShowDialog();
                            buttonValue = frm.buttonValue;
                            frmcount = frm.count;
                            frmWgt = frm.outWgt;
                            frmFinishedCode = frm.finishedProduct;
                            if (!frm.flag)
                            {
                                return;
                            }


                            if (buttonValue == "0")
                            {
                                return;
                            }
                            if (buttonValue == "2")
                            {
                                if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                                {
                                    MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                    return;
                                }
                                if (double.Parse(frmWgt) + endWgt > dbOrderMax)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                            if (buttonValue == "1")
                            {
                                if ((strWgt + endWgt) > dbOrderMax)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                        }
                        else
                        {
                            if ((strWgt + endWgt) > dbOrderMax)
                            {
                                frmBatchesPip frm = new frmBatchesPip(ob);
                                frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                                frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                                frm.SxWgt = (dbOrderMax - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                                frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                                frm.ShowDialog();
                                buttonValue = frm.buttonValue;
                                frmcount = frm.count;
                                frmWgt = frm.outWgt;
                                frmFinishedCode = frm.finishedProduct;
                                if (!frm.flag)
                                {
                                    return;
                                }


                                if (buttonValue == "0")
                                {
                                    return;
                                }
                                if (buttonValue == "2")
                                {
                                    if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                                    {
                                        MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                        return;
                                    }
                                    if (double.Parse(frmWgt) + endWgt > dbOrderMax)
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                    if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                }
                                if (buttonValue == "1")
                                {
                                    if ((strWgt + endWgt) > dbOrderMax)
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                    if ((strWgt + double.Parse(pipSwgt)) > double.Parse(dSwgt))
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                }
                            }
                            else
                            {
                                frmcount = qcmZgEntity.ActCount.ToString2();
                            }
                        }
                    }
                    else if (orderUnit.Equals("英尺") || orderUnit.Equals("米"))
                    {
                        if (orderRow.Cells["Orderweight"].Value.ToString() == "")
                        {
                            MessageUtil.ShowTips("此合同【" + uRow.Cells["ProOrderNo"].Text + "】是以英尺为交货单位!,估算量为空不能缴库!");
                            return;
                        }
                        reckonWgt = double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) + double.Parse(orderRow.Cells["Orderweight"].Value.ToString3()) * (double.Parse(strRANGE_MAX) / 100);//估算量上限
                        if (endWgt > reckonWgt)
                        {
                            if (MessageUtil.ShowYesNoAndQuestion("此合同行缴库量已超出交货量上限,是否继续缴库?") == DialogResult.No)
                            {
                                return;
                            }
                            frmBatchesPip frm = new frmBatchesPip(ob);
                            frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                            frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                            if (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3()) < 0)
                            {
                                frm.SxWgt = "0";
                            }
                            else
                            {
                                frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                            }

                            frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                            frm.ShowDialog();
                            buttonValue = frm.buttonValue;
                            frmcount = frm.count;
                            frmWgt = frm.outWgt;
                            frmFinishedCode = frm.finishedProduct;
                            if (!frm.flag)
                            {
                                return;
                            }


                            if (buttonValue == "0")
                            {
                                return;
                            }
                            if (buttonValue == "2")
                            {
                                if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                                {
                                    MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                    return;
                                }
                                if (double.Parse(frmWgt) + endWgt > reckonWgt)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                            if (buttonValue == "1")
                            {
                                if ((strWgt + endWgt) > reckonWgt)
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                                if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                                {
                                    if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                    {
                                        return;
                                    }
                                }
                            }
                        }
                        else
                        {
                            if ((strWgt + endWgt) > reckonWgt)
                            {
                                frmBatchesPip frm = new frmBatchesPip(ob);
                                frm.AllCount = uRow.Cells["ActCount"].Text.Trim();
                                frm.AllWgt = uRow.Cells["ActWeight"].Text.Trim();
                                frm.SxWgt = (reckonWgt - double.Parse(orderRow.Cells["Paydownweight"].Value.ToString3())).ToString();
                                frm.PipWgt = orderRow.Cells["Paydownweight"].Value.ToString3();
                                frm.ShowDialog();
                                buttonValue = frm.buttonValue;
                                frmcount = frm.count;
                                frmWgt = frm.outWgt;
                                frmFinishedCode = frm.finishedProduct;
                                if (!frm.flag)
                                {
                                    return;
                                }


                                if (buttonValue == "0")
                                {
                                    return;
                                }
                                if (buttonValue == "2")
                                {
                                    if (int.Parse(frmcount) > int.Parse(uRow.Cells["ActCount"].Text.Trim()))
                                    {
                                        MessageUtil.ShowTips("分批缴库支数不能大于现有支数!");
                                        return;
                                    }
                                    if (double.Parse(frmWgt) + endWgt > reckonWgt)
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库量还是大于合同行交货量差上线,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                    if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                }
                                if (buttonValue == "1")
                                {
                                    if ((strWgt + endWgt) > reckonWgt)
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同行总量,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                    if ((strWgt + double.Parse(pipSwgt)) > double.Parse(gSwgt))
                                    {
                                        if (MessageUtil.ShowYesNoAndQuestion("缴库总量大于合同总量,是否继续缴库?") == DialogResult.No)
                                        {
                                            return;
                                        }
                                    }
                                }
                            }
                            else
                            {
                                frmcount = qcmZgEntity.ActCount.ToString2();
                            }
                        }
                    }
                    if (buttonValue == "1")
                    {
                        finishproMold = "801703";
                        frmcount = qcmZgEntity.ActCount.ToString3();
                    }
                    else if (buttonValue == "2")
                    {
                        finishproMold = "801701";
                    }
                }
            }
            else
            {
                frmcount = "-1";
            }
            string qcmEntity = JSONFormat.Format(qcmZgEntity);
            PlnSaleordEntity plnSaleEntity = new PlnSaleordEntity();
            if (orderRow != null)
            {
                plnSaleEntity = (PlnSaleordEntity)orderRow.ListObject;
            }
            string plnOrderEntity = JSONFormat.Format(plnSaleEntity);

            if (this.CustomInfo.Equals("120501") && !qcmZgEntity.ProOrderNo.StartsWith(plnSaleEntity.OrderNo))
            {
                MessageUtil.ShowTips("生产合同与缴库合同不一致，无法缴库!");
                return;
            }

            ArrayList parmList = new ArrayList();
            parmList.Add(storageNo);//仓库号
            parmList.Add(finishproMold);//入库区分
            parmList.Add(this.txt_Ks.Value.ToString2());//捆数
            parmList.Add(this.txtMemo.Text);//入库备注
            parmList.Add(this.UserInfo.GetUserName());
            parmList.Add(this.UserInfo.GetDeptid());
            parmList.Add(this.UserInfo.GetDepartment());
            parmList.Add(ClsBaseInfo.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob));
            parmList.Add(ClsBaseInfo.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob));
            parmList.Add(frmcount.ToString3());

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "doFrim";
            ccp.ServerParams = new object[] { qcmEntity, plnOrderEntity, parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("缴库成功!"))
                {
                    doQueryJudge();
                    this.txt_Ks.Value = "0";
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }

        }

        /// <summary>
        /// 查询合同类型
        /// </summary>
        /// <param name="orderNo"></param>
        /// <param name="orderSeq"></param>
        private string doQueryOrderType(string orderNo)
        {
            string orderType = "";
            //判断合同类型
            DataTable orderDs = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeInTemp.doQueryOrderType", new object[] { orderNo }, ob);
            if (orderDs.Rows.Count > 0)
            {
                orderType = orderDs.Rows[0]["ORDER_TYP"].ToString();
            }
            return orderType;
        }

        /// <summary>
        /// 获取合同总量、已缴库总量、估算总量
        /// </summary>
        /// <param name="orderNo"></param>
        /// <returns></returns>
        private string[] getOrderWgt(string orderNo)
        {
            string[] str = new string[3];
            DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmFinishAfrim.getOrderWgt", new object[] { orderNo }, this.ob);
            if (dt.Rows.Count > 0)
            {
                str[0] = dt.Rows[0]["ORDERWEIGHT"].ToString();//估算量
                str[1] = dt.Rows[0]["PAYDOWNWEIGHT"].ToString();//已缴库量
                str[2] = dt.Rows[0]["ORDER_QTY"].ToString();//订货量
            }
            return str;
        }

        /// <summary>
        /// 调整结转年月
        /// </summary>
        private void updateCarryOverDate()
        {
            this.ultraGrid3.UpdateData();
            string moth = "";
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob);
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要调整结转年月的信息!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                YdmZcInlistEntity ydmEntity = (YdmZcInlistEntity)row.ListObject; 
                moth = DateTime.Parse(row.Cells["BalYearMonth"].Text).AddMonths(1).ToString("yyyyMM");
                ydmEntity.BalYearMonth = row.Cells["BalYearMonth"].Text.Substring(0, 4) + row.Cells["BalYearMonth"].Text.Substring(5, 2);
                ydmEntity.InstockTime = row.Cells["BalYearMonth"].Text.Substring(0, 4) +"-"+ row.Cells["BalYearMonth"].Text.Substring(4, 2) + "-02 12:00:00";
              
                ArrayList _list = new ArrayList();
                _list.Add(moth);
                DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeAdjust.selectYearMoth", new object[] { _list, arr,this.CustomInfo }, ob);
                if (int.Parse(ds.Rows[0]["ACOUNT"].ToString()) > 0)
                {
                    MessageUtil.ShowTips("此炉" + ydmEntity.JudgeStoveNo + "已进行结转,不允许调整结转年月!");
                    return;
                }
                string ydmInListEntity = JSONFormat.Format(ydmEntity);
                parmList.Add(ydmInListEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "updateCarryOverDate";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("调整成功!"))
                {
                    doQueryInList();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        /// <summary>
        /// 取消确认
        /// </summary>
        private void canceDoFrim()
        {
            this.ultraGrid3.UpdateData();
            string moth = "";
            string[] arr = BaseMethod.InitPermissions(this.ValidDataPurviewIds,ob);
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择需要撤销缴库的信息!");
                return;
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                YdmZcInlistEntity ydmEntity = (YdmZcInlistEntity)row.ListObject;

                //DataTable ds = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeInTemp.queryMatNoStatus", new object[] { ydmEntity.OrderNo, ydmEntity.OrderSeq, ydmEntity.DeliveryNo, ydmEntity.JudgeStoveNo, ydmEntity.BatchNo, ydmEntity.BatchGroudNo,ydmEntity.InstockDoc }, this.ob);
                //if (ds.Rows.Count == 0)
                //{
                //    MessageUtil.ShowTips("此炉批组已发运，不允许撤销!");
                //    return;
                //}
                //else if (ds.Rows.Count == 1)
                //{
                //    if (ds.Rows[0].ToString().Equals("80150302"))
                //    {
                //        MessageUtil.ShowWarning("该炉批组的数据不是可编提单状态，无法撤销！");
                //        return;
                //    }

                //}
                //else if (ds.Rows.Count > 1)
                //{
                //    for (int i = 0; i < ds.Rows.Count;i++ )
                //    {
                //        if (ds.Rows[i].ToString().Equals("80150302"))
                //        {
                //            MessageUtil.ShowWarning("该炉批组的数据不是可编提单状态，无法撤销！");
                //            return;
                //        }
                //    }
                    
                //}
                DataTable dd = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.CorePipeInTemp.getLockFlag", new object[] { ydmEntity.JudgeStoveNo, ydmEntity.BatchNo, ydmEntity.BatchGroudNo }, ob);
                if (int.Parse(dd.Rows[0]["ACOUNT"].ToString()) > 0)
                {
                    MessageUtil.ShowTips("炉号：" + ydmEntity.JudgeStoveNo + "、批号:" + ydmEntity.BatchNo + "的数据有被封锁的,不能撤销!");
                    return;
                }
                ArrayList parm = new ArrayList();
                moth = DateTime.Parse(ydmEntity.BalYearMonth).AddMonths(1).ToString("yyyyMM");
                parm.Add(moth);
                DataTable dg = ServerHelper.GetData("com.steering.pss.ydm.pipemanage.FrmPipeAdjust.selectYearMoth", new object[] { parm, arr,this.CustomInfo }, ob);
                if (int.Parse(dg.Rows[0]["ACOUNT"].ToString()) > 0)
                {
                    MessageUtil.ShowTips("此炉【" + row.Cells["JudgeStoveNo"].Text + "】已进行结转,不允许撤销!");
                    return;
                }

                string ydmZcInList = JSONFormat.Format(ydmEntity);
                parmList.Add(ydmZcInList);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.ydm.pipemanage.FrmFinishAfrim";
            ccp.MethodName = "canceDoFrim";
            ccp.ServerParams = new object[] { parmList };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("撤销成功!"))
                {
                    doQueryInList();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbDate.Enabled = this.cmbEndDate.Enabled = this.chkDate.Checked;
        }

        private void chkJudgeStoveNo_CheckedChanged(object sender, EventArgs e)
        {
            this.uteJudgeStoveNo.Enabled = this.chkJudgeStoveNo.Checked;
        }

        private void chkOrderNo1_CheckedChanged(object sender, EventArgs e)
        {
            this.uteOrderNo.Enabled = this.chkOrderNo1.Checked;
        }

        private void chkBathYear_CheckedChanged(object sender, EventArgs e)
        {
            this.dtBathYear.Enabled = this.chkBathYear.Checked;
        }

        private void chkJudgeNo1_CheckedChanged(object sender, EventArgs e)
        {
            this.txtJudgeNo1.Enabled = this.chkJudgeNo1.Checked;
        }

        private void chkOrderNo_CheckedChanged(object sender, EventArgs e)
        {
            this.txtOrderNo.Enabled = this.chkOrderNo.Checked;
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow uRow = ultraGrid1.ActiveRow;
            if (uRow == null) return;
            if (uRow.Cells["InLengthType"].Value.ToString() == "长尺")
            {
                txtMemo.Text = "合同长尺";
            }else if (uRow.Cells["InLengthType"].Value.ToString() == "短尺")
            {
                txtMemo.Text = "合同短尺";
            }
            else {
                txtMemo.Text = "";
            }
            getOrderNo(uRow);
        }

        private void getOrderNo(UltraGridRow ugr)
        {
            string orderSeq = "";
            string orderNm = ugr.Cells["ProOrderNo"].Text.Trim();
            string orderDivePk = ugr.Cells["OrdLnDlyPk"].Text.Trim();
            string orderPk = "";
            if (orderNm != "")
            {
                if (!orderNm.Contains("/"))
                {
                    MessageUtil.ShowTips("此判定数据合同号异常，不允许缴库!");
                    return;
                }
                int i = orderNm.IndexOf("/");
                if (i == -1) return;
                orderSeq = orderNm.Substring(i + 1, orderNm.Length - i - 1).PadLeft(3, '0');
                orderNm = orderNm.Substring(0, i);
                if (!string.IsNullOrWhiteSpace(orderDivePk))
                {
                    orderPk = orderDivePk.Substring(0, orderDivePk.Length - 3);
                }
            }
            else
            {
                orderPk = "";
                //MessageUtil.ShowTips("判定数据合同号为空!,数据异常!");
                //return;
            }
            
            List<PlnSaleordEntity> listSource = EntityHelper.GetData<PlnSaleordEntity>(
            "com.steering.pss.ydm.pipemanage.FrmFinishAfrim.doQueryOrderNo", new object[] { orderNm, orderSeq, orderPk }, this.ob);
            PlnSaleordEntitybindingSource.DataSource = listSource;
        }

        private void FrmFinishAfrim_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (toolMenu.Toolbars[0].Tools.Exists("QueryInList"))
            {
                toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim"))
            {
                toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate"))
            {
                toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("Query2"))
            {
                toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("updateMemo"))
            {
                toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct"))
            {
                toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo"))
            {
                toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress"))
            {
                toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("updateBelong"))
            {
                toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("QueryChange"))
            {
                toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("ChangePass"))
            {
                toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass"))
            {
                toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            ultraLabel2.Visible = false;
            ultraBelong.Visible = false;
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (ultraTabControl1.SelectedTab.Key == "0")
            {
                if (toolMenu == null) return;
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QRJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QXJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate"))
                {
                    toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Query2"))
                {
                    toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateMemo"))
                {
                    toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct"))
                {
                    toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore"))
                {
                    toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo"))
                {
                    toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress"))
                {
                    toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateBelong"))
                {
                    toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryChange"))
                {
                    toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ChangePass"))
                {
                    toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass"))
                {
                    toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                ultraLabel2.Visible = false;
                ultraBelong.Visible = false;
                
            }
            else if (ultraTabControl1.SelectedTab.Key == "1")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate"))
                {
                    toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Query2"))
                {
                    toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateMemo"))
                {
                    toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct"))
                {
                    toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore"))
                {
                    toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo"))
                {
                    toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress"))
                {
                    toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateBelong"))
                {
                    toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryChange"))
                {
                    toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ChangePass"))
                {
                    toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass"))
                {
                    toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QRJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QXJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                ultraLabel2.Visible = false;
                ultraBelong.Visible = false;
            }
            else if (ultraTabControl1.SelectedTab.Key == "2")
            {
                if (toolMenu == null) return;
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate"))
                {
                    toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Query2"))
                {
                    toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateMemo"))
                {
                    toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct"))
                {
                    toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore"))
                {
                    toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo"))
                {
                    toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress"))
                {
                    toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateBelong"))
                {
                    toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryChange"))
                {
                    toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ChangePass"))
                {
                    toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass"))
                {
                    toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QRJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QXJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                ultraLabel2.Visible = true;
                ultraBelong.Visible = true;
            }
            else if (ultraTabControl1.SelectedTab.Key == "3")
            {
                if (toolMenu == null) return;
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["DoFrim"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["QueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("canceDoFrim"))
                {
                    toolMenu.Toolbars[0].Tools["canceDoFrim"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateCarryOverDate"))
                {
                    toolMenu.Toolbars[0].Tools["updateCarryOverDate"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Query2"))
                {
                    toolMenu.Toolbars[0].Tools["Query2"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateMemo"))
                {
                    toolMenu.Toolbars[0].Tools["updateMemo"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateFinishedProduct"))
                {
                    toolMenu.Toolbars[0].Tools["updateFinishedProduct"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("getRealTimeStore"))
                {
                    toolMenu.Toolbars[0].Tools["getRealTimeStore"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateStoreNo"))
                {
                    toolMenu.Toolbars[0].Tools["updateStoreNo"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("adjustStoreButress"))
                {
                    toolMenu.Toolbars[0].Tools["adjustStoreButress"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("updateBelong"))
                {
                    toolMenu.Toolbars[0].Tools["updateBelong"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QueryChange"))
                {
                    toolMenu.Toolbars[0].Tools["QueryChange"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("ChangePass"))
                {
                    toolMenu.Toolbars[0].Tools["ChangePass"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("changeNoPass"))
                {
                    toolMenu.Toolbars[0].Tools["changeNoPass"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QRJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QRJSH"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("QXJSH"))
                {
                    toolMenu.Toolbars[0].Tools["QXJSH"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                ultraLabel2.Visible = false;
                ultraBelong.Visible = false;
            }
        }

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

        private void uteJudgeStoveNo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                doQueryJudge();
            }
        }

        private void ultraCheckEditor5_CheckedChanged(object sender, EventArgs e)
        {
            this.StartTime.Enabled = this.EndTime.Enabled = this.ultraCheckEditor5.Checked;
        }

        private void chkJudge_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbJudge.Enabled = this.chkJudge.Checked;
        }

        private void chkOrder_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbOrder.Enabled = this.chkOrder.Checked;
        }

        private void txtJudgeNo1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                doQueryInList();
            }
        }

        private void txtOrderNo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                doQueryInList();
            }
        }

        private void cmbJudge_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                QueryPipedData();
            }
            
        }

        private void cmbOrder_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                QueryPipedData();
            }
        }

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

        private void changeJudgeChk_CheckedChanged(object sender, EventArgs e)
        {
            this.changeJudgeTxt.Enabled = this.changeJudgeChk.Checked;
        }

        private void changeTimChk_CheckedChanged(object sender, EventArgs e)
        {
            this.changeStartTime.Enabled = this.changeEndTim.Enabled = this.changeTimChk.Checked;
        }

        private void chkMatNo_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow row = this.ultraGrid4.ActiveRow;
            if (row == null)
            {
                return;
            }
            if (row.Cells["MAT_STATUS"].Value.ToString() != "80150301" && row.Cells["MAT_STATUS"].Value.ToString() != "80150202" && row.Cells["MAT_STATUS"].Value.ToString() != "80150203" && row.Cells["MAT_STATUS"].Value.ToString() != "80150204" && row.Cells["MAT_STATUS"].Value.ToString() != "80150205")
            {
                MessageUtil.ShowTips("材料状态已被改变,不允许修改入库备注!");
                return;
            }

            ArrayList list = new ArrayList();
            list.Add(row.Cells["JUDGE_STOVE_NO"].Text.Trim());
            list.Add(row.Cells["BATCH_NO"].Text.Trim());
            list.Add(row.Cells["PRODUCNAME"].Text.Trim());
            list.Add(row.Cells["STEELNAME"].Text.Trim());
            list.Add(row.Cells["SPEC_NAME"].Text.Trim());
            list.Add(row.Cells["MODEL_DESC"].Text.Trim());
            list.Add(row.Cells["BATCH_GROUD_NO"].Text.Trim());
            if (row.Cells["PRODUCT_FLAG"].Text.Trim() == "商品")
            {
                list.Add("801403");
            }
            else if (row.Cells["PRODUCT_FLAG"].Text.Trim() == "成品")
            {
                list.Add("801402");
            }
            else
            {
                list.Add("801401");
            }
            list.Add(row.Cells["IN_MOLD"].Value.ToString2());
            list.Add(row.Cells["FINISHPRO_MOLD"].Value.ToString2());
            FrmMatNo frm = new FrmMatNo(list, ob);
            frm.ShowDialog();
            QueryPipedData();
        }

    }
}