using HH.WCS.QingXigongchang.process;
|
using HH.WCS.QingXigongchang.util;
|
using SqlSugar;
|
using System;
|
|
namespace HH.WCS.QingXigongchang.wms
|
{
|
|
//---------------------------------------仓库信息---------------------------------------
|
public class BaseModel
|
{
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_ID { get; set; } = Guid.NewGuid().ToString("D");
|
public string S_CREATOR_ID { get; set; } = "sa";
|
public string S_CREATOR_NAME { get; set; } = "超级用户";
|
public DateTime T_CREATE { get; set; } = DateTime.Now;
|
public DateTime T_MODIFY { get; set; } = DateTime.Now;
|
|
|
}
|
//均州现场
|
//[SugarTable("TN_0038")]
|
|
//[SugarTable("TN_0129")]//198服务器
|
[SuGG("入库排锁表")]
|
public class InworkRecord : BaseModel
|
{
|
public string SQL_PLineNo { get; set; }
|
public string S_Fule_Code { get; set; }
|
public string S_IP_Address { get; set; }
|
public string S_AREA_CODE { get; set; }
|
public string N_ROW { get; set; }
|
}
|
|
public class locCntItem
|
{
|
public string S_LOC_CODE { get; set; }
|
public int N_CURRENT_NUM { get; internal set; }
|
public string S_AREA_CODE { get; internal set; }
|
public int N_ROW { get; internal set; }
|
public int N_COL { get; internal set; }
|
/// <summary>
|
/// 1 零头1 2零头2 (标签特有) 3 整托
|
/// </summary>
|
public int HalfOrFull { get; internal set; } = 0;
|
|
[SugarColumn(IsIgnore = true)]
|
public string HalfFull
|
{
|
get
|
{
|
switch (this.HalfOrFull)
|
{
|
case 1:
|
return "零头1";
|
|
case 2:
|
return "零头2";
|
|
case 3:
|
return "整托";
|
default: return this.HalfOrFull + "未知";
|
}
|
}
|
}
|
public string S_NOTE { get; internal set; }
|
public string S_CNTR_CODE { get; internal set; }
|
public string S_TYPE { get; internal set; }
|
public int N_LAYER { get; internal set; }
|
public string S_ITEM_CODE { get; internal set; }
|
public string S_ITEM_NAME { get; internal set; }
|
|
public string S_BATCH_NO { get; internal set; }
|
|
public string S_CJ_NAME { get; set; }
|
}
|
|
|
[SuGG("货位表")]//TN_0010新安江
|
public class Location : BaseModel
|
{
|
/// <summary>
|
/// 货位码
|
/// </summary>
|
public string S_LOC_CODE { get; set; }
|
//库区码
|
public string S_AREA_CODE { get; set; }
|
|
//[SugarColumn(IsIgnore = true)]
|
public string S_Fule_LOC { get; set; }
|
/// <summary>
|
/// 仓库名称表
|
/// </summary>
|
public string S_WH_CODE { get; set; }
|
//容量 可容纳层数
|
public int N_CAPACITY { get; set; }
|
/// <summary>
|
// - 瓶坯用作 瓶坯机号（名称）
|
|
|
// - 瓶坯空框区 用作标识有空框
|
// - 不用了。 换 S_NOTE
|
/// </summary>
|
public string S_AGV_SITE { get; set; }
|
|
/// <summary>
|
/// 备注 - 标注机器。 瓶盖用，瓶坯配置了独立库区
|
/// </summary>
|
public string S_NOTE { get; set; }
|
/// <summary>
|
/// 需要注意
|
/// </summary>
|
//[SugarColumn(IsIgnore = true)]
|
public int N_AGV_CODE { get; set; }
|
|
// 大于0有货。 0 没货，
|
public int N_CURRENT_NUM { get; set; }
|
// 搬运时
|
/// <summary>
|
/// 置满时间
|
/// </summary>
|
public DateTime? T_FULL_TIME { get; set; }
|
public DateTime? T_EMPTY_TIME { get; set; }
|
// 巷道
|
public int N_ROADWAY { get; set; }
|
|
// 竖排
|
public int N_ROW { get; set; }
|
// 横列
|
public int N_COL { get; set; }
|
// - 考虑用作层数
|
public int N_LAYER { get; set; }
|
/// <summary>
|
/// 无/入库锁/出库锁/其它锁
|
/// </summary>
|
public string S_LOCK_STATE
|
{
|
get; set;
|
}
|
//public string S_DEEP { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToMany, nameof(S_LOC_CODE))]
|
public LocCntrRel LocCntrRel { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
public string Batch { get; set; }
|
//[SugarColumn(IsIgnore = true)]
|
//[Navigate(NavigateType.OneToMany, nameof(S_LOC_CODE))]
|
//public List<LocCntrRel> LocCntrRels { get; set; }
|
|
}
|
//均州现场
|
//[SugarTable("TN_0039")]
|
//198服务器
|
/// <summary>
|
/// 货位容器表
|
/// </summary>
|
|
//[SugarTable("TN_0130")]
|
//[SugarTable("TN_0011")]
|
[SuGG("托盘货位表")]
|
public class LocCntrRel : BaseModel
|
{
|
/// <summary>
|
/// 注意，mapper方式不需要
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_LOC_CODE { get; set; }
|
public string S_CNTR_CODE { get; set; }
|
|
/// <summary>
|
/// 空筐 -> 即产Y 非即产N
|
/// 瓶坯 -> 物料iTEMCODE ===> 改 产线+物料 ”lineNo+物料“
|
/// 成品 -> 版型
|
/// 瓶盖 -> 产线 || 取消 2024年12月9日 10:02:10 改=> LineNo>物料 ||-- 2024年12月9日 10:16:23 改=>
|
/// </summary>
|
public string S_TYPE { get; set; }
|
|
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(S_CNTR_CODE))]
|
public CntrItemRel CntrItemRel { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
[Navigate(NavigateType.OneToOne, nameof(S_CNTR_CODE))]
|
public Container Container { get; set; }
|
|
[SugarColumn(IsIgnore = true)]
|
public LocCntrRel Reference { get; set; }
|
public LocCntrRel Clone()
|
{
|
var clone = (LocCntrRel)this.MemberwiseClone();
|
if (this.Reference != null)
|
{
|
clone.Reference = (LocCntrRel)this.Reference.Clone();
|
}
|
return clone;
|
}
|
}
|
//均州现场
|
//[SugarTable("TN_0028")]
|
//198服务器
|
//[SugarTable("TN_0116")]
|
[SuGG("托盘物料表")]
|
public class CntrItemRel : BaseModel
|
{
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_CNTR_CODE { get; set; }
|
public string S_ITEM_CODE { get; set; }
|
public string S_ITEM_NAME { get; set; }
|
public string S_BATCH_NO { get; set; }
|
public string F_QTY { get; set; }
|
public string B_TYPE { get; set; }
|
/// <summary>
|
/// 半托1 0.5 半托2。 0.75 满托 1
|
/// </summary>
|
public double N_BQ_TRAY_TYPE { get; set; } = 1;
|
|
/// <summary>
|
/// 厂家
|
/// </summary>
|
public string S_CJ_NAME { get; set; }
|
|
public int ItemLayer { get; set; }
|
[SugarColumn(IsIgnore = true)]
|
public int qty
|
{
|
get
|
{
|
int q = 0;
|
int.TryParse(F_QTY, out q);
|
return q;
|
}
|
}
|
public string S_ITEM_STATE { get; set; } = "无";
|
|
|
[SugarColumn(IsIgnore = true)]
|
public CntrItemRel Reference { get; set; }
|
public CntrItemRel Clone()
|
{
|
var clone = (CntrItemRel)this.MemberwiseClone();
|
if (this.Reference != null)
|
{
|
clone.Reference = (CntrItemRel)this.Reference.Clone();
|
}
|
return clone;
|
}
|
/// <summary>
|
/// 下线是的工单号_isFule GDH1000001_Y
|
/// </summary>
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string S_ORDER_NO { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public DateTime? Off_T { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string Off_report { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public DateTime? In_T { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string In_report { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public DateTime? Out_T { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string Out_report { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string Out_LingNo { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public DateTime? DoF_T { get; set; }
|
|
[SugarColumn(IsIgnore = !TaskProcess.UPFule)]
|
public string DoF_report { get; set; }
|
|
|
|
}
|
|
|
[SuGG("物料表")]
|
public class ItemInfo : BaseModel
|
{
|
public string S_ITEM_CODE { get; set; }
|
public string S_ITEM_NAME { get; set; }
|
public int trayHeight { get; set; }
|
|
/// <summary>
|
/// 原料pe膜三层TS高度
|
/// </summary>
|
public int trayHeight1 { get; set; }
|
public int ItemLayer { get; set; }
|
|
//物料所在托盘的可堆叠层数。 《》与货位容量取 最小值。
|
public int MaxLayer { get; set; }
|
public string B_Type { get; set; }
|
/// <summary>
|
/// 逗号连接， 标签编码。 -
|
/// </summary>
|
public string S_BQ_NAME { get; set; }
|
}
|
|
[SuGG("自由线段表")]
|
public class FreeLineInfo : BaseModel
|
{
|
public string area { get; set; }
|
public int row { get; set; }
|
public int minCol { get; set; }
|
public int maxCol { get; set; }
|
public int bit1 { get; set; }
|
public int bit2 { get; set; }
|
|
}
|
//均州现场
|
//[SugarTable("TN_0029")]
|
|
//[SugarTable("TN_0117")]//198服务器
|
|
//[SugarTable("TN_0018")]//新安江
|
[SuGG("密集锁排")]
|
public class RowLock : BaseModel
|
{
|
public string S_AREA_CODE { get; set; }
|
public int N_ROW { get; set; }
|
public string S_LOCK_STATE { get; set; }
|
public string S_WORK_MODE { get; set; } = "";
|
public string S_LOCK_SRC { get; set; }
|
public DateTime T_LOCK_TIME { get; set; }
|
public DateTime T_UNLOCK_TIME { get; set; }
|
}
|
|
//均州现场
|
//[SugarTable("TN_0026")]
|
//198服务器
|
//[SugarTable("TN_0114")]
|
[SuGG("托盘表")]
|
public class Container : BaseModel
|
{
|
/// <summary>
|
/// 容器编码
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true)]
|
public string S_CNTR_CODE { get; set; }
|
/// <summary>
|
/// 大/小板 集化板
|
/// </summary>
|
public string S_TYPE { get; set; }
|
/// <summary>
|
/// 规格
|
/// </summary>
|
public string S_SPEC { get; set; }
|
/// <summary>
|
/// 容器用途
|
/// </summary>
|
public string N_PURPOSE { get; set; }
|
/// <summary>
|
/// 容器来源
|
/// </summary>
|
public string S_SRC { get; set; }
|
/// <summary>
|
/// 容器目的地
|
/// </summary>
|
public string S_DEST { get; set; }
|
/// <summary>
|
/// 容器状态(空-已清洁-无-转运-待生产)
|
/// </summary>
|
public string S_CNTR_STATE { get; set; }
|
}
|
|
[SuGG("库容表")]
|
public class KuRong : BaseModel
|
{
|
/// <summary>
|
/// 库位
|
/// </summary>
|
public string StorageLoc { get; set; }
|
/// <summary>
|
/// AGV总库容
|
/// </summary>
|
public int MaxCapacity { get; set; }
|
/// <summary>
|
/// 已占库容
|
/// </summary>
|
public int FilledCapacity { get; set; }
|
/// <summary>
|
/// 品相
|
/// </summary>
|
public string ProductItem { get; set; }
|
/// <summary>
|
/// 剩余库容量
|
/// </summary>
|
public int AvailableCapacity { get; set; }
|
/// <summary>
|
/// agv所需库容。
|
/// </summary>
|
public int DesiredCapacity { get; set; }
|
/// <summary>
|
/// 仓库总库容。
|
/// </summary>
|
public int CRC { get; set; }
|
/// <summary>
|
/// 剩余空库容。
|
/// </summary>
|
public int RAC { get; set; }
|
/// <summary>
|
/// 已占库容的和。
|
/// </summary>
|
public int DRC { get; set; }
|
/// <summary>
|
/// 仓库剩余总库容。
|
/// </summary>
|
public int BAC { get; set; }
|
}
|
//均州现场
|
//[SugarTable("dbo.")]
|
|
//[SugarTable("dbo.TN_0098")]//198服务器
|
|
//[SugarTable("dbo.TN_0004")]//新安江
|
[SuGG("任务表")]
|
public class WMSTask : BaseModel
|
{
|
public string S_DEPART_NAME { get; set; }
|
public string S_TASK_NO { get; set; }
|
public string S_START_LAREA { get; set; }
|
public string S_END_LAREA { get; set; }
|
public string S_START_LOC { get; set; }
|
public string S_END_LOC { get; set; }
|
public string S_TWO_END_LOC { get; set; }
|
public string S_TYPE { get; set; }
|
public string S_NOTE { get; set; }
|
public string S_SRC_SYS { get; set; }
|
public string S_SRC_NO { get; set; }
|
/// <summary>
|
/// agv/人工/输送线
|
/// </summary>
|
public string S_WORK_MODE { get; set; }
|
public DateTime? T_START_TIME { get; set; }
|
public DateTime? T_END_TIME { get; set; }
|
/// <summary>
|
/// 任务状态
|
/// </summary>
|
public string S_B_STATE { get; set; }
|
public int N_PRIORITY { get; set; }
|
/// <summary>
|
/// 搬运的托盘号，多个用英文逗号分开
|
/// </summary>
|
public string S_CNTRS { get; set; }
|
public string S_EQ_NO { get; set; }
|
/// <summary>
|
/// 起点层
|
/// </summary>
|
public int N_START_LAYER { get; set; }
|
/// <summary>
|
/// 终点层
|
/// </summary>
|
public int N_END_LAYER { get; set; }
|
/// <summary>
|
/// 搬运的托盘数量
|
/// </summary>
|
public int N_CNTR_COUNT { get; set; }
|
|
|
}
|
|
//均州现场
|
//[SugarTable("dbo.")]
|
//198服务器
|
//[SugarTable("dbo.TN_0146")]
|
//新安江
|
//[SugarTable("dbo.TN_0027")]
|
[SuGG("任务动作表")]
|
public class WmsTaskAction : BaseModel
|
{
|
public string S_TASK_NO { get; set; }
|
public string S_ACTION_CODE { get; set; }
|
/// <summary>
|
/// 设备号
|
/// </summary>
|
public string S_EQ_NO { get; set; }
|
/// <summary>
|
/// 设备类型
|
/// </summary>
|
public string S_EQ_TYPE { get; set; }
|
/// <summary>
|
/// 其它数据
|
/// </summary>
|
public string S_DATA { get; set; }
|
}
|
|
//均州现场
|
//[SugarTable("dbo.")]
|
|
//[SugarTable("dbo.TN_0023")]//新安江
|
//[SugarTable("dbo.TN_0132")]//198服务器
|
[SuGG("货位扩展表")]
|
public class LocationExt : BaseModel
|
{
|
/// <summary>
|
/// 货位
|
/// </summary>
|
public string S_LOC_CODE { get; set; }
|
/// <summary>
|
/// agv站点
|
/// </summary>
|
public string S_AGV_SITE { get; set; }
|
/// <summary>
|
/// 标识
|
/// </summary>
|
public string S_PICKUP_POINT { get; set; }
|
|
}
|
|
|
}
|
