| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | using WIDESEA_Core.DB.Models; |
| | | namespace WIDESEA_Model.Models |
| | | |
| | | namespace WIDESEA_Model.Models; |
| | | |
| | | /// <summary> |
| | | /// 物料基本信息表 |
| | | ///</summary> |
| | | [SugarTable("Dt_MaterielInfo")] |
| | | public class Dt_MaterielInfo : BaseEntity |
| | | { |
| | | /// <summary> |
| | | /// 物料基本信息表 |
| | | /// 备 注:物料ID |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarTable("Dt_MaterielInfo")] |
| | | public class Dt_MaterielInfo : BaseEntity |
| | | { |
| | | |
| | | |
| | | /// <summary> |
| | | /// 备 注:物料ID |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="MaterielID" ,IsPrimaryKey = true,IsIdentity = true) ] |
| | | public int MaterielID { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:物料编码 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="MaterielCode" ) ] |
| | | public string? MaterielCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:所属库区 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WareAreaCode" ) ] |
| | | public string? WareAreaCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:物料名称 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="MaterielName" ) ] |
| | | public string? MaterielName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:包装规格 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Packspes" ) ] |
| | | public string? Packspes { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:物料描述 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="MaterielDesc" ) ] |
| | | public string? MaterielDesc { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:物料属性 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Attribute" ) ] |
| | | public string? Attribute { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:计重单位 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Unit" ) ] |
| | | public string? Unit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:当前状态(0,禁用 1,启用) |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Status" ) ] |
| | | public int? Status { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:最小包装数 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="MinpackQty" ) ] |
| | | public decimal? MinpackQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:生产商 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Mfacturer" ) ] |
| | | public string? Mfacturer { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:供应商 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Supplier" ) ] |
| | | public string? Supplier { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:净重 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Netweight" ) ] |
| | | public decimal? Netweight { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:毛重 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Grossweight" ) ] |
| | | public decimal? Grossweight { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:有效期 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Validity" ) ] |
| | | public int? Validity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:安全库存 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Safety" ) ] |
| | | public decimal? Safety { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:备注 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="Remark" ) ] |
| | | public string? Remark { get; set; } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 备 注: |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="spare1" ) ] |
| | | public string? Spare1 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注: |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="spare2" ) ] |
| | | public string? Spare2 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注: |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="spare3" ) ] |
| | | public string? Spare3 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注: |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="spare4" ) ] |
| | | public string? Spare4 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注: |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="spare5" ) ] |
| | | public string? Spare5 { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "MaterielID", IsPrimaryKey = true, IsIdentity = true)] |
| | | public int MaterielID { get; set; } |
| | | |
| | | } |
| | | /// <summary> |
| | | /// 备 注:物料编码 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MaterielCode", IsNullable = false)] |
| | | public string? MaterielCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:物料名称 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MaterielName", IsNullable = false)] |
| | | public string? MaterielName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:物料描述 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MaterielDesc", IsNullable = true)] |
| | | public string? MaterielDesc { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:当前状态(0,禁用 1,启用) |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Status", IsNullable = false)] |
| | | public int? Status { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:最小包装数 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "MinpackQty", IsNullable = true)] |
| | | public decimal? MinpackQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:生产商 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Mfacturer", IsNullable = true)] |
| | | public string? Mfacturer { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:净重 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Netweight", IsNullable = true)] |
| | | public decimal? Netweight { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:毛重 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Grossweight", IsNullable = true)] |
| | | public decimal? Grossweight { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:有效期 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Validity", IsNullable = true)] |
| | | public int? Validity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:安全库存 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Safety", IsNullable = true)] |
| | | public decimal? Safety { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备 注:备注 |
| | | /// 默认值: |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Remark", IsNullable = true)] |
| | | public string? Remark { get; set; } |
| | | } |