using Quartz;
using SqlSugar;
using SqlSugar.Extensions;
using WIDESEA_Common.StockEnum;
using WIDESEA_Model.Models;
using WIDESEA_Model.Models.Basic;

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;
        }
    }
}