using Quartz;
|
using SqlSugar;
|
using SqlSugar.Extensions;
|
using WIDESEA_Common.StockEnum;
|
using WIDESEA_Model.Models;
|
using WIDESEA_Model.Models.Basic;
|
using WIDESEA_WMSServer.Jobs;
|
|
namespace WIDESEA_WMSServer
|
{
|
[DisallowConcurrentExecution]
|
public class InventoryLockJob : IJob
|
{
|
private readonly ISqlSugarClient _db;
|
public InventoryLockJob(ISqlSugarClient db)
|
{
|
_db = db;
|
}
|
public Task Execute(IJobExecutionContext context)
|
{
|
string updateStatusSql = @"
|
UPDATE Dt_StockInfoDetail
|
SET Status = 98
|
WHERE ValidDate IS NOT NULL AND ValidDate < GETDATE()
|
AND Status = 6";
|
int updateStatusResult = _db.Ado.ExecuteCommand(updateStatusSql);
|
|
return Task.CompletedTask;
|
}
|
}
|
}
|
