| | |
| | | updateObj.OuterDiameter = input.OuterDiameter; |
| | | updateObj.Thickness = input.Thickness; |
| | | updateObj.Material = input.Material; |
| | | updateObj.HasMainSignature = input.HasMainSignature; |
| | | |
| | | updateObj.ProcessRouteNumber = input.ProcessRouteNumber; |
| | | updateObj.PlannedStartTime = input.PlannedStartTime; |
| | | updateObj.PlannedEndTime = input.PlannedEndTime; |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System.ComponentModel; |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.Domain.Shared.Enums |
| | | { |
| | | /// <summary> |
| | | /// å«æç¶æ |
| | | /// </summary> |
| | | public enum CallMaterialStatusEnum : byte |
| | | { |
| | | /// <summary> |
| | | /// æªæ§è¡ |
| | | /// </summary> |
| | | [Description("æªæ§è¡")] |
| | | æªæ§è¡ = 0, |
| | | |
| | | /// <summary> |
| | | /// å«æä¸ |
| | | /// </summary> |
| | | [Description("嫿ä¸")] |
| | | å«æä¸ = 1, |
| | | |
| | | |
| | | /// <summary> |
| | | /// 嫿宿 |
| | | /// </summary> |
| | | [Description("嫿宿")] |
| | | 嫿宿 = 4, |
| | | |
| | | /// <summary> |
| | | /// 已忶嫿 |
| | | /// </summary> |
| | | [Description("已忶嫿")] |
| | | 已忶嫿 = 5, |
| | | |
| | | /// <summary> |
| | | /// å«æå¤±è´¥ |
| | | /// </summary> |
| | | [Description("å«æå¤±è´¥")] |
| | | å«æå¤±è´¥ = 6, |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System.ComponentModel; |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.Domain.Shared.Enums |
| | | { |
| | | /// <summary> |
| | | /// ä½ä¸è®¡åç¶æ |
| | | /// </summary> |
| | | public enum WorkPlanStatusEnum : byte |
| | | { |
| | | /// <summary> |
| | | /// æªæ§è¡ |
| | | /// </summary> |
| | | [Description("æªæ§è¡")] |
| | | æªæ§è¡ = 0, |
| | | |
| | | /// <summary> |
| | | /// æ§è¡ä¸ |
| | | /// </summary> |
| | | [Description("æ§è¡ä¸")] |
| | | æ§è¡ä¸ = 1, |
| | | |
| | | /// <summary> |
| | | /// æåä¸ |
| | | /// </summary> |
| | | [Description("æåä¸")] |
| | | æåä¸ = 2, |
| | | |
| | | /// <summary> |
| | | /// 已宿 |
| | | /// </summary> |
| | | [Description("已宿")] |
| | | 已宿 = 4, |
| | | |
| | | /// <summary> |
| | | /// 已忶 |
| | | /// </summary> |
| | | [Description("已忶")] |
| | | 已忶 = 5, |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using CMS.Plugin.MyExtension.Domain; |
| | | using CMS.Plugin.PipeLineLems.Domain.Shared.Enums; |
| | | using Microsoft.EntityFrameworkCore; |
| | | using System.ComponentModel.DataAnnotations.Schema; |
| | | using Volo.Abp.Domain.Entities.Auditing; |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.Domain.CallMaterialOrder |
| | | { |
| | | /// <summary> |
| | | /// 嫿å表 |
| | | /// </summary> |
| | | public class CallMaterialOrder : MyFullAuditedAggregateRoot<Guid> |
| | | { |
| | | /// <summary> |
| | | /// åææ è¯ |
| | | /// </summary> |
| | | public string DataIdentifier { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæåå· |
| | | /// </summary> |
| | | public string MaterialMode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å«æç¶æ |
| | | /// </summary> |
| | | public CallMaterialStatusEnum CallMaterialStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 嫿æ°é |
| | | /// </summary> |
| | | public int Quantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// WMSè¿åç»æ |
| | | /// </summary> |
| | | public string WmsRetResult { get; set; } |
| | | |
| | | /// <summary> |
| | | /// WMSä»»å¡å· |
| | | /// </summary> |
| | | public string WmsTaskNo { get; set; } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// Adjusts the sort. |
| | | /// </summary> |
| | | /// <param name="sort">The sort.</param> |
| | | public void AdjustSort(int sort) |
| | | { |
| | | Sort = sort; |
| | | } |
| | | |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using CMS.Plugin.MyExtension.Domain; |
| | | using CMS.Plugin.PipeLineLems.Domain.Shared.Enums; |
| | | using Microsoft.EntityFrameworkCore; |
| | | using System.ComponentModel.DataAnnotations.Schema; |
| | | using Volo.Abp.Domain.Entities.Auditing; |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.Domain.CallMaterialOrderRecord |
| | | { |
| | | /// <summary> |
| | | /// å«æè®°å½è¡¨ |
| | | /// </summary> |
| | | public class CallMaterialOrderRecord : MyFullAuditedAggregateRootForRecord<Guid> |
| | | { |
| | | /// <summary> |
| | | /// åææ è¯ |
| | | /// </summary> |
| | | public string DataIdentifier { get; set; } |
| | | |
| | | /// <summary> |
| | | /// åæåå· |
| | | /// </summary> |
| | | public string MaterialMode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å«æç¶æ |
| | | /// </summary> |
| | | public CallMaterialStatusEnum CallMaterialStatus { get; set; } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 嫿æ°é |
| | | /// </summary> |
| | | public int Quantity { get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// WMSè¿åç»æ |
| | | /// </summary> |
| | | public string WmsRetResult { get; set; } |
| | | |
| | | /// <summary> |
| | | /// WMSä»»å¡å· |
| | | /// </summary> |
| | | public string WmsTaskNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// Adjusts the sort. |
| | | /// </summary> |
| | | /// <param name="sort">The sort.</param> |
| | | public void AdjustSort(int sort) |
| | | { |
| | | Sort = sort; |
| | | } |
| | | |
| | | } |
| | | } |
| | |
| | | using CMS.Plugin.MyExtension.Domain; |
| | | using CMS.Plugin.PipeLineLems.Domain.Shared.Enums; |
| | | using Microsoft.EntityFrameworkCore; |
| | | using System.ComponentModel.DataAnnotations.Schema; |
| | | using Volo.Abp.Domain.Entities.Auditing; |
| | |
| | | /// ä»»å¡ç¼ç |
| | | /// </summary> |
| | | public string TaskCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 计åç¶æ |
| | | /// </summary> |
| | | public WorkPlanStatusEnum WorkPlanStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// å«æç¶æ |
| | | /// </summary> |
| | | public CallMaterialStatusEnum CallMaterialStatus { get; set; } |
| | | |
| | | #region åæç®¡ä¿¡æ¯ |
| | | |
| | |
| | | public string Material { get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ¯å¦ä¸»æ¯ç®¡ |
| | | /// </summary> |
| | | public bool HasMainSignature { get; set; } |
| | | ///// <summary> |
| | | ///// æ¯å¦ä¸»æ¯ç®¡ |
| | | ///// </summary> |
| | | //public bool HasMainSignature { get; set; } |
| | | |
| | | |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using CMS.Plugin.MyExtension.Domain; |
| | | using CMS.Plugin.PipeLineLems.Domain; |
| | | using CMS.Plugin.PipeLineLems.Domain.Shared.MyTestEntityNames; |
| | | using CMS.Plugin.PipeLineLems.Domain.CallMaterialOrder; |
| | | using Microsoft.EntityFrameworkCore; |
| | | using Volo.Abp; |
| | | using Volo.Abp.EntityFrameworkCore.Modeling; |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.EntityFrameworkCore.Extensions; |
| | | |
| | | /// <summary> |
| | | /// EfCoreæ©å± |
| | | /// </summary> |
| | | public static partial class CMSPluginEfCoreExtensions |
| | | { |
| | | /// <summary> |
| | | /// Includes the details. |
| | | /// </summary> |
| | | /// <param name="queryable">The queryable.</param> |
| | | /// <param name="include">if set to <c>true</c> [include].</param> |
| | | /// <returns></returns> |
| | | public static IQueryable<CallMaterialOrder> IncludeDetails(this IQueryable<CallMaterialOrder> queryable, bool include = true) |
| | | { |
| | | if (!include) |
| | | { |
| | | return queryable; |
| | | } |
| | | |
| | | return queryable; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// Configures the mytestentityname. |
| | | /// </summary> |
| | | /// <param name="builder">The builder.</param> |
| | | public static void ConfigureCallMaterialOrder(this ModelBuilder builder) |
| | | { |
| | | Check.NotNull(builder, nameof(builder)); |
| | | |
| | | builder.Entity<CallMaterialOrder>(b => |
| | | { |
| | | //Configure table & schema name |
| | | b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_CallMaterialOrders").ToLower(), CMSPluginDbProperties.DbSchema).HasComment("嫿å表"); |
| | | |
| | | b.ConfigureByConvention(); |
| | | |
| | | // Configure properties |
| | | |
| | | b.Property(x => x.CallMaterialStatus).IsRequired().HasComment("å«æç¶æ"); |
| | | b.Property(x => x.DataIdentifier).IsRequired().HasMaxLength(256).HasComment("åææ è¯"); |
| | | b.Property(x => x.MaterialMode).HasMaxLength(256).HasComment("åæåå·"); |
| | | b.Property(x => x.Quantity).HasComment("嫿æ°é"); |
| | | b.Property(x => x.WmsRetResult).HasComment("WMSè¿åç»æ"); |
| | | b.Property(x => x.WmsTaskNo).HasComment("WMSä»»å¡å·"); |
| | | |
| | | b.ConfigureMyCmsEntity(); |
| | | |
| | | // Configure indexes |
| | | b.HasIndex(u => u.DataIdentifier).IsUnique(); |
| | | b.HasIndex(u => u.DataIdentifier); |
| | | |
| | | b.ApplyObjectExtensionMappings(); |
| | | }); |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using CMS.Plugin.MyExtension.Domain; |
| | | using CMS.Plugin.PipeLineLems.Domain; |
| | | using CMS.Plugin.PipeLineLems.Domain.Shared.MyTestEntityNames; |
| | | using CMS.Plugin.PipeLineLems.Domain.CallMaterialOrderRecord; |
| | | using Microsoft.EntityFrameworkCore; |
| | | using Volo.Abp; |
| | | using Volo.Abp.EntityFrameworkCore.Modeling; |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.EntityFrameworkCore.Extensions; |
| | | |
| | | /// <summary> |
| | | /// EfCoreæ©å± |
| | | /// </summary> |
| | | public static partial class CMSPluginEfCoreExtensions |
| | | { |
| | | /// <summary> |
| | | /// Includes the details. |
| | | /// </summary> |
| | | /// <param name="queryable">The queryable.</param> |
| | | /// <param name="include">if set to <c>true</c> [include].</param> |
| | | /// <returns></returns> |
| | | public static IQueryable<CallMaterialOrderRecord> IncludeDetails(this IQueryable<CallMaterialOrderRecord> queryable, bool include = true) |
| | | { |
| | | if (!include) |
| | | { |
| | | return queryable; |
| | | } |
| | | |
| | | return queryable; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// Configures the mytestentityname. |
| | | /// </summary> |
| | | /// <param name="builder">The builder.</param> |
| | | public static void ConfigureCallMaterialOrderRecord(this ModelBuilder builder) |
| | | { |
| | | Check.NotNull(builder, nameof(builder)); |
| | | |
| | | builder.Entity<CallMaterialOrderRecord>(b => |
| | | { |
| | | //Configure table & schema name |
| | | b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_CallMaterialOrderRecords").ToLower(), CMSPluginDbProperties.DbSchema).HasComment("å«æè®°å½è¡¨"); |
| | | |
| | | b.ConfigureByConvention(); |
| | | |
| | | // Configure properties |
| | | |
| | | b.Property(x => x.CallMaterialStatus).IsRequired().HasComment("å«æç¶æ"); |
| | | b.Property(x => x.DataIdentifier).IsRequired().HasMaxLength(256).HasComment("åææ è¯"); |
| | | b.Property(x => x.MaterialMode).HasMaxLength(256).HasComment("åæåå·"); |
| | | b.Property(x => x.Quantity).HasComment("嫿æ°é"); |
| | | b.Property(x => x.WmsRetResult).HasComment("WMSè¿åç»æ"); |
| | | b.Property(x => x.WmsTaskNo).HasComment("WMSä»»å¡å·"); |
| | | |
| | | b.ConfigureMyCmsEntityForRecord(); |
| | | |
| | | // Configure indexes |
| | | b.HasIndex(u => u.DataIdentifier).IsUnique(); |
| | | b.HasIndex(u => u.DataIdentifier); |
| | | |
| | | b.ApplyObjectExtensionMappings(); |
| | | }); |
| | | } |
| | | } |
| | |
| | | builder.Entity<WorkPlan>(b => |
| | | { |
| | | //Configure table & schema name |
| | | b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WorkPlans").ToLower(), CMSPluginDbProperties.DbSchema).HasComment("WorkPlan"); |
| | | b.ToTable((CMSPluginDbProperties.DbTablePrefix + "_WorkPlans").ToLower(), CMSPluginDbProperties.DbSchema).HasComment("ä½ä¸è®¡å表"); |
| | | |
| | | b.ConfigureByConvention(); |
| | | |
| | | // Configure properties |
| | | b.Property(x => x.TaskCode).HasMaxLength(256).IsRequired().HasComment("ä»»å¡ç¼ç "); |
| | | b.Property(x => x.WorkPlanStatus).IsRequired().HasComment("计åç¶æ"); |
| | | b.Property(x => x.CallMaterialStatus).IsRequired().HasComment("å«æç¶æ"); |
| | | b.Property(x => x.DataIdentifier).HasMaxLength(256).HasComment("åææ è¯"); |
| | | b.Property(x => x.MaterialMode).HasMaxLength(256).HasComment("åæåå·"); |
| | | b.Property(x => x.Length).HasColumnType("decimal(18,2)").HasComment("é¿åº¦(mm)"); |
| | |
| | | b.Property(x => x.OuterDiameter).HasColumnType("decimal(18,2)").HasComment("å¤å¾(mm)"); |
| | | b.Property(x => x.Thickness).HasColumnType("decimal(18,2)").HasComment("å£å(mm)"); |
| | | b.Property(x => x.Material).HasMaxLength(256).HasComment("æè´¨"); |
| | | b.Property(x => x.HasMainSignature).HasComment("æ¯å¦ä¸»æ¯ç®¡"); |
| | | |
| | | |
| | | b.Property(x => x.MarkingPosition).HasColumnType("decimal(18,2)").HasComment("æç ä½ç½®"); |
| | | b.Property(x => x.CuttingPosition).HasColumnType("decimal(18,2)").HasComment("åå²ä½ç½®"); |
| | |
| | | |
| | | builder.ConfigureMyTestEntityName(); |
| | | builder.ConfigureWorkPlan(); |
| | | builder.ConfigureCallMaterialOrder(); |
| | | builder.ConfigureCallMaterialOrderRecord(); |
| | | |
| | | /* Configure your own tables/entities inside here */ |
| | | |
¶Ô±ÈÐÂÎļþ |
| | |
| | | // <auto-generated /> |
| | | using System; |
| | | using CMS.Plugin.PipeLineLems.MySQL; |
| | | using Microsoft.EntityFrameworkCore; |
| | | using Microsoft.EntityFrameworkCore.Infrastructure; |
| | | using Microsoft.EntityFrameworkCore.Migrations; |
| | | using Microsoft.EntityFrameworkCore.Storage.ValueConversion; |
| | | using Volo.Abp.EntityFrameworkCore; |
| | | |
| | | #nullable disable |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.MySQL.Migrations |
| | | { |
| | | [DbContext(typeof(CMSPluginDbContext))] |
| | | [Migration("20250511025035_Update1")] |
| | | partial class Update1 |
| | | { |
| | | protected override void BuildTargetModel(ModelBuilder modelBuilder) |
| | | { |
| | | #pragma warning disable 612, 618 |
| | | modelBuilder |
| | | .HasAnnotation("_Abp_DatabaseProvider", EfCoreDatabaseProvider.MySql) |
| | | .HasAnnotation("ProductVersion", "6.0.16") |
| | | .HasAnnotation("Relational:MaxIdentifierLength", 64); |
| | | |
| | | modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.CallMaterialOrder.CallMaterialOrder", b => |
| | | { |
| | | b.Property<Guid>("Id") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("char(36)"); |
| | | |
| | | b.Property<byte>("CallMaterialStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("å«æç¶æ"); |
| | | |
| | | b.Property<string>("ConcurrencyStamp") |
| | | .IsConcurrencyToken() |
| | | .HasMaxLength(40) |
| | | .HasColumnType("varchar(40)") |
| | | .HasColumnName("ConcurrencyStamp") |
| | | .HasComment("å¹¶åæ³"); |
| | | |
| | | b.Property<DateTime>("CreationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("CreationTime") |
| | | .HasComment("å建æ¶é´"); |
| | | |
| | | b.Property<Guid?>("CreatorId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("CreatorId") |
| | | .HasComment("å建人ID"); |
| | | |
| | | b.Property<string>("CreatorName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("å建人"); |
| | | |
| | | b.Property<string>("DataIdentifier") |
| | | .IsRequired() |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åææ è¯"); |
| | | |
| | | b.Property<string>("DeleteRemark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("å é¤å¤æ³¨"); |
| | | |
| | | b.Property<Guid?>("DeleterId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("DeleterId") |
| | | .HasComment("å é¤äººID"); |
| | | |
| | | b.Property<DateTime?>("DeletionTime") |
| | | .HasColumnType("datetime(6)") |
| | | .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") |
| | | .HasComment("æ©å±å±æ§"); |
| | | |
| | | b.Property<bool>("IsDeleted") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasColumnName("IsDeleted") |
| | | .HasComment("æ¯å¦å é¤"); |
| | | |
| | | b.Property<bool?>("IsDisabled") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasComment("æ¯å¦ç¦ç¨"); |
| | | |
| | | b.Property<DateTime?>("LastModificationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("LastModificationTime") |
| | | .HasComment("ä¿®æ¹æ¶é´"); |
| | | |
| | | b.Property<Guid?>("LastModifierId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("LastModifierId") |
| | | .HasComment("ä¿®æ¹äººID"); |
| | | |
| | | b.Property<string>("LastModifierName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("ä¿®æ¹äºº"); |
| | | |
| | | b.Property<string>("MaterialMode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åæåå·"); |
| | | |
| | | b.Property<string>("OperationRemark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æä½å¤æ³¨"); |
| | | |
| | | b.Property<int>("Quantity") |
| | | .HasColumnType("int") |
| | | .HasComment("嫿æ°é"); |
| | | |
| | | b.Property<string>("Remark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("夿³¨"); |
| | | |
| | | b.Property<int>("Sort") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("int") |
| | | .HasDefaultValue(0) |
| | | .HasComment("æåº"); |
| | | |
| | | b.Property<string>("WmsRetResult") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSè¿åç»æ"); |
| | | |
| | | b.Property<string>("WmsTaskNo") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSä»»å¡å·"); |
| | | |
| | | b.HasKey("Id"); |
| | | |
| | | b.HasIndex("DataIdentifier") |
| | | .IsUnique(); |
| | | |
| | | b.ToTable("scms_callmaterialorders", (string)null); |
| | | |
| | | b.HasComment("嫿å表"); |
| | | }); |
| | | |
| | | modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.CallMaterialOrderRecord.CallMaterialOrderRecord", b => |
| | | { |
| | | b.Property<Guid>("Id") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("char(36)"); |
| | | |
| | | b.Property<byte>("CallMaterialStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("å«æç¶æ"); |
| | | |
| | | b.Property<string>("ConcurrencyStamp") |
| | | .IsConcurrencyToken() |
| | | .HasMaxLength(40) |
| | | .HasColumnType("varchar(40)") |
| | | .HasColumnName("ConcurrencyStamp") |
| | | .HasComment("å¹¶åæ³"); |
| | | |
| | | b.Property<DateTime>("CreationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("CreationTime") |
| | | .HasComment("å建æ¶é´"); |
| | | |
| | | b.Property<Guid?>("CreatorId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("CreatorId") |
| | | .HasComment("å建人ID"); |
| | | |
| | | b.Property<string>("CreatorName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("å建人"); |
| | | |
| | | b.Property<string>("DataIdentifier") |
| | | .IsRequired() |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åææ è¯"); |
| | | |
| | | b.Property<Guid?>("DeleterId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("DeleterId") |
| | | .HasComment("å é¤äººID"); |
| | | |
| | | b.Property<DateTime?>("DeletionTime") |
| | | .HasColumnType("datetime(6)") |
| | | .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") |
| | | .HasComment("æ©å±å±æ§"); |
| | | |
| | | b.Property<bool>("IsDeleted") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasColumnName("IsDeleted") |
| | | .HasComment("æ¯å¦å é¤"); |
| | | |
| | | b.Property<DateTime?>("LastModificationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("LastModificationTime") |
| | | .HasComment("ä¿®æ¹æ¶é´"); |
| | | |
| | | b.Property<Guid?>("LastModifierId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("LastModifierId") |
| | | .HasComment("ä¿®æ¹äººID"); |
| | | |
| | | b.Property<string>("MaterialMode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åæåå·"); |
| | | |
| | | b.Property<int>("Quantity") |
| | | .HasColumnType("int") |
| | | .HasComment("嫿æ°é"); |
| | | |
| | | b.Property<string>("Remark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("夿³¨"); |
| | | |
| | | b.Property<int>("Sort") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("int") |
| | | .HasDefaultValue(0) |
| | | .HasComment("æåº"); |
| | | |
| | | b.Property<string>("WmsRetResult") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSè¿åç»æ"); |
| | | |
| | | b.Property<string>("WmsTaskNo") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSä»»å¡å·"); |
| | | |
| | | b.HasKey("Id"); |
| | | |
| | | b.HasIndex("DataIdentifier") |
| | | .IsUnique(); |
| | | |
| | | b.ToTable("scms_callmaterialorderrecords", (string)null); |
| | | |
| | | b.HasComment("å«æè®°å½è¡¨"); |
| | | }); |
| | | |
| | | modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.MyTestEntityNames.MyTestEntityName", b => |
| | | { |
| | | b.Property<Guid>("Id") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("char(36)"); |
| | | |
| | | b.Property<string>("Code") |
| | | .IsRequired() |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("ç¼ç "); |
| | | |
| | | b.Property<string>("ConcurrencyStamp") |
| | | .IsConcurrencyToken() |
| | | .HasMaxLength(40) |
| | | .HasColumnType("varchar(40)") |
| | | .HasColumnName("ConcurrencyStamp"); |
| | | |
| | | b.Property<DateTime>("CreationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("CreationTime"); |
| | | |
| | | b.Property<Guid?>("CreatorId") |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("CreatorId"); |
| | | |
| | | b.Property<Guid?>("DeleterId") |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("DeleterId"); |
| | | |
| | | b.Property<DateTime?>("DeletionTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("DeletionTime"); |
| | | |
| | | b.Property<string>("ExtraProperties") |
| | | .HasColumnType("longtext") |
| | | .HasColumnName("ExtraProperties"); |
| | | |
| | | b.Property<bool>("IsDeleted") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasColumnName("IsDeleted"); |
| | | |
| | | b.Property<bool?>("IsDisabled") |
| | | .HasColumnType("tinyint(1)") |
| | | .HasComment("æ¯å¦ç¦ç¨"); |
| | | |
| | | b.Property<DateTime?>("LastModificationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("LastModificationTime"); |
| | | |
| | | b.Property<Guid?>("LastModifierId") |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("LastModifierId"); |
| | | |
| | | b.Property<string>("Name") |
| | | .IsRequired() |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("åç§°"); |
| | | |
| | | b.Property<string>("Remark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("夿³¨"); |
| | | |
| | | b.Property<int>("Sort") |
| | | .HasColumnType("int") |
| | | .HasComment("æåº"); |
| | | |
| | | b.HasKey("Id"); |
| | | |
| | | b.HasIndex("Name"); |
| | | |
| | | b.ToTable("scms_mytestentitynames", (string)null); |
| | | |
| | | b.HasComment("MyTestEntityName"); |
| | | }); |
| | | |
| | | modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.WorkPlan.WorkPlan", b => |
| | | { |
| | | b.Property<Guid>("Id") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("char(36)"); |
| | | |
| | | b.Property<byte>("CallMaterialStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("å«æç¶æ"); |
| | | |
| | | b.Property<string>("ConcurrencyStamp") |
| | | .IsConcurrencyToken() |
| | | .HasMaxLength(40) |
| | | .HasColumnType("varchar(40)") |
| | | .HasColumnName("ConcurrencyStamp") |
| | | .HasComment("å¹¶åæ³"); |
| | | |
| | | b.Property<DateTime>("CreationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("CreationTime") |
| | | .HasComment("å建æ¶é´"); |
| | | |
| | | b.Property<Guid?>("CreatorId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("CreatorId") |
| | | .HasComment("å建人ID"); |
| | | |
| | | b.Property<string>("CreatorName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("å建人"); |
| | | |
| | | b.Property<decimal>("CuttingPosition") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("åå²ä½ç½®"); |
| | | |
| | | b.Property<string>("DataIdentifier") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åææ è¯"); |
| | | |
| | | b.Property<string>("DeleteRemark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("å é¤å¤æ³¨"); |
| | | |
| | | b.Property<Guid?>("DeleterId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("DeleterId") |
| | | .HasComment("å é¤äººID"); |
| | | |
| | | b.Property<DateTime?>("DeletionTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("DeletionTime") |
| | | .HasComment("å 餿¶é´"); |
| | | |
| | | b.Property<string>("EquipmentCode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .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") |
| | | .HasComment("æ©å±å±æ§"); |
| | | |
| | | b.Property<string>("FactoryCode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("å·¥å代ç "); |
| | | |
| | | b.Property<decimal>("FlangeInnerDiameter") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("æ³å
°ç´å¾(mm)"); |
| | | |
| | | b.Property<decimal>("FlangeThickness") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("æ³å
°å度(mm)"); |
| | | |
| | | b.Property<bool>("IsDeleted") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasColumnName("IsDeleted") |
| | | .HasComment("æ¯å¦å é¤"); |
| | | |
| | | b.Property<bool?>("IsDisabled") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasComment("æ¯å¦ç¦ç¨"); |
| | | |
| | | b.Property<DateTime?>("LastModificationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("LastModificationTime") |
| | | .HasComment("ä¿®æ¹æ¶é´"); |
| | | |
| | | b.Property<Guid?>("LastModifierId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("LastModifierId") |
| | | .HasComment("ä¿®æ¹äººID"); |
| | | |
| | | b.Property<string>("LastModifierName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("ä¿®æ¹äºº"); |
| | | |
| | | b.Property<decimal>("Length") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("é¿åº¦(mm)"); |
| | | |
| | | b.Property<string>("MarkingContent") |
| | | .HasMaxLength(1024) |
| | | .HasColumnType("varchar(1024)") |
| | | .HasComment("æç å
容"); |
| | | |
| | | b.Property<decimal>("MarkingPosition") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("æç ä½ç½®"); |
| | | |
| | | b.Property<string>("Material") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æè´¨"); |
| | | |
| | | b.Property<string>("MaterialMode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åæåå·"); |
| | | |
| | | b.Property<string>("OperationRemark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æä½å¤æ³¨"); |
| | | |
| | | b.Property<decimal>("OuterDiameter") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("å¤å¾(mm)"); |
| | | |
| | | b.Property<string>("PipeAllowableStress") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æ³å
°å²ç å
容"); |
| | | |
| | | b.Property<decimal>("PipeDiameter") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("å¥ç®¡é¿åº¦(mm)"); |
| | | |
| | | b.Property<string>("PipeFittingCode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("管件ç¼ç "); |
| | | |
| | | b.Property<string>("PipeSectionName") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("管段åç§°"); |
| | | |
| | | b.Property<string>("PipeSpecCode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("管段ç¼ç "); |
| | | |
| | | b.Property<decimal>("PipeWallThickness") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("å¥ç®¡ç´å¾(mm)"); |
| | | |
| | | b.Property<DateTime?>("PlannedEndTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasComment("计å宿æ¶é´"); |
| | | |
| | | b.Property<DateTime?>("PlannedStartTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasComment("计åå¼å§æ¶é´"); |
| | | |
| | | b.Property<string>("PreSerialNumber") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("顺åºå·"); |
| | | |
| | | b.Property<string>("ProcessName") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("å·¥åºåç§°"); |
| | | |
| | | b.Property<string>("ProcessRouteNumber") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("å·¥èºæµåç¼å·"); |
| | | |
| | | b.Property<string>("ProductCode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("产å代ç "); |
| | | |
| | | b.Property<int>("Quantity") |
| | | .HasColumnType("int") |
| | | .HasComment("管段æ°é"); |
| | | |
| | | b.Property<string>("Remark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("夿³¨"); |
| | | |
| | | b.Property<int>("Sort") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("int") |
| | | .HasDefaultValue(0) |
| | | .HasComment("æåº"); |
| | | |
| | | b.Property<string>("TaskCode") |
| | | .IsRequired() |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("ä»»å¡ç¼ç "); |
| | | |
| | | b.Property<string>("TeamInfo") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("çç»ä¿¡æ¯"); |
| | | |
| | | b.Property<decimal>("Thickness") |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("å£å(mm)"); |
| | | |
| | | b.Property<string>("Timestamp") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æ¶é´æ³"); |
| | | |
| | | b.Property<string>("WeldingHeatInput") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æ³å
°å
¬ç§°åå"); |
| | | |
| | | b.Property<byte>("WorkPlanStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("计åç¶æ"); |
| | | |
| | | b.Property<string>("WorkpieceName") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("工件åç§°"); |
| | | |
| | | b.Property<string>("WorkstationCode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("å·¥ä½ä»£ç "); |
| | | |
| | | b.HasKey("Id"); |
| | | |
| | | b.HasIndex("DataIdentifier"); |
| | | |
| | | b.HasIndex("PlannedEndTime"); |
| | | |
| | | b.HasIndex("PlannedStartTime"); |
| | | |
| | | b.HasIndex("TaskCode") |
| | | .IsUnique(); |
| | | |
| | | b.ToTable("scms_workplans", (string)null); |
| | | |
| | | b.HasComment("ä½ä¸è®¡å表"); |
| | | }); |
| | | #pragma warning restore 612, 618 |
| | | } |
| | | } |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using Microsoft.EntityFrameworkCore.Migrations; |
| | | |
| | | #nullable disable |
| | | |
| | | namespace CMS.Plugin.PipeLineLems.MySQL.Migrations |
| | | { |
| | | public partial class Update1 : Migration |
| | | { |
| | | protected override void Up(MigrationBuilder migrationBuilder) |
| | | { |
| | | migrationBuilder.AlterDatabase() |
| | | .Annotation("MySql:CharSet", "utf8mb4"); |
| | | |
| | | migrationBuilder.CreateTable( |
| | | name: "scms_callmaterialorderrecords", |
| | | columns: table => new |
| | | { |
| | | Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"), |
| | | DataIdentifier = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, comment: "åææ è¯") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | MaterialMode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åæåå·") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | CallMaterialStatus = table.Column<byte>(type: "tinyint unsigned", nullable: false, comment: "å«æç¶æ"), |
| | | Quantity = table.Column<int>(type: "int", nullable: false, comment: "嫿æ°é"), |
| | | WmsRetResult = table.Column<string>(type: "longtext", nullable: true, comment: "WMSè¿åç»æ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | WmsTaskNo = table.Column<string>(type: "longtext", nullable: true, comment: "WMSä»»å¡å·") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ExtraProperties = table.Column<string>(type: "longtext", nullable: true, comment: "æ©å±å±æ§") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true, comment: "å¹¶åæ³") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false, comment: "å建æ¶é´"), |
| | | CreatorId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "å建人ID", collation: "ascii_general_ci"), |
| | | LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "ä¿®æ¹æ¶é´"), |
| | | LastModifierId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "ä¿®æ¹äººID", collation: "ascii_general_ci"), |
| | | IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false, comment: "æ¯å¦å é¤"), |
| | | DeleterId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "å é¤äººID", collation: "ascii_general_ci"), |
| | | DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "å 餿¶é´"), |
| | | CreatorName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "å建人") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "æåº"), |
| | | Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "夿³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | 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 => |
| | | { |
| | | table.PrimaryKey("PK_scms_callmaterialorderrecords", x => x.Id); |
| | | }, |
| | | comment: "å«æè®°å½è¡¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"); |
| | | |
| | | migrationBuilder.CreateTable( |
| | | name: "scms_callmaterialorders", |
| | | columns: table => new |
| | | { |
| | | Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"), |
| | | DataIdentifier = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, comment: "åææ è¯") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | MaterialMode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åæåå·") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | CallMaterialStatus = table.Column<byte>(type: "tinyint unsigned", nullable: false, comment: "å«æç¶æ"), |
| | | Quantity = table.Column<int>(type: "int", nullable: false, comment: "嫿æ°é"), |
| | | WmsRetResult = table.Column<string>(type: "longtext", nullable: true, comment: "WMSè¿åç»æ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | WmsTaskNo = table.Column<string>(type: "longtext", nullable: true, comment: "WMSä»»å¡å·") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ExtraProperties = table.Column<string>(type: "longtext", nullable: true, comment: "æ©å±å±æ§") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true, comment: "å¹¶åæ³") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false, comment: "å建æ¶é´"), |
| | | CreatorId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "å建人ID", collation: "ascii_general_ci"), |
| | | LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "ä¿®æ¹æ¶é´"), |
| | | LastModifierId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "ä¿®æ¹äººID", collation: "ascii_general_ci"), |
| | | IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false, comment: "æ¯å¦å é¤"), |
| | | DeleterId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "å é¤äººID", collation: "ascii_general_ci"), |
| | | DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "å 餿¶é´"), |
| | | CreatorName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "å建人") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | LastModifierName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "ä¿®æ¹äºº") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | OperationRemark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æä½å¤æ³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | DeleteRemark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å é¤å¤æ³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "æåº"), |
| | | Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "夿³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | 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 => |
| | | { |
| | | table.PrimaryKey("PK_scms_callmaterialorders", x => x.Id); |
| | | }, |
| | | comment: "嫿å表") |
| | | .Annotation("MySql:CharSet", "utf8mb4"); |
| | | |
| | | migrationBuilder.CreateTable( |
| | | name: "scms_mytestentitynames", |
| | | columns: table => new |
| | | { |
| | | Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"), |
| | | Code = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "ç¼ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Name = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "åç§°") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Sort = table.Column<int>(type: "int", nullable: false, comment: "æåº"), |
| | | Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "夿³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, comment: "æ¯å¦ç¦ç¨"), |
| | | ExtraProperties = table.Column<string>(type: "longtext", nullable: true) |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true) |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false), |
| | | CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"), |
| | | LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true), |
| | | LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"), |
| | | IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false), |
| | | DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"), |
| | | DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true) |
| | | }, |
| | | constraints: table => |
| | | { |
| | | table.PrimaryKey("PK_scms_mytestentitynames", x => x.Id); |
| | | }, |
| | | comment: "MyTestEntityName") |
| | | .Annotation("MySql:CharSet", "utf8mb4"); |
| | | |
| | | migrationBuilder.CreateTable( |
| | | name: "scms_workplans", |
| | | columns: table => new |
| | | { |
| | | Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"), |
| | | TaskCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, comment: "ä»»å¡ç¼ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | WorkPlanStatus = table.Column<byte>(type: "tinyint unsigned", nullable: false, comment: "计åç¶æ"), |
| | | CallMaterialStatus = table.Column<byte>(type: "tinyint unsigned", nullable: false, comment: "å«æç¶æ"), |
| | | DataIdentifier = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åææ è¯") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | MaterialMode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åæåå·") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Length = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "é¿åº¦(mm)"), |
| | | MarkingContent = table.Column<string>(type: "varchar(1024)", maxLength: 1024, nullable: true, comment: "æç å
容") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | MarkingPosition = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "æç ä½ç½®"), |
| | | CuttingPosition = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "åå²ä½ç½®"), |
| | | Quantity = table.Column<int>(type: "int", nullable: false, comment: "管段æ°é"), |
| | | FlangeThickness = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "æ³å
°å度(mm)"), |
| | | FlangeInnerDiameter = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "æ³å
°ç´å¾(mm)"), |
| | | WeldingHeatInput = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æ³å
°å
¬ç§°åå") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | PipeAllowableStress = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æ³å
°å²ç å
容") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | PipeDiameter = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å¥ç®¡é¿åº¦(mm)"), |
| | | PipeWallThickness = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å¥ç®¡ç´å¾(mm)"), |
| | | FactoryCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥å代ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ProductCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "产å代ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | WorkstationCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥ä½ä»£ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | EquipmentCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "设å¤ä»£ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | WorkpieceName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "工件åç§°") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ProcessName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥åºåç§°") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | PipeFittingCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "管件ç¼ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | PreSerialNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "顺åºå·") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | PipeSpecCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "管段ç¼ç ") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | PipeSectionName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "管段åç§°") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | OuterDiameter = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å¤å¾(mm)"), |
| | | Thickness = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å£å(mm)"), |
| | | Material = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æè´¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ProcessRouteNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥èºæµåç¼å·") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | PlannedStartTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "计åå¼å§æ¶é´"), |
| | | PlannedEndTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "计å宿æ¶é´"), |
| | | TeamInfo = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "çç»ä¿¡æ¯") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Timestamp = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æ¶é´æ³") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ExtraProperties = table.Column<string>(type: "longtext", nullable: true, comment: "æ©å±å±æ§") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true, comment: "å¹¶åæ³") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false, comment: "å建æ¶é´"), |
| | | CreatorId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "å建人ID", collation: "ascii_general_ci"), |
| | | LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "ä¿®æ¹æ¶é´"), |
| | | LastModifierId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "ä¿®æ¹äººID", collation: "ascii_general_ci"), |
| | | IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false, comment: "æ¯å¦å é¤"), |
| | | DeleterId = table.Column<Guid>(type: "char(36)", maxLength: 36, nullable: true, comment: "å é¤äººID", collation: "ascii_general_ci"), |
| | | DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "å 餿¶é´"), |
| | | CreatorName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "å建人") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | LastModifierName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "ä¿®æ¹äºº") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | OperationRemark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æä½å¤æ³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | DeleteRemark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å é¤å¤æ³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "æåº"), |
| | | Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "夿³¨") |
| | | .Annotation("MySql:CharSet", "utf8mb4"), |
| | | 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 => |
| | | { |
| | | table.PrimaryKey("PK_scms_workplans", x => x.Id); |
| | | }, |
| | | comment: "ä½ä¸è®¡å表") |
| | | .Annotation("MySql:CharSet", "utf8mb4"); |
| | | |
| | | migrationBuilder.CreateIndex( |
| | | name: "IX_scms_callmaterialorderrecords_DataIdentifier", |
| | | table: "scms_callmaterialorderrecords", |
| | | column: "DataIdentifier", |
| | | unique: true); |
| | | |
| | | migrationBuilder.CreateIndex( |
| | | name: "IX_scms_callmaterialorders_DataIdentifier", |
| | | table: "scms_callmaterialorders", |
| | | column: "DataIdentifier", |
| | | unique: true); |
| | | |
| | | migrationBuilder.CreateIndex( |
| | | name: "IX_scms_mytestentitynames_Name", |
| | | table: "scms_mytestentitynames", |
| | | column: "Name"); |
| | | |
| | | migrationBuilder.CreateIndex( |
| | | name: "IX_scms_workplans_DataIdentifier", |
| | | table: "scms_workplans", |
| | | column: "DataIdentifier"); |
| | | |
| | | migrationBuilder.CreateIndex( |
| | | name: "IX_scms_workplans_PlannedEndTime", |
| | | table: "scms_workplans", |
| | | column: "PlannedEndTime"); |
| | | |
| | | migrationBuilder.CreateIndex( |
| | | name: "IX_scms_workplans_PlannedStartTime", |
| | | table: "scms_workplans", |
| | | column: "PlannedStartTime"); |
| | | |
| | | migrationBuilder.CreateIndex( |
| | | name: "IX_scms_workplans_TaskCode", |
| | | table: "scms_workplans", |
| | | column: "TaskCode", |
| | | unique: true); |
| | | } |
| | | |
| | | protected override void Down(MigrationBuilder migrationBuilder) |
| | | { |
| | | migrationBuilder.DropTable( |
| | | name: "scms_callmaterialorderrecords"); |
| | | |
| | | migrationBuilder.DropTable( |
| | | name: "scms_callmaterialorders"); |
| | | |
| | | migrationBuilder.DropTable( |
| | | name: "scms_mytestentitynames"); |
| | | |
| | | migrationBuilder.DropTable( |
| | | name: "scms_workplans"); |
| | | } |
| | | } |
| | | } |
| | |
| | | .HasAnnotation("ProductVersion", "6.0.16") |
| | | .HasAnnotation("Relational:MaxIdentifierLength", 64); |
| | | |
| | | modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.CallMaterialOrder.CallMaterialOrder", b => |
| | | { |
| | | b.Property<Guid>("Id") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("char(36)"); |
| | | |
| | | b.Property<byte>("CallMaterialStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("å«æç¶æ"); |
| | | |
| | | b.Property<string>("ConcurrencyStamp") |
| | | .IsConcurrencyToken() |
| | | .HasMaxLength(40) |
| | | .HasColumnType("varchar(40)") |
| | | .HasColumnName("ConcurrencyStamp") |
| | | .HasComment("å¹¶åæ³"); |
| | | |
| | | b.Property<DateTime>("CreationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("CreationTime") |
| | | .HasComment("å建æ¶é´"); |
| | | |
| | | b.Property<Guid?>("CreatorId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("CreatorId") |
| | | .HasComment("å建人ID"); |
| | | |
| | | b.Property<string>("CreatorName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("å建人"); |
| | | |
| | | b.Property<string>("DataIdentifier") |
| | | .IsRequired() |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åææ è¯"); |
| | | |
| | | b.Property<string>("DeleteRemark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("å é¤å¤æ³¨"); |
| | | |
| | | b.Property<Guid?>("DeleterId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("DeleterId") |
| | | .HasComment("å é¤äººID"); |
| | | |
| | | b.Property<DateTime?>("DeletionTime") |
| | | .HasColumnType("datetime(6)") |
| | | .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") |
| | | .HasComment("æ©å±å±æ§"); |
| | | |
| | | b.Property<bool>("IsDeleted") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasColumnName("IsDeleted") |
| | | .HasComment("æ¯å¦å é¤"); |
| | | |
| | | b.Property<bool?>("IsDisabled") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasComment("æ¯å¦ç¦ç¨"); |
| | | |
| | | b.Property<DateTime?>("LastModificationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("LastModificationTime") |
| | | .HasComment("ä¿®æ¹æ¶é´"); |
| | | |
| | | b.Property<Guid?>("LastModifierId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("LastModifierId") |
| | | .HasComment("ä¿®æ¹äººID"); |
| | | |
| | | b.Property<string>("LastModifierName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("ä¿®æ¹äºº"); |
| | | |
| | | b.Property<string>("MaterialMode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åæåå·"); |
| | | |
| | | b.Property<string>("OperationRemark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æä½å¤æ³¨"); |
| | | |
| | | b.Property<int>("Quantity") |
| | | .HasColumnType("int") |
| | | .HasComment("嫿æ°é"); |
| | | |
| | | b.Property<string>("Remark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("夿³¨"); |
| | | |
| | | b.Property<int>("Sort") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("int") |
| | | .HasDefaultValue(0) |
| | | .HasComment("æåº"); |
| | | |
| | | b.Property<string>("WmsRetResult") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSè¿åç»æ"); |
| | | |
| | | b.Property<string>("WmsTaskNo") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSä»»å¡å·"); |
| | | |
| | | b.HasKey("Id"); |
| | | |
| | | b.HasIndex("DataIdentifier") |
| | | .IsUnique(); |
| | | |
| | | b.ToTable("scms_callmaterialorders", (string)null); |
| | | |
| | | b.HasComment("嫿å表"); |
| | | }); |
| | | |
| | | modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.CallMaterialOrderRecord.CallMaterialOrderRecord", b => |
| | | { |
| | | b.Property<Guid>("Id") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("char(36)"); |
| | | |
| | | b.Property<byte>("CallMaterialStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("å«æç¶æ"); |
| | | |
| | | b.Property<string>("ConcurrencyStamp") |
| | | .IsConcurrencyToken() |
| | | .HasMaxLength(40) |
| | | .HasColumnType("varchar(40)") |
| | | .HasColumnName("ConcurrencyStamp") |
| | | .HasComment("å¹¶åæ³"); |
| | | |
| | | b.Property<DateTime>("CreationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("CreationTime") |
| | | .HasComment("å建æ¶é´"); |
| | | |
| | | b.Property<Guid?>("CreatorId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("CreatorId") |
| | | .HasComment("å建人ID"); |
| | | |
| | | b.Property<string>("CreatorName") |
| | | .HasMaxLength(64) |
| | | .HasColumnType("varchar(64)") |
| | | .HasComment("å建人"); |
| | | |
| | | b.Property<string>("DataIdentifier") |
| | | .IsRequired() |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åææ è¯"); |
| | | |
| | | b.Property<Guid?>("DeleterId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("DeleterId") |
| | | .HasComment("å é¤äººID"); |
| | | |
| | | b.Property<DateTime?>("DeletionTime") |
| | | .HasColumnType("datetime(6)") |
| | | .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") |
| | | .HasComment("æ©å±å±æ§"); |
| | | |
| | | b.Property<bool>("IsDeleted") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | | .HasDefaultValue(false) |
| | | .HasColumnName("IsDeleted") |
| | | .HasComment("æ¯å¦å é¤"); |
| | | |
| | | b.Property<DateTime?>("LastModificationTime") |
| | | .HasColumnType("datetime(6)") |
| | | .HasColumnName("LastModificationTime") |
| | | .HasComment("ä¿®æ¹æ¶é´"); |
| | | |
| | | b.Property<Guid?>("LastModifierId") |
| | | .HasMaxLength(36) |
| | | .HasColumnType("char(36)") |
| | | .HasColumnName("LastModifierId") |
| | | .HasComment("ä¿®æ¹äººID"); |
| | | |
| | | b.Property<string>("MaterialMode") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("åæåå·"); |
| | | |
| | | b.Property<int>("Quantity") |
| | | .HasColumnType("int") |
| | | .HasComment("嫿æ°é"); |
| | | |
| | | b.Property<string>("Remark") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("夿³¨"); |
| | | |
| | | b.Property<int>("Sort") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("int") |
| | | .HasDefaultValue(0) |
| | | .HasComment("æåº"); |
| | | |
| | | b.Property<string>("WmsRetResult") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSè¿åç»æ"); |
| | | |
| | | b.Property<string>("WmsTaskNo") |
| | | .HasColumnType("longtext") |
| | | .HasComment("WMSä»»å¡å·"); |
| | | |
| | | b.HasKey("Id"); |
| | | |
| | | b.HasIndex("DataIdentifier") |
| | | .IsUnique(); |
| | | |
| | | b.ToTable("scms_callmaterialorderrecords", (string)null); |
| | | |
| | | b.HasComment("å«æè®°å½è¡¨"); |
| | | }); |
| | | |
| | | modelBuilder.Entity("CMS.Plugin.PipeLineLems.Domain.MyTestEntityNames.MyTestEntityName", b => |
| | | { |
| | | b.Property<Guid>("Id") |
| | |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("char(36)"); |
| | | |
| | | b.Property<byte>("CallMaterialStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("å«æç¶æ"); |
| | | |
| | | b.Property<string>("ConcurrencyStamp") |
| | | .IsConcurrencyToken() |
| | | .HasMaxLength(40) |
| | |
| | | .HasComment("å建人"); |
| | | |
| | | b.Property<decimal>("CuttingPosition") |
| | | .HasColumnType("decimal(65,30)"); |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("åå²ä½ç½®"); |
| | | |
| | | b.Property<string>("DataIdentifier") |
| | | .HasMaxLength(256) |
| | |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("æ³å
°å度(mm)"); |
| | | |
| | | b.Property<bool>("HasMainSignature") |
| | | .HasColumnType("tinyint(1)") |
| | | .HasComment("æ¯å¦ä¸»æ¯ç®¡"); |
| | | |
| | | b.Property<bool>("IsDeleted") |
| | | .ValueGeneratedOnAdd() |
| | | .HasColumnType("tinyint(1)") |
| | |
| | | .HasComment("æç å
容"); |
| | | |
| | | b.Property<decimal>("MarkingPosition") |
| | | .HasColumnType("decimal(65,30)"); |
| | | .HasColumnType("decimal(18,2)") |
| | | .HasComment("æç ä½ç½®"); |
| | | |
| | | b.Property<string>("Material") |
| | | .HasMaxLength(256) |
| | |
| | | .HasColumnType("varchar(256)") |
| | | .HasComment("æ³å
°å
¬ç§°åå"); |
| | | |
| | | b.Property<byte>("WorkPlanStatus") |
| | | .HasColumnType("tinyint unsigned") |
| | | .HasComment("计åç¶æ"); |
| | | |
| | | b.Property<string>("WorkpieceName") |
| | | .HasMaxLength(256) |
| | | .HasColumnType("varchar(256)") |
| | |
| | | |
| | | b.ToTable("scms_workplans", (string)null); |
| | | |
| | | b.HasComment("WorkPlan"); |
| | | b.HasComment("ä½ä¸è®¡å表"); |
| | | }); |
| | | #pragma warning restore 612, 618 |
| | | } |
| | |
| | | <connectionStrings> |
| | | <add name="æ¬å°_MySql_CMS" connectionString="Server=localhost;Database=07a6b2f4bbb04e8bb23a9f17a4a769c2_project;Uid=root;Pwd=123abc.com;" /> |
| | | <add name="ZS_æ¬å°WmsMysql" connectionString="Server=localhost;Database=cms.plugin.hiawms;Uid=root;Pwd=123abc.com;" /> |
| | | <add name="Shao_æ¬å°WmsMysql" connectionString="Server=localhost;Database=cms.plugin.hiawms;Uid=root;Pwd=123abc.com;" /> |
| | | <add name="Shao_æ¬å°WmsMysql" connectionString="Server=localhost;Database=cms.plugin.pipelinelems;Uid=root;Pwd=123abc.com;" /> |
| | | <!-- <add name="LA22012_æ¦æ±ç§é_ç产åº_伿¬ç¯å¢" connectionString="Data Source=10.10.40.166;Initial Catalog=WHMY_Prod_Test;Persist Security Info=True;User ID=sa;Password=123abc.com" /> |
| | | <add name="LA22012_æ¦æ±ç§é_ç产åº_26æµè¯ç¯å¢" connectionString="Data Source=172.27.96.26;Initial Catalog=WHMY_Prod_Test;Persist Security Info=True;User ID=sa;Password=MJC!2022@wms" /> |
| | | <add name="LA22012_æ¦æ±ç§é_å¤ä»¶åº_伿¬ç¯å¢" connectionString="Data Source=10.10.40.166;Initial Catalog=WHMY_Admin.NET;Persist Security Info=True;User ID=sa;Password=123abc.com" /> |
| | |
| | | /// ç¹æ®å段-æ©å±å段 |
| | | /// </summary> |
| | | public const string pro_ExtraProperties = "ExtraProperties"; |
| | | |
| | | /// <summary> |
| | | /// æä¸¾çæè¿°å段åç§° |
| | | /// </summary> |
| | | public const string enumDescName = "Desc"; |
| | | } |
| | | } |
| | |
| | | [æ¨¡ç³æ¥è¯¢å段]: |
| | | [æ¨¡ç³æ¥è¯¢å段å]: |
| | | [项ç®å½å空é´]:PipeLineLems |
| | | [æä¸¾ç±»ååæ®µéå]: |
| | | [æä¸¾ç±»ååæ®µéå]:WorkPlanStatus,WorkPlanStatusEnum&CallMaterialStatus,CallMaterialStatusEnum |
| | | [åç«¯æ ¹æä»¶å¤¹åç§°]:pipelinelems_web |
| | | [æåº]:CreationTime |
| | |
| | | [æ¨¡ç³æ¥è¯¢å段]:'TaskCode','MaterialMode', 'ProductCode' |
| | | [æ¨¡ç³æ¥è¯¢å段å]:请è¾å
¥ä»»å¡ç¼ç /åæåå·/产å代ç |
| | | [项ç®å½å空é´]:PipeLineLems |
| | | [æä¸¾ç±»ååæ®µéå]: |
| | | [æä¸¾ç±»ååæ®µéå]:WorkPlanStatus,WorkPlanStatusEnum&CallMaterialStatus,CallMaterialStatusEnum |
| | | [åç«¯æ ¹æä»¶å¤¹åç§°]:pipelinelems_web |
| | | [æåº]:CreationTime |
| | |
| | | [æ¨¡ç³æ¥è¯¢å段]:'MaterialCode', 'MaterialName', 'Remark' |
| | | [æ¨¡ç³æ¥è¯¢å段å]:请è¾å
¥ç©æç¼ç /ç©æåç§°/夿³¨ |
| | | [项ç®å½å空é´]:HIAWms |
| | | [æä¸¾ç±»ååæ®µéå]:PurchaseType|PurchaseTypeEnum|PurchaseTypeDesc,MaterialType|MaterialTypeEnum|MaterialTypeDesc,IsMainBranch|YesNoEnum|IsMainBranchDesc |
| | | [æä¸¾ç±»ååæ®µéå]:PurchaseType,PurchaseTypeEnum&MaterialType,MaterialTypeEnum&IsMainBranch,YesNoEnum |
| | | [åç«¯æ ¹æä»¶å¤¹åç§°]:templatedemo_web |
| | | [æåº]:CreationTime |
| | |
| | | //å¤çæä¸¾ç±»å |
| | | List<EnumModel> enumList = new List<EnumModel>(); |
| | | var str_enumList = this.tb_EnumList.Text.Trim(); |
| | | if (str_enumList.IndexOf(',') > -1) |
| | | if (str_enumList.IndexOf('&') > -1) |
| | | { |
| | | str_enumList = str_enumList.Replace("\n", ""); |
| | | str_enumList = str_enumList.Replace("\t", ""); |
| | | str_enumList = str_enumList.Replace("\r", ""); |
| | | var arr_enumList = str_enumList.Split(','); |
| | | var arr_enumList = str_enumList.Split('&'); |
| | | foreach (var item in arr_enumList) |
| | | { |
| | | var arr_single = item.Split('|'); |
| | | var arr_single = item.Split(','); |
| | | enumList.Add(new EnumModel() |
| | | { |
| | | EnumAttrName = arr_single[0], |
| | | EnumType = arr_single[1], |
| | | EnumTypeDesc = arr_single[2] |
| | | EnumTypeDesc = arr_single[0] + SystemConst.enumDescName |
| | | }); |
| | | } |
| | | } |
| | |
| | | { |
| | | if (!string.IsNullOrEmpty(str_enumList)) |
| | | { |
| | | var arr_single = str_enumList.Split('|'); |
| | | var arr_single = str_enumList.Split(','); |
| | | enumList.Add(new EnumModel() |
| | | { |
| | | EnumAttrName = arr_single[0], |
| | | EnumType = arr_single[1], |
| | | EnumTypeDesc = arr_single[2] |
| | | EnumTypeDesc = arr_single[0] + SystemConst.enumDescName |
| | | }); |
| | | } |
| | | } |