调取PLM接口 返回文件流给前端

sjz

2025-03-05 91f6c7e052185512e683ae13263fd1d1ebdf724e

调取PLM接口 返回文件流给前端

 MES.Service/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MES.Service/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MES.Service/bin/Release/net8.0/MES.Service.dll

Binary files differ

 MES.Service/bin/Release/net8.0/MES.Service.pdb

Binary files differ

 MES.Service/service/WomcaaWWManager.cs

@@ -30,17 +30,55 @@
            switch (womErpCaa.Type)
            {
                case "3":
                    return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0;
                    return DeleteData(db, mesWomcaa, mesWomcabs) ? 1 : 0;
                case "1":
                case "2":
                case "4":
                case "5":
                    return SaveOrUpdateDataWw(db, mesWomcaa, mesWomcabs) ? 1 : 0;
                case "5":
                    return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0;
                default:
                    throw new NotImplementedException(
                        $"type没有{womErpCaa.Type}这个类型");
            }
        }) > 0;
    }

    private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa, List<Womcab> mesWomcabs)
    {
        if (mesWomcaa.Id != null)
        {
            base.DeleteById(mesWomcaa.Id);
        }
        if (mesWomcabs.Count > 0)
        {
            db.Deleteable<Womcab>().Where(s => s.Eid == mesWomcaa.Erpid).ExecuteCommand();
        }
        var orUpdate = base.Insert(mesWomcaa);
        var baOrUpdate = _womcabWWManager.InsertRange(mesWomcabs);
        if (orUpdate && baOrUpdate)
        {
            //定义输入参数
            var inputParam1 = new SugarParameter("P_WORK_NO", mesWomcaa.Caa001);
            // 定义输出参数
            var outParam1 = new SugarParameter("c_Result", null, true);
            var outParam2 = new SugarParameter("C_MSG", null, true);
            // 使用 SqlSugar 执行存储过程
            Db.Ado.ExecuteCommand("BEGIN PRC_UPDATE_DAA(:P_WORK_NO,:c_Result,:C_MSG); END;", inputParam1, outParam1, outParam2);
            // 获取输出参数的值
            int result = int.Parse((string)outParam1.Value);
            string message = outParam2.Value == DBNull.Value ? string.Empty : (string)outParam2.Value;
            if (result == 1)
            {
                //存储过程失败则事务进行回滚
                db.Ado.RollbackTran();
                throw new Exception(message);
            }
            // 提交事务
            db.Ado.CommitTran();
            return true;
        }
        throw new NotImplementedException("插入或更新失败");
    }

    private bool SaveOrUpdateDataWw(SqlSugarScope db, Womcaa mesWomcaa, List<Womcab> mesWomcabss)
@@ -56,13 +94,11 @@
        throw new NotImplementedException("插入或更新失败");
    }

    private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa,List<Womcab> mesWomcabs)
    private bool DeleteData(SqlSugarScope db, Womcaa mesWomcaa,List<Womcab> mesWomcabs)
    {
        var decimals = mesWomcabs.Select(s => s.Id).ToArray();
        var update = base.DeleteById(mesWomcaa.Id);
        var insertOrUpdate = db
            .Deleteable<Womcab>().In(decimals)
            .ExecuteCommand() > 0;
        var insertOrUpdate = db.Deleteable<Womcab>().In(decimals).ExecuteCommand() > 0;

        if (update && insertOrUpdate) return true;
        throw new NotImplementedException("更新失败");

 MESApplication/Properties/PublishProfiles/FolderProfile1.pubxml.user

@@ -5,7 +5,7 @@
<Project>
  <PropertyGroup>
    <_PublishTargetUrl>E:\Tool\YC\PDA_NEW\StandardPda\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl>
    <History>True|2025-02-09T10:26:31.5704633Z||;True|2025-02-09T18:12:48.0627520+08:00||;True|2025-02-09T18:05:44.6269171+08:00||;True|2025-02-09T17:57:50.8088587+08:00||;True|2025-02-09T17:43:40.4527367+08:00||;True|2025-02-08T10:29:31.2831957+08:00||;True|2025-02-06T18:18:38.6934851+08:00||;True|2025-02-05T17:42:20.2913884+08:00||;True|2025-02-05T10:37:26.5357481+08:00||;True|2025-01-25T20:55:17.0693465+08:00||;True|2025-01-25T20:51:27.6569448+08:00||;True|2025-01-25T20:45:43.6804480+08:00||;True|2025-01-25T20:45:33.9933370+08:00||;True|2025-01-25T20:28:04.7328972+08:00||;True|2025-01-25T14:17:14.8944582+08:00||;True|2025-01-25T14:17:05.2862379+08:00||;True|2024-12-28T09:28:40.2490285+08:00||;True|2024-12-28T09:24:13.6358072+08:00||;True|2024-12-23T11:27:56.7279470+08:00||;True|2024-12-18T10:54:17.6468925+08:00||;True|2024-12-17T11:19:11.4771193+08:00||;True|2024-12-14T16:22:42.4775142+08:00||;True|2024-12-14T14:32:08.4819570+08:00||;True|2024-12-14T14:10:38.1117540+08:00||;True|2024-12-03T17:08:31.5171260+08:00||;True|2024-12-03T16:54:32.2048138+08:00||;True|2024-12-02T17:10:38.7349786+08:00||;True|2024-12-02T17:10:29.2341240+08:00||;True|2024-12-02T16:49:27.8008227+08:00||;True|2024-12-02T16:08:50.3962240+08:00||;True|2024-12-02T15:55:08.5145697+08:00||;True|2024-11-27T10:14:16.9233553+08:00||;True|2024-11-19T13:32:20.4340463+08:00||;True|2024-11-13T14:14:38.1563187+08:00||;True|2024-10-30T08:29:42.5209480+08:00||;True|2024-04-03T18:25:07.7342086+08:00||;True|2024-04-02T13:51:16.7249454+08:00||;True|2024-04-01T15:41:41.0497757+08:00||;True|2024-04-01T15:32:18.6184478+08:00||;True|2024-04-01T10:51:21.6480746+08:00||;True|2024-04-01T08:59:32.5904066+08:00||;True|2024-03-30T09:43:11.6575865+08:00||;True|2024-03-30T09:42:27.3595089+08:00||;True|2024-03-29T13:50:20.3539700+08:00||;True|2024-03-28T09:14:58.1112867+08:00||;True|2024-03-22T10:26:07.1214007+08:00||;True|2024-03-22T10:21:08.6344551+08:00||;True|2024-03-19T15:13:41.3801414+08:00||;True|2024-03-15T10:49:50.0658357+08:00||;True|2024-03-12T14:53:58.8578963+08:00||;True|2024-03-12T13:07:33.5611497+08:00||;True|2024-03-11T13:00:04.5285501+08:00||;True|2024-03-09T14:11:27.1982745+08:00||;True|2024-03-09T14:08:28.7221723+08:00||;True|2024-03-07T10:33:08.4880656+08:00||;True|2024-03-06T10:14:43.2629071+08:00||;True|2024-03-05T09:45:52.8808832+08:00||;True|2024-03-02T14:22:27.0834070+08:00||;True|2024-03-02T12:53:22.8217970+08:00||;True|2024-03-02T12:51:11.4787600+08:00||;True|2024-03-01T13:47:20.6425791+08:00||;</History>
    <History>True|2025-02-21T01:15:23.1767574Z||;True|2025-02-19T14:32:33.8569697+08:00||;True|2025-02-09T18:26:31.5704633+08:00||;True|2025-02-09T18:12:48.0627520+08:00||;True|2025-02-09T18:05:44.6269171+08:00||;True|2025-02-09T17:57:50.8088587+08:00||;True|2025-02-09T17:43:40.4527367+08:00||;True|2025-02-08T10:29:31.2831957+08:00||;True|2025-02-06T18:18:38.6934851+08:00||;True|2025-02-05T17:42:20.2913884+08:00||;True|2025-02-05T10:37:26.5357481+08:00||;True|2025-01-25T20:55:17.0693465+08:00||;True|2025-01-25T20:51:27.6569448+08:00||;True|2025-01-25T20:45:43.6804480+08:00||;True|2025-01-25T20:45:33.9933370+08:00||;True|2025-01-25T20:28:04.7328972+08:00||;True|2025-01-25T14:17:14.8944582+08:00||;True|2025-01-25T14:17:05.2862379+08:00||;True|2024-12-28T09:28:40.2490285+08:00||;True|2024-12-28T09:24:13.6358072+08:00||;True|2024-12-23T11:27:56.7279470+08:00||;True|2024-12-18T10:54:17.6468925+08:00||;True|2024-12-17T11:19:11.4771193+08:00||;True|2024-12-14T16:22:42.4775142+08:00||;True|2024-12-14T14:32:08.4819570+08:00||;True|2024-12-14T14:10:38.1117540+08:00||;True|2024-12-03T17:08:31.5171260+08:00||;True|2024-12-03T16:54:32.2048138+08:00||;True|2024-12-02T17:10:38.7349786+08:00||;True|2024-12-02T17:10:29.2341240+08:00||;True|2024-12-02T16:49:27.8008227+08:00||;True|2024-12-02T16:08:50.3962240+08:00||;True|2024-12-02T15:55:08.5145697+08:00||;True|2024-11-27T10:14:16.9233553+08:00||;True|2024-11-19T13:32:20.4340463+08:00||;True|2024-11-13T14:14:38.1563187+08:00||;True|2024-10-30T08:29:42.5209480+08:00||;True|2024-04-03T18:25:07.7342086+08:00||;True|2024-04-02T13:51:16.7249454+08:00||;True|2024-04-01T15:41:41.0497757+08:00||;True|2024-04-01T15:32:18.6184478+08:00||;True|2024-04-01T10:51:21.6480746+08:00||;True|2024-04-01T08:59:32.5904066+08:00||;True|2024-03-30T09:43:11.6575865+08:00||;True|2024-03-30T09:42:27.3595089+08:00||;True|2024-03-29T13:50:20.3539700+08:00||;True|2024-03-28T09:14:58.1112867+08:00||;True|2024-03-22T10:26:07.1214007+08:00||;True|2024-03-22T10:21:08.6344551+08:00||;True|2024-03-19T15:13:41.3801414+08:00||;True|2024-03-15T10:49:50.0658357+08:00||;True|2024-03-12T14:53:58.8578963+08:00||;True|2024-03-12T13:07:33.5611497+08:00||;True|2024-03-11T13:00:04.5285501+08:00||;True|2024-03-09T14:11:27.1982745+08:00||;True|2024-03-09T14:08:28.7221723+08:00||;True|2024-03-07T10:33:08.4880656+08:00||;True|2024-03-06T10:14:43.2629071+08:00||;True|2024-03-05T09:45:52.8808832+08:00||;True|2024-03-02T14:22:27.0834070+08:00||;True|2024-03-02T12:53:22.8217970+08:00||;True|2024-03-02T12:51:11.4787600+08:00||;True|2024-03-01T13:47:20.6425791+08:00||;</History>
    <LastFailureDetails />
  </PropertyGroup>
</Project>

 MESApplication/bin/Debug/net8.0/MES.Service.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MES.Service.pdb

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Debug/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/MES.Service.dll

Binary files differ

 MESApplication/bin/Release/net8.0/MES.Service.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.dll

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.exe

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/MESApplication.xml

@@ -462,6 +462,102 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Save(MES.Service.Dto.webApi.SaleDeliveryNotice)">
            <summary>
                单条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SaleDeliveryNotice})">
            <summary>
                多条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.GetList">
            <summary>
                获取所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.GetById(System.Int32)">
            <summary>
                根据主键获取
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.DeleteByIds(System.Object[])">
            <summary>
                根据主键删除
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Add(MES.Service.Modes.SalesDeliveryNotice)">
            <summary>
                添加
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.InsertReturnIdentity(MES.Service.Modes.SalesDeliveryNotice)">
            <summary>
                添加返回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Update(MES.Service.Modes.SalesDeliveryNotice)">
            <summary>
                修改
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.GetList">
            <summary>
                获取所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.GetById(System.Int32)">
            <summary>
                根据主键获取
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.DeleteByIds(System.Object[])">
            <summary>
                根据主键删除
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.Add(MES.Service.Modes.SalesDeliveryNoticeDetail)">
            <summary>
                添加
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.InsertReturnIdentity(MES.Service.Modes.SalesDeliveryNoticeDetail)">
            <summary>
                添加返回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.Update(MES.Service.Modes.SalesDeliveryNoticeDetail)">
            <summary>
                修改
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.Save(MES.Service.Dto.webApi.SalesOrders)">
            <summary>
                单条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SalesOrders})">
            <summary>
                多条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.GetList">
            <summary>
                获取所有
@@ -534,6 +630,18 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.Save(MES.Service.Dto.webApi.SaleReturnNotice)">
            <summary>
                单条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SaleReturnNotice})">
            <summary>
                多条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.GetList">
            <summary>
                获取所有

 MESApplication/bin/Release/net8.0/publish/MES.Service.dll

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MES.Service.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.dll

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.exe

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.pdb

Binary files differ

 MESApplication/bin/Release/net8.0/publish/MESApplication.xml

@@ -462,6 +462,102 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Save(MES.Service.Dto.webApi.SaleDeliveryNotice)">
            <summary>
                单条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SaleDeliveryNotice})">
            <summary>
                多条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.GetList">
            <summary>
                获取所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.GetById(System.Int32)">
            <summary>
                根据主键获取
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.DeleteByIds(System.Object[])">
            <summary>
                根据主键删除
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Add(MES.Service.Modes.SalesDeliveryNotice)">
            <summary>
                添加
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.InsertReturnIdentity(MES.Service.Modes.SalesDeliveryNotice)">
            <summary>
                添加返回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeController.Update(MES.Service.Modes.SalesDeliveryNotice)">
            <summary>
                修改
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.GetList">
            <summary>
                获取所有
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.GetById(System.Int32)">
            <summary>
                根据主键获取
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.DeleteByIds(System.Object[])">
            <summary>
                根据主键删除
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.Add(MES.Service.Modes.SalesDeliveryNoticeDetail)">
            <summary>
                添加
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.InsertReturnIdentity(MES.Service.Modes.SalesDeliveryNoticeDetail)">
            <summary>
                添加返回自增
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesDeliveryNoticeDetailController.Update(MES.Service.Modes.SalesDeliveryNoticeDetail)">
            <summary>
                修改
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.Save(MES.Service.Dto.webApi.SalesOrders)">
            <summary>
                单条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SalesOrders})">
            <summary>
                多条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesOrderController.GetList">
            <summary>
                获取所有
@@ -534,6 +630,18 @@
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.Save(MES.Service.Dto.webApi.SaleReturnNotice)">
            <summary>
                单条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.SaveList(System.Collections.Generic.List{MES.Service.Dto.webApi.SaleReturnNotice})">
            <summary>
                多条主表数据保存操作
            </summary>
            <returns></returns>
        </member>
        <member name="M:MESApplication.Controllers.BasicData.SalesReturnNoticeController.GetList">
            <summary>
                获取所有