mes-client/PLCDataReader/Device/Information/DeviceStatusInfo.cs

using System;
using DevExpress.XtraEditors;
using UAS_PLCDataReader.DataOperate;
using UAS_PLCDataReader.Entity;
using System.Data;
using System.Text;
using UAS_PLCDataReader.PublicMethod;
using System.Windows.Forms;
using System.Collections.Generic;

namespace UAS_PLCDataReader.Device.Infomation
{
    public partial class DeviceStatusInfo : XtraForm
    {
        DataHelper dh = SystemInf.dh;

        StringBuilder sql = new StringBuilder();

        string de_code = "";

        public DeviceStatusInfo()
        {
            InitializeComponent();
        }

        public DeviceStatusInfo(string DevcieCode)
        {
            InitializeComponent();
            de_code = DevcieCode;
            Text = DevcieCode;
        }

        private void DeviceStatusInfo_Load(object sender, EventArgs e)
        {
            //查询设备基础信息
            sql.Clear();
            sql.Append("select de_linecode,de_wccode,de_name,de_address,de_sourcecode,sc_name from device ");
            sql.Append("left join source on sc_code=de_sourcecode where de_code='" + de_code + "' and rownum<50 ");
            DataTable dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            if (dt.Rows.Count > 0)
            {
                BaseUtil.SetFormValue(Controls, dt);
            }
            //查询设备参数信息
            sql.Clear();
            sql.Append("select dr_updatedate,case when dc_type='INQTY' then '投入' when dc_type='INGORE' then '忽略' when dc_type='OUTQTY' then '产出' when dc_type='NGQTY' then '不良'");
            sql.Append("when dc_type='PARAM1' then de_item1 when dc_type='PARAM2' then de_item2 when dc_type='PARAM3' then de_item3 ");
            sql.Append("when dc_type='PARAM4' then de_item4 when dc_type='PARAM5' then de_item5 when dc_type='PARAM6' then de_item6 ");
            sql.Append("when dc_type='PARAM7' then de_item7 when dc_type='PARAM8' then de_item8 when dc_type='PARAM9' then de_item9 ");
            sql.Append("when dc_type='PARAM10' then de_item10 end dc_name,case when dc_type='INQTY' when dc_type='INGORE' then '忽略' then dr_qty when dc_type='OUTQTY' then dr_okqty when dc_type='NGQTY' then dr_ngqty ");
            sql.Append("when dc_type='TEMPERATURE' then dr_TEMPERATURE when dc_type='PARAM1' then dr_value1 when dc_type='PARAM2' then dr_value2 ");
            sql.Append("when dc_type='PARAM3' then dr_value3 when dc_type='PARAM4' then dr_value4 when dc_type='PARAM5' then dr_value5 ");
            sql.Append("when dc_type='PARAM6' then dr_value6 when dc_type='PARAM7' then dr_value7 when dc_type='PARAM8' then dr_value8 ");
            sql.Append("when dc_type='PARAM9' then dr_value9 when dc_type='PARAM10' then dr_value10 end data from DEVICEPOLLINGCONFIG ");
            sql.Append("left join devicecommand on dpc_dccode = dc_code left join DEVICERUNSTATUS on dpc_decode = dr_decode left join device on dpc_decode=de_code where dpc_decode='"+ de_code + "' order by dc_dataindex");
            GridDeivceStatusInfo.DataSource = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            GridViewDeviceStatusInfo.BestFitColumns();
            sql.Clear();
            //查询设备运行日志
            sql.Append("select * from DEVICERUNRECORD where drr_decode='" + de_code + "' and rownum<50 ");
            GridDeviceRunLog.DataSource = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            GridViewDeviceRunLog.BestFitColumns();
            sql.Clear();
            sql.Append("select '接收'||nvl(dpg_receivedatasize,0)||'字节' dpg_receivedatasize,'发送'||nvl(dpg_senddatasize,0)||'字节' dpg_senddatasize");
            sql.Append(",dpg_onlinetime,dpg_offlinetime,'IP:'||dnc_ip dnc_ip,'端口:'|| dnc_port||',间隔'||dpg_interval||'S' dnc_port,");
            sql.Append("round(to_number(sysdate-DPG_STARTTIME )*1440) dpg_runtime from devicepollinglog left join DEVICENETCONFIG on dnc_decode=dpg_decode ");
            sql.Append("where dpg_id=(select max(dpg_id) from devicepollinglog where dpg_decode='" + de_code + "')");
            dt = (DataTable)dh.ExecuteSql(sql.ToString(), "select");
            if (dt.Rows.Count > 0)
            {
                BaseUtil.SetFormValue(this.Controls, dt);
                string TimeSpan = dt.Rows[0]["dpg_runtime"].ToString();
                dpg_runtime.Text = BaseUtil.MinutesToDayTime(int.Parse(TimeSpan == "" ? "0" : TimeSpan));
            }
        }

        private void DeviceStatusInfo_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Escape)
                Close();
        }
    }
}