MES / IOT · Files

using Hh.Mes.POJO.Entity;
using Microsoft.AspNetCore.Http;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Text;

namespace Hh.Mes.POJO.Entity
{
    public class base_entity
    {
        /// <summary>
        /// 建立时间
        /// </summary>
        [SugarColumn(ColumnDescription = "建立时间", IsNullable = true)]
        public DateTime createTime { get; set; }

        /// <summary>
        /// 建立者
        /// </summary>
        [SugarColumn(Length = 50, ColumnDescription = "建立者", IsNullable = true)]
        public string createBy { get; set; }

        /// <summary>
        /// 更新时间
        /// </summary>
        [SugarColumn(ColumnDescription = "更新时间", IsNullable = true)]
        public DateTime updateTime { get; set; }

        /// <summary>
        /// 更新者
        /// </summary>
        [SugarColumn(Length = 50, ColumnDescription = "更新者", IsNullable = true)]
        public string updateBy { get; set; }

        [SugarColumn(IsIgnore = true)]
        public bool Exel { get; set; }
    }

    public class base_Entity
    {
        [SugarColumn(IsIgnore = true)]
        public bool Exel { get; set; }
    }

    public partial class sys_interface_log
    {
        //最早日志时间
        [SugarColumn(IsIgnore = true)]
        public DateTime? BeginLogTime { get; set; }

        //最晚日志时间
        [SugarColumn(IsIgnore = true)]
        public DateTime? EndLogTime { get; set; }

        //response http  不是 200
        [SugarColumn(IsIgnore = true)]
        public string responseNo200 { get; set; }
    }




    public partial class sys_File
    {
        /// <summary>
        /// 文件
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public List<IFormFile> excelfile { get; set; }
    }



    public partial class base_material
    {
        /// <summary>
        /// 新增，更新，删除标识Flag 0 新增 1 更新，2 删除
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int flag { get; set; }

        [SugarColumn(IsIgnore = true)]
        public string codeOrName { get; set; }
    }


    public partial class base_project
    {
        /// <summary>
        /// projectMapList 读取项目对应设备信息
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string flag { get; set; }


        /// <summary>
        /// 设备运行
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int eqRunCount { get; set; }

        /// <summary>
        /// 设备待机 空闲
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int eqFreeCount { get; set; }

        /// <summary>
        /// 设备故障
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int eqFailureCount { get; set; }


        /// <summary>
        /// 设备离线
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public int eqOfflineCount { get; set; }

        /// <summary>
        /// 客户关联的多个项目拼接串
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string projectKeysString { get; set; }


        /// <summary>
        /// 项目客户登入用户
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string projectUsers { get; set; }


        /// <summary>
        /// 项目客户名称
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string projectClientNames { get; set; }

        /// <summary>
        /// 是否有报警未处理
        /// </summary>
        [NotMapped]
        public bool isHaveAlarm { get; set; }

        /// <summary>
        /// 是否有待保养
        /// </summary>
        [NotMapped]
        public bool isHaveMaintain { get; set; }


        /// <summary>
        /// 项目角色 字符串隔开
        /// </summary>
        [NotMapped]
        public string projectRoles { get; set; }
    }

    public partial class base_factory
    {
        /// <summary>
        /// 客户关联的多个项目拼接串
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string projectKeysString { get; set; }

        /// <summary>
        /// 下拉框项目对应的厂房筛选条件
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string factorySelectWhere { get; set; }
    }

    public partial class base_equipment
    {
        /// <summary>
        /// 文件
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public List<IFormFile> excelfile { get; set; }

        /// <summary>
        /// VPN虚拟IP
        /// </summary>
        [SugarColumn(IsIgnore = true)]
        public string virtualIP { get; set; }

        /// <summary>
        /// SIM卡IP
        /// </summary>

        [SugarColumn(IsIgnore = true)]
        public string simIP { get; set; }

        /// <summary>
        /// 网关序列号
        /// </summary>

        [SugarColumn(IsIgnore = true)]
        public string serialNumber { get; set; }

    }

    public partial class daq_equipment_alarm_record
    {
        /// <summary>
        /// 异常处理方式
        /// </summary>
        [NotMapped]
        public string HandleInfo { get; set; }

        /// <summary>
        /// 异常处理人员
        /// </summary>
        [NotMapped]
        public string HandleUser { get; set; }

        /// <summary>
        /// 故障类别
        /// </summary>
        [NotMapped]
        public string FaultType { get; set; }

        /// <summary>
        /// 原因方
        /// </summary>
        [NotMapped]
        public string Reason { get; set; }


        [NotMapped]
        public string WarehouseCodeExt { get; set; }

        /// <summary>
        /// 追加报警处理记录
        /// </summary>
        [NotMapped]
        public string AddAlarmHanded { get; set; }


        /// <summary>
        /// 追加报警处理记录 密码
        /// </summary>
        [NotMapped]
        public string AddAlarmHandedPwd { get; set; }

        /// <summary>
        /// 项目keys
        /// </summary>
        [NotMapped]
        public string projectKeys { get; set; }

        /// <summary>
        /// projectName
        /// </summary>
        [NotMapped]
        public string projectName { get; set; }

        /// <summary>
        /// ids 多选处理报警时传入多个id值
        /// </summary>
        [NotMapped]
        public string ids { get; set; }
    }

    public partial class bus_equipment_alarm_handle
    {
        /// <summary>
        /// 处理时间 范围 选择的开始时间
        /// </summary>
        [NotMapped]
        public DateTime? Created { get; set; }

        /// <summary>
        /// 处理时间 范围 选择的结束时间
        /// </summary>
        [NotMapped]
        public DateTime? Updated { get; set; }


        /// <summary>
        /// 项目名称 查询使用
        /// </summary>
        [NotMapped]
        public string projectName { get; set; }
        
    }

    public partial class base_project_client_info
    {

        [SugarColumn(IsIgnore = true)]
        public bool Exel { get; set; }
    }

    public partial class base_sim
    {
        /// <summary>
        /// vpn账号
        /// </summary>
        [NotMapped]
        public string vpnNumber { get; set; }

        /// <summary>
        /// 网关序列号
        /// </summary>
        [NotMapped]
        public string gatewaySerialNumber { get; set; }

        /// <summary>
        /// vpnkey
        /// </summary>
        [NotMapped]
        public Guid vpnKey { get; set; }

        /// <summary>
        /// 网关key
        /// </summary>
        [NotMapped]
        public Guid gatewayKey { get; set; }

        /// <summary>
        /// 是否领用标记
        /// </summary>
        [NotMapped]
        public bool isUse { get; set; } = false;
    }

    public partial class base_gateway
    {
        /// <summary>
        /// 虚拟IP
        /// </summary>
        [NotMapped]
        public string virtualIP { get; set; } 

        /// <summary>
        /// 网关客户
        /// </summary>
        [NotMapped]
        public string gatewayClient { get; set; }


        /// <summary>
        /// SIM卡号
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "卡号", IsNullable = false, IsIgnore = true)]
        public string simId { get; set; }

        /// <summary>
        /// sim卡ICCID码
        /// </summary>
        [SugarColumn(Length = 50, ColumnDescription = "SIM卡ICCID码", IsNullable = false, IsIgnore = true)]
        public string simNumber { get; set; }

        /// <summary>
        /// IP地址
        /// </summary>
        [SugarColumn(Length = 50, ColumnDescription = "IP地址", IsNullable = true, IsIgnore = true)]
        public string simIP { get; set; }

        /// <summary>
        /// 供应商 默认值长沙华恒机器人
        /// </summary>
        [SugarColumn(Length = 50, ColumnDescription = "供应商 默认值长沙华恒机器人", IsNullable = true, IsIgnore = true)]
        public string suppliersInfo { get; set; }

        /// <summary>
        /// 是否是虚拟卡
        /// </summary>
        [SugarColumn(ColumnDescription = "是否是虚拟卡", IsNullable = true, IsIgnore = true)]
        public bool isVirtual { get; set; }

        /// <summary>
        /// 状态 0删除 1启用
        /// </summary>
        [SugarColumn(ColumnDescription = "状态 0删除 1启用", IsNullable = true, IsIgnore = true)]
        public int isDelete { get; set; }

        /// <summary>
        /// 领卡人
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "领卡人", IsNullable = true, IsIgnore = true)]
        public string getCardUser { get; set; }

        /// <summary>
        /// 领卡时间
        /// </summary>
        [SugarColumn(ColumnDescription = "领卡时间", IsNullable = true, IsIgnore = true)]
        public DateTime? getCardDate { get; set; } = null;

        /// <summary>
        /// 调试时间
        /// </summary>
        [SugarColumn(ColumnDescription = "调试时间", IsNullable = true, IsIgnore = true)]
        public DateTime? debugDate { get; set; } = null;

        /// <summary>
        /// 出厂日期
        /// </summary>
        [SugarColumn(ColumnDescription = "出厂日期", IsNullable = true, IsIgnore = true)]
        public DateTime factoryDate { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(Length = 500, ColumnDescription = "SIM备注", IsNullable = true, IsIgnore = true)]
        public string simRemark { get; set; }


        /// <summary>
        /// VPN账号
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "VPN账号", IsNullable = false, IsIgnore = true)]
        public string vpnNumber { get; set; }

        /// <summary>
        /// VPN-IP
        /// </summary>
        [SugarColumn(Length = 100, ColumnDescription = "VPN-IP", IsNullable = true, IsIgnore = true)]
        public string vpnIP { get; set; }


        /// <summary>
        /// 备注
        /// </summary>
        [SugarColumn(Length = 2000, ColumnDescription = "备注", IsNullable = true, IsIgnore = true)]
        public string vpnRemark { get; set; }
    }
}