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

namespace WMS.BLL.SysServer
{
    public class StorageRoadwayServer: IStorageRoadwayServer
    {
        public IStorageRoadwayRepository RoadwayRst { get; set; }
        public StorageRoadwayServer(IStorageRoadwayRepository roadwayRst)
        {
            RoadwayRst = roadwayRst;
        }

        /// <summary>
        /// 查询巷道信息
        /// </summary>
        /// <param name="houseNo">仓库号</param>
        /// <param name="roadwayName">巷道名称</param>
        /// <param name="status">状态</param>
        /// <param name="type">类型</param>
        /// <param name="page"></param>
        /// <param name="limit"></param>
        /// <param name="count"></param>
        /// <returns></returns>
        public List<RoadwayDto> GetStorageRoadwayList(string houseNo, string roadwayName, string status, string type, int page, int limit,out int count)
        {
            try
            {
                Expression<Func<SysStorageRoadway, bool>> item = Expressionable.Create<SysStorageRoadway>() //创建表达式
                   .AndIF(!string.IsNullOrWhiteSpace(houseNo), it => it.WareHouseNo.Contains(houseNo.Trim()))
                   .AndIF(!string.IsNullOrWhiteSpace(roadwayName), it => it.RoadwayName.Contains(roadwayName.Trim()))
                   .AndIF(!string.IsNullOrWhiteSpace(status), it => it.Status == status)
                   .AndIF(!string.IsNullOrWhiteSpace(type), it => it.Type == type)
                   .ToExpression();//注意 这一句 不能少

                var data = RoadwayRst.GetAllByOrderPageAsync(item, limit, page,out int counts)
                    .Includes(x => x.WareHouseInfo)
                    .Includes(x => x.TemperatureInfo)
                    .Includes(x => x.CreateUserInfo)
                    .Includes(x => x.UpdateUserInfo).ToList();
                count = counts;
                return data.Select(m => new RoadwayDto()
                {
                    Id = m.Id,
                    RoadwayNo = m.RoadwayNo,
                    RoadwayName = m.RoadwayName,
                    WareHouseName = m.WareHouseInfo == null ? "" : m.WareHouseInfo.WareHouseName,
                    AreaNo = m.AreaNo,
                    Priority = m.Priority,
                    Status = m.Status,
                    Type = m.Type,
                    TypeName = GetType(m.Type),
                    TemperatureName = m.TemperatureInfo == null ? "" : m.TemperatureInfo.DictName,
                    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>
        /// 查询单条巷道信息
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public SysStorageRoadway GetStorageRoadway(int id)
        {
            try
            {
                var data = RoadwayRst.GetOneById(id);
                return data;
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }
        /// <summary>
        /// 获取巷道信息（根据仓库号）
        /// </summary>
        /// <param name="wareHouseNo">仓库号</param>
        /// <returns></returns>
        public List<SysStorageRoadway> GetStorageRoadwayByHouseNo(string wareHouseNo)
        {
            try
            {
                var data = RoadwayRst.GetAllAsync().ToList();
                if (!string.IsNullOrWhiteSpace(wareHouseNo))
                {
                    data = data.Where(m => m.WareHouseNo == wareHouseNo).ToList();
                }
                return data;
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        /// <summary>
        /// 编辑巷道信息
        /// </summary>
        /// <param name="id"></param>
        /// <param name="roadwayNo"></param>
        /// <param name="roadwayName"></param>
        /// <param name="houseNo"></param>
        /// <param name="areaNo"></param>
        /// <param name="status"></param>
        /// <param name="priority"></param>
        /// <param name="type"></param>
        /// <param name="temp"></param>
        /// <param name="userId"></param>
        /// <returns></returns>
        public bool EditStorageRoadway(int id, string roadwayName, int priority, string type, string temp, int userId)
        {
            try
            {
                var roadway = RoadwayRst.GetOneById(id);
                if (roadway == null)
                {
                    throw new Exception("为查询到当前巷道信息");
                }
                //判断除当前id信息以外是否含有编号和名称
                var bol = RoadwayRst.GetAllAsync().Any(m => m.Id != id && m.RoadwayNo== roadway.RoadwayNo && m.RoadwayName == roadwayName.Trim());
                if (bol)
                {
                    throw new Exception("当前巷道号或巷道名称已存在");
                }

                roadway.RoadwayName = roadwayName;
                roadway.Priority = priority;
                roadway.Type = type;
                roadway.Temperature = temp;
                roadway.UpdateUser = userId;
                roadway.UpdateTime = DateTime.Now;
                var num = RoadwayRst.Edit(roadway);
                if (num > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }
        /// <summary>
        /// 编辑巷道状态
        /// </summary>
        /// <param name="id"></param>
        /// <param name="status">状态</param>
        /// <param name="userId">操作人</param>
        /// <returns></returns>
        public bool EditStorageRoadwayStatus(int id, string status, int userId)
        {
            try
            {
                var area = RoadwayRst.GetOneById(id);
                if (area == null)
                {
                    throw new Exception("为查询到当前区域信息");
                }

                area.Status = status;
                area.UpdateUser = userId;
                area.UpdateTime = DateTime.Now;
                var num = RoadwayRst.EditStorageRoadwayStatus(area);
                if (num > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        /// <summary>
        /// 查询巷道类别
        /// </summary>
        /// <param name="code"></param>
        /// <returns></returns>
        public string GetType(string code)
        {
            if (string.IsNullOrWhiteSpace(code))
            {
                return "";
            }
            else
            {
                var str = "";
                switch (code)
                {
                    case "1":
                        str = "成品区";
                        break;
                    case "2":
                        str = "原料区";
                        break;
                    case "3":
                        str = "包材区";
                        break;
                    case "4":
                        str = "空托区";
                        break;
                }
                return str;
            }
        }
    }
}