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