XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/结晶器/FrmCrystallizerManage.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 CoreFS.CA06;
using Core.Mes.Client.Common;

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

        private void FrmCrystallizerManage_Load(object sender, EventArgs e)
        {
            udteFrom.DateTime = DateTime.Today;
            udteTo.DateTime = DateTime.Today;

            proc_GetFactory();
            proc_LoadCLID();
            proc_GetBaseInfo("", "");
            GetSteel();
            DataSet dsSteel = LadleCommonClass.GetSteelData("");
            //增加Grid单位字段数据集
            ulgridUseInfo.DisplayLayout.ValueLists.Add("SteelCode");
            //绑定单位
            ulgridUseInfo.DisplayLayout.Bands[0].Columns["钢种"].ValueList = ulgridUseInfo.DisplayLayout.ValueLists["SteelCode"];
        }

        /// <summary>
        /// 获取钢种
        /// </summary>
        private void GetSteel()
        {
            try
            {
                string strsql = "Select SteelCode, steel steelname from scm_steel  where LARGEFLAG='1' ORDER BY SteelCode";
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp.MethodName = "QueryMethods";
                ccp.ServerParams = new Object[] { strsql };
                DataTable dt = new DataTable();
                ccp.SourceDataTable = dt;
                ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                  this.ucmeGrude.Items.Clear();
              for(int   i=0;i<ds.Tables[0].Rows.Count;i++)  //遍历所有行的信息 
              {
                  this.ucmeGrude.Items.Add(ds.Tables[0].Rows[i][0]);//显示第一列的所有行的信息 
              }
            }
            catch { }
        }


        private string ConvertShift(string strFlag, string strShift)
        {
            if (strFlag == "1")
            {
                switch (strShift.Substring(0, 1))
                {
                    case "1":
                        return "白";
                    case "2":
                        return "中";
                    case "3":
                        return "夜";
                    default:
                        return "";
                }
            }
            else if (strFlag == "2")
            {
                switch (strShift.Substring(1, 1))
                {
                    case "1":
                        return "甲";
                    case "2":
                        return "乙";
                    case "3":
                        return "丙";
                    case "4":
                        return "丁";
                    default:
                        return "";
                }
            }
            else if (strFlag == "3")
            {
                switch (strShift.Trim())
                {
                    case "白":
                        return "1";
                    case "中":
                        return "2";
                    case "夜":
                        return "3";
                    default:
                        return "";
                }
            }
            else if (strFlag == "4")
            {
                switch (strShift.Trim())
                {
                    case "甲":
                        return "1";
                    case "乙":
                        return "2";
                    case "丙":
                        return "3";
                    case "丁":
                        return "4";
                    default:
                        return "";
                }
            }

            return "";
        }

        private void SetLeftTableRowColor()
        {
            for (int i = 0; i < this.ulgridBaseInfo.Rows.Count; i++)
            {
                switch (this.ulgridBaseInfo.Rows[i].Cells["状态"].Text.Trim())
                {
                    case "上线"://上线
                        this.ulgridBaseInfo.Rows[i].Appearance.BackColor = Color.LightGreen;
                        break;
                    case "维修"://维修
                        this.ulgridBaseInfo.Rows[i].Appearance.BackColor = Color.LightBlue;
                        break;
                    default:
                        this.ulgridBaseInfo.Rows[i].Appearance.BackColor = Color.LightYellow;
                        break;
                }
            }
        }

        private void SetRightTableRowColor()
        {
            for (int i = 0; i < this.ulgridUseInfo.Rows.Count; i++)
            {
                switch (this.ulgridUseInfo.Rows[i].Cells["状态"].Text.Trim())
                {
                    case "上线"://上线
                        this.ulgridUseInfo.Rows[i].Appearance.BackColor = Color.LightGreen;
                        break;
                    case "维修"://维修
                        this.ulgridUseInfo.Rows[i].Appearance.BackColor = Color.LightBlue;
                        break;
                    default:
                        this.ulgridUseInfo.Rows[i].Appearance.BackColor = Color.LightYellow;
                        break;
                }
            }
        }

        private void proc_ResetEditArea()
        {
            try
            {
                txtID.Clear();
                cmbCCM.Text = "";
                cmbPos.Text = "";
                cmbBC.SelectedIndex = -1;
                cmbBB.SelectedIndex = -1;
                txtTGL.Clear();
                txtTbcs.Clear();
                cmbStatus.Text = "";
                cmbType.SelectedIndex = -1;
                txtDzdzD.Clear();
                txtJCH.Clear();
                ucmeGrude.SelectedIndex = -1;
                txtDM.Clear();
                txtDzdzX.Clear();
                txtJF.Clear();
                txtLJLS.Clear();
                txtJZ.Clear();
                txtWHRY.Clear();
                txtTGBH.Clear();
                ucmeTGCJ.Text = "";
                udtePutTime.Text = "";
                udteNextTime.Text = "";
                ucmeZK.Text = "";
                txtMemo.Clear();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void proc_ResetRepairArea()
        {
            try
            {
                txtID1.Clear();
                txtType1.Clear();
                txtBegin1.Clear();
                txtEnd1.Clear();
                txtReason1.Clear();
                txtMemo1.Clear();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 修改
        /// </summary>
        private void proc_Edit()
        {
            try
            {
                if (ulgridUseInfo.Rows.Count == 0)
                    return;

                if (ulgridUseInfo.ActiveRow == null)
                {
                    MessageBox.Show("请选择要修改的使用记录！", "提示");
                    return;
                }

                string strID = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["ID"].Value);
                string strNO = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["结晶器编号"].Value);
                string strCCM = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["铸机号"].Value);
                string strCYCID = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["周期编号"].Value);

                if (MessageBox.Show("确定要修改［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;

                string strErr = "";
                string strSql = "select count(1) from DEV_JJQ_USE_DETAIL where CRYSTALLIZERID = '" + strID + "' and CYCID = '" + strCYCID + "'";
               
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp.MethodName = "QueryMethods";
                ccp.ServerParams = new Object[] { strSql };
                DataTable dt = new DataTable();
                ccp.SourceDataTable = dt;
                ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt == 0)
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录不存在，无法修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    proc_GetBaseInfo(strCCM, strNO);
                    return;
                }

                string strBCBB = ConvertShift("3", cmbBC.Text.Trim()) + ConvertShift("4", cmbBB.Text);

                strErr = "";
                strSql = "update DEV_JJQ_USE_DETAIL set "
                + "CLASS = '" + strBCBB + "',"
                + "AGE = '" + txtTGL.Text.Trim() + "',"
                + "COPPERPLATETIME = '" + txtTbcs.Text.Trim() + "',"
                //+ "TYPE = '" + (cbbType.SelectedIndex == 0 ? "1" : (cbbType.SelectedIndex == 1 ? "2" : "")) + "',"
                + "WIMBLE_E = '" + txtDzdzD.Text.Trim() + "',"
                + "CURPOURINGID = '" + txtJCH.Text.Trim() + "',"
                + "GRUDE = '" + (ucmeGrude.Value==null?"":ucmeGrude.Value.ToString().Trim()) + "',"
                + "JJQSECTION = '" + txtDM.Text.Trim() + "',"
                + "WIMBLE_W = '" + txtDzdzX.Text.Trim() + "',"
                + "ANGLESLOT = '" + txtJF.Text.Trim() + "',"
                + "MOULDNUMBER = '" + txtLJLS.Text.Trim() + "',"
                + "CAPTAIN = '" + txtJZ.Text.Trim() + "',"
                + "SURFACEMAN = '" + txtWHRY.Text.Trim() + "',"
                + "COPPERPLATEFACTORY = '" + ucmeTGCJ.Text.Trim() + "',"
                + "BEGINTIME = to_date('" + udtePutTime.Text + "','yyyy-MM-dd HH24:mi:ss'),"
                + "ENDTIME = to_date('" + udteNextTime.Text + "','yyyy-MM-dd HH24:mi:ss'),"
                + "COPPERPLATENOZZLESTATE = '" + ucmeZK.Text.Trim() + "',"
                + "MEMO = '" + txtMemo.Text.Trim() + "' "
                + "where CRYSTALLIZERID = '" + strID + "' and CYCID = '" + strCYCID + "'";

                CoreClientParam ccpUP = new CoreClientParam();
                ccpUP.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccpUP.MethodName = "UpdateMethods";
                ccpUP.ServerParams = new Object[] { strSql };
                ExecuteNonQuery(ccpUP, CoreInvokeType.Internal);

                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                proc_GetBaseInfo(strCCM, strNO);
                MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 删除
        /// </summary>
        private void proc_Del()
        {
            try
            {
                if (ulgridUseInfo.Rows.Count == 0)
                    return;

                if (ulgridUseInfo.ActiveRow == null)
                {
                    MessageBox.Show("请选择要删除的使用记录！", "提示");
                    return;
                }

                string strID = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["ID"].Value);
                string strNO = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["结晶器编号"].Value);
                string strCCM = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["铸机号"].Value);
                string strCYCID = Convert.ToString(ulgridUseInfo.ActiveRow.Cells["周期编号"].Value);

                if (MessageBox.Show("确定要删除［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;

                string strErr = "";
                string strSql = "select count(1) from DEV_JJQ_USE_DETAIL where CRYSTALLIZERID = '" + strID + "' and CYCID = '" + strCYCID + "'";
                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp.MethodName = "QueryMethods";
                ccp.ServerParams = new Object[]{ strSql };
                DataTable dt = new DataTable();
                ccp.SourceDataTable = dt;
                ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt == 0)
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录不存在，无法删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    proc_GetBaseInfo(strCCM, strNO);
                    return;
                }

                ds = null;
                strErr = "";
                string Sql = "select nvl(NOWSTATUS,'0') NOWSTATUS from DEV_JJQ_USE_DETAIL where CRYSTALLIZERID = '" + strID + "' and CYCID = '" + strCYCID + "'";
                CoreClientParam ccpdel = new CoreClientParam();
                ccpdel.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccpdel.MethodName = "QueryMethods";
                ccpdel.ServerParams = new Object[] { Sql };
                DataTable dtt = new DataTable();
                ccpdel.SourceDataTable = dtt;
                ExecuteQueryToDataTable(ccpdel, CoreInvokeType.Internal);
                DataSet dss = new DataSet();
                dss.Tables.Add(dtt);

                if (strErr != "" || !(dss != null && dss.Tables.Count > 0 && dss.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                if (Convert.ToString(dss.Tables[0].Rows[0]["NOWSTATUS"]) != "1") //１代表上线
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录已经结束，不能删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                strErr = "";
                string sSql = "delete from DEV_JJQ_USE_DETAIL where CRYSTALLIZERID = '" + strID + "' and CYCID = '" + strCYCID + "'";

                CoreClientParam ccp_del = new CoreClientParam();
                ccp_del.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp_del.MethodName = "UpdateMethods";
                ccp_del.ServerParams = new Object[] { sSql };
                ExecuteNonQuery(ccp_del, CoreInvokeType.Internal);

                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                } 
                
                strErr = "";
               string  strSql1 = "update DEV_JJQ_BASE_INFO set NOWSTATUS = '0', CCM_S_ID = null where ID = '" + strID + "'";
               CoreClientParam ccp_up = new CoreClientParam();
               ccp_up.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
               ccp_up.MethodName = "UpdateMethods";
               ccp_up.ServerParams = new Object[] { strSql1 };
               ExecuteNonQuery(ccp_up, CoreInvokeType.Internal);

                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                proc_GetBaseInfo(strCCM, strNO);
                MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 加载结晶器编号
        /// </summary>
        private void proc_LoadCLID()
        {
            try
            {
                string strErr = "";
                string strSql = "";

                if (chkCCM.Checked && ucmeZJH.SelectedIndex > -1)
                    strSql = "select CRYSTALLIZERID from DEV_JJQ_BASE_INFO where CCM_ID = '" + ucmeZJH.Text.Trim() + "' order by length(CRYSTALLIZERID), CRYSTALLIZERID";
                else
                    strSql = "select distinct CRYSTALLIZERID from DEV_JJQ_BASE_INFO  order by length(CRYSTALLIZERID), CRYSTALLIZERID";

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp.MethodName = "QueryMethods";
                ccp.ServerParams = new Object[] { strSql };
                DataTable dt = new DataTable();
                ccp.SourceDataTable = dt;
                ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("结晶器号加载失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    if (MessageBox.Show("是否重新加载结晶器号？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        proc_LoadCLID();
                    return;
                }

                ucmeID.Items.Clear();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    ucmeID.Items.Add(ds.Tables[0].Rows[i][0].ToString());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }

        /// <summary>
        /// 获取铜管厂家
        /// </summary>
        private void proc_GetFactory()
        {
            try
            {
                ArrayList ar = new ArrayList();
                ar.Add(LadleCommonClass.strCuPipeFactoryCode);
                ar.Add("");
                ar.Add("order by BASENAME");
                //string strErr = "";
                DataSet ds = QueryArrayFunions("Core.LgMes.Server.LgDeviceManager.LadleManager", "GetFactory", new object[] { ar }, ob);
               if (ds.Tables[0].Rows.Count > 0)
               {
                   for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                   {
                       this.ucmeTGCJ.Items.Add(ds.Tables[0].Rows[i][1]);
                   }
               }
            }
            catch { }
        }
        /// <summary>
        /// 结晶器基本信息查询
        /// </summary>
        /// <param name="strCCMID"></param>
        /// <param name="strJJQNO"></param>
        public void proc_GetBaseInfo(string strCCMID, string strJJQNO)
        {
            try
            {
                string strErr = "";
                string strWhere = "";

                if (chkCCM.Checked && ucmeZJH.Text.Trim().Length > 0)
                    strWhere = "and CCM_ID = '" + ucmeZJH.Text.Trim()+ "' ";

                if (chkID.Checked && ucmeID.Text.Length > 0)
                    strWhere += "and CRYSTALLIZERID = '" + ucmeID.Text.Trim()+ "'";

                string strSql = "select t.ID, t.CRYSTALLIZERID 结晶器编号, to_char(t.CREATIVEDATE,'yyyy-MM-dd') 生产日期, to_char(t.BUYDATE,'yyyy-MM-dd') 购买日期, t.AGE 通钢量,"
            +"case t.NOWSTATUS when '0' then '下线' when '1' then '上线' when '2' then '维修' when '3' then '备用' end 状态,"
            +"t.CUPRUMCANALTIME 铜管次数, t.OUTERCOPPER 铜管编号,"
            +"case t.TYPE   when '1' then    '板坯'   when '2' then    '方坯' end 类型 ,"
            +"t.CCM_ID 铸机号, t.CCM_S_ID 流号, t.MEMO 备注  from DEV_JJQ_BASE_INFO t where 1=1"
            + " " + strWhere + " "

            + "order by t.CCM_ID, "
            + "case t.NOWSTATUS when '0' then '下线' when '1' then '上线' when '2' then '维修' when '3' then '备用' end, "
            + "length(t.CRYSTALLIZERID), t.CRYSTALLIZERID";

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp.MethodName = "QueryMethods";
                ccp.ServerParams = new Object[] { strSql };
                DataTable dt = new DataTable();
                ccp.SourceDataTable = dt;
                ExecuteQueryToDataTable(ccp,CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                try
                {
                    ((DataSet)ulgridBaseInfo.DataSource).Tables[0].Rows.Clear();
                    ((DataSet)ulgridUseInfo.DataSource).Tables[0].Rows.Clear();
                }
                catch (Exception)
                {
                }
                if (ds.Tables[0].Rows.Count > 0)
                {
                    ulgridBaseInfo.DataSource = ds;
                }

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("结晶器基本信息查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                if (ds.Tables[0].Rows.Count == 0)
                    proc_ResetRepairArea();

                if (strCCMID.Length > 0)            //定位记录
                {
                    for (int i = 0; i < ulgridBaseInfo.Rows.Count; i++)
                    {
                        if (Convert.ToString(ulgridBaseInfo.Rows[i].Cells["铸机号"].Value) == strCCMID)
                        {
                            if (strJJQNO.Length > 0)
                            {
                                if (Convert.ToString(ulgridBaseInfo.Rows[i].Cells["结晶器编号"].Value) == strJJQNO)
                                {
                                    ulgridBaseInfo.ActiveRow = ulgridBaseInfo.Rows[i];
                                    ulgridBaseInfo.Rows[i].Selected = true;
                                    return;
                                }
                            }
                            else
                            {
                                ulgridBaseInfo.ActiveRow = ulgridBaseInfo.Rows[i];
                                ulgridBaseInfo.Rows[i].Selected = true;
                                return;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 使用信息查询
        /// </summary>
        /// <param name="strID"></param>
        private void proc_GetUseInfo(string strID)
        {
            try
            {
                string strErr = "";
                string strWhere = "";

                if (strID.Length > 0)
                    strWhere = "and t1.CRYSTALLIZERID = '" + strID + "' ";

                if (chkDate.Checked)
                {
                    strWhere += "and to_char(t1.BEGINTIME,'yyyy-MM-dd') between '" + udteFrom.DateTime.ToString("yyyy-MM-dd") + "' and '" + udteTo.DateTime.ToString("yyyy-MM-dd") + "'";
                }
                else
                {
                    strWhere += "and (t1.CRYSTALLIZERID,t1.CYCID) in (select CRYSTALLIZERID,CYCID from (select row_number() over (partition by x.CRYSTALLIZERID order by x.CYCID desc) xh, x.* from DEV_JJQ_USE_DETAIL x) where xh < 3)";
                }
                string strsql = "select t2.CRYSTALLIZERID 结晶器编号, t1.CYCID 周期编号, t1.NOWPOSITION 铸机号,case when t1.NOWPOSITION='1#连铸机' or  t1.NOWPOSITION = '0#连铸机' then " 
                +"t1.CCM_S_ID else 'S' || to_char(to_number(substr( t1.CCM_S_ID,2,1))-1) end 流号, t1.CRYSTALLIZERID ID,"
                +"case t1.NOWSTATUS when '0' then '下线' when '1' then '上线' when '2' then '维修' when '3' then '备用' end 状态, t1.OUTERCOPPER 铜管编号, t1.COPPERPLATEFACTORY 铜管厂家, "
                +"case substr(t1.CLASS,1,1) when '1' then '白' when '2' then '中' when '3' then '夜' end||case substr(t1.CLASS,2,1) when '1' then '甲' when '2' then '乙' when '3' then '丙' when '4' then '丁' end 班别,"
                +"t1.COPPERPLATETIME 铜管次数, t1.MOULDNUMBER 连浇炉数, t1.GRUDE 钢种, t1.JJQSECTION 断面, t1.CURPOURINGID 浇次号, case t1.TYPE when '1' then '板坯' when '2' then '方坯' end 类型,"
                + "t1.WIMBLE_E \"倒锥度值(东)\", t1.WIMBLE_W \"倒锥度值(西)\", t1.ANGLESLOT 角缝, t1.COPPERPLATENOZZLESTATE \"铜管、足辊、喷嘴状况\", t1.AGE 通钢量, "
                +"to_char(t1.BEGINTIME,'yyyy-MM-dd HH24:mi:ss') 换上时间, to_char(t1.ENDTIME,'yyyy-MM-dd HH24:mi:ss') 换下时间, t1.SURFACEMAN 维护人员, t1.CAPTAIN 机长, t1.MEMO 备注 "
                +"from DEV_JJQ_USE_DETAIL t1, DEV_JJQ_BASE_INFO t2 where t1.CRYSTALLIZERID = t2.ID(+) " + strWhere + " "
                +"order by t1.CRYSTALLIZERID, t1.CYCID desc";

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp.MethodName = "QueryMethods";
                ccp.ServerParams = new Object[] { strsql };
                DataTable dt = new DataTable();
                ccp.SourceDataTable = dt;
                ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                try
                {
                    ((DataSet)ulgridUseInfo.DataSource).Tables[0].Rows.Clear();
                }
                catch (Exception)
                {
                }
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    ulgridUseInfo.DataSource = ds;
                }

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("结晶器［" + strID + "］使用信息查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                SetRightTableRowColor();

                if (ds.Tables[0].Rows.Count == 0)
                    proc_ResetEditArea();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 维修记录
        /// </summary>
        /// <param name="strID"></param>
        private void proc_GetRepairInfo(string strID)
        {
            try
            {
                if (strID.Length == 0) return;

                string strErr = "";
                string strsql = "select t2.CRYSTALLIZERID 结晶器编号, t1.REPAIRTYPE 维修类别, t1.REASON 维修原因,t1. MEMO 备注,"
            + "to_char(t1.REPAIRTIME,'yyyy-MM-dd HH24:mi:ss') 送修时间, to_char(t1.REPAIREDTIME,'yyyy-MM-dd HH24:mi:ss') 修复时间 "
            + "from DEV_TOOL_REPAIR t1, DEV_JJQ_BASE_INFO t2 where t1.REPAIRTOOLID = t2.ID(+) and t1.REPAIRID = (select max(REPAIRID) from DEV_TOOL_REPAIR where TOOLTYPEID = '2' and REPAIRTOOLID = '" + strID + "')";

                CoreClientParam ccp = new CoreClientParam();
                ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
                ccp.MethodName = "QueryMethods";
                ccp.ServerParams = new Object[] { strsql };
                DataTable dt = new DataTable();
                ccp.SourceDataTable = dt;
                ExecuteQueryToDataTable(ccp, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);

                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("结晶器［" + strID + "］维修信息查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                if (ds.Tables[0].Rows.Count > 0)
                {
                    txtID1.Text = Convert.ToString(ds.Tables[0].Rows[0]["结晶器编号"]);
                    txtType1.Text = Convert.ToString(ds.Tables[0].Rows[0]["维修类别"]);
                    txtBegin1.Text = Convert.ToString(ds.Tables[0].Rows[0]["送修时间"]);
                    txtEnd1.Text = Convert.ToString(ds.Tables[0].Rows[0]["修复时间"]);
                    txtReason1.Text = Convert.ToString(ds.Tables[0].Rows[0]["维修原因"]);
                    txtMemo1.Text = Convert.ToString(ds.Tables[0].Rows[0]["备注"]);
                }
                else
                    proc_ResetRepairArea();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 菜单栏
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "MTRecordQuery":
                    {
                        FrmCLRepairDetail frm = new FrmCLRepairDetail(ob);
                        frm.ShowDialog();
                        break;
                    }
                case "BasicInfo":
                    {
                        FrmCLBaseInfo frm = new FrmCLBaseInfo(ob);
                        frm.Tag = this;
                        if (ulgridBaseInfo.ActiveRow != null)
                        {
                            frm.strCCM = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["铸机号"].Value);
                            frm.strNo = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["结晶器编号"].Value);
                        }
                        frm.ShowDialog();
                        break;
                    }
                case "JJQMT":
                    {
                        FrmCLRepair frm = new FrmCLRepair(ob);
                        frm.Tag = this;
                        if (ulgridBaseInfo.ActiveRow != null)
                        {
                            frm.strCCM = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["铸机号"].Value);
                            frm.strNo = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["结晶器编号"].Value);
                        }
                        frm.ShowDialog();
                    }
                    break;
                case "select":
                    {
                        proc_GetBaseInfo("", "");
                        break;
                    }
                case "update":
                    {
                        proc_Edit();
                        break;
                    }
                case "delete":
                    {
                        proc_Del();
                        break;
                    }
                case "Close":
                    {
                        this.Close();
                        break;
                    }
            }
        }

        private void ulgridBaseInfo_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            try
            {
                if (ulgridBaseInfo.ActiveRow == null)
                    return;

                FrmCL frm = new FrmCL(ob);
                frm.Tag = this;
                frm.strFlag = "0";
                frm.strID = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["ID"].Value);
                frm.strNO = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["结晶器编号"].Value);
                frm.strCCM = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["铸机号"].Value);
                frm.strPOS = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["流号"].Value);
                frm.strSTATUS = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["状态"].Value);
                frm.ShowDialog();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }

        private void ulgridBaseInfo_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                if (ulgridBaseInfo.ActiveRow == null)
                    return;
                    
                string strID = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["ID"].Value);
                proc_GetUseInfo(strID);///使用信息
                proc_GetRepairInfo(strID);//维修记录
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }

        private void ulgridUseInfo_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                if (ulgridUseInfo.ActiveRow == null)
                    return;

                Infragistics.Win.UltraWinGrid.UltraGridRow ulRow = ulgridUseInfo.ActiveRow;

                txtID.Text = Convert.ToString(ulRow.Cells["结晶器编号"].Value.ToString().Trim());
                cmbCCM.Text = Convert.ToString(ulRow.Cells["铸机号"].Value.ToString().Trim());
                cmbPos.Text = Convert.ToString(ulRow.Cells["流号"].Value.ToString().Trim());
                cmbBC.Text = Convert.ToString(ulRow.Cells["班别"].Value).Substring(0, 1);
                cmbBB.Text = Convert.ToString(ulRow.Cells["班别"].Value).Substring(1, 1);
                txtTGL.Text = Convert.ToString(ulRow.Cells["通钢量"].Value.ToString().Trim());
                txtTbcs.Text = Convert.ToString(ulRow.Cells["铜管次数"].Value.ToString().Trim());
                cmbStatus.Text = Convert.ToString(ulRow.Cells["状态"].Value.ToString().Trim());
                cmbType.Text = Convert.ToString(ulRow.Cells["类型"].Value.ToString().Trim());
                txtDzdzD.Text = Convert.ToString(ulRow.Cells["倒锥度值(东)"].Value.ToString().Trim());
                txtJCH.Text = Convert.ToString(ulRow.Cells["浇次号"].Value.ToString().Trim());
                ucmeGrude.Value = Convert.ToString(ulRow.Cells["钢种"].Value.ToString().Trim());
                txtDM.Text = Convert.ToString(ulRow.Cells["断面"].Value.ToString().Trim());
                txtDzdzX.Text = Convert.ToString(ulRow.Cells["倒锥度值(西)"].Value.ToString().Trim());
                txtJF.Text = Convert.ToString(ulRow.Cells["角缝"].Value.ToString().Trim());
                txtLJLS.Text = Convert.ToString(ulRow.Cells["连浇炉数"].Value.ToString().Trim());
                txtJZ.Text = Convert.ToString(ulRow.Cells["机长"].Value.ToString().Trim());
                txtWHRY.Text = Convert.ToString(ulRow.Cells["维护人员"].Value.ToString().Trim());
                udtePutTime.Text = Convert.ToString(ulRow.Cells["换上时间"].Value.ToString().Trim());
                udteNextTime.Text = Convert.ToString(ulRow.Cells["换下时间"].Value.ToString().Trim());
                ucmeZK.Text = Convert.ToString(ulRow.Cells["铜管、足辊、喷嘴状况"].Value.ToString().Trim());
                txtTGBH.Text = Convert.ToString(ulRow.Cells["铜管编号"].Value.ToString().Trim());
                ucmeTGCJ.Text = Convert.ToString(ulRow.Cells["铜管厂家"].Value.ToString().Trim());
                txtMemo.Text = Convert.ToString(ulRow.Cells["备注"].Value.ToString().Trim());
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }

        private void chkID_CheckedChanged(object sender, EventArgs e)
        {
            ucmeID.Enabled = chkID.Checked;
        }

        private void cbCCM_CheckedChanged(object sender, EventArgs e)
        {
            ucmeZJH.Enabled = chkCCM.Checked;
            proc_LoadCLID();
        }

        private void cbbZJH_SelectedIndexChanged(object sender, EventArgs e)
        {
            proc_LoadCLID();
        }

        private void cbDate_CheckedChanged(object sender, EventArgs e)
        {
            udteFrom.Enabled = chkDate.Checked;
            udteTo.Enabled = chkDate.Checked;
        }

        private void NumberEditor_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.') || (((TextBox)(sender)).Text.Trim().Contains(".") && e.KeyChar == '.'))
            {
                e.Handled = true;
            }
        }
    }
}