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.
283 lines
11 KiB
283 lines
11 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Text;
|
|
using System.Windows.Forms;
|
|
using Microsoft.VisualBasic;
|
|
using DBFactory;
|
|
|
|
namespace SystemConfig
|
|
{
|
|
public partial class FrmRGVGateEdit : Form
|
|
{
|
|
bool IfUpdate = false;
|
|
DBOperator dbo = CStaticClass.dbo;
|
|
private static FrmRGVGateEdit _formInstance;
|
|
|
|
public static FrmRGVGateEdit FormInstance
|
|
{
|
|
get
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmRGVGateEdit();
|
|
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
public FrmRGVGateEdit()
|
|
{
|
|
InitializeComponent();
|
|
_formInstance = this;
|
|
}
|
|
|
|
private void btLaneGateDeviceIndex_Click(object sender, EventArgs e)
|
|
{
|
|
FrmDeviceEdit.FormInstance.LaneGateDeviceIndex = true;
|
|
FrmDeviceEdit.FormInstance.LaneIndex = false;
|
|
FrmDeviceEdit.FormInstance.IsSelected = true;
|
|
FrmDeviceEdit.FormInstance.ShowDialog();
|
|
}
|
|
|
|
private void btLaneIndex_Click(object sender, EventArgs e)
|
|
{
|
|
FrmDeviceEdit.FormInstance.LaneIndex = true;
|
|
FrmDeviceEdit.FormInstance.LaneGateDeviceIndex = false;
|
|
FrmDeviceEdit.FormInstance.IsSelected = true;
|
|
FrmDeviceEdit.FormInstance.ShowDialog();
|
|
}
|
|
|
|
private void btNull_Click(object sender, EventArgs e)
|
|
{
|
|
this.tbAGVGateDeviceIndex.Text = "";
|
|
this.tbChannelsIndex.Text = "";
|
|
this.tbTop.Text = "";
|
|
this.tbLeft.Text = "";
|
|
this.tbAddress.Text = "";
|
|
this.chbInput.Checked = false;
|
|
this.chbOutput.Checked = false;
|
|
|
|
}
|
|
|
|
private void btBack_Click(object sender, EventArgs e)
|
|
{
|
|
this.Close();
|
|
}
|
|
|
|
private void btSave_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("��ȷ��Ҫ����RGVվ����Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
|
|
if (Information.IsNumeric(this.tbAGVGateDeviceIndex.Text) == false)
|
|
{
|
|
MessageBox.Show("RGVվ�㴦��Ӧ���豸����ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
tbAGVGateDeviceIndex.Focus();
|
|
return;
|
|
}
|
|
if (Information.IsNumeric(this.tbChannelsIndex.Text) == false)
|
|
{
|
|
MessageBox.Show("RGVͨ��ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbChannelsIndex.Focus();
|
|
return;
|
|
}
|
|
if (Information.IsNumeric(this.tbTop.Text) == false)
|
|
{
|
|
MessageBox.Show("RGVվ��Y����ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbTop.Focus();
|
|
return;
|
|
}
|
|
if (Information.IsNumeric(this.tbLeft.Text) == false)
|
|
{
|
|
MessageBox.Show("RGVվ��X����ֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbLeft.Focus();
|
|
return;
|
|
}
|
|
if (Information.IsNumeric(this.tbAddress.Text) == false)
|
|
{
|
|
MessageBox.Show("RGVվ����ַֻ�����������ͣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbAddress.Focus();
|
|
return;
|
|
}
|
|
if ((this.chbInput.Checked == false) && (this.chbOutput.Checked == false))
|
|
{
|
|
MessageBox.Show("����ѡ�����dz����ڡ��͡��������ڡ���", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
try
|
|
{
|
|
|
|
char inp, outp;
|
|
if (this.chbInput.Checked == true)
|
|
{
|
|
inp = '1';
|
|
}
|
|
else
|
|
{
|
|
inp = '0';
|
|
}
|
|
if (this.chbOutput.Checked == true)
|
|
{
|
|
outp = '1';
|
|
}
|
|
else
|
|
{
|
|
outp = '0';
|
|
}
|
|
string sql = "SELECT F_RGVGateDeviceIndex FROM T_Base_Rgv_Gate where F_RGVGateDeviceIndex=" + Convert.ToInt32(this.tbAGVGateDeviceIndex.Text);
|
|
DataSet ds = dbo.ExceSQL(sql);
|
|
if ((ds.Tables[0].DefaultView.Count > 0))
|
|
{
|
|
if (IfUpdate == false)
|
|
{
|
|
MessageBox.Show("RGVվ�㴦��Ӧ���豸���������ݿ��Ѿ����ڣ��벻Ҫ�ظ�¼�����ݣ�", "��������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbAGVGateDeviceIndex.Focus();
|
|
return;
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
IfUpdate = false;
|
|
}
|
|
ds.Clear();
|
|
if (IfUpdate == true)
|
|
{
|
|
sql = "UPDATE T_Base_RGV_Gate SET F_ChannelsIndex =" + Convert.ToInt32(this.tbChannelsIndex.Text)
|
|
+ ", F_Address =" + tbAddress.Text + ",F_Top=" + tbTop.Text + ",F_Left=" + tbLeft.Text + ", F_Input =" + inp +
|
|
", F_Output =" + outp + " where F_RGVGateDeviceIndex=" + Convert.ToInt32(this.tbAGVGateDeviceIndex.Text);
|
|
dbo.ExceSQL(sql);
|
|
MessageBox.Show("RGVվ����Ϣ�ijɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
IfUpdate = false;
|
|
}
|
|
else
|
|
{
|
|
|
|
sql = "INSERT INTO T_Base_RGV_Gate(F_RGVGateDeviceIndex, F_ChannelsIndex, F_Address, F_Input, F_Output,F_Top,F_Left)VALUES" +
|
|
" (" + Convert.ToInt32(this.tbAGVGateDeviceIndex.Text) + "," + Convert.ToInt32(this.tbChannelsIndex.Text)
|
|
+ "," + tbAddress.Text + "," + inp + "," + outp + "," + tbTop.Text + "," + tbLeft.Text + ")";
|
|
dbo.ExceSQL(sql);
|
|
MessageBox.Show("RGVվ����Ϣ¼���ɹ���", "������ʾ��", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
}
|
|
sql = "SELECT F_RGVGateDeviceIndex AS RGVվ�㴦��Ӧ���豸����,F_ChannelsIndex AS RGVͨ������, F_Address AS " +
|
|
" RGVվ����ַ,F_Input AS ��������,F_Output AS �dz�����,F_Top as վ��Y����,F_Left as վ��X���� FROM T_Base_RGV_Gate where " +
|
|
" F_RGVGateDeviceIndex=" + Convert.ToInt32(this.tbAGVGateDeviceIndex.Text);
|
|
ds = dbo.ExceSQL(sql);
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView ;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
|
|
private void btNullQuery_Click(object sender, EventArgs e)
|
|
{
|
|
this.tbContent.Text = "";
|
|
this.cbField.Text = "";
|
|
}
|
|
|
|
private void btQuery_Click(object sender, EventArgs e)
|
|
{
|
|
try
|
|
{
|
|
string df, sql;
|
|
if (this.tbContent.Text.Trim() == "") return;
|
|
if (this.cbField.Text == "RGVͨ������")
|
|
{
|
|
df = "F_ChannelsIndex";
|
|
}
|
|
else
|
|
{
|
|
df = "F_RGVGateDeviceIndex";
|
|
}
|
|
sql = "SELECT F_RGVGateDeviceIndex AS RGVվ�㴦��Ӧ���豸����,F_ChannelsIndex AS RGVͨ������,F_Address AS " +
|
|
" RGVվ����ַ,F_Input AS ��������,F_Output AS �dz�����,F_Top as վ��Y����,F_Left as վ��X���� FROM T_Base_RGV_Gate where " +
|
|
df + "= " + Convert.ToInt32(this.tbContent.Text);
|
|
DataSet ds = dbo.ExceSQL(sql);
|
|
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;
|
|
}
|
|
char[] cc = new char[1] { ';' };
|
|
string[] spl;
|
|
spl = this.dataGridView1.CurrentRow.Cells[0].Value.ToString().Split(cc);
|
|
this.tabControl1.SelectTab("tabPage1");
|
|
|
|
this.tbAGVGateDeviceIndex.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "";
|
|
this.tbChannelsIndex.Text = this.dataGridView1.CurrentRow.Cells[1].Value.ToString() + "";
|
|
this.tbAddress.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString() + "";
|
|
if (this.dataGridView1.CurrentRow.Cells[3].Value.ToString() == "1")
|
|
{
|
|
this.chbInput.Checked = true;
|
|
}
|
|
else
|
|
{
|
|
this.chbInput.Checked = false;
|
|
}
|
|
if (this.dataGridView1.CurrentRow.Cells[4].Value.ToString() == "1")
|
|
{
|
|
this.chbOutput.Checked = true;
|
|
}
|
|
else
|
|
{
|
|
this.chbOutput.Checked = false;
|
|
}
|
|
this.tbTop.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString() + "";
|
|
this.tbLeft.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString() + "";
|
|
IfUpdate = true;
|
|
}
|
|
|
|
private void tsmDel_Click(object sender, EventArgs e)
|
|
{
|
|
if (dataGridView1.RowCount <= 0)
|
|
{
|
|
return;
|
|
}
|
|
if (MessageBox.Show("��ȷ��Ҫɾ��ѡ���еġ�RGVվ�㣺" + this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "����Ϣ����", "������ʾ��", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
dbo.ExceSQL("delete from T_Base_Rgv_Gate where F_RGVGateDeviceIndex =" + Convert.ToInt32(this.dataGridView1.CurrentRow.Cells[0].Value));
|
|
button2_Click(sender, e);
|
|
}
|
|
|
|
private void button1_Click(object sender, EventArgs e)
|
|
{
|
|
IfUpdate = false;
|
|
}
|
|
|
|
private void button2_Click(object sender, EventArgs e)
|
|
{
|
|
string sql = "SELECT F_RGVGateDeviceIndex AS RGVվ�㴦��Ӧ���豸����,F_ChannelsIndex AS RGVͨ������,F_Address AS " +
|
|
" RGVվ����ַ,F_Input AS ��������,F_Output AS �dz�����,F_Top as վ��Y����,F_Left as վ��X���� FROM T_Base_RGV_Gate " ;
|
|
DataSet ds = dbo.ExceSQL(sql);
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
}
|