公用属性

schangxiang@126.com

2025-05-08 8bb85a10dac0b43a2f87397c48b6c62b1ae8556a

公用属性

 CommonDLL/CmsQueryExtensions.dll

Binary files differ

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.Domain/Extension/AuditableEntity.cs

ÎļþÒÑɾ³ý

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.Domain/Extension/Class1.cs

@@ -1,80 +1,80 @@
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//using Microsoft.EntityFrameworkCore;
//using Microsoft.EntityFrameworkCore.Metadata.Builders;
//using System;
//using System.Collections.Generic;
//using System.Linq;
//using System.Text;
//using System.Threading.Tasks;

namespace CMS.Plugin.HIAWms.Domain.Extension
{
    public static class EntityTypeBuilderExtensions
    {
        public static void xx<TEntity>(this EntityTypeBuilder<TEntity> b) where TEntity : MyFullAuditedAggregateRoot<Guid>
        {
            b.Property(x => x.CreatorId)
             .HasMaxLength(36)
             .IsRequired(false)
             .HasComment("创建人ID");
//namespace CMS.Plugin.HIAWms.Domain.Extension
//{
//    public static class EntityTypeBuilderExtensions
//    {
//        public static void xx<TEntity>(this EntityTypeBuilder<TEntity> b) where TEntity : MyFullAuditedAggregateRoot<Guid>
//        {
//            b.Property(x => x.CreatorId)
//             .HasMaxLength(36)
//             .IsRequired(false)
//             .HasComment("创建人ID");

            b.Property(x => x.CreatorName)
                .HasMaxLength(64)
                .IsRequired(false)
                .HasComment("创建人");
//            b.Property(x => x.CreatorName)
//                .HasMaxLength(64)
//                .IsRequired(false)
//                .HasComment("创建人");

            b.Property(x => x.CreationTime)
                .IsRequired()
                .HasComment("创建时间");
//            b.Property(x => x.CreationTime)
//                .IsRequired()
//                .HasComment("创建时间");

            b.Property(x => x.LastModifierName)
                .HasMaxLength(64)
                .IsRequired(false)
                .HasComment("修改人");
//            b.Property(x => x.LastModifierName)
//                .HasMaxLength(64)
//                .IsRequired(false)
//                .HasComment("修改人");

            b.Property(x => x.LastModifierId)
                .HasMaxLength(36)
                .IsRequired(false)
                .HasComment("修改人ID");
//            b.Property(x => x.LastModifierId)
//                .HasMaxLength(36)
//                .IsRequired(false)
//                .HasComment("修改人ID");

            b.Property(x => x.LastModificationTime)
                .IsRequired(false)
                .HasComment("修改时间");
//            b.Property(x => x.LastModificationTime)
//                .IsRequired(false)
//                .HasComment("修改时间");

            b.Property(x => x.IsDeleted)
                .IsRequired()
                .HasComment("是否删除");
//            b.Property(x => x.IsDeleted)
//                .IsRequired()
//                .HasComment("是否删除");

            b.Property(x => x.DeleterId)
                .HasMaxLength(36)
                .IsRequired(false)
                .HasComment("删除人ID");
//            b.Property(x => x.DeleterId)
//                .HasMaxLength(36)
//                .IsRequired(false)
//                .HasComment("删除人ID");

            b.Property(x => x.DeletionTime)
                .IsRequired(false)
                .HasComment("删除时间");
//            b.Property(x => x.DeletionTime)
//                .IsRequired(false)
//                .HasComment("删除时间");

            b.Property(x => x.ExtraProperties)
                .IsRequired(false)
                .HasComment("扩展属性");
//            b.Property(x => x.ExtraProperties)
//                .IsRequired(false)
//                .HasComment("扩展属性");

            b.Property(x => x.ConcurrencyStamp)
                .IsRequired(false)
                .HasMaxLength(40)
                .HasComment("并发戳");
//            b.Property(x => x.ConcurrencyStamp)
//                .IsRequired(false)
//                .HasMaxLength(40)
//                .HasComment("并发戳");

            b.Property(x => x.Sort)
                .HasDefaultValue(0)
                .HasComment("排序");
//            b.Property(x => x.Sort)
//                .HasDefaultValue(0)
//                .HasComment("排序");

            b.Property(x => x.Remark)
                .HasMaxLength(500)
                .IsRequired(false)
                .HasComment("备注");
//            b.Property(x => x.Remark)
//                .HasMaxLength(500)
//                .IsRequired(false)
//                .HasComment("备注");

            b.Property(x => x.IsDisabled)
                .IsRequired(false)
                .HasDefaultValue(false)
                .HasComment("是否禁用");
        }
    }
}
//            b.Property(x => x.IsDisabled)
//                .IsRequired(false)
//                .HasDefaultValue(false)
//                .HasComment("是否禁用");
//        }
//    }
//}

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.Domain/Extension/MyFullAuditedAggregateRoot.cs

@@ -1,84 +1,84 @@
using System;
using Volo.Abp.Auditing;
using Volo.Abp.Domain.Entities.Auditing;
//using System;
//using Volo.Abp.Auditing;
//using Volo.Abp.Domain.Entities.Auditing;

namespace CMS.Plugin.HIAWms.Domain;
//namespace CMS.Plugin.HIAWms.Domain;

/// <summary>
/// Implements <see cref="IFullAuditedObject"/> to be a base class for full-audited aggregate roots.
/// </summary>
[Serializable]
public abstract class MyFullAuditedAggregateRoot : FullAuditedAggregateRoot
{
    /// <summary>
    /// åˆ›å»ºäºº
    /// </summary>
    public virtual string? CreatorName { get; set; }
///// <summary>
///// Implements <see cref="IFullAuditedObject"/> to be a base class for full-audited aggregate roots.
///// </summary>
//[Serializable]
//public abstract class MyFullAuditedAggregateRoot : FullAuditedAggregateRoot
//{
//    /// <summary>
//    /// åˆ›å»ºäºº
//    /// </summary>
//    public virtual string? CreatorName { get; set; }

    /// <summary>
    /// ä¿®æ”¹äºº
    /// </summary>
    public virtual string? LastModifierName { get; set; }
//    /// <summary>
//    /// ä¿®æ”¹äºº
//    /// </summary>
//    public virtual string? LastModifierName { get; set; }

    /// <summary>
    /// æŽ’序
    /// </summary>
    public virtual int Sort { get; set; }
//    /// <summary>
//    /// æŽ’序
//    /// </summary>
//    public virtual int Sort { get; set; }

    /// <summary>
    /// å¤‡æ³¨
    /// </summary>
    public virtual string Remark { get; set; }
//    /// <summary>
//    /// å¤‡æ³¨
//    /// </summary>
//    public virtual string Remark { get; set; }

    /// <summary>
    /// æ˜¯å¦ç¦ç”¨
    /// </summary>
    public virtual bool? IsDisabled { get; set; }
//    /// <summary>
//    /// æ˜¯å¦ç¦ç”¨
//    /// </summary>
//    public virtual bool? IsDisabled { get; set; }


}
//}

/// <summary>
/// Implements <see cref="IFullAuditedObject"/> to be a base class for full-audited aggregate roots.
/// </summary>
/// <typeparam name="TKey">Type of the primary key of the entity</typeparam>
[Serializable]
public abstract class MyFullAuditedAggregateRoot<TKey> : FullAuditedAggregateRoot<TKey>
{
    /// <summary>
    /// åˆ›å»ºäºº
    /// </summary>
    public virtual string? CreatorName { get; set; }
///// <summary>
///// Implements <see cref="IFullAuditedObject"/> to be a base class for full-audited aggregate roots.
///// </summary>
///// <typeparam name="TKey">Type of the primary key of the entity</typeparam>
//[Serializable]
//public abstract class MyFullAuditedAggregateRoot<TKey> : FullAuditedAggregateRoot<TKey>
//{
//    /// <summary>
//    /// åˆ›å»ºäºº
//    /// </summary>
//    public virtual string? CreatorName { get; set; }

    /// <summary>
    /// ä¿®æ”¹äºº
    /// </summary>
    public virtual string? LastModifierName { get; set; }
//    /// <summary>
//    /// ä¿®æ”¹äºº
//    /// </summary>
//    public virtual string? LastModifierName { get; set; }

    /// <summary>
    /// æŽ’序
    /// </summary>
    public virtual int Sort { get; set; }
//    /// <summary>
//    /// æŽ’序
//    /// </summary>
//    public virtual int Sort { get; set; }

    /// <summary>
    /// å¤‡æ³¨
    /// </summary>
    public virtual string Remark { get; set; }
//    /// <summary>
//    /// å¤‡æ³¨
//    /// </summary>
//    public virtual string Remark { get; set; }

    /// <summary>
    /// æ˜¯å¦ç¦ç”¨
    /// </summary>
    public virtual bool? IsDisabled { get; set; }
//    /// <summary>
//    /// æ˜¯å¦ç¦ç”¨
//    /// </summary>
//    public virtual bool? IsDisabled { get; set; }


    protected MyFullAuditedAggregateRoot()
    {
//    protected MyFullAuditedAggregateRoot()
//    {

    }
//    }

    protected MyFullAuditedAggregateRoot(TKey id)
    : base(id)
    {
//    protected MyFullAuditedAggregateRoot(TKey id)
//    : base(id)
//    {

    }
}
//    }
//}

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.Domain/WmsMaterial/WmsMaterial.cs

@@ -1,5 +1,6 @@
using CMS.Plugin.HIAWms.Domain.Shared.Enums;
using CMS.Plugin.HIAWms.Domain.Shared.WmsMaterial;
using CmsQueryExtensions.Extension;
using MathNet.Numerics;
using Volo.Abp;
using Volo.Abp.Domain.Entities.Auditing;

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsMaterial.cs

@@ -1,9 +1,8 @@
using CMS.Plugin.HIAWms.Domain;
using CMS.Plugin.HIAWms.Domain.Extension;
using CMS.Plugin.HIAWms.Domain.Shared.Enums;
using CMS.Plugin.HIAWms.Domain.WmsMaterial;
using CmsQueryExtensions.Extension;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;
using Volo.Abp;
using Volo.Abp.EntityFrameworkCore.Modeling;

@@ -140,9 +139,9 @@
            b.HasIndex(x => x.PurchaseType);           // é‡‡è´­ç±»åž‹ç´¢å¼•ï¼ˆå¦‚需查询过滤）
            b.HasIndex(x => x.MaterialType);           // ç‰©æ–™ç±»åž‹ç´¢å¼•ï¼ˆå¦‚需查询过滤）

            b.xx();
            b.ConfigureMyCmsEntity();

         

            //            b.Property(x => x.CreatorId)
            //  .HasMaxLength(36)
            //  .IsRequired(false)

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508090853_InitialCreate4.Designer.cs

ÎļþÃû´Ó Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508083921_InitialCreate4.Designer.cs ÐÞ¸Ä
@@ -12,7 +12,7 @@
namespace CMS.Plugin.HIAWms.MySQL.Migrations
{
    [DbContext(typeof(CMSPluginDbContext))]
    [Migration("20250508083921_InitialCreate4")]
    [Migration("20250508090853_InitialCreate4")]
    partial class InitialCreate4
    {
        protected override void BuildTargetModel(ModelBuilder modelBuilder)
@@ -468,6 +468,21 @@
                        .HasColumnName("DeletionTime")
                        .HasComment("删除时间");

                    b.Property<string>("ExtraField1")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("扩展字段1");

                    b.Property<string>("ExtraField2")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("扩展字段2");

                    b.Property<string>("ExtraField3")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("扩展字段3");

                    b.Property<string>("ExtraProperties")
                        .HasColumnType("longtext")
                        .HasColumnName("ExtraProperties")

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508090853_InitialCreate4.cs

ÎļþÃû´Ó Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250508083921_InitialCreate4.cs ÐÞ¸Ä
@@ -202,7 +202,13 @@
                    Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "排序"),
                    Remark = table.Column<string>(type: "varchar(500)", maxLength: 500, nullable: true, comment: "备注")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, defaultValue: false, comment: "是否禁用")
                    IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, defaultValue: false, comment: "是否禁用"),
                    ExtraField1 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "扩展字段1")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    ExtraField2 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "扩展字段2")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    ExtraField3 = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "扩展字段3")
                        .Annotation("MySql:CharSet", "utf8mb4")
                },
                constraints: table =>
                {

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/Weben_CMS_TemplateDemo/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs

@@ -466,6 +466,21 @@
                        .HasColumnName("DeletionTime")
                        .HasComment("删除时间");

                    b.Property<string>("ExtraField1")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("扩展字段1");

                    b.Property<string>("ExtraField2")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("扩展字段2");

                    b.Property<string>("ExtraField3")
                        .HasMaxLength(256)
                        .HasColumnType("varchar(256)")
                        .HasComment("扩展字段3");

                    b.Property<string>("ExtraProperties")
                        .HasColumnType("longtext")
                        .HasColumnName("ExtraProperties")

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/queryExtensions/CmsQueryExtensions/CmsQueryExtensions.csproj

@@ -6,4 +6,10 @@
    <Nullable>enable</Nullable>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore" Version="6.0.16" />
    <PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="6.0.16" />
    <PackageReference Include="Volo.Abp.Ddd.Domain" Version="6.0.0" />
  </ItemGroup>

</Project>

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/queryExtensions/CmsQueryExtensions/Extension/EntityTypeBuilderExtensions/EntityTypeBuilderExtensions.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,99 @@
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace CmsQueryExtensions.Extension
{
    /// <summary>
    /// ç”¨äºŽæ‰©å±• EntityTypeBuilder çš„静态类，提供针对继承自 MyFullAuditedAggregateRoot<Guid> çš„实体类型的配置扩展方法
    /// </summary>
    public static class EntityTypeBuilderExtensions
    {
        /// <summary>
        /// é’ˆå¯¹ç»§æ‰¿è‡ª MyFullAuditedAggregateRoot<Guid> çš„实体类型，配置其公共属性
        /// </summary>
        /// <typeparam name="TEntity">继承自 MyFullAuditedAggregateRoot<Guid> çš„实体类型</typeparam>
        /// <param name="b">EntityTypeBuilder<TEntity> å®žä¾‹ï¼Œç”¨äºŽé…ç½®å®žä½“的属性</param>
        public static void ConfigureMyCmsEntity<TEntity>(this EntityTypeBuilder<TEntity> b) where TEntity : MyFullAuditedAggregateRoot<Guid>
        {
            b.Property(x => x.CreatorId)
             .HasMaxLength(36)
             .IsRequired(false)
             .HasComment("创建人ID");

            b.Property(x => x.CreatorName)
                .HasMaxLength(64)
                .IsRequired(false)
                .HasComment("创建人");

            b.Property(x => x.CreationTime)
                .IsRequired()
                .HasComment("创建时间");

            b.Property(x => x.LastModifierName)
                .HasMaxLength(64)
                .IsRequired(false)
                .HasComment("修改人");

            b.Property(x => x.LastModifierId)
                .HasMaxLength(36)
                .IsRequired(false)
                .HasComment("修改人ID");

            b.Property(x => x.LastModificationTime)
                .IsRequired(false)
                .HasComment("修改时间");

            b.Property(x => x.IsDeleted)
                .IsRequired()
                .HasComment("是否删除");

            b.Property(x => x.DeleterId)
                .HasMaxLength(36)
                .IsRequired(false)
                .HasComment("删除人ID");

            b.Property(x => x.DeletionTime)
                .IsRequired(false)
                .HasComment("删除时间");

            b.Property(x => x.ExtraProperties)
                .IsRequired(false)
                .HasComment("扩展属性");

            b.Property(x => x.ConcurrencyStamp)
                .IsRequired(false)
                .HasMaxLength(40)
                .HasComment("并发戳");

            b.Property(x => x.Sort)
                .HasDefaultValue(0)
                .HasComment("排序");

            b.Property(x => x.Remark)
                .HasMaxLength(500)
                .IsRequired(false)
                .HasComment("备注");

            b.Property(x => x.IsDisabled)
                .IsRequired(false)
                .HasDefaultValue(false)
                .HasComment("是否禁用");

            b.Property(x => x.ExtraField1)
              .HasMaxLength(256)
              .IsRequired(false)
              .HasComment("扩展字段1");

            b.Property(x => x.ExtraField2)
               .HasMaxLength(256)
               .IsRequired(false)
               .HasComment("扩展字段2");

            b.Property(x => x.ExtraField3)
             .HasMaxLength(256)
             .IsRequired(false)
             .HasComment("扩展字段3");

        }
    }
}

 Weben_CMSרÓôúÂëÉú³ÉÆ÷/queryExtensions/CmsQueryExtensions/Extension/EntityTypeBuilderExtensions/MyFullAuditedAggregateRoot.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,114 @@
using System;
using Volo.Abp.Auditing;
using Volo.Abp.Domain.Entities.Auditing;

namespace CmsQueryExtensions.Extension;

/// <summary>
/// å®žä½“类基类
/// </summary>
[Serializable]
public abstract class MyFullAuditedAggregateRoot : FullAuditedAggregateRoot
{
    /// <summary>
    /// åˆ›å»ºäºº
    /// </summary>
    public virtual string? CreatorName { get; set; }

    /// <summary>
    /// ä¿®æ”¹äºº
    /// </summary>
    public virtual string? LastModifierName { get; set; }

    /// <summary>
    /// æŽ’序
    /// </summary>
    public virtual int Sort { get; set; }

    /// <summary>
    /// å¤‡æ³¨
    /// </summary>
    public virtual string? Remark { get; set; }

    /// <summary>
    /// æ˜¯å¦ç¦ç”¨
    /// </summary>
    public virtual bool? IsDisabled { get; set; }

    /// <summary>
    /// æ‰©å±•å­—段1
    /// </summary>
    public virtual string? ExtraField1 { get; set; }

    /// <summary>
    /// æ‰©å±•å­—段2
    /// </summary>
    public virtual string? ExtraField2 { get; set; }

    /// <summary>
    /// æ‰©å±•å­—段3
    /// </summary>
    public virtual string? ExtraField3 { get; set; }


}

/// <summary>
/// å®žä½“类基类
/// </summary>
/// <typeparam name="TKey"></typeparam>
[Serializable]
public abstract class MyFullAuditedAggregateRoot<TKey> : FullAuditedAggregateRoot<TKey>
{
    /// <summary>
    /// åˆ›å»ºäºº
    /// </summary>
    public virtual string? CreatorName { get; set; }

    /// <summary>
    /// ä¿®æ”¹äºº
    /// </summary>
    public virtual string? LastModifierName { get; set; }

    /// <summary>
    /// æŽ’序
    /// </summary>
    public virtual int Sort { get; set; }

    /// <summary>
    /// å¤‡æ³¨
    /// </summary>
    public virtual string? Remark { get; set; }

    /// <summary>
    /// æ˜¯å¦ç¦ç”¨
    /// </summary>
    public virtual bool? IsDisabled { get; set; }


    /// <summary>
    /// æ‰©å±•å­—段1
    /// </summary>
    public virtual string? ExtraField1 { get; set; }

    /// <summary>
    /// æ‰©å±•å­—段2
    /// </summary>
    public virtual string? ExtraField2 { get; set; }

    /// <summary>
    /// æ‰©å±•å­—段3
    /// </summary>
    public virtual string? ExtraField3 { get; set; }

    protected MyFullAuditedAggregateRoot()
    {

    }

    protected MyFullAuditedAggregateRoot(TKey id)
    : base(id)
    {

    }
}