ZhangQi/SCLS
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
SCLS/SSWCS_JXDL(2019)/ControlSystem/FrmModifyManage.cs

670 lines
29 KiB
C#
Raw Permalink Normal View History

首次上传代码
2025-05-19 09:45:29 +08:00
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DBFactory;
using System.Net.Sockets;
using System.Threading;
using ICommLayer;
using CommLayerFactory;
using Microsoft.VisualBasic;
namespace ControlSystem
{
/// <summary>
/// Creator:Richard.liu
/// <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
/// </summary>
public partial class FrmModifyManage : Form
{
string _manstatus= " F_Status<>-1 ";
private static FrmModifyManage _formInstance;
public static FrmModifyManage FormInstance
{
get
{
if (_formInstance == null)
{
_formInstance = new FrmModifyManage();
}
return _formInstance;
}
set { _formInstance = value; }
}
Model.MDevice devinfo;
DBOperator dbo = CStaticClass.dbo;
DBOperator dboM = CStaticClass.dboM;
public FrmModifyManage()
{
InitializeComponent();
_formInstance = this;
}
private void rbmanAll_CheckedChanged(object sender, EventArgs e)
{
RadioButton rb = (RadioButton)sender;
if (rb.Checked == true)
{
_manstatus = " F_Status<>-1 ";
}
TSMrefresh_Click(sender, e);
}
private void TSMrefresh_Click(object sender, EventArgs e)
{
CStaticClass.RealRefresh = true;
this.dgvManager.DataSource = dbo.ExceSQL("select * from V_Manage_Task where " + _manstatus).Tables[0].DefaultView;
}
private void rbmanRun_CheckedChanged(object sender, EventArgs e)
{
if (rbmanRun.Checked == true)
{
_manstatus = " F_Status>=1 ";
}
TSMrefresh_Click(sender, e);
}
private void rbmanWait_CheckedChanged(object sender, EventArgs e)
{
RadioButton rb = (RadioButton)sender;
if (rb.Checked == true)
{
_manstatus = " F_Status=0 ";
}
TSMrefresh_Click(sender, e);
}
private void button1_Click(object sender, EventArgs e)
{
if (this.textBox1.Text.Trim().Length == 0) return;
int index = 0;
bool isint = int.TryParse(this.textBox1.Text.Trim(), out index);
if (this.comboBox1.Text == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
//20091016
_manstatus = " <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> like'%" + this.textBox1.Text.Trim() + "%' ";
}
if (this.comboBox1.Text == "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>")
{
if(isint==false)
{
//MessageBox.Show("<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>֣<EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʾ<EFBFBD><CABE>", MessageBoxButtons.OK, MessageBoxIcon.Error);
textBox1.Text = string.Empty;
return;
}
_manstatus = " <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>='" + this.textBox1.Text.Trim() + "' ";
}
TSMrefresh_Click(sender, e);
}
private void button2_Click(object sender, EventArgs e)
{
_manstatus = " F_Status<>-1 ";
TSMrefresh_Click(sender, e);
}
private void dgvManager_DataSourceChanged(object sender, EventArgs e)
{
dgvManager.Columns["F_Status"].Visible = false;
}
private void cmManager_Opening(object sender, CancelEventArgs e)
{
if (this.dgvManager.CurrentRow == null)
{
TSMmanagerOK.Visible = false;
//TSMrefresh.Visible = false;
TSManager.Visible = false;
toolStripSeparator1.Visible = false;
//TSMmanagerDisassemble.Visible = false;
toolStripMenuItem1.Visible = false;
toolStripSeparator2.Visible = false;
return;
}
if (Convert.ToInt32(this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value) > 0)
{
TSMmanagerOK.Visible = true;
TSManager.Visible = true;
toolStripSeparator1.Visible = true;
toolStripSeparator2.Visible = true;
//TSMmanagerDisassemble.Visible = true;
toolStripMenuItem1.Visible = true;
TSManager.Text = "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͣ<EFBFBD>" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString() +
"<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString();
}
}
private void TSMmanagerOK_Click(object sender, EventArgs e)
{
try
{
char[] cc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] split = TSManager.Text.Split(cc);
if ((split[1] == "") || (split[2] == ""))
{
return;
}
char[] scc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] strsplit = split[1].Split(scc);
int mti = 0;
int fid = Convert.ToInt32(split[2]);
if (strsplit[0] == "") return;
switch (strsplit[0])
{
case "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>":
mti = 1;
break;
case "<22>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD>":
mti = 2;
break;
case "<22><>ʱ<EFBFBD><CAB1><EFBFBD><EFBFBD>":
mti = 3;
break;
case "<22>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>":
mti = 4;
break;
}
string cap = strsplit[0];
string hw = "";
if (this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD><D5B5><EFBFBD>λ"].Value.ToString() != "-")
{
hw = ",<2C>յ<EFBFBD><D5B5><EFBFBD>λ:" + this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD><D5B5><EFBFBD>λ"].Value.ToString();
}
//20100108
if (MessageBox.Show("<22><>ȷ<EFBFBD>ϱ<EFBFBD><CFB1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>룺<EFBFBD><EBA3BA>" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString()+"<22><><EFBFBD><EFBFBD>" + cap + split[2] + "<22>Ѿ<EFBFBD><D1BE><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˵<EFBFBD><CBB5>յ<EFBFBD><D5B5>豸<EFBFBD><E8B1B8>" + this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD>"].Value.ToString() + hw + "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʾ<EFBFBD><CABE>", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
CGetState cgs = new CGetState();
dbo.ExceSQL("update T_Monitor_Task set F_STATUS=-1 where F_ManageTaskKindIndex=" + mti + " and F_ManageTaskIndex=" + fid + " and F_STATUS=0");
DataView dv = dbo.ExceSQL("SELECT F_ManageTaskKindIndex, F_ManageTaskIndex,F_DeviceIndex,F_MonitorIndex,F_Status,F_DeviceCommandIndex " +
",F_NumParam2,F_NumParam5,F_TxtParam FROM T_Monitor_Task Where F_ManageTaskIndex=" + fid + " and F_ManageTaskKindIndex= " +
mti).Tables[0].DefaultView;
if (dv.Count > 0)
{
string sss = "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:" + fid.ToString();
//20100108
CommonClassLib.CCarryConvert.WriteDarkCasket("<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>룺" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString(), sss);
for (int i = 0; i < dv.Count; i++)
{
if (Convert.ToInt32(dv[i]["F_DeviceIndex"]) == 1001)
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), Model.CGeneralFunction.TASKFINISH);
//1 <09><><EFBFBD>ϳ<EFBFBD><CFB3><EFBFBD>;2 <09><><EFBFBD><EFBFBD><EFBFBD>̻<EFBFBD><CCBB><EFBFBD>;3<><33><EFBFBD><EFBFBD><EFBFBD>̻<EFBFBD><CCBB><EFBFBD>
if (Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 1)
{
DataTable tableAGVGate = dbo.ExceSQL("SELECT F_AGVGateDeviceIndex FROM T_BASE_AGV_GATE WHERE F_ADDRESS = " + Convert.ToInt32(dv[i]["F_NumParam5"]) + "").Tables[0];
if (tableAGVGate.Rows.Count > 0)
{
dbo.ExecuteSql("UPDATE T_BASE_DEVICE SET F_PALLETBARCODE='" + dv[i]["F_TxtParam"] + "',F_HAVEGOODS = 1 WHERE F_DEVICEINDEX = " + Convert.ToInt32(tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"]) + "");
}
}
if ((Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 2) || (Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 3))
{
DataTable tableAGVGate = dbo.ExceSQL("SELECT F_AGVGateDeviceIndex FROM T_BASE_AGV_GATE WHERE F_ADDRESS = " + Convert.ToInt32(dv[i]["F_NumParam2"]) + "").Tables[0];
if (tableAGVGate.Rows.Count > 0)
{
if (mti == 1)
{
//20090817<31><37><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ
dboM.ExecuteSql("UPDATE T_ITEMDEVICE SET devicestatus ='0' WHERE devicecode = '" + tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"] + "'");
}
dbo.ExecuteSql("UPDATE T_BASE_DEVICE SET F_PALLETBARCODE='-',F_HAVEGOODS = 0 WHERE F_DEVICEINDEX = " + Convert.ToInt32(tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"]) + "");
}
}
}
else
{
if (Convert.ToInt32(dv[i]["F_Status"]) >= 1)
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), 1);
}
else
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), Model.CGeneralFunction.TASKFINISH);
}
}
}
}
else
{
if (mti == 1)
{
int startdevice= Convert.ToInt32(this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD>"].Value);
int enddevice = Convert.ToInt32(this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD>"].Value);
if(enddevice==18007||enddevice==12049||enddevice==12054)
{
//<2F><>ʾ<EFBFBD><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͻ<EFBFBD>
// dboM.ExceSQL("update IO_Control set Control_STATUS=" + Model.CGeneralFunction.TASKPACKFINISH + " where Control_ID=" + fid);
}
else
if(startdevice==32080&&enddevice==32080)
{
//dboM.ExceSQL("update IO_Control set Control_STATUS=" + Model.CGeneralFunction.TASKUNPACKFINISH + " where Control_ID=" + fid);
}
else
{
dboM.ExceSQL("update IO_Control set Control_STATUS=" + Model.CGeneralFunction.TASKFINISH + " where Control_ID=" + fid);
}
}
//<2F><>д<EFBFBD><D0B4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
cgs.ReturnManageInfo(fid, mti, cap, true);
}
this.dgvManager.DataSource = dbo.ExceSQL("select * from V_Manage_Task where " + _manstatus).Tables[0].DefaultView;
}
catch (Exception ex)
{
//throw ex;
if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message) < 0)
{
FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message, true);
}
}
}
private void TSMmanagerDisassemble_Click(object sender, EventArgs e)
{
try
{
char[] cc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] split = TSManager.Text.Split(cc);
if ((split[1] == "") || (split[2] == ""))
{
return;
}
char[] scc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] strsplit = split[1].Split(scc);
int mti = 0;
int fid = Convert.ToInt32(split[2]);
if (strsplit[0] == "") return;
switch (strsplit[0])
{
case "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>":
mti = 1;
break;
case "<22>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD>":
mti = 2;
break;
case "<22><>ʱ<EFBFBD><CAB1><EFBFBD><EFBFBD>":
mti = 3;
break;
case "<22>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>":
mti = 4;
break;
}
if (mti == 1)
{
dbo.ExceSQL("update T_Manage_Task set FIntoStepOK='0' where FID=" + fid + " and FIntoStepOK='-' ");
}
}
catch (Exception ex)
{
//throw ex;
if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("<22>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD>ֵ<EFBFBD><D6B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message) < 0)
{
FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "<22>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD>ֵ<EFBFBD><D6B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message, true);
}
}
}
private void FrmModifyManage_Load(object sender, EventArgs e)
{
rbmanRun_CheckedChanged(sender, e);
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
//ɾ<><C9BE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>900
try
{
char[] cc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] split = TSManager.Text.Split(cc);
if ((split[1] == "") || (split[2] == ""))
{
return;
}
char[] scc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] strsplit = split[1].Split(scc);
int mti = 0;
int fid = Convert.ToInt32(split[2]);
if (strsplit[0] == "") return;
switch (strsplit[0])
{
case "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>":
mti = 1;
break;
case "<22>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD>":
mti = 2;
break;
case "<22><>ʱ<EFBFBD><CAB1><EFBFBD><EFBFBD>":
mti = 3;
break;
case "<22>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>":
mti = 4;
break;
}
string hw = "";
if (this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>λ"].Value.ToString() != "-")
{
hw = ",<2C><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>λ:" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>λ"].Value.ToString();
}
string cap = strsplit[0];
if (MessageBox.Show("<22><>ȷ<EFBFBD>ϱ<EFBFBD><CFB1><EFBFBD><EFBFBD><EFBFBD><EFBFBD>룺<EFBFBD><EBA3BA>" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString() + "<22><><EFBFBD><EFBFBD>" + cap + split[2] + "<22>Ѿ<EFBFBD><D1BE><EFBFBD>ȡ<EFBFBD><C8A1><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˹<EFBFBD><CBB9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˻ص<CBBB><D8B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>豸<EFBFBD><E8B1B8>" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD>"].Value.ToString() + hw + "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʾ<EFBFBD><CABE>", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
CGetState cgs = new CGetState();
//20090902
dbo.ExceSQL("update T_Manage_Task set FExceptionNO=" + Model.CGeneralFunction.TASKDELETE + " where (F_ManageTaskKindIndex = " + mti + ") AND (FID = " + fid + ")");
dbo.ExceSQL("update T_Monitor_Task set F_STATUS=-1 where F_ManageTaskKindIndex=" + mti + " and F_ManageTaskIndex=" + fid + " and F_STATUS=0");
DataView dv = dbo.ExceSQL("SELECT F_ManageTaskKindIndex, F_ManageTaskIndex,F_DeviceIndex,F_MonitorIndex,F_Status,F_DeviceCommandIndex " +
",F_NumParam2,F_NumParam5,F_TxtParam FROM T_Monitor_Task Where F_ManageTaskIndex=" + fid + " and F_ManageTaskKindIndex= " +
mti).Tables[0].DefaultView;
if (dv.Count > 0)
{
string sss = "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:" + fid.ToString();
//20100108
CommonClassLib.CCarryConvert.WriteDarkCasket("<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD>ɾ<EFBFBD><C9BE><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>룺" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString(), sss);
for (int i = 0; i < dv.Count; i++)
{
if (Convert.ToInt32(dv[i]["F_DeviceIndex"]) == 1001)
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), Model.CGeneralFunction.TASKDELETE);
//1 <09><><EFBFBD>ϳ<EFBFBD><CFB3><EFBFBD>;2 <09><><EFBFBD><EFBFBD><EFBFBD>̻<EFBFBD><CCBB><EFBFBD>;3<><33><EFBFBD><EFBFBD><EFBFBD>̻<EFBFBD><CCBB><EFBFBD>
if ((Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 2) || (Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 3))
{
DataTable tableAGVGate = dbo.ExceSQL("SELECT F_AGVGateDeviceIndex FROM T_BASE_AGV_GATE WHERE F_ADDRESS = " + Convert.ToInt32(dv[i]["F_NumParam2"]) + "").Tables[0];
if (tableAGVGate.Rows.Count > 0)
{
dbo.ExecuteSql("UPDATE T_BASE_DEVICE SET F_PALLETBARCODE='" + dv[i]["F_TxtParam"] + "',F_HAVEGOODS = 1 WHERE F_DEVICEINDEX = " + Convert.ToInt32(tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"]) + "");
}
}
}
else
{
if (Convert.ToInt32(dv[i]["F_Status"]) >= 1)
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), 1);
}
else
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), Model.CGeneralFunction.TASKDELETE);
}
}
}
}
else
{//20091107
if (this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD>"].Value.ToString() == "2240")
{
dbo.ExceSQL("update T_Base_Device set F_CreateLock='0' where F_DeviceIndex=" + this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD>"].Value);
}
if (mti == 1)
{
dboM.ExceSQL("update IO_Control set Control_STATUS=" + Model.CGeneralFunction.TASKDELETE + " where Control_ID=" + fid);
}
//<2F><>д<EFBFBD><D0B4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
cgs.ReturnManageInfo(fid, mti, cap, false);
}
this.dgvManager.DataSource = dbo.ExceSQL("select * from V_Manage_Task where " + _manstatus).Tables[0].DefaultView;
}
catch (Exception ex)
{
//throw ex;
if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message) < 0)
{
FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message, true);
}
}
}
int GetDeviceKindIdx(int devIdx)
{
try
{
devinfo = Model.CGetInfo.GetDeviceInfo(devIdx);
return devinfo.DeviceKind;
}
catch (Exception ex)
{
throw ex;
}
}
int GetManageTaskIndexfromMonitor(int monitorIdx)
{
DataView dv = dbo.ExceSQL("SELECT F_ManageTaskIndex FROM T_Monitor_Task WHERE (F_MonitorIndex = " + monitorIdx + ")").Tables[0].DefaultView;
if (dv.Count > 0)
{
return Convert.ToInt32(dv[0]["F_ManageTaskIndex"]);
}
else
{
return -1;
}
}
int GetManageTaskKindIndexFromMonitor(int monitorIdx)
{
DataView dv = dbo.ExceSQL("SELECT F_ManageTaskKindIndex FROM T_Monitor_Task WHERE (F_MonitorIndex = " + monitorIdx + ")").Tables[0].DefaultView;
if (dv.Count > 0)
{
return Convert.ToInt32(dv[0]["F_ManageTaskKindIndex"]);
}
else
{
return -1;
}
}
int GetDeviceOrderFromMonitor(int MonitorIndex)
{
try
{
string sql = "select F_DeviceCommandIndex from T_Monitor_Task where (F_DeviceCommandIndex IS NOT NULL) and F_MonitorIndex=" + MonitorIndex;
DataView dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
if (dv.Count > 0)
{
return Convert.ToInt32(dv[0]["F_DeviceCommandIndex"]);
}
else
{
return -1;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void dgvManager_CellMouseDown(object sender, DataGridViewCellMouseEventArgs e)
{
if ((e.RowIndex >= 0) && (e.Button == MouseButtons.Right) && (e.ColumnIndex>=0))
{
dgvManager.ClearSelection();
dgvManager.Rows[e.RowIndex].Selected = true;
dgvManager.CurrentCell = dgvManager.Rows[e.RowIndex].Cells[e.ColumnIndex];
}
}
private void TSMIMANAGEEXCEPTION_Click(object sender, EventArgs e)
{
try
{
char[] cc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] split = TSManager.Text.Split(cc);
if ((split[1] == "") || (split[2] == ""))
{
return;
}
char[] scc = new char[1] { '<EFBFBD><EFBFBD>' };
string[] strsplit = split[1].Split(scc);
int mti = 0;
int fid = Convert.ToInt32(split[2]);
if (strsplit[0] == "") return;
switch (strsplit[0])
{
case "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>":
mti = 1;
break;
case "<22>Զ<EFBFBD><D4B6><EFBFBD><EFBFBD><EFBFBD>":
mti = 2;
break;
case "<22><>ʱ<EFBFBD><CAB1><EFBFBD><EFBFBD>":
mti = 3;
break;
case "<22>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD>":
mti = 4;
break;
}
string cap = strsplit[0];
string hw = "";
if (this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD><D5B5><EFBFBD>λ"].Value.ToString() != "-")
{
hw = ",<2C>յ<EFBFBD><D5B5><EFBFBD>λ:" + this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD><D5B5><EFBFBD>λ"].Value.ToString();
}
//20100108
if (MessageBox.Show("<22><>ȷ<EFBFBD>Ͻ<EFBFBD><CFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>룺<EFBFBD><EBA3BA>" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString() + "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>쳣<EFBFBD><ECB3A3><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʾ<EFBFBD><CABE>", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
{
return;
}
CGetState cgs = new CGetState();
dbo.ExceSQL("update T_Manage_Task set FExceptionNO=" + Model.CGeneralFunction.TASKABEND + ",FERRORCODE= '<27>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD>쳣<EFBFBD><ECB3A3><EFBFBD><EFBFBD>' where (F_ManageTaskKindIndex = " + mti + ") AND (FID = " + fid + ")");
dbo.ExceSQL("update T_Monitor_Task set F_STATUS=-1 where F_ManageTaskKindIndex=" + mti + " and F_ManageTaskIndex=" + fid + " and F_STATUS=0");
DataView dv = dbo.ExceSQL("SELECT F_ManageTaskKindIndex, F_ManageTaskIndex,F_DeviceIndex,F_MonitorIndex,F_Status,F_DeviceCommandIndex " +
",F_NumParam2,F_NumParam5,F_TxtParam FROM T_Monitor_Task Where F_ManageTaskIndex=" + fid + " and F_ManageTaskKindIndex= " +
mti).Tables[0].DefaultView;
if (dv.Count > 0)
{
string sss = "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:" + fid.ToString();
//20100108
CommonClassLib.CCarryConvert.WriteDarkCasket("<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD>쳣<EFBFBD><ECB3A3><EFBFBD><EFBFBD>", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>룺" + this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>"].Value.ToString(), sss);
for (int i = 0; i < dv.Count; i++)
{
if (Convert.ToInt32(dv[i]["F_DeviceIndex"]) == 1001)
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), Model.CGeneralFunction.TASKFINISH);
//1 <09><><EFBFBD>ϳ<EFBFBD><CFB3><EFBFBD>;2 <09><><EFBFBD><EFBFBD><EFBFBD>̻<EFBFBD><CCBB><EFBFBD>;3<><33><EFBFBD><EFBFBD><EFBFBD>̻<EFBFBD><CCBB><EFBFBD>
if (Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 1)
{
DataTable tableAGVGate = dbo.ExceSQL("SELECT F_AGVGateDeviceIndex FROM T_BASE_AGV_GATE WHERE F_ADDRESS = " + Convert.ToInt32(dv[i]["F_NumParam5"]) + "").Tables[0];
if (tableAGVGate.Rows.Count > 0)
{
dbo.ExecuteSql("UPDATE T_BASE_DEVICE SET F_PALLETBARCODE='" + dv[i]["F_TxtParam"] + "',F_HAVEGOODS = 1 WHERE F_DEVICEINDEX = " + Convert.ToInt32(tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"]) + "");
}
}
if ((Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 2) || (Convert.ToInt32(dv[i]["F_DeviceCommandIndex"]) == 3))
{
DataTable tableAGVGate = dbo.ExceSQL("SELECT F_AGVGateDeviceIndex FROM T_BASE_AGV_GATE WHERE F_ADDRESS = " + Convert.ToInt32(dv[i]["F_NumParam2"]) + "").Tables[0];
if (tableAGVGate.Rows.Count > 0)
{
if (mti == 1)
{
//20090817<31><37><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ
dboM.ExecuteSql("UPDATE T_ITEMDEVICE SET devicestatus ='0' WHERE devicecode = '" + tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"] + "'");
}
dbo.ExecuteSql("UPDATE T_BASE_DEVICE SET F_PALLETBARCODE='-',F_HAVEGOODS = 0 WHERE F_DEVICEINDEX = " + Convert.ToInt32(tableAGVGate.Rows[0]["F_AGVGateDeviceIndex"]) + "");
}
}
}
else
{
if (Convert.ToInt32(dv[i]["F_Status"]) >= 1)
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), 1);
}
else
{
cgs.ActionComplete(Convert.ToInt32(dv[i]["F_DeviceIndex"]), Convert.ToInt32(dv[i]["F_MonitorIndex"]), Model.CGeneralFunction.TASKABEND);
}
}
}
}
else
{
if (mti == 1)
{
int startdevice = Convert.ToInt32(this.dgvManager.CurrentRow.Cells["<22><><EFBFBD><EFBFBD>"].Value);
int enddevice = Convert.ToInt32(this.dgvManager.CurrentRow.Cells["<22>յ<EFBFBD>"].Value);
if (enddevice == 18007 || enddevice == 12049 || enddevice == 12054)
{
//<2F><>ʾ<EFBFBD><CABE><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͻ<EFBFBD>
dboM.ExceSQL("update IO_Control set Control_STATUS=" + Model.CGeneralFunction.TASKPACKFINISH + " where Control_ID=" + fid);
}
else
if (startdevice == 32080 && enddevice == 32080)
{
dboM.ExceSQL("update IO_Control set Control_STATUS=" + Model.CGeneralFunction.TASKUNPACKFINISH + " where Control_ID=" + fid);
}
else
{
dboM.ExceSQL("update IO_Control set Control_STATUS=" + Model.CGeneralFunction.TASKABEND + " where Control_ID=" + fid);
}
}
//<2F><>д<EFBFBD><D0B4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
cgs.ReturnManageInfo(fid, mti, cap, true);
}
this.dgvManager.DataSource = dbo.ExceSQL("select * from V_Manage_Task where " + _manstatus).Tables[0].DefaultView;
}
catch (Exception ex)
{
//throw ex;
if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD>쳣<EFBFBD><ECB3A3><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message) < 0)
{
FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "<22><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ֹ<EFBFBD><D6B9><EFBFBD><EFBFBD>쳣<EFBFBD><ECB3A3><EFBFBD><EFBFBD>ʱ<EFBFBD><CAB1>" + ex.Message, true);
}
}
}
private void dgvManager_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
}
}
}
Reference in New Issue Copy Permalink