using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using WIDESEA_Common.CommonEnum; using WIDESEA_Common.MaterielEnum; using WIDESEA_Core.DB.Models; namespace WIDESEA_Model.Models { /// /// 物料信息 /// [SugarTable(nameof(Dt_MaterielInfo), "物料信息")] [SugarIndex("unique_materielinfo_materielcode", nameof(MaterielCode), OrderByType.Asc, true)] public class Dt_MaterielInfo : BaseEntity//, BaseWarehouseEntity { /// /// 主键 /// [SugarColumn(IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")] public int Id { get; set; } /// /// 仓库编号 /// [SugarColumn(IsNullable = false, ColumnDescription = "仓库编号")] public int WarehouseId { get; set; } /// /// 物料编号 /// [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "物料编号")] public string MaterielCode { get; set; } /// /// 物料名称 /// [SugarColumn(IsNullable = false, Length = 200, ColumnDescription = "物料名称")] public string MaterielName { get; set; } /// /// 物料规格 /// [SugarColumn(IsNullable = false, Length = 200, ColumnDescription = "物料规格")] public string MaterielSpec { get; set; } /// /// 物料基本分类(1:成品、2:半成品、3:原材料、4:备件) /// [SugarColumn(IsNullable = false, ColumnDescription = "物料基本分类(1:成品、2:半成品、3:原材料、4:备件)")] public MaterielTypeEnum MaterielType { get; set; } /// /// 物料属性分类(1:采购件、2:自制件、3:采购&自制件) /// [SugarColumn(IsNullable = false, ColumnDescription = "物料属性分类(1:采购件、2:自制件、3:采购&自制件)")] public MaterielSourceTypeEnum MaterielSourceType { get; set; } /// /// 基本单位(buyUnitId/StockUnitId) /// [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "基本单位(buyUnitId/StockUnitId)")] public string MaterielUnit { get; set; } /// /// 版本名称 /// [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "版本名称")] public string MaterielVersion { get; set; } /// /// 物料尺寸 /// [SugarColumn(IsNullable = true, ColumnDescription = "物料尺寸")] public float? MaterielSize { get; set; } /// /// 物料长度 /// [SugarColumn(IsNullable = true, ColumnDescription = "物料长度")] public float? MaterielLength { get; set; } /// /// 物料厚度 /// [SugarColumn(IsNullable = true, ColumnDescription = "物料厚度")] public float? MaterielThickness { get; set; } /// /// 物料宽度 /// [SugarColumn(IsNullable = true, ColumnDescription = "物料宽度")] public float? MaterielWide { get; set; } /// /// 物料型号 /// [SugarColumn(IsNullable = true, ColumnDescription = "物料型号")] public string MaterielModel { get; set; } /// /// 物料状态(0:禁用、1:可用) /// [SugarColumn(IsNullable = false, ColumnDescription = "物料状态(0:禁用、1:可用)")] public EnableEnum MaterielState { get; set; } /// /// 库存组织(默认:淮安特创二厂) /// [SugarColumn(IsNullable = false, Length = 50, ColumnDescription = "库存组织(默认:淮安特创二厂)")] public string MaterielInvOrgId { get; set; } /// /// 是否需要质检 /// [SugarColumn(IsNullable = false, ColumnDescription = "是否需要质检")] public WhetherEnum IsCheck { get; set; } /// /// 备注 /// [SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "备注")] public string Remark { get; set; } } }