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

南骏 池

2025-02-13 eda0c8f74ce453b6e43f88fc92b1e651ce5b6095

 entity/Purdhb.cs

@@ -1,233 +1,274 @@
using SqlSugar;

namespace NewPdaSqlServer.entity
namespace NewPdaSqlServer.entity;

/// <summary>
///     采购到货单表身
/// </summary>
[SugarTable("PURDHB")]
public class Purdhb
{
    /// <summary>
    /// 采购到货单表身
    ///</summary>
    [SugarTable("PURDHB")]
    public class Purdhb
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// 单号 
        ///</summary>
         [SugarColumn(ColumnName="DHB001"    )]
         public string Dhb001 { get; set; }
        /// <summary>
        /// 序号 
        ///</summary>
         [SugarColumn(ColumnName="DHB002"    )]
         public string Dhb002 { get; set; }
        /// <summary>
        /// 物料编码 
        ///</summary>
         [SugarColumn(ColumnName="DHB003"    )]
         public string Dhb003 { get; set; }
        /// <summary>
        /// 物料名称 
        ///</summary>
         [SugarColumn(ColumnName="DHB004"    )]
         public string Dhb004 { get; set; }
        /// <summary>
        /// 物料规格 
        ///</summary>
         [SugarColumn(ColumnName="DHB005"    )]
         public string Dhb005 { get; set; }
        /// <summary>
        /// 交货数量 
        ///</summary>
         [SugarColumn(ColumnName="DHB006"    )]
         public int? Dhb006 { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
         [SugarColumn(ColumnName="DHB007"    )]
         public string Dhb007 { get; set; }
        /// <summary>
        /// 仓库 
        ///</summary>
         [SugarColumn(ColumnName="DHB008"    )]
         public string Dhb008 { get; set; }
        /// <summary>
        /// 仓库名称 
        ///</summary>
         [SugarColumn(ColumnName="DHB009"    )]
         public string Dhb009 { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
         [SugarColumn(ColumnName="DHB010"    )]
         public string Dhb010 { get; set; }
        /// <summary>
        /// 来源单号 
        ///</summary>
         [SugarColumn(ColumnName="DHB011"    )]
         public string Dhb011 { get; set; }
        /// <summary>
        /// 来源序号 
        ///</summary>
         [SugarColumn(ColumnName="DHB012"    )]
         public int? Dhb012 { get; set; }
        /// <summary>
        /// 清点数量 
        ///</summary>
         [SugarColumn(ColumnName="DHB013"    )]
         public int? Dhb013 { get; set; }
        /// <summary>
        /// 到厂日期 
        ///</summary>
         [SugarColumn(ColumnName="DHB014"    )]
         public string Dhb014 { get; set; }
        /// <summary>
        /// 验收数量 
        ///</summary>
         [SugarColumn(ColumnName="DHB015"    )]
         public int? Dhb015 { get; set; }
        /// <summary>
        /// 验退数量 
        ///</summary>
         [SugarColumn(ColumnName="DHB016"    )]
         public int? Dhb016 { get; set; }
        /// <summary>
        /// 进货单价 
        ///</summary>
         [SugarColumn(ColumnName="DHB017"    )]
         public int? Dhb017 { get; set; }
        /// <summary>
        /// 进货金额 
        ///</summary>
         [SugarColumn(ColumnName="DHB018"    )]
         public int? Dhb018 { get; set; }
        /// <summary>
        /// 客户料号 
        ///</summary>
         [SugarColumn(ColumnName="DHB019"    )]
         public string Dhb019 { get; set; }
        /// <summary>
        /// 部门编号 
        ///</summary>
         [SugarColumn(ColumnName="DHB020"    )]
         public string Dhb020 { get; set; }
        /// <summary>
        /// 赠品数 
        ///</summary>
         [SugarColumn(ColumnName="DHB021"    )]
         public int? Dhb021 { get; set; }
        /// <summary>
        /// 更新ERP 
        ///</summary>
         [SugarColumn(ColumnName="DHB022"    )]
         public string Dhb022 { get; set; }
        /// <summary>
        /// 检验状态 
        ///</summary>
         [SugarColumn(ColumnName="DHB023"    )]
         public string Dhb023 { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="DHB024"    )]
         public string Dhb024 { get; set; }
        /// <summary>
        /// 审核 
        ///</summary>
         [SugarColumn(ColumnName="AUDITING"    )]
         public int? Auditing { get; set; }
        /// <summary>
        /// ERP采购单号ID 
        ///</summary>
         [SugarColumn(ColumnName="DHB026"    )]
         public int? Dhb026 { get; set; }
        /// <summary>
        /// ERP采购序号ID 
        ///</summary>
         [SugarColumn(ColumnName="DHB027"    )]
         public int? Dhb027 { get; set; }
        /// <summary>
        /// ERP物料ID 
        ///</summary>
         [SugarColumn(ColumnName="DHB028"    )]
         public int? Dhb028 { get; set; }
        /// <summary>
        /// 待检数量 
        ///</summary>
         [SugarColumn(ColumnName="DHB029"    )]
         public int? Dhb029 { get; set; }
        /// <summary>
        /// 检验日期 
        ///</summary>
         [SugarColumn(ColumnName="DHB030"    )]
         public string Dhb030 { get; set; }
        /// <summary>
        /// 备注信息1 
        ///</summary>
         [SugarColumn(ColumnName="DHB031"    )]
         public string Dhb031 { get; set; }
        /// <summary>
        /// 备注信息2 
        ///</summary>
         [SugarColumn(ColumnName="DHB032"    )]
         public int? Dhb032 { get; set; }
        /// <summary>
        /// 备注信息3 
        ///</summary>
         [SugarColumn(ColumnName="DHB033"    )]
         public string Dhb033 { get; set; }
        /// <summary>
        /// 备注信息4 
        ///</summary>
         [SugarColumn(ColumnName="DHB034"    )]
         public string Dhb034 { get; set; }
        /// <summary>
        /// 备注信息5 
        ///</summary>
         [SugarColumn(ColumnName="DHB035"    )]
         public int? Dhb035 { get; set; }
        /// <summary>
        /// 备注信息6 
        ///</summary>
         [SugarColumn(ColumnName="DHB037"    )]
         public int? Dhb037 { get; set; }
        /// <summary>
        /// 备注信息7 
        ///</summary>
         [SugarColumn(ColumnName="DHB036"    )]
         public string Dhb036 { get; set; }
        /// <summary>
        /// 备注信息8 
        ///</summary>
         [SugarColumn(ColumnName="DHB038"    )]
         public int? Dhb038 { get; set; }
        /// <summary>
        /// ERP源单内码 
        ///</summary>
         [SugarColumn(ColumnName="DHB039"    )]
         public int? Dhb039 { get; set; }
        /// <summary>
        /// ERP源单类型 
        ///</summary>
         [SugarColumn(ColumnName="DHB040"    )]
         public int? Dhb040 { get; set; }
        /// <summary>
        /// ERP订单内码 
        ///</summary>
         [SugarColumn(ColumnName="DHB041"    )]
         public int? Dhb041 { get; set; }
        /// <summary>
        /// 是否检验，1为已检 
        ///</summary>
         [SugarColumn(ColumnName="ISCHECK"    )]
         public int? Ischeck { get; set; }
        /// <summary>
        /// 仓库 
        ///</summary>
         [SugarColumn(ColumnName="DHB042"    )]
         public string Dhb042 { get; set; }
    }
}
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     单号
    /// </summary>
    [SugarColumn(ColumnName = "DHB001")]
    public string Dhb001 { get; set; }

    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "DHB002")]
    public string Dhb002 { get; set; }

    /// <summary>
    ///     物料编码
    /// </summary>
    [SugarColumn(ColumnName = "DHB003")]
    public string Dhb003 { get; set; }

    /// <summary>
    ///     物料名称
    /// </summary>
    [SugarColumn(ColumnName = "DHB004")]
    public string Dhb004 { get; set; }

    /// <summary>
    ///     物料规格
    /// </summary>
    [SugarColumn(ColumnName = "DHB005")]
    public string Dhb005 { get; set; }

    /// <summary>
    ///     交货数量
    /// </summary>
    [SugarColumn(ColumnName = "DHB006")]
    public int? Dhb006 { get; set; }

    /// <summary>
    ///     单位
    /// </summary>
    [SugarColumn(ColumnName = "DHB007")]
    public string Dhb007 { get; set; }

    /// <summary>
    ///     仓库
    /// </summary>
    [SugarColumn(ColumnName = "DHB008")]
    public string Dhb008 { get; set; }

    /// <summary>
    ///     仓库名称
    /// </summary>
    [SugarColumn(ColumnName = "DHB009")]
    public string Dhb009 { get; set; }

    /// <summary>
    ///     批号
    /// </summary>
    [SugarColumn(ColumnName = "DHB010")]
    public string Dhb010 { get; set; }

    /// <summary>
    ///     来源单号
    /// </summary>
    [SugarColumn(ColumnName = "DHB011")]
    public string Dhb011 { get; set; }

    /// <summary>
    ///     来源序号
    /// </summary>
    [SugarColumn(ColumnName = "DHB012")]
    public int? Dhb012 { get; set; }

    /// <summary>
    ///     清点数量
    /// </summary>
    [SugarColumn(ColumnName = "DHB013")]
    public int? Dhb013 { get; set; }

    /// <summary>
    ///     到厂日期
    /// </summary>
    [SugarColumn(ColumnName = "DHB014")]
    public string Dhb014 { get; set; }

    /// <summary>
    ///     验收数量
    /// </summary>
    [SugarColumn(ColumnName = "DHB015")]
    public int? Dhb015 { get; set; }

    /// <summary>
    ///     验退数量
    /// </summary>
    [SugarColumn(ColumnName = "DHB016")]
    public int? Dhb016 { get; set; }

    /// <summary>
    ///     进货单价
    /// </summary>
    [SugarColumn(ColumnName = "DHB017")]
    public int? Dhb017 { get; set; }

    /// <summary>
    ///     进货金额
    /// </summary>
    [SugarColumn(ColumnName = "DHB018")]
    public int? Dhb018 { get; set; }

    /// <summary>
    ///     客户料号
    /// </summary>
    [SugarColumn(ColumnName = "DHB019")]
    public string Dhb019 { get; set; }

    /// <summary>
    ///     部门编号
    /// </summary>
    [SugarColumn(ColumnName = "DHB020")]
    public string Dhb020 { get; set; }

    /// <summary>
    ///     赠品数
    /// </summary>
    [SugarColumn(ColumnName = "DHB021")]
    public int? Dhb021 { get; set; }

    /// <summary>
    ///     更新ERP
    /// </summary>
    [SugarColumn(ColumnName = "DHB022")]
    public string Dhb022 { get; set; }

    /// <summary>
    ///     检验状态
    /// </summary>
    [SugarColumn(ColumnName = "DHB023")]
    public string Dhb023 { get; set; }

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

    /// <summary>
    ///     审核
    /// </summary>
    [SugarColumn(ColumnName = "AUDITING")]
    public int? Auditing { get; set; }

    /// <summary>
    ///     ERP采购单号ID
    /// </summary>
    [SugarColumn(ColumnName = "DHB026")]
    public int? Dhb026 { get; set; }

    /// <summary>
    ///     ERP采购序号ID
    /// </summary>
    [SugarColumn(ColumnName = "DHB027")]
    public int? Dhb027 { get; set; }

    /// <summary>
    ///     ERP物料ID
    /// </summary>
    [SugarColumn(ColumnName = "DHB028")]
    public int? Dhb028 { get; set; }

    /// <summary>
    ///     待检数量
    /// </summary>
    [SugarColumn(ColumnName = "DHB029")]
    public int? Dhb029 { get; set; }

    /// <summary>
    ///     检验日期
    /// </summary>
    [SugarColumn(ColumnName = "DHB030")]
    public string Dhb030 { get; set; }

    /// <summary>
    ///     备注信息1
    /// </summary>
    [SugarColumn(ColumnName = "DHB031")]
    public string Dhb031 { get; set; }

    /// <summary>
    ///     备注信息2
    /// </summary>
    [SugarColumn(ColumnName = "DHB032")]
    public int? Dhb032 { get; set; }

    /// <summary>
    ///     备注信息3
    /// </summary>
    [SugarColumn(ColumnName = "DHB033")]
    public string Dhb033 { get; set; }

    /// <summary>
    ///     备注信息4
    /// </summary>
    [SugarColumn(ColumnName = "DHB034")]
    public string Dhb034 { get; set; }

    /// <summary>
    ///     备注信息5
    /// </summary>
    [SugarColumn(ColumnName = "DHB035")]
    public int? Dhb035 { get; set; }

    /// <summary>
    ///     备注信息6
    /// </summary>
    [SugarColumn(ColumnName = "DHB037")]
    public int? Dhb037 { get; set; }

    /// <summary>
    ///     备注信息7
    /// </summary>
    [SugarColumn(ColumnName = "DHB036")]
    public string Dhb036 { get; set; }

    /// <summary>
    ///     备注信息8
    /// </summary>
    [SugarColumn(ColumnName = "DHB038")]
    public int? Dhb038 { get; set; }

    /// <summary>
    ///     ERP源单内码
    /// </summary>
    [SugarColumn(ColumnName = "DHB039")]
    public int? Dhb039 { get; set; }

    /// <summary>
    ///     ERP源单类型
    /// </summary>
    [SugarColumn(ColumnName = "DHB040")]
    public int? Dhb040 { get; set; }

    /// <summary>
    ///     ERP订单内码
    /// </summary>
    [SugarColumn(ColumnName = "DHB041")]
    public int? Dhb041 { get; set; }

    /// <summary>
    ///     是否检验，1为已检
    /// </summary>
    [SugarColumn(ColumnName = "ISCHECK")]
    public int? Ischeck { get; set; }

    /// <summary>
    ///     仓库
    /// </summary>
    [SugarColumn(ColumnName = "DHB042")]
    public string Dhb042 { get; set; }
}