MES_Client/TGMES/Core.StlMes.Client.ZGMil/Popup/FrmToolChange.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using Infragistics.Win;
using com.steering.mes.zgmil.entity;
using System.Collections;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.ZGMil.Entity;

namespace Core.StlMes.Client.ZGMil.Popup
{
    public partial class txtQuery : FrmBase
    {


        OpeBase _ob = null;
        int _ProcessNo = 0;
        string _Shift = "";
        string _Group = "";
        string _User = "";
        string _PlineCode = "";
        string ResultNo = "";

        /// <summary>
        /// 
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="ProcessNo"> 1-穿孔 2-连轧 3-定径</param>
        /// <param name="Date"></param>
        /// <param name="Shift"></param>
        /// <param name="Group"></param>
        /// <param name="ob"></param>
        public txtQuery(int ProcessNo, string Date, string Shift, string Group, string User, string PlineCode, OpeBase ob)
        {
            //DataTable refdt = new DataTable();
            InitializeComponent();
            _ProcessNo = ProcessNo;
            _ob = ob;
            _Shift = Shift;
            _Group = Group;
            _User = User;
            _PlineCode = PlineCode;
            DoQuery(_ProcessNo);

            switch (Shift)
            {
                case "0":
                    Shift = "常白班";
                    break;
                case "1":
                    Shift = "早班";
                    break;
                case "2":
                    Shift = "中班";
                    break;
                case "3":
                    Shift = "晚班";
                    break;
            }
            switch (Group)
            {
                case "1":
                    Group = "甲";
                    break;
                case "2":
                    Group = "乙";
                    break;
                case "3":
                    Group = "丙";
                    break;
                case "4":
                    Group = "丁";
                    break;
            }
            switch (ProcessNo)
            {
                case 1:
                    // refdt = dtPerTool;

                    if (_PlineCode == "C010")
                    {
                        GridDisplay(3);
                      
                    }
                    else
                    {
                        GridDisplay(ProcessNo - 1);
                        
                    }
                    QueryDisplay(ProcessNo - 1);
                    break;
                case 2:
                    QueryDisplay(ProcessNo - 1);
                    GridDisplay(ProcessNo - 1);
                    break;
                case 3:
                    QueryDisplay(ProcessNo - 1);
                    GridDisplay(ProcessNo - 1);
                    break;

            }
            txtDate.Text = Date;
            txtShift.Text = Shift;
            txtGroup.Text = Group;

        }

        /// <summary>
        /// 页面加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtQuery_Load(object sender, EventArgs e)
        {
            switch (_PlineCode)
            {
                case "C010":
                    ultraLabel3.Text = "导盘更换";
                    ultraGrid0.DisplayLayout.Bands[0].Columns["PLUG_CHANGE"].Hidden = true;
                    ultraGrid0.DisplayLayout.Bands[0].Columns["PLUG_CHANGE_TIME"].Hidden = true;
                    ultraGrid0.DisplayLayout.Bands[0].Columns["BAR_CHANGE"].Hidden = true;
                    ultraGrid0.DisplayLayout.Bands[0].Columns["BAR_CHANGE_TIME"].Hidden = true;
                    ultraGrid0.DisplayLayout.Bands[0].Columns["GUIDE_CHANGE"].Hidden = true;
                    ultraGrid0.DisplayLayout.Bands[0].Columns["GUIDE_CHANGE_TIME"].Hidden = true;
                    break;
                default:
                    ultraGrid0.DisplayLayout.Bands[0].Columns["TOOL_CHANGE"].Hidden = true;
                    ultraGrid0.DisplayLayout.Bands[0].Columns["TOOL_CHANGE_TIME"].Hidden = true;
                    break;
            }
        }

        /// <summary>
        /// 查询区TAB页显示
        /// </summary>
        /// <param name="ProcessNo"></param>
        private void QueryDisplay(int ProcessNo)
        {
            for (int i = 0; i < 3; i++)
            {
                ultraTabControl1.Tabs[i].Visible = false;

            }
            ultraTabControl1.Tabs[ProcessNo].Visible = true;
        }

        /// <summary>
        /// 编辑区TAB页显示
        /// </summary>
        /// <param name="ProcessNo"></param>
        private void GridDisplay(int ProcessNo)
        {
            for (int i = 0; i < 4; i++)
            {
                ultraTabControl2.Tabs[i].Visible = false;

            }
            ultraTabControl2.Tabs[ProcessNo].Visible = true;
        }



        /// <summary>
        /// 查询
        /// </summary>
        private void DoQuery(int ProcessNo)
        {
            DataTable dt = null;
            DataTable refdt = new DataTable();
            if (ProcessNo == 1)
            {
                refdt = dtPerTool;
                string Shift = UserInfo.GetUserOrder();
                string Group = UserInfo.GetUserGroup();
                string User = UserInfo.GetUserName();
                DateTime SeverTime = NativeMethod.GetSeverTime(_ob);

                string StartTime = SeverTime.ToString("yyyy-MM-dd");
                string EndTime = SeverTime.AddDays(1).ToString("yyyy-MM-dd");
                string Date = StartTime;
                string Time = SeverTime.ToLongTimeString();



                //晚班
                if (Shift == "3")
                {
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) > 205900)
                    {
                        StartTime += " " + "21:00:00";
                        EndTime += " " + "07:00:00";
                    }
                    else
                    {
                        StartTime = SeverTime.AddDays(-1).ToString("yyyy-MM-dd") + " " + "21:00:00";
                        EndTime = SeverTime.ToString("yyyy-MM-dd") + " " + "07:00:00";
                    }
                }
                dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.PerforationResult.toolChangeQuery", new object[] { _PlineCode, _Shift, _Group, StartTime, EndTime }, _ob);
            }
            if (ProcessNo == 2)
            {
                refdt = dtRollTool;
                string Shift = UserInfo.GetUserOrder();
                string Group = UserInfo.GetUserGroup();
                string User = UserInfo.GetUserName();
                DateTime SeverTime = NativeMethod.GetSeverTime(_ob);

                string StartTime = SeverTime.ToString("yyyy-MM-dd");
                string EndTime = SeverTime.AddDays(1).ToString("yyyy-MM-dd");
                string Date = StartTime;
                string Time = SeverTime.ToLongTimeString();



                //晚班
                if (Shift == "3")
                {
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) > 205900)
                    {
                        StartTime += " " + "21:00:00";
                        EndTime += " " + "07:00:00";
                    }
                    else
                    {
                        StartTime = SeverTime.AddDays(-1).ToString("yyyy-MM-dd") + " " + "21:00:00";
                        EndTime = SeverTime.ToString("yyyy-MM-dd") + " " + "07:00:00";
                    }
                }
                dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmRollingRPipeResult.toolChangeQuery", new object[] { _PlineCode, _Shift, _Group, StartTime, EndTime }, _ob);
            }
            if (ProcessNo == 3)
            {
                refdt = dtSizingTool;
                string Shift = UserInfo.GetUserOrder();
                string Group = UserInfo.GetUserGroup();
                string User = UserInfo.GetUserName();
                DateTime SeverTime = NativeMethod.GetSeverTime(_ob);

                string StartTime = SeverTime.ToString("yyyy-MM-dd");
                string EndTime = SeverTime.AddDays(1).ToString("yyyy-MM-dd");
                string Date = StartTime;
                string Time = SeverTime.ToLongTimeString();



                //晚班
                if (Shift == "3")
                {
                    Time = Time.Replace(":", "");
                    if (int.Parse(Time) > 205900)
                    {
                        StartTime += " " + "21:00:00";
                        EndTime += " " + "07:00:00";
                    }
                    else
                    {
                        StartTime = SeverTime.AddDays(-1).ToString("yyyy-MM-dd") + " " + "21:00:00";
                        EndTime = SeverTime.ToString("yyyy-MM-dd") + " " + "07:00:00";
                    }
                }
                dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.SizingResult.toolChangeQuery", new object[] { _PlineCode, _Shift, _Group, StartTime, EndTime }, _ob);
            }
            refdt.Clear();
            GridHelper.CopyDataToDatatable(ref dt, ref refdt, true);
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnAdd_Click(object sender, EventArgs e)
        {
            MilPerToolEntity PerAddEntity = new MilPerToolEntity();
            MilRollingToolEntity RollAddEntity = new MilRollingToolEntity();
            MilSizingToolEntity SizingAddEntity = new MilSizingToolEntity();
            ResultNo = NativeMethod.GetSeverTime(_ob).ToString();
            ResultNo = ResultNo.Replace(":", "").Replace(" ", "").Replace("/", "");


            //穿孔
            if (_ProcessNo == 1)
            {

                string PlugTime = "";
                string BarTime = "";
                string GuideTime = "";
                string ToolTime = "";
                if (_PlineCode != "C010")
                {
                    if (string.IsNullOrEmpty(txtPlugChange.Text) && string.IsNullOrEmpty(txtGuideChange.Text) && string.IsNullOrEmpty(txtBarChange.Text))
                    {
                        MessageBox.Show("请输入需要更换的工具！！！");
                        return;
                    }
                    if (!string.IsNullOrEmpty(txtPlugChange.Text))
                    {
                        PlugTime = udtPlugTime.Value.ToString();
                    }
                    if (!string.IsNullOrEmpty(txtGuideChange.Text))
                    {
                        GuideTime = udtGuideTime.Value.ToString();
                    }
                    if (!string.IsNullOrEmpty(txtBarChange.Text))
                    {
                        BarTime = udtBarTime.Value.ToString();
                    }
                }
                else
                {
                    if (string.IsNullOrEmpty(this.txtToolChange168.Text))
                    {
                        MessageBox.Show("请输入需要更换的工具！！！");
                        return;
                    }
                    if (!string.IsNullOrEmpty(txtToolChange168.Text))
                    {
                        ToolTime = this.dtpToolChange168.Value.ToString();
                    }
                }

                PerAddEntity.ResultNo = ResultNo;
                PerAddEntity.PlugChange = txtPlugChange.Text;
                PerAddEntity.PlugChangeTime = PlugTime;
                PerAddEntity.GuideChange = txtGuideChange.Text;
                PerAddEntity.GuideChangeTime = GuideTime;
                PerAddEntity.BarChange = txtBarChange.Text;
                PerAddEntity.BarChangeTime = BarTime;
                PerAddEntity.ToolChange = txtToolChange168.Text;
                PerAddEntity.ToolChangeTime = ToolTime;
                PerAddEntity.ColGroup = _Group;
                PerAddEntity.ColShift = _Shift;
                PerAddEntity.ColUser = _User;
                PerAddEntity.PlineCode = _PlineCode;


            }
            //连轧
            if (_ProcessNo == 2)
            {
                string ManderlTime = "";
                string RollTime = "";
                string ExMilTime = "";

                if (string.IsNullOrEmpty(txtMandrelChange.Text) && string.IsNullOrEmpty(this.txtRollChange.Text) && string.IsNullOrEmpty(this.txtExMilChange.Text))
                {
                    MessageBox.Show("请输入需要更换的工具！！！");
                    return;
                }
                if (!string.IsNullOrEmpty(txtMandrelChange.Text))
                {
                    ManderlTime = udtMandrelTime.Value.ToString();
                }
                if (!string.IsNullOrEmpty(txtRollChange.Text))
                {
                    RollTime = udtRollTime.Value.ToString();
                }
                if (!string.IsNullOrEmpty(txtExMilChange.Text))
                {
                    ExMilTime = udtExMilTime.Value.ToString();
                }

                RollAddEntity.ResultNo = ResultNo;
                RollAddEntity.MandrelChange = txtMandrelChange.Text;
                RollAddEntity.MandrelChangeTime = ManderlTime;
                RollAddEntity.RollChange = txtRollChange.Text;
                RollAddEntity.RollChangeTime = RollTime;
                RollAddEntity.ExmilChange = txtExMilChange.Text;
                RollAddEntity.ExmilChangeTime = ExMilTime;
                RollAddEntity.ColGroup = _Group;
                RollAddEntity.ColShift = _Shift;
                RollAddEntity.ColUser = _User;
                RollAddEntity.PlineCode = _PlineCode;

            }
            //定径
            if (_ProcessNo == 3)
            {

                if (string.IsNullOrEmpty(txtToolChange.Text))
                {
                    MessageBox.Show("请输入需要更换的工具！！！");
                    return;
                }
                SizingAddEntity.ResultNo = ResultNo;
                SizingAddEntity.ToolChange = txtToolChange.Text;
                SizingAddEntity.ToolChangeTime = udtToolChange.Value.ToString();
                SizingAddEntity.ColGroup = _Group;
                SizingAddEntity.ColShift = _Shift;
                SizingAddEntity.ColUser = _User;
                SizingAddEntity.PlineCode = _PlineCode;
            }
            int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmToolChange.ToolResultAdd", new object[] { PerAddEntity, RollAddEntity, SizingAddEntity, _ProcessNo }, _ob);
            MessageBox.Show("数据新增成功");
            DoQuery(_ProcessNo);

            //清空编辑区
            txtBarChange.Text = "";
            txtExMilChange.Text = "";
            txtGuideChange.Text = "";
            txtMandrelChange.Text = "";
            txtPlugChange.Text = "";
            txtRollChange.Text = "";
            txtToolChange.Text = "";
            txtToolChange168.Text = "";

        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraButton2_Click(object sender, EventArgs e)
        {
            MilPerToolEntity PerUpdateEntity = new MilPerToolEntity();
            MilRollingToolEntity RollUpdateEntity = new MilRollingToolEntity();
            MilSizingToolEntity SizingUpdateEntity = new MilSizingToolEntity();


            //穿孔
            if (_ProcessNo == 1)
            {
                string PlugChangeTime = "";
                string BarChangeTime = "";
                string GuideChangeTime = "";
                string ToolTime = "";
                if (ultraGrid0.ActiveRow == null)
                {
                    MessageBox.Show("请选择需要修改的数据！！！");
                    return;
                }
                if (_PlineCode != "C010")
                {
                    if (txtPlugChange.Text == "" && txtGuideChange.Text == "" && txtBarChange.Text == "")
                    {
                        MessageBox.Show("请输入工器具更换项目！！！");
                        return;
                    }
                    if (txtPlugChange.Text != "")
                    {
                        PlugChangeTime = udtPlugTime.Value.ToString();
                    }
                    if (txtGuideChange.Text != "")
                    {
                        GuideChangeTime = udtGuideTime.Value.ToString();
                    }
                    if (txtBarChange.Text != "")
                    {
                        BarChangeTime = udtBarTime.Value.ToString();
                    }
                }
                else
                {
                    if (this.txtToolChange168.Text == "")
                    {
                        MessageBox.Show("请输入工器具更换项目！！！");
                        return;
                    }
                    if (txtToolChange168.Text != "")
                    {
                        ToolTime = this.dtpToolChange168.Value.ToString();
                    }
                }
                ResultNo = ultraGrid0.ActiveRow.Cells["RESULT_NO"].Value.ToString();
                PerUpdateEntity.ResultNo = ResultNo;
                PerUpdateEntity.PlugChange = txtPlugChange.Text;
                PerUpdateEntity.PlugChangeTime = PlugChangeTime;
                PerUpdateEntity.GuideChange = txtGuideChange.Text;
                PerUpdateEntity.GuideChangeTime = GuideChangeTime;
                PerUpdateEntity.BarChange = txtBarChange.Text;
                PerUpdateEntity.BarChangeTime = BarChangeTime;
                PerUpdateEntity.ToolChange = txtToolChange168.Text;
                PerUpdateEntity.ToolChangeTime = ToolTime;
                PerUpdateEntity.PlineCode = _PlineCode;
            }
            //连轧
            if (_ProcessNo == 2)
            {
                string MandrelChangeTime = "";
                string RollChangeTime = "";
                string ExMilChangeTime = "";
                if (ultraGrid1.ActiveRow == null)
                {
                    MessageBox.Show("请选择需要修改的数据！！！");
                    return;
                }
                if (txtMandrelChange.Text == "" && txtRollChange.Text == "" && udtExMilTime.Text == "")
                {
                    MessageBox.Show("请输入工器具更换项目！！！");
                    return;
                }
                if (txtMandrelChange.Text != "")
                {
                    MandrelChangeTime = udtMandrelTime.Value.ToString();
                }
                if (txtRollChange.Text != "")
                {
                    RollChangeTime = udtRollTime.Value.ToString();
                }
                if (udtExMilTime.Text != "")
                {
                    ExMilChangeTime = udtExMilTime.Value.ToString();
                }
                ResultNo = ultraGrid1.ActiveRow.Cells["RESULT_NO"].Value.ToString();
                RollUpdateEntity.ResultNo = ResultNo;
                RollUpdateEntity.MandrelChange = txtMandrelChange.Text;
                RollUpdateEntity.MandrelChangeTime = udtMandrelTime.Value.ToString();
                RollUpdateEntity.RollChange = txtRollChange.Text;
                RollUpdateEntity.RollChangeTime = udtRollTime.Value.ToString();
                RollUpdateEntity.ExmilChange = txtExMilChange.Text;
                RollUpdateEntity.ExmilChangeTime = udtExMilTime.Value.ToString();
                RollUpdateEntity.ColGroup = _Group;
                RollUpdateEntity.ColShift = _Shift;
                RollUpdateEntity.ColUser = _User;
                RollUpdateEntity.PlineCode = _PlineCode;
            }
            //定径
            if (_ProcessNo == 3)
            {
                if (ultraGrid2.ActiveRow == null)
                {
                    MessageBox.Show("请选择需要修改的数据！！！");
                    return;
                }
                if (txtToolChange.Text == "")
                {
                    MessageBox.Show("请输入工器具更换项目！！！");
                    return;
                }
                ResultNo = ultraGrid2.ActiveRow.Cells["RESULT_NO"].Value.ToString();
                SizingUpdateEntity.ResultNo = ResultNo;
                SizingUpdateEntity.ToolChange = txtToolChange.Text;
                SizingUpdateEntity.ToolChangeTime = udtToolChange.Value.ToString();
                SizingUpdateEntity.ColGroup = _Group;
                SizingUpdateEntity.ColShift = _Shift;
                SizingUpdateEntity.ColUser = _User;
                SizingUpdateEntity.PlineCode = _PlineCode;
            }
            int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmToolChange.ToolResultUpdate", new object[] { PerUpdateEntity, RollUpdateEntity, SizingUpdateEntity, _ProcessNo }, _ob);
            MessageBox.Show("数据修改成功");
            DoQuery(_ProcessNo);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnDelete_Click(object sender, EventArgs e)
        {
            MilPerToolEntity PerDelEntity = new MilPerToolEntity();
            MilRollingToolEntity RollDelEntity = new MilRollingToolEntity();
            MilSizingToolEntity SizingDelEntity = new MilSizingToolEntity();


            //穿孔
            if (_ProcessNo == 1)
            {
                if (ultraGrid0.ActiveRow == null)
                {
                    MessageBox.Show("请选择需要删除的数据！！！");
                    return;
                }
                ResultNo = ultraGrid0.ActiveRow.Cells["RESULT_NO"].Value.ToString();
                PerDelEntity.ResultNo = ResultNo;
                PerDelEntity.PlineCode = _PlineCode;
            }
            //连轧
            if (_ProcessNo == 2)
            {
                if (ultraGrid1.ActiveRow == null)
                {
                    MessageBox.Show("请选择需要删除的数据！！！");
                    return;
                }
                ResultNo = ultraGrid1.ActiveRow.Cells["RESULT_NO"].Value.ToString();
                RollDelEntity.ResultNo = ResultNo;
                RollDelEntity.PlineCode = _PlineCode;
            }
            //定径
            if (_ProcessNo == 3)
            {
                if (ultraGrid2.ActiveRow == null)
                {
                    MessageBox.Show("请选择需要删除的数据！！！");
                    return;
                }
                ResultNo = ultraGrid2.ActiveRow.Cells["RESULT_NO"].Value.ToString();
                SizingDelEntity.ResultNo = ResultNo;
                SizingDelEntity.PlineCode = _PlineCode;
            }
            if (MessageUtil.ShowYesNoAndQuestion("确认删除信息？") == DialogResult.No)
            {
                return;
            }
            int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmToolChange.ToolResultDelete", new object[] { PerDelEntity, RollDelEntity, SizingDelEntity, _ProcessNo }, _ob);
            DoQuery(_ProcessNo);
        }

        /// <summary>
        /// 穿孔GRID单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraGrid0_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGrid0.ActiveRow;
            txtPlugChange.Text = "";
            txtBarChange.Text = "";
            txtGuideChange.Text = "";
            if (!string.IsNullOrEmpty(ugr.Cells["PLUG_CHANGE"].Value.ToString()))
            {
                txtPlugChange.Text = ugr.Cells["PLUG_CHANGE"].Value.ToString();
                udtPlugTime.Value = DateTime.Parse(ugr.Cells["PLUG_CHANGE_TIME"].Value.ToString());
            }
            if (!string.IsNullOrEmpty(ugr.Cells["BAR_CHANGE"].Value.ToString()))
            {
                txtBarChange.Text = ugr.Cells["BAR_CHANGE"].Value.ToString();
                udtBarTime.Value = DateTime.Parse(ugr.Cells["BAR_CHANGE_TIME"].Value.ToString());
            }
            if (!string.IsNullOrEmpty(ugr.Cells["GUIDE_CHANGE"].Value.ToString()))
            {
                txtGuideChange.Text = ugr.Cells["GUIDE_CHANGE"].Value.ToString();
                udtGuideTime.Value = DateTime.Parse(ugr.Cells["GUIDE_CHANGE_TIME"].Value.ToString());
            }
            if (!string.IsNullOrEmpty(ugr.Cells["TOOL_CHANGE"].Value.ToString()))
            {
                this.txtToolChange168.Text = ugr.Cells["TOOL_CHANGE"].Value.ToString();
                this.dtpToolChange168.Value = DateTime.Parse(ugr.Cells["TOOL_CHANGE_TIME"].Value.ToString());
            }
        }

        private void ultraButton1_Click(object sender, EventArgs e)
        {
            DoQuery(_ProcessNo);
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGrid1.ActiveRow;
            txtPlugChange.Text = "";
            txtBarChange.Text = "";
            txtGuideChange.Text = "";
            if (!string.IsNullOrEmpty(ugr.Cells["MANDREL_CHANGE"].Value.ToString()))
            {
                txtPlugChange.Text = ugr.Cells["MANDREL_CHANGE"].Value.ToString();
                udtPlugTime.Value = DateTime.Parse(ugr.Cells["MANDREL_CHANGE_TIME"].Value.ToString());
            }
            if (!string.IsNullOrEmpty(ugr.Cells["ROLL_CHANGE"].Value.ToString()))
            {
                txtBarChange.Text = ugr.Cells["ROLL_CHANGE"].Value.ToString();
                udtBarTime.Value = DateTime.Parse(ugr.Cells["ROLL_CHANGE_TIME"].Value.ToString());
            }
            if (!string.IsNullOrEmpty(ugr.Cells["EXMIL_CHANGE"].Value.ToString()))
            {
                txtGuideChange.Text = ugr.Cells["EXMIL_CHANGE"].Value.ToString();
                udtGuideTime.Value = DateTime.Parse(ugr.Cells["EXMIL_CHANGE_TIME"].Value.ToString());
            }
        }

        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGrid2.ActiveRow;

            if (!string.IsNullOrEmpty(ugr.Cells["TOOL_CHANGE"].Value.ToString()))
            {
                txtToolChange.Text = ugr.Cells["TOOL_CHANGE"].Value.ToString();
                udtToolChange.Value = DateTime.Parse(ugr.Cells["TOOL_CHANGE_TIME"].Value.ToString());
            }
        }




    }
}