委外变更单更新开工状态

zyf

2024-11-15 4fa3f2b7d70af1539cf2731d7c54cc9769b0e14d

 MES.Service/service/BasicData/ProductionOrderManager.cs

@@ -1,8 +1,11 @@
using System.Globalization;
using System.Data;
using System.Globalization;
using MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
using DbType = System.Data.DbType;

namespace MES.Service.service.BasicData;

@@ -35,7 +38,7 @@
                    return UpdateData(db, mesRohIn, mesRohInDatas) ? 1 : 0;
                case "2":
                case "4":
                    return SaveOrUpdateData(db, mesRohIn, mesRohInDatas)
                    return SaveOrUpdateData(db, mesRohIn, mesRohInDatas, erpProductionOrderDto.Type)
                        ? 1
                        : 0;
                default:
@@ -60,7 +63,7 @@

    // 插入或更新数据的方法
    private bool SaveOrUpdateData(SqlSugarScope db, ProductionOrder mesRohIn,
        List<ProductionOrderSub> mesRohInDatas)
        List<ProductionOrderSub> mesRohInDatas,string type)
    {
        if (mesRohIn.Id != null) base.DeleteById(mesRohIn.Id);

@@ -70,7 +73,52 @@

        var orUpdate = base.Insert(mesRohIn);
        var baOrUpdate = _productionOrderSubManager.InsertRange(mesRohInDatas);
        if (orUpdate && baOrUpdate) return true;
        if (orUpdate && baOrUpdate)
        {
            if ("4".Equals(type))
            {
                //调用存储过程
                try
                {
                    // 定义输出参数
                    var outputResult = new SugarParameter("C_RESULT", null,
                        DbType.Int32, ParameterDirection.Output,
                        4000);

                    var outputMessage = new SugarParameter("MSG", null, DbType.String,
                        ParameterDirection.Output, 4000);

                    // 定义输入参数
                    var parameters = new List<SugarParameter>
                {

                    new("P_ID",mesRohIn.ErpId , DbType.String,
                        ParameterDirection.Input),
                    outputResult,
                    outputMessage
                };

                    // 使用 SqlSugar 执行存储过程
                    Db.Ado.ExecuteCommand(
                        "BEGIN PRC_MES_WW_UPDATE_BS(:P_ID, :C_RESULT, :MSG); END;",
                        parameters.ToArray());

                    // 获取输出参数的值
                    var resultValue = outputResult.Value?.ToString();
                    var messageValue = outputMessage.Value?.ToString();

                    if ("1".Equals(resultValue)) throw new Exception("更新失败");

                    return true;
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
            }
            return true; 
        }

        throw new NotImplementedException("插入或更新失败");
    }

@@ -143,7 +191,8 @@
            //     Convert.ToDecimal(erpDto.F_UNW_BaseProperty_jjds),
            StockInQty = Convert.ToDecimal(erpDto.FBaseStockInQty),
            NoStockInQty = Convert.ToDouble(erpDto.FBaseNoStockInQty),
            StockOwner = erpDto.FInStockOwnerId
            StockOwner = erpDto.FInStockOwnerId,
            SUPPLIER = erpDto.FSUPPLIERID
        };

        var single = base.GetSingle(it => it.ErpId == erpDto.FPPOMID);