using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DBFactory;

namespace wcfControlMonitorClient
{
    public partial class FrmBrowseRGVInterFace : Form
    {
        DataView dv;
        DBOperator dbo = CStaticClass.dbo;
        string sql = "";

        private static FrmBrowseRGVInterFace _formInstance;

        public static FrmBrowseRGVInterFace FormInstance
        {
            get
            {
                if (_formInstance == null)
                {
                    _formInstance = new FrmBrowseRGVInterFace();
                }
                return _formInstance;
            }
            set { _formInstance = value; }
        }
        public FrmBrowseRGVInterFace()
        {
            InitializeComponent();
        }



        private void taskSearch_Click(object sender, EventArgs e)
        {
           try
           {
               this.interfaceGridView.DataSource = null;
               sql = string.Format("select  FID as '{0}',RGV_TASK_ID as '{1}',RGV_RELATIVE_TASK_ID as '{2}',RGV_TASK_TYPE as '{3}',RGV_TASK_LEVEL as '{4}',PALLET_BARCODE as '{5}',START_DEVICE_CODE as '{6}',END_AREA_CODE as '{7}',FINISH_DEVICE_CODE as '{8}',RGV_TASK_BEGINTIME as '{9}',RGV_TASK_ENDTIME as '{10}',RGV_TASK_STATUS as '{11}',RGV_CODE as '{12}', RGV_HOUSE_CODE as '{13}', REMARK as '{14}'  from  RGV_TASK ",
                "任务编号","环穿任务编号", "关联任务编号", "任务类型","优先级", "条码", "取货位置", "送货区域", "完成位置", "开始时间","完成时间", "任务状态", "RGV车号", "环穿位置","备 注", CStaticClass.UserArea);
            dv = dbo.ExceSQL(sql).Tables[0].DefaultView;


            this.interfaceGridView.DataSource = dv;

            this.labelCounts.Text = string.Format("任务数量:{0}", dv.Count);
           }
           catch (Exception fgkt)
            {
                if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("手工查询任务表时：" + fgkt.Message) < 0)
                {

                    FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "手工查询任务表时：" + fgkt.Message, true);
                }
            }
            finally { }
        }

        private void applySearch_Click(object sender, EventArgs e)
        {
            try
            {
                this.interfaceGridView.DataSource = null;
                sql = string.Format("select APPLY_ID as '{0}',APPLY_TYPE as '{1}',DEVICE_CODE as '{2}',APPLY_STATUS as '{3}',RGV_TASK_ID as '{4}', APPLY_TIME as  '{5}',WAREHOUSE_CODE as '{6}',REMARK as '{7}'  from  APPLY_TASK ",
                    "申请ID", "申请类型", "申请设备编码", "申请状态", "改变目标位置的任务ID", "申请时间", "申请库房编码", "备注", CStaticClass.UserArea);
                dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
                this.interfaceGridView.DataSource = dv;
               this.labelPortCounts.Text = string.Format("申请数量:{0}", dv.Count);
            }
            catch (Exception fgkap)
            {
                if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("手工查询申请表时：" + fgkap.Message) < 0)
                {

                    FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "手工查询申请表时：" + fgkap.Message, true);
                }
            }
        }

        private void routeSearch_Click(object sender, EventArgs e)
        {//20160318
            try
            {
                this.interfaceGridView.DataSource = null;
                sql = string.Format(
                 "select CONTROL_ROUTE_ID as '{0}',CONTROL_ROUTE_TYPE  as '{1}',CONTROL_ROUTE_CODE  as '{2}',CONTROL_ROUTE_NAME  as '{3}',START_DEVICE  as '{4}',END_DEVICE  as '{5}',CONTROL_ROUTE_STATUS  as '{6}',CONTROL_ROUTE_REMARK  as '{7}'  from IO_CONTROL_ROUTE order by CONTROL_ROUTE_ID",
                 "路径索引", " 路径类型", "路径编码", "路径名称", "起点设备", "终点设备", "路径状态[1:可用,0:不可用]", "备注");
                dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
                this.interfaceGridView.DataSource = dv;
                this.labelRGVInfoCounts.Text = string.Format("路径数量:{0}", dv.Count);
            }
            catch (Exception ex)
            {
                if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("手工查询路径表时：" + ex.Message) < 0)
                {

                    FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "手工查询路径表时：" + ex.Message, true);
                }
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                this.interfaceGridView.DataSource = null;
                sql = string.Format(
                 "select IO_CONTROL_DEVICE_CODE as '{0}',IO_CONTROL_DEVICE_STATE  as '{1}',IO_CONTROL_DEVICE_STATE_REMARK  as '{2}' from IO_CONTROL_DEVICE_STATE order by IO_CONTROL_DEVICE_STATE_ID",
                 "设备编号", "是否有货(0:无货,1:有货)","更新时间");
                dv = dbo.ExceSQL(sql).Tables[0].DefaultView;
                this.interfaceGridView.DataSource = dv;
                this.labelDevicesCounts.Text = string.Format("设备数量:{0}", dv.Count);
            }
            catch (Exception ex)
            {
                if (FrmControlMonitor.FormInstance.GetObjectText("tsStatus").IndexOf("手工查询设备状态表时：" + ex.Message) < 0)
                {

                    FrmControlMonitor.FormInstance.FlashPanit("tsStatus", "手工查询设备状态表时：" + ex.Message, true);
                }
            }
        }

        private void RTSMmanagerRestore_Click(object sender, EventArgs e)
        {

        }

        private void RTSMmanageDelete_Click(object sender, EventArgs e)
        {

        }
    }
}