using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Comm.LogInfo;
using WIDESEA_Core.EFDbContext;
using WIDESEA_Entity.DomainModels;
using WIDESEA_WCS.IRepositories;
using WIDESEA_WCS.IServices;
using WIDESEA_WCS.Repositories;
using WIDESEA_WCS.Services;
using WIDESEA_WMS.IRepositories;
using WIDESEA_WMS.Repositories;

namespace WIDESEA_WCS.JobsPart.Common
{
    public class AutoUpdateWork
    {
        #region MyRegion
        //static FreeDB freeDB = new FreeDB();
        ///// <summary>
        ///// 自动取空托任务
        ///// </summary>
        //public static void HCJCreation()
        //{
        //    try
        //    {
        //        List<dt_stationinfo> stationinfos = new List<dt_stationinfo>();
        //        for (int i = 1; i <= 3; i++)
        //        {
        //            for (int j = 1; j <= 3; j++)
        //            {
        //                dt_stationinfo stationinfo = new dt_stationinfo();
        //                stationinfo.id = Guid.NewGuid();
        //                stationinfo.stationCode = "X0" + i + (i <= 9 ? "00" + i : "0" + i) + (j <= 9 ? "00" + j : "0" + j);
        //                stationinfo.area = "5";
        //                stationinfo.enable = true;
        //                stationinfo.line = i;
        //                stationinfo.column = j;
        //                stationinfos.Add(stationinfo);
        //            }
        //        }
        //        freeDB.AddRange(stationinfos);
        //    }
        //    catch (Exception ex)
        //    {

        //        throw;
        //    }
        //}
        #endregion

        /// <summary>
        /// 查询已完成工单
        /// </summary>
        public static void FinishMesWork()
        {

            VOLContext context = new VOLContext();
            Idt_mes_headRepository mes_HeadRepository = new dt_mes_headRepository(context);
            Idt_inventoryRepository inventoryRepository = new dt_inventoryRepository(context);
            Idt_management_timeRepository timeRepository = new dt_management_timeRepository(context);

            var val = timeRepository.Find(x => x.management_name == "FinishMesWork").FirstOrDefault().management_numericalvalue;
            var mes_heads = mes_HeadRepository.Find(x => x.quantity == x.finishNum || x.CreateTime.AddDays(val) < DateTime.Now).Take(10).ToList();

            #region 检测线工单
            var mes_head_jcxs = mes_heads.Where(x => x.processCode == "28").ToList();
            if (mes_head_jcxs.Count > 0)
            {
                foreach (var mes_head in mes_head_jcxs)
                {
                    AddHtyMesWork(mes_head, mes_HeadRepository);
                }
            }
            #endregion

            #region 机加工工单
            var mes_head_jjgs = mes_heads.Where(x => x.processCode == "17").ToList();
            if (mes_head_jjgs.Count > 0)
            {
                foreach (var mes_head in mes_head_jjgs)
                {
                    var inventorys = inventoryRepository.Find(x => x.jobID == mes_head.jobID).ToList();
                    if (inventorys.Count == mes_head.quantity || inventorys.Count==0)
                        AddHtyMesWork(mes_head, mes_HeadRepository);
                }
                var k = "加载完成";
            }
            #endregion
        }

        /// <summary>
        /// 已完成工单移入历史
        /// </summary>
        public static void AddHtyMesWork(dt_mes_head mes_Head, Idt_mes_headRepository mes_HeadRepository, string compeletor = "system", string operatetype = "自动完成")
        {
            try
            {
                VOLContext context = new VOLContext();
                Idt_mes_detailRepository mes_DetailRepository = new dt_mes_detailRepository(context);
                Idt_mes_detail_htyRepository mes_DetailRepository_hty = new dt_mes_detail_htyRepository(context);
                Idt_mes_head_htyRepository mes_Head_HtyRepository = new dt_mes_head_htyRepository(context);
                var mes_Details = mes_DetailRepository.Find(x => x.jobID == mes_Head.jobID).ToList();
                if (mes_Details.Count > 0)
                {
                    List<dt_mes_detail_hty> mes_Details_hty = new List<dt_mes_detail_hty>();
                    foreach (var mes_Detail in mes_Details)
                    {
                        dt_mes_detail_hty mes_Detail_Hty = new dt_mes_detail_hty
                        {
                            billetID = mes_Detail.billetID,
                            compeletor = compeletor,
                            FinishTime = mes_Detail.FinishTime,
                            heatBatchID = mes_Detail.heatBatchID,
                            heatID = mes_Detail.heatID,
                            jobID = mes_Detail.jobID,
                            mes_detail_id = mes_Detail.mes_detail_id,
                            mes_headID = mes_Detail.mes_headID,
                            operatetype = string.IsNullOrEmpty(mes_Detail.Status) ? "超时清理" : operatetype,
                            SN = mes_Detail.SN,
                            Status = mes_Detail.Status,
                            completedate = DateTime.Now,
                        };
                        mes_Details_hty.Add(mes_Detail_Hty);
                        mes_DetailRepository.Delete(mes_Detail, true);
                    }
                    mes_DetailRepository_hty.AddRange(mes_Details_hty, true);
                }
                dt_mes_head_hty mes_Head_Hty = new dt_mes_head_hty()
                {
                    materialCode = mes_Head.materialCode,
                    area = mes_Head.area,
                    compeletor = compeletor,
                    creator = mes_Head.creator,
                    CreateTime = mes_Head.CreateTime,
                    drawingNo = mes_Head.drawingNo,
                    drawingNoVer = mes_Head.drawingNoVer,
                    jobID = mes_Head.jobID,
                    expectedFinishTime = mes_Head.expectedFinishTime,
                    quantity = mes_Head.quantity,
                    expectedStartTime = mes_Head.expectedStartTime,
                    finishNum = mes_Head.finishNum,
                    FinishTime = mes_Head.FinishTime,
                    maxDiameterDiff = mes_Head.maxDiameterDiff,
                    operatetype = operatetype,
                    processCode = mes_Head.processCode,
                    mes_id = mes_Head.mes_id,
                    skip_op_1 = mes_Head.skip_op_1,
                    skip_op_2 = mes_Head.skip_op_2,
                    skip_op_3 = mes_Head.skip_op_3,
                    stackNoRange = mes_Head.stackNoRange,
                    productDesc = mes_Head.productDesc,
                    productName = mes_Head.productName,
                    reqID = mes_Head.reqID,
                    reqIDLineNo = mes_Head.reqIDLineNo,
                    typeID = mes_Head.typeID,
                    workOrder = mes_Head.workOrder,
                    completedate = DateTime.Now,
                };
                mes_Head_HtyRepository.Add(mes_Head_Hty, true);
                mes_HeadRepository.Delete(mes_Head, true);
                WriteDBLog.Success("处理已完成工单", $"工单编号：{mes_Head.jobID}", "PCS", compeletor);
            }
            catch (Exception ex)
            {
                WriteDBLog.Error("处理已完成工单", $"错误信息：{ex.Message}", "PCS", compeletor);
            }
        }
    }
}