using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
using SqlSugar;
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;
using WIDESEA_SystemRepository;

namespace WIDESEA_SystemService
{
    public class Sys_VehicleService : ServiceBase<Sys_Vehicle, ISys_VehicleRepository>, ISys_VehicleService
    {
       
        public ISys_VehicleRepository Repository => BaseDal;

        public IDt_palletRepository _Repository;
        IDt_palletRepository ISys_VehicleService._Repository => _Repository;




        public Sys_VehicleService(ISys_VehicleRepository BaseDal, IDt_palletRepository dt_Pallet) : base(BaseDal)
        {
            _Repository = dt_Pallet;
        }

        public WebResponseContent GetCachedata()
        {
            try
            {
                List<string> traycode_materiel = BaseDal.QueryData().Select(x => x.Vehiclename).ToList();
                if (traycode_materiel != null)
                {
                    return WebResponseContent.Instance.OK(data: traycode_materiel);
                }
                else
                {
                    return WebResponseContent.Instance.OK(data: null);
                }

            }
            catch (Exception ex)
            {
                return WebResponseContent.Instance.OK(data: null);
                throw;
            }

        }

        /*public virtual PageGridData<Sys_Vehicle> GetPageData(PageDataOptions options)
        {
            string wheres = options.ValidatePageOptions(TProperties);
            //获取排序字段
            Dictionary<string, OrderByType> orderbyDic = options.GetPageDataSort(TProperties);

            PageGridData<Sys_Vehicle> pageGridData = new PageGridData<Sys_Vehicle>();
            pageGridData = BaseDal.QueryPage(wheres, options.Page, options.Rows, orderbyDic);
            foreach (var item in pageGridData.Rows)
            {
                item.Vehicletraycoid=_Repository.QueryFirst(x => x.palletnumber == int.Parse(item.Vehicletraycoid)).palletname.Trim();
            }
            

            return pageGridData;
        }*/



    }
}