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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using CoreFS.CA06;
//using Core.LgMes.Client.LgIntegrationQuery;
using Core.Mes.Client.Common;

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class frmPotAbnormal : FrmLgDevFunctions
    {
        private string strLadLeid = "";

        public frmPotAbnormal(OpeBase oba)
        {
            InitializeComponent();
             ob = oba;
            this.proc_Init();
        }

        private void frmPotAbnormal_Load(object sender, EventArgs e)
        {
            this.proc_Query();
        }

        private void proc_Init()
        {
            try
            {
                lblHeatNo.Text = lblPotNo.Text = "";
            }
            catch { }

            try
            {
               //par = new CallingMessage();
            }
            catch { }
        }

        private void GetPotNoInfo()
        {
            try
            {

                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("GBYCComfirmPot_Load");
                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("钢包信息获取失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }


                this.ultraDataSource1.Rows.Clear();
                if (ds == null) return;

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    try
                    {
                        DataRow dr = ds.Tables[0].Rows[i];
                        this.ultraDataSource1.Rows.Add(new object[]{
																   dr["钢包号"].ToString(),
																   dr["等级"].ToString(),
                                                                   dr["包况"].ToString(),
                                                                   dr["使用次数"].ToString(),
                                                                   dr["发送时间"].ToString(),
                                                                   dr["发送编号"].ToString()
															   });
                    }
                    catch { }
                }

                if (ds.Tables[0].Rows.Count > 0)
                {
                    this.ultraGrid1.ActiveRow = this.ultraGrid1.Rows[0];
                    this.ultraGrid1.Rows[0].Selected = true;
                }

                ultraGrid1_AfterRowActivate(null, null);
            }
            catch { }
        }

        private void GetHeatNoInfo()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("GBYCComfirmHeaNo_Load");
                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("炉号信息获取失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                this.ultraGrid2.DataSource = ds.Tables[0];

                if (ds.Tables[0].Rows.Count > 0)
                {
                    this.ultraGrid2.ActiveRow = this.ultraGrid2.Rows[0];
                    this.ultraGrid2.Rows[0].Selected = true;
                }

                ultraGrid2_AfterRowActivate(null, null);
            }
            catch { }
        }

        private void proc_Query()
        {
            GetPotNoInfo();
            GetHeatNoInfo();
        }

        private void proc_OK()
        {
            try
            {
                if (ultraGrid1.Rows.Count == 0)
                {
                    MessageBox.Show("还未发送钢包，无法确认！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }

                if (ultraGrid1.ActiveRow == null)
                {
                    MessageBox.Show("请选择待确认钢包号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }

                if (ultraGrid2.Rows.Count == 0)
                {
                    MessageBox.Show("没有可以确认的炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }

                if (ultraGrid2.ActiveRow == null)
                {
                    MessageBox.Show("请选择待确认炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }

                if (MessageBox.Show("确定执行确认操作？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
                {
                    return;
                }

                string strSqlID = "YCComfirm_Pot";
                object[] sArgs = new object[4];
                sArgs[0] = Convert.ToString(ultraGrid2.ActiveRow.Cells["炉号"].Value);    //炉号
                sArgs[1] = Convert.ToString(ultraGrid1.ActiveRow.Cells["钢包号"].Value);  //钢包号
                sArgs[2] = Convert.ToString(ultraGrid1.ActiveRow.Cells["发送编号"].Value);//发送编号
                sArgs[3] = this.UserInfo.GetUserName(); ;//操作人

                string strError = "";
                CommonClientToServer ccTs = new CommonClientToServer();
                ccTs.ob = ob;
                string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
                                                "ExecProcWithCollParam", strSqlID, sArgs, out strError);


                ArrayList arryS = new ArrayList();
                arryS.Add("PotBaseInfoByLED_Update");
                arryS.Add(sArgs[0]);
                arryS.Add(sArgs[0]);
                arryS.Add(sArgs[0]);
                arryS.Add(sArgs[1]);

                string strErrorTow = "";
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                DataSet ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBSave",
                                            "doSimpleSave", arryS, out strErrorTow);

                if (strError != "" && strErrorTow !="")
                {
                    MessageBox.Show("钢包确认失败！\r\n" + strError, "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    return;
                }

                MessageBox.Show("钢包确认操作成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                PotNoLVL();
                this.Close();
            }
            catch { }
        }


        private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow row = ultraGrid2.ActiveRow;

                if (row == null)
                {
                    lblHeatNo.Text = "";
                    return;
                }

                lblHeatNo.Text = Convert.ToString(row.Cells["炉号"].Value);
                strLadLeid = Convert.ToString(row.Cells["POTNO"].Value);
            }
            catch { }
        }

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

        public void PotNoLVL()
        {
           

            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]["STOPPOTTIME"].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);
                }
            }

        }
        

        private void btnRefresh_Click(object sender, EventArgs e)
        {
            proc_Query();

            FrmCasAffirm frmPotSA = new FrmCasAffirm(ob);
            frmPotSA.ShowDialog(this);
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            try
            {
                UltraGridRow row = ultraGrid1.ActiveRow;
                
                if (row == null)
                {
                    lblPotNo.Text = "";
                    lblPotNo.Tag = null;
                    return;
                }

                lblPotNo.Text = Convert.ToString(row.Cells["钢包号"].Value);
                lblPotNo.Tag = Convert.ToString(row.Cells["发送编号"].Value);
            }
            catch { }
        }


    }
}