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.
629 lines
28 KiB
629 lines
28 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 ICommLayer;
|
|
using CommLayerFactory;
|
|
using Microsoft.VisualBasic;
|
|
namespace ControlSystem
|
|
{
|
|
/// <summary>
|
|
/// Creator:Richard.liu
|
|
/// 下达手工任务--单一设备
|
|
/// </summary>
|
|
public partial class FrmHandCommand : Form
|
|
{
|
|
private static FrmHandCommand _formInstance;
|
|
|
|
public static FrmHandCommand FormInstance
|
|
{
|
|
get
|
|
{
|
|
if (_formInstance == null)
|
|
{
|
|
_formInstance = new FrmHandCommand();
|
|
}
|
|
return _formInstance;
|
|
}
|
|
set { _formInstance = value; }
|
|
}
|
|
CCommonFunction ccf = new CCommonFunction();
|
|
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.comboBox1.SelectedIndex = 0;
|
|
if (cellPanel == null)
|
|
{
|
|
cellPanel = new CommonClassLib.UCellPanel(this, txtCellCode, 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)").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_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
DataView dv;
|
|
this.cbDeviceCommand.DataSource=null;
|
|
DataSet ds = 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 <> -1");
|
|
if (ds.Tables[0].DefaultView.Count > 0)
|
|
{
|
|
|
|
|
|
this.cbDeviceCommand.DisplayMember = "F_DeviceCommandName";
|
|
this.cbDeviceCommand.ValueMember = "F_DeviceCommandIndex";
|
|
this.cbDeviceCommand.DataSource = ds.Tables[0].DefaultView;
|
|
this.cbDeviceCommand.Text = "";
|
|
this.cbDeviceCommand.SelectedValue = 0;
|
|
switch (ccf.GetDeviceKindIdx(Convert.ToInt32(cbDeviceName.SelectedValue)))
|
|
{
|
|
case 1://堆垛机
|
|
|
|
|
|
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=" + Convert.ToInt32(cbDeviceName.SelectedValue) + " and T_Base_Lane_Gate.F_LaneGateDeviceIndex=T_Base_Device.F_DeviceIndex").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_DeviceIndex";
|
|
cbEndPosition.DataSource =dv;
|
|
txtCellCode.Enabled = true;
|
|
plCell.Enabled = true;
|
|
cellPanel.StackDevice = this.cbDeviceName.SelectedValue.ToString();
|
|
}
|
|
break;
|
|
case 2://输送机
|
|
//
|
|
|
|
dv = dbo.ExceSQL("SELECT F_DeviceIndex, F_DeviceName FROM T_Base_Device WHERE F_DeviceKindIndex =2").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_DeviceIndex";
|
|
cbEndPosition.DataSource = dv;
|
|
txtCellCode.Enabled = false;
|
|
plCell.Enabled = false;
|
|
}
|
|
|
|
|
|
break;
|
|
|
|
case 4://RGV
|
|
|
|
|
|
dv = dbo.ExceSQL("SELECT F_RGVGateDeviceIndex,F_DeviceName FROM T_Base_Device,T_Base_RGV_Gate WHERE F_DeviceIndex=F_RGVGateDeviceIndex and F_ChannelsIndex =" + Convert.ToInt32(cbDeviceName.SelectedValue)).Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
cbEndPosition.DataSource = null;
|
|
cbEndPosition.DisplayMember = "F_DeviceName";
|
|
cbEndPosition.ValueMember = "F_RGVGateDeviceIndex";
|
|
cbEndPosition.DataSource = dv;
|
|
txtCellCode.Enabled = false;
|
|
plCell.Enabled = false;
|
|
}
|
|
|
|
break;
|
|
}
|
|
this.cbEndPosition.Text = "";
|
|
txtCellCode.Text = "";
|
|
}
|
|
}
|
|
|
|
private void button1_Click(object sender, EventArgs e)
|
|
{
|
|
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;
|
|
if (this.cbEndPosition.Text == "立库货位")
|
|
{
|
|
dv0 = dbo.ExceSQL("SELECT FCELLCODE FROM ST_CELL WHERE (FCELLCODE ='" + txtCellCode.Text + "')").Tables[0].DefaultView;
|
|
if (dv0.Count <= 0)
|
|
{
|
|
MessageBox.Show("请输入或选择合适的货位编码！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.txtCellCode.Focus();
|
|
return;
|
|
}
|
|
}
|
|
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));
|
|
|
|
if (routeIDsub == -1)
|
|
{
|
|
|
|
MessageBox.Show("您选择的设备错误！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
return;
|
|
}
|
|
DataSet ds;
|
|
string Sql;
|
|
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);
|
|
string qcell = string.Empty, scell = string.Empty;
|
|
int hidx =0;
|
|
int hmindx = 0; int rehidx = 0;
|
|
//20101028
|
|
int z=0, x=0, y=0, z1=0, x1=0, y1 = 0;
|
|
//2 将取,3 将送,4 取货,5 送货
|
|
switch (ccf.GetDeviceKindIdx(Convert.ToInt32(cbDeviceName.SelectedValue)))
|
|
{
|
|
case 1://堆垛机
|
|
char[] cc = new char[1] { '-' };
|
|
string[] sp = this.txtCellCode.Text.Split(cc);
|
|
switch (this.cbDeviceCommand.SelectedValue.ToString())
|
|
{
|
|
|
|
case "2":
|
|
z =Convert.ToInt32( sp[0]);
|
|
x = Convert.ToInt32(sp[1]);
|
|
y = Convert.ToInt32(sp[2]);
|
|
qcell = txtCellCode.Text;//20101028
|
|
break;
|
|
case "4":
|
|
z = Convert.ToInt32(sp[0]);
|
|
x = Convert.ToInt32(sp[1]);
|
|
y = Convert.ToInt32(sp[2]);
|
|
qcell = txtCellCode.Text;//20101028
|
|
break;
|
|
case "3":
|
|
z1 = Convert.ToInt32(sp[0]);
|
|
x1 = Convert.ToInt32(sp[1]);
|
|
y1 = Convert.ToInt32(sp[2]);
|
|
scell = txtCellCode.Text;//20101028
|
|
break;
|
|
case "5":
|
|
z1 = Convert.ToInt32(sp[0]);
|
|
x1 = Convert.ToInt32(sp[1]);
|
|
y1 = Convert.ToInt32(sp[2]);
|
|
scell = txtCellCode.Text;//20101028
|
|
break;
|
|
|
|
}
|
|
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";
|
|
z = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
z1 = Convert.ToInt32(cbEndPosition.Text);
|
|
}
|
|
else
|
|
{
|
|
|
|
z = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
z1 = Convert.ToInt32(cbEndPosition.SelectedValue);
|
|
}
|
|
z = Convert.ToInt32(cbDeviceName.SelectedValue);
|
|
z1 = Convert.ToInt32(cbEndPosition.SelectedValue);
|
|
break;
|
|
case 4://RGV
|
|
if (cbEndPosition.SelectedValue == null)
|
|
{
|
|
MessageBox.Show("请选择目标位置！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
|
|
this.cbEndPosition.Focus();
|
|
return;
|
|
}
|
|
z = Convert.ToInt32(cbEndPosition.SelectedValue);
|
|
break;
|
|
}
|
|
string useawayfork = "-"; int xx = 0; int xx1 = 0;
|
|
if (this.comboBox1.Text == "近货叉")
|
|
{
|
|
useawayfork = "0";
|
|
|
|
xx = x + 1;
|
|
xx1 = x1 + 1;
|
|
}
|
|
else
|
|
{
|
|
xx = x - 1;
|
|
xx1 = x1 - 1;
|
|
useawayfork = "1";
|
|
|
|
}
|
|
//if (this.checkBox1.Checked == true)
|
|
//{
|
|
// useawayfork = "-";
|
|
//}
|
|
|
|
|
|
if (this.checkBox1.Checked == true)
|
|
{
|
|
|
|
if ((ccf.GetDeviceKindIdx(Convert.ToInt32(cbDeviceName.SelectedValue)) == 1) && (((cbDeviceCommand.Text == "取货") || ((cbDeviceCommand.Text == "送货")))))
|
|
{
|
|
rehidx= GetManageHandIdx();
|
|
hmindx = ccf.GetMonitorIndex(hidx, 4);
|
|
if (cbDeviceCommand.Text == "取货")
|
|
{//z-x-y
|
|
|
|
if (x == 1)
|
|
{
|
|
xx = 1;
|
|
}
|
|
else
|
|
{
|
|
dv = dbo.ExceSQL("SELECT FID FROM ST_CELL WHERE (F_Z = " + z + ") AND (F_X = " + xx + ") AND (F_Y = " + y + ")").Tables[0].DefaultView;
|
|
if (dv.Count == 0)
|
|
{
|
|
return;
|
|
|
|
}
|
|
}
|
|
if (useawayfork == "1")
|
|
{
|
|
useawayfork = "0";
|
|
}
|
|
else
|
|
{
|
|
useawayfork = "1";
|
|
}
|
|
qcell = z.ToString() + "-" + xx.ToString() + "-" + y.ToString();//20101028
|
|
dbo.ExceSQL("insert into T_Monitor_Task(F_RouteID,F_ManageTaskIndex,F_ManageTaskKindIndex,F_MonitorIndex," +
|
|
"F_DeviceIndex,F_DeviceCommandIndex,F_NumParam1,F_NumParam2,F_NumParam3,F_NumParam4,F_NumParam5,F_NumParam6,F_UseAwayFork) " +
|
|
"values(" + routeIDsub + "," + rehidx + ",4," + hmindx + "," + Convert.ToInt32(cbDeviceName.SelectedValue)
|
|
+ "," + Convert.ToInt32(cbDeviceCommand.SelectedValue) + "," + z + "," + xx + "," + y + ",0,0,0,'" + useawayfork + "')");
|
|
}
|
|
if (cbDeviceCommand.Text == "送货")
|
|
{//z1-x1-y1
|
|
|
|
if (x1 == 1)
|
|
{
|
|
xx1 = 1;
|
|
}
|
|
else
|
|
{
|
|
dv = dbo.ExceSQL("SELECT FID FROM ST_CELL WHERE (F_Z = " + z1 + ") AND (F_X = " + xx1 + ") AND (F_Y = " + y1 + ")").Tables[0].DefaultView;
|
|
if (dv.Count == 0)
|
|
{
|
|
return;
|
|
|
|
}
|
|
}
|
|
if (useawayfork == "1")
|
|
{
|
|
useawayfork = "0";
|
|
}
|
|
else
|
|
{
|
|
useawayfork = "1";
|
|
}
|
|
scell = z1.ToString() + "-" + xx1.ToString() + "-" + y1.ToString();//20101028
|
|
dbo.ExceSQL("insert into T_Monitor_Task(F_RouteID,F_ManageTaskIndex,F_ManageTaskKindIndex,F_MonitorIndex," +
|
|
"F_DeviceIndex,F_DeviceCommandIndex,F_NumParam1,F_NumParam2,F_NumParam3,F_NumParam4,F_NumParam5,F_NumParam6,F_UseAwayFork) " +
|
|
"values(" + routeIDsub + "," + rehidx + ",4," + hmindx + "," + Convert.ToInt32(cbDeviceName.SelectedValue)
|
|
+ "," + Convert.ToInt32(cbDeviceCommand.SelectedValue) + ",0,0,0," + z1 + "," + xx1 + "," + y1 + ",'" + useawayfork + "')");
|
|
|
|
}
|
|
|
|
dbo.ExceSQL("insert into T_Manage_Task(FID,F_ManageTaskKindIndex,F_RELATIVECONTORLID,FIntoStepOK,FSTARTDEVICE,FREMARK,FSTARTCELL,FENDDEVICE,FENDCELL,FBEGTIME) values(" +
|
|
rehidx + ",4,-1,1," + Convert.ToInt32(cbDeviceName.SelectedValue) + ",'"+cbDeviceCommand.SelectedValue+"','" + qcell + "'," + Convert.ToInt32(cbDeviceName.SelectedValue) + ",'" + scell + "','" + dtime + "')");
|
|
|
|
RecordMaxHandTaskFID(rehidx);
|
|
//20101028
|
|
|
|
}
|
|
}
|
|
//20101028
|
|
hidx = GetManageHandIdx();
|
|
hmindx = ccf.GetMonitorIndex(hidx, 4);
|
|
Sql = "insert into T_Monitor_Task(F_RouteID,F_ManageTaskIndex,F_ManageTaskKindIndex,F_MonitorIndex," +
|
|
"F_DeviceIndex,F_DeviceCommandIndex,F_NumParam1,F_NumParam2,F_NumParam3,F_NumParam4,F_NumParam5,F_NumParam6,F_UseAwayFork) " +
|
|
"values(" + routeIDsub + "," + hidx + ",4," + hmindx + "," + Convert.ToInt32(cbDeviceName.SelectedValue)
|
|
+ "," + Convert.ToInt32(cbDeviceCommand.SelectedValue) + "," + z + "," + x + "," + y + "," + z1 + "," + x1 + "," + y1 + ",'" + useawayfork + "')";
|
|
ds = dbo.ExceSQL(Sql);
|
|
|
|
dbo.ExceSQL("insert into T_Manage_Task(FID,F_ManageTaskKindIndex,F_RELATIVECONTORLID,FIntoStepOK,FSTARTDEVICE,FREMARK,FSTARTCELL,FENDDEVICE,FENDCELL,FBEGTIME) values(" +
|
|
hidx + ",4,-1,1," + Convert.ToInt32(cbDeviceName.SelectedValue) + ",'" + cbDeviceCommand.SelectedValue + "','" + z.ToString()+"-"+x.ToString()+"-"+y.ToString()
|
|
+ "'," + Convert.ToInt32(cbEndPosition.SelectedValue) + ",'" + z1.ToString() + "-" + x1.ToString() + "-" + y1.ToString() + "','" + dtime + "')");
|
|
|
|
if (rehidx > 0)
|
|
{
|
|
dbo.ExecuteSql("update T_Manage_Task set F_RELATIVECONTORLID=" + rehidx + " where F_ManageTaskKindIndex=4 and FID=" + hidx);
|
|
dbo.ExecuteSql("update T_Manage_Task set F_RELATIVECONTORLID=" + hidx + " where F_ManageTaskKindIndex=4 and FID=" + rehidx);
|
|
}
|
|
RecordMaxHandTaskFID(hidx);
|
|
//20101028
|
|
FrmControlMonitor.FormInstance.MonitorRefresh();//20110222
|
|
FrmControlMonitor.FormInstance.ManagerRefresh();//20110222
|
|
}
|
|
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;
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
int GetRouteIDsub(int device)
|
|
{
|
|
DataView dv = dbo.ExceSQL("SELECT F_RouteIDSub, F_DeviceIndex, F_RouteID FROM T_Base_Route_Device where F_DeviceIndex="+device+"").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 (ccf.GetDeviceKindIdx(Convert.ToInt32( this.cbDeviceName.SelectedValue)))
|
|
{
|
|
case 1:
|
|
if (cbDeviceCommand.SelectedValue.ToString() == "1")
|
|
{
|
|
txtCellCode.Text = "00-00-00";
|
|
}
|
|
else
|
|
{
|
|
txtCellCode.Text = "";
|
|
}
|
|
break;
|
|
case 2:
|
|
|
|
if (cbDeviceCommand.SelectedValue.ToString() != "6")
|
|
{
|
|
|
|
cbEndPosition.SelectedValue = 0;
|
|
cbEndPosition.Text = "0";
|
|
}
|
|
else
|
|
{
|
|
|
|
cbEndPosition.SelectedValue = -1;
|
|
cbEndPosition.Text = "";
|
|
}
|
|
txtCellCode.Text = "";
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
private void cbEndPosition_SelectedIndexChanged(object sender, EventArgs e)
|
|
{
|
|
if ((Information.IsNumeric(this.cbEndPosition.SelectedValue) == true))
|
|
{
|
|
DataView dv = dbo.ExceSQL("SELECT F_ZXY FROM T_Base_Lane_Gate where F_LaneGateDeviceIndex=" + this.cbEndPosition.SelectedValue + "").Tables[0].DefaultView;
|
|
if (dv.Count > 0)
|
|
{
|
|
txtCellCode.Text = dv[0][0].ToString();
|
|
|
|
}
|
|
else
|
|
{
|
|
|
|
txtCellCode.Text = "";
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
private void txtCellCode_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if(this.cbDeviceName.SelectedValue==null)return;
|
|
if(ccf.GetDeviceKindIdx(Convert.ToInt32( this.cbDeviceName.SelectedValue))!=1)return;
|
|
DataView dv0 = dbo.ExceSQL("SELECT F_LaneGateDeviceIndex FROM T_Base_Lane_Gate WHERE F_ZXY='" + txtCellCode.Text + "' and F_LaneIndex=" + ccf.GetLaneWay(Convert.ToInt32(cbDeviceName.SelectedValue)) + "").Tables[0].DefaultView;
|
|
if (dv0.Count > 0)
|
|
{
|
|
this.cbEndPosition.SelectedValue = dv0[0][0];
|
|
}
|
|
else
|
|
{
|
|
dv0 = dbo.ExceSQL("SELECT FCELLCODE FROM ST_CELL WHERE (FCELLCODE ='" + txtCellCode.Text + "')").Tables[0].DefaultView;
|
|
if (dv0.Count > 0)
|
|
{
|
|
|
|
this.cbEndPosition.SelectedValue = 0;
|
|
this.cbEndPosition.Text = "立库货位";
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
|
|
|
|
}
|
|
}
|