// Admin.NET 项目的版权、商标、专利和其他相关权利均受相应法律法规的保护。使用本项目应遵守相关法律法规和许可证的要求。
//
// 本项目主要遵循 MIT 许可证和 Apache 许可证（版本 2.0）进行分发和使用。许可证位于源代码树根目录中的 LICENSE-MIT 和 LICENSE-APACHE 文件。
//
// 不得利用本项目从事危害国家安全、扰乱社会秩序、侵犯他人合法权益等法律法规禁止的活动！任何基于本项目二次开发而产生的一切法律纠纷和责任，我们不承担任何责任！

using Admin.NET.Core;
using Admin.NET.Core.Service;
using DocumentFormat.OpenXml.Bibliography;
using DocumentFormat.OpenXml.Drawing;
using DocumentFormat.OpenXml.Drawing.Spreadsheet;
using Furion.DependencyInjection;
using Furion.DynamicApiController;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Server.IISIntegration;
using Microsoft.Extensions.DependencyInjection;
using NewLife;
using Qiniu.CDN;
using RazorEngine;
using RazorEngine.Compilation.ImpromptuInterface;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Vistar.Application.Entity;
using Vistar.Application.SapService.Dto;
using Vistar.Application.Util;
using static SKIT.FlurlHttpClient.Wechat.Api.Models.CgibinAccountGetAccountBasicInfoResponse.Types;
using static SKIT.FlurlHttpClient.Wechat.Api.Models.ScanProductAddV2Request.Types.Product.Types;

namespace Vistar.Application.Common;
public class DataValidationService : IDynamicApiController, ITransient
{
    private readonly SqlSugarRepository<Obj110> _obj110Rep;
    public SqlSugarRepository<Obj118> _obj118Rep;
    public SqlSugarRepository<Obj109> _obj109Rep;
    public SqlSugarRepository<Obj112> _obj112Rep;
    public SqlSugarRepository<Obj133> _obj133Rep;
    public SqlSugarRepository<Obj122> _obj122Rep;
    public SqlSugarRepository<Obj137> _obj137Rep;
    public SqlSugarRepository<ObjectTypeCheckList> _objectTypeCheckListRep;
    public SqlSugarRepository<ConfigurationData> _configurationDataRep;
    private readonly IServiceScopeFactory _scopeFactory;
    public DataValidationService(
        SqlSugarRepository<Obj110> obj110Rep,
        SqlSugarRepository<Obj109> obj109Rep,
        SqlSugarRepository<Obj112> obj112Rep,
        SqlSugarRepository<Obj133> obj133Rep,
        SqlSugarRepository<Obj122> obj122Rep,
        SqlSugarRepository<Obj137> obj137Rep,
        SqlSugarRepository<ObjectTypeCheckList> objectTypeCheckList,
        SqlSugarRepository<ConfigurationData> configurationDataRep,
         IServiceScopeFactory scopeFactory

        )
    {
        _obj110Rep = obj110Rep;
        _obj109Rep = obj109Rep;
        _obj112Rep = obj112Rep;
        _obj133Rep = obj133Rep;
        _obj122Rep = obj122Rep;
        _obj137Rep = obj137Rep;
        _objectTypeCheckListRep = objectTypeCheckList;
        _configurationDataRep = configurationDataRep;
        _scopeFactory = scopeFactory;
    }
    /// <summary>
    /// 验证物料是否存在
    /// </summary>
    /// <param name="objId">对象id</param>
    /// <param name="materialCode">物料编码</param>
    /// <param name="recordGuid">物料guid</param>
    /// <returns></returns>
    public async Task<string> VerificationMaterial(long objId, string materialCode, string recordGuid)
    {
        await Task.Delay(0);
        using var serviceScope = _scopeFactory.CreateScope();
        //var sysEnumService = serviceScope.ServiceProvider.GetRequiredService<SysEnumService>();
        var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().AsTenant().GetConnectionScope("启威星 1.94.4.74").CopyNew();

        string verification = "不存在";

        if (objId == 110)
        {
            var data = db.CopyNew().Queryable<Obj110>().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).Count();
            if (data > 0)
            {
                verification = "存在";
            }
        }

        if (objId == 109)
        {
            var data = db.CopyNew().Queryable<Obj109>().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).Count();
            if (data > 0)
            {
                verification = "存在";
            }
        }

        if (objId == 112)
        {
            var data = db.CopyNew().Queryable<Obj112>().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).Count();
            if (data > 0)
            {
                verification = "存在";
            }
        }

        if (objId == 133)
        {
            var data = db.CopyNew().Queryable<Obj133>().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).Count();
            if (data > 0)
            {
                verification = "存在";
            }
        }

        if (objId == 137)
        {
            var data = db.CopyNew().Queryable<Obj137>().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid && x._system_objConfigurationName == "默认").Count();
            if (data > 0)
            {
                verification = "存在";
            }
        }

        if (objId == 122)
        {
            var data = db.CopyNew().Queryable<Obj122>().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).Count();
            if (data > 0)
            {
                verification = "存在";
            }
        }

        //var tasks = new List<Task<int>>();
        //switch (objId)
        //{
        //    case 110:
        //        tasks.Add(_obj110Rep.AsQueryable().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).CountAsync());
        //        break;
        //    case 109:
        //        tasks.Add(_obj109Rep.AsQueryable().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).CountAsync());
        //        break;
        //    case 112:
        //        tasks.Add(_obj112Rep.AsQueryable().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).CountAsync());
        //        break;
        //    case 133:
        //        tasks.Add(_obj133Rep.AsQueryable().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).CountAsync());
        //        break;
        //    case 122:
        //        tasks.Add(_obj122Rep.AsQueryable().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).CountAsync());
        //        break;
        //    case 137:
        //        tasks.Add(_obj137Rep.AsQueryable().Where(x => x._System_objNBS == materialCode && x.deleted == false && x.RecordGuid == recordGuid).CountAsync());
        //        break;
        //}
        //if (tasks.Count > 0)
        //{
        //    var result = await Task.WhenAll(tasks);
        //    verification = result.Any(count => count > 0) ? "存在" : "不存在";
        //}

        return verification;
    }

    /// <summary>
    /// 查询ecn编号
    /// </summary>
    /// <param name="idRecord"></param>
    /// <returns></returns>
    public async Task<List<EcnItemData>> ChangeModuleMaterial(long idRecord)
    {
        using var serviceScope = _scopeFactory.CreateScope();
        var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().AsTenant().GetConnectionScope("启威星 1.94.4.74").CopyNew();

        var encodingList = new List<EcnItemData>();

        // 获取符合条件的检查列表项
        var checkList = await db.CopyNew().Queryable<ObjectTypeCheckList>()
            .Where(x => x.ParentIdRecord == idRecord && (x.ColumnId == 4638 || x.ColumnId == 6002))
            .ToListAsync();

        // 遍历检查列表
        foreach (var item in checkList)
        {
            var recordGuid = item.RecordGuid;
            var objectId = item.ObjectId;
            dynamic data = null; // 使用 dynamic 类型来通用处理不同的仓储查询

            // 根据 ObjectId 选择相应的仓储并查询数据
            switch (objectId)
            {
                case 110:
                    data = await db.CopyNew().Queryable<Obj110>()
                        .Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord)
                        .FirstAsync();
                    break;
                case 109:
                    data = await db.CopyNew().Queryable<Obj109>()
                        .Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord)
                        .FirstAsync();
                    break;
                case 112:
                    data = await db.CopyNew().Queryable<Obj112>()
                        .Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord)
                        .FirstAsync();
                    break;
                case 133:
                    data = await db.CopyNew().Queryable<Obj133>()
                        .Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord)
                        .FirstAsync();
                    break;
                case 122:
                    data = await db.CopyNew().Queryable<Obj122>()
                        .Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord)
                        .FirstAsync();
                    break;
                case 137:
                    data = await db.CopyNew().Queryable<Obj137>()
                        .Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord)
                        .FirstAsync();
                    break;
                default:
                    continue; // 如果 ObjectId 不匹配，跳过本次循环
            }

            // 创建新的 EcnItemData 对象并添加到列表中
            if (data != null)
            {
                encodingList.Add(new EcnItemData
                {
                    Matnr = data._System_objNBS
                });
            }
        }

        // 返回编码列表
        return encodingList;
    }

    /// <summary>
    /// 获取单位
    /// </summary>
    /// <param name="objid"></param>
    /// <param name="ChildGuid"></param>
    /// <returns></returns>
    public async Task<string> GetUnit(long objid, string ChildGuid)
    {
        using var serviceScope = _scopeFactory.CreateScope();
        var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().AsTenant().GetConnectionScope("启威星 1.94.4.74").CopyNew();
        var unit = "";
        if (objid == 137)
        {
            var data = await db.CopyNew().Queryable<Obj137>().Where(x => x.RecordGuid == ChildGuid && x.deleted == false).OrderByDescending(x => x.VersionIndex).FirstAsync();
            unit = data._SWPDM_126_SW___;
        }
        if (objid == 112)
        {
            var data = await db.CopyNew().Queryable<Obj112>().Where(x => x.RecordGuid == ChildGuid && x.deleted == false).OrderByDescending(x => x.VersionIndex).FirstAsync();
            unit = data.fld004594;
        }
        return unit;
    }

    /// <summary>
    /// 获取记录ID
    /// </summary>
    /// <param name="objId">对象id</param>
    /// <param name="recordGuid">物料guid</param>
    /// <returns></returns>
    public async Task<long> GetRecordId(long objId, string recordGuid)
    {
        long idRecord = 0;
        if (objId == 137)
        {
            var data = await _obj137Rep.AsQueryable().Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.VersionIndex).FirstAsync();
            idRecord = data.idRecord;
        }
        if (objId == 112)
        {
            var data = await _obj112Rep.AsQueryable().Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.VersionIndex).FirstAsync();
            idRecord = data.idRecord;
        }
        return idRecord;
    }

    /// <summary>
    /// 通过id和对象id获取物料编码
    /// </summary>
    /// <param name="objId">对象id</param>
    /// <param name="id">物料guid</param>
    /// <returns></returns>
    public async Task<string> GetCoding(long objId, long id)
    {
        string coding = "编码不存在";
        if (objId == 137)
        {
            var data = await _obj137Rep.AsQueryable().Where(x => x.idRecord == id).FirstAsync();
            coding = data._System_objNBS;
        }
        if (objId == 112)
        {
            var data = await _obj112Rep.AsQueryable().Where(x => x.idRecord == id).FirstAsync();
            coding = data._System_objNBS;
        }
        return coding;
    }

    /// <summary>
    /// 获取行号
    /// </summary>
    /// <param name="objId">对象id</param>
    /// <param name="recordGuid">guid</param>
    /// <param name="versionIndex">版本</param>
    /// <param name="configId">配置id</param>
    /// <returns></returns>
    public async Task<int> GetLineNumber(long objId, string recordGuid, int versionIndex, int configId)
    {
        using var serviceScope = _scopeFactory.CreateScope();
        var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().AsTenant().GetConnectionScope("启威星 1.94.4.74").CopyNew();

        int lineNumber = 0;

        if (objId == 118)
        {
            lineNumber = await db.CopyNew().Queryable<ConfigurationData>().Where(x => x.ParentGuid == recordGuid && x.isDeleted == false && x.ParentVersion == versionIndex && x.ConfigId == configId && x.isSuppressed == false && x.inContext == false).CountAsync();
        }

        return lineNumber;
    }

    /// <summary>
    /// 生成guid
    /// </summary>
    /// <returns></returns>
    public async Task<string> GetGuid()
    {
        await Task.Delay(0);
        // 生成一个新的Guid实例
        Guid guid = Guid.NewGuid();

        // 将Guid转换为字符串形式
        string uuidString = guid.ToString();

        return uuidString;
    }

    /// <summary>
    /// 对比物料版本
    /// </summary>
    /// <param name="objId"></param>
    /// <param name="recordGuid"></param>
    /// <param name="newVersion"></param>
    /// <param name="olderVersion"></param>
    /// <returns></returns>
    public async Task<string> ComparativeVersion(long objId, string recordGuid, int newVersion, int olderVersion)
    {
        using var serviceScope = _scopeFactory.CreateScope();
        var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().AsTenant().GetConnectionScope("启威星 1.94.4.74").CopyNew();

        string contrastResult = "";

        if (objId == 137)
        {
            var contrastNewData = await db.CopyNew().Queryable<Obj137>().Where(x => x.RecordGuid == recordGuid && x.deleted == false && x.VersionIndex == newVersion).FirstAsync();
            var contrastOlderData = await db.CopyNew().Queryable<Obj137>().Where(x => x.RecordGuid == recordGuid && x.deleted == false && x.VersionIndex == olderVersion).FirstAsync();
            if (contrastNewData.revision != contrastOlderData.revision)
            {
                contrastResult = "是";
            }
        }
        //if (objId == 112)
        //{
        //    var contrastNewData = await _obj112Rep.AsQueryable().Where(x => x.RecordGuid == recordGuid && x.deleted == false && x.VersionIndex == newVersion).FirstAsync();
        //    var contrastOlderData = await _obj112Rep.AsQueryable().Where(x => x.RecordGuid == recordGuid && x.deleted == false && x.VersionIndex == olderVersion).FirstAsync();
        //    if (contrastNewData.revision == contrastOlderData.revision)
        //    {
        //        contrastResult = "是";
        //    }
        //}


        return contrastResult;
    }
    /// <summary>
    /// 修改库存信息
    /// </summary>
    /// <param name="recordGuid"></param>
    /// <param name="code"></param>
    /// <param name="objectid"></param>
    /// <param name="Bdmng"></param>
    /// <param name="Labst"></param>
    /// <param name="ZwqslPo"></param>
    /// <param name="ZwqslPr"></param>
    /// <param name="dateUpdated"></param>
    /// <returns></returns>
    public async Task<string> ModifyInventoryInformation(string recordGuid, string code, long objectid, string Bdmng, string Labst, string ZwqslPo, string ZwqslPr, DateTime dateUpdated)
    {
        using var serviceScope = _scopeFactory.CreateScope();
        var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().AsTenant().GetConnectionScope("启威星 1.94.4.74").CopyNew();
        if (code == "S")
        {
            if (objectid == 137)
            {
                var data = await db.CopyNew().Queryable<Obj137>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj137>()
                       .SetColumns(it => new Obj137
                       {
                           fld006530 = Bdmng,
                           fld005623 = Labst,
                           fld006531 = ZwqslPo,
                           fld006532 = ZwqslPr,
                           fld005624 = dateUpdated
                       })
                   .Where(it => it.idRecord == data.idRecord)
                   .ExecuteCommand();
                }
            }

            if (objectid == 112)
            {
                var data = await db.CopyNew().Queryable<Obj112>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj112>().SetColumns(it => new Obj112
                    {
                        fld006750 = Bdmng,
                        fld006751 = Labst,
                        fld006752 = ZwqslPo,
                        fld006753 = ZwqslPr,
                        fld006755 = dateUpdated
                    })
                    .Where(it => it.idRecord == data.idRecord)
                    .ExecuteCommand();
                }
            }
        }
        else
        {
            if (objectid == 137)
            {
                var data = await db.CopyNew().Queryable<Obj137>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj137>().SetColumns(it => new Obj137
                    {
                        fld006530 = "",
                        fld005623 = "",
                        fld006531 = "",
                        fld006532 = "",
                        fld005624 = dateUpdated
                    })
                    .Where(it => it.idRecord == data.idRecord)
                    .ExecuteCommand();
                }
            }

            if (objectid == 112)
            {
                var data = await db.CopyNew().Queryable<Obj112>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj112>()
                       .SetColumns(it => new Obj112
                       {
                           fld006750 = "",
                           fld006751 = "",
                           fld006752 = "",
                           fld006753 = "",
                           fld006755 = dateUpdated
                       })
                   .Where(it => it.idRecord == data.idRecord)
                   .ExecuteCommand();
                }
            }
        }

        return "修改成功";
    }

    /// <summary>
    /// 修改价格信息
    /// </summary>
    /// <param name="recordGuid"></param>
    /// <param name="code"></param>
    /// <param name="objectid"></param>
    /// <param name="Verpr"></param>
    /// <param name="dateUpdated"></param>
    /// <returns></returns>
    public async Task<string> ModifyPriceInformation(string recordGuid, string code, long objectid, string Verpr, DateTime dateUpdated)
    {
        using var serviceScope = _scopeFactory.CreateScope();
        var db = serviceScope.ServiceProvider.GetRequiredService<ISqlSugarClient>().AsTenant().GetConnectionScope("启威星 1.94.4.74").CopyNew();
        if (code == "S")
        {
            if (objectid == 137)
            {
                var data = await db.CopyNew().Queryable<Obj137>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj137>()
                       .SetColumns(it => new Obj137
                       {
                           fld005625 = Verpr,
                           fld005626 = dateUpdated
                       })
                   .Where(it => it.idRecord == data.idRecord)
                   .ExecuteCommand();
                }
            }

            if (objectid == 112)
            {
                var data = await db.CopyNew().Queryable<Obj112>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj112>().SetColumns(it => new Obj112
                    {
                        fld006754 = Verpr,
                        fld006756 = dateUpdated
                    })
                    .Where(it => it.idRecord == data.idRecord)
                    .ExecuteCommand();
                }
            }
        }
        else
        {
            if (objectid == 137)
            {
                var data = await db.CopyNew().Queryable<Obj137>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).OrderByDescending(x => x.idRecord).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj137>().SetColumns(it => new Obj137
                    {
                        fld005625 = "",
                        fld005626 = dateUpdated
                    })
                    .Where(it => it.idRecord == data.idRecord)
                    .ExecuteCommand();
                }
            }

            if (objectid == 112)
            {
                var data = await db.CopyNew().Queryable<Obj112>().Where(x => x.RecordGuid == recordGuid && x.deleted == false).FirstAsync();
                if (data != null)
                {
                    db.CopyNew().Updateable<Obj112>()
                       .SetColumns(it => new Obj112
                       {
                           fld006754 = "",
                           fld006756 = dateUpdated
                       })
                   .Where(it => it.idRecord == data.idRecord)
                   .ExecuteCommand();
                }
            }
        }

        return "修改成功";
    }

    /// <summary>
    /// SAP wbs状态
    /// </summary>
    /// <param name="status"></param>
    /// <returns></returns>
    public async Task<string> ProjProcStatus(string status)
    {
        await Task.Delay(0);
        if (status == "进行中")
        {
            return "REL";
        }
        if (status == "未启动")
        {
            return "CRTD";
        }
        if (status == "暂停")
        {
            return "TECO";
        }
        if (status == "已完成")
        {
            return "TEL";
        }
        if (status == "已取消")
        {
            return "TECO";
        }
        if (status == "删除")
        {
            return "DLFL";
        }
        return status;
    }

    public async Task<decimal> ProcessNumber(decimal number)
    {
        if (number < 1)
        {
            string numStr = number.ToString();
            int decimalIndex = numStr.IndexOf('.');
            string decimalPart = numStr.Substring(decimalIndex + 1);
            // 去除小数部分末尾的 0
            decimalPart = decimalPart.TrimEnd('0');
            if (decimalPart.Length == 1)
            {
                return number;
            }
            int firstNonZeroIndex = 0;
            while (firstNonZeroIndex < decimalPart.Length && decimalPart[firstNonZeroIndex] == '0')
            {
                firstNonZeroIndex++;
            }
            if (firstNonZeroIndex == decimalPart.Length - 1)
            {
                // 若只有一位非零数字，找到合适的进位位置
                string newDecimalPart = new string('0', firstNonZeroIndex - 1) + "1";
                return decimal.Parse("0." + newDecimalPart);
            }
            return Math.Round(number, decimalPart.Length - firstNonZeroIndex - 1);
        }
        else
        {
            if (number < 10000)
            {
                int power = (int)Math.Floor(Math.Log10((double)number));
                return (decimal)(Math.Floor((double)number / Math.Pow(10, power)) * Math.Pow(10, power));
            }
            return (decimal)(Math.Floor((double)number / 1000) * 1000);
        }
    }

    ///// <summary>
    ///// 验证是否存在bom和工艺路线
    ///// </summary>
    ///// <returns></returns>
    //public async Task<List<IsBomAndProcessRouteExistOutput>> IsBomAndProcessRouteExist()
    //{
    //    //var materialData = await _obj137Rep.AsQueryable()
    //    //    .Where(x => x.CheckedStatus == 0 && x.deleted == false && x.IsLatestVersion == true && (x._SWPDM_1202_SW_____ != "不展开" || x._SWPDM_1202_SW_____ == null) && (x.fld005534 == "A" || x.fld005534 == "M") && x._system_objConfigurationName == "默认" && !x.SWPDMFileName.Contains("SLDDRW"))
    //    //   .ToListAsync();

    //    //查询需要同步的产品
    //    var materialData = await _obj137Rep.AsQueryable()
    //   .Where(x => x.CheckedStatus == 0 && x.deleted == false && x.IsLatestVersion == true && x._system_objConfigurationName == "默认" && !x.SWPDMFileName.Contains("SLDDRW") && (x._SWPDM_1202_SW_____ != "不展开" || x._SWPDM_1202_SW_____ == null) && (x.fld005537 == "A" || x.fld005537 == "M"))
    //   .ToListAsync();

    //    //分组查询最大版本的物料
    //    var groupedData = materialData.GroupBy(item => item.RecordGuid)
    //  .Select(group => group.OrderByDescending(item => item.VersionIndex).First())
    //  .ToList();

    //    var output = new List<string>();
    //    var outputList = new List<IsBomAndProcessRouteExistOutput>();

    //    var tasks = groupedData.Select(async item =>
    //    {
    //        var versionIndex = item.VersionIndex;
    //        var processRouteData = await _configurationDataRep.CopyNew().AsQueryable()
    //          .Where(x => x.ConfigId == 8 && x.ParentGuid == item.RecordGuid && x.isDeleted == false && x.ParentVersion == versionIndex).ToListAsync();
    //        if (processRouteData.Count == 0)
    //        {
    //            await _obj137Rep.CopyNew().AsUpdateable()
    //                 .SetColumns(it => new Obj137
    //                 {
    //                     fld005534 = "N",
    //                 })
    //                 .Where(it => it.idRecord == item.idRecord)
    //                 .ExecuteCommandAsync();
    //            var oub = new IsBomAndProcessRouteExistOutput
    //            {
    //                objId = 137,
    //                materialCode = item._System_objNBS,
    //                isSuccess = "刷新成功"

    //            };

    //            outputList.Add(oub);
    //            return new IsBomAndProcessRouteExistOutput
    //            {
    //                objId = 137,
    //                materialCode = item._System_objNBS,
    //                isSuccess = "刷新成功"
    //            };
    //        }
    //        return new IsBomAndProcessRouteExistOutput
    //        {
    //            objId = 137,
    //            materialCode = item._System_objNBS,
    //            isSuccess = "刷新失败"
    //        };
    //    });
    //    var bomStockInquiryOutput = await Task.WhenAll(tasks);

    //    //foreach (var item in groupedData)
    //    //{
    //    //    // 获取版本号
    //    //    var versionIndex = item.VersionIndex;
    //    //    //var bomData = await _configurationDataRep.AsQueryable()
    //    //    //   .Where(x => x.ConfigId == 8 && x.ParentGuid == item.RecordGuid && x.isDeleted == false && x.ParentVersion == versionIndex && (x.fld005577 != "不包含" || x.fld005577 == null) && x.isSuppressed == false && x.inContext == false).ToListAsync();

    //    //    //if (bomData.Count == 0)
    //    //    //{
    //    //    //    await _obj137Rep.AsUpdateable()
    //    //    //         .SetColumns(it => new Obj137
    //    //    //         {
    //    //    //             fld005534 = "N",
    //    //    //         })
    //    //    //         .Where(it => it.idRecord == item.idRecord)
    //    //    //         .ExecuteCommandAsync();
    //    //    //    continue;
    //    //    //}


    //    //    var processRouteData = await _configurationDataRep.AsQueryable()
    //    //      .Where(x => x.ConfigId == 9 && x.ParentGuid == item.RecordGuid && x.isDeleted == false && x.ParentVersion == versionIndex).ToListAsync();
    //    //    if (processRouteData.Count == 0)
    //    //    {
    //    //        await _obj137Rep.AsUpdateable()
    //    //             .SetColumns(it => new Obj137
    //    //             {
    //    //                 fld005537 = "N",
    //    //             })
    //    //             .Where(it => it.idRecord == item.idRecord)
    //    //             .ExecuteCommandAsync();
    //    //        continue;
    //    //    }
    //    //}




    //    return outputList;
    //}

}