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

        public string strNo = "", strRHS = "";

        public FrmVTBaseInfo(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 == '.') ||
                (((TextBox)(sender)).Text.Trim().Length == 0 && e.KeyChar == '.'))
            {
                e.Handled = true;
            }
        }

        private void FrmVTBaseInfo_Load(object sender, EventArgs e)
        {
            if (strRHS.Length > 0)
            {
                cbbRHS.Text = strRHS;
                this.cbbCCM_SelectedIndexChanged(this, null);
                if (strNo.Length > 0)
                {
                    cbbID.Text = strNo;
                    bOK = true;
                    this.cbbID_SelectedIndexChanged(this, null);
                }
            }
            else
                bOK = true;
        }
        /// <summary>
        /// 槽车号加载
        /// </summary>
        /// <param name="strRHS"></param>
        private void proc_GetID(string strRHS)
        {
            try
            {
                if (strRHS.Length == 0)
                    return;

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmVTBaseInfo_Query1");
                arry.Add(strRHS);
                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(strRHS);
                    return;
                }

                cbbID.DataSource = ds.Tables[0];
                cbbID.DisplayMember = "TANKCARID";

                if (ds.Tables[0].Rows.Count == 0)
                    proc_ResetControl();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 槽车槽号信息加载
        /// </summary>
        /// <param name="strRHS"></param>
        /// <param name="strID"></param>
        private void proc_GetPluginInfo(string strRHS, string strID)
        {
            try
            {
                if (strRHS.Length == 0)
                    return;

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmVTBaseInfoLoad_Query");
                arry.Add(strRHS);
               
                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(strRHS, strID);
                    return;
                }
                if (ds.Tables[0].Rows.Count > 0)
                {
                    DataRow dr = ds.Tables[0].NewRow();
                    dr["ID"] = "0";
                    dr["PLUGINNO"] = "";
                    ds.Tables[0].Rows.InsertAt(dr, 0);


                    cbbID1.DataSource = ds.Tables[0].DefaultView;
                    cbbID1.ValueMember = "ID";
                    cbbID1.DisplayMember = "PLUGINNO";

                    //cbbID2.DataSource = ds.Tables[0].Copy().DefaultView;
                    //cbbID2.ValueMember = "ID";
                    //cbbID2.DisplayMember = "PLUGINNO";

                    //cbbID3.DataSource = ds.Tables[0].Copy().DefaultView;
                    //cbbID3.ValueMember = "ID";
                    //cbbID3.DisplayMember = "PLUGINNO";
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void proc_ResetControl()
        {
            try
            {
                cbbID.Text = "";
                tbCS.Clear();
                tbStatus.Clear();
                cbbID1.SelectedIndex = -1;
                tbCS1.Clear();
                cbbID2.SelectedIndex = -1;
                tbCS2.Clear();
                cbbID3.SelectedIndex = -1;
                tbCS3.Clear();
                ultraDateTimeEditor1.DateTime = DateTime.Now;
                ultraDateTimeEditor2.DateTime = DateTime.Now;
                tbMemo.Clear();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        /// <summary>
        /// 槽车基础信息增加
        /// </summary>
        private void proc_Add()
        {
            try
            {
                string strRHS = cbbRHS.SelectedIndex < 0 ? "" : cbbRHS.Text.Trim();
                string strID = cbbID.Text.Trim();

                if (strRHS.Length == 0)
                {
                    MessageBox.Show("请选择RH炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cbbRHS.Focus();
                    return;
                }

                cbbID1.SelectedIndex = (cbbID1.SelectedIndex < 0 ? 0 : cbbID1.SelectedIndex);


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

                if (cbbID1.SelectedIndex <-1 )
                {
                    MessageBox.Show("请选择槽号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cbbID2.Focus();
                    return;
                }

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmVTBaseInfo_Query5");
                arry.Add(strRHS);
                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("新增［" + strRHS + "］槽车［" + strID + "］失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                int iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("［" + strRHS + "］已存在槽车［" + strID + "］，不能重复录入！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cbbID.Focus();
                    return;
                }
                string strReturn = "";
                //1
                strErr = "";
                arry.Clear();
                arry.Add("FrmVTBaseInfo_Update.1");
                arry.Add(tbCS1.Text.Trim());
                arry.Add(cbbID1.SelectedValue.ToString());
                ccs.ob = this.ob;
                strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
       
               
                strErr = "";
                arry.Clear();
                arry.Add("FrmVTBaseInfo_ADD.1");
                arry.Add(strID);
                arry.Add(tbCS.Text.Trim() == "" ? "0" : tbCS.Text.Trim());
                arry.Add(ultraDateTimeEditor1.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(ultraDateTimeEditor2.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(tbMemo.Text.Trim());
                arry.Add(strRHS);
                arry.Add(cbbID1.SelectedValue.ToString());
                ccs.ob = this.ob;
                strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("新增［" + strRHS + "］槽车［" + strID + "］失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

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

                string strRHS = cbbRHS.Text.Trim();
                string strID = cbbID.Text.Trim();

                cbbID1.SelectedIndex = (cbbID1.SelectedIndex < 0 ? 0 : cbbID1.SelectedIndex);

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

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

                if (cbbID1.SelectedIndex < -1)
                {
                    MessageBox.Show("请选择槽号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cbbID2.Focus();
                    return;
                }


                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmVTBaseInfo_Query6");
                arry.Add(strRHS);
                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("［" + strRHS + "］槽车［" + strID + "］信息修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                if (ds.Tables[0].Rows.Count == 0)
                {
                    MessageBox.Show("［" + strRHS + "］不存在槽车［" + strID + "］信息，无法修改！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cbbID.Focus();
                    return;
                }

                string str1 = Convert.ToString(ds.Tables[0].Rows[0]["NOWSTATUS"]);
                string str2 = Convert.ToString(ds.Tables[0].Rows[0]["TOPID"]);
                string str3 = Convert.ToString(ds.Tables[0].Rows[0]["MIDDLEID"]);
                string str4 = Convert.ToString(ds.Tables[0].Rows[0]["BOTTOMID"]);

                if (str1 == "1" &&
                    !((str2 == cbbID1.SelectedValue.ToString())))
                {
                    MessageBox.Show("［" + strRHS + "］槽车［" + strID + "］当前处于［上线］状态，不能修改槽号信息！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }
                #region//修改真空槽信息
                string strReturn = "";
                strErr = "";
                arry.Clear();
                arry.Add("FrmVTBaseInfo_Update.1");
                arry.Add(tbCS1.Text.Trim());
                arry.Add(cbbID1.SelectedValue.ToString());
                ccs.ob = this.ob;
                strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);

                #endregion
                strErr = "";
                arry.Clear();
                arry.Add("FrmVTBaseInfo_Update.2");
                arry.Add((tbCS.Text.Trim() == "" ? "0" : tbCS.Text.Trim()));
                arry.Add(cbbID1.SelectedValue.ToString());
                arry.Add(ultraDateTimeEditor1.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(ultraDateTimeEditor2.DateTime.ToString("yyyy-MM-dd"));
                arry.Add(tbMemo.Text.Trim());
                arry.Add(strRHS);
                arry.Add(strID);
                ccs.ob = this.ob;
                strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strRHS + "］槽车［" + strID + "］信息修改失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

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

                string strRHS = cbbRHS.Text.Trim();
                string strID = cbbID.Text.Trim();

                if (strID.Length == 0)
                {
                    MessageBox.Show("请选择需要删除的槽车编号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    cbbID.Focus();
                    return;
                }

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

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmVTBaseInfo_Query7");
                arry.Add(strRHS);
                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("［" + strRHS + "］槽车［" + strID + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

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

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

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

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

                iCnt = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                if (iCnt > 0)
                {
                    MessageBox.Show("［" + strRHS + "］槽车［" + strID + "］存在烘烤记录，不能删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    cbbID.Focus();
                    return;
                }
                string strReturn = "";
                strErr = "";
                arry.Clear();
                ccs.ob = this.ob;
                arry.Add("FrmVTBaseInfo_Del.1");
                arry.Add(strRHS);
                arry.Add(strID);
                strReturn = ccs.NoQueryFunctions("Core.LgMes.Server.Common.ComDBSave", "doSimpleSave", arry, out strErr);
                if (!(strErr == null || strErr == ""))
                {
                    MessageBox.Show("［" + strRHS + "］槽车［" + strID + "］信息删除失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

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

        private TextBox proc_GetTextBox(string strComboBoxName)
        {
            switch (strComboBoxName)
            {
                case "cbbID1":
                    {
                        return tbCS1;
                    }
                case "cbbID2":
                    {
                        return tbCS2;
                    }
                case "cbbID3":
                    {
                        return tbCS3;
                    }
            }

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

        private void cbbCCM_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (cbbRHS.Text.Length > 0)
            {
                proc_GetPluginInfo(cbbRHS.Text, "");
                proc_GetID(cbbRHS.Text);
            }
        }
        /// <summary>
        /// 槽车号事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cbbID_SelectedIndexChanged(object sender, EventArgs e)
        {
            try
            {
                proc_GetPluginInfo(cbbRHS.Text.Trim(), cbbID.Text.ToString());

                if (!bOK)
                    return;

                string strRHS = cbbRHS.Text.Trim();
                string strID = cbbID.Text.Trim();

                if (strID.Length == 0)
                    return;

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmVTBaseInfo_Query3");
                arry.Add(strID);
                arry.Add(strRHS);
                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;

                tbCS.Text = Convert.ToString(ds.Tables[0].Rows[0]["AGE"]);
                cbbID1.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["ID1"]);
                tbCS1.Text = Convert.ToString(ds.Tables[0].Rows[0]["CS1"]);
                tbStatus.Text = Convert.ToString(ds.Tables[0].Rows[0]["NOWSTATUS"]);
                ultraDateTimeEditor1.DateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["CREATIVEDATE"]);
                ultraDateTimeEditor2.DateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["BUYDATE"]);
                tbMemo.Text = Convert.ToString(ds.Tables[0].Rows[0]["MEMO"]);
            }
            catch { }
        }
        /// <summary>
        /// 上中下槽号事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        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("FrmVTBaseInfo_Query4");
                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 { }
        }


    }
}