2240037_WCSHSCP/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;
        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
           {
               // add for CATL YB2 oracle 修改
               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},START_WAREHOUSE_CODE as {11},CONTROL_REMARK as {12}  from  IO_CONTROL where START_WAREHOUSE_CODE like '%{13}%'",
                "任务编号","关联任务编号","条码","任务类型","优先级","起点","终点","任务状态","开始时间","完成时间","故障信息","仓库编码","备注", CStaticClass.UserArea);
            dv = dboM.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
            {
                // add for CATL YB2 oracle
                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}, CONTROL_APPLY_PARA01 as  {5},CONTROL_APPLY_PARA02 as {6},APPLY_TASK_STATUS as {7},CREATE_TIME as {8},CONTROL_APPLY_REMARK as {9}  from  IO_CONTROL_APPLY where WAREHOUSE_CODE  like '%{10}%' ",
                    "申请ID", "申请类型", "仓库编码", "申请设备编号", "条码", "数量", "备用", "申请状态", "申请时间", "备注", CStaticClass.UserArea);//高度
                dv = dboM.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",
                 "路径索引", " 路径类型", "路径编码", "路径名称", "起点设备", "终点设备", "路径状态", "备注");
                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);
                }
            }
        }



      
    }
}