MES_Client/TGMES/Core.StlMes.Client.Mcp.Treatment/Report/FrmHttControlLog.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Windows.Forms;
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.Control.Common;
using Core.StlMes.Client.Mcp.Control.Entity;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System.Collections;

namespace Core.StlMes.Client.Mcp.Treatment.Report
{
    public partial class FrmHttControlLog : FrmBase
    {
        private string date = "";
        private string departm = "";
        private int flag = 0; //分析时间错误
        private int flag1 = 0; //分析相差时间
        private string station = ""; //工序点
        private string ProcessCode = "";

        private HttControlShiftEntity httControlShiftEntity;
        private string plineCode;
        private UltraComboEditor ucePline = new UltraComboEditor(); //产线名称

        public FrmHttControlLog()
        {
            InitializeComponent();
        }

        private void FrmHttControlLog_Load(object sender, EventArgs e)
        {
            departm = UserInfo.GetDepartment();
            //plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线

            if (UserInfo.GetUserOrder().Equals("3"))
                cmbDate.Value = DateTime.Parse(DateTime.Now.AddDays(0.5d).ToString("yyyy-MM-dd"));
            else
                cmbDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));



            EntityHelper.ShowGridCaption<HttControlLogEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<HttControlLogEntity>(ultraGrid2.DisplayLayout.Bands[0]);
            //EntityHelper.ShowGridCaption<HttControlLogDetailEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            //EntityHelper.ShowGridCaption<HttControlLogDetailEntity>(ultraGrid4.DisplayLayout.Bands[0]);

            splitContainer1.SplitterDistance = splitContainer1.Size.Height / 2;
        }

        protected override void OnLoad(EventArgs e)
        {
            base.OnLoad(e);
            ultraGrid1.DisplayLayout.Bands[0].Override.HeaderClickAction = HeaderClickAction.Select;
            //ultraGrid4.DisplayLayout.Bands[0].Override.HeaderClickAction = HeaderClickAction.Select;
            //ultraGrid3.DisplayLayout.Bands[0].Override.HeaderClickAction = HeaderClickAction.Select;
            ultraGrid2.DisplayLayout.Bands[0].Override.HeaderClickAction = HeaderClickAction.Select;

            ProcessCode = this.CustomInfo.ToString2();
            if (ProcessCode == "") ProcessCode = "F";

            var plineCodes = comm.InitDropPlinePower(ProcessCode, comPlineCode, ValidDataPurviewIds, ob);
            if (plineCodes.Length > 0) comPlineCode.SelectedIndex = 0;

            //egpGroupBox.Expanded = false;
            //egpGroupBox1.Expanded = false;

            var dt2 = ServerHelper.GetData("com.steering.mes.mcp.collarMaterial.ComBaseInfo.getBaseInfo",
                new object[] { "600701" }, ob);
            if (dt2.Rows.Count > 0)
            {
                MinTime.MaxValue = dt2.Rows[0]["BASENAME"].ToString();
            }

            MinTime.Value = "15";
            var list = new ValueList();
            var list2 = new ValueList();
            string FailCode = "";

            if (ProcessCode == "F")
            {
                list.ValueListItems.Add("000000", "所有");
                list.ValueListItems.Add("600202", "高温炉");
                list.ValueListItems.Add("600203", "淬火");
                list.ValueListItems.Add("600204", "低温炉");
                list.ValueListItems.Add("600205", "定径");
                list.ValueListItems.Add("600206", "热矫");
                list.ValueListItems.Add("600207", "冷矫");
                list.ValueListItems.Add("600208", "表面检验");
                list.ValueListItems.Add("600209", "探伤");


                list2.ValueListItems.Add("000000", "所有");
                list2.ValueListItems.Add("600202", "高温炉");
                list2.ValueListItems.Add("600203", "淬火");
                list2.ValueListItems.Add("600204", "低温炉");
                list2.ValueListItems.Add("600205", "定径");
                list2.ValueListItems.Add("600206", "热矫");
                list2.ValueListItems.Add("600207", "冷矫");
                list2.ValueListItems.Add("600208", "表面检验");
                list2.ValueListItems.Add("600209", "探伤");

                FailCode = "6006";

                ultraSTATION2.Visible = false;
            }
            else
            {
                list.ValueListItems.Add("000000", "所有");
                list.ValueListItems.Add("701302", "探伤");
                list.ValueListItems.Add("701303", "切管");
                list.ValueListItems.Add("701304", "车丝");
                list.ValueListItems.Add("701306", "拧接");
                list.ValueListItems.Add("701307", "通径");
                list.ValueListItems.Add("701308", "水压");
                list.ValueListItems.Add("701309", "倒棱");
                list.ValueListItems.Add("701310", "测量点");



                list2.ValueListItems.Add("000000", "所有");
                list2.ValueListItems.Add("701302", "探伤");
                list2.ValueListItems.Add("701303", "切管");
                list2.ValueListItems.Add("701304", "车丝");
                list2.ValueListItems.Add("701306", "拧接");
                list2.ValueListItems.Add("701307", "通径");
                list2.ValueListItems.Add("701308", "水压");
                list2.ValueListItems.Add("701309", "倒棱");
                list2.ValueListItems.Add("701310", "测量点");

                FailCode = "7025";

                ultraSTATION1.Visible = false;
            }

            //ultraGrid3.DisplayLayout.Bands[0].Columns["StationCode"].ValueList = list;




            //ultraGrid4.DisplayLayout.Bands[0].Columns["StationCode"].ValueList = list2;


            var list1 = new ValueList();
            var list3 = new ValueList();
            var dt = TubeRoll.GetComBaseInfo(FailCode, ob);
            foreach (DataRow row in dt.Rows)
            {
                list1.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());
                list3.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());
            }

            //ultraGrid3.DisplayLayout.Bands[0].Columns["StopType"].ValueList = list3;
            ultraGrid1.DisplayLayout.Bands[0].Columns["StopType"].ValueList = list1;


        }


        /// <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 "Add":
                    doAdd();
                    break;
                case "Update":
                    doUpdate();
                    break;
                case "Delete":
                    doDelete();
                    break;
                case "Confirm":
                    doConfirm();
                    break;
                case "UpConfirm":
                    UpConfirm();
                    break;
                case "Audit":
                    doAudit();
                    break;
                case "UpAudit":
                    UpAudit();
                    break;
                case "OneKeyProces":
                    //DoOneKeyProces();
                    break;
                case "Statistical":
                    DoStatistical();
                    break;
                case "OneKeyUpdate":
                    DoOneKeyUpdate();
                    break;
                case "Production":
                    DoProduction();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGrid1, "镦拔扩调度日志");
                    break;
                case "Close":
                    Close();
                    break;
            }
        }

        /// <summary>
        ///     生产记录
        /// </summary>
        private void DoProduction()
        {
            var pro = new FrmProductionDetails(cmbDate.Value.ToString("yyyyMMdd"), plineCode, ob);
            pro.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            pro.Text = "生产详细";
            pro.ShowDialog();
        }

        /// <summary>
        ///     查询统计数据
        /// </summary>
        private void DoStatistical()
        {
            var row = ultraGrid1.ActiveRow;
            if (row == null)
            {
                MessageUtil.ShowTips("无数据！");
                return;
            }

            var fsta = new FrmStatistical(plineCode, ob);
            fsta.AutoSize = true;
            fsta.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fsta.Text = "统计查询";
            fsta.ShowDialog();
        }

        /// <summary>
        ///     查询
        /// </summary>
        private void doQuery()
        {
            //egpGroupBox.Expanded = false;
            //egpGroupBox1.Expanded = false;
            httControlLogDetailEntityBindingSource.DataSource = new List<HttControlLogDetailEntity>();
            httControlLogDetailEntityBindingSource1.DataSource = new List<HttControlLogDetailEntity>();

            if (ProcessCode == "F")
            {
                station = ultraSTATION1.Value.ToString();
            }
            if (ProcessCode == "G")
            {
                station = ultraSTATION2.Value.ToString();
            }

            List<HttControlShiftEntity> ShiftEntity =
                EntityHelper.GetData<HttControlShiftEntity>(
                    "com.steering.mes.mcp.Report.FrmHttControlLog.doQueryShiftInfo",
                    new object[] { plineCode, UserInfo.GetUserOrder() }, ob);

            if ((ShiftEntity == null) || (ShiftEntity.Count != 1))
            {
                httControlShiftEntity = null;
                // MessageBox.Show("未维护该班次的上班时间");
                //  return;
            }
            else
            {
                httControlShiftEntity = ShiftEntity[0];
            }


            httControlLogEntityBindingSource1.Clear();
            ultraGrid2.DisplayLayout.Bands[0].Summaries["SumProductTime"].DisplayFormat = "";

            //前一天
            var LastDate = "";

            date = cmbDate.Value.ToString("yyyyMMdd");
            LastDate = cmbDate.Value.AddDays(-1).ToString("yyyyMMdd");

            List<HttControlLogEntity> listEntity =
                EntityHelper.GetData<HttControlLogEntity>("com.steering.mes.mcp.Report.FrmHttControlLog.doQueryPlan",
                    new object[] { date, "", UserInfo.GetUserOrder(), UserInfo.GetUserGroup(), plineCode, station }, ob);

            httControlLogEntityBindingSource.DataSource = listEntity;


            HeatTreatment.comm.RefreshAndAutoSize(ultraGrid1, new[] { "LogsBeg", "LogsEnd", "Memo" });

            if (httControlShiftEntity != null)
            {

                List<HttControlLogEntity> listEntity1 =
                    EntityHelper.GetData<HttControlLogEntity>(
                        "com.steering.mes.mcp.Report.FrmHttControlLog.doQueryPlan",
                        new object[]
                        {
                            UserInfo.GetUserOrder() == "3" ? LastDate : date, "", httControlShiftEntity.LastBc,
                            UserInfo.GetUserGroup(), plineCode, station
                        }, ob);

                httControlLogEntityBindingSource1.DataSource = listEntity1;
                ultraGrid2.DisplayLayout.Bands[0].Summaries["SumProductTime"].DisplayFormat = listEntity1.Sum(
                p =>
                {
                    var time = 0;
                    int.TryParse(p.ProductTime, out time);
                    return time;
                }).ToString2();

            }

            HeatTreatment.comm.RefreshAndAutoSize(ultraGrid2, new[] { "LogsBeg", "LogsEnd", "Memo" });


            ultraGrid1.DisplayLayout.Bands[0].Summaries["SumProductTime"].DisplayFormat = listEntity.Sum(
                p =>
                {
                    var time = 0;
                    int.TryParse(p.ProductTime, out time);
                    return time;
                }).ToString2();


        }



        /// <summary>
        ///     一键修改
        /// </summary>
        private void DoOneKeyUpdate()
        {
            ultraGrid1.UpdateData();

            try
            {
                if (MinTime.Text == "") return;

                if (MessageUtil.ShowYesNoAndQuestion("是否一键修改处理?") == DialogResult.No)
                    return;

                var list =
                    httControlLogEntityBindingSource.DataSource as List<HttControlLogEntity>;

                list = list.Where(p =>
                {
                    var min = 0;
                    int.TryParse(p.TimeDiff.ToString2().Replace("min", "").Trim(), out min);
                    return (min != 0) && (min < int.Parse(MinTime.Text)) && (min > 0 - int.Parse(MinTime.Text));
                }).ToList();

                list.ForEach(p =>
                    {
                        var min = 0;
                        int.TryParse(p.TimeDiff.ToString2().Replace("min", "").Trim(), out min);
                        p.LogsBeg = DateTime.Parse(p.LogsBeg).AddMinutes(0 - min).ToString("yyyyMMddHHmm");
                    }
                );

                var ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
                ccp.MethodName = "oneKeyUpdateMilControlLog";
                ccp.ServerParams = new object[] { list.Select(JSONFormat.Format).ToList() };
                ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                    if (ccp.ReturnInfo.Equals("一键处理成功!"))
                        doQuery();
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowTips("开始时间或结束时间不能为空！");
            }
        }

        /// <summary>
        ///     新增
        /// </summary>
        private void doAdd()
        {

            var StartTime = DateTime.Now.ToString("yyyyMMddHHmm");
            var time = "0";
            if (ultraGrid1.ActiveRow != null)
            {
                ultraGrid1.UpdateData();
                var Lastentity = ultraGrid1.ActiveRow.ListObject as HttControlLogEntity;
                StartTime = Lastentity.LogsBeg;
                time = Lastentity.TimeDiff.ToString2().Replace("min", "").Trim();
                if ((time == "") || (time == "0") || (int.Parse(time) < 0))
                {
                    StartTime = Lastentity.LogsEnd;
                    time = "0";
                }
                if (Lastentity.ConfirmFlag.Equals("已审核"))
                {
                    MessageUtil.ShowTips("已审核的停机记录不能增加！");
                    return;
                }
            }
            if (ProcessCode == "F")
            {
                station = ultraSTATION1.Value.ToString();
            }
            if (ProcessCode == "G")
            {
                station = ultraSTATION2.Value.ToString();
            }
            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
            ccp.MethodName = "addMilControlLog";
            ccp.ServerParams = new object[]
            {
                StartTime, time, UserInfo.GetUserName(), UserInfo.GetUserOrder(), UserInfo.GetUserGroup(),
                cmbDate.Value.ToString("yyyy-MM-dd"), plineCode, station
            };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("新增成功!"))
                    doQuery();
            }
        }

        /// <summary>
        ///     修改
        /// </summary>
        private void doUpdate()
        {
            ultraGrid1.UpdateData();
            //ultraGrid3.UpdateData();
            try
            {
                var list =
                    httControlLogEntityBindingSource.DataSource as List<HttControlLogEntity>;

                var list1 =
                    httControlLogDetailEntityBindingSource.DataSource as List<HttControlLogDetailEntity>;

                if (list == null)
                {
                    MessageUtil.ShowTips("请选择要修改的数据！");
                    return;
                }

                if (list1 == null)
                    list1 = new List<HttControlLogDetailEntity>();

                list = list.Where(p => p.Chk).Select(p => p.Clone()).ToList();
                list1 = list1.Where(p => p.Chk).Select(p => p.Clone()).ToList();

                if (!list.Any())
                {
                    MessageUtil.ShowTips("请选择要修改的数据！");
                    return;
                }


                if (list.Any(p => p.ConfirmFlag != "未确认"))
                {
                    MessageUtil.ShowTips("请选择未确认的数据！");
                    return;
                }


                if (MessageUtil.ShowYesNoAndQuestion("是否修改?") == DialogResult.No)
                    return;

                for (var i = 0; i < list.Count; i++)
                {
                    DateTime dtStart, dtEnd;
                    if (DateTime.TryParse(list[i].LogsBeg, out dtStart))
                        list[i].LogsBeg = dtStart.ToString("yyyyMMddHHmm");

                    if (DateTime.TryParse(list[i].LogsEnd, out dtEnd))
                        list[i].LogsEnd = dtEnd.ToString("yyyyMMddHHmm");
                }

                for (var i = 0; i < list1.Count; i++)
                {
                    list1[i].ControlSeq = i + 1;
                    DateTime dtStart, dtEnd;
                    if (DateTime.TryParse(list1[i].LogsBeg, out dtStart))
                        list1[i].LogsBeg = dtStart.ToString("yyyyMMddHHmm");

                    if (DateTime.TryParse(list1[i].LogsEnd, out dtEnd))
                        list1[i].LogsEnd = dtEnd.ToString("yyyyMMddHHmm");
                }

                var ccp = new CoreClientParam();
                ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
                ccp.MethodName = "updateMilControlLog";
                ccp.ServerParams = new object[]
                {
                    list.Select(JSONFormat.Format).ToList(),
                    list1.Any() ? list1.Select(JSONFormat.Format).ToList() : new List<string>()
                };
                ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
                if (ccp.ReturnCode != -1)
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                    if (ccp.ReturnInfo.Equals("修改成功!"))
                        doQuery();
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowTips(ex.Message);
            }
        }

        /// <summary>
        ///     删除
        /// </summary>
        private void doDelete()
        {
            ultraGrid1.UpdateData();

            var list =
                httControlLogEntityBindingSource.DataSource as List<HttControlLogEntity>;

            if (list == null)
            {
                MessageUtil.ShowTips("请选择要删除的停机数据！");
                return;
            }

            list = list.Where(p => p.Chk).ToList();

            if (!list.Any())
            {
                MessageUtil.ShowTips("请选择要删除的停机数据！");
                return;
            }

            if (list.Any(p => p.ProType != "停机"))
            {
                MessageUtil.ShowTips("请选择停机数据！");
                return;
            }

            if (list.Any(p => p.ConfirmFlag != "未确认"))
            {
                MessageUtil.ShowTips("请选择未确认的停机数据！");
                return;
            }

            if (MessageUtil.ShowYesNoAndQuestion("是否删除?") == DialogResult.No)
                return;

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
            ccp.MethodName = "deleteMilControlLog";
            ccp.ServerParams = new object[] { list.Select(p => p.ControlId).ToList() };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("删除成功!"))
                    doQuery();
            }
        }


        /// <summary>
        ///     确认
        /// </summary>
        private void doConfirm()
        {
            ultraGrid1.UpdateData();

            //var list =
            //    httControlLogEntityBindingSource.DataSource as List<HttControlLogEntity>;

            //if (list == null)
            //{
            //    MessageUtil.ShowTips("请选择要确认的数据！");
            //    return;
            //}

            //if (!list.Any())
            //{
            //    MessageUtil.ShowTips("请选择要确认的数据！");
            //    return;
            //}
            ArrayList pram = new ArrayList();
            //IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");

            if (this.ultraGrid1.Rows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要确认的数据!");
                return;
            }
            foreach (UltraGridRow uRow in this.ultraGrid1.Rows)
            {
                HttControlLogEntity stlControlLogEntity = (HttControlLogEntity)uRow.ListObject;
                stlControlLogEntity.ConfirmName = this.UserInfo.GetUserName();
                if (stlControlLogEntity.ProType.Equals("停机"))
                {
                    if (stlControlLogEntity.StopType.Equals("") || stlControlLogEntity.StopSmall.Equals("") || stlControlLogEntity.StopReason.Equals(""))
                    {
                        MessageUtil.ShowTips("停机原因不能为空!");
                        return;
                    }
                }
                string matZcTity = JSONFormat.Format(stlControlLogEntity);
                pram.Add(matZcTity);
            }

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
            ccp.MethodName = "confirmMilControlLog";
            ccp.ServerParams = new object[]
            {
                pram, UserInfo.GetUserName(), date, plineCode,
                UserInfo.GetUserOrder(),"1"
            };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("确认成功!"))
                    doQuery();
            }
        }

        /// <summary>
        ///     取消确认
        /// </summary>
        private void UpConfirm()
        {
            ultraGrid1.UpdateData();

            ArrayList pram = new ArrayList();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要取消确认的数据!");
                return;
            }
            foreach (UltraGridRow uRow in checkMagRows)
            {
                HttControlLogEntity stlControlLogEntity = (HttControlLogEntity)uRow.ListObject;
                stlControlLogEntity.ConfirmName = this.UserInfo.GetUserName();
                string matZcTity = JSONFormat.Format(stlControlLogEntity);
                pram.Add(matZcTity);
            }

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
            ccp.MethodName = "upConfirmMilControlLog";
            ccp.ServerParams = new object[] { pram, "0" };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("取消确认成功!"))
                    doQuery();
            }
        }

        /// <summary>
        /// 审核
        /// </summary>
        private void doAudit()
        {
            ultraGrid1.UpdateData();

            ArrayList pram = new ArrayList();
            //IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (this.ultraGrid1.Rows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要审核的数据!");
                return;
            }
            foreach (UltraGridRow uRow in this.ultraGrid1.Rows)
            {
                HttControlLogEntity stlControlLogEntity = (HttControlLogEntity)uRow.ListObject;
                stlControlLogEntity.ConfirmName = this.UserInfo.GetUserName();
                string matZcTity = JSONFormat.Format(stlControlLogEntity);
                pram.Add(matZcTity);
            }


            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
            ccp.MethodName = "confirmMilControlLog";
            ccp.ServerParams = new object[]
            {
                pram, UserInfo.GetUserName(), date, plineCode,
                UserInfo.GetUserOrder(),"2"
            };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("审核成功!"))
                    doQuery();
            }
        }

        /// <summary>
        ///     取消审核
        /// </summary>
        private void UpAudit()
        {
            ultraGrid1.UpdateData();

            ArrayList pram = new ArrayList();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请选择要取消审核的数据!");
                return;
            }
            foreach (UltraGridRow uRow in checkMagRows)
            {
                HttControlLogEntity stlControlLogEntity = (HttControlLogEntity)uRow.ListObject;
                stlControlLogEntity.ConfirmName = this.UserInfo.GetUserName();
                string matZcTity = JSONFormat.Format(stlControlLogEntity);
                pram.Add(matZcTity);
            }

            var ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.mcp.Report.FrmHttControlLog";
            ccp.MethodName = "upConfirmMilControlLog";
            ccp.ServerParams = new object[] { pram, "1" };
            ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("取消审核成功!"))
                    doQuery();
            }
        }

        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            if (chkDate.Checked) cmbDate.Enabled = true;
            else cmbDate.Enabled = false;
        }


        private void ultraGrid1_CellDataError(object sender, CellDataErrorEventArgs e)
        {
            e.RaiseErrorEvent = false;

            MessageUtil.ShowTips("您输入的时间格式不正确!");
        }


        private void ultraGrid1_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            try
            {
                var entity = e.Row.ListObject as HttControlLogEntity;

                if (entity == null) return;

                if (entity.ConfirmFlag == "未确认")
                {
                    e.Row.Cells["LogsBeg"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    e.Row.Cells["LogsBeg"].Activation = Activation.AllowEdit;
                    e.Row.Cells["LogsBeg"].IgnoreRowColActivation = true;

                    e.Row.Cells["LogsEnd"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    e.Row.Cells["LogsEnd"].Activation = Activation.AllowEdit;
                    e.Row.Cells["LogsEnd"].IgnoreRowColActivation = true;

                    e.Row.Cells["Memo"].Appearance.BackColor = Color.FromArgb(255, 255, 192);
                    e.Row.Cells["Memo"].Activation = Activation.AllowEdit;
                    e.Row.Cells["Memo"].IgnoreRowColActivation = true;
                }

                if (entity.ProType == "停机")
                    e.Row.Cells["ProType"].Appearance.BackColor = Color.Pink;

                DateTime dtBegin, dtEnd;
                if (DateTime.TryParse(entity.LogsBeg, out dtBegin) && DateTime.TryParse(entity.LogsEnd, out dtEnd))
                    if (dtBegin > dtEnd)
                        e.Row.Cells["LogsEnd"].Appearance.BackColor = Color.Red;
                    else
                        e.Row.Cells["LogsEnd"].Appearance.ResetBackColor();

                if ((e.Row.Index == 0) && httControlShiftEntity != null)
                {

                    string logsBeg = httControlShiftEntity.ShiftBeg.Insert(2, ":");
                    logsBeg = (entity.ProBc == "3" ? DateTime.ParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).AddDays(-1).ToString("yyyy-MM-dd") : DateTime.ParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyy-MM-dd")) + " " + logsBeg;
                    DateTime dtLastEnd;
                    if ((httControlShiftEntity.ShiftBeg != null) && DateTime.TryParse(entity.LogsBeg, out dtBegin) && DateTime.TryParse(logsBeg, out dtLastEnd) &&
                        DateTime.TryParse(entity.LogsBeg, out dtBegin))
                    {
                        var diff = DateDiff(dtBegin, dtLastEnd);
                        if (diff > 0)
                            e.Row.Cells["TimeDiff"].Appearance.BackColor = Color.Red;
                        else e.Row.Cells["TimeDiff"].Appearance.ResetBackColor();
                        entity.TimeDiff = diff + " min";
                    }
                }

                if ((e.Row.Index > 0) && (entity.ProductTime != "") && (entity.ProductTime != "0" || entity.ProType == "正常"))
                    for (var i = e.Row.Index - 1; i >= 0; i--)
                    {
                        var Lastentity = ultraGrid1.Rows[i].ListObject as HttControlLogEntity;
                        if ((Lastentity.ProductTime == "") || (Lastentity.ProductTime == "0" && Lastentity.ProType != "正常"))
                        {
                        }
                        else
                        {
                            DateTime dtLastEnd;
                            if ((Lastentity != null) && DateTime.TryParse(Lastentity.LogsEnd, out dtLastEnd) &&
                                DateTime.TryParse(entity.LogsBeg, out dtBegin))
                            {
                                var diff = DateDiff(dtBegin, dtLastEnd);
                                if (diff > 0) e.Row.Cells["TimeDiff"].Appearance.BackColor = Color.Red;
                                else e.Row.Cells["TimeDiff"].Appearance.ResetBackColor();
                                entity.TimeDiff = diff + " min";
                            }
                            break;
                        }

                        if (i == 0 && httControlShiftEntity != null)
                        {
                            string logsBeg = httControlShiftEntity.ShiftBeg.Insert(2, ":");
                            logsBeg = (entity.ProBc == "3" ? DateTime.ParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).AddDays(-1).ToString("yyyy-MM-dd") : DateTime.ParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyy-MM-dd")) + " " + logsBeg;
                            DateTime dtLastEnd;
                            if ((httControlShiftEntity.ShiftBeg != null) && DateTime.TryParse(entity.LogsBeg, out dtBegin) && DateTime.TryParse(logsBeg, out dtLastEnd) &&
                                DateTime.TryParse(entity.LogsBeg, out dtBegin))
                            {
                                var diff = DateDiff(dtBegin, dtLastEnd);
                                if (diff > 0)
                                    e.Row.Cells["TimeDiff"].Appearance.BackColor = Color.Red;
                                else e.Row.Cells["TimeDiff"].Appearance.ResetBackColor();
                                entity.TimeDiff = diff + " min";
                            }
                        }
                    }

                //var entity = e.Row.ListObject as HttControlLogDetailEntity;
                if (entity == null) return;

                var list1 = new ValueList();
                var dt = TubeRoll.GetComBaseInfo(entity.StopType, ob);
                foreach (DataRow row in dt.Rows)
                    list1.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

                e.Row.Cells["StopSmall"].ValueList = list1;
                var list2 = new ValueList();
                var dt2 = TubeRoll.GetComBaseInfo(entity.StopSmall, ob);
                foreach (DataRow row in dt2.Rows)
                    list2.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

                e.Row.Cells["StopReason"].ValueList = list2;
                ultraGrid1.Refresh();
            }
            catch (Exception)
            {
            }
        }

        private void ultraGrid1_CellChange_1(object sender, CellEventArgs e)
        {
            try
            {
                if (((e.Cell.Column.Key == "LogsEnd") || (e.Cell.Column.Key == "LogsBeg")) && e.Cell.Text.Contains("_"))
                {

                    return;
                }



                ultraGrid1.UpdateData();
                if (ultraGrid1.ActiveRow == null) return;
                var entity = ultraGrid1.ActiveRow.ListObject as HttControlLogEntity;
                if (entity == null) return;

                if (e.Cell.Column.Key != "Chk")
                    entity.Chk = true;

                if ((e.Cell.Column.Key == "LogsEnd") || (e.Cell.Column.Key == "LogsBeg"))
                {
                    DateTime dtBegin, dtEnd;
                    if (DateTime.TryParse(entity.LogsBeg, out dtBegin) && DateTime.TryParse(entity.LogsEnd, out dtEnd))
                        if (dtBegin > dtEnd)
                            ultraGrid1.ActiveRow.Cells["LogsEnd"].Appearance.BackColor = Color.Red;
                        else
                            ultraGrid1.ActiveRow.Cells["LogsEnd"].Appearance.ResetBackColor();

                    if ((entity.ProductTime == "") || (entity.ProductTime == "0")) return;

                    if ((ultraGrid1.ActiveRow.Index == 0) && httControlShiftEntity != null)
                    {
                        string logsBeg = httControlShiftEntity.ShiftBeg.Insert(2, ":");
                        logsBeg = (entity.ProBc == "3" ? DateTime.ParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).AddDays(-1).ToString("yyyy-MM-dd") : DateTime.ParseExact(date, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyy-MM-dd")) + " " + logsBeg;
                        DateTime dtLastEnd;
                        if ((httControlShiftEntity.ShiftBeg != null) && DateTime.TryParse(entity.LogsBeg, out dtBegin) && DateTime.TryParse(logsBeg, out dtLastEnd) &&
                            DateTime.TryParse(entity.LogsBeg, out dtBegin))
                        {
                            var diff = DateDiff(dtBegin, dtLastEnd);
                            if (diff > 0)
                                ultraGrid1.ActiveRow.Cells["TimeDiff"].Appearance.BackColor = Color.Red;
                            else ultraGrid1.ActiveRow.Cells["TimeDiff"].Appearance.ResetBackColor();
                            entity.TimeDiff = diff + " min";
                        }

                    }

                    if ((ultraGrid1.ActiveRow.Index > 0))
                        for (var i = ultraGrid1.ActiveRow.Index - 1; i >= 0; i--)
                        {
                            var Lastentity =
                                ultraGrid1.Rows[i].ListObject as HttControlLogEntity;
                            if ((Lastentity.ProductTime == "") || (Lastentity.ProductTime == "0"))
                            {
                            }
                            else
                            {
                                DateTime dtLastEnd;
                                if ((Lastentity != null) && DateTime.TryParse(Lastentity.LogsEnd, out dtLastEnd) &&
                                    DateTime.TryParse(entity.LogsBeg, out dtBegin))
                                {
                                    var diff = DateDiff(dtBegin, dtLastEnd);
                                    if (diff > 0)
                                        ultraGrid1.ActiveRow.Cells["TimeDiff"].Appearance.BackColor = Color.Red;
                                    else ultraGrid1.ActiveRow.Cells["TimeDiff"].Appearance.ResetBackColor();
                                    entity.TimeDiff = diff + " min";
                                }
                                break;
                            }
                        }

                    if ((ultraGrid1.ActiveRow.Index < ultraGrid1.Rows.Count - 1))
                        for (var j = ultraGrid1.ActiveRow.Index + 1; j < ultraGrid1.Rows.Count - 1; j++)
                        {
                            var Nextentity =
                                ultraGrid1.Rows[j].ListObject as HttControlLogEntity;

                            if ((Nextentity.ProductTime == "") || (Nextentity.ProductTime == "0"))
                            {
                            }
                            else
                            {
                                DateTime dtNextBeg;
                                if ((Nextentity != null) && DateTime.TryParse(Nextentity.LogsBeg, out dtNextBeg) &&
                                    DateTime.TryParse(entity.LogsEnd, out dtEnd))
                                {
                                    var diff = DateDiff(dtNextBeg, dtEnd);
                                    if (diff > 0)
                                        ultraGrid1.Rows[ultraGrid1.ActiveRow.Index + 1].Cells["TimeDiff"].Appearance
                                                .BackColor =
                                            Color.Red;
                                    else
                                        ultraGrid1.Rows[ultraGrid1.ActiveRow.Index + 1].Cells["TimeDiff"].Appearance
                                            .ResetBackColor();
                                    Nextentity.TimeDiff = diff + " min";
                                }
                                break;
                            }
                        }

                    var details =
                        httControlLogDetailEntityBindingSource.DataSource as List<HttControlLogDetailEntity>;
                    if ((details != null) && (details.Count == 1))
                    {
                        details[0].LogsBeg = entity.LogsBeg;
                        details[0].LogsEnd = entity.LogsEnd;
                        //ultraGrid3.Refresh();
                    }

                    var listEntity1 =
                        httControlLogEntityBindingSource.DataSource as List<HttControlLogEntity>;

                    ultraGrid1.DisplayLayout.Bands[0].Summaries["SumProductTime"].DisplayFormat = listEntity1.Sum(
                        p =>
                        {
                            var time = 0;
                            int.TryParse(p.ProductTime, out time);
                            return time;
                        }).ToString2();
                }

                if ((e.Cell.Column.Key == "Memo")) return;
                if (e.Cell.Column.Key == "StopType")
                {
                    var list1 = new ValueList();
                    var dt = TubeRoll.GetComBaseInfo(e.Cell.Value.ToString(), ob);
                    foreach (DataRow row in dt.Rows)
                        list1.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

                    e.Cell.Row.Cells["StopSmall"].ValueList = list1;

                    e.Cell.Row.Cells["StopSmall"].Value = "";
                    e.Cell.Row.Cells["StopReason"].Value = "";
                }
                if (e.Cell.Column.Key == "StopSmall")
                {
                    var list2 = new ValueList();
                    var dt2 = TubeRoll.GetComBaseInfo(e.Cell.Value.ToString(), ob);
                    foreach (DataRow row in dt2.Rows)
                        list2.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

                    e.Cell.Row.Cells["StopReason"].ValueList = list2;

                    e.Cell.Row.Cells["StopReason"].Value = "";
                }
            }
            catch (Exception)
            {
            }
            finally
            {
                ultraGrid1.Refresh();
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            if (ultraGrid1.ActiveRow == null) return;
            var entity = ultraGrid1.ActiveRow.ListObject as HttControlLogEntity;
            if (entity == null) return;
            if (entity.ProType == "停机")
            {
                //egpGroupBox.Expanded = true;

                var lists =
                    EntityHelper.GetData<HttControlLogDetailEntity>(
                        "com.steering.mes.mcp.Report.FrmHttControlLog.doQueryDetail",
                        new object[] { entity.ControlId }, ob);
                lists.ForEach(p => p.Chk = true);
                httControlLogDetailEntityBindingSource.DataSource = lists;
                //ultraGrid3.DisplayLayout.Override.AllowAddNew = AllowAddNew.TemplateOnBottom;
            }
            else
            {
                //egpGroupBox.Expanded = false;
                httControlLogDetailEntityBindingSource.DataSource = new List<HttControlLogDetailEntity>();
                //ultraGrid3.DisplayLayout.Override.AllowAddNew = AllowAddNew.No;
            }
        }


        private double DateDiff(DateTime DateTime1, DateTime DateTime2)
        {
            double dateDiff = 0;

            try
            {
                var ts1 = new TimeSpan(DateTime1.Ticks);

                var ts2 = new TimeSpan(DateTime2.Ticks);

                var ts = ts1.Subtract(ts2);

                dateDiff = ts.TotalMinutes;
            }

            catch
            {
            }

            return dateDiff;
        }

        private void ultraGrid3_CellChange(object sender, CellEventArgs e)
        {
            try
            {


                if (ultraGrid1.ActiveRow != null)
                    ultraGrid1.ActiveRow.Cells["Chk"].Value = true;


                if (((e.Cell.Column.Key == "LogsEnd") || (e.Cell.Column.Key == "LogsBeg")) && e.Cell.Text.Contains("_"))
                {

                    return;
                }
                if ((e.Cell.Column.Key == "Memo")) return;

                //ultraGrid3.UpdateData();
                if (e.Cell.Column.Key == "StopType")
                {
                    var list1 = new ValueList();
                    var dt = TubeRoll.GetComBaseInfo(e.Cell.Value.ToString(), ob);
                    foreach (DataRow row in dt.Rows)
                        list1.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

                    e.Cell.Row.Cells["StopSmall"].ValueList = list1;

                    e.Cell.Row.Cells["StopSmall"].Value = "";
                    e.Cell.Row.Cells["StopReason"].Value = "";
                }
                if (e.Cell.Column.Key == "StopSmall")
                {
                    var list2 = new ValueList();
                    var dt2 = TubeRoll.GetComBaseInfo(e.Cell.Value.ToString(), ob);
                    foreach (DataRow row in dt2.Rows)
                        list2.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

                    e.Cell.Row.Cells["StopReason"].ValueList = list2;

                    e.Cell.Row.Cells["StopReason"].Value = "";
                }
            }
            catch (Exception)
            {
            }
        }

        private void comPlineCode_ValueChanged(object sender, EventArgs e)
        {
            plineCode = comPlineCode.SelectedItem.DataValue.ToString();
            doQuery();
        }

        private void ultraGrid3_AfterRowInsert(object sender, RowEventArgs e)
        {
            e.Row.Cells["Chk"].Value = true;
            e.Row.Cells["ControlId"].Value = ultraGrid1.ActiveRow.Cells["ControlId"].Value;
        }

        private void ultraGrid3_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            var entity = e.Row.ListObject as HttControlLogDetailEntity;
            if (entity == null) return;

            var list1 = new ValueList();
            var dt = TubeRoll.GetComBaseInfo(entity.StopType, ob);
            foreach (DataRow row in dt.Rows)
                list1.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

            e.Row.Cells["StopSmall"].ValueList = list1;
            var list2 = new ValueList();
            var dt2 = TubeRoll.GetComBaseInfo(entity.StopSmall, ob);
            foreach (DataRow row in dt2.Rows)
                list2.ValueListItems.Add(row["BASECODE"].ToString(), row["BASENAME"].ToString());

            e.Row.Cells["StopReason"].ValueList = list2;
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            if (ultraGrid2.ActiveRow == null) return;
            var entity = ultraGrid2.ActiveRow.ListObject as HttControlLogEntity;
            if (entity == null) return;
            if (entity.ProType == "停机")
            {
                //egpGroupBox1.Expanded = true;

                var lists =
                    EntityHelper.GetData<HttControlLogDetailEntity>(
                        "com.steering.mes.mcp.Report.FrmHttControlLog.doQueryDetail",
                        new object[] { entity.ControlId }, ob);
                lists.ForEach(p => p.Chk = true);
                httControlLogDetailEntityBindingSource1.DataSource = lists;
            }
            else
            {
                //egpGroupBox1.Expanded = false;
                httControlLogDetailEntityBindingSource1.DataSource = new List<HttControlLogDetailEntity>();
            }
        }

        private void ultraGrid2_InitializeRow(object sender, InitializeRowEventArgs e)
        {
            try
            {
                var entity = e.Row.ListObject as HttControlLogEntity;
                if (entity == null) return;


                if (entity.ProType == "停机")
                    e.Row.Cells["ProType"].Appearance.BackColor = Color.Pink;

                DateTime dtBegin, dtEnd;
                if (DateTime.TryParse(entity.LogsBeg, out dtBegin) && DateTime.TryParse(entity.LogsEnd, out dtEnd))
                    if (dtBegin > dtEnd)
                        e.Row.Cells["LogsEnd"].Appearance.BackColor = Color.Red;
                    else
                        e.Row.Cells["LogsEnd"].Appearance.ResetBackColor();


                ultraGrid2.Refresh();
            }
            catch (Exception)
            {
            }
        }

        private void cmbTextDefault_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            var TextEdit = new TextEdit { data = ultraGrid1.ActiveCell.Text };
            TextEdit.ShowDialog();

            if (TextEdit.DialogResult == DialogResult.OK)
            {
                ultraGrid1.ActiveCell.Value = TextEdit.data;
                ultraGrid1.UpdateData();

                //if (ultraGrid1.ActiveRow != null)
                //    ultraGrid1.ActiveRow.Cells["Chk"].Value = true;
            }
        }

        private void cmsCopy_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            UltraGrid ug = (sender as ContextMenuStrip).SourceControl as UltraGrid;
            if (ug == null || ug.ActiveCell == null)
            {
                return;
            }



            if (e.ClickedItem.Name == "tsmCopy")
            {
                Clipboard.SetText(ug.ActiveCell.Text);

            }
            else
            {

                if (ug.ActiveCell.Activation == Activation.AllowEdit && ultraGrid1.ActiveRow != null && ultraGrid1.ActiveRow.Cells["ConfirmFlag"].Value.ToString() == "未确认")
                {
                    string text = Clipboard.GetText();
                    try
                    {
                        ug.ActiveCell.Value = text;
                    }
                    catch (Exception)
                    {

                    }

                }
            }
        }
    }
}