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位数!");
}
}
}
}
}