HIAWms/server/src/CMS.Plugin.HIAWms.Application.Contracts/Services/IWmsMaterialStockAppService.cs
@@ -23,6 +23,13 @@ Task DeleteManyAsync(IEnumerable<Guid> ids); /// <summary> /// éè¿ç©æç¼å·å é¤åºå /// </summary> /// <param name="materialNo"></param> /// <returns></returns> Task DeleteByMaterialAsync(string materialNo); /// <summary> /// Adjusts the sort asynchronous. /// </summary> /// <param name="id">The identifier.</param> HIAWms/server/src/CMS.Plugin.HIAWms.Application/Implements/WmsMaterialStockAppService.cs
@@ -12,6 +12,10 @@ using CMS.Plugin.HIAWms.Domain.WmsContainers; using CMS.Plugin.HIAWms.Domain.WmsPlaces; using CMS.Plugin.HIAWms.Domain.WmsAreas; using Volo.Abp.Uow; using Microsoft.Extensions.DependencyInjection; using NPOI.POIFS.Storage; using System.Text.Json; namespace CMS.Plugin.HIAWms.Application.Implements; @@ -23,23 +27,26 @@ private readonly IWmsContainerRepository _wmscontainerRepository; private readonly IWmsPlaceRepository _wmsplaceRepository; private readonly IWmsAreaRepository _wmsareaRepository; private readonly IServiceProvider _serviceProvider; /// <summary> /// Initializes a new instance of the <see cref="WmsMaterialStockAppService"/> class. /// </summary> /// <param name="wmsmaterialstockRepository">The task job repository.</param> public WmsMaterialStockAppService(IWmsMaterialStockRepository wmsmaterialstockRepository, IWmsMaterialRepository wmsMaterialRepository, IWmsContainerRepository wmscontainerRepository, IWmsPlaceRepository wmsplaceRepository, public WmsMaterialStockAppService(IWmsMaterialStockRepository wmsmaterialstockRepository, IWmsMaterialRepository wmsMaterialRepository, IWmsContainerRepository wmscontainerRepository, IWmsPlaceRepository wmsplaceRepository, IWmsAreaRepository wmsareaRepository ) , IServiceProvider serviceProvider) { _wmsmaterialstockRepository = wmsmaterialstockRepository; _wmsMaterialRepository = wmsMaterialRepository; _wmscontainerRepository = wmscontainerRepository; _wmsplaceRepository = wmsplaceRepository; _wmsareaRepository = wmsareaRepository; _serviceProvider = serviceProvider; } /// <inheritdoc /> @@ -69,6 +76,9 @@ /// <inheritdoc /> public virtual async Task<WmsMaterialStockDto> CreateAsync(WmsMaterialStockCreateDto input) { using var scope = _serviceProvider.CreateScope(); var unitOfWorkManager = scope.ServiceProvider.GetRequiredService<IUnitOfWorkManager>(); using var uow = unitOfWorkManager.Begin(requiresNew: true); await CheckCreateOrUpdateDtoAsync(input); //var exist = await _wmsmaterialstockRepository.NameExistAsync(input.MaterialNo); @@ -101,7 +111,7 @@ var wmsmaterialstock = ObjectMapper.Map<WmsMaterialStockCreateDto, WmsMaterialStock>(input); input.MapExtraPropertiesTo(wmsmaterialstock, MappingPropertyDefinitionChecks.None); wmsmaterialstock.MaterialId = Guid.NewGuid().ToString("N"); material.MaterialName = material.MaterialName; wmsmaterialstock.MaterialName = material.MaterialName; wmsmaterialstock.ContainerStatus = Domain.Shared.Enums.ContainerStatusEnum.KUWEI; wmsmaterialstock.ContainerType = container.ContainerType; @@ -116,7 +126,19 @@ wmsmaterialstock.Sort = sort; wmsmaterialstock.InStockTime = DateTime.Now; await _wmsmaterialstockRepository.InsertAsync(wmsmaterialstock); var stockList = new List<WmsMaterialStock>(); for (int i = 0; i< input.StockNumber; i++) { var stock = new WmsMaterialStock(); var json = JsonSerializer.Serialize(wmsmaterialstock); stock = JsonSerializer.Deserialize<WmsMaterialStock>(json); stock.MaterialId = Guid.NewGuid().ToString("N"); stock.StockNumber = 1; stockList.Add(stock); } await _wmsmaterialstockRepository.InsertManyAsync(stockList); container.ContainerStatus = Domain.Shared.Enums.ContainerStatusEnum.KUWEI; @@ -130,16 +152,20 @@ { await AdjustSortAsync(wmsmaterialstock.Id, wmsmaterialstock.Sort); } await uow.SaveChangesAsync(); await uow.CompleteAsync(); return ObjectMapper.Map<WmsMaterialStock, WmsMaterialStockDto>(wmsmaterialstock); } /// <inheritdoc /> public virtual async Task<WmsMaterialStockDto> UpdateAsync(Guid id, WmsMaterialStockUpdateDto input) { using var scope = _serviceProvider.CreateScope(); var unitOfWorkManager = scope.ServiceProvider.GetRequiredService<IUnitOfWorkManager>(); using var uow = unitOfWorkManager.Begin(requiresNew: true); await CheckCreateOrUpdateDtoAsync(input); var wmsmaterialstock = await _wmsmaterialstockRepository.GetAsync(id); var wmsmaterialstockList = await _wmsmaterialstockRepository.GetStockListAsync(new WmsMaterialStock { MaterialNo = input.MaterialNo }); //var exist = await _wmsmaterialstockRepository.NameExistAsync(input.MaterialNo, wmsmaterialstock.Id); //if (exist) //{ @@ -165,29 +191,53 @@ { throw new UserFriendlyException("åºä½åºåºä¿¡æ¯ä¸åå¨"); } wmsmaterialstock.SetConcurrencyStampIfNotNull(input.ConcurrencyStamp); input.MapExtraPropertiesTo(wmsmaterialstock, MappingPropertyDefinitionChecks.None); wmsmaterialstock.MaterialNo = input.MaterialNo; wmsmaterialstock.ContainerNo = input.ContainerNo; wmsmaterialstock.StockNumber = input.StockNumber; wmsmaterialstock.PlaceNo = input.PlaceNo; wmsmaterialstock.IsLock = input.IsLock; wmsmaterialstock.InStockTime = input.InStockTime; wmsmaterialstock.Remark = input.Remark; wmsmaterialstock.MaterialName = material.MaterialName; wmsmaterialstock.ContainerStatus = Domain.Shared.Enums.ContainerStatusEnum.KUWEI; wmsmaterialstock.ContainerType = container.ContainerType; foreach(var wmsmaterialstock in wmsmaterialstockList) { if(input.StockNumber< wmsmaterialstockList.Count) { wmsmaterialstock.IsDeleted = true; input.StockNumber += 1; } wmsmaterialstock.SetConcurrencyStampIfNotNull(input.ConcurrencyStamp); input.MapExtraPropertiesTo(wmsmaterialstock, MappingPropertyDefinitionChecks.None); wmsmaterialstock.MaterialNo = input.MaterialNo; wmsmaterialstock.ContainerNo = input.ContainerNo; //wmsmaterialstock.StockNumber = input.StockNumber; wmsmaterialstock.PlaceNo = input.PlaceNo; wmsmaterialstock.IsLock = input.IsLock; wmsmaterialstock.EmptyContainer = input.EmptyContainer; //wmsmaterialstock.InStockTime = input.InStockTime; wmsmaterialstock.Remark = input.Remark; wmsmaterialstock.PlaceStatus = Domain.Shared.Enums.PlaceStatusEnum.CUNHUO; wmsmaterialstock.StorageTypeNo = place.StorageTypeNo; wmsmaterialstock.AreaCode = place.AreaCode; wmsmaterialstock.AreaName = area.AreaName; wmsmaterialstock.MaterialName = material.MaterialName; wmsmaterialstock.ContainerStatus = Domain.Shared.Enums.ContainerStatusEnum.KUWEI; wmsmaterialstock.ContainerType = container.ContainerType; wmsmaterialstock.MaterialModel = material.MaterialModel; wmsmaterialstock.MaterialBatch = input.MaterialBatch; wmsmaterialstock.PlaceStatus = Domain.Shared.Enums.PlaceStatusEnum.CUNHUO; wmsmaterialstock.StorageTypeNo = place.StorageTypeNo; wmsmaterialstock.AreaCode = place.AreaCode; wmsmaterialstock.AreaName = area.AreaName; await _wmsmaterialstockRepository.UpdateAsync(wmsmaterialstock); wmsmaterialstock.MaterialModel = material.MaterialModel; wmsmaterialstock.MaterialBatch = input.MaterialBatch; } if(input.StockNumber > wmsmaterialstockList.Count) { var stockList = new List<WmsMaterialStock>(); for (int i = 0; i < input.StockNumber - wmsmaterialstockList.Count; i++) { var stock = new WmsMaterialStock(); var json = JsonSerializer.Serialize(wmsmaterialstockList[0]); stock = JsonSerializer.Deserialize<WmsMaterialStock>(json); stock.MaterialId = Guid.NewGuid().ToString("N"); stock.StockNumber = 1; stockList.Add(stock); } await _wmsmaterialstockRepository.InsertManyAsync(stockList); } await _wmsmaterialstockRepository.UpdateManyAsync(wmsmaterialstockList); container.ContainerStatus = Domain.Shared.Enums.ContainerStatusEnum.KUWEI; place.PlaceStatus = Domain.Shared.Enums.PlaceStatusEnum.CUNHUO; @@ -196,7 +246,31 @@ await _wmscontainerRepository.UpdateAsync(container); await _wmsplaceRepository.UpdateAsync(place); return ObjectMapper.Map<WmsMaterialStock, WmsMaterialStockDto>(wmsmaterialstock); await uow.SaveChangesAsync(); await uow.CompleteAsync(); var result = wmsmaterialstockList.GroupBy(x => new { x.MaterialNo, x.PlaceNo, x.ContainerNo }) .Select(g => new WmsMaterialStock { MaterialNo = g.Key.MaterialNo, MaterialName = g.First().MaterialName, PlaceNo = g.Key.PlaceNo, ContainerNo = g.Key.ContainerNo, ContainerStatus = g.First().ContainerStatus, PlaceStatus = g.First().PlaceStatus, StorageTypeNo = g.First().StorageTypeNo, MaterialBatch = g.First().MaterialBatch, MaterialModel = g.First().MaterialModel, AreaCode = g.First().AreaCode, AreaName = g.First().AreaName, CheckStatus = g.First().CheckStatus, IsLock = g.First().IsLock, EmptyContainer = g.First().EmptyContainer, InStockTime = g.First().InStockTime, StockNumber = g.Sum(x => x.StockNumber) }) .FirstOrDefault(); return ObjectMapper.Map<WmsMaterialStock, WmsMaterialStockDto>(result); } /// <inheritdoc /> @@ -249,6 +323,19 @@ } } /// <summary> /// å é¤åºå /// </summary> /// <param name="materialNo"></param> /// <returns></returns> public async Task DeleteByMaterialAsync(string materialNo) { var wmsmaterialstockList = await _wmsmaterialstockRepository.GetStockListAsync(new WmsMaterialStock { MaterialNo = materialNo }); var ids = wmsmaterialstockList.Select(x => x.Id); await DeleteManyAsync(ids); } /// <inheritdoc /> public virtual async Task AdjustSortAsync(Guid id, int sort) { HIAWms/server/src/CMS.Plugin.HIAWms.Domain/WmsMaterialStocks/IWmsMaterialStockRepository.cs
@@ -44,6 +44,12 @@ Task<List<WmsMaterialStock>> GetListAsync(WmsMaterialStock? stock, DateTime? startTime = null, DateTime? endTime = null, string sorting = null, int maxResultCount = int.MaxValue, int skipCount = 0, string filter = null, Specification<WmsMaterialStock> specification = null, bool includeDetails = false, CancellationToken cancellationToken = default); /// <summary> /// è·åææçåºåä¿¡æ¯ /// </summary> /// <param name="stock"></param> /// <returns></returns> Task<List<WmsMaterialStock>> GetStockListAsync(WmsMaterialStock? stock); /// <summary> /// Gets the count asynchronous. /// </summary> /// <param name="filter">The filter.</param> HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Extensions/CMSPluginEfCoreExtensions.WmsMaterialStock.cs
@@ -146,7 +146,7 @@ .HasComment("æ¯å¦ç¦ç¨"); // ç´¢å¼é ç½® b.HasIndex(x => x.MaterialNo).IsUnique(); b.HasIndex(x => x.MaterialNo); b.HasIndex(x => x.MaterialName); b.HasIndex(x => x.ContainerNo); b.HasIndex(x => x.PlaceNo); HIAWms/server/src/CMS.Plugin.HIAWms.EntityFrameworkCore/Repositories/EfCoreWmsMaterialStockRepository.cs
@@ -1,6 +1,7 @@ using System.Linq.Dynamic.Core; using CMS.Plugin.HIAWms.Domain.WmsMaterialStocks; using CMS.Plugin.HIAWms.EntityFrameworkCore.Extensions; using DatabaseSchemaReader.Filters; using Microsoft.EntityFrameworkCore; using SqlKata; using Volo.Abp.Domain.Repositories.EntityFrameworkCore; @@ -100,17 +101,18 @@ x.AreaName, x.CheckStatus, x.IsLock, x.StockNumber, x.EmptyContainer, x.InStockTime }) .ToListAsync(GetCancellationToken(cancellationToken)); var groupedData = materialList .GroupBy(x => new { x.MaterialNo, x.PlaceNo, x.ContainerNo, x.MaterialName }) .GroupBy(x => new { x.MaterialNo, x.PlaceNo, x.ContainerNo}) .Select(g => new WmsMaterialStock { MaterialNo = g.Key.MaterialNo, MaterialName = g.Key.MaterialName, MaterialName = g.First().MaterialName, PlaceNo = g.Key.PlaceNo, ContainerNo = g.Key.ContainerNo, ContainerStatus = g.First().ContainerStatus, @@ -124,7 +126,7 @@ IsLock = g.First().IsLock, EmptyContainer = g.First().EmptyContainer, InStockTime = g.First().InStockTime, StockNumber = g.Count() StockNumber = g.Sum(x=>x.StockNumber) }) .AsQueryable(); // 转æ¢åIQueryable以æ¯æåç»æä½ @@ -213,6 +215,32 @@ return groupedData.Count(); } /// <summary> /// æ¥è¯¢åºåå表 /// </summary> /// <param name="stock"></param> /// <returns></returns> public async Task<List<WmsMaterialStock>> GetStockListAsync(WmsMaterialStock? stock) { var baseQuery = await (await GetDbSetAsync()) .WhereIf(!string.IsNullOrEmpty(stock?.MaterialNo), u => u.MaterialNo.Contains(stock.MaterialNo)) .WhereIf(!string.IsNullOrEmpty(stock?.MaterialName), u => u.MaterialName.Contains(stock.MaterialName)) .WhereIf(!string.IsNullOrEmpty(stock?.ContainerNo), u => u.ContainerNo == stock.ContainerNo) .WhereIf(stock?.ContainerStatus > 0, u => u.ContainerStatus == stock.ContainerStatus) .WhereIf(stock?.ContainerType > 0, u => u.ContainerType == stock.ContainerType) .WhereIf(!string.IsNullOrEmpty(stock?.MaterialBatch), u => u.MaterialBatch == stock.MaterialBatch) .WhereIf(!string.IsNullOrEmpty(stock?.SupplierCode), u => u.SupplierCode == stock.SupplierCode) .WhereIf(!string.IsNullOrEmpty(stock?.MaterialModel), u => u.MaterialModel.Contains(stock.MaterialModel)) .WhereIf(!string.IsNullOrEmpty(stock?.PlaceNo), u => u.PlaceNo == stock.PlaceNo) .WhereIf(stock.PlaceStatus > 0, u => u.PlaceStatus == stock.PlaceStatus) .WhereIf(stock?.StorageTypeNo > 0, u => u.StorageTypeNo == stock.StorageTypeNo) .WhereIf(!string.IsNullOrEmpty(stock?.AreaCode), u => u.AreaCode == stock.AreaCode) .WhereIf(!string.IsNullOrEmpty(stock?.AreaName), u => u.AreaName.Contains(stock.AreaName)) .WhereIf(stock.IsLock > 0, u => u.IsLock == stock.IsLock) .Where(u => !u.IsDeleted) .ToListAsync(); return baseQuery; } /// <inheritdoc /> public override async Task<IQueryable<WmsMaterialStock>> WithDetailsAsync() { HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250505135455_InitialCreate4.Designer.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,1002 @@ // <auto-generated /> using System; using CMS.Plugin.HIAWms.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.HIAWms.MySQL.Migrations { [DbContext(typeof(CMSPluginDbContext))] [Migration("20250505135455_InitialCreate4")] partial class InitialCreate4 { 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.HIAWms.Domain.WmsAreas.WmsArea", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("AreaDesc") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("æè¿°"); b.Property<string>("AreaName") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åºåºå称"); b.Property<string>("AreaNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("åºåºç¼å·"); b.Property<int>("AreaStatus") .HasColumnType("int") .HasComment("åºåºç¶æ"); b.Property<int>("AreaType") .HasColumnType("int") .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>("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<string>("StoreCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ä»åºä»£ç "); b.Property<string>("StoreName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("ä»åºå称"); b.HasKey("Id"); b.HasIndex("AreaName"); b.ToTable("scms_wmsareas", (string)null); b.HasComment("åºåºè¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainers.WmsContainer", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property<string>("ContainerNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("æçç¼å·"); b.Property<int>("ContainerStatus") .HasColumnType("int") .HasComment("æçç¶æ"); b.Property<int>("ContainerType") .HasColumnType("int") .HasComment("æçç±»å"); 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<int?>("ExceptionNumber") .HasColumnType("int") .HasComment("å¼å¸¸æ°é"); 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<decimal?>("LimitHeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("éé«"); b.Property<decimal?>("LimitLength") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("éé¿"); b.Property<decimal?>("LimitWidth") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("é宽"); b.Property<int?>("MaterialNumber") .HasColumnType("int") .HasComment("ç©ææ°é"); b.Property<decimal?>("MaxWeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("è½½éä¸é"); b.Property<string>("RedundantField1") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<decimal?>("SpecHeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("é«åº¦"); b.Property<decimal?>("SpecLength") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("é¿åº¦"); b.Property<decimal?>("SpecWidth") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("宽度"); b.HasKey("Id"); b.HasIndex("ContainerNo") .IsUnique(); b.HasIndex("ContainerStatus"); b.HasIndex("ContainerType"); b.ToTable("scms_wmscontainers", (string)null); b.HasComment("æçä¿¡æ¯è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialInfos.WmsMaterialInfo", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<int?>("CheckStatus") .HasColumnType("int") .HasComment("æ£éªç¶æ(0:æªæ£éª,1:æ£éªéè¿,2:æ£éªä¸éè¿)"); 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>("MaterialBatch") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ç©ææ¹å·"); b.Property<string>("MaterialId") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æå¯ä¸ç "); b.Property<string>("MaterialModel") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("æºå/è§æ ¼"); b.Property<string>("MaterialName") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("ç©æå称"); b.Property<string>("MaterialNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ç©æ代å·"); b.Property<string>("RedundantField1") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("åä½å段1"); b.Property<string>("RedundantField2") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("åä½å段2"); b.Property<string>("RedundantField3") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("åä½å段3"); b.Property<string>("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("æåº"); b.Property<int?>("StockNumber") .HasColumnType("int") .HasComment("åºåæ°é"); b.Property<string>("SupplierCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ä¾åºåç¼å·"); b.HasKey("Id"); b.HasIndex("CheckStatus"); b.HasIndex("MaterialBatch"); b.HasIndex("MaterialId") .IsUnique(); b.HasIndex("MaterialName"); b.HasIndex("MaterialNo") .IsUnique(); b.HasIndex("SupplierCode"); b.ToTable("scms_wmsmaterialinfos", (string)null); b.HasComment("WMSç©æä¿¡æ¯è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterials.WmsMaterial", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("Certification") .HasMaxLength(128) .HasColumnType("varchar(128)") .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<string>("Factory") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç产工å"); b.Property<bool>("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property<bool?>("IsDisabled") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasComment("æ¯å¦ç¦ç¨"); b.Property<int>("IsMainBranch") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(2) .HasComment("æ¯å¦ä¸ºä¸»æ¯ç®¡"); b.Property<DateTime?>("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property<Guid?>("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property<decimal>("Length") .HasColumnType("decimal(18,2)") .HasComment("é¿åº¦ï¼åä½ï¼mï¼"); b.Property<string>("MaterialCode") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æç¼ç ï¼å¯ä¸æ è¯ï¼"); b.Property<string>("MaterialModel") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("åå·"); b.Property<string>("MaterialName") .IsRequired() .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("ç©æå称"); b.Property<string>("MaterialQuality") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("æè´¨ï¼å¦ï¼304ä¸éé¢ï¼"); b.Property<int>("MaterialType") .HasColumnType("int") .HasComment("ç©æç±»åï¼æ举å¼ï¼"); b.Property<decimal>("OuterDiameter") .HasColumnType("decimal(18,2)") .HasComment("å¤å¾ï¼åä½ï¼mmï¼"); b.Property<string>("PrimaryUnit") .HasMaxLength(20) .HasColumnType("varchar(20)") .HasComment("主åä½ï¼å¦ï¼kgãmã个ï¼"); b.Property<int>("PurchaseType") .HasColumnType("int") .HasComment("éè´ç±»åï¼æ举å¼ï¼"); b.Property<string>("RedundantField1") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("æåº"); b.Property<string>("Standard") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("è§æ ¼/æ åï¼å¦ï¼GB/T 8163-2018ï¼"); b.Property<decimal>("WallThickness") .HasColumnType("decimal(18,2)") .HasComment("å£åï¼åä½ï¼mmï¼"); b.HasKey("Id"); b.HasIndex("MaterialCode") .IsUnique(); b.HasIndex("MaterialName"); b.HasIndex("MaterialType"); b.HasIndex("PurchaseType"); b.ToTable("scms_wmsmaterials", (string)null); b.HasComment("ç©æåºç¡ä¿¡æ¯è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialStocks.WmsMaterialStock", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("AreaCode") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("åºåç¼å·"); b.Property<string>("AreaName") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("åºåºå称"); b.Property<int?>("CheckStatus") .HasColumnType("int") .HasComment("æ£éªç¶æ(1:æªæ£éª,2:æ£éªéè¿,3:æ£éªä¸éè¿)"); b.Property<string>("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property<string>("ContainerNo") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("容å¨ç¼å·"); b.Property<int>("ContainerStatus") .HasColumnType("int") .HasComment("容å¨ç¶æ"); b.Property<int>("ContainerType") .HasColumnType("int") .HasComment("容å¨ç±»å"); 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<int>("EmptyContainer") .HasColumnType("int") .HasComment("æ¯å¦ç©ºæ(2:å¦,1:æ¯)"); b.Property<string>("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property<DateTime?>("InStockTime") .HasColumnType("datetime(6)") .HasComment("å ¥åºæ¶é´"); b.Property<bool>("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property<bool?>("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("æ¯å¦ç¦ç¨"); b.Property<int>("IsLock") .HasColumnType("int") .HasComment("æ¯å¦éå®(2:æªéå®,1:å·²éå®)"); b.Property<DateTime?>("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property<Guid?>("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property<string>("MaterialBatch") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©ææ¹æ¬¡"); b.Property<string>("MaterialId") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æID"); b.Property<string>("MaterialModel") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("æºå/è§æ ¼"); b.Property<string>("MaterialName") .IsRequired() .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("ç©æå称"); b.Property<string>("MaterialNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æç¼å·"); b.Property<string>("PlaceNo") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("åºä½ç¼å·"); b.Property<int>("PlaceStatus") .HasColumnType("int") .HasComment("åºä½ç¶æ;"); b.Property<string>("RedundantField1") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("æåº"); b.Property<int>("StockNumber") .HasColumnType("int") .HasComment("åºåæ°é"); b.Property<int>("StorageTypeNo") .HasColumnType("int") .HasComment("åºä½ç±»å"); b.Property<string>("SupplierCode") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ä¾åºåç¼å·"); b.HasKey("Id"); b.HasIndex("AreaCode"); b.HasIndex("ContainerNo"); b.HasIndex("MaterialName"); b.HasIndex("MaterialNo"); b.HasIndex("PlaceNo"); b.HasIndex("MaterialBatch", "SupplierCode"); b.ToTable("scms_wmsmaterialstocks", (string)null); b.HasComment("WMSç©æåºå表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsPlaces.WmsPlace", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<int>("Aisle") .HasColumnType("int") .HasComment("å··é"); b.Property<string>("AreaCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("æå¨åºåº"); b.Property<int>("ColumnNo") .HasColumnType("int") .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<int>("EmptyContainer") .HasColumnType("int") .HasComment("æ¯å¦ç©ºæ"); 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<int>("Islock") .HasColumnType("int") .HasComment("æ¯å¦éå®"); b.Property<DateTime?>("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property<Guid?>("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property<int>("LayerNo") .HasColumnType("int") .HasComment("å±"); b.Property<string>("PlaceNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ç¼å·"); b.Property<int>("PlaceStatus") .HasColumnType("int") .HasComment("è´§ä½ç¶æ"); b.Property<string>("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("RowNo") .HasColumnType("int") .HasComment("æ"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<int>("StorageTypeNo") .HasColumnType("int") .HasComment("è´§ä½ç±»å"); b.HasKey("Id"); b.HasIndex("AreaCode"); b.HasIndex("PlaceNo") .IsUnique(); b.HasIndex("PlaceStatus"); b.HasIndex("StorageTypeNo"); b.ToTable("scms_wmsplaces", (string)null); b.HasComment("åºä½è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsStores.WmsStore", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); 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>("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<string>("StoreCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ä»åºä»£ç "); b.Property<string>("StoreName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("ä»åºå称"); b.HasKey("Id"); b.HasIndex("StoreName"); b.ToTable("scms_wmsstores", (string)null); b.HasComment("ä»åºä¿¡æ¯è¡¨"); }); #pragma warning restore 612, 618 } } } HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250505135455_InitialCreate4.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,34 @@ using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace CMS.Plugin.HIAWms.MySQL.Migrations { public partial class InitialCreate4 : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "IX_scms_wmsmaterialstocks_MaterialNo", table: "scms_wmsmaterialstocks"); migrationBuilder.CreateIndex( name: "IX_scms_wmsmaterialstocks_MaterialNo", table: "scms_wmsmaterialstocks", column: "MaterialNo"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "IX_scms_wmsmaterialstocks_MaterialNo", table: "scms_wmsmaterialstocks"); migrationBuilder.CreateIndex( name: "IX_scms_wmsmaterialstocks_MaterialNo", table: "scms_wmsmaterialstocks", column: "MaterialNo", unique: true); } } } HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250505140345_InitialCreate5.Designer.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,1000 @@ // <auto-generated /> using System; using CMS.Plugin.HIAWms.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.HIAWms.MySQL.Migrations { [DbContext(typeof(CMSPluginDbContext))] [Migration("20250505140345_InitialCreate5")] partial class InitialCreate5 { 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.HIAWms.Domain.WmsAreas.WmsArea", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("AreaDesc") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("æè¿°"); b.Property<string>("AreaName") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åºåºå称"); b.Property<string>("AreaNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("åºåºç¼å·"); b.Property<int>("AreaStatus") .HasColumnType("int") .HasComment("åºåºç¶æ"); b.Property<int>("AreaType") .HasColumnType("int") .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>("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<string>("StoreCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ä»åºä»£ç "); b.Property<string>("StoreName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("ä»åºå称"); b.HasKey("Id"); b.HasIndex("AreaName"); b.ToTable("scms_wmsareas", (string)null); b.HasComment("åºåºè¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsContainers.WmsContainer", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property<string>("ContainerNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("æçç¼å·"); b.Property<int>("ContainerStatus") .HasColumnType("int") .HasComment("æçç¶æ"); b.Property<int>("ContainerType") .HasColumnType("int") .HasComment("æçç±»å"); 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<int?>("ExceptionNumber") .HasColumnType("int") .HasComment("å¼å¸¸æ°é"); 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<decimal?>("LimitHeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("éé«"); b.Property<decimal?>("LimitLength") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("éé¿"); b.Property<decimal?>("LimitWidth") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("é宽"); b.Property<int?>("MaterialNumber") .HasColumnType("int") .HasComment("ç©ææ°é"); b.Property<decimal?>("MaxWeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("è½½éä¸é"); b.Property<string>("RedundantField1") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(200) .HasColumnType("varchar(200)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<decimal?>("SpecHeight") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("é«åº¦"); b.Property<decimal?>("SpecLength") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("é¿åº¦"); b.Property<decimal?>("SpecWidth") .HasPrecision(18, 2) .HasColumnType("decimal(18,2)") .HasComment("宽度"); b.HasKey("Id"); b.HasIndex("ContainerNo") .IsUnique(); b.HasIndex("ContainerStatus"); b.HasIndex("ContainerType"); b.ToTable("scms_wmscontainers", (string)null); b.HasComment("æçä¿¡æ¯è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialInfos.WmsMaterialInfo", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<int?>("CheckStatus") .HasColumnType("int") .HasComment("æ£éªç¶æ(0:æªæ£éª,1:æ£éªéè¿,2:æ£éªä¸éè¿)"); 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>("MaterialBatch") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ç©ææ¹å·"); b.Property<string>("MaterialId") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æå¯ä¸ç "); b.Property<string>("MaterialModel") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("æºå/è§æ ¼"); b.Property<string>("MaterialName") .IsRequired() .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("ç©æå称"); b.Property<string>("MaterialNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ç©æ代å·"); b.Property<string>("RedundantField1") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("åä½å段1"); b.Property<string>("RedundantField2") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("åä½å段2"); b.Property<string>("RedundantField3") .HasMaxLength(255) .HasColumnType("varchar(255)") .HasComment("åä½å段3"); b.Property<string>("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("æåº"); b.Property<int?>("StockNumber") .HasColumnType("int") .HasComment("åºåæ°é"); b.Property<string>("SupplierCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ä¾åºåç¼å·"); b.HasKey("Id"); b.HasIndex("CheckStatus"); b.HasIndex("MaterialBatch"); b.HasIndex("MaterialId") .IsUnique(); b.HasIndex("MaterialName"); b.HasIndex("MaterialNo") .IsUnique(); b.HasIndex("SupplierCode"); b.ToTable("scms_wmsmaterialinfos", (string)null); b.HasComment("WMSç©æä¿¡æ¯è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterials.WmsMaterial", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("Certification") .HasMaxLength(128) .HasColumnType("varchar(128)") .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<string>("Factory") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç产工å"); b.Property<bool>("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property<bool?>("IsDisabled") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasComment("æ¯å¦ç¦ç¨"); b.Property<int>("IsMainBranch") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(2) .HasComment("æ¯å¦ä¸ºä¸»æ¯ç®¡"); b.Property<DateTime?>("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property<Guid?>("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property<decimal>("Length") .HasColumnType("decimal(18,2)") .HasComment("é¿åº¦ï¼åä½ï¼mï¼"); b.Property<string>("MaterialCode") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æç¼ç ï¼å¯ä¸æ è¯ï¼"); b.Property<string>("MaterialModel") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("åå·"); b.Property<string>("MaterialName") .IsRequired() .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("ç©æå称"); b.Property<string>("MaterialQuality") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("æè´¨ï¼å¦ï¼304ä¸éé¢ï¼"); b.Property<int>("MaterialType") .HasColumnType("int") .HasComment("ç©æç±»åï¼æ举å¼ï¼"); b.Property<decimal>("OuterDiameter") .HasColumnType("decimal(18,2)") .HasComment("å¤å¾ï¼åä½ï¼mmï¼"); b.Property<string>("PrimaryUnit") .HasMaxLength(20) .HasColumnType("varchar(20)") .HasComment("主åä½ï¼å¦ï¼kgãmã个ï¼"); b.Property<int>("PurchaseType") .HasColumnType("int") .HasComment("éè´ç±»åï¼æ举å¼ï¼"); b.Property<string>("RedundantField1") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("æåº"); b.Property<string>("Standard") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("è§æ ¼/æ åï¼å¦ï¼GB/T 8163-2018ï¼"); b.Property<decimal>("WallThickness") .HasColumnType("decimal(18,2)") .HasComment("å£åï¼åä½ï¼mmï¼"); b.HasKey("Id"); b.HasIndex("MaterialCode") .IsUnique(); b.HasIndex("MaterialName"); b.HasIndex("MaterialType"); b.HasIndex("PurchaseType"); b.ToTable("scms_wmsmaterials", (string)null); b.HasComment("ç©æåºç¡ä¿¡æ¯è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsMaterialStocks.WmsMaterialStock", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<string>("AreaCode") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("åºåç¼å·"); b.Property<string>("AreaName") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("åºåºå称"); b.Property<int?>("CheckStatus") .HasColumnType("int") .HasComment("æ£éªç¶æ(1:æªæ£éª,2:æ£éªéè¿,3:æ£éªä¸éè¿)"); b.Property<string>("ConcurrencyStamp") .IsConcurrencyToken() .HasMaxLength(40) .HasColumnType("varchar(40)") .HasColumnName("ConcurrencyStamp"); b.Property<string>("ContainerNo") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("容å¨ç¼å·"); b.Property<int>("ContainerStatus") .HasColumnType("int") .HasComment("容å¨ç¶æ"); b.Property<int>("ContainerType") .HasColumnType("int") .HasComment("容å¨ç±»å"); 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<int>("EmptyContainer") .HasColumnType("int") .HasComment("æ¯å¦ç©ºæ(2:å¦,1:æ¯)"); b.Property<string>("ExtraProperties") .HasColumnType("longtext") .HasColumnName("ExtraProperties"); b.Property<DateTime?>("InStockTime") .HasColumnType("datetime(6)") .HasComment("å ¥åºæ¶é´"); b.Property<bool>("IsDeleted") .ValueGeneratedOnAdd() .HasColumnType("tinyint(1)") .HasDefaultValue(false) .HasColumnName("IsDeleted"); b.Property<bool?>("IsDisabled") .HasColumnType("tinyint(1)") .HasComment("æ¯å¦ç¦ç¨"); b.Property<int>("IsLock") .HasColumnType("int") .HasComment("æ¯å¦éå®(2:æªéå®,1:å·²éå®)"); b.Property<DateTime?>("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property<Guid?>("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property<string>("MaterialBatch") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©ææ¹æ¬¡"); b.Property<string>("MaterialId") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æID"); b.Property<string>("MaterialModel") .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("æºå/è§æ ¼"); b.Property<string>("MaterialName") .IsRequired() .HasMaxLength(128) .HasColumnType("varchar(128)") .HasComment("ç©æå称"); b.Property<string>("MaterialNo") .IsRequired() .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ç©æç¼å·"); b.Property<string>("PlaceNo") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("åºä½ç¼å·"); b.Property<int>("PlaceStatus") .HasColumnType("int") .HasComment("åºä½ç¶æ;"); b.Property<string>("RedundantField1") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(500) .HasColumnType("varchar(500)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .ValueGeneratedOnAdd() .HasColumnType("int") .HasDefaultValue(0) .HasComment("æåº"); b.Property<int>("StockNumber") .HasColumnType("int") .HasComment("åºåæ°é"); b.Property<int>("StorageTypeNo") .HasColumnType("int") .HasComment("åºä½ç±»å"); b.Property<string>("SupplierCode") .HasMaxLength(64) .HasColumnType("varchar(64)") .HasComment("ä¾åºåç¼å·"); b.HasKey("Id"); b.HasIndex("AreaCode"); b.HasIndex("ContainerNo"); b.HasIndex("MaterialName"); b.HasIndex("PlaceNo"); b.HasIndex("MaterialBatch", "SupplierCode"); b.ToTable("scms_wmsmaterialstocks", (string)null); b.HasComment("WMSç©æåºå表"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsPlaces.WmsPlace", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); b.Property<int>("Aisle") .HasColumnType("int") .HasComment("å··é"); b.Property<string>("AreaCode") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("æå¨åºåº"); b.Property<int>("ColumnNo") .HasColumnType("int") .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<int>("EmptyContainer") .HasColumnType("int") .HasComment("æ¯å¦ç©ºæ"); 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<int>("Islock") .HasColumnType("int") .HasComment("æ¯å¦éå®"); b.Property<DateTime?>("LastModificationTime") .HasColumnType("datetime(6)") .HasColumnName("LastModificationTime"); b.Property<Guid?>("LastModifierId") .HasColumnType("char(36)") .HasColumnName("LastModifierId"); b.Property<int>("LayerNo") .HasColumnType("int") .HasComment("å±"); b.Property<string>("PlaceNo") .IsRequired() .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ç¼å·"); b.Property<int>("PlaceStatus") .HasColumnType("int") .HasComment("è´§ä½ç¶æ"); b.Property<string>("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("RowNo") .HasColumnType("int") .HasComment("æ"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<int>("StorageTypeNo") .HasColumnType("int") .HasComment("è´§ä½ç±»å"); b.HasKey("Id"); b.HasIndex("AreaCode"); b.HasIndex("PlaceNo") .IsUnique(); b.HasIndex("PlaceStatus"); b.HasIndex("StorageTypeNo"); b.ToTable("scms_wmsplaces", (string)null); b.HasComment("åºä½è¡¨"); }); modelBuilder.Entity("CMS.Plugin.HIAWms.Domain.WmsStores.WmsStore", b => { b.Property<Guid>("Id") .ValueGeneratedOnAdd() .HasColumnType("char(36)"); 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>("RedundantField1") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段1 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField2") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段2 - é¢çæ©å±ç¨é"); b.Property<string>("RedundantField3") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("åä½å段3 - é¢çæ©å±ç¨é"); b.Property<string>("Remark") .HasMaxLength(256) .HasColumnType("varchar(256)") .HasComment("å¤æ³¨"); b.Property<int>("Sort") .HasColumnType("int") .HasComment("æåº"); b.Property<string>("StoreCode") .HasMaxLength(50) .HasColumnType("varchar(50)") .HasComment("ä»åºä»£ç "); b.Property<string>("StoreName") .HasMaxLength(100) .HasColumnType("varchar(100)") .HasComment("ä»åºå称"); b.HasKey("Id"); b.HasIndex("StoreName"); b.ToTable("scms_wmsstores", (string)null); b.HasComment("ä»åºä¿¡æ¯è¡¨"); }); #pragma warning restore 612, 618 } } } HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250505140345_InitialCreate5.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,24 @@ using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace CMS.Plugin.HIAWms.MySQL.Migrations { public partial class InitialCreate5 : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropIndex( name: "IX_scms_wmsmaterialstocks_MaterialNo", table: "scms_wmsmaterialstocks"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.CreateIndex( name: "IX_scms_wmsmaterialstocks_MaterialNo", table: "scms_wmsmaterialstocks", column: "MaterialNo"); } } } HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/CMSPluginDbContextModelSnapshot.cs
@@ -757,9 +757,6 @@ b.HasIndex("MaterialName"); b.HasIndex("MaterialNo") .IsUnique(); b.HasIndex("PlaceNo"); b.HasIndex("MaterialBatch", "SupplierCode"); HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Scripts/UpdateMigrations.bat
@@ -1,5 +1,5 @@ cd ../ dotnet ef migrations add InitialCreate3 -c CMSPluginDbContext -o Migrations dotnet ef migrations add InitialCreate6 -c CMSPluginDbContext -o Migrations ::dotnet ef migrations add Update1 -c CMSPluginDbContext -o Migrations ::dotnet ef migrations add Update2 -c CMSPluginDbContext -o Migrations ::dotnet ef migrations add Update3 -c CMSPluginDbContext -o Migrations HIAWms/server/src/CMS.Plugin.HIAWms/Controller/WmsMaterialStockController.cs
@@ -108,6 +108,12 @@ { return _wmsmaterialstockAppService.DeleteAsync(id); } [HttpDelete] [Route("DeleteStock")] public virtual Task DeleteStockAsync(Guid id) { return _wmsmaterialstockAppService.DeleteAsync(id); } /// <summary> /// æ¹éå é¤wmsmaterialstock. HIAWms/web/src/widgets/WmsMaterialStock/Controllers/WmsMaterialStock.ts
@@ -126,9 +126,11 @@ ConfirmBox( `æ¯å¦å é¤${names.length ? names.join(',') : c.row.name}` ).then(async () => { const ids = selection.value.map((item: { id: string }) => item.id) await wmsMaterialStock.deleteWmsMaterialStocks( ids.length ? ids : [c.row.id] const materialNo = selection.value.map( (item: { materialNo: string }) => item.materialNo ) await wmsMaterialStock.deleteWmsMaterialStocksByMaterialNo( materialNo ? materialNo : [c.row.materialNo] ) ElMessage.success('å é¤æå') tableRef.value.getList() HIAWms/web/src/widgets/WmsMaterialStock/Controllers/WmsMaterialStockDrawer.tsx
@@ -300,10 +300,11 @@ updateFormAreaOptions('areaCode', areaList) if (current.value) { const res = await wmsMaterialStockDrawer.getWmsMaterialStockDetail( console.log(current.value.materialNo) const data = await wmsMaterialStockDrawer.getWmsMaterialStockDetail( current.value ) const res = data?.items[0] formData.value = { materialNo: res.materialNo, materialName: res.materialName, HIAWms/web/src/widgets/WmsMaterialStock/Models/Service/WmsMaterialStock.ts
@@ -22,6 +22,18 @@ } /** * æ¹éå é¤ * @returns */ export const deleteWmsMaterialStocksMaterial = (materialNo: string[]) => { return request({ data: materialNo, url: '/api/v1/HIAWms/wmsMaterialStock', method: 'delete', }) } /** * å é * @returns */ HIAWms/web/src/widgets/WmsMaterialStock/Models/Service/WmsMaterialStockDrawer.ts
@@ -13,8 +13,8 @@ * è·å详æ * @returns */ export const getWmsMaterialStock = (id: string) => { return request.get(`/api/v1/HIAWms/wmsMaterialStock/${id}`) export const getWmsMaterialStock = (materialNo: string) => { return request.get(`/api/v1/HIAWms/wmsMaterialStock?materialNo=${materialNo}`) } /** HIAWms/web/src/widgets/WmsMaterialStock/Models/WmsMaterialStock.ts
@@ -3,6 +3,7 @@ deleteWmsMaterialStocks, addWmsMaterialStock, cloneData, deleteWmsMaterialStocksMaterial, } from './Service/WmsMaterialStock' export class WmsMaterialStock extends Base<{ [key: string]: any }> { @@ -20,6 +21,14 @@ async deleteWmsMaterialStocks(ids: string[]) { return deleteWmsMaterialStocks(ids) } /** * å é¤éè¿ç©æç¼å· * @param id * @returns */ async deleteWmsMaterialStocksByMaterialNo(materialNo: string[]) { return deleteWmsMaterialStocksMaterial(materialNo) } /** * æ·»å æ°æ® HIAWms/web/src/widgets/WmsMaterialStock/Models/WmsMaterialStockDrawer.ts
@@ -32,7 +32,7 @@ /** * è·å详æ */ async getWmsMaterialStockDetail(current: any, id?: string) { return getWmsMaterialStock(id || current?.id) async getWmsMaterialStockDetail(current: any, materialNo?: string) { return getWmsMaterialStock(current?.materialNo) } }
