using Model.ModelVm.DataVm;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WMS.DAL;
using WMS.Entity.Context;
using WMS.Entity.DataEntity;
using WMS.Entity.SysEntity;
using WMS.IBLL.IDataServer;

namespace WMS.BLL.DataServer
{
    public class StockInfoServer : DbHelper<DataStockInfo>, IStockInfoServer
    {
        private static readonly SqlSugarScope Db = DataContext.Db;

        public StockInfoServer() : base(Db)
        {
        }

        /// <summary>
        /// 每日凌晨自动执行当前方法
        /// 添加库存总表到库存信息
        /// </summary>
        /// <returns></returns>
        public string ByDayInsertStock()
        {
            try
            {

                string arr = "";
                //获取今日时间与昨日时间
                var data1 = DateTime.Now.ToString("yyyy-MM-dd");
                var data2 = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
                //获取当前库存总表信息
                var stock = Db.Queryable<DataStock>().Where(a => a.IsDel == "0").ToList();
                //以及前一天的库存信息
                var info = Db.Queryable<DataStockInfo>().Where(a => a.IsDel == "0" && a.CreateTime.Year == DateTime.Parse(data2).Year && a.CreateTime.Month == DateTime.Parse(data2).Month && a.CreateTime.Day == DateTime.Parse(data2).Day).ToList();
                //获取物料信息
                var sku = Db.Queryable<SysMaterials>().Where(a => a.IsDel == "0").ToList();
                //获取单位信息
                var unit = Db.Queryable<SysUnit>().Where(a => a.IsDel == "0").ToList();
                Db.BeginTran();
                List<DataStockInfo> list = new List<DataStockInfo>();
                //验证是否存在前一天的库存信息
                if (info.Count <= 0)
                {
                    //根据库存总表添加对应库存信息
                    foreach (var item in stock)
                    {

                        //获取对应单位信息
                        var unitNo = sku.Where(a => a.IsDel == "0" && a.SkuNo == item.SkuNo).Select(a => a.UnitNo).ToString();
                        var unitName = unit.Where(a => a.IsDel == "0" && a.UnitNo == unitNo).Select(a => a.UnitName).ToString();

                        var Folded = item.Standard.Split("*");
                        int count = 0;
                        var sum = 0m;
                        //获取对应折件数量
                        foreach (var item1 in Folded)
                        {
                            if (count == 0)
                            {
                                if (item1.Contains(unitName))
                                {
                                    count = 1;
                                    sum = Convert.ToDecimal(item1);
                                }
                            }
                            if (count == 1)
                            {
                                sum *= Convert.ToDecimal(item1);
                            }
                        }
                        DataStockInfo data = new DataStockInfo()
                        {
                            SkuNo = item.SkuNo,
                            SkuName = item.SkuName,
                            Standard = item.Standard,
                            Unit = unitName,
                            LastMonthQty = 0, //上月结存-库存数量
                            LastMonthFoldedQty = 0, //上月结存-折件数量
                            ArrDayQty = item.Qty, //入库数量-当日数量
                            ArrDayFoldedQty = item.Qty / sum, //入库数量-当日折件数量
                            ArrMonthQty = item.Qty, //入库数量-当月数量
                            ArrMonthFoldedQty = item.Qty / sum, //入库数量-当月折件数量
                            ArrYearQty = item.Qty, //入库数量-本年数量
                            ArrYearFoldedQty = item.Qty / sum, //入库数量-本年折件数量
                            SoDayQty = 0, //出库数量-当日数量
                            SoDayFoldedQty = 0, //出库数量-当日折件数量
                            SoMonthQty = 0, //出库数量-当月数量
                            SoMonthFoldedQty = 0, //出库数量-当月折件数量
                            SoYearQty = 0, //出库数量-本年数量
                            SoYearFoldedQty = 0, //出库数量-本年折件数量
                            MonthQty = item.Qty, //当月数量-累计数量 
                            MonthFoldedQty = item.Qty / sum, //当月数量-累计折件数量 
                            DepositQty = 0,
                            Qty = item.Qty,
                            SecurityQty = sku[0].LowInventory, //暂用低库存
                            Situation = item.Qty < sku[0].LowInventory ? "1" : "0",
                            IsDel = "0",
                            CreateTime = DateTime.Now,
                            CreateUser = 0,
                            UpdateTime = null,
                            UpdateUser = null,

                        };


                        list.Add(data);
                    }
                }
                else
                {
                    //验证今日是一号还是其它
                    if (DateTime.Parse(data2).Day == 1)
                    {
                        //验证月份是否为1月
                        if (DateTime.Parse(data2).Month == 1)
                        {
                            //1月
                            //1月需要重新计算所有
                            foreach (var item in info)
                            {
                                var Folded = item.Standard.Split("*");
                                int count = 0;
                                var sum = 0m;
                                //获取对应折件数量
                                foreach (var item1 in Folded)
                                {
                                    if (count == 0)
                                    {
                                        if (item1.Contains(item.Unit))
                                        {
                                            count = 1;
                                            sum = Convert.ToDecimal(item1);
                                        }
                                    }
                                    if (count == 1)
                                    {
                                        sum *= Convert.ToDecimal(item1);
                                    }
                                }

                                DataStockInfo data = new DataStockInfo()
                                {
                                    SkuNo = item.SkuNo,
                                    SkuName = item.SkuName,
                                    Standard = item.Standard,
                                    Unit = item.Unit,

                                    LastMonthQty = item.Qty, //上月结存-库存数量
                                    LastMonthFoldedQty = item.Qty / sum, //上月结存-折件数量
                                    ArrDayQty = 0, //入库数量-当日数量
                                    ArrDayFoldedQty = 0, //入库数量-当日折件数量
                                    ArrMonthQty = 0, //入库数量-当月数量
                                    ArrMonthFoldedQty = 0, //入库数量-当月折件数量
                                    ArrYearQty = 0, //入库数量-本年数量
                                    ArrYearFoldedQty = 0, //入库数量-本年折件数量
                                    SoDayQty = 0, //出库数量-当日数量
                                    SoDayFoldedQty = 0, //出库数量-当日折件数量
                                    SoMonthQty = 0, //出库数量-当月数量
                                    SoMonthFoldedQty = 0, //出库数量-当月折件数量
                                    SoYearQty = 0, //出库数量-本年数量
                                    SoYearFoldedQty = 0, //出库数量-本年折件数量
                                    MonthQty = 0, //当月数量-累计数量 
                                    MonthFoldedQty = 0, //当月数量-累计折件数量 

                                    DepositQty = item.DepositQty,
                                    Qty = item.Qty,
                                    SecurityQty = item.SecurityQty,
                                    Situation = item.Qty < item.SecurityQty ? "1" : "0",
                                    IsDel = "0",
                                    CreateTime = DateTime.Now,
                                    CreateUser = 0,
                                    UpdateTime = null,
                                    UpdateUser = null,

                                };


                                list.Add(data);
                            }
                        }
                        else if (DateTime.Parse(data2).Month != 1)
                        {
                            //1号
                            //1号需要重新计算当月与上月、当日
                            foreach (var item in info)
                            {
                                var Folded = item.Standard.Split("*");
                                int count = 0;
                                var sum = 0m;
                                //获取对应折件数量
                                foreach (var item1 in Folded)
                                {
                                    if (count == 0)
                                    {
                                        if (item1.Contains(item.Unit))
                                        {
                                            count = 1;
                                            sum = Convert.ToDecimal(item1);
                                        }
                                    }
                                    if (count == 1)
                                    {
                                        sum *= Convert.ToDecimal(item1);
                                    }
                                }

                                DataStockInfo data = new DataStockInfo()
                                {
                                    SkuNo = item.SkuNo,
                                    SkuName = item.SkuName,
                                    Standard = item.Standard,
                                    Unit = item.Unit,

                                    LastMonthQty = item.Qty, //上月结存-库存数量
                                    LastMonthFoldedQty = item.Qty / sum, //上月结存-折件数量
                                    ArrDayQty = 0, //入库数量-当日数量
                                    ArrDayFoldedQty = 0, //入库数量-当日折件数量
                                    ArrMonthQty = 0, //入库数量-当月数量
                                    ArrMonthFoldedQty = 0, //入库数量-当月折件数量
                                    ArrYearQty = item.ArrYearQty, //入库数量-本年数量
                                    ArrYearFoldedQty = item.ArrYearQty / sum, //入库数量-本年折件数量
                                    SoDayQty = 0, //出库数量-当日数量
                                    SoDayFoldedQty = 0, //出库数量-当日折件数量
                                    SoMonthQty = 0, //出库数量-当月数量
                                    SoMonthFoldedQty = 0, //出库数量-当月折件数量
                                    SoYearQty = item.SoYearQty, //出库数量-本年数量
                                    SoYearFoldedQty = item.SoYearQty / sum, //出库数量-本年折件数量
                                    MonthQty = item.Qty, //当月数量-累计数量 
                                    MonthFoldedQty = item.Qty / sum, //当月数量-累计折件数量

                                    DepositQty = item.DepositQty,
                                    Qty = item.Qty,
                                    SecurityQty = item.SecurityQty,
                                    Situation = item.Qty < item.SecurityQty ? "1" : "0",
                                    IsDel = "0",
                                    CreateTime = DateTime.Now,
                                    CreateUser = 0,
                                    UpdateTime = null,
                                    UpdateUser = null,

                                };


                                list.Add(data);
                            }
                        }
                        #region 注释例子
                        ////1号
                        ////1号需要重新计算当月与上月、当日
                        //foreach (var item in info)
                        //{
                        //    DataStockInfo data = new DataStockInfo()
                        //    {
                        //        SkuNo = item.SkuNo,
                        //        SkuName = item.SkuName,
                        //        Standard = item.Standard,
                        //        Unit = item.Unit,
                        //        LastMonthQty = item.Qty,
                        //        ArrDayQty = 0,
                        //        ArrMonthQty = 0,
                        //        ArrYearQty = item.ArrYearQty,
                        //        SoDayQty = 0,
                        //        SoMonthQty = 0,
                        //        SoYearQty = item.SoYearQty,
                        //        MonthQty = item.Qty,
                        //        DepositQty = item.DepositQty,
                        //        Qty = item.Qty,
                        //        SecurityQty = item.SecurityQty,
                        //        Situation = item.Qty >= item.SecurityQty ? "0" : "1",
                        //        IsDel = "0",
                        //        CreateTime = DateTime.Now,
                        //        CreateUser = 0,
                        //        UpdateTime = null,
                        //        UpdateUser = null,

                        //    };


                        //    list.Add(data);
                        //}

                        #endregion
                    }
                    else
                    {
                        //其它
                        //需要计算当日
                        foreach (var item in info)
                        {
                            var Folded = item.Standard.Split("*");
                            int count = 0;
                            var sum = 0m;
                            //获取对应折件数量
                            foreach (var item1 in Folded)
                            {
                                if (count == 0)
                                {
                                    if (item1.Contains(item.Unit))
                                    {
                                        count = 1;
                                        sum = Convert.ToDecimal(item1);
                                    }
                                }
                                if (count == 1)
                                {
                                    sum *= Convert.ToDecimal(item1);
                                }
                            }

                            DataStockInfo data = new DataStockInfo()
                            {
                                SkuNo = item.SkuNo,
                                SkuName = item.SkuName,
                                Standard = item.Standard,
                                Unit = item.Unit,

                                LastMonthQty = item.LastMonthQty, //上月结存-库存数量
                                LastMonthFoldedQty = item.LastMonthQty / sum, //上月结存-折件数量
                                ArrDayQty = 0, //入库数量-当日数量
                                ArrDayFoldedQty = 0, //入库数量-当日折件数量
                                ArrMonthQty = item.ArrMonthQty, //入库数量-当月数量
                                ArrMonthFoldedQty = item.ArrMonthQty / sum, //入库数量-当月折件数量
                                ArrYearQty = item.ArrYearQty, //入库数量-本年数量
                                ArrYearFoldedQty = item.ArrYearQty / sum, //入库数量-本年折件数量
                                SoDayQty = 0, //出库数量-当日数量
                                SoDayFoldedQty = 0, //出库数量-当日折件数量
                                SoMonthQty = item.SoMonthQty, //出库数量-当月数量
                                SoMonthFoldedQty = item.SoMonthQty / sum, //出库数量-当月折件数量
                                SoYearQty = item.SoYearQty, //出库数量-本年数量
                                SoYearFoldedQty = item.SoYearQty / sum, //出库数量-本年折件数量
                                MonthQty = item.MonthQty, //当月数量-累计数量 
                                MonthFoldedQty = item.MonthQty / sum, //当月数量-累计折件数量

                                DepositQty = item.DepositQty,
                                Qty = item.Qty,
                                SecurityQty = item.SecurityQty,
                                Situation = item.Qty < item.SecurityQty ? "1" : "0",
                                IsDel = "0",
                                CreateTime = DateTime.Now,
                                CreateUser = 0,
                                UpdateTime = null,
                                UpdateUser = null,
                            };


                            list.Add(data);
                        }
                    }
                }


                //添加库存信息
                Db.Insertable<DataStockInfo>(list).ExecuteCommand();

                Db.CommitTran();
                return arr;
            }
            catch (Exception ex)
            {
                Db.RollbackTran();
                throw ex;
            }
        }

        /// <summary>
        /// 获取对应天数信息
        /// </summary>
        /// <param name="StartDate"></param>
        /// <returns></returns>
        public List<DataStockInfoVM> GetDataStockInfo(string StartDate)
        {
            try
            {
                var list = Db.Queryable<DataStockInfo>().Where(a => a.IsDel == "0").ToList();

                //验证是否存在选中时间 不存在则赋值今日时间
                if (string.IsNullOrEmpty(StartDate))
                {
                    StartDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ff");
                }

                //根据时间获取对应日期的库存信息
                if (!string.IsNullOrEmpty(StartDate))
                {
                    list = list.Where(a => a.CreateTime.Year == DateTime.Parse(StartDate).Year && a.CreateTime.Month == DateTime.Parse(StartDate).Month && a.CreateTime.Day == DateTime.Parse(StartDate).Day).ToList();
                }

                List<DataStockInfoVM> list1 = new List<DataStockInfoVM>();

                foreach (var item in list)
                {
                    DataStockInfoVM info = new DataStockInfoVM()
                    {
                        SkuNo = item.SkuNo, //物料编码
                        SkuName = item.SkuName, //物料名称
                        Standard = item.Standard, //规格
                        Unit = item.Unit, //单位
                        LastMonthQty = item.LastMonthQty, //上月结存-库存数量
                        LastMonthFoldedQty = item.LastMonthFoldedQty, //上月结存-折件数量
                        ArrDayQty = item.ArrDayQty, //入库数量-当日数量
                        ArrDayFoldedQty = item.ArrDayFoldedQty, //入库数量-当日折件数量
                        ArrMonthQty = item.ArrMonthQty, //入库数量-当月数量
                        ArrMonthFoldedQty = item.ArrMonthFoldedQty, //入库数量-当月折件数量
                        ArrYearQty = item.ArrYearQty, //入库数量-本年数量
                        ArrYearFoldedQty = item.ArrYearFoldedQty, //入库数量-本年折件数量
                        SoDayQty = item.SoDayQty, //出库数量-当日数量
                        SoDayFoldedQty = item.SoDayFoldedQty, //出库数量-当日折件数量
                        SoMonthQty = item.SoMonthQty, //出库数量-当月数量
                        SoMonthFoldedQty = item.SoMonthFoldedQty, //出库数量-当月折件数量
                        SoYearQty = item.SoYearQty, //出库数量-本年数量
                        SoYearFoldedQty = item.SoYearFoldedQty, //出库数量-本年折件数量
                        MonthQty = item.MonthQty, //当月数量-累计数量 
                        MonthFoldedQty = item.MonthFoldedQty, //当月数量-累计折件数量 
                        DepositQty = item.DepositQty, //寄存数量
                        Qty = item.Qty, //本月库存数量
                        SecurityQty = item.SecurityQty, //安全库存
                        Situation = item.Situation, //安全库存情况
                        IsDel = item.IsDel, //是否删除
                        CreateTime = item.CreateTime, //创建时间
                        CreateUser = item.CreateUser, //创建人
                        UpdateTime = item.UpdateTime, //更新时间
                        UpdateUser = item.UpdateUser, //更新人
                    };
                    list1.Add(info);
                }

                return list1;
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }


        /// <summary>
        /// 根据出入库新增或修改信息
        /// </summary>
        /// <param name="type">类型 0：入库 1：出库</param>
        /// <param name="qty">入库或出库数量</param>
        /// <param name="isDeposit">是否寄存 0：是 1：否</param>
        /// <param name="skuNo">物料编码</param>
        /// <returns></returns>
        public bool AddOrUptStockInfo(string type, decimal qty, string isDeposit, string skuNo)
        {
            try
            {
                int a = 0;
                bool isTrue = false;
                //获取今日时间
                string date = DateTime.Now.ToString("yyyy-MM-dd");
                //根据物料信息获取今日库存信息
                var list = Db.Queryable<DataStockInfo>().First(a => a.IsDel == "0" && a.SkuNo == skuNo && a.CreateTime.Year == DateTime.Parse(date).Year && a.CreateTime.Month == DateTime.Parse(date).Month && a.CreateTime.Day == DateTime.Parse(date).Day);
                Db.BeginTran();
                //验证是否存在库存信息
                if (list == null)
                {
                    //根据物料编码获取物料信息
                    var sku = Db.Queryable<SysMaterials>().First(a => a.IsDel == "0" && a.SkuNo == skuNo);
                    //根据物料信息获取单位信息
                    var unit = Db.Queryable<SysUnit>().First(a => a.IsDel == "0" && a.UnitNo == sku.UnitNo);
                    //获取对应折件数量
                    var Folded = sku.Standard.Split("*");
                    int count = 0;
                    var sum = 0m;
                    foreach (var item1 in Folded)
                    {
                        if (count == 0)
                        {
                            if (item1.Contains(unit.UnitName))
                            {
                                count = 1;
                                sum = Convert.ToDecimal(item1);
                            }
                        }
                        if (count == 1)
                        {
                            sum *= Convert.ToDecimal(item1);
                        }
                    }
                    DataStockInfo info = new DataStockInfo()
                    {
                        SkuNo = sku.SkuNo,
                        SkuName = sku.SkuName,
                        Standard = sku.Standard,
                        Unit = unit.UnitName,
                        LastMonthQty = 0,
                        ArrDayQty = 0,
                        ArrMonthQty = 0,
                        ArrYearQty = 0,
                        SoDayQty = 0,
                        SoMonthQty = 0,
                        SoYearQty = 0,
                        MonthQty = 0,
                        DepositQty = 0,
                        Qty = 0,
                        SecurityQty = sku.LowInventory,
                        Situation = qty < sku.LowInventory ? "1" : "0",
                        IsDel = "0",
                        CreateTime = DateTime.Now,
                        CreateUser = 0,
                        UpdateTime = null,
                        UpdateUser = null,

                    };

                    if (type == "0") //入库
                    {
                        //编辑对应库存信息
                        info.ArrDayQty += qty; //当日入库数量
                        info.ArrDayFoldedQty += qty; //当日入库数量-折件
                        info.ArrMonthQty += qty; //当月入库数量
                        info.ArrMonthFoldedQty += qty; //当月入库数量-折件
                        info.ArrYearQty += qty; //今年入库数量
                        info.ArrYearFoldedQty += qty; //今年入库数量-折件
                        info.MonthQty += qty; //当月结存
                        info.MonthFoldedQty += qty; //当月结存-折件

                        if (isDeposit == "0")
                        {
                            //验证是否为寄存数量
                            info.DepositQty += qty; //寄存数量
                        }
                        info.Qty = info.MonthQty + info.DepositQty; //本月库存数量
                    }
                    else if (type == "1") //出库
                    {
                        //编辑对应库存信息
                        info.SoDayQty += qty; //当日出库数量
                        info.ArrDayFoldedQty += qty; //当日入库数量-折件
                        info.ArrMonthQty += qty; //当月入库数量
                        info.ArrMonthFoldedQty += qty; //当月入库数量-折件
                        info.ArrYearQty += qty; //今年入库数量
                        info.ArrYearFoldedQty += qty; //今年入库数量-折件
                        info.MonthQty += qty; //当月结存
                        info.MonthFoldedQty += qty; //当月结存-折件

                        if (isDeposit == "0")
                        {
                            //验证是否为寄存数量
                            info.DepositQty -= qty; //寄存数量
                        }
                        info.Qty = info.MonthQty + info.DepositQty; //本月库存数量
                    }
                    //新增库存信息
                    a = Db.Insertable(info).ExecuteCommand();
                }
                else
                {
                    if (type == "0") //入库
                    {
                        //编辑对应库存信息
                        list.ArrDayQty += qty; //当日出库数量
                        list.ArrDayFoldedQty += qty; //当日入库数量-折件
                        list.ArrMonthQty += qty; //当月入库数量
                        list.ArrMonthFoldedQty += qty; //当月入库数量-折件
                        list.ArrYearQty += qty; //今年入库数量
                        list.ArrYearFoldedQty += qty; //今年入库数量-折件
                        list.MonthQty += qty; //当月结存
                        list.MonthFoldedQty += qty; //当月结存-折件

                        if (isDeposit == "0")
                        {
                            //验证是否为寄存数量
                            list.DepositQty += qty; //寄存数量
                        }
                        list.Qty = list.MonthQty + list.DepositQty; //本月库存数量
                        list.Situation = list.Qty < list.SecurityQty ? "1" : "0"; //安全库存情况


                    }
                    else if (type == "1") //出库
                    {
                        //编辑对应库存信息
                        list.SoDayQty += qty; //当日出库数量
                        list.ArrDayFoldedQty += qty; //当日入库数量-折件
                        list.ArrMonthQty += qty; //当月入库数量
                        list.ArrMonthFoldedQty += qty; //当月入库数量-折件
                        list.ArrYearQty += qty; //今年入库数量
                        list.ArrYearFoldedQty += qty; //今年入库数量-折件
                        list.MonthQty += qty; //当月结存
                        list.MonthFoldedQty += qty; //当月结存-折件

                        if (isDeposit == "0")
                        {
                            //验证是否为寄存数量
                            list.DepositQty -= qty; //寄存数量
                        }
                        list.Qty = list.MonthQty + list.DepositQty; //本月库存数量
                        list.Situation = list.Qty < list.SecurityQty ? "1" : "0"; //安全库存情况
                    }
                    a = Db.Updateable(list).ExecuteCommand();
                }

                Db.CommitTran();
                if (a == 1)
                {
                    isTrue = true;
                }

                return isTrue;

            }
            catch (Exception ex)
            {
                Db.RollbackTran();
                throw ex;
            }
        }
    }
}