using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.BaseServices;
using WIDESEA_ISystemRepository;
using WIDESEA_ISystemService;
using WIDESEA_Model.Models.System;

namespace WIDESEA_SystemService
{
    public class Sys_TraycodeinfoService : ServiceBase<Dt_traycodeinfo, ISys_TraycodeinfoRepository>, ISys_TraycodeinfoService
    {
        public Sys_TraycodeinfoService(ISys_TraycodeinfoRepository BaseDal) : base(BaseDal)
        {
        }

        public ISys_TraycodeinfoRepository Repository => BaseDal;


        public WebResponseContent SetCacheList()
        {
            var data = BaseDal.QueryData().OrderBy(x=>x.traycode_name).Select(x => new { x.traycode_name, x.traycode_id }).Distinct().ToList();
            return WebResponseContent.Instance.OK(data: data);
        }

        


        public Dt_traycodeinfo? GetInCacheList(string traycode_code)
        {
             Dt_traycodeinfo _Traycodeinfo= BaseDal.QueryData(x=>x.traycode_code== traycode_code && x.traycode_staute==1).FirstOrDefault();
            return _Traycodeinfo;
        }
    }
}