| | |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using WIDESEA_Core.DB.Models; |
| | | using WIDESEA_Core.Enums; |
| | | |
| | | namespace WIDESEA_Model.Models |
| | | { |
| | | /// <summary> |
| | | /// 物料信息 |
| | | /// </summary> |
| | | [SugarTable(nameof(Dt_MaterielInfo), "物料信息")] |
| | | public class Dt_MaterielInfo : BaseEntity |
| | | [SugarIndex("unique_materielinfo_materielcode", nameof(MaterielCode), OrderByType.Asc, true)] |
| | | public class Dt_MaterielInfo : BaseEntity//, BaseWarehouseEntity |
| | | { |
| | | /// <summary> |
| | | /// 主键 |
| | | /// </summary> |
| | | [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")] |
| | | public int Id { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "区域主键")] |
| | | public int AreaId { get; set; } |
| | | /// <summary> |
| | | /// 仓库编号 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "仓库编号")] |
| | | public int WarehouseId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料id |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "物料id")] |
| | | public int MaterielId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料编号 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "物料编号")] |
| | | public string MaterielCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料名称 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, Length = 200, ColumnDescription = "物料名称")] |
| | | public string MaterielName { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料规格")] |
| | | public string MaterieSpec { get; set; } |
| | | /// <summary> |
| | | /// 物料规格 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, Length = 200, ColumnDescription = "物料规格")] |
| | | public string MaterielSpec { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = true, Length = 500, ColumnDescription = "物料描述")] |
| | | public string MaterielDes { get; set; } |
| | | /// <summary> |
| | | /// 物料类型(1:成品、2:半成品、3:原材料、4:备件) |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "物料基本分类(1:成品、2:半成品、3:原材料、4:备件)")] |
| | | public string? MaterielType { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "容器类型", DefaultValue = "0")] |
| | | public int CotainerType { get; set; } |
| | | /// <summary> |
| | | /// 物料属性分类(1:采购件、2:自制件、3:采购&自制件) |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "物料属性分类(1:采购件、2:自制件、3:采购&自制件)")] |
| | | public string? MaterielSourceType { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "包装规格")] |
| | | public string Packspes { get; set; } |
| | | /// <summary> |
| | | /// 基本单位(buyUnitId/StockUnitId) |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "基本单位(buyUnitId/StockUnitId)")] |
| | | public string? MaterielUnit { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "物料属性", DefaultValue = "0")] |
| | | public int Attribute { get; set; } |
| | | /// <summary> |
| | | /// 版本名称 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, Length = 50, ColumnDescription = "版本名称")] |
| | | public string? MaterielVersion { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, Length = 20, ColumnDescription = "计量单位", DefaultValue = "0")] |
| | | public string Unit { get; set; } |
| | | /// <summary> |
| | | /// 物料尺寸 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料尺寸")] |
| | | public float? MaterielSize { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "有效期", DefaultValue = "-1")] |
| | | public int Validity { get; set; } |
| | | /// <summary> |
| | | /// 物料长度 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料长度")] |
| | | public float? MaterielLength { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, DecimalDigits = 2, ColumnDescription = "安全库存", DefaultValue = "-1")] |
| | | public decimal SafetyStock { get; set; } |
| | | /// <summary> |
| | | /// 物料厚度 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料厚度")] |
| | | public float? MaterielThickness { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "是否允许混批")] |
| | | public bool IsMixBatch { get; set; } |
| | | /// <summary> |
| | | /// 物料宽度 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料宽度")] |
| | | public float? MaterielWide { get; set; } |
| | | |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "是否允许混料")] |
| | | public bool IsMixMateriel { get; set; } |
| | | /// <summary> |
| | | /// 物料型号 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料型号")] |
| | | public string MaterielModel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料状态(0:禁用、1:可用) |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, ColumnDescription = "物料状态(0:禁用、1:可用)")] |
| | | public EnableEnum MaterielState { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 库存组织(默认:淮安特创二厂) |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "库存组织(默认:淮安特创二厂)")] |
| | | public float? MaterielQa{ get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 供应商ID |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料型号")] |
| | | public string SupplierId { get; set; } |
| | | /// <summary> |
| | | /// 供应商代码 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料型号")] |
| | | public string SupplierCode { get; set; } |
| | | /// <summary> |
| | | /// 供应商名称 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, ColumnDescription = "物料型号")] |
| | | public string SupplierName { get; set; } |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "备注")] |
| | | public string Remark { get; set; } |
| | | } |