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.
1071 lines
48 KiB
1071 lines
48 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 System.ServiceModel;
|
|
using Microsoft.VisualBasic;
|
|
namespace wcfControlMonitorClient
|
|
{
|
|
/// <summary>
|
|
/// Creator:Richard.liu
|
|
/// 下达手工任务--单一设备
|
|
/// </summary>
|
|
public partial class FrmHandCommand : Form
|
|
{
|
|
Model.MDevice deviceInfo;
|
|
private static FrmHandCommand _formInstance;
|
|
|
|
public static FrmHandCommand FormInstance
|
|
{
|
|
get
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmHandCommand();
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
|
|
DBOperator dbo = CStaticClass.dbo;
|
|
#region ====变量定义
|
|
|
|
CommonClassLib.UCellPanel cellPanel = null;
|
|
|
|
|
|
#endregion
|
|
public FrmHandCommand()
|
|
{
|
|
InitializeComponent();
|
|
_formInstance = this;
|
|
dbo.Open();
|
|
|
|
}
|
|
|
|
private void FrmHandCommand_Load(object sender, EventArgs e)
|
|
{
|
|
this.cbInWorkBench.SelectedIndex = 2;
|
|
this.comboBox1.SelectedIndex = 0;
|
|
if (cellPanel == null)
|
|
{
|
|
cellPanel = new CommonClassLib.UCellPanel(this, txtCellCode, null, null, string.Empty);
|
|
cellPanel.TaskType = "100";
|
|
cellPanel.GoodsName = "";
|
|
cellPanel.Dock = DockStyle.Fill;
|
|
cellPanel.AllowWareHouseChanged = false;
|
|
plCell.Controls.Add(cellPanel);
|
|
|
|
}
|
|
|
|
//20090910 and F_DBW1Address is not null
|
|
//DataView dv = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceIndex, T_Base_Device.F_DeviceKindIndex," +
|
|
// " T_Base_Device.F_DeviceName, T_Base_Device_Kind.F_GoodsMoveKindIndex FROM T_Base_Device,T_Base_Device_Kind " +
|
|
// " where T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex and F_DBW1Address is not null and " +
|
|
// " (T_Base_Device_Kind.F_GoodsMoveKindIndex = 1 OR T_Base_Device_Kind.F_GoodsMoveKindIndex = 2) AND T_Base_Device.F_DeviceKindIndex != 38 AND T_Base_Device.F_DeviceIndex NOT LIKE'350%'").Tables[0].DefaultView;
|
|
DataView dv = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceIndex, T_Base_Device.F_DeviceKindIndex," +
|
|
" T_Base_Device.F_DeviceName, T_Base_Device_Kind.F_GoodsMoveKindIndex FROM T_Base_Device,T_Base_Device_Kind " +
|
|
" where T_Base_Device.F_DeviceKindIndex = T_Base_Device_Kind.F_DeviceKindIndex and F_DBW1Address is not null and " +
|
|
" (T_Base_Device_Kind.F_GoodsMoveKindIndex = 1 OR T_Base_Device_Kind.F_GoodsMoveKindIndex = 2) " +
|
|
" AND T_Base_Device.F_DeviceKindIndex not in(38,2) AND T_Base_Device.F_DeviceIndex NOT LIKE'350%'").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
this.cbDeviceName.DisplayMember = "F_DeviceName";
|
|
this.cbDeviceName.ValueMember = "F_DeviceIndex";
|
|
this.cbDeviceName.DataSource = dv;
|
|
|
|
this.cbDeviceName.Text = "";
|
|
this.cbDeviceName.SelectedValue = 0;
|
|
}
|
|
|
|
txtCellCode.Text = "";
|
|
|
|
|
|
|
|
}
|
|
private void CbDeviceName_SelectionChangeCommitted(object sender, EventArgs e)
|
|
{
|
|
DataView dv;
|
|
this.cbDeviceCommand.DataSource = null;
|
|
string tem2sql = "SELECT T_Base_Device.F_DeviceKindIndex, F_DeviceCommandName,F_DeviceCommandIndex FROM " +
|
|
"T_Base_Device , T_Base_Device_Command WHERE T_Base_Device.F_DeviceKindIndex" +
|
|
"= T_Base_Device_Command.F_DeviceKindIndex and F_DeviceIndex=" +
|
|
Convert.ToInt32(cbDeviceName.SelectedValue) + " and F_DeviceCommandIndex <> -1";
|
|
DataSet ds = dbo.ExceSQL(tem2sql);
|
|
if (ds.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
|
|
deviceInfo = Model.CGetInfo.GetDeviceInfo(Convert.ToInt32(cbDeviceName.SelectedValue));
|
|
//if (deviceInfo.IfCorrelDoubleFork == "1")// && deviceInfo.DeviceKind==1)
|
|
if (deviceInfo.DeviceKind == 1)
|
|
{
|
|
pnDblFork.Visible = true;
|
|
}
|
|
else
|
|
{
|
|
pnDblFork.Visible = false;
|
|
}
|
|
if (deviceInfo.DeviceKind == 13)
|
|
{
|
|
pnGd.Visible = true;
|
|
}
|
|
else
|
|
{
|
|
pnGd.Visible = false;
|
|
}
|
|
this.cbDeviceCommand.DisplayMember = "F_DeviceCommandName";
|
|
this.cbDeviceCommand.ValueMember = "F_DeviceCommandIndex";
|
|
this.cbDeviceCommand.DataSource = ds.Tables[0].DefaultView;
|
|
this.cbDeviceCommand.Text = "";
|
|
this.cbDeviceCommand.SelectedValue = 0;
|
|
int rgvdev = 0;//20130510
|
|
switch (CStaticClass.GetDeviceKindIdx(Convert.ToInt32(cbDeviceName.SelectedValue)))
|
|
{
|
|
|
|
case 1://堆垛机
|
|
int devic = deviceInfo.DeviceIndex;
|
|
if (deviceInfo.VirtualStack > 0)
|
|
{
|
|
devic = deviceInfo.VirtualStack;
|
|
}
|
|
#region 注释 by lyj 20171117
|
|
//dv = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName FROM T_Base_Lane_Gate,T_Base_LaneInfo,T_Base_Device where F_LaneIndex = F_LaneDeviceIndex and T_Base_LaneInfo.F_StackIndex=" + devic + " and T_Base_Lane_Gate.F_LaneGateDeviceIndex=T_Base_Device.F_DeviceIndex").Tables[0].DefaultView;
|
|
#endregion
|
|
string tem = "SELECT F_DeviceIndex, F_DeviceName FROM T_Base_Lane_Gate,T_Base_LaneInfo,T_Base_Device where F_LaneIndex = F_LaneDeviceIndex and T_Base_Lane_Gate.F_LaneGateDeviceIndex=T_Base_Device.F_DeviceIndex";
|
|
dv = dbo.ExceSQL(tem).Tables[0].DefaultView;
|
|
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_DeviceIndex";
|
|
cbEndPosition.DataSource = dv;
|
|
// cbEndPosition.Items.Add("");
|
|
txtCellCode.Enabled = true;
|
|
comboBox1.Enabled = true;
|
|
#region 注释 by lyj 20171120
|
|
// DataView dv1 = dbo.ExceSQL(string.Format("SELECT F_ForkAmount FROM T_Base_StackInfo WHERE (F_StackIndex = {0})", Convert.ToInt32(cbDeviceName.SelectedValue))).Tables[0].DefaultView;
|
|
#endregion
|
|
string tem1sql = string.Format("SELECT F_ForkAmount FROM T_Base_StackInfo WHERE (F_StackIndex = {0})", Convert.ToInt32(cbDeviceName.SelectedValue));
|
|
DataView dv1 = dbo.ExceSQL(tem1sql).Tables[0].DefaultView;
|
|
if (dv1.Count > 0)
|
|
{
|
|
|
|
comboBox1.Items.Clear();
|
|
|
|
for (int j = 1; j <= Convert.ToInt32(dv1[0]["F_ForkAmount"]); j++)
|
|
{
|
|
comboBox1.Items.Add(j);
|
|
}
|
|
comboBox1.Text = "0";
|
|
}
|
|
else
|
|
{
|
|
comboBox1.Text = "0";
|
|
|
|
}
|
|
|
|
plCell.Enabled = true;
|
|
#region add by lyj 20171120
|
|
//if (devic.ToString().Substring(0, 4) == ("1100"))
|
|
//{
|
|
// cellPanel.StackDevice = "11000";
|
|
//}
|
|
|
|
switch (deviceInfo.Tunnel)
|
|
{
|
|
case 18001:
|
|
cellPanel.StackDevice = "35001";
|
|
break;
|
|
case 18002:
|
|
cellPanel.StackDevice = "35002";
|
|
break;
|
|
case 18003:
|
|
cellPanel.StackDevice = "35003";
|
|
break;
|
|
case 18004:
|
|
cellPanel.StackDevice = "35004";
|
|
break;
|
|
}
|
|
#endregion
|
|
//cellPanel.StackDevice =devic.ToString();//注释 by lyj 20171120
|
|
cellPanel.WareHouse = GetWarehouse(devic);
|
|
}
|
|
break;
|
|
case 2://输送机
|
|
|
|
dv = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName FROM T_Base_Device WHERE F_DeviceKindIndex =2 and F_DBW1Address is not null and f_s7connection='" + deviceInfo.S7Connection + "'").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_DeviceIndex";
|
|
cbEndPosition.DataSource = dv;
|
|
txtCellCode.Enabled = false;
|
|
comboBox1.Enabled = false;
|
|
if (deviceInfo.IfCorrelDoubleFork == "1")
|
|
{
|
|
comboBox1.Enabled = true;
|
|
}
|
|
|
|
|
|
plCell.Enabled = false;
|
|
}
|
|
comboBox1.Text = "0";
|
|
|
|
break;
|
|
case 13://高端输送机
|
|
comboBox1.Text = "0";
|
|
|
|
dv = dbo.ExceSQL(string.Format("SELECT FUCONVEYOR,F_DeviceName FROM ST_CELL,T_Base_Device WHERE FUCONVEYOR = F_DeviceIndex and (FUCODE = {0})", Convert.ToInt32(this.cbDeviceName.SelectedValue))).Tables[0].DefaultView;
|
|
|
|
if (dv.Count > 0)
|
|
{
|
|
cbBeginDev.DataSource = null;
|
|
cbBeginDev.DisplayMember = "F_DeviceName";
|
|
cbBeginDev.ValueMember = "FUCONVEYOR";
|
|
cbBeginDev.DataSource = dv;
|
|
DataView dv1 = dbo.ExceSQL(string.Format("SELECT FUCONVEYOR,F_DeviceName FROM ST_CELL,T_Base_Device WHERE FUCONVEYOR = F_DeviceIndex and (FUCODE = {0})", Convert.ToInt32(this.cbDeviceName.SelectedValue))).Tables[0].DefaultView;
|
|
|
|
cbEndDev.DataSource = null;
|
|
cbEndDev.DisplayMember = "F_DeviceName";
|
|
cbEndDev.ValueMember = "FUCONVEYOR";
|
|
cbEndDev.DataSource = dv1;
|
|
txtCellCode.Enabled = false;
|
|
comboBox1.Enabled = false;
|
|
|
|
plCell.Enabled = false;
|
|
}
|
|
|
|
|
|
break;
|
|
case 4://RGV
|
|
comboBox1.Text = "0";
|
|
//20130510
|
|
//if (Convert.ToInt32(cbDeviceName.SelectedValue) == 23004)
|
|
//{
|
|
// rgvdev = 23002;
|
|
//}
|
|
//else if (Convert.ToInt32(cbDeviceName.SelectedValue) == 13004)
|
|
//{
|
|
// rgvdev = 13002;
|
|
//}
|
|
//else
|
|
//{
|
|
// rgvdev = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
//}
|
|
rgvdev = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
pnGd.Visible = false;
|
|
dv = dbo.ExceSQL("SELECT F_RGVGateDeviceIndex,F_DeviceName FROM T_Base_Device,T_Base_RGV_Gate WHERE F_DeviceIndex=F_RGVGateDeviceIndex and F_ChannelsIndex =" + rgvdev).Tables[0].DefaultView;//20130510
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_RGVGateDeviceIndex";
|
|
cbEndPosition.DataSource = dv;
|
|
comboBox1.Enabled = false;
|
|
|
|
txtCellCode.Enabled = false;
|
|
plCell.Enabled = false;
|
|
}
|
|
|
|
break;
|
|
}
|
|
this.cbEndPosition.Text = "";
|
|
txtCellCode.Text = "";
|
|
}
|
|
}
|
|
private void cbDeviceName_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
/* yy -2023-0128 注释
|
|
DataView dv;
|
|
this.cbDeviceCommand.DataSource=null;
|
|
string tem2sql = "SELECT T_Base_Device.F_DeviceKindIndex, F_DeviceCommandName,F_DeviceCommandIndex FROM " +
|
|
"T_Base_Device , T_Base_Device_Command WHERE T_Base_Device.F_DeviceKindIndex" +
|
|
"= T_Base_Device_Command.F_DeviceKindIndex and F_DeviceIndex=" +
|
|
Convert.ToInt32(cbDeviceName.SelectedValue) + " and F_DeviceCommandIndex <> -1";
|
|
DataSet ds = dbo.ExceSQL(tem2sql);
|
|
if (ds.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
|
|
deviceInfo = Model.CGetInfo.GetDeviceInfo(Convert.ToInt32(cbDeviceName.SelectedValue));
|
|
if (deviceInfo.IfCorrelDoubleFork == "1")// && deviceInfo.DeviceKind==1)
|
|
{
|
|
pnDblFork.Visible = true;
|
|
}
|
|
else
|
|
{
|
|
pnDblFork.Visible = false;
|
|
}
|
|
if (deviceInfo.DeviceKind == 13)
|
|
{
|
|
pnGd.Visible = true;
|
|
}
|
|
else
|
|
{
|
|
pnGd.Visible = false;
|
|
}
|
|
this.cbDeviceCommand.DisplayMember = "F_DeviceCommandName";
|
|
this.cbDeviceCommand.ValueMember = "F_DeviceCommandIndex";
|
|
this.cbDeviceCommand.DataSource = ds.Tables[0].DefaultView;
|
|
this.cbDeviceCommand.Text = "";
|
|
this.cbDeviceCommand.SelectedValue = 0;
|
|
int rgvdev = 0;//20130510
|
|
switch (CStaticClass.GetDeviceKindIdx (Convert.ToInt32(cbDeviceName.SelectedValue)))
|
|
{
|
|
|
|
case 1://堆垛机
|
|
int devic=deviceInfo.DeviceIndex;
|
|
if (deviceInfo.VirtualStack>0)
|
|
{
|
|
devic = deviceInfo.VirtualStack;
|
|
}
|
|
#region 注释 by lyj 20171117
|
|
//dv = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName FROM T_Base_Lane_Gate,T_Base_LaneInfo,T_Base_Device where F_LaneIndex = F_LaneDeviceIndex and T_Base_LaneInfo.F_StackIndex=" + devic + " and T_Base_Lane_Gate.F_LaneGateDeviceIndex=T_Base_Device.F_DeviceIndex").Tables[0].DefaultView;
|
|
#endregion
|
|
string tem = "SELECT F_DeviceIndex, F_DeviceName FROM T_Base_Lane_Gate,T_Base_LaneInfo,T_Base_Device where F_LaneIndex = F_LaneDeviceIndex and T_Base_Lane_Gate.F_LaneGateDeviceIndex=T_Base_Device.F_DeviceIndex";
|
|
dv = dbo.ExceSQL(tem).Tables[0].DefaultView;
|
|
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_DeviceIndex";
|
|
cbEndPosition.DataSource =dv;
|
|
// cbEndPosition.Items.Add("");
|
|
txtCellCode.Enabled = true;
|
|
comboBox1.Enabled = true;
|
|
#region 注释 by lyj 20171120
|
|
// DataView dv1 = dbo.ExceSQL(string.Format("SELECT F_ForkAmount FROM T_Base_StackInfo WHERE (F_StackIndex = {0})", Convert.ToInt32(cbDeviceName.SelectedValue))).Tables[0].DefaultView;
|
|
#endregion
|
|
string tem1sql = string.Format("SELECT F_ForkAmount FROM T_Base_StackInfo WHERE (F_StackIndex = {0})", Convert.ToInt32(cbDeviceName.SelectedValue));
|
|
DataView dv1 = dbo.ExceSQL(tem1sql).Tables[0].DefaultView;
|
|
if (dv1.Count > 0)
|
|
{
|
|
|
|
comboBox1.Items.Clear();
|
|
|
|
for (int j = 1; j <= Convert.ToInt32(dv1[0]["F_ForkAmount"]); j++)
|
|
{
|
|
comboBox1.Items.Add(j);
|
|
}
|
|
comboBox1.Text = "0";
|
|
}
|
|
else
|
|
{
|
|
comboBox1.Text = "0";
|
|
|
|
}
|
|
|
|
plCell.Enabled = true;
|
|
#region add by lyj 20171120
|
|
if (devic.ToString().Substring(0, 4) == ("1100"))
|
|
{
|
|
cellPanel.StackDevice = "11000";
|
|
}
|
|
#endregion
|
|
//cellPanel.StackDevice =devic.ToString();//注释 by lyj 20171120
|
|
cellPanel.WareHouse = GetWarehouse(devic);
|
|
}
|
|
break;
|
|
case 2://输送机
|
|
|
|
dv = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName FROM T_Base_Device WHERE F_DeviceKindIndex =2 and F_DBW1Address is not null and f_s7connection='"+deviceInfo.S7Connection+"'").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_DeviceIndex";
|
|
cbEndPosition.DataSource = dv;
|
|
txtCellCode.Enabled = false;
|
|
comboBox1.Enabled = false;
|
|
if (deviceInfo.IfCorrelDoubleFork == "1")
|
|
{
|
|
comboBox1.Enabled = true;
|
|
}
|
|
|
|
|
|
plCell.Enabled = false;
|
|
}
|
|
comboBox1.Text = "0";
|
|
|
|
break;
|
|
case 13://高端输送机
|
|
comboBox1.Text = "0";
|
|
|
|
dv = dbo.ExceSQL(string.Format("SELECT FUCONVEYOR,F_DeviceName FROM ST_CELL,T_Base_Device WHERE FUCONVEYOR = F_DeviceIndex and (FUCODE = {0})", Convert.ToInt32(this.cbDeviceName.SelectedValue))).Tables[0].DefaultView;
|
|
|
|
if (dv.Count > 0)
|
|
{
|
|
cbBeginDev.DataSource = null;
|
|
cbBeginDev.DisplayMember = "F_DeviceName";
|
|
cbBeginDev.ValueMember = "FUCONVEYOR";
|
|
cbBeginDev.DataSource = dv;
|
|
DataView dv1 = dbo.ExceSQL(string.Format("SELECT FUCONVEYOR,F_DeviceName FROM ST_CELL,T_Base_Device WHERE FUCONVEYOR = F_DeviceIndex and (FUCODE = {0})", Convert.ToInt32(this.cbDeviceName.SelectedValue))).Tables[0].DefaultView;
|
|
|
|
cbEndDev.DataSource = null;
|
|
cbEndDev.DisplayMember = "F_DeviceName";
|
|
cbEndDev.ValueMember = "FUCONVEYOR";
|
|
cbEndDev.DataSource = dv1;
|
|
txtCellCode.Enabled = false;
|
|
comboBox1.Enabled = false;
|
|
|
|
plCell.Enabled = false;
|
|
}
|
|
|
|
|
|
break;
|
|
case 4://RGV
|
|
comboBox1.Text = "0";
|
|
//20130510
|
|
if (Convert.ToInt32(cbDeviceName.SelectedValue) == 23004)
|
|
{
|
|
rgvdev = 23002;
|
|
}
|
|
else if (Convert.ToInt32(cbDeviceName.SelectedValue) == 13004)
|
|
{
|
|
rgvdev = 13002;
|
|
}
|
|
else
|
|
{
|
|
rgvdev = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
}
|
|
pnGd.Visible = false;
|
|
dv = dbo.ExceSQL("SELECT F_RGVGateDeviceIndex,F_DeviceName FROM T_Base_Device,T_Base_RGV_Gate WHERE F_DeviceIndex=F_RGVGateDeviceIndex and F_ChannelsIndex =" + rgvdev).Tables[0].DefaultView;//20130510
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_RGVGateDeviceIndex";
|
|
cbEndPosition.DataSource = dv;
|
|
comboBox1.Enabled = false;
|
|
|
|
txtCellCode.Enabled = false;
|
|
plCell.Enabled = false;
|
|
}
|
|
|
|
break;
|
|
}
|
|
this.cbEndPosition.Text = "";
|
|
txtCellCode.Text = "";
|
|
}
|
|
*/
|
|
}
|
|
|
|
private void button1_Click(object sender, EventArgs e)
|
|
{
|
|
//TODO 手工任务下发
|
|
if (MessageBox.Show("您确认要增加手工任务吗？下达手工任务需要明确了解立体库调度逻辑且需人工保证任务下达正确", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK)
|
|
{
|
|
return;
|
|
}
|
|
|
|
//向调度任务表插入手工任务，管理类型４，
|
|
//管理索引（如果调度任务表没有手工任务，
|
|
//在T_Base_Manage_Task_Index_Hand_Task表去找个基数然后加一）
|
|
try
|
|
{
|
|
//20090910
|
|
if (cbDeviceName.SelectedValue == null)
|
|
{
|
|
MessageBox.Show("请选择设备！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbDeviceName.Focus();
|
|
return;
|
|
}
|
|
if (this.cbDeviceName.Text.Trim() == "")
|
|
{
|
|
MessageBox.Show("请选择设备！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbDeviceName.Focus();
|
|
return;
|
|
}
|
|
if (this.cbDeviceCommand.Text.Trim() == "")
|
|
{
|
|
MessageBox.Show("请选择设备命令！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbDeviceCommand.Focus();
|
|
return;
|
|
}
|
|
if ((cbDeviceCommand.Text == "复位") || (cbDeviceCommand.Text == "回原点"))
|
|
{
|
|
}
|
|
else
|
|
{
|
|
if (this.txtCellCode.Enabled == true)
|
|
{
|
|
DataView dv0;
|
|
//this.cbEndPosition.Text = "立库货位";
|
|
//if (this.cbEndPosition.Text == "立库货位")
|
|
if (true)
|
|
{
|
|
int fstack = 0;
|
|
//if (cbDeviceName.SelectedValue.ToString() == "35001" || cbDeviceName.SelectedValue.ToString() == "35002")
|
|
//{
|
|
// fstack = 35000;
|
|
//}
|
|
//else
|
|
//{
|
|
// fstack = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
//}
|
|
fstack = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
|
|
#region 注释 by lyj 201801171117
|
|
// dv0 = dbo.ExceSQL(string.Format("SELECT FCELLCODE FROM ST_CELL WHERE FStack={0} and (FCELLCODE ='{1}')",fstack,txtCellCode.Text)).Tables[0].DefaultView;
|
|
|
|
//dv0 = dbo.ExceSQL(string.Format("SELECT FCELLCODE FROM ST_CELL WHERE (FCELLCODE ='{0}')", txtCellCode.Text)).Tables[0].DefaultView;
|
|
//if (dv0.Count <= 0)
|
|
//{
|
|
// MessageBox.Show("请输入或选择合适的货位编码！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
// this.txtCellCode.Focus();
|
|
// return;
|
|
//}
|
|
|
|
#endregion
|
|
}
|
|
//else
|
|
//{
|
|
// int ep = -1;
|
|
// if (cbEndPosition.SelectedValue == null)
|
|
// {
|
|
// MessageBox.Show("请输入或选择合适的终点位置！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
// this.txtCellCode.Focus();
|
|
// return;
|
|
// }
|
|
// int.TryParse(cbEndPosition.SelectedValue.ToString(), out ep);
|
|
// if (ep==-1)
|
|
// {
|
|
// MessageBox.Show("请输入或选择合适的终点位置！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
// this.txtCellCode.Focus();
|
|
// return;
|
|
// }
|
|
// dv0 = dbo.ExceSQL("SELECT F_LaneGateDeviceIndex FROM T_Base_Lane_Gate where F_LaneGateDeviceIndex=" + cbEndPosition.SelectedValue + " and F_ZXY='" + txtCellCode.Text + "'").Tables[0].DefaultView;
|
|
// if (dv0.Count <= 0)
|
|
// {
|
|
// MessageBox.Show("请输入或选择合适的货位编码！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
// this.txtCellCode.Focus();
|
|
// return;
|
|
|
|
// }
|
|
//}
|
|
|
|
}
|
|
}
|
|
int routeIDsub = GetRouteIDsub(Convert.ToInt32(cbDeviceName.SelectedValue));
|
|
deviceInfo = Model.CGetInfo.GetDeviceInfo(Convert.ToInt32(cbDeviceName.SelectedValue));
|
|
if ((routeIDsub == -1) && (deviceInfo.DeviceKind != 13) && (deviceInfo.DeviceKind != 31))
|
|
{
|
|
|
|
MessageBox.Show("您选择的设备错误！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
|
|
//DataView dv = dbo.ExceSQL("SELECT F_ManageTASKKINDINDEX, F_DeviceIndex FROM T_Monitor_Task where F_ManageTASKKINDINDEX=4 and F_DeviceIndex=" + this.cbDeviceName.SelectedValue + "").Tables[0].DefaultView;
|
|
//if (dv.Count > 0)
|
|
//{
|
|
// MessageBox.Show("在调度队列中已经存在这个设备的手工命令！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
|
|
// return;
|
|
//}
|
|
DataSet dss = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceKindIndex, F_DeviceCommandName,F_DeviceCommandIndex FROM " +
|
|
"T_Base_Device , T_Base_Device_Command WHERE T_Base_Device.F_DeviceKindIndex" +
|
|
"= T_Base_Device_Command.F_DeviceKindIndex and F_DeviceIndex=" +
|
|
Convert.ToInt32(cbDeviceName.SelectedValue) + " and F_DeviceCommandIndex=" + Convert.ToInt32(this.cbDeviceCommand.SelectedValue) + " and F_DeviceCommandIndex <> -1");
|
|
if (dss.Tables[0].DefaultView.Count <= 0)
|
|
{
|
|
MessageBox.Show("请选择设备和对应的有效命令！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
//20101028
|
|
string dtime = DateTime.Now.ToString("u");
|
|
dtime = dtime.Substring(0, dtime.Length - 1);
|
|
|
|
int beginDeviceIndex = 0; int Inworkbench = 2, forkno = 0;
|
|
|
|
//2 将取,3 将送,4 取货,5 送货
|
|
switch (CStaticClass.GetDeviceKindIdx(Convert.ToInt32(cbDeviceName.SelectedValue)))
|
|
{
|
|
case 1://堆垛机
|
|
if ((cbDeviceCommand.SelectedValue.ToString() == "6" || cbDeviceCommand.SelectedValue.ToString() == "5") && (this.cbEndPosition.Text == "立库货位"))
|
|
{
|
|
int fstack = 0;
|
|
if (deviceInfo.VirtualStack > 0)
|
|
{
|
|
fstack = deviceInfo.VirtualStack;
|
|
}
|
|
else
|
|
{
|
|
fstack = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
}
|
|
//DataView dv0 = dbo.ExceSQL(string.Format("SELECT FCELLCODE FROM ST_CELL WHERE fstack={0} and (FCELLCODE ='{1}')", fstack, txtCellCode1.Text)).Tables[0].DefaultView;
|
|
DataView cell = dbo.ExceSQL(string.Format("SELECT FCELLCODE FROM ST_CELL WHERE fstack={0} and (FCELLCODE ='{1}') and (F_Y = {2})", fstack, txtCellCode1.Text, deviceInfo.YCoor)).Tables[0].DefaultView;
|
|
if (cell.Count <= 0)
|
|
{
|
|
MessageBox.Show("请输入或选择合适的送货位编码！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.txtCellCode1.Focus();
|
|
return;
|
|
}
|
|
|
|
}
|
|
DataView dv0 = dbo.ExceSQL(string.Format("SELECT distinct FLaneWay,f_y FROM ST_CELL WHERE FLaneWay={0} and F_Y = {1} and (FCELLCODE = '{2}' or FCELLCODE = '{3}')", deviceInfo.Tunnel, deviceInfo.YCoor, txtCellCode.Text.Trim(), txtCellCode1.Text.Trim())).Tables[0].DefaultView;
|
|
|
|
if (dv0.Count <= 0)
|
|
{
|
|
MessageBox.Show("请输入或选择合适的货位编码！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
if (this.comboBox1.Text.Trim() == "")
|
|
{
|
|
forkno = 0;
|
|
}
|
|
else
|
|
{
|
|
forkno = Convert.ToInt32(this.comboBox1.Text);
|
|
}
|
|
break;
|
|
case 2://输送机
|
|
if (cbEndPosition.Text.Trim().Length == 0)
|
|
{
|
|
MessageBox.Show("请选择目标位置！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbEndPosition.Focus();
|
|
return;
|
|
}
|
|
if (cbDeviceCommand.SelectedValue.ToString() != "6")
|
|
{
|
|
cbEndPosition.Text = "0";
|
|
|
|
}
|
|
|
|
int.TryParse(this.comboBox1.Text, out forkno);
|
|
|
|
break;
|
|
case 4://RGV
|
|
if (cbEndPosition.SelectedValue == null)
|
|
{
|
|
MessageBox.Show("请选择目标位置！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbEndPosition.Focus();
|
|
return;
|
|
}
|
|
|
|
break;
|
|
case 13://高端
|
|
if (cbEndDev.SelectedValue == null)
|
|
{
|
|
MessageBox.Show("请选择目标位置！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbEndDev.Focus();
|
|
return;
|
|
}
|
|
if (cbBeginDev.SelectedValue == null)
|
|
{
|
|
MessageBox.Show("请选择目标位置！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbBeginDev.Focus();
|
|
return;
|
|
}
|
|
beginDeviceIndex = Convert.ToInt32(cbBeginDev.SelectedValue);
|
|
if (int.TryParse(cbInWorkBench.Text, out Inworkbench) == false)
|
|
{
|
|
MessageBox.Show("请选择是否进工位！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbInWorkBench.Focus();
|
|
return;
|
|
}
|
|
forkno = Inworkbench;
|
|
break;
|
|
}
|
|
//调用服务
|
|
|
|
|
|
|
|
|
|
|
|
string errtext = string.Empty;
|
|
string epp = string.Empty;
|
|
if (cbEndPosition.SelectedValue == null)
|
|
{
|
|
epp = "0";
|
|
}
|
|
else
|
|
{
|
|
epp = cbEndPosition.SelectedValue.ToString();
|
|
}
|
|
string cellcode = string.Empty;
|
|
if (deviceInfo.DeviceKind == 13)
|
|
{
|
|
epp = cbEndDev.SelectedValue.ToString();
|
|
cellcode = tbFPALLETBARCODE.Text;
|
|
}
|
|
else
|
|
{
|
|
cellcode = txtCellCode.Text;
|
|
}
|
|
string cforks = string.Empty;
|
|
if (fork2.Checked == true)
|
|
{
|
|
cforks = ",2";
|
|
}
|
|
if (fork3.Checked == true)
|
|
{
|
|
cforks = cforks + ",3";
|
|
}
|
|
if (cforks.Length >= 2)
|
|
{
|
|
cforks = cforks.Substring(1);
|
|
}
|
|
Model.HandTask ht = new Model.HandTask(Convert.ToInt32(cbDeviceName.SelectedValue)
|
|
, Convert.ToInt32(cbDeviceCommand.SelectedValue), beginDeviceIndex, epp,
|
|
cellcode, txtCellCode1.Text, forkno, cforks);
|
|
|
|
CStaticClass.WcfControl.BeginBuildHandTask(ht, new AsyncCallback(BuildHandTaskCallBack), ht);
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw ex;
|
|
}
|
|
|
|
}
|
|
int GetManageHandIdx()
|
|
{
|
|
DataSet ds = dbo.ExceSQL("SELECT F_ManageTaskKindIndex, max(FID) as mFID FROM T_Manage_Task Where F_ManageTaskKindIndex=4 group by F_ManageTaskKindIndex");
|
|
if (ds.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
return (Convert.ToInt32(ds.Tables[0].DefaultView[0]["mFID"]) + 1);
|
|
}
|
|
else
|
|
{
|
|
DataSet dss = dbo.ExceSQL("SELECT F_ManageTaskIndex FROM T_Base_Manage_Task_Index_Hand_Task");
|
|
if (dss.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
if ((Convert.ToInt32(dss.Tables[0].DefaultView[0]["F_ManageTaskIndex"]) + 1) >= 29998)
|
|
{
|
|
return 20001;
|
|
}
|
|
else
|
|
{
|
|
return (Convert.ToInt32(dss.Tables[0].DefaultView[0]["F_ManageTaskIndex"]) + 1);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
return 20001;
|
|
}
|
|
}
|
|
}
|
|
void RecordMaxHandTaskFID(int fid)
|
|
{
|
|
DataSet ds = dbo.ExceSQL("select F_ManageTaskIndex from T_Base_Manage_Task_Index_Hand_Task");
|
|
DataView dv = ds.Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
if (fid == 29998)
|
|
{
|
|
dbo.ExceSQL("UPDATE T_Base_Manage_Task_Index_Hand_Task SET F_ManageTaskIndex =20001");
|
|
return;
|
|
}
|
|
if (fid > Convert.ToInt32(dv[0]["F_ManageTaskIndex"]))
|
|
{
|
|
dbo.ExceSQL("UPDATE T_Base_Manage_Task_Index_Hand_Task SET F_ManageTaskIndex =" + fid);
|
|
return;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
dbo.ExceSQL("INSERT INTO T_Base_Manage_Task_Index_Hand_Task (F_ManageTaskIndex)VALUES (" + fid + ")");
|
|
return;
|
|
}
|
|
}
|
|
|
|
void BuildHandTaskCallBack(IAsyncResult ar)
|
|
{
|
|
string errtext = string.Empty;
|
|
|
|
if (CStaticClass.WcfControl.EndBuildHandTask(out errtext, ar) == false)
|
|
{
|
|
MessageBox.Show(errtext, "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Error);
|
|
}
|
|
}
|
|
string GetWarehouse(int Fstack)
|
|
{
|
|
#region 注释 by lyj 20171117
|
|
// DataView dv = dbo.ExceSQL(string.Format("SELECT DISTINCT FWAREHOUSE FROM ST_CELL WHERE (Fstack = {0})", Fstack)).Tables[0].DefaultView;
|
|
#endregion
|
|
DataView dv = dbo.ExceSQL(string.Format("SELECT DISTINCT FWAREHOUSE FROM ST_CELL WHERE FStack like '1100%'", Fstack)).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
return dv[0][0].ToString();
|
|
}
|
|
else
|
|
{
|
|
return "1";
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
int GetRouteIDsub(int device)
|
|
{
|
|
#region 注释 by lyj 20171120
|
|
//DataView dv = dbo.ExceSQL("SELECT F_RouteIDSub, F_DeviceIndex, F_RouteID FROM T_Base_Route_Device where F_DeviceIndex="+device+"").Tables[0].DefaultView;
|
|
#endregion
|
|
if (device == 11001 || device == 11002 || device == 11003)
|
|
{
|
|
device = 1100;
|
|
}
|
|
string stemkk = "SELECT F_RouteIDSub, F_DeviceIndex, F_RouteID FROM T_Base_Route_Device where F_DeviceIndex like '" + device + "%'";
|
|
DataView dv = dbo.ExceSQL(stemkk).Tables[0].DefaultView;
|
|
|
|
if (dv.Count > 0)
|
|
{
|
|
return Convert.ToInt32(dv[0]["F_RouteIDSub"]);
|
|
}
|
|
else
|
|
{
|
|
return -1;
|
|
}
|
|
}
|
|
|
|
private void cbDeviceCommand_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if (this.cbDeviceCommand.SelectedValue != null && this.cbDeviceName.SelectedValue != null && this.cbDeviceCommand.Text.Trim() != "")
|
|
{
|
|
switch (CStaticClass.GetDeviceKindIdx(Convert.ToInt32(this.cbDeviceName.SelectedValue)))
|
|
{
|
|
case 1:
|
|
if (cbDeviceCommand.SelectedValue.ToString() == "1")
|
|
{
|
|
txtCellCode.Text = "00-00-00";
|
|
txtCellCode.Enabled = true;
|
|
txtCellCode1.Enabled = false;
|
|
txtCellCode1.Text = "";
|
|
cbEndPosition.SelectedValue = 0;
|
|
}
|
|
else if (cbDeviceCommand.SelectedValue.ToString() == "6")
|
|
{
|
|
txtCellCode.Enabled = true;
|
|
txtCellCode.Text = "";
|
|
txtCellCode1.Enabled = true;
|
|
txtCellCode1.Text = "";
|
|
|
|
}
|
|
else if ((cbDeviceCommand.SelectedValue.ToString() == "2") || (cbDeviceCommand.SelectedValue.ToString() == "4"))
|
|
{
|
|
txtCellCode.Enabled = true;
|
|
txtCellCode.Text = "";
|
|
txtCellCode1.Enabled = false;
|
|
txtCellCode1.Text = "";
|
|
cellPanel.ControlCellCode = txtCellCode;
|
|
}
|
|
else if ((cbDeviceCommand.SelectedValue.ToString() == "3") || (cbDeviceCommand.SelectedValue.ToString() == "5"))
|
|
{
|
|
txtCellCode.Enabled = false;
|
|
txtCellCode.Text = "";
|
|
txtCellCode1.Enabled = true;
|
|
txtCellCode1.Text = "";
|
|
|
|
cellPanel.ControlCellCode = txtCellCode1;
|
|
|
|
|
|
}
|
|
else
|
|
{
|
|
txtCellCode1.Enabled = false;
|
|
txtCellCode1.Text = "";
|
|
txtCellCode.Text = "";
|
|
}
|
|
|
|
break;
|
|
case 2:
|
|
|
|
if (cbDeviceCommand.SelectedValue.ToString() != "6")
|
|
{
|
|
|
|
cbEndPosition.SelectedValue = 0;
|
|
cbEndPosition.Text = "0";
|
|
}
|
|
else
|
|
{
|
|
|
|
cbEndPosition.SelectedValue = -1;
|
|
cbEndPosition.Text = "";
|
|
}
|
|
txtCellCode.Text = "";
|
|
txtCellCode1.Enabled = false;
|
|
txtCellCode1.Text = "";
|
|
break;
|
|
case 31:
|
|
|
|
if (cbDeviceCommand.SelectedValue.ToString() != "6")
|
|
{
|
|
|
|
cbEndPosition.SelectedValue = 0;
|
|
cbEndPosition.Text = "0";
|
|
}
|
|
else
|
|
{
|
|
|
|
cbEndPosition.SelectedValue = -1;
|
|
cbEndPosition.Text = "";
|
|
}
|
|
txtCellCode.Text = "";
|
|
txtCellCode.Enabled = false;
|
|
txtCellCode1.Enabled = false;
|
|
txtCellCode1.Text = "";
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
private void cbEndPosition_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
int devic = 35000;
|
|
if ((Convert.ToInt32(cbDeviceName.SelectedValue) == 35001) || (Convert.ToInt32(cbDeviceName.SelectedValue) == 35002))
|
|
{
|
|
devic = 35000;
|
|
}
|
|
else
|
|
{
|
|
devic = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
}
|
|
if (this.cbEndPosition.SelectedValue == null) return;
|
|
int qq = -1;
|
|
if (int.TryParse(this.cbEndPosition.SelectedValue.ToString(), out qq) == true)
|
|
{
|
|
#region 注释 by lyj 20171120
|
|
//DataView dv = dbo.ExceSQL(string.Format("SELECT T_Base_Lane_Gate.F_ZXY FROM T_Base_LaneInfo,T_Base_Lane_Gate WHERE T_Base_LaneInfo.F_LaneDeviceIndex = T_Base_Lane_Gate.F_LaneIndex and (T_Base_LaneInfo.F_StackIndex = {0}) AND (T_Base_Lane_Gate.F_LaneGateDeviceIndex = {1})",devic,cbEndPosition.SelectedValue)).Tables[0].DefaultView;
|
|
#endregion
|
|
string sqltem3 = string.Format("SELECT T_Base_Lane_Gate.F_ZXY FROM T_Base_LaneInfo,T_Base_Lane_Gate WHERE T_Base_LaneInfo.F_LaneDeviceIndex = T_Base_Lane_Gate.F_LaneIndex AND (T_Base_Lane_Gate.F_LaneGateDeviceIndex = {0})", cbEndPosition.SelectedValue);
|
|
DataView dv = dbo.ExceSQL(sqltem3).Tables[0].DefaultView;
|
|
|
|
|
|
if (dv.Count > 0)
|
|
{
|
|
if (txtCellCode.Enabled == true)
|
|
{
|
|
txtCellCode.Text = dv[0][0].ToString();
|
|
}
|
|
else
|
|
{
|
|
txtCellCode1.Text = dv[0][0].ToString();
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
|
|
txtCellCode.Text = "";
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
private void txtCellCode_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (this.cbDeviceName.SelectedValue == null) return;
|
|
if (CStaticClass.GetDeviceKindIdx(Convert.ToInt32(this.cbDeviceName.SelectedValue)) != 1) return;
|
|
int fstack = 0;
|
|
if (cbDeviceName.SelectedValue.ToString() == "35001" || cbDeviceName.SelectedValue.ToString() == "35002")
|
|
{
|
|
fstack = 35000;
|
|
}
|
|
else
|
|
{
|
|
fstack = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
}
|
|
DataView dv0 = dbo.ExceSQL("SELECT F_LaneGateDeviceIndex FROM T_Base_Lane_Gate WHERE F_ZXY='" + txtCellCode.Text + "' and F_LaneIndex=" + CStaticClass.GetLaneWay(fstack) + "").Tables[0].DefaultView;
|
|
if (dv0.Count > 0)
|
|
{
|
|
this.cbEndPosition.SelectedValue = dv0[0][0];
|
|
}
|
|
else
|
|
{
|
|
#region add by lyj 20171120
|
|
if (fstack == 11001 || fstack == 11002 | fstack == 11002)
|
|
{
|
|
fstack = 11000;
|
|
}
|
|
#endregion
|
|
string temsql11 = "SELECT FCELLCODE FROM ST_CELL WHERE fstack=" + fstack + " and (FCELLCODE ='" + txtCellCode.Text + "')";
|
|
dv0 = dbo.ExceSQL(temsql11).Tables[0].DefaultView;
|
|
if (dv0.Count > 0)
|
|
{
|
|
|
|
this.cbEndPosition.SelectedValue = 0;
|
|
this.cbEndPosition.Text = "立库货位";
|
|
}
|
|
}
|
|
}
|
|
|
|
private void FrmHandCommand_FormClosing(object sender, FormClosingEventArgs e)
|
|
{
|
|
_formInstance = null;
|
|
}
|
|
|
|
private void txtCellCode1_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (this.cbDeviceName.SelectedValue == null) return;
|
|
if (CStaticClass.GetDeviceKindIdx(Convert.ToInt32(this.cbDeviceName.SelectedValue)) != 1) return;
|
|
int fstack = 0;
|
|
if (cbDeviceName.SelectedValue.ToString() == "35001" || cbDeviceName.SelectedValue.ToString() == "35002")
|
|
{
|
|
fstack = 35000;
|
|
}
|
|
else
|
|
{
|
|
fstack = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
}
|
|
DataView dv0 = dbo.ExceSQL("SELECT F_LaneGateDeviceIndex FROM T_Base_Lane_Gate WHERE F_ZXY='" + txtCellCode1.Text + "' and F_LaneIndex=" + CStaticClass.GetLaneWay(fstack) + "").Tables[0].DefaultView;
|
|
if (dv0.Count > 0)
|
|
{
|
|
this.cbEndPosition.SelectedValue = dv0[0][0];
|
|
}
|
|
else
|
|
{
|
|
dv0 = dbo.ExceSQL("SELECT FCELLCODE FROM ST_CELL WHERE fstack=" + fstack + " and (FCELLCODE ='" + txtCellCode1.Text + "')").Tables[0].DefaultView;
|
|
if (dv0.Count > 0)
|
|
{
|
|
|
|
this.cbEndPosition.SelectedValue = 0;
|
|
this.cbEndPosition.Text = "立库货位";
|
|
}
|
|
}
|
|
}
|
|
|
|
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if (comboBox1.Text == "1")
|
|
{
|
|
//fork2.Visible = true;
|
|
fork2.Visible = false;
|
|
//fork3.Visible = true;
|
|
}
|
|
else if (comboBox1.Text == "2")
|
|
{
|
|
fork2.Visible = false;
|
|
//fork3.Visible = true;
|
|
}
|
|
else if (comboBox1.Text == "3")
|
|
{
|
|
fork2.Visible = false;
|
|
//fork3.Visible = false;
|
|
}
|
|
}
|
|
}
|
|
}
|