XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/电炉炉壳/FrmServiceInfo.cs

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

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class FrmServiceInfo : FrmLgDevFunctions
    {
        public DataSet ds;
        public FrmServiceInfo(OpeBase oba)
        {
            InitializeComponent();
            this.chkQStartTime.CheckedChanged += new System.EventHandler(this.chkQStartTime_CheckedChanged);
            this.chkQEndTime.CheckedChanged += new System.EventHandler(this.chkQEndTime_CheckedChanged);
            this.chkQOxygenLanceID.CheckedChanged += new System.EventHandler(this.chkQOxygenLanceID_CheckedChanged);
            ob = oba;
        }

        private void FrmServiceInfo_Load(object sender, EventArgs e)
        {
            cmbID.Enabled = false;
            udteStart.Enabled = false;
            udteEnd.Enabled = false;
            udteStart.Text = System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00";
            udteEnd.Text = System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59";
            if (ds != null)
            {
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    cmbID.Items.Add(ds.Tables[0].Rows[i]["EAFSHELLID"].ToString());
                }
            }
        }

        private void proc_UpdateBaseInfoAge(string strRecordID, string strAge)
        {
            //try
            //{
            //    string strErr = "";
            //    string strSql = "select case when ENDTIME is null then '0' else '1' end Finished from DEV_yq_use_detail where RECRODID='" + strRecordID + "'";

            //    //CallingMessage par = new CallingMessage();
            //    //par.ServerName = "LgDeviceManager";
            //    //par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
            //    //par.ClassName = "Core.LgMes.Server.LgDeviceManager.OxygenLanceManager";
            //    //par.MethodName = "OxygenLance_Return";
            //    //par.args = new object[] { strSql };
            //    DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);

            //    if (!((strErr == null || strErr == "") && ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
            //        return;

            //    string strFinished = Convert.ToString(ds.Tables[0].Rows[0]["Finished"]);
            //    if (strFinished == "1")
            //        return;

            //    strErr = "";
            //    strSql = "update DEV_YQ_BASE_INFO set USEMAXTIME = '" + strAge + "' where OXYGENLANCEID = (select OXYGENLANCEID from DEV_YQ_USE_DETAIL where RECRODID = '" + strRecordID + "')";

            //    //par.MethodName = "OxygenLance_NonReturn";
            //    //par.args = new object[] { strSql };
            //    //ClientCommon._RemotingHelp.ExecuteMethod(par, out strErr);
            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.Message, "出错");
            //}
        }
        /// <新增>
        /// 新增
        /// </summary>
        private void AddUseDetail()
        {
            try
            {
                string v0=ucmbLKBH.Text.ToString();//, --设备编号
                string v1=ucmbWXWZ.Text.ToString();//, --维修位置
                string v2 = ucmblb.Text.ToString();//, --维修类别
                string v3 = ucmbYY.Text.ToString();//, --维修原因
                string v4 = txtCB.Text.ToString();//, --维修成本
                string v5 = txtname.Text.ToString();//, --记录人
                string v6 = ucmbCJ.Text.ToString();//, --维修厂家
                string v7=udteStartTime.Value.ToString();//, --开始时间
                string v8=udteendtime.Value.ToString();// --结束时间
                string v9=txtmemo.Text.ToString();// --备注
                string v10=ucmbNC.Text.ToString();// --耐材更换yyyyyyyyyyyy
                string[] strParams = new string[11] { v0,v1,v2,v3,v4,v5,v6,v7,v8,v9,v10};
                string strErr = "";
                string msg = "";
                ProcedureZ("Core.LgMes.Server.DEV.Methods.DEVPublicMethods", "procedure", new object[] { "STL_DEV_Info.Eaf_ServiceInfo_add", strParams }, ob, out strErr, out msg);

                if (Convert.ToInt32(strErr) > 0)
                {
                    QueryDataselect();
                    MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                }
                else
                    MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <修改>
        /// 修改
        /// </summary>
        private void ModifyUseDetail()
        {
            try
            {
                string v0 = ucmbLKBH.Text.ToString();//, --设备编号
                string v1 = ucmbWXWZ.Text.ToString();//, --维修位置
                string v2 = ucmblb.Text.ToString();//, --维修类别
                string v3 = ucmbYY.Text.ToString();//, --维修原因
                string v4 = txtCB.Text.ToString();//, --维修成本
                string v5 = txtname.Text.ToString();//, --记录人
                string v6 = ucmbCJ.Text.ToString();//, --维修厂家
                string v7 = udteStartTime.Value.ToString();//, --开始时间
                string v8 = udteendtime.Value.ToString();// --结束时间
                string v9 = txtmemo.Text.ToString();// --备注
                string v10 = ucmbNC.Text.ToString();// --耐材更换yyyyyyyyyyyy
                string[] strParams = new string[11] { v0, v1, v2, v3, v4, v5, v6, v7, v8, v9, v10 };
                string strErr = "";
                string msg = "";
                ProcedureZ("Core.LgMes.Server.DEV.Methods.DEVPublicMethods", "procedure", new object[] { "STL_DEV_Info.Eaf_ServiceInfo_Edit", strParams }, ob, out strErr, out msg);

                if (Convert.ToInt32(strErr) > 0)
                {
                    QueryDataselect();
                    MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                }
                else
                    MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <删除>
        /// 删除
        /// </summary>
        private void DelUseDetail()
        {
            try
            {
                string v0 = ucmbLKBH.Text.ToString();//, --设备编号
                string[] strParams = new string[1] { v0 };
                string strErr = "";
                string msg = "";
                ProcedureZ("Core.LgMes.Server.DEV.Methods.DEVPublicMethods", "procedure", new object[] { "STL_DEV_Info.Eaf_ServiceInfo_Del", strParams }, ob, out strErr, out msg);

                if (Convert.ToInt32(strErr) > 0)
                {
                    QueryDataselect();
                    MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                }
                else
                    MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private string ClassTransCode()
        {
            DateTime TimeNow = new DateTime();
            TimeNow = System.DateTime.Now;
            string str1 = "";
            string str2 = "";
            if (TimeNow >= Convert.ToDateTime("8:00:00") && TimeNow <= Convert.ToDateTime("15:59:59"))
            {
                str1 = "1";
            }
            else if (TimeNow >= Convert.ToDateTime("16:00:00") && TimeNow <= Convert.ToDateTime("23:59:59"))
            {
                str1 = "2";
            }
            else
            {
                str1 = "3";
            }
            switch (cmbClass.Text)
            {
                case "甲":
                    {
                        str2 = "1";
                        break;
                    }
                case "乙":
                    {
                        str2 = "2";
                        break;
                    }
                case "丙":
                    {
                        str2 = "3";
                        break;
                    }
                case "丁":
                    {
                        str2 = "4";
                        break;
                    }
            }
            return (str1 + str2);
        }
        private string ClassTransChar(string code)
        {
            string str = "";
            switch (code)
            {
                case "1":
                    {
                        str = "甲";
                        break;
                    }
                case "2":
                    {
                        str = "乙";
                        break;
                    }
                case "3":
                    {
                        str = "丙";
                        break;
                    }
                case "4":
                    {
                        str = "丁";
                        break;
                    }
            }
            return str;
        }
        private bool CheckIsNumberByASCII(string sSrc)
        {
            bool bRet = true;

            ASCIIEncoding AE = new ASCIIEncoding();
            byte[] bArray = AE.GetBytes(sSrc);

            for (int i = 0; i < bArray.Length; i++)
            {
                if (bArray[i] < 47 || bArray[i] > 57)
                {
                    bRet = false;
                    break;
                }
            }
            return bRet;
        }
        /// <按条件查询>
        /// //按条件查询
        /// </summary>
        private void QueryDataselect()
        {
            string sqlSelect = "select REPAIRID, REPAIRTOOLID,REPAIRPART,REPAIRTYPE,MATERIALREPLACING,REPAIRCOST,"
                                +" REASON,CYCID,REPAIRTIME,REPAIREDTIME,TBMENDFACTORY,RECORDER,MEMO "
                                +"from DEV_TOOL_REPAIR t where t.tooltypeid = '3'";
            string sqlWhere = "";
            //string err = "";
            string SBbianhao = cmbID.Text;
            string startTime = udteStart.Value.ToString();
            string endTime = udteEnd.Value.ToString();
            
            if (chkQStartTime.Checked && chkQEndTime.Checked)
            {
                if (Convert.ToDateTime(startTime) > Convert.ToDateTime(endTime))
                {
                    MessageBox.Show("开始时间不能大于结束时间！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
            }
            if (chkQOxygenLanceID.Checked)
            {
                sqlWhere += " and REPAIRTOOLID= '" + SBbianhao + "'";
            }
            if (chkQStartTime.Checked)
            {
                sqlWhere += " and REPAIRTIME >= to_date('" + startTime + "','yyyy-mm-dd hh24:mi:ss')";
            }
            if (chkQEndTime.Checked)
            {
                sqlWhere += " and REPAIREDTIME <= to_date( '" + endTime + "','yyyy-mm-dd hh24:mi:ss')";
            }
            string strsql = sqlSelect + sqlWhere + " order by REPAIRTOOLID";
            DataSet ds = QueryFixedFunions(strsql,ob);
            try
            {
                ((DataSet)ulgridBaseInfo.DataSource).Tables[0].Rows.Clear();
            }
            catch (Exception)
            {
            }
            if (ds.Tables[0].Rows.Count > 0)
            {
                ulgridBaseInfo.DataSource = ds;
            }
        }
        /// <导出>
        /// 导出
        /// </summary>
        private void proc_Export()
        {
            try
            {
                if (ulgridBaseInfo.Rows.Count == 0) return;
                Core.Mes.Client.Common.Globals.ulGridToExcel(ulgridBaseInfo, Text);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void chkQOxygenLanceID_CheckedChanged(object sender, EventArgs e)
        {
            cmbID.Enabled = chkQOxygenLanceID.Checked;
        }
        private void chkQStartTime_CheckedChanged(object sender, EventArgs e)
        {
            udteStart.Enabled = chkQStartTime.Checked;
        }

        private void chkQEndTime_CheckedChanged(object sender, EventArgs e)
        {
            udteEnd.Enabled = chkQEndTime.Checked;
        }
        /// <summary>
        /// 菜单栏
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "Add":
                    AddUseDetail();
                    break;
                case "Modify":
                    ModifyUseDetail();
                    break;
                case "Delete":
                    DelUseDetail();
                    break;
                case "Select":
                    this.QueryDataselect();
                    break;
                case "Export":
                    this.proc_Export();
                    break;
                case "Close":
                    this.Close();
                    break;
                default:
                    break;
            }
        }

        private void ulgridBaseInfo_AfterRowActivate(object sender, EventArgs e)
        {
            if (ulgridBaseInfo.Rows.Count > 0)
            {
                ucmbLKBH.Text = ulgridBaseInfo.ActiveRow.Cells["REPAIRTOOLID"].Value.ToString();
                ucmbWXWZ.Text = ulgridBaseInfo.ActiveRow.Cells["REPAIRPART"].Value.ToString();
                ucmblb.Text = ulgridBaseInfo.ActiveRow.Cells["REPAIRTYPE"].Value.ToString();
                ucmbYY.Text = ulgridBaseInfo.ActiveRow.Cells["REASON"].Value.ToString();
                //comboBox2.Text = ultdsUseDetail.Rows[0]["CLASS"].ToString();
                txtCB.Text = ulgridBaseInfo.ActiveRow.Cells["REPAIRCOST"].Value.ToString();
                txtname.Text = ulgridBaseInfo.ActiveRow.Cells["RECORDER"].Value.ToString();
                ucmbCJ.Text = ulgridBaseInfo.ActiveRow.Cells["TBMENDFACTORY"].Value.ToString();
                udteStartTime.Value=ulgridBaseInfo.ActiveRow.Cells["REPAIRTIME"].Value.ToString();
                udteendtime.Value=ulgridBaseInfo.ActiveRow.Cells["REPAIREDTIME"].Value.ToString();
                txtmemo.Text = ulgridBaseInfo.ActiveRow.Cells["MEMO"].Value.ToString();
                ucmbNC.Text = ulgridBaseInfo.ActiveRow.Cells["MATERIALREPLACING"].Value.ToString();
            }
        }
    }

}