JNLR_WCS/ControlMonitorClient/FrmBrowseInterFace.cs

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 FrmBrowseInterFace : Form
    {
        DataView dv;
        DBOperator dboM = CStaticClass.dboM;
        DBOperator dbo = CStaticClass.dbo;
        string sql = "";

        private static FrmBrowseInterFace _formInstance;

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



        private void taskSearch_Click(object sender, EventArgs e)
        {
            try
            {
                this.interfaceGridView.DataSource = null;
                sql = string.Format("select  CONTROL_ID as '{0}',RELATIVE_CONTROL_ID as '{1}',STOCK_BARCODE as '{2}',CONTROL_TASK_TYPE as '{3}',CONTROL_TASK_LEVEL as '{4}',START_DEVICE_CODE as '{5}',END_DEVICE_CODE as '{6}',CONTROL_STATUS as '{7}',CONTROL_BEGIN_TIME as '{8}',CONTROL_END_TIME as '{9}',ERROR_TEXT as '{10}' from  IO_CONTROL",
                 "任务编号", "关联任务编号", "托盘条码", "任务类型", "优先级", "起点", "终点", "任务状态", "开始时间", "完成时间", "设备故障信息");
                //dv = dboM.ExceSQL(sql).Tables[0].DefaultView;
                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 CONTROL_APPLY_ID as '{0}',CONTROL_APPLY_TYPE as '{1}',WAREHOUSE_CODE as '{2}',DEVICE_CODE as '{3}',STOCK_BARCODE as '{4}',APPLY_TASK_STATUS as '{5}',CREATE_TIME as '{6}',CONTROL_APPLY_PARA01 as '{7}',CONTROL_APPLY_PARAMETER as  '{8}', CONTROL_APPLY_REMARK as  '{9}'  from  IO_CONTROL_APPLY",
                    "申请ID", "申请类型", "仓库编码", "申请设备编号", "托盘条码", "申请状态", "申请时间", "数量", "物料条码", "备注 ");
                //dv = dboM.ExceSQL(sql).Tables[0].DefaultView;
                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 = dboM.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 = dboM.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);
                }
            }
        }




    }
}