MES_Client/TGMES/Core.StlMes.Client.Mcp.VRP/Vrp/FrmOutSourcApp.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.Mcp.Control.Base;
using Core.StlMes.Client.Mcp.VRP.Entity;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.Mcp.VRP.Vrp
{
    public partial class FrmOutSourcApp : FrmBase
    {
        public FrmOutSourcApp()
        {
            InitializeComponent();
        }
        private string[] plineCode = null;
        private void FrmOutSourcApp_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.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");
            EntityHelper.ShowGridCaption<YdmBcInlistEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            plineCode = comm.GetPlineCode(this.ValidDataPurviewIds, ob);
        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    break;
                case "DoQueryInList":
                    doQueryInList();
                    break;
                case "AppThrough":
                    DoAppThrough();
                    break;
                case "AppNotThrough":
                    DoAppNotThrough();
                    break;
                case "OutsourcReturn":
                    DoOutsourcReturn();
                    break;
                case"CancelOutReturn":
                    cancelOutReturn();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGrid1, "委外审批信息");
                    break;  
                case "OutsourceInStore":
                    OutsourceInStore();
                    break;
                case "CancelOutsourceInStore":
                    CancelOutsourceInStore();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 查询委外交库实绩
        /// </summary>
        private void doQueryInList()
        {
            string lotNo = "";
            string jugeNo = "";
            string startTim = "";
            string endTim = "";
            if (this.chkJugeHeatNo.Checked && this.txtJugeNo.Text.Trim() != "")
            {
                jugeNo = this.txtJugeNo.Text.Trim();
            }
            if (this.chkBatch.Checked && this.txtBatch.Text.Trim() != "")
            {
                lotNo = txtBatch.Text.Trim();
            }
            if (this.chkTim.Checked)
            {
                if (DateTime.Parse(StartTime.Value.ToString()) > DateTime.Parse(EndTime.Value.ToString()))
                {
                    MessageUtil.ShowTips("选择的前面时间不能大于后面的时间!");
                    return;
                }
                else
                {
                    startTim = this.StartTime.Value.ToString("yyyy-MM-dd");
                    endTim = this.EndTime.Value.ToString("yyyy-MM-dd");
                }
            }
            ArrayList list = new ArrayList();
            list.Add(startTim);
            list.Add(endTim);
            list.Add(lotNo);
            list.Add(jugeNo);

            List<YdmBcInlistEntity> listSource = EntityHelper.GetData<YdmBcInlistEntity>(
         "com.steering.mes.mcp.Vrp.FrmOutSourcApp.doQueryInList", new object[] { list, plineCode }, this.ob);
            YdmBcInlistEntitybindingSource.DataSource = listSource;
        }
        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery()
        {
            if (!CheckQuery()) return;

            string startTime = "";
            string endTime = "";
            string judgeNo = "";
            string batchNo = "";
            string strat = "";
            if (chkTim.Checked)
            {
                startTime = StartTime.Value.ToString();
                endTime = EndTime.Value.ToString();
            }
            if (chkJugeHeatNo.Checked)
            {
                judgeNo = txtJugeNo.Text.ToString().Trim();
            }
            if (chkBatch.Checked)
            {
                batchNo = txtBatch.Text.ToString().Trim();
            }
            if (chkStrat.Checked)
            {
                strat = cmbStrat.Value.ToString();
            }
            ArrayList list = new ArrayList();
            list.Add(startTime);
            list.Add(endTime);
            list.Add(judgeNo);
            list.Add(batchNo);
            list.Add(strat);
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Vrp.FrmOutSourcApp.doQuery", new object[] { list }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref dataTable2, true);
        }
        /// <summary>
        /// 审批通过
        /// </summary>
        private void DoAppThrough()
        {
            string plineCode="";
            string plineName = "";
            string spNote = "";
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要审批通过的委外信息!");
                return;
            }
            FrmOutSouCon subCon = new FrmOutSouCon(this.ob);
            if (subCon.ShowDialog() == DialogResult.OK)
            {
               spNote=subCon.Remark;//审批说明
               plineCode = subCon.PlinCode;
               plineName = subCon.PlineName;
            }
            else
            {
                return;
            }
 
            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                ArrayList parm = new ArrayList();
                parm.Add(spNote);
                parm.Add(plineCode);
                parm.Add(plineName);
                parm.Add(row.Cells["SUBCONTRACT_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO_SEQ"].Text.ToString());
                parm.Add(this.UserInfo.GetUserName());
                parm.Add(this.UserInfo.GetUserGroup());
                parm.Add(this.UserInfo.GetUserOrder());
                parm2.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认审批通过？") == DialogResult.No) return;


            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmOutSourcApp";
            ccp.MethodName = "doAppThrough";
            ccp.ServerParams = new object[] { parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("审批通过成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 审批不通过
        /// </summary>
        private void DoAppNotThrough()
        {
            string plineCode = "";
            string plineName = "";
            string spNote = "";
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要审批不通过的委外信息!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认审批不通过？") == DialogResult.No) return;
            FrmOutSouCon subCon = new FrmOutSouCon(this.ob);
            if (subCon.ShowDialog() == DialogResult.OK)
            {
                spNote = subCon.Remark;//审批说明
                plineCode = subCon.PlinCode;
                plineName = subCon.PlineName;
            }
            else
            {
                return;
            }
 
            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                ArrayList parm = new ArrayList();
                parm.Add(spNote);
                parm.Add(plineCode);
                parm.Add(plineName);
                parm.Add(row.Cells["SUBCONTRACT_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO_SEQ"].Text.ToString());
                parm.Add(this.UserInfo.GetUserName());
                parm.Add(this.UserInfo.GetUserGroup());
                parm.Add(this.UserInfo.GetUserOrder());
                parm.Add(row.Cells["RESULT_NO"].Text.ToString());
                parm2.Add(parm);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmOutSourcApp";
            ccp.MethodName = "doAppNotThrough";
            ccp.ServerParams = new object[] { parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("审批不通过成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 委外回报
        /// </summary>
        private void DoOutsourcReturn()
        {

            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要回报的委外信息!");
                return;
            }

            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                if (row.Cells["HB_COMPLETE_NUM"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入委外回报支数！");
                    return;
                }
                if (row.Cells["HB_COMPLETE_WT"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入委外回报重量！");
                    return;
                }

                ArrayList parm = new ArrayList();
                parm.Add(row.Cells["HB_COMPLETE_NUM"].Value.ToString());
                parm.Add(row.Cells["HB_COMPLETE_WT"].Value.ToString());
                parm.Add(row.Cells["HB_FP_NUM"].Text.ToString());
                parm.Add(row.Cells["HB_FP_WT"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO_SEQ"].Text.ToString());
                parm.Add(this.UserInfo.GetUserName());
                parm.Add(this.UserInfo.GetUserGroup());
                parm.Add(this.UserInfo.GetUserOrder());
                parm.Add(row.Cells["RESULT_NO"].Text.ToString());               
                parm2.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认委外回报？") == DialogResult.No) return;


            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmOutSourcApp";
            ccp.MethodName = "doOutsourcReturn";
            ccp.ServerParams = new object[] { parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("委外回报成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 撤销委外完毕
        /// </summary>
        private void cancelOutReturn()
        {

            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要回报的委外信息!");
                return;
            }

            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {           
                ArrayList parm = new ArrayList();
                parm.Add(row.Cells["HB_COMPLETE_NUM"].Value.ToString());
                parm.Add(row.Cells["HB_COMPLETE_WT"].Value.ToString());
                parm.Add(row.Cells["HB_FP_NUM"].Text.ToString());
                parm.Add(row.Cells["HB_FP_WT"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO_SEQ"].Text.ToString());
                parm.Add(this.UserInfo.GetUserName());
                parm.Add(this.UserInfo.GetUserGroup());
                parm.Add(this.UserInfo.GetUserOrder());
                parm.Add(row.Cells["RESULT_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NUM"].Value.ToString());
                parm.Add(row.Cells["SUBCONTRACT_WT"].Value.ToString());
                parm2.Add(parm);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销委外回报？") == DialogResult.No) return;


            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmOutSourcApp";
            ccp.MethodName = "cancelOutsourcReturn";
            ccp.ServerParams = new object[] { parm2 };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("撤销委外回报成功！"))
                {
                    DoQuery();
                }
            }
        }


        /// <summary>
        /// 委外入库
        /// </summary>
        private void OutsourceInStore()
        {
            string plnZyEntity = "";
            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要回报的委外信息!");
                return;
            }
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null)
            {
                return;
            }

            ArrayList parm2 = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                if (row.Cells["HB_COMPLETE_NUM"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入委外回报支数！");
                    return;
                }
                if (row.Cells["HB_COMPLETE_WT"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入委外回报重量！");
                    return;
                }
                if (!row.Cells["SUBCONTRACT_LOG"].Text.ToString().Equals("审核通过"))
                {
                    MessageUtil.ShowTips("不是审批通过状态,不允许委外入库！");
                    return;
                }
                ArrayList parm = new ArrayList();
                parm.Add(row.Cells["HB_COMPLETE_NUM"].Value.ToString());
                parm.Add(row.Cells["HB_COMPLETE_WT"].Value.ToString());
                parm.Add(row.Cells["HB_FP_NUM"].Text.ToString());
                parm.Add(row.Cells["HB_FP_WT"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO_SEQ"].Text.ToString());
                parm.Add(this.UserInfo.GetUserName());
                parm.Add(this.UserInfo.GetUserGroup());
                parm.Add(this.UserInfo.GetUserOrder());
                parm.Add(row.Cells["RESULT_NO"].Text.ToString());
                parm.Add(row.Cells["STATION_CODE"].Text.ToString());
                parm.Add(row.Cells["HEAT_PLAN_NO"].Text.ToString());
                parm.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
                parm.Add(row.Cells["BATCH_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_PLINE_CODE"].Text.ToString());
                parm2.Add(parm);
            }
            ArrayList parmList = new ArrayList();
            foreach (UltraGridRow row in checkMagRows)
            {
                if (row.Cells["HB_COMPLETE_NUM"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入委外回报支数！");
                    return;
                }
                if (row.Cells["HB_COMPLETE_WT"].Value.ToString().Equals("0"))
                {
                    MessageUtil.ShowTips("请输入委外回报重量！");
                    return;
                }

                ArrayList parm = new ArrayList();
                parm.Add(row.Cells["HB_COMPLETE_NUM"].Value.ToString());
                parm.Add(row.Cells["HB_COMPLETE_WT"].Value.ToString());
                parm.Add(row.Cells["HB_FP_NUM"].Text.ToString());
                parm.Add(row.Cells["HB_FP_WT"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_NO_SEQ"].Text.ToString());
                parm.Add(this.UserInfo.GetUserName());
                parm.Add(this.UserInfo.GetUserGroup());
                parm.Add(this.UserInfo.GetUserOrder());
                parm.Add(row.Cells["RESULT_NO"].Text.ToString());
                parm.Add(row.Cells["STATION_CODE"].Text.ToString());
                parm.Add(row.Cells["HEAT_PLAN_NO"].Text.ToString());
                parm.Add(row.Cells["JUDGE_STOVE_NO"].Text.ToString());
                parm.Add(row.Cells["BATCH_NO"].Text.ToString());
                parm.Add(row.Cells["SUBCONTRACT_PLINE_CODE"].Text.ToString());
                parm2.Add(parm);
                //VrpEntrustedBillEntity portTity = (VrpEntrustedBillEntity)row.ListObject;
                ////portTity.PhyBatchNo = portTity.NewPhyBatchNo;
                ////if (portTity.PhyBatchNo.Equals(""))
                ////{
                ////    MessageUtil.ShowTips("性能批号为空,不允许交库!");
                ////    return;
                ////}
                ////if (portTity.IsSamplePipe.Equals("样管"))
                ////{
                ////    portTity.IsSamplePipe = "1";
                ////}
                ////else
                ////{
                ////    portTity.IsSamplePipe = "0";
                ////}
                //string vrpEntity = JSONFormat.Format(portTity);
                //parmList.Add(vrpEntity);
               // VrpEntrustedBillEntity portTity = (VrpEntrustedBillEntity)row.ListObject;
                plnZyEntity = JsonHelper.ToJson(ultraGrid1.ActiveRow);
                parmList.Add(plnZyEntity);
            }
            //PlnZyDbkMEntity paa = new PlnZyDbkMEntity();
            //PlnZyDbkMEntity plnZyTity = (PlnZyDbkMEntity)uRow.ListObject;
            
            if (MessageUtil.ShowYesNoAndQuestion("是否确认委外入库？") == DialogResult.No) return;


            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmOutSourcApp";
            ccp.MethodName = "OutsourceInStore";
            ccp.ServerParams = new object[] { parm2, parmList,plnZyEntity, UserInfo.GetUserName(), UserInfo.GetDeptid(), UserInfo.GetUserOrder(), UserInfo.GetUserGroup() };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("委外入库成功！"))
                {
                    DoQuery();
                }
            }
        }
        /// <summary>
        /// 撤销委外交库
        /// </summary>
        private void CancelOutsourceInStore()
        {
            this.ultraGrid3.UpdateData();
            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)
            {
                YdmBcInlistEntity ydmBcTity = (YdmBcInlistEntity)row.ListObject;
                string ydmBcEntity = JSONFormat.Format(ydmBcTity);
                parmList.Add(ydmBcEntity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Vrp.FrmOutSourcApp";
            ccp.MethodName = "CancelOutsourceInStore";
            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>
        /// <returns></returns>
        private bool CheckQuery()
        {
            if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择！");
                return false;
            }
            if (this.chkJugeHeatNo.Checked && string.IsNullOrEmpty(this.txtJugeNo.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入炉号！");
                return false;
            }
            if (this.chkBatch.Checked && string.IsNullOrEmpty(this.txtBatch.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入生产批号！");
                return false;
            }          
            if (this.chkStrat.Checked && string.IsNullOrEmpty(this.cmbStrat.Text.Trim()))
            {
                MessageUtil.ShowWarning("请选择委外状态！");
                return false;
            }
            return true;
        }
        private void chkTim_CheckedChanged(object sender, EventArgs e)
        {

            if (chkTim.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; }
            if (chkJugeHeatNo.Checked) { txtJugeNo.Enabled = true; } else { txtJugeNo.Enabled = false; }
            if (chkBatch.Checked) { txtBatch.Enabled = true; } else { txtBatch.Enabled = false; }
            if (chkStrat.Checked) { cmbStrat.Enabled = true; } else { cmbStrat.Enabled = false; }

        }

        /// <summary>
        /// ultraGrid1改变事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            //委外回报合格支
            if (e.Cell.Column.Key.Equals("HB_COMPLETE_NUM"))
            {
                if (e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value == null)
                {
                    e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value = "0";
                }
                else
                {
                    ultraGrid1.UpdateData();
                    string hbConNum = e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value.ToString();
                    if (!StringUtil.IsInt(hbConNum) || hbConNum == "0")
                    {
                        e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value = "0";
                    }
                    //if (int.Parse(e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value.ToString()) > int.Parse(e.Cell.Row.Cells["SUBCONTRACT_NUM"].Value.ToString()))
                    //{
                    //    e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value = "0";
                    //}

                    e.Cell.Row.Cells["HB_COMPLETE_WT"].Value = ((double.Parse(e.Cell.Row.Cells["SUBCONTRACT_WT"].Value.ToString()) / int.Parse(e.Cell.Row.Cells["SUBCONTRACT_NUM"].Value.ToString())) * int.Parse(e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value.ToString())).ToString("f3");

                    e.Cell.Row.Cells["HB_FP_NUM"].Value = int.Parse(e.Cell.Row.Cells["SUBCONTRACT_NUM"].Value.ToString()) - int.Parse(e.Cell.Row.Cells["HB_COMPLETE_NUM"].Value.ToString());
                    e.Cell.Row.Cells["HB_FP_WT"].Value = (double.Parse(e.Cell.Row.Cells["SUBCONTRACT_WT"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["HB_COMPLETE_WT"].Value.ToString())).ToString("f3");
                }
            }
            if (e.Cell.Column.Key.Equals("HB_FP_NUM"))
            {
                if (e.Cell.Row.Cells["HB_FP_NUM"].Value == null)
                {
                    e.Cell.Row.Cells["HB_FP_NUM"].Value = "0";
                }
                else
                {
                    ultraGrid1.UpdateData();
                    string hbConNum = e.Cell.Row.Cells["HB_FP_NUM"].Value.ToString();
                    if (!StringUtil.IsInt(hbConNum) || hbConNum == "0")
                    {
                        e.Cell.Row.Cells["HB_FP_NUM"].Value = "0";
                    }
                    e.Cell.Row.Cells["HB_FP_WT"].Value = ((double.Parse(e.Cell.Row.Cells["SUBCONTRACT_WT"].Value.ToString()) / int.Parse(e.Cell.Row.Cells["SUBCONTRACT_NUM"].Value.ToString())) * int.Parse(e.Cell.Row.Cells["HB_FP_NUM"].Value.ToString())).ToString("f3");
                        //(double.Parse(e.Cell.Row.Cells["SUBCONTRACT_WT"].Value.ToString()) - double.Parse(e.Cell.Row.Cells["HB_COMPLETE_WT"].Value.ToString())).ToString("f3");
                }
            }

            //委外回报合格吨
            if (e.Cell.Column.Key.Equals("HB_COMPLETE_WT"))
            {
                if (e.Cell.Row.Cells["HB_COMPLETE_WT"].Value == null)
                {
                    e.Cell.Row.Cells["HB_COMPLETE_WT"].Value = "0";
                }
                else
                {
                    ultraGrid1.UpdateData();
                    string hbConWt = e.Cell.Row.Cells["HB_COMPLETE_WT"].Value.ToString();
                    if (!StringUtil.IsFloat(hbConWt) || hbConWt == "0")
                    {
                        e.Cell.Row.Cells["HB_COMPLETE_WT"].Value = "0";
                    }
                    if (double.Parse(e.Cell.Row.Cells["HB_COMPLETE_WT"].Value.ToString()) > double.Parse(e.Cell.Row.Cells["SUBCONTRACT_WT"].Text.ToString()))
                    {
                        e.Cell.Row.Cells["HB_COMPLETE_WT"].Value = "0";
                    }
                    e.Cell.Row.Cells["HB_FP_WT"].Value = (double.Parse(e.Cell.Row.Cells["SUBCONTRACT_WT"].Text.ToString()) - double.Parse(e.Cell.Row.Cells["HB_COMPLETE_WT"].Value.ToString())).ToString("f3");
                }
            }
        }

        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("AppThrough"))
                {
                    toolMenu.Toolbars[0].Tools["AppThrough"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AppNotThrough"))
                {
                    toolMenu.Toolbars[0].Tools["AppNotThrough"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutsourcReturn"))
                {
                    toolMenu.Toolbars[0].Tools["OutsourcReturn"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                {
                    toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Close"))
                {
                    toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoQueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["DoQueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutsourceInStore"))
                {
                    toolMenu.Toolbars[0].Tools["OutsourceInStore"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelOutsourceInStore"))
                {
                    toolMenu.Toolbars[0].Tools["CancelOutsourceInStore"].InstanceProps.Visible = DefaultableBoolean.False;
                }
            }else if(ultraTabControl1.SelectedTab.Key=="1")
            {
                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("AppThrough"))
                {
                    toolMenu.Toolbars[0].Tools["AppThrough"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("AppNotThrough"))
                {
                    toolMenu.Toolbars[0].Tools["AppNotThrough"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutsourcReturn"))
                {
                    toolMenu.Toolbars[0].Tools["OutsourcReturn"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Export"))
                {
                    toolMenu.Toolbars[0].Tools["Export"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("Close"))
                {
                    toolMenu.Toolbars[0].Tools["Close"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoQueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["DoQueryInList"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("OutsourceInStore"))
                {
                    toolMenu.Toolbars[0].Tools["OutsourceInStore"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelOutsourceInStore"))
                {
                    toolMenu.Toolbars[0].Tools["CancelOutsourceInStore"].InstanceProps.Visible = DefaultableBoolean.True;
                }
            }
        }

        private void FrmOutSourcApp_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (toolMenu.Toolbars[0].Tools.Exists("DoQueryInList"))
            {
                toolMenu.Toolbars[0].Tools["DoQueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelOutsourceInStore"))
            {
                toolMenu.Toolbars[0].Tools["CancelOutsourceInStore"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

     
    }
}