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

南骏 池

2025-02-13 eda0c8f74ce453b6e43f88fc92b1e651ce5b6095

 entity/MesStaff.cs

@@ -1,134 +1,154 @@
using SqlSugar;

namespace NewPdaSqlServer.entity
namespace NewPdaSqlServer.entity;

/// <summary>
/// </summary>
[SugarTable("MES_STAFF")]
public class MesStaff
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("MES_STAFF")]
    public class MesStaff
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// ID 
        ///</summary>
         [SugarColumn(ColumnName="id"    )]
         public int Id { get; set; }
        /// <summary>
        /// 员工编码 
        ///</summary>
         [SugarColumn(ColumnName="staff_no"    )]
         public string StaffNo { get; set; }
        /// <summary>
        /// 员工姓名 
        ///</summary>
         [SugarColumn(ColumnName="staff_name"    )]
         public string StaffName { get; set; }
        /// <summary>
        /// 部门编码 
        ///</summary>
         [SugarColumn(ColumnName="department_no"    )]
         public string DepartmentNo { get; set; }
        /// <summary>
        /// 部门名称 
        ///</summary>
         [SugarColumn(ColumnName="department_name"    )]
         public string DepartmentName { get; set; }
        /// <summary>
        /// 岗位编码 
        ///</summary>
         [SugarColumn(ColumnName="position_code"    )]
         public string PositionCode { get; set; }
        /// <summary>
        /// 岗位名称 
        ///</summary>
         [SugarColumn(ColumnName="position_name"    )]
         public string PositionName { get; set; }
        /// <summary>
        /// 手机号 
        ///</summary>
         [SugarColumn(ColumnName="phone_number"    )]
         public string PhoneNumber { get; set; }
        /// <summary>
        /// 任岗开始日期 
        ///</summary>
         [SugarColumn(ColumnName="start_date"    )]
         public DateTime? StartDate { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="remark"    )]
         public string Remark { 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="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="memo"    )]
         public string Memo { get; set; }
        /// <summary>
        /// 生产线 
        ///</summary>
         [SugarColumn(ColumnName="line_no"    )]
         public string LineNo { get; set; }
        /// <summary>
        /// 生产员工标识 
        /// 默认值: ((1))
        ///</summary>
         [SugarColumn(ColumnName="work_mk"    )]
         public int? WorkMk { get; set; }
        /// <summary>
        /// 是否禁用 
        ///</summary>
         [SugarColumn(ColumnName="fforbid_status"    )]
         public string FforbidStatus { 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
    /// </summary>
    [SugarColumn(ColumnName = "id")]
    public int Id { get; set; }

    /// <summary>
    ///     员工编码
    /// </summary>
    [SugarColumn(ColumnName = "staff_no")]
    public string StaffNo { get; set; }

    /// <summary>
    ///     员工姓名
    /// </summary>
    [SugarColumn(ColumnName = "staff_name")]
    public string StaffName { get; set; }

    /// <summary>
    ///     部门编码
    /// </summary>
    [SugarColumn(ColumnName = "department_no")]
    public string DepartmentNo { get; set; }

    /// <summary>
    ///     部门名称
    /// </summary>
    [SugarColumn(ColumnName = "department_name")]
    public string DepartmentName { get; set; }

    /// <summary>
    ///     岗位编码
    /// </summary>
    [SugarColumn(ColumnName = "position_code")]
    public string PositionCode { get; set; }

    /// <summary>
    ///     岗位名称
    /// </summary>
    [SugarColumn(ColumnName = "position_name")]
    public string PositionName { get; set; }

    /// <summary>
    ///     手机号
    /// </summary>
    [SugarColumn(ColumnName = "phone_number")]
    public string PhoneNumber { get; set; }

    /// <summary>
    ///     任岗开始日期
    /// </summary>
    [SugarColumn(ColumnName = "start_date")]
    public DateTime? StartDate { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "remark")]
    public string Remark { 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 = "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 = "memo")]
    public string Memo { get; set; }

    /// <summary>
    ///     生产线
    /// </summary>
    [SugarColumn(ColumnName = "line_no")]
    public string LineNo { get; set; }

    /// <summary>
    ///     生产员工标识
    ///     默认值: ((1))
    /// </summary>
    [SugarColumn(ColumnName = "work_mk")]
    public int? WorkMk { get; set; }

    /// <summary>
    ///     是否禁用
    /// </summary>
    [SugarColumn(ColumnName = "fforbid_status")]
    public string FforbidStatus { get; set; }

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

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