using System;
using iWareSql.DBModel;
using System.Linq;
using XiGang.Core.Model;
using iWareCommon;
using iWareCommon.Common.Globle;

namespace iWareSql.DataAccess
{

    public class SalverHandler
    {

        /// <summary>
        /// 根据库位对象找到Srm_Container
        /// </summary>
        /// <param name="edm"></param>
        /// <param name="place"></param>
        /// <returns></returns>
        public static Base_Salver GetSalverByPlace(DbModel edm, Base_Station place)
        {
            Base_Salver_V_Station cvp_FromPlace = Salver_Station_Handler.GetCVPByPlaceId(place.Id, true, edm);
            Base_Salver salver = edm.Base_Salver.Where(o => o.Id == cvp_FromPlace.SalverId).FirstOrDefault();
            return salver;
        }

        /// <summary>
        /// 根据托盘ID获取托盘对象
        /// </summary>
        /// <param name="edm"></param>
        /// <param name="stationId"></param>
        /// <returns></returns>
        public static Base_Salver GetSalveById(DbModel edm, string salverId)
        {
            var materials = edm.Base_Salver.Where(x => x.Id == salverId).ToList();
            if (materials != null && materials.Count == 1)
                return materials.First();
            return null;
        }


        /// <summary>
        /// 根据托盘编号获取托盘对象
        /// </summary>
        /// <param name="edm"></param>
        /// <param name="salverCode"></param>
        /// <returns></returns>
        public static Base_Salver GetSalveByCode(DbModel edm, string salverCode)
        {
            var salver = edm.Base_Salver.Where(x => x.SalverCode == salverCode).ToList();
            if (salver == null || salver.Count == 0)
            {
                return null;
            }
            if (salver.Count > 1)
            {
                throw new Exception("托盘号" + salverCode + "存在重复的" + salver.Count() + "条托盘基础数据！");
            }
            return salver.First();
        }

        /// <summary>
        /// 入库时，使用托盘
        /// </summary>
        /// <param name="edm"></param>
        /// <param name="salverCode"></param>
        /// <param name="errMsg"></param>
        /// <returns></returns>
        public static Base_Salver GetSalveByCodeForInTask(DbModel edm, string salverCode, out string errMsg)
        {
            errMsg = "";
            var salver = GetSalveByCode(edm, salverCode);
            if (salver == null)
            {
                salver = BaseCreateSalver(edm, "入库时，新建托盘", salverCode);
            }
            else
            {
                //验证托盘是否被占用
                Base_Salver_V_Station cvp = Salver_Station_Handler.GetCVPByContainerId(edm, salver.Id);
                if (cvp != null)
                {
                    errMsg = "托盘" + salverCode + "被站点" + cvp.StationCode + "占用";
                    return null;
                }
                Base_Salver_V_Material svm = Salver_Material_Handler.GetIVCByContainerId(edm, salver.Id);
                if (svm != null)
                {
                    errMsg = "托盘" + salverCode + "被物料占用";
                    return null;
                }
            }
            return salver;
        }


        /// <summary>
        /// 创建新的托盘
        /// </summary>
        /// <param name="edm"></param>
        /// <param name="remark"></param>
        /// <returns></returns>
        private static Base_Salver BaseCreateSalver(DbModel edm, string remark, string salverCode)
        {
            try
            {
                Base_Salver salver = new Base_Salver();
                salver.Id = Guid.NewGuid().ToString();
                salver.SalverCode = salverCode;
                salver.SalverName = salverCode;
                salver.OperationRemark = remark;

                salver.IsVirtual = false;

                salver.CreateTime = salver.ModifyTime = DateTime.Now;
                salver.CreateBy = salver.ModifyBy = SysGloble.WCSSystem;


                edm.Base_Salver.Add(salver);

                return salver;
            }
            catch (Exception)
            {
                throw;
            }
        }


        /// <summary>
        /// 创建新的托盘
        /// </summary>
        /// <param name="edm"></param>
        /// <param name="remark"></param>
        /// <returns></returns>
        public static Base_Salver CreateVirtualSalver(DbModel edm, string remark)
        {
            try
            {
                Base_Salver salver = new Base_Salver();
                salver.Id = Guid.NewGuid().ToString();
                salver.SalverCode = "虚拟空托-" + salver.Id;
                salver.SalverName = "虚拟空托-" + salver.Id;
                salver.OperationRemark = remark;

                salver.IsVirtual = true;


                salver.CreateTime = salver.ModifyTime = DateTime.Now;
                salver.CreateBy = salver.ModifyBy = SysGloble.WCSSystem;


                edm.Base_Salver.Add(salver);

                return salver;
            }
            catch (Exception)
            {
                throw;
            }
        }
    }
}