using System;
using System.Collections.Generic;
using System.Linq;

using HH.WCS.Mobox3.DSZSH.models;
using HH.WCS.Mobox3.DSZSH.util;

using Newtonsoft.Json;

using SqlSugar;

namespace HH.WCS.Mobox3.DSZSH.wms {
    /// <summary>
    /// 货位帮助类(包含货位-容器关系的处理) 
    /// </summary>
    public class LocationHelper
    {
        private static Dictionary<string, TN_Location> _locationDict = null;

        static LocationHelper()
        {
            try
            {
                //初始化Location加入到字典缓存
                _locationDict = new Dictionary<string, TN_Location>();
                var list = GetAllLocList();
                if (list.Count > 0)
                {
                    list.ForEach(a =>
                    {
                        if (!_locationDict.ContainsKey(a.S_CODE))
                        {
                            _locationDict.Add(a.S_CODE, a);
                        }
                    });
                }
                //初始化LocationExt加入到集合缓存
                //LocationExts = new Dictionary<string, LocationExt>();
                //var exts = GetAllLocExtList();
                //if (exts.Count > 0) {
                //    exts.ForEach(a => {
                //        LocationExts.Add($"{a.S_LOC_CODE.Trim()}_{a.S_PICKUP_POINT.Trim()}", a);
                //    });
                //}
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }

        /// <summary>
        /// 获取所有货位信息
        /// </summary>
        /// <returns></returns>
        internal static List<TN_Location> GetAllLocList()
        {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<TN_Location>().ToList();
        }


        internal static TN_Location GetLocation(string loc)
        {
            if (_locationDict.Keys.Contains(loc))
            {
                return _locationDict[loc.Trim()];
            }
            return null;
        }

        //public static bool IsStartLocFound(string startLocCode, ref )

        /// <summary>
        /// 获取货位站点信息
        /// </summary>
        /// <param name="loc"></param>
        /// <param name="isEmpty">是否属于人工空托区到空托缓存库区</param>
        /// <returns></returns>
        internal static string GetAgvSite(string loc, bool isEmpty = false) {
            var site = "0";
            if (_locationDict.Keys.Contains(loc.Trim()) && !isEmpty) {
                var Location = _locationDict[loc.Trim()];
                site = Location.S_AGV_SITE;
            }
            else {
                var Location = GetLoc(loc.Trim());
                if (Location != null) {
                    site = Location.S_AGV_SITE;

                    if (isEmpty) {
                        if (Location.N_CURRENT_NUM == 0) {
                            site = Location.S_AGV_SITE;
                        }
                    }
                }
            }
            return site;
        }

        internal static TN_Location GetLoc(string code) {
            var db = new SqlHelper<object>().GetInstance();
            return db.Queryable<TN_Location>().Where(a => a.S_CODE.Trim() == code).First();
        }

        
    }
}