/*
 *所有关于dt_stationinfo类的业务代码应在此处编写
*可使用repository.调用常用方法，获取EF/Dapper等信息
*如果需要事务请使用repository.DbContextBeginTransaction
*也可使用DBServerProvider.手动获取数据库相关信息
*用户信息、权限、角色等使用UserContext.Current操作
*dt_stationinfoService对增、删、改查、导入、导出、审核业务代码扩展参照ServiceFunFilter
*/
using WIDESEA_Core.BaseProvider;
using WIDESEA_Core.Extensions.AutofacManager;
using WIDESEA_Entity.DomainModels;
using System.Linq;
using WIDESEA_Core.Utilities;
using System.Linq.Expressions;
using WIDESEA_Core.Extensions;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.AspNetCore.Http;
using WIDESEA_WMS.IRepositories;
using Newtonsoft.Json;
using WIDESEA_Comm.LogInfo;
using WIDESEA_Core.FreeDB;
using WIDESEA_Core.ManageUser;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
using static System.Collections.Specialized.BitVector32;

namespace WIDESEA_WMS.Services
{
    public class Parm
    {
        public List<string> data { get; set; }
        public int type { get; set; }
    }
    public partial class dt_stationinfoService
    {
        private readonly IHttpContextAccessor _httpContextAccessor;
        private readonly Idt_stationinfoRepository _repository;//访问数据库

        [ActivatorUtilitiesConstructor]
        public dt_stationinfoService(
            Idt_stationinfoRepository dbRepository,
            IHttpContextAccessor httpContextAccessor
            )
        : base(dbRepository)
        {
            _httpContextAccessor = httpContextAccessor;
            _repository = dbRepository;
            //多租户会用到这init代码，其他情况可以不用
            //base.Init(dbRepository);
        }
        FreeDB freeDB = new FreeDB();
        /// <summary>
        /// 设置缓存架禁用启用
        /// </summary>
        /// <param name="json"></param>
        /// <returns></returns>
        public WebResponseContent SetStationEnable(object json)
        {
            WebResponseContent webResponse = new WebResponseContent();
            try
            {
                var Tel = UserContext.Current.UserInfo.Tel;
                var data = JsonConvert.DeserializeObject<Parm>(json.ToString());
                //var updateList = FreeDB.DB.Select<dt_stationinfo>().Where(t => data.data.Contains(t.id.ToString())).ToList();
                var updateList = _repository.Find(x => data.data.Contains(x.id.ToString())).ToList();
                if (!string.IsNullOrEmpty(Tel))
                {
                    var types = Tel.Split(',');
                    foreach (var update in updateList)
                    {
                        var OK = false;
                        foreach (var type in types)
                        {
                            if (update.stationCode.Contains(type))
                                OK = true;
                        }
                        if (!OK) throw new Exception("当前账号无禁用权限!");
                    }
                }

                var res = freeDB.Update<dt_stationinfo>()
                     .Set(t => t.enable, data.type == 1)
                     .Where(t => data.data.Contains(t.id.ToString()))
                     .ExecuteAffrows();

                var msg = data.type == 1 ? "启用" : "禁用";
                WriteDBLog.Write($"手动{msg}站点 ", $"{string.Join('、', updateList.Select(t => t.stationCode).ToArray())}", LogState.Sucess, "WMS", UserContext.Current.UserName);

                webResponse.OK();
            }
            catch (Exception ex)
            {
                WriteDBLog.Write($"手动启用或禁用站点 ", new { 错误信息 = ex.Message, 数据 = json }, LogState.Error, "WMS", UserContext.Current.UserName);
                webResponse.Error(ex.Message);
            }
            return webResponse;
        }

        public WebResponseContent SendAGVTask(object json)
        {
            WebResponseContent webResponse = new WebResponseContent();
            try
            {

            }
            catch (Exception ex)
            {

            }
            return webResponse;
        }

        public override WebResponseContent Add(SaveModel saveDataModel)
        {

            return base.Add(saveDataModel);
        }



        public override WebResponseContent Update(SaveModel saveModel)
        {
            WebResponseContent webResponse = new WebResponseContent();
            var station = _repository.FindFirst(x => x.id.ToString() == saveModel.MainData["id"].ToString());
            station.location_state = saveModel.MainData["location_state"].ToString();
            //station.bindSN = saveModel.MainData["bindSN"].ToString();
            var SNS = saveModel.MainData["bindSN"].ToString().Split(",");
            List<string> list = new List<string>();
            foreach (var SN in SNS)
            {
                if (!string.IsNullOrEmpty(SN))
                    list.Add(SN);
            }
            station.bindSN = string.Join(",", list);
            station.quantity = list.Count;
            station.stationType = saveModel.MainData["stationType"].ToString();
            station.heatNumber = saveModel.MainData["heatNumber"].ToString();
            station.Number = saveModel.MainData["Number"].ToString();
            station.billetID = saveModel.MainData["billetID"].ToString();
            station.remark = saveModel.MainData["remark"].ToString();
            station.tray_type = saveModel.MainData["tray_type"].ToString();
            if (list.Count == 0)
            {
                //station.tray_status = "EmptyTray";
                station.stationType = string.Empty;
                station.heatNumber = string.Empty;
                station.Number = string.Empty;
            }
            station.tray_status = string.IsNullOrEmpty(station.stationType) ? "EmptyTray" : "StrogeTray";
            if (station.location_state == "Empty" && !string.IsNullOrEmpty(station.stationType))
            {
                webResponse.Error("图号不为空,货位状态不能设置为空货位！");
            }
            //station.tray_status = list.Count == 0 ? "EmptyTray" : "StrogeTray";
            if (station.location_state == "Empty")
            {
                station.stationType = string.Empty;
                station.heatNumber = string.Empty;
                station.Number = string.Empty;
                station.billetID = string.Empty;
                station.tray_status = string.Empty;
                station.bindSN = string.Empty;
                station.quantity = 0;
                //if (!station.stationCode.Contains("S") && !station.stationCode.Contains("X") && !station.stationCode.Contains("W01001004") && !station.stationCode.Contains("W01001005"))
                //    station.tray_type = string.Empty;
            }
            var count = _repository.Update(station, true);
            if (count > 0)
                webResponse.OK();
            else
                webResponse.Error();
            return webResponse;
        }

    }
}