| | |
| | |  |
| | | 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) |