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("设备信息修改成功！", "操作提示：", 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) { } } }