XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/钢包/frmPotSendArrivall.cs

using System;
using System.Data;
using System.Drawing;
using System.Collections;
using System.Windows.Forms;
using CoreFS.CA06;
using Core.Mes.Client.Common;
using Core.LgMes.Client.Comm;

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class frmPotSendArrivall : FrmLgDevFunctions
    {
        public DataSet _ds;
        public string strHeatprocessNo = "";
        private string strInitID = "";
        public string strOneHeaN0 = "",strTwoHeaNo="";
        string strLadLeid = "";
        public frmPotSendArrivall(string strInitID, OpeBase oba)
        {
            InitializeComponent();
            ob = oba;
            this.strInitID = strInitID;
        }

        private void frmPotSendArrivall_Load(object sender, EventArgs e)
        {
            POrientation();

            if (this._ds == null) return;

            _ds.Tables[0].DefaultView.RowFilter = "STATUS='待用' or STATUS='保温'";
            cmbNoLadle.Items.Clear();
            for (int i = 0; i < _ds.Tables[0].DefaultView.Count; i++)
            {
                cmbNoLadle.Items.Add(_ds.Tables[0].DefaultView[i]["LADLEID"].ToString());
            }
            if (cmbNoLadle.Text != strInitID)
            {
                cmbNoLadle.SelectedIndex = 0;
            }
            GetCVTHeatno();
            LadLeId_Staus();
            proc_GetBK();
            proc_GetLVL();
            proc_GetBKDZ();
            proc_GetHBFT();
            cmbPOTSTATUS.SelectedIndex = 0;
            cmbLVL.SelectedIndex = 0;
            cmbCvtpos.SelectedIndex = 0;
            cmbBKDZ.SelectedIndex = 0;
            cmbHBFT.SelectedIndex = 0;
        }

        /// <钢包包况>
        /// 钢包包况
        /// </钢包包况>
        private void proc_GetBK()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("LoadGetBK.Query");
                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_GetBK();
                    return;
                }
                cmbPOTSTATUS.Items.Clear();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)  //遍历所有行的信息 
                {
                    cmbPOTSTATUS.Items.Add(ds.Tables[0].Rows[i]["basename"]);
                    
                }
                cmbPOTSTATUS.SelectedIndex = -1;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <钢包等级>
        /// 钢包等级
        /// </钢包等级>
        private void proc_GetLVL()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("LoadGetLVL.Query");
                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_GetBK();
                    return;
                }
                cmbLVL.Items.Clear();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)  //遍历所有行的信息 
                {
                    cmbLVL.Items.Add(ds.Tables[0].Rows[i]["basename"]);
                }

                cmbLVL.SelectedIndex = -1;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <钢包等级>
        ///  包口掉转
        /// </钢包等级>
        private void proc_GetBKDZ()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("LoadGetBKDZ.Query");
                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_GetBKDZ();
                    return;
                }

                this.cmbBKDZ.DataSource = ds.Tables[0].DefaultView;
                this.cmbBKDZ.DisplayMember = "BASENAME";
                this.cmbBKDZ.ValueMember = "BASECODE";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <钢包等级>
        ///  滑板厂家
        /// </钢包等级>
        private void proc_GetHBFT()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("LoadGetHBFT.Query");
                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_GetHBFT();
                    return;
                }

                this.cmbHBFT.DataSource = ds.Tables[0];
                this.cmbHBFT.DisplayMember = "BASENAME";
                this.cmbHBFT.ValueMember = "BASECODE";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        /// <summary>
        /// 获取滑板、耐材、透气蕊厂家
        /// </summary>
        private DataTable GetFactory(string strBaseCode)
        {
            DataTable dtFactory = null;
            try
            {
                ArrayList ar = new ArrayList();
                ar.Add(strBaseCode);
                ar.Add("");
                ar.Add("order by BASENAME");
                DataSet ds = QueryArray("Core.LgMes.Server.LgDeviceManager.LadleManager", "GetFactory", new object[] { ar });
                if (ds.Tables[0].Rows.Count > 0)
                {
                    dtFactory = ds.Tables[0];
                }
            }
            catch { }
            return dtFactory;
        }

        /// <summary>
        /// 转炉号加载
        /// </summary>
        private void GetCVTHeatno()
        {
            try
            {
                //this.txtCVT1.Text = "";
                //this.txtCVT2.Text = "";
               

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("frmsendpot_Query1");
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
                if (strErr == "")
                {
                    if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
                    {
                        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                        {
                            string v_LH = "";
                            string v_POS = ds.Tables[0].Rows[i]["objectid"].ToString().Substring(0, 1);
                            string v_POSID = ds.Tables[0].Rows[i]["objectpos"].ToString().Substring(3, (int)OBJLEN.nDevCode);
                            if (v_POS == "C")
                            {
                                v_LH = (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(5, (int)OBJLEN.nHeatNo));
                                strHeatprocessNo = ds.Tables[0].Rows[i]["objectid"].ToString();
                                if (v_POSID == "01")
                                    this.txtCVT1.Text = v_LH;
                                if (v_POSID == "02")
                                    this.txtCVT2.Text = v_LH;

                            }
                        }
                    }
                }

                this.radcvt1.Checked = true;
                if (this.txtCVT1.Text.Trim().Length > 0) return;

                if (this.txtCVT2.Text.Trim().Length > 0)
                {
                    this.radcvt2.Checked = true;
                    return;
                }
               
            }
            catch { }
        }

        /// <summary>
        /// 根据炉座号 显示在生产的炉号
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void cmbCvtpos_ValueChanged(object sender, EventArgs e)
        {
            //if (this.cmbCvtpos.Text == "1")
            //{
            //    this.txtCVT1.Text = strOneHeaN0;
            //}
            //else
            //    this.txtCVT1.Text = strTwoHeaNo;
        }

        private void btnOK_Click(object sender, EventArgs e)
        {
            this.PotUpdate();
            this.proc_OK();
        }

        /// <summary>
        /// 钢包修改
        /// </summary>
        private void PotUpdate()
        {
            string strErr = "";
            string msg = "";
            string[] strParams = new string[3] { cmbNoLadle.Text, cmbLVL.Text, cmbPOTSTATUS.Text };

            ArrayList arry = new ArrayList();
            arry.Add("UpdatePort.Query");
            //arry.Add(cmbLVL.Text);
            arry.Add(cmbPOTSTATUS.Text);
            arry.Add(cmbNoLadle.Text);

            CommonClientToServer cctos = new CommonClientToServer();
            cctos.ob = this.ob;
            DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                        "doSimpleSave", arry, out strErr);
        }

        /// <summary>
        /// 钢包配送
        /// </summary>
        private void proc_OK()
        {
            if (this.cmbNoLadle.Text.Trim().Length == 0)
            {
                MessageBox.Show("请选择钢包号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            string cvtheatno = "";
            if (this.radcvt1.Checked) cvtheatno = txtCVT1.Text;
            if (this.radcvt2.Checked) cvtheatno = txtCVT2.Text;
            if (cvtheatno == "") return;

            string strError = "";

            string strErr = "";
            ArrayList arry = new ArrayList();
            arry.Add("frmsendpot_Query2");
            CommonClientToServer ccs = new CommonClientToServer();
            ccs.ob = this.ob;
            arry.Add(this.cmbNoLadle.Text);
            DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
            if (!(strError == "" && ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0))
            {
                this.labShow.ForeColor = Color.Red;
                this.labShow.Text = this.cmbNoLadle.Text.Trim() + "号钢包发送失败！";
                Application.DoEvents();
                System.Threading.Thread.Sleep(1000);
                this.labShow.Text = "";
                return;
            }

            string strStatus = Convert.ToString(ds.Tables[0].Rows[0]["STATUS"].ToString().Trim());

            if (strStatus != "待用" && strStatus != "保温")
            {
                this.labShow.ForeColor = Color.Red;
                this.labShow.Text = this.cmbNoLadle.Text.Trim() + "号钢包当前状态为［" + strStatus + "］，不能发送！";
                Application.DoEvents();
                System.Threading.Thread.Sleep(1000);
                this.labShow.Text = "";
                return;
            }

            int iTimes = Convert.ToInt32(ds.Tables[0].Rows[0]["SLEEKTIMES"]);

            string strDo = "0";
            if (iTimes >= 3)
            {
                DialogResult dr = MessageBox.Show("［" + this.cmbNoLadle.Text.Trim() + "］号钢包当前滑板次数已经到达［" + iTimes.ToString() + "］次。\r\n"
                    + "点击按钮［是］系统将滑板次数清零并发送钢包；\r\n"
                    + "点击按钮［否］系统以当前次数加一并发送钢包；\r\n"
                    + "点击按钮［取消］将不发送当前钢包。", "提示", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);

                if (dr == DialogResult.Cancel) return;
                if (dr == DialogResult.Yes)
                    strDo = "1";
                else if (dr == DialogResult.No)
                    strDo = "0";
            }

            strError = "";
            string isaddtop = "";
            if (this.checkBox1.Checked == true)
            {
                isaddtop = "C";
            }
            else
            {
                isaddtop = "N";
            }
            string zxtempt = this.txtZX.Text.Trim();
            string rctempt = this.txtRC.Text.Trim();
            string[] strParams = new string[9] { cmbNoLadle.Text, cvtheatno, strDo,cvtheatno.Substring(2,1).ToString() ,cmbBKDZ.Value.ToString(),cmbHBFT.Value.ToString(),isaddtop,zxtempt,rctempt };
            string Mse = "";
            ProcedureZ("Core.LgMes.Server.DEV.Methods.DEVPublicMethods", "procedure", new object[] { "STL_DEV_Info.STL_GBILSend", strParams }, ob, out strError, out Mse);

            if (Convert.ToInt32(strError) > 0)
            {
                this.labShow.ForeColor = Color.Green;
                this.labShow.Text = this.cmbNoLadle.Text.Trim() + "号钢包发送成功！";
                Application.DoEvents();
                System.Threading.Thread.Sleep(800);
                FrmPotMgt frm = new FrmPotMgt();
                frm.Tag = this.Tag;
                frm.Getpotbasedata();
                this.Close();
            }
            else
            {
                this.labShow.ForeColor = Color.Red;
                this.labShow.Text = this.cmbNoLadle.Text.Trim() + strError;
                Application.DoEvents();
                System.Threading.Thread.Sleep(1000);
                this.labShow.Text = "";
            }
        }


        /// <summary>
        /// 窗体定位
        /// </summary>
        /// <param name="strOpe"></param>
        /// <returns></returns>
        public void POrientation()
        {
            int x = (int)(Screen.PrimaryScreen.WorkingArea.Height);

            int y = (int)(Screen.PrimaryScreen.WorkingArea.Width);

            int m = (y - 500) / 2;

            int n = (x - 500) / 2;

            this.Location = new Point(m, n);
        }

        /// <summary>
        /// 绑定所有在用钢包信息
        /// </summary>
        public void LadLeId_Staus()
        {
            string strErr = "";
            ArrayList arry = new ArrayList();
            arry.Add("LadLeidStatus.Query");

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

            dsPA.Clear();

            if (strErr == "" && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow Dr in ds.Tables[0].Rows)
                {
                    DataRow dr1 = dsPA.Tables[0].NewRow();
                    dr1["Select"] = Dr["flag"].ToString() == "1" ? true : false;
                    dr1["LADLEID"] = Dr["LADLEID"].ToString();
                    dr1["STATUS"] = Dr["STATUS"].ToString();
                    dr1["NOWPOSITION"] = Dr["NOWPOSITION"].ToString();
                    dsPA.Tables[0].Rows.Add(dr1);
                }
            }

        }

        /// <summary>
        /// 钢包到达
        /// </summary>
        private void proc_Arrivall(string strErr, string msg)
        {
            string strPot = "";
            try
            {
                if (Convert.ToInt32(strErr) > 0)
                {
                    this.labArrivall.ForeColor = Color.Green;                
                    this.labArrivall.Text = "钢包到达设置成功！";
                    Application.DoEvents();
                    System.Threading.Thread.Sleep(800);
                    this.Close();
                }
                else
                {
                    this.labArrivall.ForeColor = Color.Red;
                    this.labArrivall.Text = this.cmbNoLadle.Text.Trim() + msg;
                    Application.DoEvents();
                    System.Threading.Thread.Sleep(1000);
                    this.labArrivall.Text = "";
                }
            }
            catch { }
        }

        /// <summary>
        /// 钢包到达
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnArrival_Click(object sender, EventArgs e)
        {
            
          
            string strErr = "";
            string msg = "";

            for (int i = 0; i < this.uGrdArrivall.Rows.Count; i++)
            {
                if (this.uGrdArrivall.Rows[i].Cells["Select"].Text == "True")
                {

                    strLadLeid = this.uGrdArrivall.Rows[i].Cells["LADLEID"].Value.ToString();

                    string[] strParams = new string[1] { strLadLeid };

                     ProcedureZ("Core.LgMes.Server.DEV.Methods.DEVPublicMethods", "procedure", new object[]
                                        { "STL_DEV_Info.STL_GBdaoda_Info", strParams }, ob, out strErr, out msg);

                    
                }
            }

            proc_Arrivall(strErr, msg);
        }

        private void btnCan_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void cmbNoLadle_ValueChanged(object sender, EventArgs e)
        {
            string strErr = "";
            ArrayList arry = new ArrayList();
            arry.Add("GetLastPlanSteel.Query");
            arry.Add(cmbNoLadle.Text);
            arry.Add(cmbNoLadle.Text);

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

            if (strErr == "" && ds.Tables[0].Rows.Count > 0)
            {
                this.lblDSPlaySteel.ForeColor = Color.Red;
                this.lblDSPlaySteel.Text = ds.Tables[0].Rows[0][0].ToString();
            }
        }

        /// <summary>
        /// 功能：钢包取消操作
        /// 说明：Add 2011-09-15 by WYB
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnCancel_Click(object sender, EventArgs e)
        {
            for (int i = 0; i < this.uGrdArrivall.Rows.Count; i++)
            {
                if (this.uGrdArrivall.Rows[i].Cells["Select"].Text == "True")
                {

                    strLadLeid = this.uGrdArrivall.Rows[i].Cells["LADLEID"].Value.ToString();
                }
            }


            string strErr = "";

            //钢包状态修改
            ArrayList arryUp = new ArrayList();
            arryUp.Add("UpdateGBStatus");
            arryUp.Add(strLadLeid);

            CommonClientToServer cctosPL = new CommonClientToServer();
            cctosPL.ob = this.ob;
            DataSet dsUP = cctosPL.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                        "doSimpleSave", arryUp, out strErr);

            //钢包使用信息查询
            ArrayList arryU = new ArrayList();
            arryU.Add("CasISConfirm.Query");
            arryU.Add(strLadLeid);

            CommonClientToServer cctos = new CommonClientToServer();
            cctos.ob = this.ob;
            DataSet dsUser = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                        "doSimpleQuery", arryU, out strErr);

            //钢包发送信息记录查询
            ArrayList arryS = new ArrayList();
            arryS.Add("CasIsToolSendConfrim.Query");
            arryS.Add(strLadLeid);

            DataSet dsSend = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery",
                                        "doSimpleQuery", arryS, out strErr);



            if (strErr == "" && dsUser.Tables[0].Rows.Count > 0 && dsSend.Tables[0].Rows.Count >0 )
            {
                if (dsUser.Tables[0].Rows[0]["CASOKTIME"].ToString() == "" && dsSend.Tables[0].Rows[0]["RECEIVETIME"].ToString() == "")
                {
                    //钢包使用信息删除
                    ArrayList arryUD = new ArrayList();
                    arryUD.Add("GBUserDeTail_Del");
                    arryUD.Add(strLadLeid);
                    arryUD.Add(dsUser.Tables[0].Rows[0]["CYCID"].ToString());

                    DataSet dsUD = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                                "doSimpleSave", arryUD, out strErr);

                    //钢包发送信息删除
                    ArrayList arrySD = new ArrayList();
                    arrySD.Add("GBToolSendDTeail_Del");
                    arrySD.Add(strLadLeid);
                    arrySD.Add(dsSend.Tables[0].Rows[0]["SENDID"].ToString());


                    DataSet dsSD = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                                "doSimpleSave", arrySD, out strErr);
                }
            }

            LadLeId_Staus();
        }

        private void tempt_KeyPress(object sender, KeyPressEventArgs e)
        {            
            if (e.KeyChar != '\b')//这是允许输入退格键
            {
                if ((e.KeyChar < '0') || (e.KeyChar > '9'))//这是允许输入0-9数字
                {
                    e.Handled = true;                  
                    MessageBox.Show("请输入数字！\r\n总位数不超过4位数！");
                }
            }
        }


      
    }
}