采购订单：整单删除功能

快乐的昕的电脑

2025-12-02 660ee1b662d0170c4bf256419178f41ad0df1987

采购订单：整单删除功能

 MES.Service/Modes/DeleteRequestDto.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,12 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
/// åªåŒ…含删除所需字段的DTO
/// </summary>
public class DeleteRequestDto
{
    public string FBillNo { get; set; }
    public string FBillTypeID { get; set; }
}

 MES.Service/service/BasicData/MesRohInManager.cs

@@ -3,6 +3,7 @@
using MES.Service.Dto.webApi;
using MES.Service.Modes;
using SqlSugar;
using System.Data;
using System.Globalization;
using System.Security.AccessControl;

@@ -286,4 +287,30 @@
            return entity;
        }).ToList();
    }

    /// <summary>
    /// æ•´å•åˆ é™¤ï¼Œè°ƒç”¨å­˜å‚¨è¿‡ç¨‹
    /// </summary>
    /// <param name="billNo">单号</param>
    /// <returns>被删除的单号</returns>
    public (int outSum, string outMsg) Delete(string FBillNo, string FBillTypeID)
    {
        var outMsg = string.Empty;
        var outSum = 0;

        var parameters = new List<SugarParameter>
    {
        new SugarParameter("@FBillNo", FBillNo),
        new SugarParameter("@FBillTypeID", FBillTypeID),
        new SugarParameter("@outMsg", outMsg, typeof(string), ParameterDirection.Output, 2500),
        new SugarParameter("@outSum", outSum, typeof(int), ParameterDirection.Output)
    };

        Db.Ado.UseStoredProcedure().ExecuteCommand("ERP_DeleteMesRohInByBillNo", parameters);

        outMsg = parameters[2].Value?.ToString() ?? "";
        outSum = parameters[3].Value != null ? Convert.ToInt32(parameters[2].Value) : -1;

        return (outSum, outMsg);
    }
}

 MESApplication/Controllers/BasicData/MesRohInController.cs

@@ -255,4 +255,31 @@
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ•´å•åˆ é™¤
    /// </summary>
    /// <returns></returns>
    [HttpPost("Delete")]
    public ResponseResult Delete([FromBody] DeleteRequestDto data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            // è°ƒç”¨åˆ é™¤ï¼ŒèŽ·å–存储过程返回的状态和消息
            var (outSum, outMsg) = m.Delete(data.FBillNo,data.FBillTypeID);
            resultInfos.OutSum = outSum;
            resultInfos.OutMsg = outMsg;
            return new ResponseResult
            {
                status = outSum,
                message = outMsg,
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

}