MES_Client/TGMES/Core.StlMes.Client.ZGMil/Signature/FrmStlControlLogCollect.cs

using com.steering.mes.zgmil.entity;
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.ZGMil.Entity;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Core.StlMes.Client.ZGMil.Signature
{
    public partial class FrmStlControlLogCollect : FrmBase
    {
        private string departm = "";
        UltraComboEditor ucePline = new UltraComboEditor();//产线名称
        private string plineCode;
        private string userId = "";
        private string[] plineCodes = { };
        //int stratday;//开始时间日期差，天，时，分
        //int strathours;
        //int stratminutes;
        //int endday;//结束时间日期差，天，时，分
        //int endhours;
        //int endminutes;toolba
        int flag = 0;//分析时间错误
        int flag1 = 0;//分析相差时间
        private string basecodeSamll = "";//停机小类值
        private string basecodeReason = "";//停机原因值
        public FrmStlControlLogCollect()
        {
            InitializeComponent();
        }

        private void FrmStlControlLogCollect_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<StlControlLogEntity>(ultraGrid1.DisplayLayout.Bands[0]);

            NativeMethodNew na = new NativeMethodNew(this.ob);
            departm = UserInfo.GetDepartment();
            userId = UserInfo.GetUserID();
            plineCode = na.GetPCode(departm);//获取 用户 对应的产线
            plineCodes = na.GetPlineCode(this.ValidDataPurviewIds);
            //cmbPline.DataSource = ServerHelper.GetData("com.steering.mes.signature.FrmTubeRollFileManage.queryPlineCode", new object[] { plineCode }, this.ob);
            //cmbPline.ValueMember = "PLINE_CODE";
            //cmbPline.DisplayMember = "PLINE_NAME";
            //TubeRoll.SetComboItemHeight(cmbPline);
            //cmbPlineE.DataSource = ServerHelper.GetData("com.steering.mes.signature.FrmTubeRollFileManage.queryPlineCode", new object[] { plineCode }, this.ob);
            //cmbPlineE.ValueMember = "PLINE_CODE";
            //cmbPlineE.DisplayMember = "PLINE_NAME";
            //TubeRoll.SetComboItemHeight(cmbPlineE);
            if (plineCode.Equals(""))
            {
                this.chkpline.Visible = true;
                this.cmbPline.Visible = true;
            }
            
            //cmbDate.MaxDate = DateTime.Now;
            cmbDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
            cmbDate2.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
            cmbPline.Value = na.GetPCodePline(this.ValidDataPurviewIds);

            TubeRoll.setUltraGridColumnInput(ultraGrid1, new string[] { "QualifiedNum", "ScrapNum" });//支数
            TubeRoll.setUltraGridColumnMaxInput(ultraGrid1, new string[] { "QualifiedWt", "ScrapWt" });//重量
            TubeRoll.SetComboItemHeight(cmbPline);
            TubeRoll.SetComboItemHeight(cmbBc);
            TubeRoll.SetComboItemHeight(cmbBz);


            DataTable dt = TubeRoll.GetComBaseInfo("3001", ob);
            cmbStop.DataSource = dt;
            cmbStop.ValueMember = "BASECODE";
            cmbStop.DisplayMember = "BASENAME";
            TubeRoll.SetComboItemHeight(cmbStop);
        }
        /// <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("0");
                //    break;
                case "Update":
                    doUpdate();
                    break;
                //case "Delete":
                //    doDelete();
                //    break;
                case "Analysis":
                    doQuery();
                    doAnalysis();
                    break;
                //case "Confirm":
                //    doConfirm();
                //    break;
                //case "UpConfirm":
                //    UpConfirm();
                //    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":
                    this.Close();
                    break;
            }
        }
        /// <summary>
        /// 生产记录
        /// </summary>
        private void DoProduction()
        {
            FrmProductionDetails pro = new FrmProductionDetails(cmbDate.Value.ToString("yyyyMMdd"), plineCode, this.ob);
            pro.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            pro.Text = "生产详细";
            pro.ShowDialog();
        }
        /// <summary>
        /// 查询统计数据
        /// </summary>
        private void DoStatistical()
        {
            

            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) { MessageUtil.ShowTips("无数据！"); return; }
            //foreach (UltraGridRow urg in ultraGrid1.Rows)
            //{
            //    if (row.Cells["ConfirmFlag"].Text.Equals("未确认")) { MessageUtil.ShowTips("未确认,不允许此操作！"); return; }
            //}
            FrmStatistical 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()
        {
            ArrayList list = new ArrayList();
            //当天
            string date = "";
            //前一天
            string endDate = "";

            date = cmbDate.Value.ToString("yyyyMMdd");
            endDate = cmbDate2.Value.ToString("yyyyMMdd");
            if (this.chkpline.Checked)
            {
                plineCode = this.cmbPline.Value.ToString();
            }
            else 
            {
                NativeMethodNew na = new NativeMethodNew(this.ob);
                plineCode = na.GetPCode(departm);
            }
            //当班数据
            List<StlControlLogEntity> listSource = EntityHelper.GetData<StlControlLogEntity>
                ("com.steering.mes.signature.FrmStlControlLog.doQueryPlanCollect", new object[] { date, endDate, plineCode }, this.ob);
            StlControlLogEntity.DataSource = listSource;
            GridHelper.RefreshAndAutoSize(ultraGrid1);
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["LogsBeg"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DateTimeWithSpin;
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["LogsBeg"].MaskInput = "yyyy-mm-dd hh:mm";
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["LogsEnd"].Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DateTimeWithSpin;
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["LogsEnd"].MaskInput = "yyyy-mm-dd hh:mm";

        }
        /// <summary>
        /// 一键处理新增（分析后五分钟以内的时间间隔）
        /// </summary>
        //private void DoOneKeyProces()
        //{
        //    ultraGrid1.UpdateData();
        //    UltraGridRow row = ultraGrid1.ActiveRow;
        //    if (row == null) { MessageUtil.ShowTips("无数据，不允许此操作！"); return; }
        //    int minutes = int.Parse(MinTime.Value.ToString());
        //    if (minutes == 0) { MessageUtil.ShowTips("请输入相差时间！"); }
        //    ArrayList pram = new ArrayList();
        //    if (flag == 0) { MessageUtil.ShowTips("未分析，不允许此操作！"); return; }
        //    if (flag == 1 && flag1 == 0) { MessageUtil.ShowTips("分析通过，不允许此操作！"); return; }
        //    if (flag == 2) { MessageUtil.ShowTips("分析时间错误，不允许此操作！"); return; }
        //    int i = 0;
        //    try
        //    {
        //        foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //        {
        //            //if (ugr.Cells["ConfirmFlag"].Text.Equals("已确认"))
        //            //{
        //            //    MessageUtil.ShowTips("已确认数据，不允许此操作！");
        //            //    return;

        //            //}
        //            if (!ugr.Cells["LogsEnd"].Value.Equals(""))
        //            {
        //                i += 1;
        //            }
        //        }
        //        for (int j = 0; j < i; j++)
        //        {
        //            string loagEnd = ultraGrid1.Rows[j].Cells["LogsEnd"].Text.ToString();
        //            string loagBeg = "";
        //            if (j + 1 < i)
        //            {
        //                loagBeg = ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Text.ToString();
        //                if (DateTime.Compare(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) > 0)
        //                {
        //                    if (TubeRoll.JudgeTimeMax(Convert.ToDateTime(loagEnd), Convert.ToDateTime(loagBeg)) <= minutes
        //                         && TubeRoll.JudgeTimeMax(Convert.ToDateTime(loagEnd), Convert.ToDateTime(loagBeg)) > 0)
        //                    {
        //                        ArrayList list = new ArrayList();
        //                        list.Add(DateTime.Parse(ultraGrid1.Rows[j].Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                        list.Add(DateTime.Parse(ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                        list.Add(this.UserInfo.GetUserName());
        //                        list.Add(this.UserInfo.GetUserOrder());
        //                        list.Add(this.UserInfo.GetUserGroup());
        //                        list.Add(plineCode);
        //                        pram.Add(list);
        //                    }
        //                }
        //            }
        //        }
        //        if (MessageUtil.ShowYesNoAndQuestion("是否一键新增处理?") == DialogResult.No)
        //        {
        //            return;
        //        }
        //        CoreClientParam ccp = new CoreClientParam();
        //        ccp.ServerName = "com.steering.mes.signature.FrmMilControlLog";
        //        ccp.MethodName = "oneKeyProcesMilControlLog";
        //        ccp.ServerParams = new object[] { pram };
        //        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        //        if (ccp.ReturnCode != -1)
        //        {
        //            MessageUtil.ShowTips(ccp.ReturnInfo);
        //            if (ccp.ReturnInfo.Equals("一键处理成功!"))
        //            {
        //                doQuery();
        //                doAnalysis();
        //            }
        //        }


        //    }
        //    catch (Exception ex)
        //    {
        //        MessageUtil.ShowTips("开始时间或结束时间不能为空！");
        //    }

        //}
        /// <summary>
        /// 一键修改
        /// </summary>
        //private void DoOneKeyUpdate()
        //{
        //    ultraGrid1.UpdateData();
        //    UltraGridRow row = ultraGrid1.ActiveRow;
        //    if (row == null) { MessageUtil.ShowTips("无数据，不允许此操作！"); return; }
        //    ArrayList pram = new ArrayList();
        //    if (flag == 0) { MessageUtil.ShowTips("未分析，不允许此操作！"); return; }
        //    if (flag == 1 && flag1 == 0) { MessageUtil.ShowTips("分析通过，不允许此操作！"); return; }
        //    //if (flag == 2) { MessageUtil.ShowTips("分析时间错误，不允许此操作！"); return; }
        //    int i = 0;
        //    try
        //    {
        //        foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //        {
        //            //if (ugr.Cells["ConfirmFlag"].Text.Equals("已确认"))
        //            //{
        //            //    MessageUtil.ShowTips("已确认数据，不允许此操作！");
        //            //    return;
        //            //}
        //            if (!ugr.Cells["LogsEnd"].Value.Equals(""))
        //            {
        //                i += 1;
        //            }
        //        }
        //        for (int j = 0; j < i; j++)
        //        {
        //            string loagEnd = ultraGrid1.Rows[j].Cells["LogsEnd"].Text.ToString();
        //            string loagBeg = "";
        //            if (j + 1 < i)
        //            {
        //                loagBeg = ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Text.ToString();
        //                if (DateTime.Compare(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) < 0)
        //                {
        //                    ArrayList list = new ArrayList();
        //                    list.Add(DateTime.Parse(ultraGrid1.Rows[j].Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                    list.Add(DateTime.Parse(ultraGrid1.Rows[j].Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                    list.Add(DateTime.Parse(ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                    list.Add(this.UserInfo.GetUserName());
        //                    list.Add(this.UserInfo.GetUserOrder());
        //                    list.Add(this.UserInfo.GetUserGroup());
        //                    list.Add(plineCode);
        //                    list.Add(ultraGrid1.Rows[j].Cells["ControlId"].Value.ToString());
        //                    pram.Add(list);
        //                }
        //            }
        //        }

        //        if (ultraGrid1.Rows.Count > 0 && ultraGrid2.Rows.Count > 0)
        //        {
        //            int a = ultraGrid2.Rows.Count;
        //            string logsBeg = ultraGrid1.Rows[0].Cells["LogsBeg"].Value.ToString();
        //            string logsEnd = ultraGrid2.Rows[a - 1].Cells["LogsEnd"].Value.ToString();
        //            string ControlId = ultraGrid1.Rows[0].Cells["ControlId"].Value.ToString();
        //            if (DateTime.Compare(Convert.ToDateTime(logsBeg), Convert.ToDateTime(logsEnd)) < 0)
        //            {
        //                logsEnd = DateTime.Parse(logsEnd).ToString("yyyyMMddHHmm");
        //                ServerHelper.SetData("com.steering.mes.signature.FrmMilControlLog.updateOneDate", new object[] { logsEnd, ControlId }, this.ob);
        //            }
        //        }

        //        if (MessageUtil.ShowYesNoAndQuestion("是否一键修改处理?") == DialogResult.No)
        //        {
        //            return;
        //        }
        //        CoreClientParam ccp = new CoreClientParam();
        //        ccp.ServerName = "com.steering.mes.signature.FrmMilControlLog";
        //        ccp.MethodName = "oneKeyUpdateMilControlLog";
        //        ccp.ServerParams = new object[] { pram };
        //        ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        //        if (ccp.ReturnCode != -1)
        //        {
        //            MessageUtil.ShowTips(ccp.ReturnInfo);
        //            if (ccp.ReturnInfo.Equals("一键处理成功!"))
        //            {
        //                doQuery();
        //                doAnalysis();
        //            }
        //        }
        //    }
        //    catch (Exception ex)
        //    {
        //        MessageUtil.ShowTips("开始时间或结束时间不能为空！");
        //    }
        //}
        /// <summary>
        /// 新增
        /// </summary>
        //private void doAdd()
        //{
        //    ultraGrid1.UpdateData();
        //    ArrayList pram = new ArrayList();
        //    UltraGridRow row = ultraGrid1.ActiveRow;
        //    int count = 0;
        //    int statrindex = 0;//第一行记录
        //    int endindex = 0;//最后一行记录
        //    int indexEnd = 0;//获取Grid最后一行记录
        //    string statime = "";//新增开始时间
        //    string endtime = "";//新增结束时间
        //    string datetime1 = "";//获取选中第一行结束时间
        //    string datetime2 = "";//获取选中第二行开始时间
        //    if (row != null)
        //    {
        //        try
        //        {
        //            foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //            {
        //                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
        //                {
        //                    //if (ugr.Cells["ConfirmFlag"].Text.Equals("已确认"))
        //                    //{
        //                    //    MessageUtil.ShowTips("已确认数据，不允许此操作！");
        //                    //    return;
        //                    //}
        //                    statime = DateTime.Parse(ugr.Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm");//新增开始时间
        //                    datetime1 = DateTime.Parse(ugr.Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm");
        //                    statrindex = ugr.Index;
        //                    break;
        //                }
        //            }
        //            foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //            {
        //                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
        //                {
        //                    count += 1;
        //                    endindex = ugr.Index;
        //                    endtime = DateTime.Parse(ugr.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm");//新增结束时间
        //                    datetime2 = DateTime.Parse(ugr.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm");
        //                }
        //                indexEnd = ugr.Index;
        //            }

        //            //判断选中的两行没有时间差，不许增加
        //            int cnt = ultraGrid1.Rows.Where(a => a.GetValue("CHK") == "True").Count();
        //            if (datetime2 == datetime1 && cnt > 1)
        //            { MessageUtil.ShowTips("选中的两行没有时间差，不允许增加！"); return; }

        //            int index = endindex - statrindex;
        //            if (index == 0)
        //            {
        //                if (statrindex == 0)//获取第一行
        //                {
        //                    if (indexEnd == 0)//如果只有一条数据
        //                    {
        //                        FrmPopupWindow win = new FrmPopupWindow();
        //                        win.AutoSize = true;
        //                        win.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
        //                        win.Text = "提示";
        //                        win.ShowDialog();
        //                        if (win.DialogResult == System.Windows.Forms.DialogResult.OK)
        //                        {
        //                            if (win.Popup == "之前")
        //                            {
        //                                pram.Add(DateTime.Parse(row.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                                pram.Add(DateTime.Parse(row.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                            }
        //                            else if (win.Popup == "之后")
        //                            {
        //                                pram.Add(DateTime.Parse(row.Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                                pram.Add(DateTime.Parse(row.Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                            }
        //                            else
        //                            {
        //                                return;
        //                            }
        //                        }
        //                    }
        //                    else
        //                    {
        //                        foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //                        {
        //                            if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
        //                            {
        //                                pram.Add(DateTime.Parse(ugr.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                                pram.Add(DateTime.Parse(ugr.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                            }
        //                        }
        //                    }

        //                }
        //                else if (statrindex == indexEnd)//获取最后一行
        //                {
        //                    foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //                    {
        //                        if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
        //                        {
        //                            pram.Add(DateTime.Parse(ugr.Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                            pram.Add(DateTime.Parse(ugr.Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //                        }
        //                    }
        //                }
        //                else
        //                {
        //                    if (count == 0 || count > 2 || count < 2 && index < 2)
        //                    {
        //                        MessageUtil.ShowTips("请选择数据且选择相邻两条数据新增！");
        //                        return;
        //                    }
        //                    if (MessageUtil.ShowYesNoAndQuestion("是否新增?") == DialogResult.No)
        //                    {
        //                        return;
        //                    }
        //                    pram.Add(statime);
        //                    pram.Add(endtime);
        //                }
        //            }
        //            else
        //            {
        //                if (count == 0 || count > 2 || count < 2 && index < 2)
        //                {
        //                    MessageUtil.ShowTips("请选择数据且选择相邻两条数据新增！");
        //                    return;
        //                }
        //                if (MessageUtil.ShowYesNoAndQuestion("是否新增?") == DialogResult.No)
        //                {
        //                    return;
        //                }
        //                pram.Add(statime);
        //                pram.Add(endtime);
        //            }

        //        }
        //        catch (Exception ex)
        //        {
        //            MessageUtil.ShowTips("开始时间或结束时间不能为空！");
        //            return;
        //        }
        //    }
        //    else//Grid 为空
        //    {
        //        if (MessageUtil.ShowYesNoAndQuestion("当前班次无数据是否新增?") == DialogResult.No)
        //        {
        //            return;
        //        }
        //        pram.Add(cmbDate.Value.ToString("yyyyMMdd") + DateTime.Now.ToString("HHmm"));
        //        pram.Add(cmbDate.Value.ToString("yyyyMMdd") + DateTime.Now.ToString("HHmm"));
        //        //pram.Add(DateTime.Now.ToString("yyyyMMddHHmm"));
        //        //pram.Add(DateTime.Now.ToString("yyyyMMddHHmm"));
        //    }
        //    pram.Add(this.UserInfo.GetUserName());
        //    pram.Add(this.UserInfo.GetUserOrder());
        //    pram.Add(this.UserInfo.GetUserGroup());
        //    pram.Add(plineCode);
        //    CoreClientParam ccp = new CoreClientParam();
        //    ccp.ServerName = "com.steering.mes.signature.FrmMilControlLog";
        //    ccp.MethodName = "addMilControlLog";
        //    ccp.ServerParams = new object[] { pram };
        //    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        //    if (ccp.ReturnCode != -1)
        //    {
        //        MessageUtil.ShowTips(ccp.ReturnInfo);
        //        if (ccp.ReturnInfo.Equals("新增成功!"))
        //        {
        //            doQuery();
        //            doAnalysis();
        //        }
        //    }

        //}
       
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="ifConfirm">0只能修改未确认的，1可以修改已确认的</param>
        /// 
        private void doUpdate()
        {
            ultraGrid1.UpdateData();
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) { MessageUtil.ShowTips("无数据！"); return; }

            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)
            {
                StlControlLogEntity stlControlLogEntity = (StlControlLogEntity)uRow.ListObject;
                //if (stlControlLogEntity.ConfirmFlag.Equals("1"))
                //{
                //    MessageUtil.ShowTips("已确认的数据不能修改!");
                //    return;
                //}
                stlControlLogEntity.LogsBeg = DateTime.Parse(uRow.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm");
                stlControlLogEntity.LogsEnd = DateTime.Parse(uRow.Cells["LogsEnd"].Value.ToString()).ToString("yyyyMMddHHmm");
                //stlControlLogEntity.StopType = row.Cells["StopType"].Value.ToString();
                stlControlLogEntity.StopReason = basecodeReason;
                stlControlLogEntity.StopSmall = basecodeSamll;
                string matZcTity = JSONFormat.Format(stlControlLogEntity);
                pram.Add(matZcTity);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.signature.FrmStlControlLog";
            ccp.MethodName = "updateMilControlLog";
            ccp.ServerParams = new object[] { pram };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功!"))
                {
                    doQuery();
                    //doAnalysis();
                }
            }

        }

       
        /// <summary>
        /// 删除
        /// </summary>
        //private void doDelete()
        //{
        //    ultraGrid1.UpdateData();
        //    UltraGridRow row = ultraGrid1.ActiveRow;
        //    if (row == null) { MessageUtil.ShowTips("无数据！"); return; }
        //    int count = 0;
        //    ArrayList list = new ArrayList();
        //    foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //    {
        //        if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
        //        {
        //            count += 1;
        //            //只有各厂总账号可以删除正常数据，普通账号只可删除停机数据。
        //            if (userId != "250001" && userId != "1680001" && userId != "2580001" && userId != "4600001")
        //            {
        //                if (ugr.Cells["ProType"].Text.Equals("正常"))
        //                {
        //                    MessageUtil.ShowTips("请选择停机数据！");
        //                    return;
        //                }
        //            }
                    
        //            if (ugr.Cells["ConfirmFlag"].Text.Equals("已确认"))
        //            {
        //                MessageUtil.ShowTips("已确认数据，不允许此操作！");
        //                return;

        //            }
        //            ArrayList pram = new ArrayList();
        //            pram.Add(ugr.Cells["ControlId"].Value.ToString());
        //            list.Add(pram);
        //        }

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

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

        //    CoreClientParam ccp = new CoreClientParam();
        //    ccp.ServerName = "com.steering.mes.signature.FrmMilControlLog";
        //    ccp.MethodName = "deleteMilControlLog";
        //    ccp.ServerParams = new object[] { list };
        //    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        //    if (ccp.ReturnCode != -1)
        //    {
        //        MessageUtil.ShowTips(ccp.ReturnInfo);
        //        if (ccp.ReturnInfo.Equals("删除成功!"))
        //        {
        //            doQuery();
        //            doAnalysis();
        //        }
        //    }
        //}
        /// <summary>
        ///分析
        /// </summary>
        private void doAnalysis()
        {

            flag = 1;
            flag1 = 0;
            int i = 0;
            try
            {
                //当班数据分析
                foreach (UltraGridRow ugr in ultraGrid1.Rows)
                {
                    if (!ugr.Cells["LogsEnd"].Value.Equals(""))
                    { i += 1; }
                    if (!ugr.Cells["LogsEnd"].Value.Equals(""))
                    {

                        if (Convert.ToDateTime(ugr.Cells["LogsBeg"].Value.ToString()) > Convert.ToDateTime(ugr.Cells["LogsEnd"].Value.ToString()))
                        {
                            ugr.RowSelectorAppearance.BackColor = Color.Red;
                            //ugr.Cells["LogsBeg"].Appearance.BackHatchStyle = BackHatchStyle.None;
                            //ugr.Cells["LogsEnd"].Appearance.BackColor = Color.Red;
                            //ugr.Cells["LogsEnd"].Appearance.BackHatchStyle = BackHatchStyle.None;
                            flag = 2;//分析时间错误
                        }
                    }
                }
                for (int j = 0; j < i; j++)
                {
                    string loagEnd = ultraGrid1.Rows[j].Cells["LogsEnd"].Text.ToString();
                    string loagBeg = "";
                    if (j + 1 < i)
                    {
                        loagBeg = ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Text.ToString();
                        if (DateTime.Compare(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) > 0)
                        {
                            if (TubeRoll.JudgeTime(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) > 0)
                            {
                                ultraGrid1.Rows[j + 1].Cells["StopType"].Appearance.BackColor = Color.Pink;
                                ultraGrid1.Rows[j + 1].Cells["StopType"].Appearance.BackHatchStyle = BackHatchStyle.None;
                                ultraGrid1.Rows[j].Cells["StopType"].Appearance.BackColor = Color.Pink;
                                ultraGrid1.Rows[j].Cells["StopType"].Appearance.BackHatchStyle = BackHatchStyle.None;
                                flag1 = 1;//时间差
                            }
                            //else if (TubeRoll.JudgeTime(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) <= 5 && TubeRoll.JudgeTime(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd))>=3)
                            //{
                            //    ultraGrid1.Rows[j + 1].Cells["StopType"].Appearance.BackColor = Color.LightGray;
                            //    ultraGrid1.Rows[j + 1].Cells["StopType"].Appearance.BackHatchStyle = BackHatchStyle.None;
                            //    ultraGrid1.Rows[j].Cells["StopType"].Appearance.BackColor = Color.LightGray;
                            //    ultraGrid1.Rows[j].Cells["StopType"].Appearance.BackHatchStyle = BackHatchStyle.None;
                            //    flag = 2;
                            //}
                        }
                        else if (DateTime.Compare(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) < 0)
                        {
                            ultraGrid1.Rows[j].RowSelectorAppearance.BackColor = Color.Red;
                            //ultraGrid1.Rows[j + 1].RowSelectorAppearance.BackColor = Color.Red;
                            //ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Appearance.BackColor = Color.Orange;
                            //ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Appearance.BackHatchStyle = BackHatchStyle.None;
                            //ultraGrid1.Rows[j].Cells["LogsBeg"].Appearance.BackColor = Color.Orange;
                            //ultraGrid1.Rows[j].Cells["LogsBeg"].Appearance.BackHatchStyle = BackHatchStyle.None;
                            flag = 2;
                        }
                        TimeSpan timeSpan = DateTime.Parse(ultraGrid1.Rows[j + 1].Cells["LogsBeg"].Value.ToString()) -
                            DateTime.Parse(ultraGrid1.Rows[j].Cells["LogsEnd"].Value.ToString());
                        ultraGrid1.Rows[j + 1].Cells["TimeDiff"].Value = timeSpan.TotalMinutes.ToString();
                    }
                }

                //上班数据分析
                //i = 0;
                //foreach (UltraGridRow ugr in ultraGrid2.Rows)
                //{
                //    if (!ugr.Cells["LogsBeg"].Value.Equals(""))
                //    { i += 1; }
                //    if (!ugr.Cells["LogsEnd"].Value.Equals(""))
                //    {
                //        //i += 1;
                //        if (Convert.ToDateTime(ugr.Cells["LogsBeg"].Value.ToString()) > Convert.ToDateTime(ugr.Cells["LogsEnd"].Value.ToString()))
                //        {
                //            ugr.RowSelectorAppearance.BackColor = Color.Red;
                //            flag = 2;//分析时间错误
                //        }
                //    }
                //}
                //for (int j = 0; j < i; j++)
                //{
                //    string loagEnd = ultraGrid2.Rows[j].Cells["LogsEnd"].Text.ToString();
                //    string loagBeg = "";
                //    if (j + 1 < i)
                //    {
                //        loagBeg = ultraGrid2.Rows[j + 1].Cells["LogsBeg"].Text.ToString();
                //        if (DateTime.Compare(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) > 0)
                //        {
                //            if (TubeRoll.JudgeTime(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) > 0)
                //            {
                //                ultraGrid2.Rows[j + 1].Cells["StopType"].Appearance.BackColor = Color.Pink;
                //                ultraGrid2.Rows[j + 1].Cells["StopType"].Appearance.BackHatchStyle = BackHatchStyle.None;
                //                ultraGrid2.Rows[j].Cells["StopType"].Appearance.BackColor = Color.Pink;
                //                ultraGrid2.Rows[j].Cells["StopType"].Appearance.BackHatchStyle = BackHatchStyle.None;
                //                flag1 = 1;//时间差
                //            }
                //        }
                //        else if (DateTime.Compare(Convert.ToDateTime(loagBeg), Convert.ToDateTime(loagEnd)) < 0)
                //        {
                //            ultraGrid2.Rows[j].RowSelectorAppearance.BackColor = Color.Red;
                //            flag = 2;
                //        }
                //        TimeSpan timeSpan = DateTime.Parse(ultraGrid2.Rows[j + 1].Cells["LogsBeg"].Value.ToString()) -
                //            DateTime.Parse(ultraGrid2.Rows[j].Cells["LogsEnd"].Value.ToString());
                //        ultraGrid2.Rows[j + 1].Cells["TimeDiff"].Value = timeSpan.TotalMinutes.ToString();
                //    }
                //}
                //if (ultraGrid1.Rows.Count > 0 && ultraGrid2.Rows.Count > 0)
                //{
                //    string logsBeg = ultraGrid1.Rows[0].Cells["LogsBeg"].Value.ToString();
                //    string logsEnd = ultraGrid2.Rows[i - 1].Cells["LogsEnd"].Value.ToString();
                //    if (DateTime.Compare(Convert.ToDateTime(logsBeg), Convert.ToDateTime(logsEnd)) > 0)
                //    {
                //        if (TubeRoll.JudgeTime(Convert.ToDateTime(logsBeg), Convert.ToDateTime(logsEnd)) > 0)
                //        {
                //            flag1 = 1;//时间差
                //        }
                //    }
                //    else if (DateTime.Compare(Convert.ToDateTime(logsBeg), Convert.ToDateTime(logsEnd)) < 0)
                //    {
                //        flag = 2;
                //    }
                //    TimeSpan timeSpan = DateTime.Parse(logsBeg) - DateTime.Parse(logsEnd);
                //    ultraGrid1.Rows[0].Cells["TimeDiff"].Value = timeSpan.TotalMinutes.ToString();
                //}
            }
            catch (Exception ex)
            {
                // MessageUtil.ShowTips(ex.Message);
                MessageUtil.ShowTips("开始时间或结束时间不能为空！");
            }
        }


        private string DateDiff(DateTime DateTime1, DateTime DateTime2)
        {

            string dateDiff = null;

            try
            {

                TimeSpan ts1 = new TimeSpan(DateTime1.Ticks);

                TimeSpan ts2 = new TimeSpan(DateTime2.Ticks);

                TimeSpan ts = ts1.Subtract(ts2).Duration();

                dateDiff = ts.Minutes.ToString();

            }

            catch
            {

            }

            return dateDiff;

        }
        /// <summary>
        ///确认
        /// </summary>
        //private void doConfirm()
        //{
        //    UltraGridRow uow = ultraGrid1.ActiveRow;
        //    if (uow == null) { MessageUtil.ShowTips("无数据！"); return; }
        //    ArrayList list = new ArrayList();
        //    string date = DateTime.Now.ToString();
        //    int count = 0;
        //    if (flag == 0) { MessageUtil.ShowTips("未分析，不允许此操作！"); return; }
        //    if (flag1 == 1) { MessageUtil.ShowTips("有停机记录未新增，不允许此操作！"); return; }
        //    if (flag == 2) { MessageUtil.ShowTips("分析时间错误，不允许此操作！"); return; }
        //    foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //    {
        //        if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true && ugr.Cells["LogsBeg"].Value.ToString().Equals(""))
        //        {
        //            MessageUtil.ShowTips("有开始时间为空，不允许此操作！"); return;
        //        }
        //        if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true && ugr.Cells["LogsEnd"].Value.ToString().Equals(""))
        //        {
        //            MessageUtil.ShowTips("有结束时间为空，不允许此操作！"); return;
        //        }

        //    }

        //    ultraGrid1.UpdateData();
        //    int seqmin1 = ultraGrid1.Rows.Where(a => a.GetValue("CHK") == "True").Select(a => a.Index).Count();
        //    if (seqmin1 < 1)
        //    {
        //        MessageUtil.ShowTips("没有选中要确认的数据！"); return;
        //    }
        //    if (seqmin1 > 0 && ultraGrid1.Rows.Count > 0)
        //    {
        //        int seqmin = ultraGrid1.Rows.Where(a => a.GetValue("CHK") == "True").Select(a => a.Index).Min();
        //        for (int i = 0; i < seqmin; i++)
        //        {
        //            if (ultraGrid1.Rows[i].Cells["ConfirmFlag"].Value.ToString().Trim().Equals("未确认"))
        //            {
        //                MessageBox.Show("前面有未确认的数据，请先确认!");
        //                return;
        //            }
        //        }
        //    }



        //    //if (flag2 == 1) { MessageUtil.ShowTips("有开始时间为空，不允许此操作！"); return; }
        //    //if (flag2 == 2) { MessageUtil.ShowTips("有结束时间为空，不允许此操作！"); return; }
        //    //判断上班是否有未确认的数据
        //    if (ultraGrid2.Rows.Count() < 1)
        //    {
        //        MessageBox.Show("上班有停机记录未新增!");
        //        return;
        //    }
        //    foreach (UltraGridRow row in ultraGrid2.Rows)
        //    {
        //        if (row.Cells["ConfirmFlag"].Value.ToString().Trim().Equals("未确认"))
        //        {
        //            MessageBox.Show("上班有未确认的数据，请先确认!");
        //            return;
        //        }
        //    }
        //    string startdate = "";
        //    string endDate = "";
        //    if (chkDate.Checked)
        //    {
        //        startdate = cmbDate.Value.ToString("yyyyMMdd1800");
        //    }
        //    else
        //    {
        //        MessageUtil.ShowTips("请选择日期！");
        //        return;
        //        //startdate = cmbDate.Value.ToString("199901012100");
        //        //endDate = cmbEndDate.Value.ToString("203901012100");
        //    }

        //    foreach (UltraGridRow ugr in ultraGrid1.Rows)
        //    {

        //        if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
        //        {
        //            if (ugr.Cells["ProType"].Text.ToString().Trim().Equals("停机"))
        //            {
        //                if (ugr.Cells["StopType"].Value.Equals("") || ugr.Cells["StopSmall"].Value.Equals("") || ugr.Cells["StopReason"].Value.Equals(""))
        //                {
        //                    MessageUtil.ShowTips("停机大类,停机小类,停机原因不能为空！");
        //                    return;
        //                }
        //            }
        //            string shift = ugr.Cells["ProBc"].Value.ToString();
        //            string group = ugr.Cells["ProBz"].Value.ToString();
        //            if (shift != this.UserInfo.GetUserOrder() || group != this.UserInfo.GetUserGroup())
        //            {
        //                MessageUtil.ShowTips("您登录的班次班组与要确认的数据班次班组不符，请重新确认！");
        //                return;
        //            }
        //            count += 1;
        //            ArrayList list1 = new ArrayList();
        //            list1.Add(ugr.Cells["ControlId"].Text.ToString());
        //            list1.Add(this.UserInfo.GetUserName());
        //            list1.Add(date);
        //            list1.Add(this.UserInfo.GetUserOrder());
        //            list1.Add(this.UserInfo.GetUserGroup());
        //            list1.Add(plineCode);
        //            list1.Add(DateTime.Parse(ugr.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
        //            list1.Add(startdate);
        //            list1.Add(endDate);
        //            list1.Add(ugr.Cells["JudgeStoveNo"].Text.ToString());
        //            list.Add(list1);
        //        }
        //    }
        //    if (count == 0)
        //    {
        //        MessageUtil.ShowTips("请选中要确认的数据！");
        //        return;
        //    }
        //    string intCount = "0";//是否选择确认
        //    if (MessageUtil.ShowYesNoAndQuestion("是否只确认选中行数据？") == DialogResult.No)
        //    {
        //        intCount = "0";
        //        if (count == 2)
        //        {
        //            MessageUtil.ShowTips("请选择一条数据！");
        //            return;
        //        }
        //    }
        //    else
        //    {
        //        intCount = "1";
        //    }
        //    //if (MessageUtil.ShowYesNoAndQuestion("是否确认?") == DialogResult.No)
        //    //{
        //    //    return;
        //    //}
        //    UltraGridRow ugr1 = ultraGrid1.ActiveRow;
        //    if (ugr1 != null)
        //    {
        //        string logbeg = ugr1.Cells["LogsBeg"].Value.ToString();

        //    }

        //    CoreClientParam ccp = new CoreClientParam();
        //    ccp.ServerName = "com.steering.mes.signature.FrmMilControlLog";
        //    ccp.MethodName = "confirmMilControlLog";
        //    ccp.ServerParams = new object[] { list, intCount };
        //    ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
        //    if (ccp.ReturnCode != -1)
        //    {
        //        MessageUtil.ShowTips(ccp.ReturnInfo);
        //        if (ccp.ReturnInfo.Equals("确认成功!"))
        //        {
        //            doQuery();
        //            doAnalysis();
        //        }
        //    }
        //}

        /// <summary>
        ///取消确认
        /// </summary>
        private void UpConfirm()
        {

            UltraGridRow uow = ultraGrid1.ActiveRow;
            if (uow == null) { MessageUtil.ShowTips("无数据！"); return; }

            ultraGrid1.UpdateData();
            int seqmax1 = ultraGrid1.Rows.Where(a => a.GetValue("CHK") == "True").Select(a => a.Index).Count();
            if (seqmax1 < 1)
            {
                MessageUtil.ShowTips("没有选中要确认的数据！"); return;
            }
            if (seqmax1 > 0 && ultraGrid1.Rows.Count() > 0)
            {
                int seqmax = ultraGrid1.Rows.Where(a => a.GetValue("CHK") == "True").Select(a => a.Index).Max();
                for (int i = seqmax + 1; i < ultraGrid1.Rows.Count(); i++)
                {
                    if (ultraGrid1.Rows[i].Cells["ConfirmFlag"].Value.ToString().Trim().Equals("已确认"))
                    {
                        MessageBox.Show("后面有已确认的数据，请先取消确认!");
                        return;
                    }
                }
            }



            ArrayList list = new ArrayList();
            string date = DateTime.Now.ToString();
            int count = 0;
            string startdate = "";
            string endDate = "";
            if (chkDate.Checked)
            {
                startdate = cmbDate.Value.ToString("yyyyMMdd1800");

            }
            else
            {
                MessageUtil.ShowTips("请选择日期！");
                return;
                //startdate = cmbDate.Value.ToString("199901012100");
                //endDate = cmbEndDate.Value.ToString("203901012100");
            }
            foreach (UltraGridRow ugr in ultraGrid1.Rows)
            {
                if (Convert.ToBoolean(ugr.Cells["CHK"].Text) == true)
                {
                    count += 1;
                    ArrayList list1 = new ArrayList();
                    list1.Add(ugr.Cells["ControlId"].Text.ToString());
                    list1.Add(this.UserInfo.GetUserOrder());
                    list1.Add(this.UserInfo.GetUserGroup());
                    list1.Add(plineCode);
                    list1.Add(DateTime.Parse(ugr.Cells["LogsBeg"].Value.ToString()).ToString("yyyyMMddHHmm"));
                    list1.Add(startdate);
                    list1.Add(endDate);
                    list1.Add(ugr.Cells["JudgeStoveNo"].Text.ToString());
                    list.Add(list1);
                }
            }
            if (count == 0) { MessageUtil.ShowTips("请选中要取消确认的数据！"); return; }
            string intCount = "0";//是否选择取消确认
            if (MessageUtil.ShowYesNoAndQuestion("是否只取消确认选中行数据？") == DialogResult.No)
            {
                intCount = "0";
                if (count == 2)
                {
                    MessageUtil.ShowTips("请选择一条数据！");
                    return;
                }
            }
            else
            {
                intCount = "1";
            }
            //if (MessageUtil.ShowYesNoAndQuestion("是否取消确认?") == DialogResult.No)
            //{
            //    return;
            //}

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.mes.signature.FrmMilControlLog";
            ccp.MethodName = "upConfirmMilControlLog";
            ccp.ServerParams = new object[] { list, intCount };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("取消确认成功!"))
                {
                    doQuery();
                    doAnalysis();
                }
            }
        }
        private void chkDate_CheckedChanged(object sender, EventArgs e)
        {
            if (chkDate.Checked) { cmbDate.Enabled = true; } else { cmbDate.Enabled = false; }
            if (chkBc.Checked) { cmbBc.Enabled = true; } else { cmbBc.Enabled = false; }
            if (chkBz.Checked) { cmbBz.Enabled = true; } else { cmbBz.Enabled = false; }
            if (chkpline.Checked) { cmbPline.Enabled = true; } else { cmbPline.Enabled = false; }
        }

        /// <summary>
        /// Grid字段修改触发事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid1_CellChange(object sender, CellEventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            //string stratime = row.Cells["LogsBeg"].Value.ToString();
            //string endtime = row.Cells["LogsEnd"].Value.ToString();
            try
            {

                //string updateStratime = "";
                //string updateEndtime = "";
                ultraGrid1.UpdateData();
                //if (e.Cell.Column.Key.Equals("LogsEnd"))
                //{
                //    if (Convert.ToBoolean(e.Cell.Row.Cells["CHK"].Text) == true)
                //    {
                //        if (e.Cell.Value == null || e.Cell.Value.ToString().Trim().Equals(""))
                //        {
                //            return;
                //        }
                //        else
                //        {
                //            updateEndtime = e.Cell.Row.Cells["LogsEnd"].Value.ToString();
                //            TimeSpan midTime = DateTime.Parse(updateEndtime) - DateTime.Parse(endtime);
                //             stratday = midTime.Days;
                //             strathours = midTime.Hours;
                //             stratminutes = midTime.Minutes;

                //            int i = e.Cell.Row.Index;//h获取选中行序号 

                //            UltraGridRow urg = ultraGrid1.Rows.AsQueryable().Where(a => a.Index == i + 1).First();//获取选择行下一行序号
                //            DateTime time = DateTime.Parse(urg.Cells["LogsBeg"].Value.ToString()).AddDays(stratday).AddHours(strathours).AddMinutes(stratminutes);
                //            urg.Cells["LogsBeg"].Value = time;
                //        }
                //    }
                //    else
                //    {
                //        MessageUtil.ShowTips("请选择需要修改的数据！");
                //        e.Cell.Row.Cells["LogsEnd"].Value = row.Cells["LogsEnd"].Value.ToString();
                //        return;
                //    }

                //}
                //if (e.Cell.Column.Key.Equals("LogsBeg"))
                //{
                //    if (Convert.ToBoolean(e.Cell.Row.Cells["CHK"].Text) == true)
                //    {
                //        if (e.Cell.Value == null || e.Cell.Value.ToString().Trim().Equals(""))
                //        {
                //            return;
                //        }
                //        else
                //        {
                //            updateStratime = e.Cell.Row.Cells["LogsBeg"].Value.ToString();
                //            TimeSpan midTime = DateTime.Parse(updateStratime) - DateTime.Parse(stratime);
                //            endday = midTime.Days;
                //            endhours = midTime.Hours;
                //            endminutes = midTime.Minutes;

                //            int i = e.Cell.Row.Index;//h获取选中行序号 

                //            UltraGridRow urg = ultraGrid1.Rows.AsQueryable().Where(a => a.Index == i -1).First();//获取选择行上一行序号
                //            //if (urg.Index < 0) return;
                //            DateTime time = DateTime.Parse(urg.Cells["LogsEnd"].Value.ToString()).AddDays(endday).AddHours(endhours).AddMinutes(endminutes);
                //            urg.Cells["LogsEnd"].Value = time;

                //        }
                //    }
                //    else
                //    {
                //        MessageUtil.ShowTips("请选择需要修改的数据！");
                //        e.Cell.Row.Cells["LogsBeg"].Value = row.Cells["LogsBeg"].Value.ToString();
                //        return;
                //    }
                //}
                if (e.Cell.Column.Key.Equals("QualifiedNum"))
                {
                    if (e.Cell.Row.Cells["QualifiedNum"].Value == null)
                    {
                        e.Cell.Row.Cells["QualifiedNum"].Value = "0";
                    }
                    else
                    {

                        string actCount = e.Cell.Row.Cells["QualifiedNum"].Value.ToString();
                        if (!StringUtil.IsInt(actCount) || actCount == "0")//actCount == "" || int.Parse(actCount)==0
                        {
                            e.Cell.Row.Cells["QualifiedNum"].Value = "0";
                        }
                    }
                }
                if (e.Cell.Column.Key.Equals("QualifiedWt"))
                {
                    if (e.Cell.Row.Cells["QualifiedWt"].Value == null)
                    {
                        e.Cell.Row.Cells["QualifiedWt"].Value = "0";
                    }
                    else
                    {

                        string actWt = e.Cell.Row.Cells["QualifiedWt"].Value.ToString();
                        if (!StringUtil.IsDouble(actWt) || actWt == "0")//actCount == "" || int.Parse(actCount)==0
                        {
                            e.Cell.Row.Cells["QualifiedWt"].Value = "0";
                        }
                    }
                }
                if (e.Cell.Column.Key.Equals("ScrapNum"))
                {
                    if (e.Cell.Row.Cells["ScrapNum"].Value == null)
                    {
                        e.Cell.Row.Cells["ScrapNum"].Value = "0";
                    }
                    else
                    {

                        string scrpNum = e.Cell.Row.Cells["ScrapNum"].Value.ToString();
                        if (!StringUtil.IsInt(scrpNum) || scrpNum == "0")//actCount == "" || int.Parse(actCount)==0
                        {
                            e.Cell.Row.Cells["ScrapNum"].Value = "0";
                        }
                    }
                }
                if (e.Cell.Column.Key.Equals("ScrapWt"))
                {
                    if (e.Cell.Row.Cells["ScrapWt"].Value == null)
                    {
                        e.Cell.Row.Cells["ScrapWt"].Value = "0";
                    }
                    else
                    {

                        string scrpwt = e.Cell.Row.Cells["ScrapWt"].Value.ToString();
                        if (!StringUtil.IsDouble(scrpwt) || scrpwt == "0")//actCount == "" || int.Parse(actCount)==0
                        {
                            e.Cell.Row.Cells["ScrapWt"].Value = "0";
                        }
                    }
                }
                if (e.Cell.Column.Key.Equals("StopType"))
                {
                    e.Cell.Row.Cells["StopSmall"].Value = "";
                    e.Cell.Row.Cells["StopReason"].Value = "";
                }
                if (e.Cell.Column.Key.Equals("StopSmall"))
                {
                    e.Cell.Row.Cells["StopReason"].Value = "";
                }

            }
            catch (Exception ex)
            {
                //MessageUtil.ShowTips("您输入的时间格式不正确！");
                //e.Cell.Row.Cells["LogsBeg"].Value = row.Cells["LogsBeg"].Value.ToString();
                //e.Cell.Row.Cells["LogsEnd"].Value = row.Cells["LogsEnd"].Value.ToString();
                return;
            }

        }

        private void ultraGrid1_CellDataError(object sender, CellDataErrorEventArgs e)
        {
            e.RaiseErrorEvent = false;
            MessageUtil.ShowTips("您输入的时间格式不正确!");
        }

        /// <summary>
        /// 停机原因
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cmbStopReason_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;
            if (row == null) return;

            string stopSallm = basecodeSamll;
            if (!row.Cells["StopSmall"].Text.Equals("")) { stopSallm = row.Cells["StopSmall"].Text; }

            FrmStopSamll fpdc = new FrmStopSamll(basecodeSamll, ob);
            fpdc.AutoSize = true;
            fpdc.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fpdc.Text = "停机原因";
            fpdc.ShowDialog();
            if (fpdc.DialogResult == System.Windows.Forms.DialogResult.OK)
            {
                //获取弹出窗体的属性值
                row.Cells["StopReasonm"].Value = fpdc.Basename;
                //cmbStopReason.Value = fpdc.Basename;
                basecodeReason = fpdc.Basecode;
            }
        }

        /// <summary>
        /// 停机小类
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cmbStopSmall_EditorButtonClick(object sender, EditorButtonEventArgs e)
        {
            UltraGridRow row = ultraGrid1.ActiveRow;

            string stoptype = "";
            if (!row.Cells["StopType"].Text.Trim().Equals(""))
            {
                stoptype = row.Cells["StopType"].Value.ToString();
            }

            FrmStopSamll fpdc = new FrmStopSamll(stoptype, ob);
            fpdc.AutoSize = true;
            fpdc.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
            fpdc.Text = "停机小类";
            fpdc.ShowDialog();
            if (fpdc.DialogResult == System.Windows.Forms.DialogResult.OK)
            {
                //获取弹出窗体的属性值
                row.Cells["StopSmallm"].Value = fpdc.Basename;
                //cmbStopSmall.Value = fpdc.Basename;
                basecodeSamll = fpdc.Basecode;
            }
        }

        /// <summary>
        /// 班次中文
        /// </summary>
        /// <param name="dtShift"></param>
        /// <returns></returns>
        private string changeShift(string dtShift)
        {
            switch (dtShift)
            {
                case "1":
                    dtShift = "早班";
                    break;
                case "2":
                    dtShift = "中班";
                    break;
                case "3":
                    dtShift = "夜班";
                    break;
            }
            return dtShift;
        }

        /// <summary>
        /// 班组中文
        /// </summary>
        /// <param name="dtGroup"></param>
        /// <returns></returns>
        private string changeGroup(string dtGroup)
        {
            switch (dtGroup)
            {
                case "1":
                    dtGroup = "甲班";
                    break;
                case "2":
                    dtGroup = "乙班";
                    break;
                case "3":
                    dtGroup = "丙班";
                    break;
                case "4":
                    dtGroup = "丁班";
                    break;
            }
            return dtGroup;
        }
    }
}