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
|
}
|
