You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
842 lines
35 KiB
842 lines
35 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Text;
|
|
using System.Windows.Forms;
|
|
using System.ServiceModel;
|
|
using OPCClient;
|
|
using Opc.Ua;
|
|
using System.Net;
|
|
using System.Linq;
|
|
|
|
namespace wcfControlMonitorClient
|
|
{
|
|
/// <summary>
|
|
/// Creator:Richard.liu and Jack.Ma
|
|
/// 设备实时状态显示
|
|
/// </summary>
|
|
public partial class FrmDeviceStatus : Form
|
|
{
|
|
#region 变量定义
|
|
Model.MDevice _device = null;
|
|
int _deviceIndex;
|
|
DBFactory.DBOperator dboMan = CStaticClass.dboM;
|
|
DBFactory.DBOperator dbo = CStaticClass.dbo;
|
|
int count = 0;
|
|
/// <summary>
|
|
/// 设置要显示的设备索引
|
|
/// </summary>
|
|
public int DeviceIndex
|
|
{
|
|
set { _deviceIndex = value; }
|
|
}
|
|
private static FrmDeviceStatus _formInstance;
|
|
|
|
public static FrmDeviceStatus FormInstance
|
|
{
|
|
get
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmDeviceStatus();
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
#endregion
|
|
|
|
#region 构造函数/初始化
|
|
public FrmDeviceStatus()
|
|
{
|
|
InitializeComponent();
|
|
_formInstance = this;
|
|
}
|
|
|
|
private void FrmDeviceStatus_Load(object sender, EventArgs e)
|
|
{
|
|
StringBuilder sql = new StringBuilder();
|
|
|
|
|
|
sql = new StringBuilder();
|
|
sql.Append("SELECT F_DeviceIndex from T_Base_PLC_Ask where F_DeviceIndex=").Append(_deviceIndex);
|
|
DataView dvlane = dbo.ExceSQL(sql.ToString()).Tables[0].DefaultView;
|
|
if (dvlane.Count > 0)
|
|
{
|
|
this.tbAddBarcode.Visible = true;
|
|
this.btresendbarcode.Visible = true;
|
|
|
|
}
|
|
else
|
|
{
|
|
this.tbAddBarcode.Visible = false;
|
|
this.btresendbarcode.Visible = false;
|
|
}
|
|
this.btLogicHaveGoods.Visible = true;
|
|
this.btLogicNoneGoods.Visible = true;
|
|
textBox1.Visible = true;
|
|
textBox2.Visible = false;
|
|
button1.Visible = false;
|
|
label10.Visible = false;
|
|
this.tbAddBarcode.Text = "";
|
|
if (_deviceIndex == 12014 || _deviceIndex == 12011 || _deviceIndex == 12008 || _deviceIndex == 12007)
|
|
{
|
|
button6.Visible = true;
|
|
}
|
|
else { button6.Visible = false; }
|
|
|
|
if (new int[] { 22005, 22006, 29008 }.Contains(_deviceIndex))
|
|
{
|
|
this.lab_AutomaticPlatform.Visible = true;
|
|
this.txt_AutomaticPlatform.Visible = true;
|
|
this.btn_AutomaticPlatform.Visible = true;
|
|
}
|
|
else
|
|
{
|
|
this.lab_AutomaticPlatform.Visible = false;
|
|
this.txt_AutomaticPlatform.Visible = false;
|
|
this.btn_AutomaticPlatform.Visible = false;
|
|
}
|
|
btnRefresh_Click(null, EventArgs.Empty);
|
|
}
|
|
#endregion
|
|
|
|
#region 更新设备状态
|
|
private void btnRefresh_Click(object sender, EventArgs e)
|
|
{
|
|
try
|
|
{
|
|
_device = Model.CGetInfo.GetDeviceInfo(_deviceIndex);
|
|
//20100108
|
|
|
|
if (_device == null)
|
|
{
|
|
MessageBox.Show("您选择的设备在数据库没有记录！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
|
|
}
|
|
|
|
//设备索引
|
|
this.lblDeviceIndex.Value = _device.DeviceIndex;
|
|
//设备名称
|
|
this.lblDeviceName.Text = _device.DeviceName;
|
|
//设备指令索引
|
|
this.lblTaskIndex.Text = _device.TaskNo.ToString();
|
|
DataView dv = dbo.ExceSQL(string.Format("SELECT F_TxtParam, F_NumParam1, F_NumParam2, F_NumParam3, F_NumParam4,F_NumParam5, F_NumParam6 FROM T_Monitor_Task WHERE (F_MonitorIndex = {0})", _device.TaskNo)).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
//条码号
|
|
this.lblBarcode.Text = dv[0]["F_TxtParam"].ToString();
|
|
//目标位置
|
|
|
|
this.lblArrowLocation.Text = _device.ArrowLocation;
|
|
|
|
if (_device.DeviceKind == 1)
|
|
{
|
|
this.lblArrowLocation.Text = string.Format("{0}排{1}列{2}层", dv[0]["F_NumParam4"].ToString(), dv[0]["F_NumParam5"].ToString(), dv[0]["F_NumParam6"].ToString());
|
|
}
|
|
if (_device.DeviceKind == 4)
|
|
{
|
|
this.lblArrowLocation.Text = dv[0]["F_NumParam1"].ToString();
|
|
}
|
|
if ((_device.DeviceKind == 2) || (_device.DeviceKind == 31))
|
|
{
|
|
this.lblArrowLocation.Text = dv[0]["F_NumParam4"].ToString();
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
//20140109
|
|
if (_device.DeviceKind == 2)
|
|
{
|
|
if (_device.RunState == 5 && _device.SplitByte_0 == 1)
|
|
{
|
|
//条码号
|
|
object bcode = dbo.GetSingle(string.Format("SELECT F_PALLETBARCODE FROM T_Base_Device WHERE (F_DeviceIndex = {0})", _device.DeviceIndex));
|
|
if (bcode != null)
|
|
{
|
|
this.lblBarcode.Text = bcode.ToString();
|
|
}
|
|
else
|
|
{
|
|
this.lblBarcode.Text = "";
|
|
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
//条码号
|
|
this.lblBarcode.Text = "";
|
|
}
|
|
if ((_device.DeviceIndex == 12008 || _device.DeviceIndex == 12007 || _device.DeviceIndex == 12014 || _device.DeviceIndex == 12011))
|
|
{
|
|
//this.groupBox1.Visible = true;
|
|
//条码号
|
|
//object bcode = dbo.GetSingle(string.Format("SELECT SN FROM ZH_pallet WHERE (Device = {0})", _device.DeviceIndex));
|
|
//if (bcode != null)
|
|
//{
|
|
// this.groupBox1.Text = bcode.ToString();
|
|
//}
|
|
//else
|
|
//{
|
|
// this.groupBox1.Text = "";
|
|
//}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
//条码号
|
|
this.lblBarcode.Text = "";
|
|
if (_device.DeviceKind == 43)
|
|
{
|
|
//条码号
|
|
object bcode = dbo.GetSingle(string.Format("SELECT F_PALLETBARCODE FROM T_Base_Device WHERE (F_DeviceIndex = {0})", 22005));
|
|
if (bcode != null)
|
|
{
|
|
this.lblBarcode.Text = bcode.ToString();
|
|
}
|
|
else
|
|
{
|
|
this.lblBarcode.Text = "";
|
|
|
|
}
|
|
}
|
|
}
|
|
//目标位置
|
|
|
|
this.lblArrowLocation.Text = "";
|
|
}
|
|
if (_device.DeviceKind == 31)
|
|
{
|
|
|
|
this.lblTaskIndex.Text = GetMonitorTaskIndexFromBarCode(new StringBuilder(_device.Barcode)).ToString();
|
|
this.lblBarcode.Text = _device.Barcode;
|
|
this.lblBarcode.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
this.lblBarcode.Enabled = false;
|
|
}
|
|
if (_device.DeviceKind == 1)
|
|
{
|
|
button2.Visible = true;
|
|
}
|
|
else
|
|
{
|
|
button2.Visible = false;
|
|
}
|
|
DataView dvb = dbo.ExceSQL(string.Format("select * from T_Base_PLC_Ask where F_BindingDevice = {0}", _device.DeviceIndex)).Tables[0].DefaultView;
|
|
if (dvb.Count > 0 && _device.DeviceKind == 2)
|
|
{
|
|
//this.lblBarcode.Text = dvb[0]["F_BarCode"].ToString();
|
|
//------------------------------------------------------获取当前叠盘条码-----------------------------------------------------------------//
|
|
if (Convert.ToInt32(dvb[0]["F_PalletBarcodeReservedLength"]) == 70)
|
|
{
|
|
textBox2.Text = "";
|
|
textBox2.Visible = true;
|
|
label10.Visible = true;
|
|
button1.Visible = true;
|
|
StringBuilder barcode = new StringBuilder();
|
|
int dbbegin = Convert.ToInt32(dbo.GetSingle("select F_DBW2Address from t_base_device where f_deviceindex=" + dvb[0]["F_DeviceIndex"]));
|
|
string s7connection = dbo.GetSingle("select F_S7Connection from t_base_device where f_deviceindex=" + dvb[0]["F_DeviceIndex"]).ToString();
|
|
CCommonOPCClient.Hostname = CommonClassLib.AppSettings.GetValue("HostName");//20090922 devinfo.RemoteIP;
|
|
CCommonOPCClient.ProgID = CommonClassLib.AppSettings.GetValue("OPCProgID");
|
|
CCommonOPCClient.PlcConnectionID = s7connection;//20110216
|
|
Opc.Ua.DataValueCollection dc = new DataValueCollection();
|
|
StringBuilder[] itemnames = new StringBuilder[72];
|
|
for (int i = 0; i < 72; i++)
|
|
{
|
|
itemnames[i] = new StringBuilder("");
|
|
itemnames[i].Append(Model.CGeneralFunction.DBGet).Append(".").Append(Convert.ToString(dbbegin + i)).Append(",b");
|
|
|
|
}
|
|
|
|
dc = CCommonOPCClient.SyncReadAllItemValue(itemnames);
|
|
|
|
int PalletBarcodeLength = Convert.ToInt32(dvb[0]["F_PalletBarcodeLength"]);
|
|
int BarcodeReservedLength = Convert.ToInt32(dvb[0]["F_BarcodeReservedLength"]);
|
|
count = Convert.ToInt32(Convert.ToByte(dc[1].ToString()));
|
|
for (int i = 0; i < 6; i++)
|
|
{
|
|
StringBuilder tempparam = new StringBuilder();
|
|
for (int ii = 0; ii < PalletBarcodeLength; ii++)
|
|
{//周转箱叠箱时PalletBarcodeLength=0和PalletBarcodeReservedLength=0
|
|
tempparam.Append(Convert.ToChar(Convert.ToByte(dc[10 + i * BarcodeReservedLength + ii].ToString())).ToString().ToUpper());//20131106richard
|
|
}
|
|
//if (tempparam.ToString() == incompleteBarcode.ToString())//扫到残码，但是有货物
|
|
//{//自动生成条码“9+dvsp[0]["F_BindingDevice"]+顺序号”
|
|
// //tempparam.Clear();
|
|
// //tempparam.Append(GetErrorBarcode(dcode, devidx, BarcodeLength));
|
|
//}
|
|
if (tempparam.ToString().Trim().Length == PalletBarcodeLength)
|
|
{
|
|
barcode.Append(tempparam);
|
|
}
|
|
|
|
if (i < 5)
|
|
{
|
|
barcode.Append('|');
|
|
}
|
|
textBox2.Text = barcode.ToString().Trim('\0').Trim('|');
|
|
//if ((i == 0) && (barcode.Length == 0))
|
|
//{//托盘垛或者箱垛记录最上面的条码作为记录
|
|
// barcode = tempparam;
|
|
//}
|
|
}
|
|
|
|
|
|
}
|
|
//------------------------------------------------------获取当前叠盘条码-----------------------------------------------------------------//
|
|
|
|
}
|
|
else
|
|
{
|
|
|
|
lblBarcode.Enabled = false;
|
|
}
|
|
|
|
if (new int[] { 22005, 22006, 29008 }.Contains(_device.DeviceIndex))
|
|
{
|
|
DataView dvTemp = dbo.ExceSQL($"SELECT * FROM T_Base_Device WHERE F_DeviceIndex = {_device.DeviceIndex}").Tables[0].DefaultView;
|
|
if (dvTemp.Count > 0)
|
|
{
|
|
this.txt_AutomaticPlatform.Text = dvTemp[0]["F_PALLETBARCODE"].ToString();
|
|
}
|
|
}
|
|
//设备状态
|
|
switch (_device.RunState)
|
|
{
|
|
case 0:
|
|
lblDeviceStatus.Text = "空闲";
|
|
break;
|
|
case 1:
|
|
lblDeviceStatus.Text = "运行";
|
|
break;
|
|
case 2:
|
|
lblDeviceStatus.Text = "故障";
|
|
break;
|
|
case 3:
|
|
lblDeviceStatus.Text = "离线";
|
|
break;
|
|
case 4:
|
|
lblDeviceStatus.Text = "停用";
|
|
break;
|
|
case 5://20090920
|
|
lblDeviceStatus.Text = "动作完成";
|
|
break;
|
|
}
|
|
|
|
|
|
if (_device.ErrorCode >= 30)
|
|
{
|
|
Model.MError err = Model.CGetInfo.GetErrorInfo(Convert.ToInt32(_device.DeviceKind.ToString() + _device.ErrorCode.ToString()));
|
|
if (err != null)
|
|
{
|
|
this.lblErrorName.Text = err.ErrorName + "，代码：" + _device.ErrorCode.ToString();
|
|
}
|
|
else
|
|
{
|
|
this.lblErrorName.Text = _device.ErrorCode.ToString();
|
|
}
|
|
}
|
|
else
|
|
{
|
|
this.lblErrorName.Text = "";
|
|
}
|
|
if (_device.DeviceKind == 7 || _device.DeviceKind == 42)
|
|
{
|
|
dv = dbo.ExceSQL(string.Format("SELECT F_BarCode ,F_ErrorBarcodeSN FROM T_Base_PLC_Ask WHERE (F_DeviceIndex = {0})", _device.DeviceIndex)).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
this.lblBarcode.Text = dv[0][0].ToString();
|
|
Model.MError err = Model.CGetInfo.GetErrorInfo(Convert.ToInt32(_device.DeviceKind.ToString() + dv[0][1].ToString()));
|
|
if (err != null)
|
|
{
|
|
this.lblErrorName.Text = err.ErrorName + "，代码：" + dv[0][1].ToString();
|
|
}
|
|
else
|
|
{
|
|
this.lblErrorName.Text = "";
|
|
}
|
|
}
|
|
//lblErrorName.Text = "";
|
|
lblDeviceStatus.Text = "";
|
|
}
|
|
if ((_device.DeviceKind == 1) || (_device.DeviceKind == 4))
|
|
{
|
|
this.lblNowX.Text = _device.XCoor.ToString();
|
|
this.lblNowY.Text = _device.YCoor.ToString();
|
|
}
|
|
else
|
|
{
|
|
this.lblNowX.Text = "";
|
|
this.lblNowY.Text = "";
|
|
}
|
|
//是否逻辑有物
|
|
dv = dbo.ExceSQL("select F_DeviceIndex from T_Base_Device where F_HaveGoods >0 and F_DeviceIndex =" + this._deviceIndex).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
lblGoods.Text = "逻辑有物";
|
|
}
|
|
else
|
|
{
|
|
lblGoods.Text = "逻辑无物";
|
|
}
|
|
//dv = dbo.ExceSQL("select F_DeviceIndex from T_NeedLock where F_DeviceIndex =" + this._deviceIndex).Tables[0].DefaultView;
|
|
//if (dv.Count > 0)
|
|
//{
|
|
// button5.Visible = true;
|
|
//}
|
|
//else
|
|
//{
|
|
// button5.Visible = false;
|
|
//}
|
|
//20120417被预约的调度任务
|
|
dv = dbo.ExceSQL(string.Format("SELECT F_MonitorIndex FROM T_Monitor_Task WHERE (F_ManageTaskKindIndex = 4 and F_MonitorIndex={0})", Convert.ToInt32(this.lblTaskIndex.Text))).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
lblManTask.Text = "手工任务";
|
|
}
|
|
else
|
|
{
|
|
dv = dbo.ExceSQL(string.Format("select F_ManTaskReserve from T_Base_Device where F_ManTaskReserve>0 and F_DeviceIndex ={0}", this._deviceIndex)).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
int mankind = Convert.ToInt32(dv[0][0].ToString().Substring(0, 1));
|
|
int fid = Convert.ToInt32(dv[0][0].ToString().Substring(1));
|
|
lblManTask.Text = fid.ToString();
|
|
dv = dbo.ExceSQL(string.Format("SELECT F_TxtParam FROM T_Monitor_Task WHERE (F_ManageTaskKindIndex = {0} and F_ManageTaskIndex={1})", mankind, fid)).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
lblBarcode.Text = dv[0][0].ToString(); ;
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
lblManTask.Text = "";
|
|
}
|
|
}
|
|
//dv = dbo.ExceSQL(string.Format("SELECT F_DeviceIndex,F_PalletBarcodeLength,F_BarCode FROM T_Base_PLC_Ask WHERE (F_Askkind = 4 OR F_Askkind = 14) AND (F_BindingDevice = {0})", this._deviceIndex)).Tables[0].DefaultView;
|
|
//if (dv.Count > 0)
|
|
//{
|
|
|
|
// gbBarcode.Visible = true;
|
|
// CStaticClass.WcfControl.BeginGetReadedAndReportedBarcode(this._deviceIndex, new AsyncCallback(CallbackGetReadedAndReportedBarcode), null);
|
|
//}
|
|
//else
|
|
//{
|
|
// gbBarcode.Visible = false;
|
|
//}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MessageBox.Show(ex.Message);
|
|
}
|
|
}
|
|
void CallbackGetReadedAndReportedBarcode(IAsyncResult ar)
|
|
{
|
|
string errortext, ReadedBarcode, ReportedBarcode;
|
|
try
|
|
{
|
|
bool rt = CStaticClass.WcfControl.EndGetReadedAndReportedBarcode(out ReadedBarcode, out ReportedBarcode, out errortext, ar);
|
|
if (rt == true)
|
|
{
|
|
this.BeginInvoke(new MethodInvoker(delegate ()
|
|
{
|
|
//lblReadedBarcode.Text = ReadedBarcode;
|
|
//lblReportedBarcode.Text = ReportedBarcode;
|
|
}));
|
|
}
|
|
else
|
|
{
|
|
this.BeginInvoke(new MethodInvoker(delegate ()
|
|
{
|
|
//lblReadedBarcode.Text ="";
|
|
//lblReportedBarcode.Text = "";
|
|
}));
|
|
if (errortext != "")
|
|
{
|
|
MessageBox.Show(errortext, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
}
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 关闭窗体
|
|
private void btnClose_Click(object sender, EventArgs e)
|
|
{
|
|
this.Close();
|
|
}
|
|
#endregion
|
|
|
|
|
|
|
|
private void button2_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("您确认要把设备：" + this._deviceIndex + "设成逻辑无物吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
|
|
CStaticClass.WcfControl.BeginSetLogicHaveGoods(false, this._deviceIndex, new AsyncCallback(SetLogicHaveGoodsCallBack), null);
|
|
btnRefresh_Click(sender, e);
|
|
}
|
|
|
|
private void button1_Click(object sender, EventArgs e)
|
|
{
|
|
|
|
if (MessageBox.Show("您确认要把设备：" + this._deviceIndex + "设成逻辑有物吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
CStaticClass.WcfControl.BeginSetLogicHaveGoods(true, this._deviceIndex, new AsyncCallback(SetLogicHaveGoodsCallBack), null);
|
|
btnRefresh_Click(sender, e);
|
|
}
|
|
|
|
private void button3_Click(object sender, EventArgs e)
|
|
{
|
|
|
|
if (MessageBox.Show("您确认要向设备：" + this._deviceIndex + "发送【完成应答】吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
string errtext = string.Empty;
|
|
|
|
CStaticClass.WcfControl.BeginSendDeviceReset(this._deviceIndex, 2, new AsyncCallback(SendDeviceResetCallBack), 2);
|
|
|
|
}
|
|
|
|
void SetLogicHaveGoodsCallBack(IAsyncResult ar)
|
|
{
|
|
string errtext = string.Empty;
|
|
|
|
if (CStaticClass.WcfControl.EndSetLogicHaveGoods(out errtext, ar) == false)
|
|
{
|
|
MessageBox.Show(errtext, "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
}
|
|
void SendDeviceResetCallBack(IAsyncResult ar)
|
|
{
|
|
string errtext = string.Empty;
|
|
|
|
if (CStaticClass.WcfControl.EndSendDeviceReset(out errtext, ar) == false)
|
|
{
|
|
MessageBox.Show(errtext, "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
else
|
|
{
|
|
if (ar.AsyncState != null)
|
|
{
|
|
//if ((((int)ar.AsyncState) == 4)&&(_device.DeviceKind==4))
|
|
//{
|
|
// CStaticClass.WcfControl.BeginSendDeviceReset(_deviceIndex, 2, new AsyncCallback(SendDeviceResetCallBack), null);
|
|
//}
|
|
if (((int)ar.AsyncState) == 2)
|
|
{
|
|
CStaticClass.WcfControl.BeginSendDeviceReset(_deviceIndex, 0, new AsyncCallback(SendDeviceResetCallBack), null);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
private void lblDeviceIndex_ValueChanged(object sender, EventArgs e)
|
|
{
|
|
_deviceIndex = int.Parse(lblDeviceIndex.Value.ToString());
|
|
}
|
|
|
|
private void FrmDeviceStatus_FormClosing(object sender, FormClosingEventArgs e)
|
|
{
|
|
_formInstance = null;
|
|
}
|
|
|
|
private void button4_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("您确认要向设备：" + this._deviceIndex + "发送【设备复位】吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
string errtext = string.Empty;
|
|
CStaticClass.WcfControl.BeginSendDeviceReset(this._deviceIndex, 4, new AsyncCallback(SendDeviceResetCallBack), 4);
|
|
|
|
}
|
|
int GetMonitorTaskIndexFromBarCode(StringBuilder BarCode)
|
|
{//20110216
|
|
string bc = BarCode.ToString();
|
|
|
|
DataView dv = dbo.ExceSQL(string.Format("SELECT T_Monitor_Task.F_MonitorIndex FROM T_Base_Device,T_Monitor_Task WHERE T_Base_Device.F_DeviceIndex = T_Monitor_Task.F_DeviceIndex and ((T_Base_Device.F_DeviceKindIndex = 13) OR (T_Base_Device.F_DeviceKindIndex = 31)) and (F_TxtParam = '{0}') and F_Status>0 order by F_MonitorIndex asc", bc)).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
return Convert.ToInt32(dv[0]["F_MonitorIndex"]);
|
|
}
|
|
else
|
|
{
|
|
return -1;
|
|
}
|
|
|
|
}
|
|
|
|
|
|
void WriteDBDataCallback(IAsyncResult ar)
|
|
{
|
|
string errtext;
|
|
|
|
if (CStaticClass.WcfControl.EndWriteDBData(out errtext, ar) == false)
|
|
{
|
|
MessageBox.Show("操作提示", errtext, MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
|
|
}
|
|
void WriteBarcodeCallback(IAsyncResult ar)
|
|
{
|
|
|
|
|
|
if (CStaticClass.WcfControl.EndWriteBarcode(ar) == false)
|
|
{
|
|
MessageBox.Show("操作提示", "补码失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
else
|
|
{
|
|
MessageBox.Show("操作提示", "补码成功", MessageBoxButtons.OK, MessageBoxIcon.None);
|
|
}
|
|
|
|
}
|
|
void WriteGroupBarcodeCallback(IAsyncResult ar)
|
|
{
|
|
|
|
|
|
if (CStaticClass.WcfControl.EndWriteGroupBarcode(ar) == false)
|
|
{
|
|
MessageBox.Show("操作提示", "修改失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
else
|
|
{
|
|
MessageBox.Show("操作提示", "修改成功", MessageBoxButtons.OK, MessageBoxIcon.None);
|
|
}
|
|
|
|
}
|
|
void ClearFireAlarmCallback(IAsyncResult ar)
|
|
{
|
|
|
|
|
|
if (CStaticClass.WcfControl.EndClearFireAlarm(ar) == false)
|
|
{
|
|
MessageBox.Show("操作提示", "火警暂停解除失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
else
|
|
{
|
|
MessageBox.Show("操作提示", "火警暂停解除成功", MessageBoxButtons.OK, MessageBoxIcon.None);
|
|
}
|
|
|
|
}
|
|
void ClearPalletCallback(IAsyncResult ar)
|
|
{
|
|
|
|
|
|
if (CStaticClass.WcfControl.EndClearPallet(ar) == false)
|
|
{
|
|
MessageBox.Show("操作提示", "串盘锁定解除失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
else
|
|
{
|
|
MessageBox.Show("操作提示", "串盘锁定解除成功", MessageBoxButtons.OK, MessageBoxIcon.None);
|
|
}
|
|
|
|
}
|
|
private void lblBarcode_KeyPress(object sender, KeyPressEventArgs e)
|
|
{
|
|
if (e.KeyChar == '\r')
|
|
{
|
|
if (MessageBox.Show("您确认要修改设备【" + this._deviceIndex + "】记录的【条码】吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
CStaticClass.WcfControl.BeginWriteDBData(_deviceIndex, "DB2", lblBarcode.Text, new AsyncCallback(WriteDBDataCallback), null);
|
|
}
|
|
}
|
|
|
|
private void btCancelDoubleFork_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("您确认要取消【" + this._deviceIndex + "】的双叉关联吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
StringBuilder sql = new StringBuilder();
|
|
sql.Append("update T_Base_PLC_Ask set F_TaskIndex=0,F_Remark='' where F_DeviceIndex=").Append(_deviceIndex);
|
|
dbo.ExecuteSql(sql.ToString());
|
|
|
|
}
|
|
|
|
private void tableLayoutPanel1_Paint(object sender, PaintEventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
private void btresendbarcode_Click(object sender, EventArgs e)
|
|
{
|
|
int barcodelenth = Convert.ToInt32(dbo.GetSingle("select F_PalletBarcodeLength from T_Base_PLC_Ask where F_DeviceIndex=" + _deviceIndex));
|
|
//if (this.tbAddBarcode.Text.Length != barcodelenth)
|
|
//{
|
|
// MessageBox.Show("操作提示", "条码位数不正确", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
// return;
|
|
//}
|
|
|
|
//OPCClient.CSendDeviceOrder sdo = new OPCClient.CSendDeviceOrder();
|
|
//sdo.WriteBarcode(_deviceIndex, tbAddBarcode.Text);
|
|
string d = Dns.GetHostEntry("localhost").HostName;
|
|
if (CStaticClass.UserID != "")
|
|
{
|
|
d = Dns.GetHostEntry("localhost").HostName + dbo.GetSingle("select f_username from T_Base_Users where f_userid='" + CStaticClass.UserID + "'").ToString();
|
|
}
|
|
CStaticClass.WcfControl.BeginWriteBarcode(d, _deviceIndex, string.Format("{0}", tbAddBarcode.Text), new AsyncCallback(WriteBarcodeCallback), null);
|
|
MessageBox.Show("补码成功！");
|
|
|
|
|
|
}
|
|
|
|
private void button1_Click_1(object sender, EventArgs e)
|
|
{
|
|
int barcodelenth = Convert.ToInt32(dbo.GetSingle("select F_PalletBarcodeLength from T_Base_PLC_Ask where F_BindingDevice=" + _deviceIndex));
|
|
string GroupBarcode = textBox2.Text.ToString().Trim('|');
|
|
string[] barcode = GroupBarcode.Split('|');
|
|
if (count != barcode.GetLength(0))
|
|
{
|
|
MessageBox.Show("操作提示", "电气设备记录数量与补入条码数量不一致", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
}
|
|
if (barcode.GetLength(0) < 1)
|
|
{
|
|
MessageBox.Show("操作提示", "条码位数不正确", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
}
|
|
for (int i = 0; i < barcode.GetLength(0); i++)
|
|
{
|
|
if (barcode[i].Length != barcodelenth)
|
|
{
|
|
MessageBox.Show("操作提示", "条码位数不正确", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
}
|
|
}
|
|
string d = Dns.GetHostEntry("localhost").HostName;
|
|
if (CStaticClass.UserID != "")
|
|
{
|
|
d = Dns.GetHostEntry("localhost").HostName + dbo.GetSingle("select f_username from T_Base_Users where f_userid='" + CStaticClass.UserID + "'").ToString();
|
|
}
|
|
CStaticClass.WcfControl.BeginWriteGroupBarcode(d, _deviceIndex, GroupBarcode, new AsyncCallback(WriteGroupBarcodeCallback), null);
|
|
|
|
|
|
}
|
|
|
|
private void button2_Click_1(object sender, EventArgs e)
|
|
{
|
|
if (Convert.ToInt32(dbo.GetSingle("select F_AlarmLock from T_Base_Device where F_DeviceIndex=" + _deviceIndex)) == 0)
|
|
{
|
|
MessageBox.Show("操作提示", "当前设备没有被火警暂停，无需解除！", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
}
|
|
string lane = "18" + _deviceIndex.ToString().Substring(2, 3);
|
|
if (Convert.ToInt32(dbo.GetSingle("select count(0) from t_manage_task with(nolock) where fstartdevice=" + Convert.ToInt32(lane) + " and fenddevice like '19%'")) != 0)
|
|
{
|
|
MessageBox.Show("操作提示", "当前巷道仍有未完成的火警任务，不能解除锁定！", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
}
|
|
if (MessageBox.Show("您确认要清除【" + this._deviceIndex + "】设备的火警暂停吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
string d = Dns.GetHostEntry("localhost").HostName;
|
|
if (CStaticClass.UserID != "")
|
|
{
|
|
string purview = dbo.GetSingle("select f_purview from T_Base_Users where f_userid='" + CStaticClass.UserID + "'").ToString();
|
|
if (purview.IndexOf("MIAltMonitor") < 0)
|
|
{
|
|
MessageBox.Show("操作提示", "该账号没有权限！", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
}
|
|
d = Dns.GetHostEntry("localhost").HostName + dbo.GetSingle("select f_username from T_Base_Users where f_userid='" + CStaticClass.UserID + "'").ToString();
|
|
}
|
|
CStaticClass.WcfControl.BeginClearFireAlarm(d, _deviceIndex, new AsyncCallback(ClearFireAlarmCallback), null);
|
|
}
|
|
|
|
private void button5_Click(object sender, EventArgs e)
|
|
{
|
|
//if (Convert.ToInt32(dbo.GetSingle("select F_Lock from T_NeedLock where F_DeviceIndex=" + _deviceIndex)) == 0)
|
|
//{
|
|
// MessageBox.Show("操作提示", "当前设备没有被串盘锁定，无需解除！", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
// return;
|
|
//}
|
|
|
|
if (MessageBox.Show("您确认要清除【" + this._deviceIndex + "】设备的串盘锁定吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
string d = Dns.GetHostEntry("localhost").HostName;
|
|
if (CStaticClass.UserID != "")
|
|
{
|
|
string purview = dbo.GetSingle("select f_purview from T_Base_Users where f_userid='" + CStaticClass.UserID + "'").ToString();
|
|
if (purview.IndexOf("MIAltMonitor") < 0)
|
|
{
|
|
MessageBox.Show("操作提示", "该账号没有权限！", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
return;
|
|
}
|
|
d = Dns.GetHostEntry("localhost").HostName + dbo.GetSingle("select f_username from T_Base_Users where f_userid='" + CStaticClass.UserID + "'").ToString();
|
|
}
|
|
CStaticClass.WcfControl.BeginClearPallet(d, _deviceIndex, new AsyncCallback(ClearPalletCallback), null);
|
|
|
|
}
|
|
|
|
private void button6_Click(object sender, EventArgs e)
|
|
{
|
|
//强制满垛
|
|
string dtime = DateTime.Now.ToString("u");//20101028
|
|
StringBuilder sql = new StringBuilder();
|
|
string strSQL = string.Format("update ZH_pallet set GOODS_COUNT=1 where Device={0}", _deviceIndex);
|
|
int bl = dboMan.ExecuteSql(strSQL);
|
|
if (bl == 1)
|
|
{
|
|
DataView dvTemp = dbo.ExceSQL($" select * from ZH_pallet where Device = {_deviceIndex} ").Tables[0].DefaultView;
|
|
if (dvTemp.Count > 0)
|
|
{
|
|
//满垛任务申请
|
|
dtime = dtime.Substring(0, dtime.Length - 1);
|
|
sql.Remove(0, sql.Length);
|
|
sql.AppendLine(" INSERT INTO IO_CONTROL_APPLY ( ");
|
|
sql.AppendLine(" CONTROL_APPLY_TYPE, WAREHOUSE_CODE,DEVICE_CODE");//任务类型、库房编码、位置（起始站台）
|
|
sql.AppendLine(" , STOCK_BARCODE, APPLY_TASK_STATUS, CREATE_TIME ");//托盘条码、申请任务转态、申请时间
|
|
sql.AppendLine(" ,CONTROL_APPLY_REMARK,CONTROL_APPLY_PARAMETER ");//备注、纸箱条码信息/ASN码
|
|
sql.AppendLine(" ) VALUES ( ");
|
|
sql.AppendLine($" 14 , 1 , '{_deviceIndex}'");// 14 满垛申请
|
|
sql.AppendLine($" ,'{dvTemp[0]["STOCK_BARCODE"]}',0, '{dtime}'");
|
|
sql.AppendLine($" ,'','{dvTemp[0]["SN"]}'");
|
|
sql.AppendLine(" ) ");
|
|
dboMan.ExceSQL(sql.ToString());
|
|
}
|
|
MessageBox.Show("操作提示", "强制满垛一下发！", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
|
|
}
|
|
else
|
|
{
|
|
MessageBox.Show("没有码垛任务！！");
|
|
}
|
|
|
|
}
|
|
|
|
public static implicit operator FrmDeviceStatus(FrmDeviceMS v)
|
|
{
|
|
throw new NotImplementedException();
|
|
}
|
|
|
|
private void Btn_AutomaticPlatform_Click(object sender, EventArgs e)
|
|
{
|
|
string strSQL = $"update T_Base_Device set F_PALLETBARCODE = '{this.txt_AutomaticPlatform.Text}' where F_DeviceIndex = {_deviceIndex} ";
|
|
dboMan.ExecuteSql(strSQL);
|
|
}
|
|
}
|
|
}
|