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.
345 lines
13 KiB
345 lines
13 KiB
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;
|
|
namespace SystemConfig
|
|
{
|
|
public partial class FrmRouteEdit : Form
|
|
{
|
|
bool _IfUpdate = false;
|
|
DBOperator dbo = CStaticClass.dbo;
|
|
DBOperator dboMan = new DBOperator("ManConnString", "ManDBFactory");
|
|
private static FrmRouteEdit _formInstance;
|
|
string CommSQL = "SELECT F_RouteID AS 路径索引, F_RouteKind AS 路径类型," +
|
|
" F_RouteName AS 路径名称,F_StartDevice as 起点设备,F_EndDevice as 终点设备,"+
|
|
"F_OutsideAltDevice as 巷道外可变向设备索引,F_InsideAltDevice as 巷道内可变向设备索引,f_status as 路径状态 FROM T_Base_Route ";
|
|
public static FrmRouteEdit FormInstance
|
|
{
|
|
get
|
|
{
|
|
if (_formInstance==null)
|
|
{
|
|
_formInstance = new FrmRouteEdit();
|
|
}
|
|
return FrmRouteEdit._formInstance;
|
|
}
|
|
set { FrmRouteEdit._formInstance = value; }
|
|
}
|
|
public FrmRouteEdit()
|
|
{
|
|
InitializeComponent();
|
|
_formInstance = this;
|
|
dbo.Open();
|
|
DataSet ds1;
|
|
ds1 = dbo.ExceSQL("select * from t_base_device");
|
|
if (ds1.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
//cbstartposition
|
|
cbstartposition.ValueMember = "F_DeviceIndex";
|
|
cbstartposition.DisplayMember = "F_DeviceName";
|
|
cbstartposition.DataSource = ds1.Tables[0].DefaultView;
|
|
|
|
}
|
|
DataSet ds2;
|
|
ds2 = dbo.ExceSQL("select * from t_base_device");
|
|
if (ds2.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
|
|
//cbendposition
|
|
cbendposition.ValueMember = "F_DeviceIndex";
|
|
cbendposition.DisplayMember = "F_DeviceName";
|
|
cbendposition.DataSource = ds2.Tables[0].DefaultView;
|
|
}
|
|
DataSet ds3;
|
|
ds3 = dbo.ExceSQL("select * from t_base_device where F_DeviceKindIndex<=10");
|
|
if (ds3.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
|
|
//comboBox1
|
|
comboBox1.ValueMember = "F_DeviceIndex";
|
|
comboBox1.DisplayMember = "F_DeviceName";
|
|
comboBox1.DataSource = ds3.Tables[0].DefaultView;
|
|
}
|
|
}
|
|
|
|
private void btNull_Click(object sender, EventArgs e)
|
|
{
|
|
this.tbRouteKindIndex.Text = "";
|
|
this.tbRouteName.Text = "";
|
|
this.cbRouteKind.SelectedIndex=2;
|
|
this.cbstartposition.Text = "";
|
|
this.cbendposition.Text="";
|
|
}
|
|
|
|
private void btQuery_Click(object sender, EventArgs e)
|
|
{
|
|
if (tbContent.Text.Trim() == "") return;
|
|
try
|
|
{
|
|
string df;
|
|
string sql = "";
|
|
switch (this.cbField.Text)
|
|
{
|
|
|
|
|
|
case "路径索引":
|
|
df = "F_RouteID";
|
|
|
|
break;
|
|
case "路径类型":
|
|
df = "F_RouteKind";
|
|
break;
|
|
|
|
case "路径名称":
|
|
df = "F_RouteName";
|
|
break;
|
|
default:
|
|
return;
|
|
}
|
|
sql =CommSQL+ " WHERE " + df + " = '" + this.tbContent.Text + "'";
|
|
DataSet 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.cbField.Text = "";
|
|
this.tbContent.Text = "";
|
|
}
|
|
|
|
private void btSave_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("您确认要保存路径信息吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
|
|
if (Information.IsNumeric(this.tbRouteKindIndex.Text) == false)
|
|
{
|
|
MessageBox.Show("路径索引只能是数字类型！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbRouteKindIndex.Focus();
|
|
return;
|
|
}
|
|
if (this.cbRouteKind.Text.Trim().Length ==0)
|
|
{
|
|
MessageBox.Show("路径类型不能输入空值！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbRouteKind.Focus();
|
|
return;
|
|
}
|
|
|
|
if (this.tbRouteName.Text.Trim().Length == 0)
|
|
{
|
|
MessageBox.Show("路径名称不能输入空值！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbRouteName.Focus();
|
|
return;
|
|
}
|
|
if (this.cbstartposition.Text.Trim().Length == 0)
|
|
{
|
|
MessageBox.Show("起点设备不能输入空值！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbstartposition.Focus();
|
|
return;
|
|
}
|
|
if (this.cbendposition.Text.Trim().Length == 0)
|
|
{
|
|
MessageBox.Show("终点设备不能输入空值！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbendposition.Focus();
|
|
return;
|
|
}
|
|
|
|
|
|
|
|
int ki;
|
|
if (this.cbRouteKind.Text == "入库")
|
|
{
|
|
ki = 1;
|
|
}
|
|
else if (this.cbRouteKind.Text == "出库")
|
|
{
|
|
ki = 2;
|
|
}
|
|
else if (this.cbRouteKind.Text == "倒库")//
|
|
{
|
|
if ((tbInsideAltDevice.Text == "0") && (tbOutsideAltDevice.Text == "0"))
|
|
{
|
|
MessageBox.Show("路径类型是“倒库”时，必须输入一个合法的出入库可变更方向的设备，例如ＲＧＶ或者堆垛机！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbInsideAltDevice.Focus();
|
|
return;
|
|
}
|
|
ki = 3;
|
|
}
|
|
else if (this.cbRouteKind.Text == "库外货物搬运")//
|
|
{
|
|
ki = 9;
|
|
}
|
|
else
|
|
{
|
|
MessageBox.Show("路径类型不是允许范围值！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbRouteKind.Focus();
|
|
return;
|
|
}
|
|
string sql;
|
|
DataSet ds;
|
|
if (_IfUpdate == true)
|
|
{//20100208
|
|
sql = "update T_Base_Route set F_RouteKind=" + ki + ",F_StartDevice=" + Convert.ToInt32(this.cbstartposition.SelectedValue) + ",F_EndDevice=" + Convert.ToInt32(this.cbendposition.SelectedValue) + "," +
|
|
" F_RouteName='" + this.tbRouteName.Text + "',F_InsideAltDevice=" + tbInsideAltDevice.Text + ",F_OutsideAltDevice=" + tbOutsideAltDevice.Text + ",f_status="+tbStatus.Text+" where F_RouteID=" + Convert.ToInt32(this.tbRouteKindIndex.Text);
|
|
dbo.ExceSQL(sql);
|
|
MessageBox.Show("路径信息修改成功！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
_IfUpdate = false;
|
|
}
|
|
else
|
|
{
|
|
sql = CommSQL + " WHERE F_RouteID =" + Convert.ToInt32(this.tbRouteKindIndex.Text);
|
|
ds = dbo.ExceSQL(sql);
|
|
if (ds.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
MessageBox.Show("您输入的路径索引重复！", "误操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.tbRouteKindIndex.Focus();
|
|
return;
|
|
}
|
|
ds.Clear();
|
|
sql = "INSERT INTO T_Base_Route (F_RouteID,F_RouteKind," +
|
|
"F_RouteName,F_StartDevice,F_EndDevice,F_InsideAltDevice,F_OutsideAltDevice,f_status)VALUES (" + Convert.ToInt32(this.tbRouteKindIndex.Text) +
|
|
"," + ki + ",'" + this.tbRouteName.Text + "'," + Convert.ToInt32(this.cbstartposition.SelectedValue) + "," +
|
|
Convert.ToInt32(this.cbendposition.SelectedValue) + ","+tbInsideAltDevice.Text+","+tbOutsideAltDevice.Text+","+tbStatus.Text+")";
|
|
dbo.ExceSQL(sql);
|
|
MessageBox.Show("路径信息录入成功！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Information);
|
|
}
|
|
|
|
sql = CommSQL + " WHERE F_RouteID =" + Convert.ToInt32(this.tbRouteKindIndex.Text);
|
|
ds = dbo.ExceSQL(sql);
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
|
}
|
|
|
|
private void btBack_Click(object sender, EventArgs e)
|
|
{
|
|
this.Close();
|
|
}
|
|
|
|
private void btSelectOK_Click(object sender, EventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
private void tsmEdit_Click(object sender, EventArgs e)
|
|
{
|
|
if (dataGridView1.RowCount <= 0)
|
|
{
|
|
return;
|
|
}
|
|
|
|
this.tabControl1.SelectTab("tabPage1");
|
|
this.tbRouteKindIndex.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "";
|
|
if (this.dataGridView1.CurrentRow.Cells[1].Value.ToString() == "1")
|
|
{
|
|
this.cbRouteKind.SelectedIndex = 0;
|
|
}
|
|
else if (this.dataGridView1.CurrentRow.Cells[1].Value.ToString() == "2")
|
|
{
|
|
this.cbRouteKind.SelectedIndex = 1;
|
|
}
|
|
else
|
|
{
|
|
this.cbRouteKind.SelectedIndex = 2;
|
|
}
|
|
this.tbRouteName.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString() + "";
|
|
this.cbstartposition.SelectedValue = this.dataGridView1.CurrentRow.Cells[3].Value.ToString() + "";
|
|
this.cbendposition.SelectedValue = this.dataGridView1.CurrentRow.Cells[4].Value.ToString() + "";
|
|
//20100208
|
|
this.tbOutsideAltDevice.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString() + "";
|
|
this.tbInsideAltDevice.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString() + "";
|
|
this.tbStatus.Text = this.dataGridView1.CurrentRow.Cells[7].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_Route where F_RouteID =" + 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 = CommSQL + "";
|
|
DataSet ds = dbo.ExceSQL(sql);
|
|
this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
|
|
}
|
|
|
|
private void FrmRouteEdit_Load(object sender, EventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
private void button3_Click(object sender, EventArgs e)
|
|
{
|
|
//20100208设置设备所属路径不可用
|
|
if (MessageBox.Show("您确认要设置设备"+this.comboBox1.SelectedValue.ToString()+"所属路径状态不可用吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
try
|
|
{
|
|
DataView dv = dbo.ExceSQL("select distinct F_RouteID from T_Base_Route_Device where F_DeviceIndex=" + this.comboBox1.SelectedValue).Tables[0].DefaultView;
|
|
for (int i = 0; i < dv.Count; i++)
|
|
{
|
|
dbo.ExecuteSql("update t_base_route set F_Status=0 where f_routeid=" + dv[i]["F_RouteID"]);
|
|
dboMan.ExceSQL("update IO_ROUTEPATH set FSTATUS=0 where FID=" + dv[i]["F_RouteID"] );
|
|
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
|
|
}
|
|
|
|
private void button4_Click(object sender, EventArgs e)
|
|
{
|
|
//20100208设置设备所属路径可用
|
|
if (MessageBox.Show("您确认要设置设备" + this.comboBox1.SelectedValue.ToString() + "所属路径状态可用吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
try
|
|
{
|
|
DataView dv = dbo.ExceSQL("select distinct F_RouteID from T_Base_Route_Device where F_DeviceIndex=" + this.comboBox1.SelectedValue).Tables[0].DefaultView;
|
|
for (int i = 0; i < dv.Count; i++)
|
|
{
|
|
dbo.ExecuteSql("update t_base_route set F_Status=1 where f_routeid=" + dv[i]["F_RouteID"]);
|
|
dboMan.ExceSQL("update IO_ROUTEPATH set FSTATUS=1 where FID=" + dv[i]["F_RouteID"] );
|
|
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
}
|
|
}
|
|
}
|