using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// </summary>
|
[SugarTable("MES_DEPOTS")]
|
public class MesDepots
|
{
|
/// <summary>
|
///
|
/// 默认值: (newid())
|
///</summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 仓库ID
|
/// </summary>
|
[SugarColumn(ColumnName = "depot_id", IsIdentity = true)]
|
public decimal DepotId { get; set; }
|
|
/// <summary>
|
/// 仓库编码
|
/// </summary>
|
[SugarColumn(ColumnName = "depot_code", Length = 50, IsNullable = true)]
|
public string? DepotCode { get; set; }
|
|
/// <summary>
|
/// 仓库名称
|
/// </summary>
|
[SugarColumn(ColumnName = "depot_name", Length = 100, IsNullable = true)]
|
public string? DepotName { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "description", Length = 255, IsNullable = true)]
|
public string? Description { get; set; }
|
|
/// <summary>
|
/// 仓库负责人
|
/// </summary>
|
[SugarColumn(ColumnName = "create_by", Length = 20, IsNullable = true)]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[SugarColumn(ColumnName = "create_date", IsNullable = true)]
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 最后更新人
|
/// </summary>
|
[SugarColumn(ColumnName = "lastupdate_by", Length = 20, IsNullable = true)]
|
public string? LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 最后更新时间
|
/// </summary>
|
[SugarColumn(ColumnName = "lastupdate_date", IsNullable = true)]
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// 仓库类型
|
/// </summary>
|
[SugarColumn(ColumnName = "depottype", Length = 30, IsNullable = true)]
|
public string? Depottype { get; set; }
|
|
/// <summary>
|
/// 分厂编码
|
/// </summary>
|
[SugarColumn(ColumnName = "factory", Length = 20, IsNullable = true)]
|
public string? Factory { get; set; }
|
|
/// <summary>
|
/// 物料使用 (默认 0)
|
/// </summary>
|
[SugarColumn(ColumnName = "type_1", IsNullable = true)]
|
public int? Type1 { get; set; }
|
|
/// <summary>
|
/// 成品使用 (默认 0)
|
/// </summary>
|
[SugarColumn(ColumnName = "type_2", IsNullable = true)]
|
public int? Type2 { get; set; }
|
|
/// <summary>
|
/// 仓库类型编码
|
/// </summary>
|
[SugarColumn(ColumnName = "depottypecode", IsNullable = true)]
|
public int? Depottypecode { get; set; }
|
|
/// <summary>
|
/// 公司代码
|
/// </summary>
|
[SugarColumn(ColumnName = "company", Length = 20, IsNullable = true)]
|
public string? Company { get; set; }
|
|
/// <summary>
|
/// 看板图标样式
|
/// </summary>
|
[SugarColumn(ColumnName = "icon_type", IsNullable = true)]
|
public int? IconType { get; set; }
|
|
/// <summary>
|
/// 是否委外仓库 (默认 0)
|
/// </summary>
|
[SugarColumn(ColumnName = "is_wy", IsNullable = true)]
|
public int? IsWy { get; set; }
|
|
/// <summary>
|
/// 禁用状态 (默认 0) 注意：原表为 nvarchar(10) 且默认 '0'
|
/// </summary>
|
[SugarColumn(ColumnName = "is_ng", Length = 10, IsNullable = true)]
|
public string? IsNg { get; set; }
|
|
/// <summary>
|
/// 仓库地址
|
/// </summary>
|
[SugarColumn(ColumnName = "cwhaddress", Length = 200, IsNullable = true)]
|
public string? Cwhaddress { get; set; }
|
|
/// <summary>
|
/// 看板显示区域编号 (默认 1)
|
/// </summary>
|
[SugarColumn(ColumnName = "pi_type", Length = 10, IsNullable = true)]
|
public string? PiType { get; set; }
|
|
/// <summary>
|
/// 分组
|
/// </summary>
|
[SugarColumn(ColumnName = "zuid", Length = 20, IsNullable = true)]
|
public string? Zuid { get; set; }
|
|
/// <summary>
|
/// 允许即时库存负库存
|
/// </summary>
|
[SugarColumn(ColumnName = "is_fkc", Length = 30, IsNullable = true)]
|
public string? IsFkc { get; set; }
|
|
/// <summary>
|
/// 生产车间
|
/// </summary>
|
[SugarColumn(ColumnName = "production_workshop", Length = 32,
|
IsNullable = true)]
|
public string? ProductionWorkshop { get; set; }
|
|
/// <summary>
|
/// 物料属性
|
/// </summary>
|
[SugarColumn(ColumnName = "material_properti", Length = 32,
|
IsNullable = true)]
|
public string? MaterialProperti { get; set; }
|
|
/// <summary>
|
/// 自定义字段3
|
/// </summary>
|
[SugarColumn(ColumnName = "remark3", Length = 32, IsNullable = true)]
|
public string? Remark3 { get; set; }
|
|
/// <summary>
|
/// 自定义字段4
|
/// </summary>
|
[SugarColumn(ColumnName = "remark4", Length = 32, IsNullable = true)]
|
public string? Remark4 { get; set; }
|
|
/// <summary>
|
/// 自定义字段5
|
/// </summary>
|
[SugarColumn(ColumnName = "remark5", Length = 32, IsNullable = true)]
|
public string? Remark5 { get; set; }
|
|
/// <summary>
|
/// 点检时间
|
/// </summary>
|
[SugarColumn(ColumnName = "check_date", IsNullable = true)]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 点检人
|
/// </summary>
|
[SugarColumn(ColumnName = "check_by", Length = 50, IsNullable = true)]
|
public string? CheckBy { get; set; }
|
|
/// <summary>
|
/// 点检状态 (默认 0)
|
/// </summary>
|
[SugarColumn(ColumnName = "check_status", IsNullable = true)]
|
public bool? CheckStatus { get; set; }
|
|
/// <summary>
|
/// 创建组织
|
/// </summary>
|
[SugarColumn(ColumnName = "Fumbrella", Length = 32, IsNullable = true)]
|
public string? Fumbrella { get; set; }
|
|
/// <summary>
|
/// 使用组织
|
/// </summary>
|
[SugarColumn(ColumnName = "FSubsidiary", Length = 32, IsNullable = true)]
|
public string? FSubsidiary { get; set; }
|
|
/// <summary>
|
/// 供应商
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLIER_ID", Length = 50, IsNullable = true)]
|
public string? SupplierId { get; set; }
|
|
/// <summary>
|
/// 客户
|
/// </summary>
|
[SugarColumn(ColumnName = "Client_Id", Length = 50, IsNullable = true)]
|
public string? ClientId { get; set; }
|
|
/// <summary>
|
/// 部门
|
/// </summary>
|
[SugarColumn(ColumnName = "department", Length = 50, IsNullable = true)]
|
public string? Department { get; set; }
|
|
/// <summary>
|
/// 联系电话
|
/// </summary>
|
[SugarColumn(ColumnName = "Phone", Length = 50, IsNullable = true)]
|
public string? Phone { get; set; }
|
|
/// <summary>
|
/// Z=暂存,A=创建,B=审核中,C=已审核,D=重新审核
|
/// </summary>
|
[SugarColumn(ColumnName = "DOCUMENT_STATUS", Length = 10,
|
IsNullable = true)]
|
public string? DocumentStatus { get; set; }
|
|
/// <summary>
|
/// 0=可用,4=在途,6=废品,2=冻结,5=收货冻结,1=待检,8=不参与核算,3=退回冻结,7=不良
|
/// </summary>
|
[SugarColumn(ColumnName = "STOCK_STATUS_TYPE", Length = 50,
|
IsNullable = true)]
|
public string? StockStatusType { get; set; }
|
|
/// <summary>
|
/// 数据状态
|
/// </summary>
|
[SugarColumn(ColumnName = "FDocumentStatus", Length = 100,
|
IsNullable = true)]
|
public string? FDocumentStatus { get; set; }
|
|
/// <summary>
|
/// 客户 (整数)
|
/// </summary>
|
[SugarColumn(ColumnName = "FCustomerId", IsNullable = true)]
|
public int? FCustomerId { get; set; }
|
|
/// <summary>
|
/// 库存状态类型
|
/// </summary>
|
[SugarColumn(ColumnName = "FStockStatusType", Length = 50,
|
IsNullable = true)]
|
public string? FStockStatusType { get; set; }
|
|
/// <summary>
|
/// 启用仓位管理
|
/// </summary>
|
[SugarColumn(ColumnName = "FISOPENLOCATION", Length = 5, IsNullable = true)]
|
public string? FIsOpenLocation { get; set; }
|
|
|
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
|
}
|
