XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/结晶器/FrmCrystallizerManageBP.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 FrmCrystallizerManageBP : Core.Mes.Client.Common.frmStyleBase
    {
        public FrmCrystallizerManageBP()
        {
            InitializeComponent();
        }

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

            proc_GetFactory();
            proc_LoadCLID();
            proc_GetBaseInfo("", "");
        }

        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
            {
                tbID.Clear();
                cbbCCM.Text = "";
                cbbPos.Text = "";
                cbbBC.SelectedIndex = -1;
                cbbBB.SelectedIndex = -1;
                tbTGL.Clear();
                cbbStatus.Text = "";
                cbbType.SelectedIndex = -1;
                tbDzdzD.Clear();
                tbSYCS.Clear();
                tbGZ.Clear();
                tbDM.Clear();
                txtWidth.Clear();
                tbDzdzX.Clear();
                tbJF.Clear();
                tbLJLS.Clear();
                tbJZ.Clear();
                tbWHRY.Clear();
                ultraDateTimeEditor1.Text = "";
                ultraDateTimeEditor2.Text = "";
                cbbZK.Text = "";
                tbNO1.Clear();
                tbCS1.Clear();
                tbNO2.Clear();
                tbCS2.Clear();
                tbNO3.Clear();
                tbCS3.Clear();
                tbNO4.Clear();
                tbCS4.Clear();
                tbNO5.Clear();
                tbCS5.Clear();
                tbNO6.Clear();
                tbCS6.Clear();
                cbbTBCJ.Text = "";
                tbMemo.Clear();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void proc_ResetRepairArea()
        {
            try
            {
                tbID1.Clear();
                tbType1.Clear();
                tbBegin1.Clear();
                tbEnd1.Clear();
                tbReason1.Clear();
                tbMemo1.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 = "";
                ArrayList arry = new ArrayList();
                arry.Add("DEV_JJQ_USE_DETAIL.Select");
                arry.Add(strID);
                arry.Add(strCYCID);
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); 

                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;
                }


                string strBCBB = ConvertShift("3", cbbBC.Text.Trim()) + ConvertShift("4", cbbBB.Text);

                strErr = "";
                arry.Clear();
                arry.Add("FrmCrystallizerManageBP.Edit");
                arry.Add(strBCBB);
                arry.Add(tbTGL.Text.Trim());
                arry.Add(tbDzdzD.Text.Trim());
                arry.Add(tbSYCS.Text.Trim());
                arry.Add(tbGZ.Text.Trim());
                arry.Add(tbDM.Text.Trim()+"X"+txtWidth.Text.Trim());
                arry.Add(tbDzdzX.Text.Trim());
                arry.Add(tbJF.Text.Trim());
                arry.Add(tbLJLS.Text.Trim());
                arry.Add(tbJZ.Text.Trim());
                arry.Add(tbWHRY.Text.Trim());
                arry.Add(tbCS1.Text.Trim());
                arry.Add(tbCS2.Text.Trim());
                arry.Add(tbCS3.Text.Trim());
                arry.Add(tbCS4.Text.Trim());
                arry.Add(tbCS5.Text.Trim());
                arry.Add(tbCS6.Text.Trim());
                arry.Add(ultraDateTimeEditor1.Text);
                arry.Add(ultraDateTimeEditor2.Text);
                arry.Add(cbbZK.Text.Trim());
                arry.Add(cbbTBCJ.Text.Trim());
                arry.Add(tbMemo.Text.Trim());
                arry.Add(strID);
                arry.Add(strCYCID);
                ccs.ob = this.ob;
               string strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                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 = "";
                ArrayList arry = new ArrayList();
                arry.Add("DEV_JJQ_USE_DETAIL.Select");
                arry.Add(strID);
                arry.Add(strCYCID);
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
                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 = "";
                arry.Clear();
                ccs.ob = this.ob;
                arry.Add("DEV_JJQ_USE_DETAIL.Select_1");
                arry.Add(strID);
                arry.Add(strCYCID);
                ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);

                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;
                }

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

                strErr = "";
                arry.Clear();
                ccs.ob = this.ob;
                arry.Add("FrmCrystallizerManageBP.Del");
                arry.Add(strID);
                arry.Add(strCYCID);
                string strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strCCM + "］结晶器［" + strNO + "］的当前使用记录删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                } 
                
                strErr = "";
                strReturn = "";
                arry.Clear();
                arry.Add("FrmCrystallizerManageBP.Del.Updata");
                arry.Add(strID);
                strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                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 strCCM = cmbZJH.Text.Trim() ;
                ArrayList arry = new ArrayList();
                if (strCCM == "1#连铸机" || strCCM == "2#连铸机")
                {
                    arry.Add("OneandTwoCCM.select");
                }
                else
                {
                    arry.Add("CRYSTALLIZERID.select");
                    arry.Add(strCCM);
                }

                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);

                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;
                }

                cmbID.DataSource = ds.Tables[0];
                cmbID.DisplayMember = "CRYSTALLIZERID";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// SCM_BASE_INFO表基础信息查询
        /// </summary>
        private void proc_GetFactory()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("SCM_BASE_INFO");
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr); 
                if (strErr == "" && ds != null)
                {
                    cbbTBCJ.DataSource = ds.Tables[0].DefaultView;
                    cbbTBCJ.DisplayMember = "BASENAME";
                    cbbTBCJ.ValueMember = "BASECODE";
                }
            }
            catch { }
        }
        /// <summary>
        /// 结晶器基础信息查询
        /// </summary>
        /// <param 铸机号="strCCMID"></param>
        /// <param 结晶器编号="strJJQNO"></param>
        public void proc_GetBaseInfo(string strCCMID, string strJJQNO)
        {
            try
            {
                string strErr = "";
                //string strWhere = "and t.CCM_ID <> '3#连铸机'";
                string strCCM_ID = "";
                string strcbbID = "";
                if (chkCCM.Checked && cmbZJH.Text.Trim().Length > 0)
                {
                    strCCM_ID = cmbZJH.Text.Trim();
                }
                if (chkID.Checked && cmbID.Text.Length > 0)
                {
                    strcbbID = cmbID.Text.Trim();
                }

                ArrayList arry = new ArrayList();
                arry.Add("FrmCrystallizerManageBP.Select");
                arry.Add(strCCM_ID);
                arry.Add(strCCM_ID);
                arry.Add(strcbbID);
                arry.Add(strcbbID);
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
                try
                {
                    ((DataTable)ulgridBaseInfo.DataSource).Rows.Clear();
                    ((DataSet)ulgridUseInfo.DataSource).Tables[0].Rows.Clear();
                }
                catch (Exception)
                {
                }
                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)
                {
                    ulgridBaseInfo.DataSource = ds.Tables[0];
                }
                SetLeftTableRowColor();

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

                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 strWh = "";
                string strwhere = "";
                string strWhere = "";
                if (strID.Length > 0)
                    strWh ="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)  ";
                }

                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();
                sqlList.Add(strWh);
                if (chkDate.Checked)
                {
                    arry.Add("FrmCrystallizerManageBP_GetUseInfo.Select");
                    
                    sqlList.Add(strwhere);
                }
                else
                {
                    arry.Add("FrmCrystallizerManageBP_GetUseInfo.Select");
                    sqlList.Add(strWhere);
                }

                CoreClientParam CCP_LgEts = new CoreClientParam();
                DataTable dt = new DataTable();
                CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
                CCP_LgEts.MethodName = "doQuery";
                CCP_LgEts.ServerParams = new object[] { arry, sqlList };
                CCP_LgEts.SourceDataTable = dt;
                this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                strErr = CCP_LgEts.ReturnInfo;
                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 = "";
                ArrayList arry = new ArrayList();
                arry.Add("GetRepairInfo.Select");
                arry.Add(strID);
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
                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)
                {
                    tbID1.Text = Convert.ToString(ds.Tables[0].Rows[0]["结晶器编号"]);
                    tbType1.Text = Convert.ToString(ds.Tables[0].Rows[0]["维修类别"]);
                    tbBegin1.Text = Convert.ToString(ds.Tables[0].Rows[0]["送修时间"]);
                    tbEnd1.Text = Convert.ToString(ds.Tables[0].Rows[0]["修复时间"]);
                    tbReason1.Text = Convert.ToString(ds.Tables[0].Rows[0]["维修原因"]);
                    tbMemo1.Text = Convert.ToString(ds.Tables[0].Rows[0]["备注"]);
                }
                else
                    proc_ResetRepairArea();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }

        private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
        {
            switch (e.Tool.Key)
            {
                case "RepairDetail":
                    {
                        FrmCLRepairDetail frm = new FrmCLRepairDetail(ob);
                        frm.ShowDialog();
                        break;
                    }
                case "PLUGIN":
                    {
                        FrmCLPluginInfo frm = new FrmCLPluginInfo(ob);
                        frm.ShowDialog();
                        break;
                    }
                case "BaseInfo":
                    {
                        FrmCLBaseInfoBP frm = new FrmCLBaseInfoBP(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 "JJQWX":
                    {
                        FrmCLRepairBP frm = new FrmCLRepairBP(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 "Close":
                    {
                        this.Close();
                        break;
                    }
                case "Modfiy":
                    {
                        proc_Edit();
                        break;
                    }
                case "Delete":
                    {
                        proc_Del();
                        break;
                    }
            }
        }
        /// <summary>
        /// 菜单栏
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "RepairDetail"://维修记录查询
                    {
                        FrmCLRepairDetail frm = new FrmCLRepairDetail(ob);
                        frm.ShowDialog();
                        break;
                    }
                case "PLUGIN"://铜板水箱信息
                    {
                        FrmCLPluginInfo frm = new FrmCLPluginInfo(ob);
                        //frm.MdiParent=this.MdiParent;
                        //frm.Show();
                        frm.ShowDialog();
                        break;
                    }
                case "BaseInfo"://基本信息
                    {
                        FrmCLBaseInfoBP frm = new FrmCLBaseInfoBP(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 "JJQWX"://结晶器维修
                    {
                        FrmCLRepairBP frm = new FrmCLRepairBP(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 "Query":
                    {
                        proc_GetBaseInfo("", "");
                        break;
                    }
                case "Exit":
                    {
                        this.Close();
                        break;
                    }
                case "Update":
                    {
                        proc_Edit();
                        break;
                    }
                case "Delete":
                    {
                        proc_Del();
                        break;
                    }
            }
        }
        /// <summary>
        /// 双击ulgridBaseInfo选中行事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        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 = "1";
                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, "提示");
            }
        }
        /// <summary>
        /// ulgridBaseInfo单击事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ulgridBaseInfo_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                try
                {
                    ((DataSet)ulgridUseInfo.DataSource).Tables[0].Rows.Clear();
                }
                catch (Exception)
                {
                }
               
                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;

                tbID.Text = Convert.ToString(ulRow.Cells["结晶器编号"].Value);
                cbbCCM.Text = Convert.ToString(ulRow.Cells["铸机号"].Value);
                cbbPos.Text = Convert.ToString(ulRow.Cells["流号"].Value);
                cbbBC.Text = Convert.ToString(ulRow.Cells["班别"].Value).Substring(0, 1);
                cbbBB.Text = Convert.ToString(ulRow.Cells["班别"].Value).Substring(1, 1);
                tbTGL.Text = Convert.ToString(ulRow.Cells["通钢量"].Value);
                cbbStatus.Text = Convert.ToString(ulRow.Cells["状态"].Value);
                cbbType.Text = Convert.ToString(ulRow.Cells["类型"].Value);
                tbDzdzD.Text = Convert.ToString(ulRow.Cells["倒锥度值(东)"].Value);
                tbSYCS.Text = Convert.ToString(ulRow.Cells["使用炉数"].Value);
                tbGZ.Text = Convert.ToString(ulRow.Cells["钢种"].Value);

                string[] arry = new string[2];
                if (ulRow.Cells["断面"].Value.ToString() != "")
                {
                    arry = Convert.ToString(ulRow.Cells["断面"].Value).Split('X');
                    tbDM.Text = arry[0];
                    txtWidth.Text = arry[1];
                }
                else
                {
                    tbDM.Text = "";
                    txtWidth.Text = "";
                }
                tbDzdzX.Text = Convert.ToString(ulRow.Cells["倒锥度值(西)"].Value);
                tbJF.Text = Convert.ToString(ulRow.Cells["角缝"].Value);
                tbLJLS.Text = Convert.ToString(ulRow.Cells["连浇炉数"].Value);
                tbJZ.Text = Convert.ToString(ulRow.Cells["机长"].Value);
                tbWHRY.Text = Convert.ToString(ulRow.Cells["维护人员"].Value);
                ultraDateTimeEditor1.Text = Convert.ToString(ulRow.Cells["换上时间"].Value);
                ultraDateTimeEditor2.Text = Convert.ToString(ulRow.Cells["换下时间"].Value);
                cbbZK.Text = Convert.ToString(ulRow.Cells["铜板、足辊、喷嘴状况"].Value);
                tbNO1.Text = Convert.ToString(ulRow.Cells["OUTAGE"].Value);
                tbCS1.Text = Convert.ToString(ulRow.Cells["VL1"].Value);
                tbNO2.Text = Convert.ToString(ulRow.Cells["INNERAGE"].Value);
                tbCS2.Text = Convert.ToString(ulRow.Cells["VL2"].Value);
                tbNO3.Text = Convert.ToString(ulRow.Cells["LEFTAGE"].Value);
                tbCS3.Text = Convert.ToString(ulRow.Cells["VL3"].Value);
                tbNO4.Text = Convert.ToString(ulRow.Cells["RIGHTAGE"].Value);
                tbCS4.Text = Convert.ToString(ulRow.Cells["VL4"].Value);
                cbbTBCJ.Text = Convert.ToString(ulRow.Cells["铜板厂家"].Value);
                tbMemo.Text = Convert.ToString(ulRow.Cells["备注"].Value);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }

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

        private void cbCCM_CheckedChanged(object sender, EventArgs e)
        {
            cmbZJH.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;
            }
        }

        private void tbDM_KeyPress(object sender, KeyPressEventArgs e)
        {
            try
            {
                if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.'))
                    e.Handled = true;
            }
            catch { }
        }

        private void txtWidth_KeyPress(object sender, KeyPressEventArgs e)
        {
            try
            {
                if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.'))
                    e.Handled = true;
            }
            catch { }
        }

    }
}