MES_Client/TGMES/Core.StlMes.Client.Mcp.Mch/MchResult/FrmCoupMakeupResult.cs


using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Net;
using System.Windows.Forms;
using com.steering.mes.mcp.entity;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Control;
using Core.StlMes.Client.Mcp.Control.Common;
using Core.StlMes.Client.Mcp.Control.Entity;
using Core.StlMes.Client.Mcp.Mch.MchResult;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;


namespace Core.StlMes.Client.Mcp.Mch
{
    public partial class FrmCoupMakeupResult :   FrmMchBase
    {
        public FrmCoupMakeupResult()
        {
            InitializeComponent();
            mchControlBase1 = new CouplingMakeupControl()
            {
                Dock = DockStyle.Fill
            };
            plnEdit.Controls.Add(mchControlBase1);
        }

        


        protected override UltraGridRow ActitveResultRow { get { return CrackDetectGrid.ActiveRow; } }


        protected override object Value { get { return (mchControlBase1 as CouplingMakeupControl).Value; } }


        protected override void OnLoad(EventArgs e)
        {

            base.OnLoad(e);
            EntityHelper.ShowGridCaption<MchTwistinglyResultEntity>(CrackDetectGrid.DisplayLayout.Bands[0]);

            EntityHelper.ShowGridCaption<MchTwistinglyResultDEntity>(CrackDetectGrid.DisplayLayout.Bands[1]);
            base.ultraGrid1.DisplayLayout.Bands[0].Columns["ActCount"].Hidden = true;
            base.ultraGrid1.DisplayLayout.Bands[0].Columns["ActWeight"].Hidden = true;
            base.ultraGrid1.DisplayLayout.Bands[0].Columns["BatchGroudNo"].Hidden = true;
            CrackDetectGrid.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.False;
            CrackDetectGrid.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.Default;
            ultraOptionSet2.Visible = false;
        }

        protected override void DoUpdate()
        {
            MchTwistinglyResultEntity data = Value as MchTwistinglyResultEntity;
            data.ResultNo = CrackDetectGrid.ActiveRow.Cells["ResultNo"].Value.ToString2();
            data.JudgeStoveNo = CrackDetectGrid.ActiveRow.Cells["JudgeStoveNo"].Value.ToString2();
            data.BatchNo = CrackDetectGrid.ActiveRow.Cells["BatchNo"].Value.ToString2();
            if (data.ResultNo == null || data.ResultNo == "")
            {
                MessageBox.Show("请选择实绩编号");
                return;
            }
            if (data.JudgeStoveNo == null || data.JudgeStoveNo == "")
            {
                MessageBox.Show("炉号不能为空");
                return;
            }
            if (data.BatchNo == null || data.BatchNo == "")
            {
                MessageBox.Show("批号不能为空");
                return;
            }
            if (data.CouplingNum == null || data.CouplingNum == 0)
            {
                MessageBox.Show("接箍个数不能为0");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否修改接箍个数?") == DialogResult.No)
                return;
            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Mch.FrmCoupMakeupResult";
            ccp.MethodName = "DoUpdate";
            ccp.ServerParams = new object[]
                {
                    JSONFormat.Format(data),
                    (mchControlBase1 as CouplingMakeupControl).Detail.Select(JSONFormat.Format).ToList()
                };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功！"))
                {
                    Query();
                }
            }
        }

        protected override void DoAdd()
        {
            if (ActiveRow != null)
            {
                List<MchTwistinglyResultEntity> pro = EntityHelper.GetData<MchTwistinglyResultEntity>(
  "com.steering.mes.mcp.Mch.FrmCoupMakeupResult.getQueryExpandResult",
  new object[] { ActiveRow.HeatPlanNo, ActiveRow.BatchNo },
  ob);

                MchTwistinglyResultEntity data = Value as MchTwistinglyResultEntity;

                decimal used = pro.Sum(p => p.FinalQualifiedNum) ?? 0;
                decimal OkPort = (mchControlBase1 as CouplingMakeupControl).OkPort.Count;

                if (OkPort - used - data.FinalQualifiedNum < 0)
                {
                    List<MchOfflineResultEntity> mchOffline = EntityHelper.GetData<MchOfflineResultEntity>("com.steering.mes.mcp.common.OfflineHelper.QueryMchOffLineData", new object[] { ActiveRow.HeatPlanNo, ActiveRow.BatchNo }, ob);

                    var returnData = mchOffline.Where(
                        p =>
                            p.ReturnProcess != null && p.StationCode != p.ReturnProcess &&
                            mchControlBase1.CheckGx2(p.StationCode, mchControlBase1.gx) &&
                            mchControlBase1.CheckGx2(mchControlBase1.gx, p.ReturnProcess)).ToList();

                    int ReturnNum = 0;

                    if (returnData.Any())
                    {
                        ReturnNum = int.Parse(returnData.Sum(p => p.ReNum).ToString3());

                        if (ReturnNum > 0)
                        {
                            data.ProWt = returnData.Sum(p => p.ReWt);
                        }
                    }

                    if (OkPort + ReturnNum - used - data.FinalQualifiedNum < 0)
                    {

                        if (mchOffline.Any(p => p.ReNum == null || p.ReNum <= 0))
                        {
                            MessageBox.Show(
                                mchOffline.Any(p => (p.ReNum == null || p.ReNum <= 0) && p.SubcontractcompleteNum > 0)
                                    ? "委托已经完成,未返线, 请联系出料人员对该炉批进行返线操作!"
                                    : "存在离线数据未返线, 请联系出料人员对该炉批进行返线操作!");
                            return;
                        }


                        MessageBox.Show("请检查数据是否维护正确, 最终合格支 + 离线返线支= 一次合格支+ 返修支, 该炉批当前工序总 " + OkPort + "支  已维护了合格" + used +
                                        "支  当前最终合格支不能超过" + (OkPort + ReturnNum - used) + "支");
                        return;
                    }
                }


                if (MessageUtil.ShowYesNoAndQuestion("是否增加拧接实绩?") == DialogResult.No)
                    return;
                var ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.mes.mcp.Mch.FrmCoupMakeupResult";
                ccp.MethodName = "DoAdd";
                ccp.ServerParams = new object[]
                {
                    JSONFormat.Format(data), 
                    Gx,
                    mchControlBase1.ScrappedList.Select(JSONFormat.Format).ToList(),
                    mchControlBase1.SuspiciousList.Select(JSONFormat.Format).ToList(),
                     (mchControlBase1 as CouplingMakeupControl).Detail.Select(JSONFormat.Format).ToList()
                };
                ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                    if (ccp.ReturnInfo.Equals("新增成功！"))
                    {
                        Query();
                    }
                }
            }
        }

        protected override void DoDelete()
        {
            {

                if (ActiveRow != null && ActitveResultRow != null)
                {

                    if (MessageUtil.ShowYesNoAndQuestion("是否删除拧接实绩?") == DialogResult.No)
                        return;
                    var ccp = new CoreClientParam();
                    ccp.ServerName = "com.steering.mes.mcp.Mch.FrmCoupMakeupResult";
                    ccp.MethodName = "DoDelete";
                    ccp.ServerParams = new object[]
                    {
                        JSONFormat.Format(ActitveResultRow.ListObject), Gx
                    };
                    ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                    if (ccp.ReturnCode != -1)
                    {
                        MessageUtil.ShowTips(ccp.ReturnInfo);
                        if (ccp.ReturnInfo.Equals("删除成功！"))
                        {
                            if (!string.IsNullOrEmpty(ActitveResultRow.Cells["ReportPath"].Value.ToString2()))
                            {
                                try
                                {
                                    FileHelper.Delete(ActitveResultRow.Cells["ReportPath"].Value.ToString2());
                                }
                                catch (Exception)
                                {
                                    MessageUtil.ShowTips("报告删除失败！");
                                }
                            }
                            Query();
                        }
                    }
                }
            }
        }



        protected override void GetResultData()
        {
            base.GetResultData();
            var list = EntityHelper.GetData<MchTwistinglyResultEntityAll>(
                "com.steering.mes.mcp.Mch.FrmCoupMakeupResult.getQueryExpandResult",
                new object[] { ActiveRow.HeatPlanNo, ActiveRow.BatchNo },
                ob);
            if (list.Count > 0) {
                var listdetail = EntityHelper.GetData<MchTwistinglyResultDEntity>(
                                   "com.steering.mes.mcp.Mch.FrmCoupMakeupResult.doQuerypDetail",
                                   new object[] { list.Select(p => p.ResultNo).ToArray() },
                                   ob);

                list.ForEach(p => p.List = listdetail.Where(q => p.ResultNo == q.ResultNo).ToList());
                mchTwistinglyResultEntityAllBindingSource.DataSource = list;
                commHelper.RefreshAndAutoSizeExceptColumns(CrackDetectGrid, "ReportPath");

            }
            if (ActiveRow == null) return;
            var CouplingMakeupControl = mchControlBase1 as CouplingMakeupControl;
            if (CouplingMakeupControl == null) return;

            var result = new MchTwistinglyResultEntity
            {
                HeatPlanNo = ActiveRow.HeatPlanNo,
                JudgeStoveNo = ActiveRow.JudgeStoveNo,
                BatchNo = ActiveRow.BatchNo,
                PlineCode = ActiveRow.PlineCode,
                PlineName = ActiveRow.PlineName,
                ProNum = CouplingMakeupControl.OkPort.Count > (ActiveRow.OperateCount ?? 0) ? CouplingMakeupControl.OkPort.Count - (ActiveRow.OperateCount ?? 0) : 0,
                FailNum = 0,
                FailWt = 0,
                ReProNum = 0,
                ReProWt = 0,
                CouplingNum = 0,
                ProShift = UserInfo.GetUserOrder(),
                ProGroup = UserInfo.GetUserGroup(),
                ProUser = UserInfo.GetUserName(),
                ProTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
            };


            if (result.ProNum <= 0)
            {
                int OffNum = GetReturnNum();
                result.ProNum = CouplingMakeupControl.OkPort.Count - (ActiveRow.OperateCount ?? 0) + result.ProNum + OffNum;
                if (result.ProNum < 0)
                {
                    result.ProNum = 0;
                }

            }

            result.QualifiedNum = result.ProNum;
            result.FinalQualifiedNum = result.ProNum;
            CouplingMakeupControl.Value = result;

        }

        private void utUpLoad1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            var entity = CrackDetectGrid.ActiveRow.ListObject as MchTwistinglyResultEntity;
            if (entity == null) return;

            var strurl = "";

            if (e.Button.Key == "VIEW")
            {


                    strurl =
                        "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=MchTwistingLyReport.cpt&op=view&resultNo=" +
                        entity.ResultNo;
                

                var fre = new FrmRepExcel(ob, strurl);
                fre.AutoSize = true;
                fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width,
                    Screen.PrimaryScreen.WorkingArea.Height);
                fre.WindowState = FormWindowState.Maximized;
                fre.Show();
            }
            else if (e.Button.Key == "UPLOAD")
            {

                strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=MchTwistingLyReport.cpt&format=pdf&resultNo=" + entity.ResultNo;


                var webClient = new WebClient();
                var listPdf = new List<FileBean>();
                var date = DateTime.Now.ToString("yyyyMMdd");

                var filePathNew = ""; //报告目录
                var reportNo = ""; //报告编号


                filePathNew = "Mch/Twist/" + ActiveRow.JudgeStoveNo + "/" + entity.BatchNo + "/" + entity.HeatPlanNo + "/";
                reportNo = entity.ResultNo ;

                var pdf = webClient.DownloadData(strurl);
                var fileBean = new FileBean();

                fileBean.setFile(pdf);
                fileBean.setFileName(reportNo + ".pdf");
                fileBean.setPathName(filePathNew);
                listPdf.Add(fileBean);
                webClient.Dispose();
                var a = FileHelper.Upload(listPdf);

                if (a)
                {
                    ServerHelper.SetData("com.steering.mes.mcp.Mch.FrmCoupMakeupResult.UpdatePath",
                        new object[] {filePathNew + reportNo + ".pdf", entity.ResultNo }, ob);

                    MessageUtil.ShowTips("上传报告成功！");
                    Query();
                }
            }
            else
            {
                MessageUtil.ShowError("系统生成PDF失败，请稍后再试！");
            }
        }

        private void CrackDetectGrid_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            if(e.Row.HasParent()) return;

            var MchTwistinglyResultEntity = e.Row.ListObject as MchTwistinglyResultEntity;

            e.Row.Cells["ReportPath"].Appearance.BackColor = string.IsNullOrEmpty(MchTwistinglyResultEntity.ReportPath)
        ? Color.Red
        : Color.LightGreen;
            e.Row.Cells["ReportPath"].EditorComponent = utUpLoad1;
        }
    }
    
     
    
}