using HH.WCS.JingyuNongfu.util;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace HH.WCS.JingyuNongfu.wms
|
{
|
|
|
|
|
//---------------------------------------工单信息---------------------------------------
|
|
|
[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_BatchNo { get; set; }
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string S_PLineNo { get; set; }
|
/// <summary>
|
/// 瓶盖机机无，翻斗机线边区连接到翻斗机暂存区
|
/// </summary>
|
public string S_LinkLineNO { get; set; }
|
/// <summary>
|
/// 连接区域,瓶盖机连接v8或无；翻斗机连接线边区
|
/// </summary>
|
public string S_Area { get; set; }
|
public string S_Area2 { get; set; }
|
//SQL_LinkLineNo2
|
[SugarColumn(ColumnName = "S_LinkLineNo2")]
|
public string S_LinkLineNO1 { get; set; }
|
/// <summary>
|
/// 即产即用
|
/// </summary>
|
public string S_UsingNow { get; set; }//SQL_UsingNow "Y"|"N"
|
/// <summary>
|
/// 外调
|
/// </summary>
|
// public string S_Out { get; set; }//SQL_Out "Y"|"N"
|
/// <summary>
|
/// 工单状态
|
/// </summary>
|
public string S_WorkState { get; set; }//SQL_State
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string S_WorkNo { get; set; }//SQL_WorkNo
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string S_ItemCode { get; set; }
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
public string S_ItemName { get; set; }//SQL_ItemName
|
/// <summary>
|
/// 总数
|
/// </summary>
|
public string S_Total { get; set; }//SQL_Total
|
/// <summary>
|
/// 即产即用数量
|
/// </summary>
|
// public string S_UsingNowTotal { get; set; }
|
|
/// <summary>
|
/// 每批运输数量
|
/// </summary>
|
public string S_PCNumber { get; set; }//SQL_PCNumber
|
public string S_PCNumber1 { get; set; }//SQL_PCNumber
|
/// <summary>
|
/// 计数（已执行数量）
|
/// </summary>
|
public string S_Current { get; set; }//SQL_Current
|
/// <summary>
|
/// 当前工单执行时间
|
/// </summary>
|
//public string S_Modify { get; set; }//SQL_Modify
|
/// <summary>
|
/// 当前工单结束时间
|
/// </summary>
|
// public string S_PLAN_END { get; set; }
|
/// <summary>
|
/// 是、否
|
/// </summary>
|
public string S_AutoComplete { get; set; }
|
|
|
}
|
|
|
[ST("成品工单表")]
|
public class WorkOrder1 : BaseModel
|
{
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string S_BatchNo { get; set; }
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string S_PLineNo { get; set; }
|
/// <summary>
|
/// 状态
|
/// </summary>
|
public string S_WorkState { get; set; }//SQL_State
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string S_WorkNo { get; set; }//SQL_WorkNo
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string S_ItemCode { get; set; }
|
public string SQL_ItemName { get; set; }
|
public string SQL_Area { get; set; }
|
public string S_TrayType { get; set; }
|
public int maxTask { get; set; }
|
public int trayHeight { get; set; }
|
public string S_ItemLayer { get; set; }
|
/// <summary>
|
/// 是/否 有码和无码模式
|
/// </summary>
|
public string withCode { get; set; }
|
public string SQL_Area1 { get; set; }
|
public string SQL_Area2 { get; set; }
|
public string S_ORDER_TYPE { get; set; }
|
}
|
|
[ST("移库工单表")]
|
public class WorkOrder2 : BaseModel
|
{
|
|
/// <summary>
|
/// 状态
|
/// </summary>
|
public string SQL_State { get; set; }//SQL_State
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string SQL_WorkNo { get; set; }//SQL_WorkNo
|
|
public string start_area { get; set; }
|
public string end_area { get; set; }
|
public int start_row { get; set; }
|
public int end_row { get; set; }
|
public int priority { get; set; }
|
|
public string note { get; set; }
|
public string size { get; set; }
|
public string IsUnlock { get; set; }
|
/// <summary>
|
/// 移库任务数量
|
/// </summary>
|
public int number { get; set; }
|
/// <summary>
|
/// 当前移库数量
|
/// </summary>
|
public int current { get; set; }
|
}
|
|
[ST("顶升机工单表")]
|
public class WorkOrder3 : BaseModel
|
{
|
/// <summary>
|
/// 状态
|
/// </summary>
|
public string S_WorkState { get; set; }//SQL_State
|
/// <summary>
|
/// 产线号
|
/// </summary>
|
public string S_PLineNo { get; set; }
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string S_WorkNo { get; set; }//SQL_WorkNo
|
|
}
|
|
[ST("领料工单表")]
|
public class OutWorkOrder : BaseModel
|
{
|
/// <summary>
|
/// 工单号
|
/// </summary>
|
public string WorkNo { get; set; }
|
/// <summary>
|
/// 领料单号
|
/// </summary>
|
public string WorkFromNo { get; set; }
|
public string ItemCode { get; set; }
|
public string ItemName { get; set; }
|
public int OutAreaNum { get; set; }
|
public string DeviceNo { get; set; }
|
public int CurrQty { get; set; }
|
}
|
|
[ST("成品空托入库计划表")]
|
public class CPEmptyIn : BaseModel
|
{
|
public string cntrType { get; set; }
|
public string area { get; set; }
|
public int priority { get; set; }
|
public int startRow { get; set; }
|
public string endArea { get; set; }
|
public int endRow { get; set; }
|
}
|
[ST("成品空托出库库计划表")]
|
public class CPEmptyOut : BaseModel
|
{
|
public string cntrType { get; set; }
|
public string area { get; set; }
|
public int priority { get; set; }
|
public int row { get; set; }
|
|
}
|
|
[ST("富勒托盘表")]
|
public class ThirdPartTrayInfo : 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; }
|
}
|
|
[ST("物料区域优先级表")]
|
public class ItemZonePriInfo : BaseModel
|
{
|
public string S_ITEM_CODE { get; set; }
|
public string S_ITEM_NAME { get; set; }
|
public string S_AREA_CODE { get; set; }
|
public string S_TRAY_TYPE { get; set; }
|
public int S_PRIORITY { get; set; }
|
}
|
/// <summary>
|
/// 移库单执行时创建，调富勒后更新IsNotice=1，移库单完成时State=1，IsNotice=0，再次通知富勒后删除
|
/// </summary>
|
public class MoveOrderNotice : BaseModel
|
{
|
/// <summary>
|
/// 移库单号
|
/// </summary>
|
public string OrderNo { get; set; }
|
public string StartArea { get; set; }
|
public string EndArea { get; set; }
|
/// <summary>
|
/// wcs遍历移库单，发现执行中的就检查此表，如果没数据就插入，state是0，移库单完成时state更新成1。
|
/// </summary>
|
public int State { get; set; }
|
/// <summary>
|
/// 0是没通知，1是已通知
|
/// </summary>
|
public int IsNotice { get; set; }
|
}
|
|
/// <summary>
|
/// 入库完成或者移库完成时写入，通知富勒后删除
|
/// </summary>
|
public class InOutRecord : BaseModel
|
{
|
/// <summary>
|
/// 一般是2个托盘，用逗号分开
|
/// </summary>
|
public string TrayInfo { get; set; }
|
/// <summary>
|
/// 输送线下线起点库位是空，移库任务需要包含
|
/// </summary>
|
public string StartArea { get; set; } = "";
|
public string EndArea { get; set; }
|
public string WorkOrder { get; set; } = "";
|
/// <summary>
|
/// 0是入库（入库有上游工单信息），1是移库
|
/// </summary>
|
public int IsMove { get; set; }
|
}
|
public class PgZsjReportMesInfo : BaseModel
|
{
|
|
public string WorkOrder { get; set; }
|
public string ItemName { get; set; }
|
public string Qty { get; set; }
|
public string CntrCode { get; set; }
|
/// <summary>
|
/// 是否连线(1非即产即用，2即产即用)
|
/// </summary>
|
public int WorkType { get; set; }
|
|
}
|
public class PgFdjReportMesFeedInfo : BaseModel
|
{
|
|
public string WorkOrder { get; set; }
|
public string CntrCode { get; set; }
|
/// <summary>
|
/// 是否连线(1非即产即用，2即产即用)
|
/// </summary>
|
public int WorkType { get; set; }
|
|
}
|
public class PgReportFluxInfo : BaseModel
|
{
|
|
public string WorkOrder { get; set; }
|
public string ItemName { get; set; }
|
/// <summary>
|
/// 多个托盘数量拼接
|
/// </summary>
|
public string Qty { get; set; }
|
/// <summary>
|
/// 多个托盘号拼接
|
/// </summary>
|
public string CntrCode { get; set; }
|
public string BindTime { get; set; }
|
|
public string Loc { get; set; }
|
/// <summary>
|
/// 1入库 2出库
|
/// </summary>
|
public int ActionType { get; set; }
|
/// <summary>
|
/// 入库state默认1，出库state默认0，卸货完成变成1，否则卸货完成时候找不到之前的领料单了，不方便扩展
|
/// </summary>
|
public int State { get; set; }
|
|
|
}
|
}
|
