//using SqlSugar.Extensions;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
using WIDESEA_DTO.Stock;
using WIDESEA_IStockRepository;
using WIDESEA_IStockService;
using WIDESEA_Model.Models;

namespace WIDESEA_StockService
{
    public partial class StockInfoDetailService : ServiceBase<Dt_StockInfoDetail, IStockInfoDetailRepository>, IStockInfoDetailService
    {
        public bool ExistSerialNumber(string SerialNumber)
        {
            return BaseDal.QueryFirst(x => x.SerialNumber == SerialNumber) != null;
        }

        public bool ExistSerialNumbers(List<string> SerialNumbers)
        {
            return BaseDal.QueryFirst(x => SerialNumbers.Contains(x.SerialNumber)) != null;
        }
        /// <summary>
        /// 根据批次号和单据号获取库存明细信息
        /// </summary>
        /// <param name="OrderNo">订单号</param>
        /// <param name="BatchNo">批次号</param>
        /// <returns></returns>
        public Dt_StockInfoDetail? Get_StockInfoDetail(string OrderNo, string BatchNo = null)
        {
            Dt_StockInfoDetail? stockInfoDetail = null;
            if (BatchNo != null)
            {
                stockInfoDetail = BaseDal.QueryData(x => x.OrderNo == OrderNo && x.BatchNo.Contains(BatchNo) && (x.Status == StockStatusEmun.入库中.ObjToInt() || x.Status == StockStatusEmun.已入库.ObjToInt())).OrderByDescending(x => x.ModifyDate).FirstOrDefault();
            }
            else
            {
                stockInfoDetail = BaseDal.QueryData(x => x.OrderNo == OrderNo && (x.Status == StockStatusEmun.入库中.ObjToInt() || x.Status == StockStatusEmun.已入库.ObjToInt())).OrderByDescending(x => x.ModifyDate).FirstOrDefault();
            }
            return stockInfoDetail;
        }
        /// <summary>
        /// 获取指定库存
        /// </summary>
        /// <param name="stockSelectViews"></param>
        /// <returns></returns>
        public List<Dt_StockInfoDetail> GetStockInfosByBatchNoCodes(List<StockSelectViewDTO> stockSelectViews)
        {
            List<Dt_StockInfoDetail> stockInfoDetails = new List<Dt_StockInfoDetail>();
            foreach (var item in stockSelectViews)
            {
                var stockSelectView = BaseDal.QueryData(x => x.BatchNo == item.BatchNo && x.MaterielCode == item.MaterielCode);
                if (stockSelectView.Count > 0) stockInfoDetails.AddRange(stockSelectView);
            }
            return stockInfoDetails;
        }
        public List<Dt_StockInfoDetail> GetStockInfosByBatchNoCodes()
        {
            List<Dt_StockInfoDetail> stockInfoDetails = new List<Dt_StockInfoDetail>();

            return stockInfoDetails;
        }

        public List<Dt_StockInfoDetail> Get_StockInfoDetails(string OrderNo, string BatchNo = null)
        {
            List<Dt_StockInfoDetail> stockInfoDetails = null;
            if (BatchNo != null)
            {
                stockInfoDetails = BaseDal.QueryData(x => x.OrderNo == OrderNo && x.BatchNo == BatchNo && (x.Status == StockStatusEmun.入库中.ObjToInt() || x.Status == StockStatusEmun.已入库.ObjToInt()));
            }
            else
            {
                stockInfoDetails = BaseDal.QueryData(x => x.OrderNo == OrderNo && (x.Status == StockStatusEmun.入库中.ObjToInt() || x.Status == StockStatusEmun.已入库.ObjToInt()));
            }
            return stockInfoDetails;
        }
    }
}