using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using Model.ModelDto.SysDto;
using WMS.Entity.SysEntity;
using WMS.IBLL.ISysServer;
using WMS.IDAL.ISysInterface;
using Model.ModelVm.SysVm;

namespace WMS.BLL.SysServer
{
    public class PackagServer : IPackagServer
    {
        public IPackagRepository PackagRst { get; set; }

        public PackagServer(IPackagRepository packagRst)
        {
            PackagRst = packagRst;
        }


        /// <summary>
        /// 获取包装信息集合
        /// </summary>
        /// <param name="packagNo">包装编号</param>
        /// <param name="packagName">包装名称</param>
        /// <param name="level">等级</param>
        /// <returns>包装集合</returns>
        public List<PackagDto> GetPackagList(string packagNo, string packagName, int? level, int page, int limit, out int count)
        {
            try
            {
                Expression<Func<SysPackag, bool>> item = Expressionable.Create<SysPackag>() //创建表达式
                    .AndIF(!string.IsNullOrWhiteSpace(packagNo), it => it.PackagNo.Contains(packagNo.Trim()))
                    .AndIF(!string.IsNullOrWhiteSpace(packagName), it => it.PackagName.Contains(packagName.Trim()))
                    .AndIF(level != null, it => it.Level.Equals(level))
                    .ToExpression();//注意 这一句 不能少

                var data = PackagRst.GetAllByOrderPageAsync(item, limit, page, out int counts)
                    .Includes(x => x.CreateUserInfo)
                    .Includes(x => x.UpdateUserInfo).ToList();
                count = counts;

                return data.Select(m => new PackagDto()
                {
                    Id = m.Id,
                    IsValid = m.IsDel,
                    PackagNo = m.PackagNo,
                    PackagName = m.PackagName,
                    Level = m.Level,
                    L1 = m.L1Num == null ? "" : m.L1Num.ToString() + "/" + m.L1Name,
                    L2 = m.L2Num == null ? "" : m.L2Num.ToString() + "/" + m.L2Name,
                    L3 = m.L3Num == null ? "" : m.L3Num.ToString() + "/" + m.L3Name,
                    L4 = m.L4Num == null ? "" : m.L4Num.ToString() + "/" + m.L4Name,
                    L5 = m.L5Num == null ? "" : m.L5Num.ToString() + "/" + m.L5Name,
                    //L1Num = int.Parse(m.L1Num.ToString()),
                    //L1Name = m.L1Name,
                    //L2Num = int.Parse(m.L2Num.ToString()),
                    //L2Name = m.L2Name,
                    //L3Num = int.Parse(m.L3Num.ToString()),
                    //L3Name = m.L3Name,
                    //L4Num = int.Parse(m.L4Num.ToString()),
                    //L4Name = m.L4Name,
                    //L5Num = int.Parse(m.L5Num.ToString()),
                    //L5Name = m.L5Name,
                    CreateTime = m.CreateTime,
                    CreateUserName = m.CreateUserInfo == null ? "" : m.CreateUserInfo.RealName,
                    UpdateTime = m.UpdateTime,
                    UpdateUserName = m.UpdateUserInfo == null ? "" : m.UpdateUserInfo.RealName
                }).ToList();
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        /// <summary>
        /// 根据id获取包装信息
        /// </summary>
        /// <param name="id">包装id</param>
        /// <returns></returns>
        public SysPackag GetPackagById(int id)
        {
            SysPackag packag = PackagRst.GetOneById(id);
            return packag;
        }

        /// <summary>
        /// 添加包装信息
        /// </summary>
        /// <param name="model">包装信息</param>
        /// <returns>true：成功  flase：失败</returns>
        public int AddPackag(AddEditPackagVm model)
        {
            try
            {
                var rowCount = PackagRst.GetAllWhereAsync(m => m.PackagNo == model.PackagNo).Count();
                if (rowCount > 0)
                {
                    throw new Exception("包装编号已存在!");
                }

                rowCount = PackagRst.GetAllWhereAsync(m => m.PackagName == model.PackagName).Count();
                if (rowCount > 0)
                {
                    throw new Exception("包装名称已存在!");
                }

                SysPackag packagModel = new SysPackag();
                packagModel.PackagNo = model.PackagNo;
                packagModel.PackagName = model.PackagName;
                packagModel.Level = 0;

                //判断五级包装是否为空
                if (!string.IsNullOrEmpty(model.L5Num) && !string.IsNullOrEmpty(model.L5Name))
                {
                    packagModel.L5Num = int.Parse(model.L5Num);
                    packagModel.L5Name = model.L5Name;
                    packagModel.Level += 1;
                    //判断四级包装是否为空
                    if (string.IsNullOrEmpty(model.L4Num) && string.IsNullOrEmpty(model.L4Name))
                    {
                        return 2;
                    }
                }
                //判断四级包装是否为空
                if (!string.IsNullOrEmpty(model.L4Num) && !string.IsNullOrEmpty(model.L4Name))
                {
                    packagModel.L4Num = int.Parse(model.L4Num);
                    packagModel.L4Name = model.L4Name;
                    packagModel.Level += 1;
                    //判断三级包装是否为空
                    if (string.IsNullOrEmpty(model.L3Num) && string.IsNullOrEmpty(model.L3Name))
                    {
                        return 2;
                    }
                }
                //判断三级包装是否为空
                if (!string.IsNullOrEmpty(model.L3Num) && !string.IsNullOrEmpty(model.L3Name))
                {
                    packagModel.L3Num = int.Parse(model.L3Num);
                    packagModel.L3Name = model.L3Name;
                    packagModel.Level += 1;
                    //判断二级包装是否为空
                    if (string.IsNullOrEmpty(model.L2Num) && string.IsNullOrEmpty(model.L2Name))
                    {
                        return 2;
                    }
                }
                //判断二级包装是否为空
                if (!string.IsNullOrEmpty(model.L2Num) && !string.IsNullOrEmpty(model.L2Name))
                {
                    packagModel.L2Num = int.Parse(model.L2Num);
                    packagModel.L2Name = model.L2Name;
                    packagModel.Level += 1;
                    //判断一级包装是否为空
                    if (string.IsNullOrEmpty(model.L1Num) && string.IsNullOrEmpty(model.L1Name))
                    {
                        return 2;
                    }
                }
                //判断一级包装是否为空
                if (!string.IsNullOrEmpty(model.L1Num) && !string.IsNullOrEmpty(model.L1Name))
                {
                    packagModel.L1Num = int.Parse(model.L1Num);
                    packagModel.L1Name = model.L1Name;
                    packagModel.Level += 1;
                }
                else
                {
                    return 2;
                }

                packagModel.CreateUser = (int)model.CreateUser;

                int rowNum = PackagRst.Add(packagModel);
                if (rowNum > 0)
                {
                    return 1;
                }

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

        /// <summary>
        /// 修改包装信息
        /// </summary>
        /// <param name="model">包装信息</param>
        /// <returns>true：成功  flase：失败</returns>
        public int EditPackag(AddEditPackagVm model)
        {
            try
            {
                if (string.IsNullOrEmpty(model.PackagName))
                {
                    var date = PackagRst.GetAllWhereAsync(m => m.Id != model.Id && (m.PackagName == model.PackagName)).Count();
                    if (date > 0)
                    {
                        throw new Exception("包装名称已存在!");
                    }
                }
                var packagItems = PackagRst.GetOneById(model.Id);
                packagItems.Id = model.Id; //id
                packagItems.PackagNo = model.PackagNo; //包装编号
                packagItems.PackagName = model.PackagName; //包装描述
                //packagItems.IsDel = model.IsDel; 原因: 修改时不需要修改IsDel字段
                packagItems.UpdateTime = DateTime.Now; //修改时间
                packagItems.UpdateUser = model.CreateUser; //修改人
                packagItems.Level = 0;

                //判断五级包装是否为空
                if (!string.IsNullOrEmpty(model.L5Num) && !string.IsNullOrEmpty(model.L5Name))
                {
                    packagItems.L5Num = int.Parse(model.L5Num);
                    packagItems.L5Name = model.L5Name;
                    packagItems.Level += 1;
                    //判断四级包装是否为空
                    if (string.IsNullOrEmpty(model.L4Num) && string.IsNullOrEmpty(model.L4Name))
                    {
                        return 2;
                    }
                }
                else
                {
                    packagItems.L5Num = null;
                    packagItems.L5Name = null;
                }
                //判断四级包装是否为空
                if (!string.IsNullOrEmpty(model.L4Num) && !string.IsNullOrEmpty(model.L4Name))
                {
                    packagItems.L4Num = int.Parse(model.L4Num);
                    packagItems.L4Name = model.L4Name;
                    packagItems.Level += 1;
                    //判断三级包装是否为空
                    if (string.IsNullOrEmpty(model.L3Num) && string.IsNullOrEmpty(model.L3Name))
                    {
                        return 2;
                    }
                }
                else
                {
                    packagItems.L4Num = null;
                    packagItems.L4Name = null;
                }
                //判断三级包装是否为空
                if (!string.IsNullOrEmpty(model.L3Num) && !string.IsNullOrEmpty(model.L3Name))
                {
                    packagItems.L3Num = int.Parse(model.L3Num);
                    packagItems.L3Name = model.L3Name;
                    packagItems.Level += 1;
                    //判断二级包装是否为空
                    if (string.IsNullOrEmpty(model.L2Num) && string.IsNullOrEmpty(model.L2Name))
                    {
                        return 2;
                    }
                }
                else
                {
                    packagItems.L3Num = null;
                    packagItems.L3Name = null;
                }
                //判断二级包装是否为空
                if (!string.IsNullOrEmpty(model.L2Num) && !string.IsNullOrEmpty(model.L2Name))
                {
                    packagItems.L2Num = int.Parse(model.L2Num);
                    packagItems.L2Name = model.L2Name;
                    packagItems.Level += 1;
                    //判断一级包装是否为空
                    if (string.IsNullOrEmpty(model.L1Num) && string.IsNullOrEmpty(model.L1Name))
                    {
                        return 2;
                    }
                }
                else
                {
                    packagItems.L3Num = null;
                    packagItems.L3Name = null;
                }
                //判断一级包装是否为空
                if (!string.IsNullOrEmpty(model.L1Num) && !string.IsNullOrEmpty(model.L1Name))
                {
                    packagItems.L1Num = int.Parse(model.L1Num);
                    packagItems.L1Name = model.L1Name;
                    packagItems.Level += 1;
                }
                else
                {
                    packagItems.L1Num = null;
                    packagItems.L1Name = null;

                    return 2;
                }

                var rowCount = PackagRst.Edit(packagItems);
                return rowCount;
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        /// <summary>
        /// 删除包装信息
        /// </summary>
        /// <param name="packagId">包装信息主键ID</param>
        /// <returns>true：成功  flase：失败</returns>
        public bool DelPackag(int packagId, int userId)
        {
            try
            {
                var packagItems = PackagRst.GetOneById(packagId);
                if (packagItems == null)
                {
                    throw new Exception("包装信息不存在！");
                }

                packagItems.IsDel = "1";
                packagItems.UpdateTime = DateTime.Now;
                packagItems.UpdateUser = userId;

                var rowCount = PackagRst.Edit(packagItems);
                return rowCount > 0;
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }
    }
}