From 18d1f45193e34e00fc1b6f65b8596ddb29c5267d Mon Sep 17 00:00:00 2001 From: dengjunjie <dengjunjie@hnkhzn.com> Date: 星期二, 24 十二月 2024 15:32:43 +0800 Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/MeiRuiAn/HuaiAn --- 代码管理/WCS/WIDESEAWCS_Server/WIDESEAWCS_Server/HostedService/WarehouseHostedService.cs | 36 +++++++++++++++++++++++++++++++++++- 1 files changed, 35 insertions(+), 1 deletions(-) diff --git "a/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_Server/HostedService/WarehouseHostedService.cs" "b/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_Server/HostedService/WarehouseHostedService.cs" index e6305ee..390d476 100644 --- "a/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_Server/HostedService/WarehouseHostedService.cs" +++ "b/\344\273\243\347\240\201\347\256\241\347\220\206/WCS/WIDESEAWCS_Server/WIDESEAWCS_Server/HostedService/WarehouseHostedService.cs" @@ -1,11 +1,45 @@ 锘� +using SqlSugar; +using WIDESEAWCS_Core.Helper; +using WIDESEAWCS_Core.Seed; +using WIDESEAWCS_DTO.BasicInfo; +using WIDESEAWCS_Model.Models; +using ICacheService = WIDESEAWCS_Core.Caches.ICacheService; + namespace WIDESEAWCS_Server.HostedService { public class WarehouseHostedService : IHostedService { + private readonly ICacheService _cacheService; + private readonly DBContext _dbContext; + + public WarehouseHostedService(ICacheService cacheService, DBContext dbContext) + { + _cacheService = cacheService; + _dbContext = dbContext; + } + public Task StartAsync(CancellationToken cancellationToken) { - throw new NotImplementedException(); + string connStr = AppSettings.GetValue("WMSConnectionStrings"); + if (string.IsNullOrEmpty(connStr)) + { + throw new Exception("WMS杩炴帴瀛楃涓查敊璇�"); + } + SqlSugarClient sugarClient = new(new ConnectionConfig() + { + ConnectionString = connStr, + IsAutoCloseConnection = true, + DbType = DbType.SqlServer + }); + + List<Dt_Warehouse> warehouses = sugarClient.Queryable<Dt_Warehouse>().ToList(); + + _dbContext.Db.Deleteable<Dt_Warehouse>().ExecuteCommand(); + + _dbContext.Db.Insertable(warehouses).ExecuteCommand(); + + return Task.CompletedTask; } public Task StopAsync(CancellationToken cancellationToken) -- Gitblit v1.9.3