using System;
using System.Collections.Generic;
using System.Text;
using Model.ModelDto.BllCheckDto;
using SqlSugar;
using WMS.Entity.BllCheckEntity;
using WMS.Entity.Context;
using WMS.Entity.DataEntity;
using WMS.Entity.SysEntity;
using WMS.IBLL.IPdaServer;

namespace WMS.BLL.BllPdaServer
{
    public class PdaCrServer : IPdaCrServer
    {
        private static readonly SqlSugarScope Db = DataContext.Db;


        #region 盘点

        //获取盘库单正在执行单号
        public List<string> GetStockCheckNoList(string palletNo)
        {
            try
            {
                List<string> list;
                if (!string.IsNullOrWhiteSpace(palletNo))
                {
                    list = Db.Queryable<BllStockCheckDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo && m.Status == 2).Select(m => m.CRNo).Distinct().ToList();

                }
                else
                {
                    list = Db.Queryable<BllStockCheck>().Where(m => m.IsDel == "0" && m.Status == 1).Select(m => m.CRNo)
                        .Distinct().ToList();
                }

                return list;

            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        //获取盘点明细物料批次信息
        public List<StockCheckDetailDto> GetStockCheckDetailList(string crNo, string palletNo)
        {
            try
            {
                if (string.IsNullOrWhiteSpace(crNo))
                {
                    throw new Exception("盘点单据不能为空");
                }

                var list = Db.Queryable<BllStockCheckDetail>().Where(m => m.IsDel == "0" && m.CRNo == crNo);

                if (!string.IsNullOrWhiteSpace(palletNo))
                {
                    list = list.Where(m => m.PalletNo == palletNo);
                }

                var data = list.GroupBy(m => new { m.SkuNo, m.SkuName, m.LotNo }).Select(m => new StockCheckDetailDto()
                {
                    SkuNo = m.SkuNo,
                    SkuName = m.SkuName,
                    LotNo = m.LotNo
                }).ToList();

                return data;

            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        //获取要盘点的箱码信息（盘点记录中数据）
        public List<StockCheckLogDto> GetStockCheckLogList(string crNo, string crDetail, string palletNo, string boxNo)
        {
            try
            {
                #region 判断
                if (string.IsNullOrWhiteSpace(crNo))
                {
                    throw new Exception("盘点单据不能为空");
                }
                if (string.IsNullOrWhiteSpace(crDetail))
                {
                    throw new Exception("物料批次不能为空");
                }
                if (string.IsNullOrWhiteSpace(palletNo))
                {
                    throw new Exception("托盘码不能为空");
                }
                #endregion

                var detail = crDetail.Split("-");
                var sku = detail[0];
                var lotNo = detail.Length == 3 ? detail[1] + "-" + detail[2] : detail[1];
                var list = Db.Queryable<BllStockCheckLog>().Where(m => m.IsDel == "0" && m.CRNo == crNo);
                //var deList= Db.Queryable<BllStockCheckDetail>().Where(m => m.IsDel == "0" && m.SkuNo == sku && m.LotNo == lotNo && m.PalletNo == palletNo);
                //if (deList.Count() == 0)
                //{
                //    throw new Exception("未查询到托盘上的盘点物料批次信息");
                //}

                list = list.Where(m => m.SkuNo == sku && m.LotNo == lotNo && m.PalletNo == palletNo);
                if (!string.IsNullOrWhiteSpace(boxNo))
                {
                    list = list.Where(m => m.BoxNo == boxNo);
                }

                var data = list.Select(m => new StockCheckLogDto()
                {
                    BoxNo = m.BoxNo,
                    BoxNo3 = m.BoxNo3,
                    SkuNo = m.SkuNo,
                    SkuName = m.SkuName,
                    LotNo = m.LotNo,
                    Qty = m.Qty,
                    CheckResult = m.CheckResult,

                }).ToList();
                return data;
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        /// <summary>
        /// 盘点库存
        /// </summary>
        /// <param name="crNo">单据号</param>
        /// <param name="crDetail">物料批次</param>
        /// <param name="palletNo">托盘码</param>
        /// <param name="qty">数量</param>
        /// <param name="sQty">实际数量</param>
        /// <param name="userId"></param>
        public void CrSetCheck(string crNo, string crDetail, string palletNo, int? qty, int sQty, int userId)
        {
            try
            {
                #region 判断

                if (string.IsNullOrWhiteSpace(crNo))
                {
                    throw new Exception("盘点单据不能为空");
                }
                if (string.IsNullOrWhiteSpace(crDetail))
                {
                    throw new Exception("物料批次不能为空");
                }
                if (string.IsNullOrWhiteSpace(palletNo))
                {
                    throw new Exception("托盘码不能为空");
                }

                #endregion

                //箱码为空  是整托要盘点的都正常
                //物料-批次
                var detail = crDetail.Split("-");
                //物料号
                var sku = detail[0];
                //批次号
                var lotNo = detail.Length == 3 ? detail[1] + "-" + detail[2] : detail[1];
                //盘点明细
                var checkDetail = Db.Queryable<BllStockCheckDetail>().First(m =>
                    m.IsDel == "0" && m.CRNo == crNo && m.PalletNo == palletNo && m.SkuNo == sku && m.LotNo == lotNo);
                //判断是否存在盘点明细
                if (checkDetail == null)
                {
                    throw new Exception("未查询到未盘点的盘点明细信息");
                }
                //盘点记录
                var checkLog = Db.Queryable<BllStockCheckLog>().First(m =>
                    m.IsDel == "0" && m.CRNo == crNo && m.PalletNo == palletNo && m.SkuNo == sku && m.LotNo == lotNo && m.CheckResult == null);
                //时间
                var time = DateTime.Now;

                #region 包装信息
                var package = Db.Queryable<SysPackag>().Where(m => m.IsDel == "0");
                var skuInfo = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == sku);
                var pack = package.First(m => m.IsDel == "0" && m.PackagNo == skuInfo.PackagNo);
                var pNum = 0;//托盘物品数量 
                if (pack.L5Num.HasValue)
                {
                    pNum = (int)pack.L5Num;
                }
                else if (pack.L4Num.HasValue)
                {
                    pNum = (int)pack.L4Num;
                }
                else if (pack.L3Num.HasValue)
                {
                    pNum = (int)pack.L3Num;
                }
                else if (pack.L2Num.HasValue)
                {
                    pNum = (int)pack.L2Num;
                }
                else if (pack.L1Num.HasValue)
                {
                    pNum = (int)pack.L1Num;
                }
                if (pNum == 0)
                {
                    throw new Exception($"绑定失败，{sku}物品包装未找到！");
                }

                if (sQty > pNum)
                {
                    throw new Exception($"确认失败，托盘{palletNo}实际数量大于物品包装数量！请取出多余数量进行入库操作！");
                }
                #endregion

                //判断盘点记录表是否为空
                if (checkLog != null)
                {
                    checkLog.RealQty = sQty; //记录 实际数量
                    checkLog.CheckResult = sQty == qty ? 0 : sQty < qty ? 1 : 2; //记录 盘点状态 0：正常、1：盘亏、2：盘盈
                    checkLog.CheckDate = time; //记录 盘点时间
                    checkLog.CheckUserId = userId; //记录 盘点人

                    checkDetail.RealQty = sQty; //明细 实际数量 
                    checkDetail.CheckResult = sQty == qty ? 0 : sQty < qty ? 1 : 2; //明细 盘点状态 0：正常、1：盘亏、2：盘盈
                    //checkDetail.Status = sQty == qty ? 4 : 3; //明细 状态 3：已盘点
                    checkDetail.Status = 3; //明细 状态 3：已盘点

                    Db.Updateable(checkDetail).ExecuteCommand(); //修改盘点明细
                    Db.Updateable(checkLog).ExecuteCommand(); //修改盘点记录
                }

                #region 盘亏 盘盈无用代码
                ////盘亏
                //else if (sQty < qty)
                //{
                //    if (checkLog.Count() == 0)
                //    {
                //        throw new Exception("未查询到托盘信息");
                //    }

                //    var list = checkLog.ToList();
                //    foreach (var l in list)
                //    {
                //        l.RealQty = sQty; //实际数量
                //        l.CheckResult = 1; //盘点状态 1：盘亏
                //        l.CheckDate = time; //盘点实际
                //        l.CheckUserId = userId; //盘点人
                //    }

                //    //盘点明细实际数量
                //    checkDetail.RealQty = 0;

                //    checkDetail.RealQty = sQty;
                //    Db.Updateable(checkDetail).ExecuteCommand(); //修改盘点明细
                //    Db.Updateable(list).ExecuteCommand(); //修改盘点记录
                //}
                ////盘盈
                //else if (sQty> qty)
                //{
                //    var list = checkLog.ToList();
                //    foreach (var l in list)
                //    {
                //        l.RealQty = sQty; //实际数量
                //        l.CheckResult = 2; //盘点状态 2：盘盈
                //        l.CheckDate = time; //盘点实际
                //        l.CheckUserId = userId; //盘点人
                //    }
                //    checkDetail.RealQty = sQty;
                //    Db.Updateable(checkDetail).ExecuteCommand(); //修改盘点明细
                //    Db.Updateable(list).ExecuteCommand(); //修改盘点记录;
                //}
                //else
                //{
                //    throw new Exception("实际数量为0，请核实！");
                //}
                #endregion


                //获取该盘点单 盘点明细中未变更为已盘点的信息条数
                var checkDetailCount = Db.Queryable<BllStockCheckDetail>().Where(m => m.IsDel == "0" && m.CRNo == crNo && m.Status != 3 && m.CheckResult == null && m.RealQty == null).ToList();
                //判断条数是否为0
                if (checkDetailCount.Count <= 0)
                {
                    //获取盘点单信息
                    var check = Db.Queryable<BllStockCheck>().First(m => m.CRNo == crNo && m.IsDel == "0");
                    check.Status = 2;
                    Db.Updateable(check).ExecuteCommand();
                }


                Db.CommitTran();
            }
            catch (Exception e)
            {
                Db.RollbackTran();
                throw new Exception(e.Message);
            }
        }

        #endregion

        #region 库存查询

        /// <summary>
        /// pda库存查询
        /// </summary>
        /// <param name="locatNo">储位编号</param>
        /// <param name="palletNo">托盘号</param>
        /// <param name="skuName">物料名称</param>
        /// <returns></returns>
        public List<DataStockDetail> GetStockQueryList(string locatNo, string palletNo, string skuName)
        {
            string str = "select LocatNo,PalletNo,SkuName,Standard,LotNo,Qty,LockQty,FrozenQty,InspectQty from DataStockDetail Where IsDel = @isdel";
            //判断储位编号是否为空
            if (!string.IsNullOrEmpty(locatNo))
            {
                str += " and LocatNo like @locatno";
            }
            //判断托盘号是否为空
            if (!string.IsNullOrEmpty(palletNo))
            {
                str += " and PalletNo like @palletno";
            }
            //判断物料名称是否为空
            if (!string.IsNullOrEmpty(skuName))
            {
                str += " and SkuName like @skuname";
            }
            //排序
            str += " order by LotNo,LocatNo,PalletNo";
            List<DataStockDetail> stockList = Db.Ado.SqlQuery<DataStockDetail>(str, new
            {
                isdel = "0", //是否删除
                locatno = "%" + locatNo + "%", //储位编号
                palletno = "%" + palletNo + "%", //托盘号
                skuname = "%" + skuName + "%" //物料名称
            });
            return stockList;
        }

        #endregion

    }
}