XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/FrmSplitUtil.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Core.Mes.ClientFrameWork;
using CoreFS.CA06;
using Core.Mes.Client.Common;

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class FrmSplitUtil : frmStyleBase
    {
        public FrmSplitUtil()
        {
            InitializeComponent();
        }

        string remark = "";
        string SplitTime = "";
        public string sysguid = "";
        public string username = "";
        public string v_endtime = "";
        public string v_starttime = "";
        public OpeBase ob1 = new OpeBase();

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string strSql = "", strErr = "";
                SplitTime = ultraDateTimeEditor1.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
                remark = this.textBox1.Text.Trim();

                DateTime SplitTime_DT = DateTime.Parse(SplitTime);

                DateTime v_EndTime = DateTime.Parse(v_endtime);
                DateTime v_StartTime = DateTime.Parse(v_starttime);

                int ts1 = SplitTime_DT.CompareTo(v_EndTime);//前者在后者时间之前则返回小于0 否则大于0
                int ts2 = v_StartTime.CompareTo(SplitTime_DT);

                if (ts1 > 0 || ts2 > 0)
                {
                    MessageBox.Show("所选拆分时间点必须处于原记录停机开始与结束周期之内！");
                    return;
                }

                strSql = @"INSERT INTO DEV_EQUIPSTOP_LOG
                                  (STATIONCODE,
                                   SHIFTCLASS,
                                   SHIFTGROUP,
                                   STOPTYPE,
                                   STARTTIME,
                                   ENDTIME,
                                   REMARK,
                                   SPLITMAN,
                                   SPLITTIME,
                                   FLAG)
                                  SELECT STATIONCODE,
                                         SHIFTCLASS,
                                         SHIFTGROUP,
                                         STOPTYPE,
                                         TO_DATE('{0}','YYYY-MM-DD HH24:MI:SS'),
                                         ENDTIME,
                                         '{1}',
                                         '{2}',
                                         SYSDATE,
                                         FLAG
                                    FROM DEV_EQUIPSTOP_LOG
                                   WHERE SYSGUID = '{3}'";

                strSql = string.Format(strSql, SplitTime, remark, username, sysguid);
                //调用服务端方法
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = ob1;
                cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                        "ExcuteNoParameter", strSql, out strErr);
                if (!string.IsNullOrEmpty(strErr))
                {
                    MessageBox.Show("修改失败:" + strErr);
                    return;
                }


                strSql = "UPDATE DEV_EQUIPSTOP_LOG SET ENDTIME = TO_DATE('{0}','YYYY-MM-DD HH24:MI:SS'),SPLITMAN = '{1}',SPLITTIME = SYSDATE WHERE SYSGUID = '{2}'";
                strSql = string.Format(strSql, SplitTime, username, sysguid);
                cctos = new CommonClientToServer();
                cctos.ob = ob1;
                // DataSet ds = 
                cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                        "ExcuteNoParameter", strSql, out strErr);
                if (!string.IsNullOrEmpty(strErr))
                {
                    MessageBox.Show("修改失败:" + strErr);
                    return;
                }

                MessageBox.Show("拆分成功!");
            }
            catch (Exception ex)
            { 
                MessageBox.Show("拆分失败:" + ex.Message + "!");
                return;
            }
            this.Close();
        }

        private void FrmSplitUtil_Load(object sender, EventArgs e)
        {
            ultraDateTimeEditor1.DateTime = DateTime.Parse(v_endtime);
        }


    }
}