1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人

南骏 池

2025-02-13 eda0c8f74ce453b6e43f88fc92b1e651ce5b6095

 entity/MesDepots.cs

@@ -1,179 +1,204 @@
using SqlSugar;

namespace NewPdaSqlServer.entity
namespace NewPdaSqlServer.entity;

/// <summary>
/// </summary>
[SugarTable("MES_DEPOTS")]
public class MesDepots
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("MES_DEPOTS")]
    public class MesDepots
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// ID(SEQ_INV_ID) 
        ///</summary>
         [SugarColumn(ColumnName="depot_id"    )]
         public int DepotId { get; set; }
        /// <summary>
        /// 仓库类别编码 
        ///</summary>
         [SugarColumn(ColumnName="depot_code"    )]
         public string DepotCode { get; set; }
        /// <summary>
        /// 仓库类别名称 
        ///</summary>
         [SugarColumn(ColumnName="depot_name"    )]
         public string DepotName { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="description"    )]
         public string Description { get; set; }
        /// <summary>
        /// 仓库负责人 
        ///</summary>
         [SugarColumn(ColumnName="create_by"    )]
         public string CreateBy { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
         [SugarColumn(ColumnName="create_date"    )]
         public DateTime? CreateDate { get; set; }
        /// <summary>
        /// 最后更新人 
        ///</summary>
         [SugarColumn(ColumnName="lastupdate_by"    )]
         public string LastupdateBy { get; set; }
        /// <summary>
        /// 最后更新时间 
        ///</summary>
         [SugarColumn(ColumnName="lastupdate_date"    )]
         public DateTime? LastupdateDate { get; set; }
        /// <summary>
        /// 仓库类型 
        ///</summary>
         [SugarColumn(ColumnName="depottype"    )]
         public string Depottype { get; set; }
        /// <summary>
        /// 分厂编码 
        ///</summary>
         [SugarColumn(ColumnName="factory"    )]
         public string Factory { get; set; }
        /// <summary>
        /// 物料使用 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="type_1"    )]
         public int? Type1 { get; set; }
        /// <summary>
        /// 成品使用 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="type_2"    )]
         public int? Type2 { get; set; }
        /// <summary>
        /// 仓库类型编码 
        ///</summary>
         [SugarColumn(ColumnName="depottypecode"    )]
         public int? Depottypecode { get; set; }
        /// <summary>
        /// 公司代码 
        ///</summary>
         [SugarColumn(ColumnName="company"    )]
         public string Company { get; set; }
        /// <summary>
        /// 看板图标样式 
        ///</summary>
         [SugarColumn(ColumnName="icon_type"    )]
         public int? IconType { get; set; }
        /// <summary>
        /// 是否委外仓库 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="is_wy"    )]
         public int? IsWy { get; set; }
        /// <summary>
        /// 是否不良品仓 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="is_ng"    )]
         public string IsNg { get; set; }
        /// <summary>
        /// 仓库地址 
        ///</summary>
         [SugarColumn(ColumnName="cwhaddress"    )]
         public string Cwhaddress { get; set; }
        /// <summary>
        /// 看板显示区域编号 
        /// 默认值: ((1))
        ///</summary>
         [SugarColumn(ColumnName="pi_type"    )]
         public string PiType { get; set; }
        /// <summary>
        /// 分组 
        ///</summary>
         [SugarColumn(ColumnName="zuid"    )]
         public string Zuid { get; set; }
        /// <summary>
        /// 允许即时库存负库存 
        ///</summary>
         [SugarColumn(ColumnName="is_fkc"    )]
         public string IsFkc { get; set; }
        /// <summary>
        /// 生产车间 
        ///</summary>
         [SugarColumn(ColumnName="production_workshop"    )]
         public string ProductionWorkshop { get; set; }
        /// <summary>
        /// 物料属性 
        ///</summary>
         [SugarColumn(ColumnName="material_properti"    )]
         public string MaterialProperti { get; set; }
        /// <summary>
        /// 自定义字段3 
        ///</summary>
         [SugarColumn(ColumnName="remark3"    )]
         public string Remark3 { get; set; }
        /// <summary>
        /// 自定义字段4 
        ///</summary>
         [SugarColumn(ColumnName="remark4"    )]
         public string Remark4 { get; set; }
        /// <summary>
        /// 自定义字段5 
        ///</summary>
         [SugarColumn(ColumnName="remark5"    )]
         public string Remark5 { get; set; }
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="check_date"    )]
         public DateTime? CheckDate { get; set; }
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="check_by"    )]
         public string CheckBy { get; set; }
        /// <summary>
        ///  
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="check_status"    )]
         public bool? CheckStatus { get; set; }
        /// <summary>
        /// 创建组织 
        ///</summary>
         [SugarColumn(ColumnName="Fumbrella"    )]
         public string Fumbrella { get; set; }
        /// <summary>
        /// 使用组织 
        ///</summary>
         [SugarColumn(ColumnName="FSubsidiary"    )]
         public string FSubsidiary { get; set; }
    }
}
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     ID(SEQ_INV_ID)
    /// </summary>
    [SugarColumn(ColumnName = "depot_id")]
    public int? DepotId { get; set; }

    /// <summary>
    ///     仓库类别编码
    /// </summary>
    [SugarColumn(ColumnName = "depot_code")]
    public string? DepotCode { get; set; }

    /// <summary>
    ///     仓库类别名称
    /// </summary>
    [SugarColumn(ColumnName = "depot_name")]
    public string? DepotName { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "description")]
    public string? Description { get; set; }

    /// <summary>
    ///     仓库负责人
    /// </summary>
    [SugarColumn(ColumnName = "create_by")]
    public string? CreateBy { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [SugarColumn(ColumnName = "create_date")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     最后更新人
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_by")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     最后更新时间
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_date")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     仓库类型
    /// </summary>
    [SugarColumn(ColumnName = "depottype")]
    public string? Depottype { get; set; }

    /// <summary>
    ///     分厂编码
    /// </summary>
    [SugarColumn(ColumnName = "factory")]
    public string? Factory { get; set; }

    /// <summary>
    ///     物料使用
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "type_1")]
    public int? Type1 { get; set; }

    /// <summary>
    ///     成品使用
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "type_2")]
    public int? Type2 { get; set; }

    /// <summary>
    ///     仓库类型编码
    /// </summary>
    [SugarColumn(ColumnName = "depottypecode")]
    public int? Depottypecode { get; set; }

    /// <summary>
    ///     公司代码
    /// </summary>
    [SugarColumn(ColumnName = "company")]
    public string? Company { get; set; }

    /// <summary>
    ///     看板图标样式
    /// </summary>
    [SugarColumn(ColumnName = "icon_type")]
    public int? IconType { get; set; }

    /// <summary>
    ///     是否委外仓库
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "is_wy")]
    public int? IsWy { get; set; }

    /// <summary>
    ///     是否不良品仓
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "is_ng")]
    public string? IsNg { get; set; }

    /// <summary>
    ///     仓库地址
    /// </summary>
    [SugarColumn(ColumnName = "cwhaddress")]
    public string? Cwhaddress { get; set; }

    /// <summary>
    ///     看板显示区域编号
    ///     默认值: ((1))
    /// </summary>
    [SugarColumn(ColumnName = "pi_type")]
    public string? PiType { get; set; }

    /// <summary>
    ///     分组
    /// </summary>
    [SugarColumn(ColumnName = "zuid")]
    public string? Zuid { get; set; }

    /// <summary>
    ///     允许即时库存负库存
    /// </summary>
    [SugarColumn(ColumnName = "is_fkc")]
    public string? IsFkc { get; set; }

    /// <summary>
    ///     生产车间
    /// </summary>
    [SugarColumn(ColumnName = "production_workshop")]
    public string? ProductionWorkshop { get; set; }

    /// <summary>
    ///     物料属性
    /// </summary>
    [SugarColumn(ColumnName = "material_properti")]
    public string? MaterialProperti { get; set; }

    /// <summary>
    ///     自定义字段3
    /// </summary>
    [SugarColumn(ColumnName = "remark3")]
    public string? Remark3 { get; set; }

    /// <summary>
    ///     自定义字段4
    /// </summary>
    [SugarColumn(ColumnName = "remark4")]
    public string? Remark4 { get; set; }

    /// <summary>
    ///     自定义字段5
    /// </summary>
    [SugarColumn(ColumnName = "remark5")]
    public string? Remark5 { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "check_date")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "check_by")]
    public string? CheckBy { get; set; }

    /// <summary>
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "check_status")]
    public bool? CheckStatus { get; set; }

    /// <summary>
    ///     创建组织
    /// </summary>
    [SugarColumn(ColumnName = "Fumbrella")]
    public string? Fumbrella { get; set; }

    /// <summary>
    ///     使用组织
    /// </summary>
    [SugarColumn(ColumnName = "FSubsidiary")]
    public string? FSubsidiary { get; set; }
}