11

啊鑫

2025-01-11 c378358dc38972fe6643cb0c2e3a68ce49b9f002

 entity/SysDepartment.cs

@@ -1,147 +1,170 @@
using SqlSugar;

namespace NewPdaSqlServer.entity
namespace NewPdaSqlServer.entity;

/// <summary>
/// </summary>
[SugarTable("SYS_DEPARTMENT")]
public class SysDepartment
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("SYS_DEPARTMENT")]
    public class SysDepartment
    {
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// 公司 
        ///</summary>
         [SugarColumn(ColumnName="company"    )]
         public string Company { get; set; }
        /// <summary>
        /// 部门ID 
        ///</summary>
         [SugarColumn(ColumnName="departmentid"    )]
         public int? Departmentid { get; set; }
        /// <summary>
        /// 部门编号 
        ///</summary>
         [SugarColumn(ColumnName="departmentcode"    )]
         public string Departmentcode { get; set; }
        /// <summary>
        /// 部门名称 
        ///</summary>
         [SugarColumn(ColumnName="departmentname"    )]
         public string Departmentname { get; set; }
        /// <summary>
        /// 部门属性 
        ///</summary>
         [SugarColumn(ColumnName="depextr1"    )]
         public string Depextr1 { get; set; }
        /// <summary>
        /// 部门分组 
        ///</summary>
         [SugarColumn(ColumnName="depextr2"    )]
         public string Depextr2 { get; set; }
        /// <summary>
        /// WIP仓库 
        ///</summary>
         [SugarColumn(ColumnName="depextr3"    )]
         public string Depextr3 { get; set; }
        /// <summary>
        /// 是否禁用 A 启用 B禁用 
        ///</summary>
         [SugarColumn(ColumnName="depextr4"    )]
         public string Depextr4 { get; set; }
        /// <summary>
        /// 部门扩展字段5 
        ///</summary>
         [SugarColumn(ColumnName="depextr5"    )]
         public string Depextr5 { get; set; }
        /// <summary>
        /// 车间ID 
        ///</summary>
         [SugarColumn(ColumnName="workshop_no"    )]
         public string WorkshopNo { get; set; }
        /// <summary>
        /// 车间名 
        ///</summary>
         [SugarColumn(ColumnName="workshop_name"    )]
         public string WorkshopName { get; set; }
        /// <summary>
        /// 部门经理 
        ///</summary>
         [SugarColumn(ColumnName="fmanager"    )]
         public string Fmanager { get; set; }
        /// <summary>
        /// 工厂 
        ///</summary>
         [SugarColumn(ColumnName="factory"    )]
         public string Factory { 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="remark"    )]
         public string Remark { get; set; }
        /// <summary>
        /// 部门id 
        ///</summary>
         [SugarColumn(ColumnName="id"    )]
         public int? Id { 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>
        /// 自定义字段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="Fumbrella"    )]
         public string Fumbrella { get; set; }
        /// <summary>
        /// 使用组织 
        ///</summary>
         [SugarColumn(ColumnName="FSubsidiary"    )]
         public string FSubsidiary { get; set; }
        /// <summary>
        /// 上级部门 
        ///</summary>
         [SugarColumn(ColumnName="FParentID"    )]
         public string FParentID { get; set; }
    }
}
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

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

    /// <summary>
    ///     部门ID
    /// </summary>
    [SugarColumn(ColumnName = "departmentid")]
    public int? Departmentid { get; set; }

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

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

    /// <summary>
    ///     部门属性
    /// </summary>
    [SugarColumn(ColumnName = "depextr1")]
    public string Depextr1 { get; set; }

    /// <summary>
    ///     部门分组
    /// </summary>
    [SugarColumn(ColumnName = "depextr2")]
    public string Depextr2 { get; set; }

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

    /// <summary>
    ///     是否禁用 A 启用 B禁用
    /// </summary>
    [SugarColumn(ColumnName = "depextr4")]
    public string Depextr4 { get; set; }

    /// <summary>
    ///     部门扩展字段5
    /// </summary>
    [SugarColumn(ColumnName = "depextr5")]
    public string Depextr5 { get; set; }

    /// <summary>
    ///     车间ID
    /// </summary>
    [SugarColumn(ColumnName = "workshop_no")]
    public string WorkshopNo { get; set; }

    /// <summary>
    ///     车间名
    /// </summary>
    [SugarColumn(ColumnName = "workshop_name")]
    public string WorkshopName { get; set; }

    /// <summary>
    ///     部门经理
    /// </summary>
    [SugarColumn(ColumnName = "fmanager")]
    public string Fmanager { get; set; }

    /// <summary>
    ///     工厂
    /// </summary>
    [SugarColumn(ColumnName = "factory")]
    public string Factory { 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 = "remark")]
    public string Remark { get; set; }

    /// <summary>
    ///     部门id
    /// </summary>
    [SugarColumn(ColumnName = "id")]
    public int? Id { 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>
    ///     自定义字段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 = "Fumbrella")]
    public string Fumbrella { get; set; }

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

    /// <summary>
    ///     上级部门
    /// </summary>
    [SugarColumn(ColumnName = "FParentID")]
    public string FParentID { get; set; }
}