using HslCommunication;
using MailKit.Search;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Common.WareHouseEnum;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Helper;
using WIDESEA_DTO.SquareCabin;
using WIDESEA_IWMsInfoServices;
using WIDESEA_Model.Models;
using static WIDESEA_DTO.SquareCabin.TowcsDto;

namespace WIDESEA_WMsInfoServices
{
    public class InventoryInfoService : ServiceBase<Dt_InventoryInfo, IRepository<Dt_InventoryInfo>>, IInventoryInfoService
    {
        public InventoryInfoService(IRepository<Dt_InventoryInfo> BaseDal) : base(BaseDal)
        {
        }
        public IRepository<Dt_InventoryInfo> Repository => BaseDal;


        /// <summary>
        /// 获取库存
        /// </summary>
        /// <returns></returns>
        public WebResponseContent GetInventory()
        {
            WebResponseContent content = new WebResponseContent();
            try
            {
                List<object> lists = new List<object>();
                #region 冷冻库
                string WareCodeLD = WarehouseEnum.冷冻库.ObjToInt().ToString("000");
                var LDQty = Convert.ToInt32(BaseDal.QueryData(x => x.WarehouseCode == WareCodeLD).Sum(x => x.StockQuantity));
                lists.Add(new
                {
                    name = WarehouseEnum.冷冻库.ObjToString(),
                    count = LDQty
                });
                #endregion
                #region 麻精库
                string WareCodeMJ = WarehouseEnum.麻精库.ObjToInt().ToString("000");
                var MJQty = Convert.ToInt32(BaseDal.QueryData(x => x.WarehouseCode == WareCodeMJ).Sum(x => x.StockQuantity));
                lists.Add(new
                {
                    name = WarehouseEnum.麻精库.ObjToString(),
                    count = MJQty
                });
                #endregion
                #region 大件库
                string WareCodeDJ = WarehouseEnum.大件库.ObjToInt().ToString("000");
                var DJQty = Convert.ToInt32(BaseDal.QueryData(x => x.WarehouseCode == WareCodeDJ).Sum(x => x.StockQuantity));
                lists.Add(new
                {
                    name = WarehouseEnum.大件库.ObjToString(),
                    count = DJQty
                });
                #endregion
                content.OK(data: lists);
            }
            catch (Exception ex)
            {
                content.Error(ex.Message);
            }
            return content;
        }



    }
}