XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/结晶器/FrmCLBaseInfoBP.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 FrmCLBaseInfoBP : Core.Mes.Client.Common.frmStyleBase
    {
        bool bOK = false;      //是否响应结晶器号选择改变事件

        public string strNo = "", strCCM = "";
        public FrmCLBaseInfoBP(OpeBase oba)
        {
            InitializeComponent();
            ob = oba;
        }

        private void txtAge_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 FrmCLBaseInfoBP_Load(object sender, EventArgs e)
        {
            //proc_LoadCLID();
            if (strCCM.Length > 0)
            {
                cmbCCM.Text = strCCM;
                this.cbbCCM_SelectedIndexChanged(this, null);
                if (strNo.Length > 0)
                {
                    cmbID.Text = strNo;
                    bOK = true;
                    this.cbbID_SelectedIndexChanged(this, null);
                }
            }
            else
                bOK = true;
        }

        private void proc_GetID(string strCCM)
        {
            try
            {
                if (strCCM.Length == 0)
                    return;

                string strErr = "";
                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_GetID(strCCM);
                    return;
                }

                cmbID.DataSource = ds.Tables[0];
                cmbID.DisplayMember = "CRYSTALLIZERID";

                if (ds.Tables[0].Rows.Count == 0)
                    proc_ResetControl();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void proc_GetPluginInfo(string strCCM, string strID)
        {
            try
            {
                if (strCCM.Length == 0)
                    return;

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("GetPluginInfo.Select");
                arry.Add(strCCM);
                arry.Add(strCCM);
                arry.Add(strID);
                arry.Add(strCCM);
                arry.Add(strID);
                arry.Add(strCCM);
                arry.Add(strID);
                arry.Add(strCCM);
                arry.Add(strID);
                arry.Add(strCCM);
                arry.Add(strID);
                arry.Add(strCCM);
                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("结晶器插件信息加载失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    if (MessageBox.Show("是否重新加载结晶器插件信息？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        proc_GetPluginInfo(strCCM, strID);
                    return;
                }

                if (ds.Tables[0].Rows.Count > 0)
                {
                    DataRow dr = ds.Tables[0].NewRow();
                    dr["ID"] = "0";
                    dr["PLUGINNO"] = "";
                    dr["TYPE"] = "2";
                    ds.Tables[0].Rows.InsertAt(dr, 0);

                    dr = ds.Tables[0].NewRow();
                    dr["ID"] = "0";
                    dr["PLUGINNO"] = "";
                    dr["TYPE"] = "1";
                    ds.Tables[0].Rows.InsertAt(dr, 0);

                    dr = ds.Tables[0].NewRow();
                    dr["ID"] = "0";
                    dr["PLUGINNO"] = "";
                    dr["TYPE"] = "0";
                    ds.Tables[0].Rows.InsertAt(dr, 0);

                    ds.Tables[0].AcceptChanges();
                    DataSet ds1 = ds.Copy();
                    DataView dv1 = ds1.Tables[0].DefaultView;
                    dv1.RowFilter = "Type = '0'";

                    DataSet ds2 = ds.Copy();
                    DataView dv2 = ds2.Tables[0].DefaultView;
                    dv2.RowFilter = "Type = '0'";

                    DataSet ds3 = ds.Copy();
                    DataView dv3 = ds3.Tables[0].DefaultView;
                    dv3.RowFilter = "Type = '1'";

                    DataSet ds4 = ds.Copy();
                    DataView dv4 = ds4.Tables[0].DefaultView;
                    dv4.RowFilter = "Type = '1'";

                    DataSet ds5 = ds.Copy();
                    DataView dv5 = ds5.Tables[0].DefaultView;
                    dv5.RowFilter = "Type = '2'";

                    DataSet ds6 = ds.Copy();
                    DataView dv6 = ds6.Tables[0].DefaultView;
                    dv6.RowFilter = "Type = '2'";


                    cmbID1.DataSource = dv1;
                    cmbID1.ValueMember = "ID";
                    cmbID1.DisplayMember = "PLUGINNO";

                    cmbID2.DataSource = dv2;
                    cmbID2.ValueMember = "ID";
                    cmbID2.DisplayMember = "PLUGINNO";

                    cmbID3.DataSource = dv3;
                    cmbID3.ValueMember = "ID";
                    cmbID3.DisplayMember = "PLUGINNO";

                    cmbID4.DataSource = dv4;
                    cmbID4.ValueMember = "ID";
                    cmbID4.DisplayMember = "PLUGINNO";

                    cmbID5.DataSource = dv5;
                    cmbID5.ValueMember = "ID";
                    cmbID5.DisplayMember = "PLUGINNO";

                    cmbID6.DataSource = dv6;
                    cmbID6.ValueMember = "ID";
                    cmbID6.DisplayMember = "PLUGINNO";
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void proc_ResetControl()
        {
            try
            {
                cmbID.Text = "";
                txtCS.Clear();
                txtTgl.Clear();
                cmbID1.SelectedIndex = -1;
                txtCS1.Clear();
                cmbID2.SelectedIndex = -1;
                txtCS2.Clear();
                cmbID3.SelectedIndex = -1;
                txtCS3.Clear();
                cmbID4.SelectedIndex = -1;
                txtCS4.Clear();
                cmbID5.SelectedIndex = -1;
                txtCS5.Clear();
                cmbID6.SelectedIndex = -1;
                txtCS6.Clear();
                txtStatus.Clear();
                txtPos.Clear();
                udtePTime.DateTime = DateTime.Now;
                udteBuyTime.DateTime = DateTime.Now;
                txtMemo.Clear();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 结晶器基本信息增加
        /// </summary>
        private void proc_Add()
        {
            try
            {
                string strCcm = cmbCCM.Text.Trim();
                string strID = cmbID.Text.Trim();

                if (strCcm.Length == 0)
                {
                    MessageBox.Show("请选择铸机号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cmbCCM.Focus();
                    return;
                }

                if (strID.Length == 0)
                {
                    MessageBox.Show("请输入结晶器编号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cmbID.Focus();
                    return;
                }

                string strType = "1";   //板坯结晶器

                string strErr = "";
                ArrayList arry = new ArrayList();

                if (strCcm == "3#连铸机")
                {
                    arry.Add("FrmCLBaseInfoBP.DEV_JJQ_BASE_INFO");
                    arry.Add(strCcm);
                    arry.Add(strID);
                }
                else
                {
                    arry.Add("FrmCLBaseInfoBP_OneTwoCcmNO");
                    arry.Add(strID);
                }
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                            "doSimpleQuery", arry, out strErr);

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("［" + strCCM + "］已存在结晶器［" + strID + "］，不能重复录入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cmbID.Focus();
                    return;
                }

                string strReturn = "";
                strErr = "";
                arry.Clear();
                #region//修改结晶器铜板水箱信息
                CommonClientToServer cctos = new CommonClientToServer();
                #endregion
                strErr = "";
                arry.Clear();
                strReturn = "";
                arry.Add("FrmCLBaseInfoBP.ADD");
                arry.Add(strID);
                arry.Add(strType);
                arry.Add(txtCS.Text.Trim() == "" ? "0" : txtCS.Text.Trim());
                arry.Add(txtTgl.Text.Trim() == "" ? "0" : txtTgl.Text.Trim());
                arry.Add(udtePTime.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(udteBuyTime.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(txtMemo.Text.Trim());
                arry.Add(strCcm);
                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add(txtOutAge.Text.Trim());
                arry.Add(txtInnerAge.Text.Trim());
                arry.Add(txtLeftAge.Text.Trim());
                arry.Add(txtRightAge.Text.Trim());

                //添加铜板对应使用炉数
                arry.Add(txtCS1.Text.Trim());
                arry.Add(txtCS2.Text.Trim());
                arry.Add(txtCS3.Text.Trim());
                arry.Add(txtCS4.Text.Trim());

                strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("新增［" + strCcm + "］结晶器［" + strID + "］失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                FrmCrystallizerManageBP frm = (FrmCrystallizerManageBP)this.Tag;
                frm.proc_GetBaseInfo(strCcm, strID);
                proc_GetID(strCcm);
                MessageBox.Show("新增［" + strCcm + "］结晶器［" + strID + "］成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 结晶器基本信息修改
        /// </summary>
        private void proc_Edit()
        {
            try
            {
                if (cmbID.Items.Count == 0)
                    return;

                string strCcm = cmbCCM.Text.Trim();
                string strID = cmbID.Text.Trim();

                if (strID.Length == 0)
                {
                    MessageBox.Show("请选择需要修改的结晶器编号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cmbID.Focus();
                    return;
                }

                #region

                #endregion
                string strType = "1";   //板坯结晶器

                if (MessageBox.Show("确定要修改［" + strCcm + "］的结晶器［" + strID + "］信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;

                string strErr = "";
                string strReturn = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmCLBaseInfoBP_Edit.select");
                arry.Add(strCcm);
                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("［" + strCcm + "］结晶器［" + strID + "］信息修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                string str1 = "", str2 = "", str3 = "", str4 = "";
                string str5 = "", str6 = "", str7 = "";
                if (ds.Tables[0].Rows.Count > 0)
                {
                    str1 = Convert.ToString(ds.Tables[0].Rows[0]["NOWSTATUS"]);
                    str2 = Convert.ToString(ds.Tables[0].Rows[0]["OUTERCOPPER"]);
                    str3 = Convert.ToString(ds.Tables[0].Rows[0]["INNERCOPPER"]);
                    str4 = Convert.ToString(ds.Tables[0].Rows[0]["LEFTCOPPER"]);
                    str5 = Convert.ToString(ds.Tables[0].Rows[0]["RIGHTCOPPER"]);
                    str6 = Convert.ToString(ds.Tables[0].Rows[0]["OUTERWATER"]);
                    str7 = Convert.ToString(ds.Tables[0].Rows[0]["INNERWATER"]);
                }


                strErr = "";

                #region//修改结晶器铜板水箱信息
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;

                #endregion//修改结晶器铜板水箱信息


                //根据流号获取结晶器编号和周期编号
                ArrayList arryCry = new ArrayList();
                arryCry.Add("FrmJJQCryByCcmsId.Query");
                arryCry.Add(txtPos.Text.Trim());
                DataSet dsCry = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arryCry, out strErr);

                strErr = "";
                arry.Clear();
                cctos.ob = this.ob;
                arry.Add("FrmCLBaseInfoBP.Edit");
                arry.Add(strType);
                arry.Add(strCcm);
                arry.Add(txtCS.Text.Trim() == "" ? "0" : txtCS.Text.Trim());
                arry.Add(txtTgl.Text.Trim() == "" ? "0" : txtTgl.Text.Trim());

                arry.Add(txtOutAge.Text.Trim() == "" ? "0" : txtOutAge.Text.Trim());
                arry.Add(txtInnerAge.Text.Trim() == "" ? "0" : txtInnerAge.Text.Trim());
                arry.Add(txtLeftAge.Text.Trim() == "" ? "0" : txtLeftAge.Text.Trim());
                arry.Add(txtRightAge.Text.Trim() == "" ? "0" : txtRightAge.Text.Trim());

                arry.Add(txtCS1.Text.Trim() == "" ? "0" : txtCS1.Text.Trim());
                arry.Add(txtCS2.Text.Trim() == "" ? "0" : txtCS2.Text.Trim());
                arry.Add(txtCS3.Text.Trim() == "" ? "0" : txtCS3.Text.Trim());
                arry.Add(txtCS4.Text.Trim() == "" ? "0" : txtCS4.Text.Trim());

                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add("");
                arry.Add(udtePTime.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(udteBuyTime.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(txtMemo.Text.Trim());
                arry.Add(strCCM);
                arry.Add(strID);
                strReturn = cctos.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);

                //修改结晶器使用信息
                ArrayList arryU = new ArrayList();
                arryU.Add("FrmJJQ_User_Detail.Edit");
                arryU.Add(txtCS1.Text.Trim() == "" ? "0" : txtCS1.Text.Trim());
                arryU.Add(txtCS2.Text.Trim() == "" ? "0" : txtCS2.Text.Trim());
                arryU.Add(txtCS3.Text.Trim() == "" ? "0" : txtCS3.Text.Trim());
                arryU.Add(txtCS4.Text.Trim() == "" ? "0" : txtCS4.Text.Trim());

                arryU.Add(txtOutAge.Text.Trim() == "" ? "0" : txtOutAge.Text.Trim());
                arryU.Add(txtInnerAge.Text.Trim() == "" ? "0" : txtInnerAge.Text.Trim());
                arryU.Add(txtLeftAge.Text.Trim() == "" ? "0" : txtLeftAge.Text.Trim());
                arryU.Add(txtRightAge.Text.Trim() == "" ? "0" : txtRightAge.Text.Trim());
                arryU.Add(dsCry.Tables[0].Rows.Count > 0 ? dsCry.Tables[0].Rows[0]["CRYSTALLIZERID"].ToString():"");
                arryU.Add(dsCry.Tables[0].Rows.Count > 0 ? dsCry.Tables[0].Rows[0]["CYCID"].ToString():"");

                strReturn = cctos.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arryU, out strErr);

                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strCcm + "］结晶器［" + strID + "］信息修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                FrmCrystallizerManageBP frm = (FrmCrystallizerManageBP)this.Tag;
                frm.proc_GetBaseInfo(strCcm, strID);
                proc_GetID(strCcm);
                MessageBox.Show("［" + strCcm + "］结晶器［" + strID + "］信息修改成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 结晶器基础信息删除
        /// </summary>
        private void proc_Del()
        {
            try
            {
                if (cmbID.Items.Count == 0)
                    return;

                string strCcm = cmbCCM.Text.Trim();
                string strID = cmbID.Text.Trim();
                if (strID.Length == 0)
                {
                    MessageBox.Show("请选择需要删除的结晶器编号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cmbID.Focus();
                    return;
                }

                if (MessageBox.Show("确定要删除［" + strCcm + "］结晶器［" + strID + "］的信息吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                    return;

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmCLBaseInfoBP_Del_Select");
                arry.Add(strCcm);
                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 && ds.Tables[0].Rows.Count > 0))
                {
                    MessageBox.Show("［" + strCcm + "］结晶器［" + strID + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt == 0)
                {
                    MessageBox.Show("［" + strCcm + "］不存在结晶器［" + strID + "］信息，无法删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cmbID.Focus();
                    return;
                }

                iCnt = 0;
                ds = null;
                strErr = "";
                arry.Clear();
                ccs.ob = this.ob;
                arry.Add("FrmCLBaseInfoBP_Del_Select_1");
                arry.Add(strCcm);
                arry.Add(strID);
                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 + "］结晶器［" + strID + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("［" + strCcm + "］结晶器［" + strID + "］存在使用记录，不能删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cmbID.Focus();
                    return;
                }

                iCnt = 0;
                ds = null;
                strErr = "";
                arry.Clear();
                ccs.ob = this.ob;
                arry.Add("FrmCLBaseInfoBP_Del_Select_2");
                arry.Add(strCcm);
                arry.Add(strID);
                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 + "］结晶器［" + strID + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("［" + strCcm + "］结晶器［" + strID + "］存在维修记录，不能删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cmbID.Focus();
                    return;
                }
                strErr = "";
                arry.Clear();
                arry.Add("FrmCLBaseInfoBP_Del.Delect");
                arry.Add(strCcm);
                arry.Add(strID);
                string strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strCcm + "］结晶器［" + strID + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                FrmCrystallizerManageBP frm = (FrmCrystallizerManageBP)this.Tag;
                frm.proc_GetBaseInfo(strCcm, "");
                proc_GetID(strCcm);
                MessageBox.Show("［" + strCcm + "］结晶器［" + strID + "］信息删除成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                return;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private TextBox proc_GetTextBox(string strComboBoxName)
        {
            switch (strComboBoxName)
            {
                case "cbbID1":
                    {
                        return txtCS1;
                    }
                case "cbbID2":
                    {
                        return txtCS2;
                    }
                case "cbbID3":
                    {
                        return txtCS3;
                    }
                case "cbbID4":
                    {
                        return txtCS4;
                    }
                case "cbbID5":
                    {
                        return txtCS5;
                    }
                case "cbbID6":
                    {
                        return txtCS6;
                    }
            }

            return null;
        }

        private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            switch (e.ClickedItem.Name)
            {
                case "ADD":
                    {
                        this.proc_Add();
                        break;
                    }
                case "EDIT":
                    {
                        this.proc_Edit();
                        break;
                    }
                case "DEL":
                    {
                        this.proc_Del();
                        break;
                    }
                case "CLOSE":
                    {
                        this.Close();
                        break;
                    }
                default:
                    break;
            }
        }
        /// <铸机号属性更改时>
        /// 铸机号属性更改时
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cbbCCM_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cmbCCM.Text.Length > 0)
            {
                //proc_GetPluginInfo(cmbCCM.Text, "");
                proc_GetID(cmbCCM.Text);
            }
        }
        /// <结晶器属性更改时>
        /// 结晶器属性更改时
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cbbID_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                proc_GetPluginInfo(cmbCCM.Text.Trim(), cmbID.Text.ToString());

                if (!bOK)
                    return;

                string strCCM = cmbCCM.Text.Trim();
                string strID = cmbID.Text.Trim();

                if (strID.Length == 0)
                    return;

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("cbbID.Select");
                arry.Add(strID);
                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("结晶器［" + strID + "］信息查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

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

                txtCS.Text = Convert.ToString(ds.Tables[0].Rows[0]["CUPRUMCANALTIME"]);
                txtTgl.Text = Convert.ToString(ds.Tables[0].Rows[0]["AGE"]);
                cmbID1.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["ID1"]);
                txtCS1.Text = Convert.ToString(ds.Tables[0].Rows[0]["CS1"]);
                cmbID2.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["ID2"]);
                txtCS2.Text = Convert.ToString(ds.Tables[0].Rows[0]["CS2"]);
                cmbID3.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["ID3"]);
                txtCS3.Text = Convert.ToString(ds.Tables[0].Rows[0]["CS3"]);
                cmbID4.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["ID4"]);
                txtCS4.Text = Convert.ToString(ds.Tables[0].Rows[0]["CS4"]);
                cmbID5.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["ID5"]);
                txtCS5.Text = Convert.ToString(ds.Tables[0].Rows[0]["CS5"]);
                cmbID6.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["ID6"]);
                txtCS6.Text = Convert.ToString(ds.Tables[0].Rows[0]["CS6"]);
                txtStatus.Text = Convert.ToString(ds.Tables[0].Rows[0]["NOWSTATUS"]);
                txtPos.Text = Convert.ToString(ds.Tables[0].Rows[0]["CCM_S_ID"]);
                udtePTime.DateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["CREATIVEDATE"]);
                udteBuyTime.DateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["BUYDATE"]);
                txtMemo.Text = Convert.ToString(ds.Tables[0].Rows[0]["MEMO"]);
                txtOutAge.Text = Convert.ToString(ds.Tables[0].Rows[0]["OUTAGE"]);
                txtInnerAge.Text = Convert.ToString(ds.Tables[0].Rows[0]["INNERAGE"]);
                txtLeftAge.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEFTAGE"]);
                txtRightAge.Text = Convert.ToString(ds.Tables[0].Rows[0]["RIGHTAGE"]);

                txtCS1.Text = Convert.ToString(ds.Tables[0].Rows[0]["OUTTIMES"]);
                txtCS2.Text = Convert.ToString(ds.Tables[0].Rows[0]["INNERTIMES"]);
                txtCS3.Text = Convert.ToString(ds.Tables[0].Rows[0]["LEFTTIMES"]);
                txtCS4.Text = Convert.ToString(ds.Tables[0].Rows[0]["RIGHTTIMES"]);
            }
            catch { }
        }

        private void PlugIn_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                ComboBox cbb = sender as ComboBox;
                if (cbb == null) return;
                if (!(cbb is ComboBox)) return;

                string str = cbb.SelectedValue.ToString();

                if (cbb.SelectedItem != null)
                {
                    DataRowView rowView = (DataRowView)cbb.SelectedItem;
                    str = rowView.Row["ID"].ToString();
                }

                if (str.Length == 0) return;

                string strErr = "";

                ArrayList arry = new ArrayList();
                arry.Add("USETIMES.select");
                arry.Add(str);
                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))
                {
                    return;
                }

                proc_GetTextBox(cbb.Name).Text = Convert.ToString(ds.Tables[0].Rows[0]["USETIMES"]);
            }
            catch { }
        }
    }
}