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.
480 lines
20 KiB
480 lines
20 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;
|
|
namespace SystemConfig
|
|
{
|
|
public partial class FrmRouteDeviceEdit : Form
|
|
{
|
|
DBOperator dbo = CStaticClass.dbo;
|
|
private static FrmRouteDeviceEdit _formInstance;
|
|
|
|
public static FrmRouteDeviceEdit FormInstance
|
|
{
|
|
get
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmRouteDeviceEdit();
|
|
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
public FrmRouteDeviceEdit()
|
|
{
|
|
InitializeComponent();
|
|
_formInstance = this;
|
|
DataView dv = dbo.ExceSQL("select * from T_Base_Route ").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
this.comboBox1.ValueMember = "F_RouteID";
|
|
this.comboBox1.DisplayMember = "F_RouteName";
|
|
this.comboBox1.DataSource = dv;
|
|
|
|
}
|
|
}
|
|
|
|
private void button1_Click(object sender, EventArgs e)
|
|
{
|
|
DataView dv = dbo.ExceSQL("SELECT F_StartDevice, F_EndDevice,F_RouteKind FROM T_Base_Route where F_RouteID=" + this.comboBox1.SelectedValue).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
List<List<int>> devs = SearchNextDevices(Convert.ToInt32(dv[0]["F_StartDevice"]), Convert.ToInt32(dv[0]["F_EndDevice"]), dv[0]["F_RouteKind"].ToString());
|
|
if (devs.Count > 0)
|
|
{
|
|
for (int i = 0; i <devs.Count; i++)
|
|
{
|
|
|
|
List<int> devline = devs[i];
|
|
ListViewItem lvi = new ListViewItem(this.comboBox1.SelectedValue.ToString());
|
|
lvi.SubItems.Add(this.comboBox1.Text + "的路径:" + (i + 1).ToString());
|
|
for (int j = (devline.Count - 1); j >= 0; j--)
|
|
{
|
|
if (listView1.Columns.Count <= devline.Count+1)
|
|
{
|
|
for (int kk = 0; kk <= (devline.Count - listView1.Columns.Count+2); kk++)
|
|
{
|
|
listView1.Columns.Add("columnsHeader");
|
|
}
|
|
}
|
|
lvi.SubItems.Add(devline[j].ToString());
|
|
}
|
|
listView1.Items.Add(lvi);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
List< List<int>> SearchNextDevices(int startdev, int enddev, string RouteKind)
|
|
{
|
|
List<List<int>> rets = new List<List<int>>();
|
|
List<List<int>> rets0 = new List<List<int>>();
|
|
List<List<int>> rets1 = new List<List<int>>();
|
|
switch (RouteKind)
|
|
{
|
|
case "1"://入库，只在入库的方向F_InputNextDevice查找设备
|
|
rets = RecursionDevices(startdev, enddev, "F_InputNextDevice");
|
|
break;
|
|
case "2"://出库，只出库的方向F_OutputNextDevice查找设备
|
|
rets = RecursionDevices(startdev, enddev, "F_OutputNextDevice");
|
|
///↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓ ZCY ↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
|
|
// 在出库的路径上加入虚拟设备 17001
|
|
|
|
List<int> rss = rets[0];
|
|
rss.Insert(0, 17001);
|
|
///↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑ ZCY ↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑
|
|
break;
|
|
case "3"://移库，遇到堆垛机、RGV、AGV等设备要考虑转换设备入库F_InputNextDevice和出库F_OutputNextDevice方向属性
|
|
case "4"://移库，遇到堆垛机、RGV、AGV等设备要考虑转换设备入库F_InputNextDevice和出库F_OutputNextDevice方向属性
|
|
#region 移库
|
|
|
|
if (checkBox1.Checked == true)
|
|
{
|
|
if (comboBox2.Text !=null)
|
|
{
|
|
rets0 = RecursionDevices(startdev, Convert.ToInt32(comboBox2.Text), "F_InputNextDevice");
|
|
if (rets0.Count > 0)
|
|
{
|
|
rets1 = RecursionDevices(Convert.ToInt32(comboBox2.Text), enddev, "F_OutputNextDevice");
|
|
if (rets1.Count > 0)
|
|
{
|
|
for (int i = 0; i < rets1.Count; i++)
|
|
{
|
|
List<int> rets1line = rets1[i];
|
|
for (int j = 0; j < rets0.Count; j++)
|
|
{
|
|
List<int> rets0line = rets0[j];
|
|
for (int k = 0; k < rets0line.Count; k++)
|
|
{
|
|
int rets0element = rets0line[k];
|
|
if (rets1line.Contains(rets0element) == false)
|
|
{
|
|
rets1line.Add(rets0element);
|
|
}
|
|
}
|
|
}
|
|
rets.Add(rets1line);
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
rets0 = RecursionDevices(startdev, Convert.ToInt32(comboBox2.Text), "F_OutputNextDevice");
|
|
if (rets0.Count > 0)
|
|
{
|
|
rets1 = RecursionDevices(Convert.ToInt32(comboBox2.Text), enddev, "F_InputNextDevice");
|
|
if (rets1.Count > 0)
|
|
{
|
|
for (int i = 0; i < rets1.Count; i++)
|
|
{
|
|
List<int> rets1line = rets1[i];
|
|
for (int j = 0; j < rets0.Count; j++)
|
|
{
|
|
List<int> rets0line = rets0[j];
|
|
for (int k = 0; k < rets0line.Count; k++)
|
|
{
|
|
int rets0element = rets0line[k];
|
|
if (rets1line.Contains(rets0element) == false)
|
|
{
|
|
rets1line.Add(rets0element);
|
|
}
|
|
}
|
|
}
|
|
rets.Add(rets1line);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
#endregion
|
|
break;
|
|
|
|
default:
|
|
break;
|
|
|
|
}
|
|
return rets;
|
|
}
|
|
/// <summary>
|
|
/// 递归形成List< List<int>>的倒序的设备串集合的集合
|
|
/// </summary>
|
|
/// <param name="startdev"></param>
|
|
/// <param name="enddev"></param>
|
|
/// <param name="IONextDevice"></param>
|
|
/// <returns></returns>
|
|
List< List<int>> RecursionDevices(int startdev, int enddev, string IONextDevice)
|
|
{
|
|
string sql = "";
|
|
DataView dv;
|
|
string nextdev = "";
|
|
string[] spl;
|
|
char[] cc = new char[1] { ';' };
|
|
List<List<int>> routedevs = new List<List<int>>();
|
|
sql = "SELECT " + IONextDevice + " FROM T_Base_Device where F_DeviceIndex=" + startdev;
|
|
dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
nextdev = dv[0][IONextDevice].ToString();
|
|
|
|
if (nextdev.Length > 0)
|
|
{
|
|
spl = nextdev.Split(cc);
|
|
for (int i = spl.GetLowerBound(0); i <= spl.GetUpperBound(0);i++ )
|
|
{
|
|
|
|
List< List<int>> rs = RecursionSingle(Convert.ToInt32( spl[i]), enddev, IONextDevice);
|
|
if (rs.Count > 0)
|
|
{
|
|
//返回多条路经设备集合的集合
|
|
List<int> rss=new List<int>();
|
|
for (int ii = 0; ii < rs.Count; ii++)
|
|
{
|
|
rss = rs[ii];
|
|
if (rss.Contains(Convert.ToInt32(spl[i])) == false)
|
|
{
|
|
rss.Add(Convert.ToInt32(spl[i]));
|
|
}
|
|
|
|
if (rss.Contains(startdev) == false)
|
|
{
|
|
rss.Add(startdev);
|
|
}
|
|
if (routedevs.Contains(rss) == false)
|
|
{
|
|
routedevs.Add(rss);
|
|
}
|
|
}
|
|
//Predicate<List<int>> FindValue = delegate(List<int> obj) { return obj.Contains(Convert.ToInt32(spl[i])); };
|
|
|
|
|
|
|
|
}
|
|
|
|
}
|
|
|
|
return routedevs;
|
|
//返回值
|
|
|
|
}
|
|
|
|
}
|
|
return routedevs;
|
|
//返回值
|
|
}
|
|
List< List<int>> RecursionSingle(int startdev, int enddev, string IONextDevice)
|
|
{
|
|
|
|
char[] cc = new char[1] { ';' };
|
|
List<int> routedevs = new List<int>();
|
|
List<List<int>> mutiRoute = new List<List<int>>();
|
|
|
|
#region 递归获得多条路径详细设备集合
|
|
|
|
if (startdev == enddev)//找到了终点设备
|
|
{
|
|
|
|
if (routedevs.Contains(enddev) == false)
|
|
{
|
|
routedevs.Add(enddev);
|
|
}
|
|
if (routedevs.Contains(startdev) == false)
|
|
{
|
|
routedevs.Add(startdev);
|
|
}
|
|
mutiRoute.Add(routedevs);
|
|
return mutiRoute;
|
|
}
|
|
else//接着找
|
|
{
|
|
List< List<int>> mutireturndevs = RecursionDevices(startdev, enddev, IONextDevice);
|
|
if (mutireturndevs.Count > 0)
|
|
{
|
|
for (int k = 0; k < mutireturndevs.Count; k++)
|
|
{
|
|
//List<int> returndevs = mutireturndevs[k];
|
|
//if (returndevs.Count > 0)
|
|
//{
|
|
// for (int j = 0; j < returndevs.Count; j++)
|
|
// {
|
|
|
|
// if (routedevs.Contains(returndevs[j]) == false)
|
|
// {
|
|
// routedevs.Add(returndevs[j]);
|
|
|
|
// }
|
|
|
|
// }
|
|
// if (routedevs.Contains(startdev) == false)
|
|
// {
|
|
// routedevs.Add(startdev);
|
|
|
|
// }
|
|
// mutiRoute.Add(routedevs);
|
|
|
|
//}
|
|
if (mutireturndevs[k].Contains(startdev) == false)
|
|
{
|
|
mutireturndevs[k].Add(startdev);
|
|
|
|
}
|
|
mutiRoute.Add(mutireturndevs[k]);
|
|
}
|
|
}
|
|
return mutiRoute;
|
|
|
|
}
|
|
#endregion
|
|
}
|
|
|
|
private void button2_Click(object sender, EventArgs e)
|
|
{
|
|
|
|
for (int i = 0; i < listView1.Items.Count; i++)
|
|
{
|
|
ListViewItem lvi = listView1.Items[i];
|
|
if (lvi.Checked == true)
|
|
{
|
|
//增加对F_RouteIDSub值的判断：
|
|
//如果表中存在F_RouteID那么F_RouteIDSub的取值就是对应的F_RouteIDSub+1
|
|
//否则，F_RouteIDSub的值就是F_RouteID+"001"
|
|
int routeIDSub = GetRouteIDSub(Convert.ToInt32( lvi.Text));
|
|
int sn = 0;
|
|
for (int j = 2; j < lvi.SubItems.Count; j++)
|
|
{
|
|
int max = GetMaxRouteDeviceIndex();
|
|
sn = sn + 1;
|
|
string sql = "INSERT INTO T_Base_Route_Device "+
|
|
"(F_RouteDeviceIndex, F_RouteID, F_DeviceIndex, F_SerialNumber,F_RouteIDSub)VALUES " +
|
|
"(" + max + "," + lvi.Text + "," + lvi.SubItems[j].Text + "," + sn + "," + routeIDSub + ")";
|
|
dbo.ExceSQL(sql);
|
|
|
|
}
|
|
}
|
|
}
|
|
}
|
|
int GetMaxRouteDeviceIndex()
|
|
{
|
|
DataView dv = dbo.ExceSQL("SELECT MAX(F_RouteDeviceIndex) AS MaxIndex FROM T_Base_Route_Device").Tables[0].DefaultView; ;
|
|
if (dv.Count > 0)
|
|
{
|
|
if (dv[0]["MaxIndex"].ToString().Length > 0)
|
|
{
|
|
return (Convert.ToInt32(dv[0]["MaxIndex"]) + 1);
|
|
}
|
|
else
|
|
{
|
|
return 1;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
return 1;
|
|
}
|
|
}
|
|
|
|
int GetRouteIDSub(int routeID)
|
|
{
|
|
DataView dv = dbo.ExceSQL("SELECT F_RouteIDSub FROM T_Base_Route_Device where F_RouteID=" + routeID + " order by F_RouteIDSub desc").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
return (Convert.ToInt32(dv[0]["F_RouteIDSub"]) + 1);
|
|
}
|
|
else
|
|
{
|
|
return Convert.ToInt32 (routeID.ToString() + "001");
|
|
}
|
|
}
|
|
|
|
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if (comboBox1.SelectedValue.ToString().Length <= 0) return;
|
|
comboBox2.Items.Clear();
|
|
DataView dv = dbo.ExceSQL("SELECT F_OutsideAltDevice, F_InsideAltDevice FROM T_Base_Route WHERE (F_RouteID = " + comboBox1.SelectedValue.ToString() + ")").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
if (dv[0]["F_OutsideAltDevice"].ToString().Length > 0)
|
|
{
|
|
comboBox2.Items.Add(dv[0]["F_OutsideAltDevice"]);
|
|
}
|
|
if (dv[0]["F_InsideAltDevice"].ToString().Length > 0)
|
|
{
|
|
comboBox2.Items.Add(dv[0]["F_InsideAltDevice"]);
|
|
}
|
|
}
|
|
}
|
|
|
|
private void button3_Click(object sender, EventArgs e)
|
|
{
|
|
listView1.Items.Clear();
|
|
}
|
|
|
|
private void button7_Click(object sender, EventArgs e)
|
|
{
|
|
DataView dv = dbo.ExceSQL("SELECT F_routeID,f_routename, F_StartDevice, F_EndDevice,F_RouteKind FROM T_Base_Route order by F_routeID asc").Tables[0].DefaultView;
|
|
for(int k=0;k<dv.Count;k++)
|
|
{
|
|
List<List<int>> devs = SearchNextDevices(Convert.ToInt32(dv[k]["F_StartDevice"]), Convert.ToInt32(dv[k]["F_EndDevice"]), dv[k]["F_RouteKind"].ToString());
|
|
if (devs.Count > 0)
|
|
{
|
|
for (int i = 0; i < devs.Count; i++)
|
|
{
|
|
List<int> devline = devs[i];
|
|
ListViewItem lvi = new ListViewItem(dv[k]["F_routeID"].ToString());
|
|
lvi.SubItems.Add(dv[k]["F_routeID"].ToString() + "的路径:" + (i + 1).ToString());
|
|
for (int j = (devline.Count - 1); j >= 0; j--)
|
|
{
|
|
if (listView1.Columns.Count <= devline.Count + 1)
|
|
{
|
|
for (int kk = 0; kk <= (devline.Count - listView1.Columns.Count + 2); kk++)
|
|
{
|
|
listView1.Columns.Add("columnsHeader");
|
|
}
|
|
}
|
|
lvi.SubItems.Add(devline[j].ToString());
|
|
}
|
|
listView1.Items.Add(lvi);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
|
|
}
|
|
|
|
}
|
|
}
|
|
|
|
private void button5_Click(object sender, EventArgs e)
|
|
{
|
|
for (int i = 0; i < listView1.Items.Count; i++)
|
|
{
|
|
listView1.Items[i].Checked = true;
|
|
}
|
|
}
|
|
|
|
private void button6_Click(object sender, EventArgs e)
|
|
{
|
|
for (int i = 0; i < listView1.Items.Count; i++)
|
|
{
|
|
listView1.Items[i].Checked = false;
|
|
}
|
|
}
|
|
|
|
private void button4_Click(object sender, EventArgs e)
|
|
{
|
|
int startRouteDeviceIndex = 3965;
|
|
//查询T_Base_Route 中F_EndDevice是否为 那几个设备
|
|
|
|
string sql = "SELECT F_RouteID, F_RouteName, F_StartDevice, F_EndDevice, F_RouteKind, F_OutsideAltDevice, F_InsideAltDevice, F_Status, F_AutoUpdate FROM T_Base_Route WHERE (F_EndDevice IN (15253, 15247, 15237, 15211, 15205, 14255, 14245, 14235, 14225, 14215, 14205)) AND (F_RouteID > 31)";
|
|
DataTable dt = dbo.ExceSQL(sql).Tables[0];
|
|
|
|
//查询完毕遍历
|
|
if (dt.Rows.Count > 0)
|
|
{
|
|
for (int dtrowcount = 0; dtrowcount < dt.Rows.Count; dtrowcount++)
|
|
{
|
|
string sql1 = "SELECT F_RouteDeviceIndex, F_RouteID, F_RouteIDSub, F_DeviceIndex, F_SerialNumber, F_DeviceOrder, F_UseAwayFork FROM T_Base_Route_Device WHERE (F_RouteID = " + dt.Rows[dtrowcount]["F_RouteID"] + ") ORDER BY F_RouteDeviceIndex";
|
|
DataTable dtRoute = dbo.ExceSQL(sql1).Tables[0];
|
|
if (dtRoute.Rows.Count > 0)
|
|
{
|
|
for (int RouteCount = 0; RouteCount < dtRoute.Rows.Count; RouteCount++)
|
|
{
|
|
if (dtRoute.Rows[RouteCount]["F_DeviceIndex"].ToString() == dt.Rows[dtrowcount]["F_EndDevice"].ToString())
|
|
{
|
|
string sqlss = startRouteDeviceIndex.ToString() +","+ dt.Rows[dtrowcount]["F_RouteID"].ToString()+","+ dtRoute.Rows[RouteCount]["F_RouteIDSub"].ToString() +",17001,"+ (Convert.ToInt32(dtRoute.Rows[RouteCount]["F_SerialNumber"].ToString())+1).ToString();
|
|
string insertsql = "insert into T_Base_Route_Device(F_RouteDeviceIndex,F_RouteID,F_RouteIDSub,F_DeviceIndex,F_SerialNumber,F_DeviceOrder,F_UseAwayFork) values(" + sqlss + ",-1,'-') \r\n";
|
|
startRouteDeviceIndex++;
|
|
textBox1.Text += insertsql;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
//查询出来T_Base_Route中F_RouteID， 从32开始。根据F_RouteID查询T_Base_Route_Device ORder by F_RouteDeviceIndex
|
|
|
|
//根据出来的datatable,要知道分了几条路径，那没关系，找F_DeviceIndex 是不是等于那几个设备
|
|
|
|
//如果是，数据库中插入一条数据 3965 开始，当前的routeid，上一条的idsub，17001，上一条+1，-1，-
|
|
//startRouteDeviceIndex++
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
|
}
|