using HH.WMS.BLL;
using HH.WMS.BLL.Basic;
using HH.WMS.Common;
using HH.WMS.Common.External;
using HH.WMS.Entitys;
using HH.WMS.Entitys.Basic;
using HH.WMS.Entitys.Common;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;

namespace HH.WMS.WebApi.Areas.Common.Controllers
{
    public class LocationExtController : BaseController
    {
        #region 缓存同步-根据仓库号和货位号获取一条数据
        /// <summary>
        /// 根据仓库号和货位号获取一条数据
        /// </summary>
        /// <param name="Where">仓库号和货位号条件集合</param>
        /// <returns></returns>
        /// <history>[HanHe(XDL)] CREATED 2018/06/28</history>
        [HttpGet]
        public string GetModel(string Where)
        {
            TN_WM_LOCATION_EXTEntity entity = BLL.BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().GetExtModel(Where);
            return JsonConvert.SerializeObject(entity);
        }
        #endregion

        #region 缓存同步-删除
        /// <summary>
        /// 缓存同步-删除
        /// </summary>
        /// <param name="obj">删除实体</param>
        /// <returns></returns>
        /// <history>[HanHe(XDL)] CREATED 2018/06/28</history>
        [HttpGet]
        public string Delete(string Where)
        {
            SqlExecuteResult reuslt = BLL.BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().Delete(Where);
            return JsonConvert.SerializeObject(reuslt);
        }
        #endregion

        #region 缓存同步-新增
        /// <summary>
        /// 缓存同步-新增
        /// </summary>
        /// <param name="obj">新增实体</param>
        /// <returns></returns>
        /// <history>[HanHe(XDL)] CREATED 2018/06/28</history>
        [HttpPost]
        public string Add(dynamic obj)
        {
            TN_WM_LOCATION_EXTEntity Entity = JsonConvert.DeserializeObject<TN_WM_LOCATION_EXTEntity>(obj.ExtEntity.ToString());
            var result = JsonConvert.SerializeObject(BLL.BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().Add(Entity));
            return result;
        }
        #endregion

        #region 缓存同步-同步时修改数据
        /// <summary>
        /// 缓存同步-同步时修改数据
        /// </summary>
        /// <param name="entity">更新实体</param>
        /// <returns></returns>
        /// <history>[HanHe(XDL)] CREATED 2018/06/28</history>
        [HttpPost]
        public string UpdateSync(dynamic obj)
        {
            TN_WM_LOCATION_EXTEntity Entity = JsonConvert.DeserializeObject<TN_WM_LOCATION_EXTEntity>(obj.ExtEntity.ToString());
            SqlExecuteResult reuslt = BLL.BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().UpdateSync(Entity);
            return JsonConvert.SerializeObject(reuslt);
        }
        #endregion

        #region 缓存同步-修改成报废
        /// <summary>
        /// 缓存同步-修改成报废
        /// </summary>
        /// <param name="obj">删除实体</param>
        /// <returns></returns>
        /// <history>[HanHe(XDL)] CREATED 2018/06/28</history>
        [HttpGet]
        public string UpdateBFState(string Where)
        {
            Log.Detail("缓存同步-修改成报废", "接收参数：" + Where);
            try
            {
                HH.TOOLS.LOG.LogPara logPara = new HH.TOOLS.LOG.LogPara("缓存同步-修改成报废");
                logPara.Push("接收参数：" + Where);
                var result = JsonConvert.SerializeObject(BLL.BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().UpdateBFState(Where, ""));
                logPara.PushAndAdd("返回结果：" + result);
                return result;
            }
            catch(Exception ex)
            {
                Log.Detail("缓存同步-修改成报废", "报错原因：" + ex.Message);
                return "";
            }
           
        }
        #endregion

        #region 更新货位状态
        [HttpGet]
        public string UpdateLocationState(string locationCode, string state)
        {
            var logPara = LogType.LogPara("更新货位状态");
            Log.Detail(logPara, "接收参数，货位：" + locationCode + "，状态：" +state);
            OperateResult result = BLL.BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().UpdateState(locationCode, state, "");
            Log.Detail(logPara, "结果：" + JsonConvert.SerializeObject(result));
            return JsonConvert.SerializeObject(result);
        }
        #endregion

        #region 货位列表
        /// <summary>
        /// 货位列表-分页
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        [HttpPost]
        public string GetLocationExtList(SearchModel searchModel)
        {
            return ValidateToken(searchModel.TokenId, x =>
            {

                OperateResult list = BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().GetLocationExtList(searchModel);
                return JsonConvert.SerializeObject(list);

            });
        }
        #endregion

        #region 货位列表
        /// <summary>
        /// 货位列表
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        [HttpGet]
        public string GetLocationList()
        {
            return ValidateToken(x =>
            {

                List<TN_WM_LOCATION_EXTEntity> locationList = BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().GetLocationList();
                return JsonConvert.SerializeObject(locationList);

            });
        }
        /// <summary>
        /// 货位实体
        /// </summary>
        /// <returns></returns>
        [HttpGet]
        public string GetLocationModel(string locationCode)
        {
            return ValidateToken(x =>
            {
                TN_WM_LOCATION_EXTEntity locationModel = BLLCreator.CreateDapper<TN_WM_LOCATION_EXTEntity>().GetSingleEntity(new
                {
                    CN_S_LOCATION_CODE = locationCode
                });
                return JsonConvert.SerializeObject(OperateResult.Succeed("", locationModel));

            });
        }
        #endregion

        #region
        public OperateResult GetLocationState(string stockCode)
        {
            try
            {
                return ValidateToken(Y =>
                {
                    if (Constants.SysConfig.DB_TYPE == "MSSQL")
                    {
                        List<AutoBomStockAreaEntity> areas = BLLCreator.Create<TN_AB_B_STOCK_AREABLL>().GetArea(1, stockCode);
                        areas.AddRange(BLLCreator.Create<TN_AB_B_STOCK_AREABLL>().GetArea(4, stockCode));
                        if (areas.Count() == 0)
                        {
                            return OperateResult.Succeed("", new DataTable());
                        }
                        DataTable list = BLLCreator.Create<TN_WM_LOCATION_EXTBLL>().GetAreaStorageInfo(stockCode, areas.Select(x => x.CN_S_AREA_CODE).ToArray());
                        foreach (DataRow dr in list.Rows)
                        {
                            dr["CN_S_AREA_CODE"] = areas.Find(x => x.CN_S_AREA_CODE.Equals(dr["CN_S_AREA_CODE"].ToString().Trim())).CN_S_AREA_NAME;
                        }
                        return OperateResult.Succeed("", list);
                    }
                    else
                    {
                        DataTable list = new DataTable();
                        return OperateResult.Succeed("", list);
                    }
                });
            }
            catch (Exception ex)
            {
                return OperateResult.Error(ex.Message);
            }
        }
        #endregion
    }
}