using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ST = HH.WCS.NongFuChaYuan.OtherService.STAttribute;

namespace HH.WCS.NongFuChaYuan.WmsService
{
    [SugarTable("dbo.HangChaAGV")]
    public class HangChaAGV : BaseModel
    {
        public string ext4 { get; set; }
        public string ext3 { get; set; }
        public string ext2 { get; set; }
        public string ext1 { get; set; }
        public DateTime createDate { get; set; }
        public string agvErrMsg { get; set; }
        public string faildCode { get; set; }
        public string ext5 { get; set; }
        public string errCode2 { get; set; }
        public string agvRunStatus { get; set; }
        public string agvCurrTaskInfo { get; set; }
        public string agvBattery { get; set; }
        public string agvYPos { get; set; }
        public string agvXPos { get; set; }
        public string agvNo { get; set; }
        public string agvErrCode { get; set; }
        public string ext6 { get; set; }
    }


    //---------------------------------------工单信息---------------------------------------


    #region 大明山中间表

    [SugarTable("dbo.MarginAGV")]
    public class MarginAGV : BaseModel
    {
        public int agvNo { get; set; }
        public int marginGroup { get; set; }
        /// <summary>
        /// 状态  0-无状态   1-充电中   2-充电完成
        /// </summary>
        public int state { get; set; }
        public DateTime dateTime { get; set; }
        public string singNo { get; set; } = "1";
    }

    [ST("成品工单表")]
    public class WorkOrder : BaseModel
    {
        //public DateTime T_CREATE { get; set; }
        /// <summary>
        /// 数据编号ID
        /// </summary>
        //public string SQL_id { get; set; }
        /// <summary>
        /// 即产即用
        /// </summary>
        //public string S_UsingNo { get; set; }//目前不使用，无即产即用需求
        /// <summary>
        /// 批次号
        /// </summary>
        public string S_BatchNo { get; set; }
        /// <summary>
        /// 产线号
        /// </summary>
        public string S_PLineNo { get; set; }
        /// <summary>
        /// 瓶盖机机无，翻斗机线边区连接到翻斗机暂存区
        /// </summary>
        //public string S_LinkLineNO { get; set; }//

        public string S_ItemLayer { get; set; } //物料层数

        public string S_ORDER_TYPE { get; set; }//工单类型
        /// <summary>
        /// 工单状态
        /// </summary>
        public string S_WorkState { get; set; }//S_WorkState
        /// <summary>
        /// 工单号
        /// </summary>
        public string S_WorkNo { get; set; }//S_WorkNo
        /// <summary>
        /// 物料编码
        /// </summary>
        public string S_ItemCode { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        //public string S_ItemName { get; set; }//S_ItemName
        /// <summary>
        /// 当前工单执行时间
        /// </summary>
        //public string S_Modify { get; set; }//S_Modify
        /// <summary>
        /// 当前工单结束时间
        /// </summary>
        //public string S_PLAN_END { get; set; }//
        /// <summary>
        /// 下线托盘类型
        /// </summary>
        public string S_TrayType { get; set; }
        public string S_StartLoca { get; set; }
        public string S_EndLoca { get; set; }
        public int S_YiKuNum { get; set; }
        /// <summary>
        /// 托规
        /// </summary>
        public string S_TrayRules { get; set; }
        public string S_ItemName { get; set; }
    }


    [ST("坯盖工单表")]
    public class PGWorkOrder : BaseModel
    {
        /// <summary>
        /// 工单号
        /// </summary>
        public string S_WorkNo { get; set; }
        /// <summary>
        /// 产线号
        /// </summary>
        public string S_PLineNo { get; set; }
        /// <summary>
        /// 工单类型
        /// </summary>
        public string S_ORDER_TYPE { get; set; }
        /// <summary>
        /// 工单状态
        /// </summary>
        public string S_WorkState { get; set; }
        /// <summary>
        /// 物料编码
        /// </summary>
        public string S_ItemCode { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        public string S_ItemName { get; set; }
        /// <summary>
        /// 总数
        /// </summary>
        public string S_Total { get; set; }
        /// <summary>
        /// 是否即产即用
        /// </summary>
        public string S_UsingNow { get; set; }
        /// <summary>
        /// 连接产线
        /// </summary>
        public string S_LinkLineNo { get; set; }
        /// <summary>
        /// 连接区域
        /// </summary>
        public string S_Area { get; set; }
        /// <summary>
        /// 连接产线2
        /// </summary>
        public string S_LinkLineNo2 { get; set; }
        /// <summary>
        /// 连接区域2
        /// </summary>
        public string S_Area2 { get; set; }
        /// <summary>
        /// 即产每筐报工数量
        /// </summary>
        public string S_PCNumber { get; set; }
        /// <summary>
        /// 非即产每筐报工数量
        /// </summary>
        public string S_PCNumber1 { get; set; }
        /// <summary>
        /// 自动结束工单
        /// </summary>
        public string S_AutoComplete { get; set; }
        /// <summary>
        /// 已执行数量
        /// </summary>
        public string S_Current { get; set; }
        /// <summary>
        /// 关联工单号
        /// </summary>
        public string S_Order_WorkNo { get; set; }
    }


    [ST("AGV设备信息")]
    public class AGVDeviceDataTable : BaseModel
    {
        /// <summary>
        /// 车辆类型
        /// </summary>
        public string equipmentType { get; set; }
        /// <summary>
        /// 车辆型号
        /// </summary>
        public string equipmentMold { get; set; }
        /// <summary>
        /// 车辆铭牌号
        /// </summary>
        public string equipmentCode { get; set; }
        /// <summary>
        /// 车辆区域
        /// </summary>
        public string equipmentArea { get; set; }
        /// <summary>
        /// 对应工厂编号
        /// </summary>
        public string orgCode { get; set; }
        /// <summary>
        /// 车辆投放状态
        /// </summary>
        public string equipmentStatus { get; set; }
        /// <summary>
        /// 唯一标识码
        /// </summary>
        public string proxyInterfaceCode { get; set; }
        /// <summary>
        /// 工厂名称
        /// </summary>
        public string orgName { get; set; }
        /// <summary>
        /// 车辆编码
        /// </summary>
        public string equipmentNo { get; set; }
    }

    [ST("任务类型转换表")]
    public class TaskTypeConvTable : BaseModel
    {
        public string taskTypeName { get; set; }
        public string taskType { get; set; }
    }

    [ST("富勒下线表")]
    public class DaMingShanDeviceState : BaseModel
    {
        /// <summary>
        /// 产线号
        /// </summary>
        public string DeviceName { get; set; }
        /// <summary>
        /// 第一次收到产线下线信号时间-仅更新一次
        /// </summary>
        public string DeviceTime { get; set; }
        /// <summary>
        /// 设备状态标识
        /// --0-默认值：收到下线信号可以更新 DeviceStartTime
        /// --1-锁定值：更新 DeviceStartTime 值之后，更改此值，此时不允许更新 DeviceStartTime 值，等到取货完成恢复为0
        /// </summary>
        public string DeviceState { get; set; }
    }


    [SugarTable("dbo.DaMingShanAnalysisMoveLib")]
    public class DaMingShanAnalysisMoveLib : BaseModel
    {
        /// <summary>
        /// 产线号
        /// </summary>
        public string DeviceName { get; set; }
        /// <summary>
        /// 排号
        /// </summary>
        public string RowNo { get; set; }
        public string Batch { get; set; }

        //public string AreaCode { get; set; }
    }



    [ST("盘库中间表")]
    public class DaMingShanPanKuTask : BaseModel
    {
        /// <summary>
        /// 产线号
        /// </summary>
        public string S_PLineNo { get; set; }
        /// <summary>
        /// 批次号
        /// </summary>
        public string S_BatchNo { get; set; }
        /// <summary>
        /// 物料编码
        /// </summary>
        public string S_ItemCode { get; set; }
        /// <summary>
        /// 品项
        /// </summary>
        public string SQL_Condition { get; set; }
        /// <summary>
        /// 排
        /// </summary>
        [SugarColumn(IsPrimaryKey = true)]
        public string N_ROW { get; set; }
        /// <summary>
        /// 数量
        /// </summary>
        public int N_CURRENT_NUM { get; set; }
        /// <summary>
        /// 库区编码
        /// </summary>
        public string S_AREA_CODE { get; set; }
    }


    [SugarTable("dbo.HttpRepeatSend")]
    public class HttpRepeatSend : BaseModel
    {
        /// <summary>
        /// 发送URL
        /// </summary>
        public string Url { get; set; }
        /// <summary>
        /// 接口名
        /// </summary>
        public string UrlName { get; set; }
        /// <summary>
        /// 发送参数
        /// </summary>
        public string SendMsg { get; set; }
        /// <summary>
        /// 发送次数
        /// </summary>
        public int SendNum { get; set; }
    }

    [ST("大明山富勒托盘表")]
    public class DaMingShanTrayInfo : BaseModel
    {
        /// <summary>
        /// 产线号
        /// </summary>
        public string deviceName { get; set; }
        /// <summary>
        /// 工单号
        /// </summary>
        public string workNo { get; set; }
        /// <summary>
        /// 托盘码
        /// </summary>
        public string trayCode { get; set; }
        /// <summary>
        /// 托盘数量
        /// </summary>
        public string trayNum { get; set; }
        /// <summary>
        /// 富勒接收到托盘码的时间
        /// </summary>
        public string dateTime { get; set; }
        /// <summary>
        /// 批次号--同标准托规
        /// </summary>
        public string batchNo { get; set; }
        /// <summary>
        /// 标准托规
        /// --成品下线：因存在中途切换 生产物料 动作；因此将 批次号、物料层高以及托规 存在于物料信息接口
        /// --不一定每次都有值，当首次托规与 trayNum 相同时，需更新至 Mobox 工单对应字段
        /// --后续收到托规时，先判断当前物料托规 与 工单托规是否相同，不同即代表换物料了
        /// </summary>
        public string trayRule { get; set; }
        /// <summary>
        /// 物料层高-6、7、8--同标准托规
        /// </summary>
        public string itemLayer { get; set; }
        public string positionCode { get; set; }
    }

    [ST("大明山富勒锁定表")]
    public class FuleLock : BaseModel
    {
        public string RowNo { get; set; }
        /// <summary>
        /// 1:锁定 2:解锁
        /// </summary>
        public string LockState { get; set; }
    }
    #endregion
}