/********************************************************************************

** auth： DBS

** date： 2018/12/5 14:38:14

** desc： 尚未编写描述

** Ver.:  V1.0.0

*********************************************************************************/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using HH.Redis.ReisModel;
using HH.WMS.Entitys.Basic;
using HH.WMS.Common;
using HH.WMS.DAL;
using HH.WMS.DAL.Basic;
using System.Data;
using HH.WMS.Entitys;

namespace HH.WMS.BLL.Basic
{
    public class TN_WM_B_TRAY_INFOBLL:DapperBaseBLL
    {
        public TN_WM_B_TRAY_INFOEntity GetModel(string trayCode)
        {
            return DALCreator.Create<TN_WM_B_TRAY_INFODAL>().GetModel(trayCode);
        }
        #region GET

        public TN_WM_B_TRAY_INFOEntity GetByTrayCode(string trayCode)
        {
            return DALCreator.Create<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().GetSingleEntity(new { CN_S_TRAY_CODE = trayCode });
        }

        public OperateResult GetForPrint(string trayCode, string trayType, string spec, int pageIndex, int pageSize)
        {
            return DALCreator.Create<TN_WM_B_TRAY_INFODAL>().GetForPrint(trayCode, trayType, spec, pageIndex, pageSize);
        }

        #endregion

        #region 批量新增
        /// <summary>
        /// 批量新增
        /// </summary>
        /// <param name="list">新增实体</param>
        /// <returns></returns>
        /// <History>[Hanhe(DBS)] created by 2018/12/06</History>
        public OperateResult AddRange(List<TN_WM_B_TRAY_INFOEntity> list)
        {
            return CreateDAL<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().AddRange(list);
        }
        #endregion

        #region 根据托盘号批量删除
        /// <summary>
        /// 根据托盘号批量删除
        /// </summary>
        /// <param name="trays">多个托盘号用逗号隔开</param>
        /// <returns></returns>
        /// <History>[Hanhe(DBS)] created by 2018/12/06</History>
        public OperateResult Delete(string trays)
        {
            string[] arrTray = trays.Split(',');
            int okCount = 0;
            for (int i = 0; i < arrTray.Length; i++)
            {
                bool isUsed = CreateDAL<TN_WM_B_TRAY_INFODAL>().GetUseState(arrTray[i]);
                if (!isUsed)
                {
                    OperateResult or = CreateDAL<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().Delete(new { CN_S_TRAY_CODE = arrTray[i] });
                    okCount += or.AffectedRows;
                }
            }
            if (okCount == arrTray.Length)
                return OperateResult.Succeed("");
            else if(okCount == 0)
                return OperateResult.Error("删除异常！");
            else
                return OperateResult.Succeed("删除部分托盘！");
        }
        #endregion
        
        /// <summary>
        /// 创建虚拟托盘
        /// </summary>
        /// <param name="user"></param>
        /// <returns></returns>
        internal OperateResult CreateVirtualTray(RedisUserEntity user)
        {
            OperateResult or = GetCode(user, Constants.VirtualTray);
            if (or.Status != ResultStatus.Success)
                return or;

            string trayCode = or.Data.ToString();
            or = CreateDAL<DapperDAL<TN_WM_B_TRAY_INFOEntity>>().Add(new TN_WM_B_TRAY_INFOEntity
            {
                CN_S_TRAY_CODE = trayCode,
                CN_S_TRAY_CODE_EXT = "",
                CN_S_TRAY_TYPE = "虚拟托盘",
                CN_S_TRAY_DIMENSION = "",
                CN_S_TRAY_COLOR = "",
                CN_S_STATE = "",
                CN_S_SPEC = "",
                CN_S_SORTING_CODE = "",
                CN_S_COLLECT_CODE = "",
                CN_S_COLLECT_LOCATION = "",
                CN_N_LATTICE_NUM = 1,
                CN_S_USE_STATE = "",
                CN_N_ROW_NUM = 1,
                CN_N_COLUMN_NUM = 1,
                CN_F_LOADBEARING = 0,
                CN_F_GROSSWEIGHT = 0,
                CN_F_WEIGHT = 0,
                CN_S_CREATOR = user.CN_S_LOGIN,
                CN_S_CREATOR_BY = user.CN_S_NAME,
                CN_T_CREATE = DateTime.Now,
                CN_S_MODIFY = user.CN_S_LOGIN,
                CN_S_MODIFY_BY = user.CN_S_NAME,
                CN_T_MODIFY = DateTime.Now
            });
            if (or.Status == ResultStatus.Success)
                or.Data = trayCode;
            return or;
        }
    }
}