using iWareSql.MyDbContext;
using System;
using System.Collections.Generic;
using System.Linq;

namespace iWareCC.Common.Helper
{
    public class BaseInfoHelper
    {
        /// <summary>
        /// 获取容器
        /// </summary>
        /// <param name="mycontext"></param>
        /// <param name="containerCode"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static wms_base_container GetContainer(MyDbContext mycontext, string containerCode, ref string errMsg)
        {


            var container = mycontext.wms_base_container.FirstOrDefault(f => f.ContainerCode == containerCode && f.IsDelete == false);
            if (container == null)
            {
                errMsg = $"容器号{containerCode}不存在";
                throw new Exception(errMsg);
            }
            if (container.IsDisabled == true)
            {
                errMsg = $"容器号{containerCode}已禁用";
                throw new Exception(errMsg);

            }

            return container;
        }

        /// <summary>
        /// 获取库位
        /// </summary>
        /// <param name="mycontext"></param>
        /// <param name="placeCode"></param>
        /// <param name="remark"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static wms_base_place GetPlace(MyDbContext mycontext, string placeCode, string remark, ref string errMsg)
        {


            var place = mycontext.wms_base_place.FirstOrDefault(f => f.PlaceCode == placeCode && f.IsDelete == false);
            if (place == null)
            {
                errMsg = $"{remark}{placeCode}不存在";
                throw new Exception(errMsg);
            }
            if (place.IsDisabled == true)
            {
                errMsg = $"{remark}{placeCode}已禁用";
                throw new Exception(errMsg);
            }
            //if (place.PlaceStatus != (int)PlaceStatusEnum.正常)
            //{
            //    errMsg = $"{remark}{placeCode}库位属性不是{PlaceStatusEnum.正常.ToString()}";
            //}

            return place;

        }


        /// <summary>
        /// 获取库区
        /// </summary>
        /// <param name="mycontext"></param>
        /// <param name="placeCode"></param>
        /// <param name="remark"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static wms_base_area GetArea(MyDbContext mycontext, string areaCode, string remark, ref string errMsg)
        {


            var area = mycontext.wms_base_area.FirstOrDefault(f => f.AreaCode == areaCode && f.IsDelete == false);
            if (area == null)
            {
                errMsg = $"{remark}{areaCode}不存在";
                throw new Exception(errMsg);
            }
            if (area.IsDisabled == true)
            {
                errMsg = $"{remark}{areaCode}已禁用";
                throw new Exception(errMsg);
            }

            return area;

        }



        /// <summary>
        /// 获取移动单
        /// </summary>
        /// <param name="mycontext"></param>
        /// <param name="singleTask"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static wms_order_movement GetOrderMovement(MyDbContext mycontext, wms_task singleTask, ref string errMsg)
        {

            var moveOrder = mycontext.wms_order_movement.FirstOrDefault(x => singleTask.OrderNo.Equals(x.OrderNo) || singleTask.RelationNo.Equals(x.OrderNo));
            if (moveOrder == null)
            {
                errMsg = $"单号{singleTask.RelationNo}\\{singleTask.OrderNo}未查询到移动单";
                throw new Exception(errMsg);

            }

            return moveOrder;
        }

        /// <summary>
        /// 获取移动单明细
        /// </summary>
        /// <param name="mycontext"></param>
        /// <param name="singleTask"></param>
        /// <param name="moveOrder"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static List<wms_order_movement_details> GetMoveOrderDetails(MyDbContext mycontext, wms_task singleTask, wms_order_movement moveOrder, ref string errMsg)
        {

            var moveOrderDetails = mycontext.wms_order_movement_details.Where(x => x.MovementId == moveOrder.Id).ToList();
            if (moveOrderDetails?.Count <= 0)
            {
                errMsg = $"单号{singleTask.OrderNo}移动单明细不存在";
                throw new Exception(errMsg);
            }

            return moveOrderDetails;
        }



    }
}