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); } } /// /// 获取滑板、耐材、透气蕊厂家 /// 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; } /// /// 转炉号加载 /// 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 { } } /// /// 根据炉座号 显示在生产的炉号 /// /// /// 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(); } /// /// 钢包修改 /// 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); } /// /// 钢包配送 /// 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 = ""; } } /// /// 窗体定位 /// /// /// 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); } /// /// 绑定所有在用钢包信息 /// 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); } } } /// /// 钢包到达 /// 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 { } } /// /// 钢包到达 /// /// /// 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(); } } /// /// 功能:钢包取消操作 /// 说明:Add 2011-09-15 by WYB /// /// /// 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位数!"); } } } } }