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;
namespace wcfControlMonitorClient
{
    /// <summary>
    /// Creator:Richard.liu
    /// 模仿管理下达自动任务
    /// </summary>
    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 < 1)
            {
                MessageBox.Show("请输入条码！", "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;
            }
            if (panelType.Visible)
            {
                if (this.comboBoxType.Text.Trim() == "")
                {
                    MessageBox.Show("请选择托盘类型！", "操作提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    this.comboBoxType.Focus();
                    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;
            }
            int tasktype = Convert.ToInt32(this.cbtasktype.SelectedValue);
            int count = 0;////借用this.cbInWorkBench.Text传递count
            int pallettype = 0;
            if (tasktype == 5 || tasktype == 6 || (tasktype == 4 && cbstartposition.SelectedValue.ToString() == "12008"))
            {
                if (int.TryParse(this.textBoxCount.Text.Trim(), out count) == false)

                {
                    string message = string.Format("请输入正确的{0}信息！", labelCount.Text);
                    MessageBox.Show(message, "误操作提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
            }

            if (tasktype == 1)//入库时获取是否双叉入库
            {
                count = CheckBoxfork2.Checked ? 2 : 1;

            }
            if (panelType.Visible)
            {
                if (comboBoxType.SelectedIndex > -1)
                {
                    pallettype = comboBoxType.SelectedIndex + 1;//用来保存单叉堆垛机的托盘类型(1小托盘，2大托盘)
                }
            }
            //调用服务
            string errtext = string.Empty;
            string startcell = string.Empty, endcell = string.Empty;
            if (tbstartsite.SelectedValue != null)
            {
                startcell = tbstartsite.SelectedValue.ToString();
            }
            else
            {
                startcell = tbstartsite.Text;
            }
            if (tbendsite.SelectedValue != null)
            {
                endcell = tbendsite.SelectedValue.ToString();
            }
            else
            {
                endcell = tbendsite.Text;
            }
            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, pallettype);//借用this.cbInWorkBench.Text传递pallettype
            CStaticClass.WcfControl.BeginBuildAutoTask(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, tbFPALLETBARCODE, 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 = "";
            string StrSql = string.Format(" and F_WorkArea  like '%{0}%'", CStaticClass.UserArea);
            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 + StrSql).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 + StrSql).Tables[0].DefaultView;
            //cbendposition
            cbendposition.ValueMember = "F_EndDevice";
            cbendposition.DisplayMember = "F_DeviceName";
            cbendposition.DataSource = dvs1;

            labelCount.Visible = false;
            textBoxCount.Visible = false;
            labelCount.Text = "数量";
            labelBarcode.Text = "条码";
            int type = Convert.ToInt32(this.cbtasktype.SelectedValue);

            if (type == 5 || type == 6 || Convert.ToInt32(this.cbstartposition.SelectedValue) == 12008)//离开绿色通道的任务
            {
                //labelCount.Visible = true;
                //textBoxCount.Visible = true;//输入计划数量、绿色通道出库数量、申请出库的通知结果
            }


            if (type == 5)//出库计划
            {
                labelBarcode.Text = "物料条码";
            }
            if (type == 6)//通知出库结果
            {
                labelCount.Text = "结果";
            }
            //CheckBoxfork2.Visible = false;
            //if (Convert.ToInt32(this.cbtasktype.SelectedValue) == 1)//生成双叉自动入库任务
            //{
            //    CheckBoxfork2.Visible = true;

            //}

        }
        private void Cbstartposition_SelectionChangeCommitted(object sender, EventArgs e)
        {
            tbstartsite.DataSource = null;
            tbstartsite.Text = "";
            //如果是巷道设备tbstartsite.enable=true
            DataSet ds = dbo.ExceSQL("select FLaneWay from ST_CELL where FLaneWay=" + Convert.ToInt32(cbstartposition.SelectedValue) + "");
            //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, 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 if (cbstartposition.SelectedValue != null && cbstartposition.SelectedValue.ToString() == "38001")
            {
                tbstartsite.Enabled = true;
                DataView dv1 = dbo.ExceSQL("SELECT F_RGVGateDeviceIndex FROM T_Base_RGV_Gate where F_ChannelsIndex = " + cbstartposition.SelectedValue + "").Tables[0].DefaultView;
                if (dv1.Count > 0)
                {
                    tbstartsite.DisplayMember = "F_RGVGateDeviceIndex";
                    tbstartsite.ValueMember = "F_RGVGateDeviceIndex";
                    tbstartsite.DataSource = dv1;
                }
                else
                {

                    plCell.Enabled = false;
                    tbstartsite.Enabled = false;
                }
            }
            else
            {
                tbstartsite.Enabled = true;
                DataView dv1 = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceName, T_Base_Device.F_DeviceIndex FROM T_Base_Lane_Gate,T_Base_Device WHERE T_Base_Lane_Gate.F_LaneGateDeviceIndex = T_Base_Device.F_DeviceIndex and F_DeviceKindIndex=9 and F_LaneIndex=" + cbstartposition.SelectedValue + "").Tables[0].DefaultView;
                if (dv1.Count > 0)
                {
                    tbstartsite.DisplayMember = "F_DeviceName";
                    tbstartsite.ValueMember = "F_DeviceIndex";
                    tbstartsite.DataSource = dv1;
                }
                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;
            }


            labelCount.Visible = false;
            textBoxCount.Visible = false;

            //int type = Convert.ToInt32(this.cbtasktype.SelectedValue);

            int startdevice = Convert.ToInt32(this.cbstartposition.SelectedValue);
            int enddevice = Convert.ToInt32(this.cbendposition.SelectedValue);
            //if ((startdevice >= 18001 && startdevice <= 18004) || (enddevice >= 18001 && enddevice <= 18004))
            //{
            //    panelType.Visible = true;
            //}
            //else
            //{
            //    panelType.Visible = false;
            //}
            comboBoxType.SelectedIndex = -1;
            comboBoxType.Text = "";
            #region 根据起点更新终点列表
            //string StrSql = string.Format(" and F_WorkArea  like '%{0}%'", CStaticClass.UserArea);
            //int IOtype = Convert.ToInt32(this.cbtasktype.SelectedValue.ToString());
            //dv = 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 + StrSql + "and F_StartDevice = " + Convert.ToInt32(cbstartposition.SelectedValue) + "").Tables[0].DefaultView;

            //if (dv.Count > 0)
            //{
            //    cbendposition.DisplayMember = "F_DeviceName";
            //    cbendposition.ValueMember = "F_DeviceIndex";
            //    cbendposition.DataSource = dv;
            //}
            #endregion

        }
        /*
        private void cbstartposition_SelectedIndexChanged(object sender, EventArgs e)
        {
            tbstartsite.DataSource = null;
            tbstartsite.Text = "";
            //如果是巷道设备tbstartsite.enable=true
            DataSet ds = dbo.ExceSQL("select FLaneWay from ST_CELL where FLaneWay=" + Convert.ToInt32(cbstartposition.SelectedValue) + "");
            //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, 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 if (cbendposition.SelectedValue != null && cbendposition.SelectedValue.ToString() == "38001")
            {
                tbstartsite.Enabled = true;
                DataView dv1 = dbo.ExceSQL("SELECT F_RGVGateDeviceIndex FROM T_Base_RGV_Gate where F_ChannelsIndex = " + cbendposition.SelectedValue + "").Tables[0].DefaultView;
                if (dv1.Count > 0)
                {
                    tbstartsite.DisplayMember = "F_RGVGateDeviceIndex";
                    tbstartsite.ValueMember = "F_RGVGateDeviceIndex";
                    tbstartsite.DataSource = dv1;
                }
                else
                {

                    plCell.Enabled = false;
                    tbstartsite.Enabled = false;
                }
            }
            else
            {
                tbstartsite.Enabled = true;
                DataView dv1 = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceName, T_Base_Device.F_DeviceIndex FROM T_Base_Lane_Gate,T_Base_Device WHERE T_Base_Lane_Gate.F_LaneGateDeviceIndex = T_Base_Device.F_DeviceIndex and F_DeviceKindIndex=9 and F_LaneIndex=" + cbstartposition.SelectedValue + "").Tables[0].DefaultView;
                if (dv1.Count > 0)
                {
                    tbstartsite.DisplayMember = "F_DeviceName";
                    tbstartsite.ValueMember = "F_DeviceIndex";
                    tbstartsite.DataSource = dv1;
                }
                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;
            }


            labelCount.Visible = false;
            textBoxCount.Visible = false;

            //int type = Convert.ToInt32(this.cbtasktype.SelectedValue);

            int startdevice = Convert.ToInt32(this.cbstartposition.SelectedValue);
            int enddevice = Convert.ToInt32(this.cbendposition.SelectedValue);
            //if ((startdevice >= 18001 && startdevice <= 18004) || (enddevice >= 18001 && enddevice <= 18004))
            //{
            //    panelType.Visible = true;
            //}
            //else
            //{
            //    panelType.Visible = false;
            //}
            comboBoxType.SelectedIndex = -1;
            comboBoxType.Text = "";
            #region 根据起点更新终点列表
            //string StrSql = string.Format(" and F_WorkArea  like '%{0}%'", CStaticClass.UserArea);
            //int IOtype = Convert.ToInt32(this.cbtasktype.SelectedValue.ToString());
            //dv = 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 + StrSql + "and F_StartDevice = " + Convert.ToInt32(cbstartposition.SelectedValue) + "").Tables[0].DefaultView;

            //if (dv.Count > 0)
            //{
            //    cbendposition.DisplayMember = "F_DeviceName";
            //    cbendposition.ValueMember = "F_DeviceIndex";
            //    cbendposition.DataSource = dv;
            //}
            #endregion


        }
        */
        private void cbendposition_SelectedIndexChanged(object sender, EventArgs e)
        {
            tbendsite.DataSource = null;
            tbendsite.Text = "";
            //如果是巷道设备tbstartsite.enable=true
            DataSet ds = dbo.ExceSQL("select FLaneWay from ST_CELL where FLaneWay=" + Convert.ToInt32(cbendposition.SelectedValue) + "");

            //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, 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 if (cbendposition.SelectedValue != null && cbendposition.SelectedValue.ToString() == "38001")
            {
                tbendsite.Enabled = true;
                DataView dv1 = dbo.ExceSQL("SELECT F_RGVGateDeviceIndex FROM T_Base_RGV_Gate where F_ChannelsIndex = " + cbendposition.SelectedValue + "").Tables[0].DefaultView;
                if (dv1.Count > 0)
                {
                    tbendsite.DisplayMember = "F_RGVGateDeviceIndex";
                    tbendsite.ValueMember = "F_RGVGateDeviceIndex";
                    tbendsite.DataSource = dv1;
                }
                else
                {

                    plCell.Enabled = false;
                    tbendsite.Enabled = false;
                }
            }
            else
            {
                tbendsite.Enabled = true;
                DataView dv1 = dbo.ExceSQL("SELECT T_Base_Device.F_DeviceName, T_Base_Device.F_DeviceIndex FROM T_Base_Lane_Gate,T_Base_Device WHERE T_Base_Lane_Gate.F_LaneGateDeviceIndex = T_Base_Device.F_DeviceIndex  and F_DeviceKindIndex=9 and F_LaneIndex=" + cbendposition.SelectedValue + "").Tables[0].DefaultView;
                if (dv1.Count > 0)
                {
                    tbendsite.DisplayMember = "F_DeviceName";
                    tbendsite.ValueMember = "F_DeviceIndex";
                    tbendsite.DataSource = dv1;
                }
                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 startdevice = Convert.ToInt32(this.cbstartposition.SelectedValue);
            int enddevice = Convert.ToInt32(this.cbendposition.SelectedValue);
            //if ((startdevice >= 18001 && startdevice <= 18004) || (enddevice >= 18001 && enddevice <= 18004))
            //{
            //    panelType.Visible = true;
            //}
            //else
            //{
            //    panelType.Visible = false;
            //}
        }

        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";
            }
        }

    }
}