XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/扇形段/FrmSegMentManage.cs

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

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

        private void FrmSegMentManage_Load(object sender, EventArgs e)
        {
            ucmeFrom.DateTime = DateTime.Today;
            ucmeTo.DateTime = DateTime.Today;

            cmbZJH.SelectedIndex = 0;
            //chkCCM.Checked = true;

            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
            {
                txtID.Clear();
                txtZJH.Clear();
                txtWZ.Clear();
                cbbBC.SelectedIndex = -1;
                cbbBB.SelectedIndex = -1;
                txtZT.Clear();
                txtLX.Clear();
                txtLJLS.Clear();
                txtSYCS.Clear();
                udteOnTime.Text = "";
                udteNextTime.Text = "";
                cmbGZCJ.Text = "";
                txtMemo.Clear();
                txtWHRY.Clear();
                txtJZ.Clear();
                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 = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmSegMentManage_Query6");
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                arry.Add(strID);
                arry.Add(strCYCID);
                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;
                }

                string strBCBB = ConvertShift("3", cbbBC.Text.Trim()) + ConvertShift("4", cbbBB.Text);
                string strReturn = "";
                strErr = "";
                arry.Clear();
                ccs.ob = ob;
                arry.Add("FrmSegMentManage_Update1");
                arry.Add(strBCBB);
                arry.Add(txtLJLS.Text.Trim());
                arry.Add(txtSYCS.Text.Trim());
                arry.Add(udteOnTime.Text);
                arry.Add(udteNextTime.Text);
                arry.Add(cmbGZCJ.Text.Trim());
                arry.Add(txtXXYY.Text.Trim());
                arry.Add(txtWHRY.Text.Trim());
                arry.Add(txtJZ.Text.Trim());
                arry.Add(txtMemo.Text.Trim());
                arry.Add(strID);
                arry.Add(strCYCID);
                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("FrmSegMentManage_Query7");
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                arry.Add(strID);
                arry.Add(strCYCID);
                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 = ob;
                arry.Add("FrmSegMentManage_Query8");
                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;
                }
                string strReturn = "";
                strErr = "";
                arry.Clear();
                ccs.ob = ob;
                arry.Add("FrmSegMentManage_Del1");
                arry.Add(strID);
                arry.Add(strCYCID);
                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 = "";
                arry.Clear();
                ccs.ob = ob;
                arry.Add("FrmSegMentManage_Update2");
                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 strSql = "";

                if (chkCCM.Checked && cmbZJH.SelectedIndex > -1)
                    strSql = "where CCM_ID = '" + cmbZJH.Text.Trim() + "'";
                else
                    strSql = "";

                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();
                arry.Add("FrmSegMentManage_Query2");
                sqlList.Add(strSql);

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

                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 = "SEGMENTID";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 取塞棒、涂料、水口厂家
        /// </summary>
        private void proc_GetFactory()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmSegMentManage_Query1");
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
                if (strErr == "")
                {
                    
                    cmbGZCJ.DataSource = ds.Tables[0].DefaultView;
                    cmbGZCJ.DisplayMember = "BASENAME";
                    cmbGZCJ.ValueMember = "BASECODE";
                }
            }
            catch { }
        }
        /// <summary>
        /// 扇形段基本信息查询
        /// </summary>
        /// <param name="strCCMID"></param>
        /// <param name="strSXDNO"></param>
        public void proc_GetBaseInfo(string strCCMID, string strSXDNO)
        {
            try
            {
                string strErr = "";
                string strWhere = "";// "and CCM_ID <> '3#连铸机'";

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

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

                if (chkPos.Checked && cmbPos.Text.Trim().Length > 0)
                    strWhere += "and POSITION = '" + cmbPos.Text.Trim() + "'";

                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();
                arry.Add("FrmSegMentManage_Query3");
                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;
                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("扇形段基本信息查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                try
                {
                    ((DataTable)ulgridBaseInfo.DataSource).Rows.Clear();
                    ((DataTable)ulgridUseInfo.DataSource).Rows.Clear();
                }
                catch (Exception)
                {
                }
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    ulgridBaseInfo.DataSource = ds.Tables[0];
                }
                
                SetLeftTableRowColor();

                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 (strSXDNO.Length > 0)
                            {
                                if (Convert.ToString(ulgridBaseInfo.Rows[i].Cells["扇形段编号"].Value) == strSXDNO)
                                {
                                    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.SEGMENTID = '" + strID + "' ";

                if (chkDate.Checked)
                {
                    strWhere += "and to_char(t1.BEGINTIME,'yyyy-MM-dd') between '" + ucmeFrom.DateTime.ToString("yyyy-MM-dd") + "' and '" + ucmeTo.DateTime.ToString("yyyy-MM-dd") + "'";
                }
                else
                {
                    strWhere += "and (t1.SEGMENTID,t1.CYCID) in (select SEGMENTID,CYCID from (select row_number() over (partition by x.SEGMENTID order by x.CYCID desc) xh, x.* from DEV_SXD_USE_DETAIL x) where xh < 3)";
                }

                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();
                arry.Add("FrmSegMentManage_Query4");
                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();
                    //((DataTable)ulgridUseInfo.DataSource).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("FrmSegMentManage_Query5");
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                arry.Add(strID);
                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)
                {
                    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 "RepairDetail"://维修记录
                    {
                        FrmSGRepairDetail frm = new FrmSGRepairDetail(ob);
                        frm.ShowDialog();
                        break;
                    }
                case "BaseInfo"://基础信息
                    {
                        FrmSGBaseInfo frm = new FrmSGBaseInfo(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"://维修
                    {
                        FrmSGRepair frm = new FrmSGRepair(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;
                    }
            }
        }

        private void ulgridBaseInfo_DoubleClickRow(object sender, Infragistics.Win.UltraWinGrid.DoubleClickRowEventArgs e)
        {
            try
            {
                if (ulgridBaseInfo.ActiveRow == null)
                {
                    try
                    {
                        ((DataTable)ulgridUseInfo.DataSource).Rows.Clear();
                    }
                    catch (Exception)
                    {
                    }
                return;
                }
                    

                FrmSG frm = new FrmSG(ob);
                frm.Tag = this;
                frm.strID = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["ID"].Value);
                //frm.tbCurrPos = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["流号"].Value);
                frm.strCCM_LH = Convert.ToString(ulgridBaseInfo.ActiveRow.Cells["流号"].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);
                txtZJH.Text = Convert.ToString(ulRow.Cells["铸机号"].Value);
                txtWZ.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);
                txtZT.Text = Convert.ToString(ulRow.Cells["状态"].Value);
                txtLX.Text = Convert.ToString(ulRow.Cells["类型"].Value);
                txtLJLS.Text = Convert.ToString(ulRow.Cells["连浇炉数"].Value);
                txtSYCS.Text = Convert.ToString(ulRow.Cells["使用炉数"].Value);
                txtJZ.Text = Convert.ToString(ulRow.Cells["机长"].Value);
                txtWHRY.Text = Convert.ToString(ulRow.Cells["维护人员"].Value);
                udteOnTime.Text = Convert.ToString(ulRow.Cells["上线时间"].Value);
                udteNextTime.Text = Convert.ToString(ulRow.Cells["下线时间"].Value);
                cmbGZCJ.Text = Convert.ToString(ulRow.Cells["辊子厂家"].Value);
                txtXXYY.Text = Convert.ToString(ulRow.Cells["下线原因"].Value);
                txtMemo.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 cbPos_CheckedChanged(object sender, EventArgs e)
        {
            cmbPos.Enabled = chkPos.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)
        {
            ucmeFrom.Enabled = chkDate.Checked;
            ucmeTo.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;
            }
        }

    }
}