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.
1162 lines
49 KiB
1162 lines
49 KiB
5 months ago
|
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 Microsoft.VisualBasic;
|
||
|
|
using System.Resources;
|
||
|
|
using System.Collections;
|
||
|
|
|
||
|
|
namespace SystemConfig
|
||
|
|
{
|
||
|
|
public partial class FrmDeviceEdit : Form
|
||
|
|
{
|
||
|
|
bool IfUpdate = false;
|
||
|
|
string CommonSql = "SELECT T_Base_Device.F_DeviceIndex AS �豸����, " +
|
||
|
|
" T_Base_Device.F_DeviceName AS �豸����, " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex AS �豸��������, " +
|
||
|
|
" T_Base_Device_Kind.F_DeviceKindName AS �豸��������, " +
|
||
|
|
" T_Base_Device.F_CommType AS ͨѶ�ӿڷ�ʽ, " +
|
||
|
|
" T_Base_Device.F_DBWAddress AS DBW1����ʼ��ַ, " +
|
||
|
|
" T_Base_Device.F_DBWSendLength AS ��������," +
|
||
|
|
" T_Base_Device.F_DBWGetLength AS ��������, " +
|
||
|
|
" T_Base_Device.F_SerialPort AS ���ڱ���, " +
|
||
|
|
" T_Base_Device.F_CommSettings AS ͨѶ��������," +
|
||
|
|
" T_Base_Device.F_LocalIP AS ����IP��ַ, " +
|
||
|
|
" T_Base_Device.F_LocalPort AS ���ض˿�," +
|
||
|
|
" T_Base_Device.F_RemoteIP AS Զ��IP��ַ, " +
|
||
|
|
" T_Base_Device.F_RemotePort AS Զ�̶˿�,F_LockedState AS �豸״̬," +
|
||
|
|
" F_EndNode AS ���ն˽ڵ�,F_WaitPallet AS ����ͣ��, F_DeviceVisual AS ������ʾ," +
|
||
|
|
" F_Picture AS ͼƬԴ����,F_ControlName AS ���ؽ����ϵ�ͼ�οؼ�����, " +
|
||
|
|
" T_Base_Device.F_BindingDevice AS �����豸����,F_NeedOptimize AS ��Ҫ�Ż�����," +
|
||
|
|
" F_CollectPut AS ��Ҫ����,f_createlock as �����Զ�����JIT��Ͱ,T_Base_Device.F_DBW2Address AS DBW2����ʼ��ַ " +
|
||
|
|
" FROM T_Base_Device,T_Base_Device_Kind ";
|
||
|
|
private bool _laneIndex = false;
|
||
|
|
|
||
|
|
public bool LaneIndex
|
||
|
|
{
|
||
|
|
get { return _laneIndex; }
|
||
|
|
set { _laneIndex = value; }
|
||
|
|
}
|
||
|
|
private bool _laneGateDeviceIndex = false;
|
||
|
|
|
||
|
|
public bool LaneGateDeviceIndex
|
||
|
|
{
|
||
|
|
get { return _laneGateDeviceIndex; }
|
||
|
|
set { _laneGateDeviceIndex = value; }
|
||
|
|
}
|
||
|
|
private bool _isSelected = false;
|
||
|
|
|
||
|
|
public bool IsSelected
|
||
|
|
{
|
||
|
|
get { return _isSelected; }
|
||
|
|
set { _isSelected = value; }
|
||
|
|
}
|
||
|
|
private static FrmDeviceEdit _formInstance;
|
||
|
|
|
||
|
|
public static FrmDeviceEdit FormInstance
|
||
|
|
{
|
||
|
|
get
|
||
|
|
{
|
||
|
|
if (_formInstance == null)
|
||
|
|
{
|
||
|
|
_formInstance = new FrmDeviceEdit();
|
||
|
|
|
||
|
|
}
|
||
|
|
return _formInstance;
|
||
|
|
}
|
||
|
|
set { FrmDeviceEdit._formInstance = value; }
|
||
|
|
}
|
||
|
|
DBOperator dbo = CStaticClass.dbo;
|
||
|
|
|
||
|
|
public FrmDeviceEdit()
|
||
|
|
{
|
||
|
|
InitializeComponent();
|
||
|
|
_formInstance = this;
|
||
|
|
dbo.Open();
|
||
|
|
}
|
||
|
|
|
||
|
|
private void FrmDeviceEdit_Load(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
this.tabControl1.SelectTab("tabPage2");
|
||
|
|
if (_isSelected == true)
|
||
|
|
{
|
||
|
|
btSelectOK.Visible = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
btSelectOK.Visible = false;
|
||
|
|
|
||
|
|
DataSet ds= dbo.ExceSQL("select * from T_BASE_CommType");
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count > 0)
|
||
|
|
{
|
||
|
|
|
||
|
|
this.cbCommType.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
this.cbCommType.ValueMember = "F_CommType";
|
||
|
|
this.cbCommType.DisplayMember = "F_CommType";
|
||
|
|
}
|
||
|
|
this.cbCommType.Text = "";
|
||
|
|
cbPicture.Items.Clear();
|
||
|
|
ResourceManager rm = new ResourceManager("SystemConfig.Properties.Resources", this.GetType().Assembly);
|
||
|
|
ResourceSet rs=rm.GetResourceSet(System.Globalization.CultureInfo.CurrentCulture,true,true);
|
||
|
|
|
||
|
|
IDictionaryEnumerator en = rs.GetEnumerator();
|
||
|
|
|
||
|
|
|
||
|
|
// Goes through the enumerator, printing out the key and value pairs.
|
||
|
|
while (en.MoveNext())
|
||
|
|
{
|
||
|
|
if ((en.Key.ToString().IndexOf("Err") < 0) && (en.Key.ToString().IndexOf("Goods") < 0))
|
||
|
|
{
|
||
|
|
cbPicture.Items.Add(en.Key);
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
rs.Close();
|
||
|
|
|
||
|
|
|
||
|
|
///////////////////����̽������
|
||
|
|
DataView dv4 = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName, F_DeviceKindIndex FROM T_Base_Device Where F_DeviceKindIndex=18 order by F_DeviceName").Tables[0].DefaultView;
|
||
|
|
//��ť��
|
||
|
|
DataView dv3 = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName, F_DeviceKindIndex FROM T_Base_Device Where F_DeviceKindIndex=14 order by F_DeviceName").Tables[0].DefaultView;
|
||
|
|
DataView dv2 = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName, F_DeviceKindIndex FROM T_Base_Device Where F_DeviceKindIndex=14 order by F_DeviceName").Tables[0].DefaultView;
|
||
|
|
//�������ͼ���
|
||
|
|
DataView dv1 = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName, F_DeviceKindIndex FROM T_Base_Device Where F_DeviceKindIndex=18 order by F_DeviceName").Tables[0].DefaultView;
|
||
|
|
if (dv4.Count > 0)
|
||
|
|
{
|
||
|
|
this.cbBindingDeviceIndex.ValueMember = "F_DeviceIndex";
|
||
|
|
this.cbBindingDeviceIndex.DisplayMember = "F_DeviceName";
|
||
|
|
this.cbBindingDeviceIndex.DataSource = dv4;
|
||
|
|
this.cbPauseWeighButton.ValueMember = "F_DeviceIndex";
|
||
|
|
this.cbPauseWeighButton.DisplayMember = "F_DeviceName";
|
||
|
|
this.cbPauseWeighButton.DataSource = dv3;
|
||
|
|
this.cbLoopButton.ValueMember = "F_DeviceIndex";
|
||
|
|
this.cbLoopButton.DisplayMember = "F_DeviceName";
|
||
|
|
this.cbLoopButton.DataSource = dv2;
|
||
|
|
this.cbContainerType.ValueMember = "F_DeviceIndex";
|
||
|
|
this.cbContainerType.DisplayMember = "F_DeviceName";
|
||
|
|
this.cbContainerType.DataSource = dv1;
|
||
|
|
|
||
|
|
}
|
||
|
|
this.cbBindingDeviceIndex.SelectedValue = 0;
|
||
|
|
this.cbPauseWeighButton.SelectedValue = 0;
|
||
|
|
this.cbLoopButton.SelectedValue = 0;
|
||
|
|
this.cbContainerType.SelectedValue = 0;
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void cbCommType_SelectedIndexChanged(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
switch (this.cbCommType.SelectedValue.ToString())
|
||
|
|
{
|
||
|
|
case "SimensSerialPort":
|
||
|
|
this.gbSerialPort.Visible =true;
|
||
|
|
this.gbCp5611.Visible = false;
|
||
|
|
this.gbSockects.Visible = false;
|
||
|
|
break;
|
||
|
|
case "SimensCP5611":
|
||
|
|
this.gbSerialPort.Visible = false;
|
||
|
|
this.gbSockects.Visible = false;
|
||
|
|
this.gbCp5611.Visible = true;
|
||
|
|
break;
|
||
|
|
case "Symbol3204":
|
||
|
|
this.gbSerialPort.Visible = true;
|
||
|
|
this.gbCp5611.Visible = false;
|
||
|
|
this.gbSockects.Visible = false;
|
||
|
|
break;
|
||
|
|
case "SocketsUDP":
|
||
|
|
this.gbSerialPort.Visible = false;
|
||
|
|
this.gbCp5611.Visible = false;
|
||
|
|
this.gbSockects.Visible = true;
|
||
|
|
break;
|
||
|
|
case "SocketsTCPIP":
|
||
|
|
this.gbSerialPort.Visible = false;
|
||
|
|
this.gbCp5611.Visible = false;
|
||
|
|
this.gbSockects.Visible = true;
|
||
|
|
break;
|
||
|
|
case "SocketsTCPIPServer":
|
||
|
|
this.gbSerialPort.Visible = false;
|
||
|
|
this.gbCp5611.Visible = false;
|
||
|
|
this.gbSockects.Visible = true;
|
||
|
|
break;
|
||
|
|
default:
|
||
|
|
break;
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btQuery_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (tbContent.Text.Trim() == "") return;
|
||
|
|
try
|
||
|
|
{
|
||
|
|
string df = "";
|
||
|
|
|
||
|
|
switch (this.cbField.Text)
|
||
|
|
{
|
||
|
|
case "�豸����":
|
||
|
|
df = "F_DeviceIndex";
|
||
|
|
break;
|
||
|
|
case "�豸����":
|
||
|
|
df = "F_DeviceName";
|
||
|
|
break;
|
||
|
|
case "�豸��������":
|
||
|
|
df = "T_Base_Device.F_DeviceKindIndex";
|
||
|
|
break;
|
||
|
|
case "�豸��������":
|
||
|
|
df = "F_DeviceKindName";
|
||
|
|
break;
|
||
|
|
case "ͨѶ�ӿ�����":
|
||
|
|
df = "F_CommType";
|
||
|
|
break;
|
||
|
|
default:
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
string sql = CommonSql + " WHERE " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex " +
|
||
|
|
" and " + df + "= '" + this.tbContent.Text + "' order by T_Base_Device.F_DeviceIndex";
|
||
|
|
DataSet ds = dbo.ExceSQL(sql);
|
||
|
|
//if (ds.Tables[0].DefaultView.Count > 0)
|
||
|
|
//{
|
||
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
//}
|
||
|
|
}
|
||
|
|
catch (Exception ex)
|
||
|
|
{
|
||
|
|
throw ex;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btNullQuery_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
this.cbField.Text = "";
|
||
|
|
this.tbContent.Text = "";
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btNull_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
this.tbDeviceIndex.Text = "";
|
||
|
|
this.tbDeviceKindIndex.Text = "";
|
||
|
|
this.tbDeviceName.Text = "";
|
||
|
|
this.cbCommType.Text = "";
|
||
|
|
this.tbAddress.Text = "";
|
||
|
|
this.tbCommSettings.Text = "";
|
||
|
|
this.tbGetLength.Text = "";
|
||
|
|
this.tbPort.Text = "";
|
||
|
|
this.tbSendLength.Text = "";
|
||
|
|
this.tblocalIP.Text = "";
|
||
|
|
this.tblocalport.Text = "";
|
||
|
|
this.tbremoteIP.Text = "";
|
||
|
|
this.tbremoteport.Text = "";
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btBack_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
this.Close();
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btSave_Click(object sender , EventArgs e)
|
||
|
|
{
|
||
|
|
try
|
||
|
|
{
|
||
|
|
#region ��������
|
||
|
|
|
||
|
|
if (MessageBox.Show("��ȷ��Ҫ�����豸��Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
string sql = "";
|
||
|
|
string sqlUpdate = "";
|
||
|
|
int LockedState, devvisual;
|
||
|
|
string endnode, waitp, pic, ctrolname, NeedOptimize, CollectPut,CreateLock;
|
||
|
|
this.tbCommSettings.Text.Replace(',', '��');
|
||
|
|
|
||
|
|
if (Information.IsNumeric(this.tbDeviceIndex.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("�豸����ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tbDeviceIndex.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(this.tbDeviceKindIndex.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("�豸��������ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tbDeviceKindIndex.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (this.tbDeviceName.Text.Trim().Length == 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("�豸���Ʋ������ǿ�ֵ��", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tbDeviceName.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (this.cbCommType.Text.Trim().Length == 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("ͨѶ�ӿ����Ͳ������ǿ�ֵ��", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
cbCommType.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
|
||
|
|
if (cbLockedState.Text == "0:����")
|
||
|
|
{
|
||
|
|
LockedState = 0;
|
||
|
|
}
|
||
|
|
else if (cbLockedState.Text == "-1:ͣ��")
|
||
|
|
{
|
||
|
|
LockedState = -1;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
if (Information.IsNumeric(cbLockedState.Text) != true)
|
||
|
|
{
|
||
|
|
MessageBox.Show("ֻ���ǣ�0:���У�����-1:ͣ�ã����������͵��豸ָ��������", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
cbLockedState.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
LockedState = Convert.ToInt32(cbLockedState.Text.Trim());
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
if (chbDeviceVisual.Checked == true)
|
||
|
|
{
|
||
|
|
devvisual = 1;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
devvisual = 0;
|
||
|
|
}
|
||
|
|
if (this.chbEndNode.Checked == true)
|
||
|
|
{
|
||
|
|
endnode = "1";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
endnode = "0";
|
||
|
|
}
|
||
|
|
if (chbWaitPallet.Checked == true)
|
||
|
|
{
|
||
|
|
waitp = "1";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
waitp = "0";
|
||
|
|
}
|
||
|
|
if (chbNeedOptimize.Checked == true)
|
||
|
|
{
|
||
|
|
NeedOptimize = "1";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
NeedOptimize = "0";
|
||
|
|
}
|
||
|
|
if (chbCollectPut.Checked == true)
|
||
|
|
{
|
||
|
|
CollectPut = "1";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
CollectPut = "0";
|
||
|
|
}
|
||
|
|
if (cbPicture.Text.Trim() == "")
|
||
|
|
{
|
||
|
|
pic = null;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
pic = cbPicture.Text.Trim();
|
||
|
|
}
|
||
|
|
if (tbControlName.Text.Trim() == "")
|
||
|
|
{
|
||
|
|
ctrolname= null;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
ctrolname = tbControlName.Text.Trim();
|
||
|
|
}
|
||
|
|
if (chbCreateLock.Checked == true)
|
||
|
|
{
|
||
|
|
CreateLock = "1";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
CreateLock = "0";
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region ��̫��ģʽ
|
||
|
|
|
||
|
|
|
||
|
|
if ((this.cbCommType.SelectedValue.ToString() == "SocketsUDP") || (this.cbCommType.SelectedValue.ToString() == "SocketsTCPIP") || (this.cbCommType.SelectedValue.ToString() == "SocketsTCPIPServer"))
|
||
|
|
{
|
||
|
|
if (Information.IsNumeric(this.tblocalport.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("����ͨѶ�˿�ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tblocalport.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
char[] cc = new char[1] { '.' };
|
||
|
|
string [] split=this.tblocalIP.Text.Split(cc);
|
||
|
|
for (int i=0;i<=3;i++)
|
||
|
|
{
|
||
|
|
if (Information.IsNumeric(split[i]) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("����Ip��ַֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tblocalIP.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(this.tbremoteport.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("Զ��ͨѶ�˿�ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tbremoteport.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
split = this.tbremoteIP.Text.Split(cc);
|
||
|
|
for (int i = 0; i <= 3; i++)
|
||
|
|
{
|
||
|
|
if (Information.IsNumeric(split[i]) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("Զ��Ip��ַֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tbremoteIP.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
sql = "insert into T_Base_Device(F_DeviceIndex,F_DeviceKindIndex,F_DeviceName," +
|
||
|
|
"F_CommType,F_LocalIP,F_LocalPort,F_RemoteIP,F_RemotePort,F_LockedState,F_EndNode,F_WaitPallet,F_DeviceVisual,F_Picture,F_ControlName,F_NeedOptimize,F_CollectPut,f_createlock ) " +
|
||
|
|
"values(" + Convert.ToInt32(tbDeviceIndex.Text) + "," + Convert.ToInt32(tbDeviceKindIndex.Text) +
|
||
|
|
",'" + tbDeviceName.Text + "','" + cbCommType.SelectedValue.ToString() + "','" + this.tblocalIP.Text +
|
||
|
|
"'," + Convert.ToInt32(this.tblocalport.Text) + ",'" + (this.tbremoteIP.Text) + "'," + Convert.ToInt32(this.tbremoteport.Text) + ","+
|
||
|
|
LockedState + ",'" + endnode + "','" + waitp + "'," + devvisual + ",'" + pic + "','" + ctrolname + "','" + NeedOptimize + "','" + CollectPut + "','"+ CreateLock +"')";
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region ���ɿ�
|
||
|
|
|
||
|
|
|
||
|
|
else if ((this.cbCommType.SelectedValue.ToString() == "SimensSerialPort") || (this.cbCommType.SelectedValue.ToString() == "Symbol3204"))
|
||
|
|
{
|
||
|
|
if (Information.IsNumeric(this.tbPort.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���ڱ���ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tbPort.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (this.tbCommSettings.Text.Trim().Length == 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("ͨѶ�������ò������ǿ�ֵ��", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
tbCommSettings.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
sql = "insert into T_Base_Device(F_DeviceIndex,F_DeviceKindIndex,F_DeviceName," +
|
||
|
|
"F_CommType,F_SerialPort,F_CommSettings,F_LockedState,F_EndNode,F_WaitPallet,F_DeviceVisual,F_Picture,F_ControlName,F_NeedOptimize,F_CollectPut,f_createlock ) " +
|
||
|
|
"values(" + Convert.ToInt32(tbDeviceIndex.Text) + "," + Convert.ToInt32(tbDeviceKindIndex.Text) +
|
||
|
|
",'" + tbDeviceName.Text + "','" + cbCommType.SelectedValue.ToString() + "'," + Convert.ToInt32(this.tbPort.Text) +
|
||
|
|
",'" + this.tbCommSettings.Text + "'," +
|
||
|
|
LockedState + ",'" + endnode + "','" + waitp + "'," + devvisual + ",'" + pic + "','" + ctrolname + "','" + NeedOptimize + "','" + CollectPut + "','"+CreateLock +"')"; ;
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region SimensCP5611
|
||
|
|
|
||
|
|
|
||
|
|
else if (this.cbCommType.SelectedValue.ToString() == "SimensCP5611")
|
||
|
|
{
|
||
|
|
if (Information.IsNumeric(this.tbAddress.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("DBW1����ʼ��ַֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(this.tbAddress2.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("DBW2����ʼ��ַֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(this.tbGetLength.Text) == false)
|
||
|
|
{
|
||
|
|
double a, b, c;
|
||
|
|
char[] cc = new char[1] { '/' };
|
||
|
|
string[] sp;
|
||
|
|
if (this.tbGetLength.Text.IndexOf('/') > 0)
|
||
|
|
{
|
||
|
|
sp = this.tbGetLength.Text.Split(cc);
|
||
|
|
a = Convert.ToDouble(sp[0]);
|
||
|
|
b = Convert.ToDouble(sp[1]);
|
||
|
|
c = a / b;
|
||
|
|
this.tbGetLength.Text = c.ToString();
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
MessageBox.Show("��������ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(this.tbSendLength.Text) == false)
|
||
|
|
{
|
||
|
|
double a, b, c;
|
||
|
|
char[] cc = new char[1] { '/' };
|
||
|
|
string[] sp;
|
||
|
|
if (this.tbSendLength.Text.IndexOf('/') > 0)
|
||
|
|
{
|
||
|
|
sp = this.tbSendLength.Text.Split(cc);
|
||
|
|
a = Convert.ToDouble(sp[0]);
|
||
|
|
b = Convert.ToDouble(sp[1]);
|
||
|
|
c = a / b;
|
||
|
|
this.tbSendLength.Text = c.ToString();
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
MessageBox.Show("��������ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
sql = "insert into T_Base_Device(F_DeviceIndex,F_DeviceKindIndex,F_DeviceName," +
|
||
|
|
"F_CommType,F_DBWAddress,F_DBWSendLength,F_DBW2Address,F_DBWGetLength,F_LockedState,F_EndNode,F_WaitPallet,F_DeviceVisual,F_Picture,F_ControlName,F_NeedOptimize,F_CollectPut,f_createlock ) " +
|
||
|
|
"values(" + Convert.ToInt32(tbDeviceIndex.Text) + "," + Convert.ToInt32(tbDeviceKindIndex.Text) +
|
||
|
|
",'" + tbDeviceName.Text + "','" + cbCommType.SelectedValue + "'," + Convert.ToInt32(this.tbAddress.Text) +
|
||
|
|
"," + Convert.ToDouble(this.tbSendLength.Text) + "," + Convert.ToInt32(this.tbAddress2.Text) +"," + Convert.ToDouble(this.tbGetLength.Text) + "," +
|
||
|
|
LockedState + ",'" + endnode + "','" + waitp + "'," + devvisual + ",'" + pic + "','" + ctrolname + "','" + NeedOptimize + "','" + CollectPut + "','"+ CreateLock +"')";
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region �������ӿ�
|
||
|
|
|
||
|
|
|
||
|
|
else //if ((this.cbCommType.SelectedValue.ToString() == "-"))
|
||
|
|
{
|
||
|
|
sql = "insert into T_Base_Device(F_DeviceIndex,F_DeviceKindIndex,F_DeviceName," +
|
||
|
|
" F_CommType,F_LockedState,F_EndNode,F_WaitPallet,F_DeviceVisual,F_Picture,F_ControlName,F_NeedOptimize,F_CollectPut,f_createlock) " +
|
||
|
|
"values(" + Convert.ToInt32(tbDeviceIndex.Text) + "," + Convert.ToInt32(tbDeviceKindIndex.Text) +
|
||
|
|
",'" + tbDeviceName.Text + "','" + cbCommType.SelectedValue + "'," + LockedState + ",'" + endnode + "','" + waitp + "'," +
|
||
|
|
devvisual + ",'" + pic + "','" + ctrolname + "','" + NeedOptimize + "','" + CollectPut + "','" + CreateLock + "')"; ;
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region ������ʾ
|
||
|
|
|
||
|
|
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT F_DeviceKindIndex, F_GoodsMoveKindIndex," +
|
||
|
|
" F_DeviceKindName FROM T_Base_Device_Kind where F_DeviceKindIndex=" + Convert.ToInt32(this.tbDeviceKindIndex.Text));
|
||
|
|
if (ds.Tables[0].DefaultView.Count <= 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("�豸�������������ݿ��в����ڣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
ds.Clear();
|
||
|
|
|
||
|
|
string strsql = CommonSql + " WHERE " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex " +
|
||
|
|
" and F_DeviceIndex = " + Convert.ToInt32(this.tbDeviceIndex.Text);
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
#region ���豸��Ϣ
|
||
|
|
|
||
|
|
|
||
|
|
if (IfUpdate == true)
|
||
|
|
{
|
||
|
|
int addr = 0, addr2 = 0, sport = 0, lport = 0, rport = 0;
|
||
|
|
double slen=0, glen=0;
|
||
|
|
string lip = null, rip = null;
|
||
|
|
if (tbAddress.Text.Length > 0)
|
||
|
|
addr =Convert.ToInt32(tbAddress.Text);
|
||
|
|
if (tbPort.Text.Length > 0)
|
||
|
|
sport = Convert.ToInt32(tbPort.Text);
|
||
|
|
if (tbSendLength.Text.Length > 0)
|
||
|
|
slen = Convert.ToDouble(tbSendLength.Text );
|
||
|
|
if (tbAddress2.Text.Length > 0)
|
||
|
|
addr2 = Convert.ToInt32(tbAddress2.Text);
|
||
|
|
if (tbGetLength.Text.Length > 0)
|
||
|
|
glen = Convert.ToDouble(tbGetLength.Text);
|
||
|
|
if (tblocalIP.Text.Length > 0)
|
||
|
|
lip = tblocalIP.Text ;
|
||
|
|
if (tblocalport.Text.Length > 0)
|
||
|
|
lport = Convert.ToInt32(tblocalport.Text);
|
||
|
|
if (tbremoteIP.Text.Length > 0)
|
||
|
|
rip = tbremoteIP.Text;
|
||
|
|
if (tbremoteport.Text.Length > 0)
|
||
|
|
rport = Convert.ToInt32(tbremoteport.Text);
|
||
|
|
sqlUpdate = "update T_Base_Device set F_DeviceKindIndex="+ tbDeviceKindIndex.Text
|
||
|
|
+ ", F_DeviceName='" + tbDeviceName.Text + "',F_CommType='"+ cbCommType.Text
|
||
|
|
+ "',F_DBWAddress=" + addr + ",F_DBWSendLength="+ slen
|
||
|
|
+ ",F_DBW2Address=" + addr2 + ",F_DBWGetLength=" + glen + ",F_SerialPort=" + sport
|
||
|
|
+ ",F_LocalIP='" + lip + "',F_LocalPort=" + lport
|
||
|
|
+ ",F_RemoteIP='" + rip + "',F_RemotePort=" + rport
|
||
|
|
+ ", F_CommSettings='" + tbCommSettings.Text
|
||
|
|
+ "',F_LockedState ="+LockedState +", F_EndNode ='"+endnode
|
||
|
|
+"', F_WaitPallet ='"+waitp +"', F_DeviceVisual ="+devvisual
|
||
|
|
+", F_Picture ='"+pic +"', F_ControlName ='"+ ctrolname
|
||
|
|
+ "',F_NeedOptimize='" + NeedOptimize + "',F_CollectPut='" + CollectPut + "',f_createlock ='"+ CreateLock
|
||
|
|
+ "' where F_DeviceIndex=" + Convert.ToInt32(tbDeviceIndex.Text);
|
||
|
|
ds = dbo.ExceSQL(sqlUpdate);
|
||
|
|
MessageBox.Show("�豸��Ϣ�ijɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
|
|
|
||
|
|
IfUpdate = false;
|
||
|
|
}
|
||
|
|
#endregion
|
||
|
|
|
||
|
|
else
|
||
|
|
{
|
||
|
|
//�ж��Ƿ�����
|
||
|
|
ds = dbo.ExceSQL(strsql);
|
||
|
|
if (ds.Tables[0].DefaultView.Count > 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("�豸���������ݿ����Ѿ����ڣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
ds.Clear();
|
||
|
|
ds = dbo.ExceSQL(sql);
|
||
|
|
MessageBox.Show("�豸��Ϣ¼���ɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
ds.Clear();
|
||
|
|
ds = dbo.ExceSQL(strsql);
|
||
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
catch (Exception ex)
|
||
|
|
{
|
||
|
|
throw ex;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
private void tsmEdit_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (dataGridView1.RowCount <= 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
|
||
|
|
this.tabControl1.SelectTab("tabPage1");
|
||
|
|
this.tbDeviceIndex.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString()+ "";
|
||
|
|
this.tbDeviceName.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString() + "";
|
||
|
|
this.tbDeviceKindIndex.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString() + "";
|
||
|
|
//this.cbCommType.SelectedValue = this.dataGridView1.CurrentRow.Cells[4].Value.ToString() + "";
|
||
|
|
this.cbCommType.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString() + "";
|
||
|
|
cbCommType_SelectedIndexChanged(sender, e);
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[4].Value.ToString() + "" == "")
|
||
|
|
{
|
||
|
|
this.cbCommType.Text = "-";
|
||
|
|
}
|
||
|
|
this.tbAddress.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString() + "";
|
||
|
|
this.tbSendLength.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString() + "";
|
||
|
|
this.tbGetLength.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString() + "";
|
||
|
|
this.tbPort.Text = this.dataGridView1.CurrentRow.Cells[8].Value.ToString() + "";
|
||
|
|
this.tbCommSettings.Text = this.dataGridView1.CurrentRow.Cells[9].Value.ToString() + "";
|
||
|
|
this.tblocalIP.Text = this.dataGridView1.CurrentRow.Cells[10].Value.ToString() + "";
|
||
|
|
this.tblocalport.Text = this.dataGridView1.CurrentRow.Cells[11].Value.ToString() + "";
|
||
|
|
this.tbremoteIP.Text = this.dataGridView1.CurrentRow.Cells[12].Value.ToString() + "";
|
||
|
|
this.tbremoteport.Text = this.dataGridView1.CurrentRow.Cells[13].Value.ToString() + "";
|
||
|
|
if(this.dataGridView1.CurrentRow.Cells[14].Value.ToString() + ""=="0")
|
||
|
|
{
|
||
|
|
this.cbLockedState.Text = "0:����";
|
||
|
|
}
|
||
|
|
else if (this.dataGridView1.CurrentRow.Cells[14].Value.ToString() + "" == "-1")
|
||
|
|
{
|
||
|
|
this.cbLockedState.Text = "-1:ͣ��";
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.cbLockedState.Text = this.dataGridView1.CurrentRow.Cells[14].Value.ToString() + "";
|
||
|
|
}
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[15].Value.ToString() + "" == "1")
|
||
|
|
{
|
||
|
|
this.chbEndNode.Checked = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.chbEndNode.Checked = false;
|
||
|
|
}
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[16].Value.ToString() + "" == "1")
|
||
|
|
{
|
||
|
|
this.chbWaitPallet.Checked = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.chbWaitPallet.Checked = false;
|
||
|
|
}
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[17].Value.ToString() + "" == "1")
|
||
|
|
{
|
||
|
|
this.chbDeviceVisual.Checked = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.chbDeviceVisual.Checked = false;
|
||
|
|
}
|
||
|
|
this.tbControlName.Text = this.dataGridView1.CurrentRow.Cells[19].Value.ToString() + "";
|
||
|
|
this.cbPicture.Text = this.dataGridView1.CurrentRow.Cells[18].Value.ToString() + "";
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[21].Value.ToString() + "" == "1")
|
||
|
|
{
|
||
|
|
this.chbNeedOptimize.Checked = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.chbNeedOptimize.Checked = false;
|
||
|
|
}
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[22].Value.ToString() + "" == "1")
|
||
|
|
{
|
||
|
|
this.chbCollectPut.Checked = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.chbCollectPut.Checked = false;
|
||
|
|
}
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[23].Value.ToString() + "" == "1")
|
||
|
|
{
|
||
|
|
this.chbCreateLock.Checked = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.chbCreateLock.Checked = false;
|
||
|
|
}
|
||
|
|
this.tbAddress2.Text = this.dataGridView1.CurrentRow.Cells[24].Value.ToString() + "";
|
||
|
|
IfUpdate = true;
|
||
|
|
}
|
||
|
|
|
||
|
|
private void tsmDel_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (dataGridView1.RowCount <= 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (MessageBox.Show("��ȷ��Ҫɾ��ѡ���еġ��豸������" + this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "����Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
dbo.ExceSQL("delete from T_Base_Device where F_DeviceIndex =" + Convert.ToInt32(this.dataGridView1.CurrentRow.Cells[0].Value));
|
||
|
|
button2_Click(sender, e);
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btDeviceKind_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
FrmDeviceKindEdit.FormInstance.IsSelected = true;
|
||
|
|
FrmDeviceKindEdit.FormInstance.ShowDialog();
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btSelectOK_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (_laneGateDeviceIndex==true)
|
||
|
|
FrmLaneGateEdit.FormInstance.tbLaneGateDeviceIndex.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
|
||
|
|
else if (_laneIndex==true)
|
||
|
|
FrmLaneGateEdit.FormInstance.tbLaneIndex.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
|
||
|
|
this.Close();
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button1_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
IfUpdate = false;
|
||
|
|
}
|
||
|
|
|
||
|
|
private void cbLockedState_SelectedIndexChanged(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void chbDeviceVisual_CheckedChanged(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (chbDeviceVisual.Checked == true)
|
||
|
|
{
|
||
|
|
lblctrolname.Visible = true;
|
||
|
|
lblpic.Visible = true;
|
||
|
|
cbPicture.Visible = true;
|
||
|
|
tbControlName.Visible = true;
|
||
|
|
pbPicture.Visible = true;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
lblctrolname.Visible = false;
|
||
|
|
lblpic.Visible = false;
|
||
|
|
cbPicture.Visible = false;
|
||
|
|
tbControlName.Visible = false;
|
||
|
|
pbPicture.Visible = false;
|
||
|
|
tbControlName.Text = "";
|
||
|
|
cbPicture.Text = "";
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
private void cbPicture_SelectedIndexChanged(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
ResourceManager rm = new ResourceManager("SystemConfig.Properties.Resources", this.GetType().Assembly);
|
||
|
|
|
||
|
|
pbPicture.BackgroundImage= (System.Drawing.Image)rm.GetObject(cbPicture.Text.Trim());
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button2_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
string sql = CommonSql + " WHERE " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex order by T_Base_Device.F_DeviceIndex";
|
||
|
|
DataSet ds = dbo.ExceSQL(sql);
|
||
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button20_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (cbBindingDeviceIndex.SelectedValue.ToString() == "")
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
string litem;
|
||
|
|
litem = cbBindingDeviceIndex.Text.Trim() + "=" + cbBindingDeviceIndex.SelectedValue.ToString();
|
||
|
|
for (int i = 0; i < listBox1.Items.Count; i++)
|
||
|
|
{
|
||
|
|
if (litem == listBox1.Items[i].ToString())
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
this.listBox1.Items.Add(litem);
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button19_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (listBox1.SelectedIndex < 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
this.listBox1.Items.RemoveAt(listBox1.SelectedIndex);
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button28_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (listBox1.SelectedIndex < 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
string item = listBox1.SelectedItem.ToString();
|
||
|
|
int idx = listBox1.SelectedIndex - 1;
|
||
|
|
if (idx < 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
listBox1.Items.RemoveAt(listBox1.SelectedIndex);
|
||
|
|
listBox1.Items.Insert(idx, item);
|
||
|
|
listBox1.SelectedIndex = idx;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button27_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if ((listBox1.SelectedIndex >= listBox1.Items.Count) || (listBox1.SelectedIndex < 0))
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
string item = listBox1.SelectedItem.ToString();
|
||
|
|
int idx = listBox1.SelectedIndex + 1;
|
||
|
|
if ((idx >= listBox1.Items.Count) || (idx < 0))
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
listBox1.Items.RemoveAt(listBox1.SelectedIndex);
|
||
|
|
listBox1.Items.Insert(idx, item);
|
||
|
|
listBox1.SelectedIndex = idx;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button18_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
this.tbDeviceIndex1.Text = "";
|
||
|
|
this.cbBindingDeviceIndex.Text = "";
|
||
|
|
this.listBox1.Text = "";
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void toolStripMenuItem1_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (dataGridView1.RowCount <= 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
this.tabControl1.SelectTab("tabPage3");
|
||
|
|
this.tbDeviceIndex1.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "";
|
||
|
|
char[] cc = new char[1] { ';' };
|
||
|
|
|
||
|
|
string[] split;
|
||
|
|
|
||
|
|
string sql;
|
||
|
|
|
||
|
|
if (this.dataGridView1.CurrentRow.Cells[20].Value.ToString() + "" == "")
|
||
|
|
{
|
||
|
|
listBox1.Items.Clear();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT * FROM T_Base_Device where F_DeviceIndex=" + Convert.ToInt32(this.tbDeviceIndex1.Text.Trim()));
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count > 0)
|
||
|
|
{
|
||
|
|
if (dv[0]["F_BindingDevice"] == DBNull.Value)
|
||
|
|
{
|
||
|
|
listBox1.Items.Clear();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
//listBox1
|
||
|
|
listBox1.Items.Clear();
|
||
|
|
split = dv[0]["F_BindingDevice"].ToString().Split(cc);
|
||
|
|
for (int i = split.GetLowerBound(0); i <= split.GetUpperBound(0); i++)
|
||
|
|
{
|
||
|
|
sql = "SELECT F_DeviceIndex,F_DeviceName FROM T_Base_Device Where F_DeviceIndex=" + Convert.ToInt32(split[i]);
|
||
|
|
DataSet ds2 = dbo.ExceSQL(sql);
|
||
|
|
DataView dv2 = ds2.Tables[0].DefaultView;
|
||
|
|
if (dv2.Count <= 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("�����豸�������豸�������ڣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
listBox1.Items.Add(dv2[0]["F_DeviceName"].ToString() + "=" + dv2[0]["F_DeviceIndex"].ToString());
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.listBox1.Items.Clear();
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
IfUpdate = true;
|
||
|
|
}
|
||
|
|
|
||
|
|
private void button17_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
if (MessageBox.Show("��ȷ��Ҫ���������豸��Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(this.tbDeviceIndex1.Text) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸����ֻ�����������֣�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex1.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT * FROM T_Base_Device where F_DeviceIndex=" + Convert.ToInt32(this.tbDeviceIndex1.Text.Trim()));
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count <= 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸���������ݿ��в����ڣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex1.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
ds.Clear();
|
||
|
|
dv.Dispose();
|
||
|
|
string bindingdevice="";
|
||
|
|
char[] dh = new char[1] { '='};
|
||
|
|
string[] sp;
|
||
|
|
if (listBox1.Items.Count > 0)
|
||
|
|
{
|
||
|
|
for (int i = 0; i < listBox1.Items.Count; i++)
|
||
|
|
{
|
||
|
|
sp = listBox1.Items[i].ToString().Split(dh);
|
||
|
|
bindingdevice = bindingdevice + ";" + sp[1];
|
||
|
|
}
|
||
|
|
bindingdevice = bindingdevice.Substring(1);
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
bindingdevice = null;
|
||
|
|
}
|
||
|
|
dbo.ExceSQL("update t_base_device set f_bindingdevice='"+ bindingdevice +"' where F_DeviceIndex=" + Convert.ToInt32(this.tbDeviceIndex1.Text.Trim()));
|
||
|
|
string sql = CommonSql + " WHERE " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex and F_DeviceIndex=" + Convert.ToInt32(this.tbDeviceIndex1.Text.Trim());
|
||
|
|
ds = dbo.ExceSQL(sql);
|
||
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
MessageBox.Show("�����豸��Ϣ�����ɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
|
|
}
|
||
|
|
|
||
|
|
private void toolStripMenuItem3_Click(object sender, EventArgs e)
|
||
|
|
{//WIA��������ͣ���ϰ�ť��Ϣά��
|
||
|
|
if (dataGridView1.RowCount <= 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
this.tabControl1.SelectTab("tabPage5");
|
||
|
|
this.tbDeviceIndex3.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "";
|
||
|
|
|
||
|
|
DataView dv= dbo.ExceSQL("SELECT f_pause FROM T_Base_Device where f_pause is not NULL and F_DeviceIndex=" + Convert.ToInt32(this.tbDeviceIndex3.Text.Trim())).Tables[0].DefaultView;
|
||
|
|
if (dv.Count > 0)
|
||
|
|
{
|
||
|
|
this.cbPauseWeighButton.SelectedValue = dv[0]["f_pause"];
|
||
|
|
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.cbPauseWeighButton.SelectedValue = 0;
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
IfUpdate = true;
|
||
|
|
}
|
||
|
|
|
||
|
|
private void toolStripMenuItem2_Click(object sender, EventArgs e)
|
||
|
|
{//JIT�Ŀ�������λ��������ť��Ϣά��
|
||
|
|
if (dataGridView1.RowCount <= 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
this.tabControl1.SelectTab("tabPage4");
|
||
|
|
this.tbDeviceIndex2.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "";
|
||
|
|
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT f_loop FROM T_Base_Device where f_loop is not NULL and F_DeviceIndex=" + Convert.ToInt32(this.tbDeviceIndex2.Text.Trim()));
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count > 0)
|
||
|
|
{
|
||
|
|
this.cbLoopButton.SelectedValue = Convert.ToInt32(dv[0]["f_loop"]);
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.cbLoopButton.SelectedValue = 0;
|
||
|
|
}
|
||
|
|
IfUpdate = true;
|
||
|
|
}
|
||
|
|
|
||
|
|
private void toolStripMenuItem4_Click(object sender, EventArgs e)
|
||
|
|
{//JIT/WIA�������ͼ���������Ϣά��
|
||
|
|
if (dataGridView1.RowCount <= 0)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
this.tabControl1.SelectTab("tabPage6");
|
||
|
|
this.tbDeviceIndex4.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "";
|
||
|
|
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT f_containertype FROM T_Base_Device where f_containertype is not NULL and F_DeviceIndex=" + Convert.ToInt32(this.tbDeviceIndex4.Text.Trim()));
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count > 0)
|
||
|
|
{
|
||
|
|
this.cbContainerType.SelectedValue = dv[0]["f_containertype"];
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
this.cbContainerType.SelectedValue = 0;
|
||
|
|
}
|
||
|
|
IfUpdate = true;
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btSaveJITLoop_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
string devIndex = this.tbDeviceIndex2.Text ;
|
||
|
|
if (MessageBox.Show("��ȷ��Ҫ����JIT�Ŀ�������λ��������ť��Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(devIndex) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸����ֻ�����������֣�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex2.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT F_DeviceIndex FROM T_Base_Device where F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim()));
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count <= 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸���������ݿ��в����ڣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex2.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
ds.Clear();
|
||
|
|
dv.Dispose();
|
||
|
|
string bindingdevice = this.cbLoopButton.SelectedValue.ToString();
|
||
|
|
dbo.ExceSQL("update t_base_device set f_loop ='" + bindingdevice + "' where F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim()));
|
||
|
|
string sql = CommonSql + " WHERE " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex and F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim());
|
||
|
|
ds = dbo.ExceSQL(sql);
|
||
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
MessageBox.Show("JIT�Ŀ�������λ��������ť��Ϣ�����ɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btSaveWIAPause_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
string devIndex = this.tbDeviceIndex3.Text ;
|
||
|
|
if (MessageBox.Show("��ȷ��Ҫ����WIA��ͣ���ϵ�������ť��Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(devIndex) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸����ֻ�����������֣�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex3.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT F_DeviceIndex FROM T_Base_Device where F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim()));
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count <= 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸���������ݿ��в����ڣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex3.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
ds.Clear();
|
||
|
|
dv.Dispose();
|
||
|
|
string bindingdevice = this.cbPauseWeighButton.SelectedValue.ToString();
|
||
|
|
dbo.ExceSQL("update t_base_device set f_pause ='" + bindingdevice + "' where F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim()));
|
||
|
|
string sql = CommonSql + " WHERE " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex and F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim());
|
||
|
|
ds = dbo.ExceSQL(sql);
|
||
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
MessageBox.Show("WIA��ͣ���ϵ�������ť��Ϣ�����ɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void btSaveContainer_Click(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
string devIndex = this.tbDeviceIndex4.Text;
|
||
|
|
if (MessageBox.Show("��ȷ��Ҫ����JIT/WIA�������ͼ���������Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
||
|
|
{
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
if (Information.IsNumeric(devIndex) == false)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸����ֻ�����������֣�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex4.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
DataSet ds = dbo.ExceSQL("SELECT F_DeviceIndex FROM T_Base_Device where F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim()));
|
||
|
|
DataView dv = ds.Tables[0].DefaultView;
|
||
|
|
if (dv.Count <= 0)
|
||
|
|
{
|
||
|
|
MessageBox.Show("���豸���������ݿ��в����ڣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
||
|
|
tbDeviceIndex4.Focus();
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
ds.Clear();
|
||
|
|
dv.Dispose();
|
||
|
|
string bindingdevice = this.cbContainerType.SelectedValue.ToString();
|
||
|
|
dbo.ExceSQL("update t_base_device set f_containertype ='" + bindingdevice + "' where F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim()));
|
||
|
|
string sql = CommonSql + " WHERE " +
|
||
|
|
" T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex and F_DeviceIndex=" + Convert.ToInt32(devIndex.Trim());
|
||
|
|
ds = dbo.ExceSQL(sql);
|
||
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
||
|
|
MessageBox.Show("JIT/WIA�������ͼ���������Ϣ�����ɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void cbLoopButton_SelectedIndexChanged(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
private void cbPauseWeighButton_SelectedIndexChanged(object sender, EventArgs e)
|
||
|
|
{
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|