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; using System.ServiceModel; using System.Net; namespace wcfControlMonitorClient { /// /// Creator:Richard.liu /// 模仿管理下达自动任务 /// public partial class FrmAutoCommand : Form { DBOperator dbo = CStaticClass.dbo; int AutoManageIdx = 0; #region ====变量定义 CommonClassLib.UCellPanel cellPanel = null; #endregion private static FrmAutoCommand _formInstance; public static FrmAutoCommand FormInstance { get { if (_formInstance == null) { _formInstance = new FrmAutoCommand(); } return _formInstance; } set { _formInstance = value; } } public FrmAutoCommand() { dbo.Open(); InitializeComponent(); _formInstance = this; ////特殊命令:堆垛机取坐标001，送坐标002；条码比对003；称重回传004； ////搬运木块码盘005(一个主搬运木块任务，拆分成多个单一搬运任务) //this.cbKind.Items.Add(""); //this.cbKind.Items.Add("条码比对"); //this.cbKind.Items.Add("称重回传"); ////this.cbKind.Items.Add("机器人码盘"); //this.cbKind.Text="条码比对"; ////cbtasktype DataSet ds = dbo.ExceSQL("select * from T_ITEMTASKTYPE where FCODE !='-'"); if (ds.Tables[0].DefaultView.Count > 0) { cbtasktype.ValueMember = "FCODE"; cbtasktype.DisplayMember = "FNAME"; cbtasktype.DataSource = ds.Tables[0].DefaultView; } } private void button1_Click(object sender, EventArgs e) { if (MessageBox.Show("您确认要增加自动任务吗？", "操作提示：", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) != DialogResult.OK) { return; } if (tbFPALLETBARCODE.Text.Trim().Length < 6) { MessageBox.Show("条码不够6位字符！", "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if ((this.cbtasktype.Text.Trim().Length == 0) || (this.cbstartposition.Text.Trim().Length == 0) || (this.cbendposition.Text.Trim().Length == 0)) { MessageBox.Show("搬运任务类型、起点位置、终点位置都不允许保持空值！", "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if ((tbstartsite.Enabled == true) && (tbstartsite.Text.Trim().Length == 0)) { MessageBox.Show("起点位置是巷道，所以必须指定货架位置！", "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if ((tbendsite.Enabled == true) && (tbendsite.Text.Trim().Length == 0)) { MessageBox.Show("终点位置是巷道，所以必须指定货架位置！", "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if ((cbKind.Text.Trim().Length > 0) && (txtparm.Text.Trim().Length == 0)) { MessageBox.Show("特殊命令如果不是空值，必须指定特殊参数！", "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if ((cbInWorkBench.Text.Trim().Length > 0) && (cbInWorkBench.Text.Trim().Length == 0)) { MessageBox.Show("是否进工位必须选定！", "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //调用服务 string errtext = string.Empty; string startcell = string.Empty, endcell = string.Empty; int type = 0; if (tbstartsite.SelectedValue != null) { startcell = tbstartsite.SelectedValue.ToString(); } else { startcell = tbstartsite.Text; } if (tbendsite.SelectedValue != null) { endcell = tbendsite.SelectedValue.ToString(); } else { endcell = tbendsite.Text; } if ((cbtype.Text== "18650"||cbtype.Text=="21700")&&cbtype.Visible==true) { type = Convert.ToInt32(cbtype.Text); } else { endcell = tbendsite.Text; } string d = Dns.GetHostEntry("localhost").HostName; if (CStaticClass.UserID != "") { d = Dns.GetHostEntry("localhost").HostName + dbo.GetSingle("select f_username from T_Base_Users where f_userid='" + CStaticClass.UserID + "'").ToString(); } Model.AutoTask at = new Model.AutoTask(Convert.ToInt32(this.cbtasktype.SelectedValue), tbFPALLETBARCODE.Text, cbstartposition.SelectedValue.ToString(), startcell, cbendposition.SelectedValue.ToString(), endcell, this.tbstartsite.Enabled, this.tbendsite.Enabled, Convert.ToInt32(this.cbInWorkBench.Text),type); CStaticClass.WcfControl.BeginBuildAutoTask(d,at, new AsyncCallback(BuildAutoTaskCallBack), at); //{ // MessageBox.Show(errtext, "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error); // return; //} } private void button2_Click(object sender, EventArgs e) { string Sql, _kind, _txtparm; DataSet ds; //dbo.TransBegin(); try { //插入IO_CONTROLDETAIL //特殊命令:堆垛机取坐标001，送坐标002；条码比对003；称重回传004； switch (this.cbKind.Text.Trim()) { case "条码比对": _kind = "003"; break; case "称重回传": _kind = "004"; break; //case "机器人码盘": // _kind = "005"; // break; default: _kind = "003"; break; } _txtparm = this.txtparm.Text.Trim(); if (_kind == "005") { } else { int fid = GetIOControlDetailFid(1, AutoManageIdx); Sql = "insert into IO_CONTROLDETAIL(FID,FCONTROLID,F_ManageTaskKindIndex,FKIND,FINDEX,FVALUE) " + "values(" + fid + "," + AutoManageIdx + ",1,'" + _kind + "',0,'" + _txtparm + "')"; ds = dbo.ExceSQL(Sql); } //dbo.TransCommit(); } catch (Exception ex) { //dbo.TransRollback(); throw ex; } } private void FrmAutoCommand_Load(object sender, EventArgs e) { cbInWorkBench.SelectedIndex = 2; if (cellPanel == null) { cellPanel = new CommonClassLib.UCellPanel(this, tbstartsite, null, string.Empty); cellPanel.TaskType = "100"; cellPanel.GoodsName = ""; cellPanel.Dock = DockStyle.Fill; cellPanel.AllowWareHouseChanged = false; plCell.Controls.Add(cellPanel); } cellPanel.Visible = true; } private void cbtasktype_SelectedIndexChanged(object sender, EventArgs e) { this.tbFPALLETBARCODE.Enabled = true; this.tbFPALLETBARCODE.Text = ""; int IOtype = Convert.ToInt32(this.cbtasktype.SelectedValue.ToString()); DataView dvs = dbo.ExceSQL("SELECT DISTINCT F_StartDevice,F_DeviceName FROM T_Base_Route,T_Base_Device where F_StartDevice = F_DeviceIndex and T_Base_Route.F_RouteKind = " + IOtype).Tables[0].DefaultView; //cbstartposition cbstartposition.ValueMember = "F_StartDevice"; cbstartposition.DisplayMember = "F_DeviceName"; cbstartposition.DataSource = dvs; DataView dvs1 = dbo.ExceSQL("SELECT DISTINCT F_EndDevice,F_DeviceName FROM T_Base_Route,T_Base_Device where F_EndDevice = F_DeviceIndex and T_Base_Route.F_RouteKind = " + IOtype).Tables[0].DefaultView; //cbendposition cbendposition.ValueMember = "F_EndDevice"; cbendposition.DisplayMember = "F_DeviceName"; cbendposition.DataSource = dvs1; } private void cbstartposition_SelectedIndexChanged(object sender, EventArgs e) { tbstartsite.DataSource = null; tbstartsite.Text = ""; int IOtype = Convert.ToInt32(this.cbtasktype.SelectedValue.ToString()); //如果是巷道设备tbstartsite.enable=true DataSet ds = dbo.ExceSQL("select F_DeviceIndex,F_DeviceKindIndex from T_Base_Device where F_DeviceKindIndex=10 and F_DeviceIndex=" + Convert.ToInt32(cbstartposition.SelectedValue) + ""); if (ds.Tables[0].DefaultView.Count > 0) { DataView dvs1 = dbo.ExceSQL("SELECT DISTINCT F_EndDevice,F_DeviceName FROM T_Base_Route,T_Base_Device where F_EndDevice = F_DeviceIndex and F_StartDevice=" + this.cbstartposition.SelectedValue + " and T_Base_Route.F_RouteKind = " + IOtype).Tables[0].DefaultView; //cbendposition cbendposition.ValueMember = "F_EndDevice"; cbendposition.DisplayMember = "F_DeviceName"; cbendposition.DataSource = dvs1; tbstartsite.Enabled = true; this.cbstartposition.Select(); plCell.Enabled = true; if (cellPanel == null) { cellPanel = new CommonClassLib.UCellPanel(this, tbstartsite, null, string.Empty); cellPanel.TaskType = "100"; cellPanel.GoodsName = ""; cellPanel.Dock = DockStyle.Fill; cellPanel.AllowWareHouseChanged = false; plCell.Controls.Add(cellPanel); } cellPanel.ControlCellCode = tbstartsite; cellPanel.Laneway = this.cbstartposition.SelectedValue.ToString(); cellPanel.WareHouse = GetWarehouse(Convert.ToInt32(this.cbstartposition.SelectedValue)); cellPanel.Visible = plCell.Visible; } else { DataView dvs1 = dbo.ExceSQL("SELECT DISTINCT F_EndDevice,F_DeviceName FROM T_Base_Route,T_Base_Device where F_EndDevice = F_DeviceIndex and F_StartDevice=" + this.cbstartposition.SelectedValue + " and T_Base_Route.F_RouteKind = " + IOtype).Tables[0].DefaultView; //cbendposition cbendposition.ValueMember = "F_EndDevice"; cbendposition.DisplayMember = "F_DeviceName"; cbendposition.DataSource = dvs1; this.cbstartposition.Select(); plCell.Enabled = false; tbstartsite.Enabled = false; } DataView dv = dbo.ExceSQL("select F_DeviceIndex,F_DeviceKindIndex from T_Base_Device where F_DeviceKindIndex=11 and F_DeviceIndex=" + Convert.ToInt32(cbstartposition.SelectedValue) + "").Tables[0].DefaultView; if (dv.Count > 0) { tbstartsite.Enabled = true; dv = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceName, T_Base_Device.F_DeviceIndex FROM T_Base_AGV_Gate,T_Base_Device WHERE T_Base_AGV_Gate.F_AGVGateDeviceIndex = T_Base_Device.F_DeviceIndex and F_ChannelsIndex=" + cbstartposition.SelectedValue + "").Tables[0].DefaultView; tbstartsite.DisplayMember = "F_DeviceName"; tbstartsite.ValueMember = "F_DeviceIndex"; tbstartsite.DataSource = dv; } if ("22367,22371,22375,22379,22383,22164,22160,22156,22152,22148,22144".IndexOf(cbstartposition.SelectedValue.ToString()) >= 0) { lbtype.Visible = true; cbtype.Visible = true; } else { lbtype.Visible = false; cbtype.Visible = false; } //tbstartsite.DataSource = null; //tbstartsite.Text = ""; ////如果是巷道设备tbstartsite.enable=true //DataSet ds = dbo.ExceSQL("select F_DeviceIndex,F_DeviceKindIndex from T_Base_Device where F_DeviceKindIndex=10 and F_DeviceIndex=" +Convert.ToInt32( cbstartposition.SelectedValue )+ ""); //if (ds.Tables[0].DefaultView.Count > 0) //{ // tbstartsite.Enabled = true; // plCell.Enabled = true; // if (cellPanel == null) // { // cellPanel = new CommonClassLib.UCellPanel(this, tbstartsite, null, string.Empty); // cellPanel.TaskType = "100"; // cellPanel.GoodsName = ""; // cellPanel.Dock = DockStyle.Fill; // cellPanel.AllowWareHouseChanged = false ; // plCell.Controls.Add(cellPanel); // } // cellPanel.ControlCellCode = tbstartsite; // cellPanel.Laneway = this.cbstartposition.SelectedValue.ToString(); // cellPanel.WareHouse = GetWarehouse(Convert.ToInt32(this.cbstartposition.SelectedValue)); // cellPanel.Visible = plCell.Visible; //} //else //{ // plCell.Enabled = false; // tbstartsite.Enabled = false; //} //DataView dv = dbo.ExceSQL("select F_DeviceIndex,F_DeviceKindIndex from T_Base_Device where F_DeviceKindIndex=11 and F_DeviceIndex=" + Convert.ToInt32(cbstartposition.SelectedValue) + "").Tables[0].DefaultView; //if (dv.Count > 0) //{ // tbstartsite.Enabled = true; // dv = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceName, T_Base_Device.F_DeviceIndex FROM T_Base_AGV_Gate,T_Base_Device WHERE T_Base_AGV_Gate.F_AGVGateDeviceIndex = T_Base_Device.F_DeviceIndex and F_ChannelsIndex=" + cbstartposition.SelectedValue + "").Tables[0].DefaultView; // tbstartsite.DisplayMember = "F_DeviceName"; // tbstartsite.ValueMember = "F_DeviceIndex"; // tbstartsite.DataSource = dv; //} } private void cbendposition_SelectedIndexChanged(object sender, EventArgs e) { tbendsite.DataSource = null; tbendsite.Text = ""; //如果是巷道设备tbstartsite.enable=true DataSet ds = dbo.ExceSQL("select F_DeviceIndex,F_DeviceKindIndex from T_Base_Device where F_DeviceKindIndex=10 and F_DeviceIndex= " + Convert.ToInt32(cbendposition.SelectedValue) + ""); if (ds.Tables[0].DefaultView.Count > 0) { tbendsite.Enabled = true; plCell.Enabled = true; if (cellPanel == null) { cellPanel = new CommonClassLib.UCellPanel(this, tbendsite, null, string.Empty); cellPanel.TaskType = "100"; cellPanel.GoodsName = ""; cellPanel.Dock = DockStyle.Fill; cellPanel.AllowWareHouseChanged = false; plCell.Controls.Add(cellPanel); } cellPanel.ControlCellCode = tbendsite; cellPanel.Laneway = this.cbendposition.SelectedValue.ToString(); cellPanel.WareHouse = GetWarehouse(Convert.ToInt32(this.cbendposition.SelectedValue)); cellPanel.Visible = plCell.Visible; } else { plCell.Enabled = false; tbendsite.Enabled = false; } DataView dv = dbo.ExceSQL("select F_DeviceIndex,F_DeviceKindIndex from T_Base_Device where F_DeviceKindIndex=11 and F_DeviceIndex=" + Convert.ToInt32(cbendposition.SelectedValue) + "").Tables[0].DefaultView; if (dv.Count > 0) { tbendsite.Enabled = true; dv = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceName, T_Base_Device.F_DeviceIndex FROM T_Base_AGV_Gate,T_Base_Device WHERE T_Base_AGV_Gate.F_AGVGateDeviceIndex = T_Base_Device.F_DeviceIndex and F_ChannelsIndex=" + cbendposition.SelectedValue + "").Tables[0].DefaultView; tbendsite.DisplayMember = "F_DeviceName"; tbendsite.ValueMember = "F_DeviceIndex"; tbendsite.DataSource = dv; } } int GetIOControlDetailFid(int ManageTaskKindIndex, int FCONTROLID) { DataSet ds = dbo.ExceSQL("SELECT MAX(FID) AS MaxFID FROM IO_CONTROLDETAIL GROUP BY F_ManageTaskKindIndex, FCONTROLID HAVING (F_ManageTaskKindIndex = " + ManageTaskKindIndex + ") AND (FCONTROLID = " + FCONTROLID + ")"); if (ds.Tables[0].DefaultView.Count > 0) { return (Convert.ToInt32(ds.Tables[0].DefaultView[0]["MaxFID"]) + 1); } else { return 1; } } void BuildAutoTaskCallBack(IAsyncResult ar) { string errtext = string.Empty; if (CStaticClass.WcfControl.EndBuildAutoTask(out errtext, ar) == false) { MessageBox.Show(errtext, "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } private void FrmAutoCommand_FormClosing(object sender, FormClosingEventArgs e) { _formInstance = null; } string GetWarehouse(int laneway) { DataView dv = dbo.ExceSQL(string.Format("SELECT DISTINCT FWAREHOUSE FROM ST_CELL WHERE (FLaneWay = {0})", laneway)).Tables[0].DefaultView; if (dv.Count > 0) { return dv[0][0].ToString(); } else { return "01"; } } } }