异常单回滚

啊鑫

5 天以前 5707781039b9d902ce1d2d6727fba65bbab14574

 WebApi/Gs.Wom/Service/WomdaaManager.cs

@@ -1,21 +1,21 @@
using System.Data;
using System.Data.SqlClient;
using System.Dynamic;
using System.Text;
using Gs.Toolbox;
using Gs.Toolbox;
using Gs.Toolbox.ApiCore.Abstract.Mvc;
using Gs.Toolbox.ApiCore.Common.Mvc;
using Gs.Toolbox.ApiCore.Group;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;
using System.Data;
using System.Data.SqlClient;
using System.Dynamic;
using System.Text;
using static Gs.Toolbox.UtilityHelper;


namespace Gs.Wom.Service;

[ApiGroup(ApiGroupNames.WOM)]
public class WomdaaManager :IRomteService
public class WomdaaManager : IRomteService
{
    private readonly IHttpContextAccessor _http;

@@ -127,10 +127,16 @@
                m.list2 = _tb2;
                var _tb3 = dset.Tables[3].TableToDynamicList();
                m.list3 = _tb3;
                var _tb4= dset.Tables[4].TableToDynamicList();
                var _tb4 = dset.Tables[4].TableToDynamicList();
                m.list4 = _tb4;
                var _tb5 = dset.Tables[5].TableToDynamicList();
                m.list5 = _tb5;
                var _tb6 = dset.Tables[6].TableToDynamicList();
                m.list6 = _tb6;
                var _tb7 = dset.Tables[7].TableToDynamicList();
                m.list7 = _tb7;
                var _tb8 = dset.Tables[8].TableToDynamicList();
                m.list8 = _tb8;
            }
        }
        catch (Exception ex)
@@ -259,63 +265,65 @@



    ///// <summary>
    /////     增加或编辑实体
    ///// </summary>
    ///// <param name="model"></param>
    ///// <returns></returns>
    //[RequestMethod(RequestMethods.POST)]
    //public ReturnDto<string?> EditModel([FromBody] dynamic model)
    //{
    //    Guid? guid = model.guid; //主键
    //    string sjxt = model.sjxt; //工单号 
    //    string bz = model.bz;//仓库
    //    var _outMsg = "";
    //    var _outSum = -1;
    //    using (var conn = new SqlConnection(DbHelperSQL.strConn))
    //    {
    //        using (var cmd = new SqlCommand("[prc_wom_daa_edt]", conn))
    //        {
    //            try
    //            {
    //                conn.Open();
    //                cmd.CommandType = CommandType.StoredProcedure;
    //                SqlParameter[] parameters =
    //                {
    //                    new("@outMsg", SqlDbType.NVarChar, 300),
    //                    new("@outSum", SqlDbType.Int),
    //                    new("@inOrderGuid",UtilityHelper.CheckGuid(guid)? guid : DBNull.Value),
    //                    new("@inSjxt", sjxt),
    //                    new("@inBz", bz),
    //                    new("@inEdtUserGuid", _userGuid),
    //                };
    //                parameters[0].Direction = ParameterDirection.Output;
    //                parameters[1].Direction = ParameterDirection.Output;
    //                foreach (var parameter in parameters)
    //                    cmd.Parameters.Add(parameter);
    //                cmd.ExecuteNonQuery();
    //                _outMsg = parameters[0].Value.ToString();
    //                _outSum = int.Parse(parameters[1].Value.ToString());
    //            }
    //            catch (Exception ex)
    //            {
    //                LogHelper.Debug(ToString(),
    //                    "prc_wom_daa_edt error：" + ex.Message);
    //                _outMsg = ex.Message;
    //                _outSum = -1;
    //            }
    //            finally
    //            {
    //                conn.Close();
    //            }
    //        }
    //    }
    //    if (_outSum <= 0)
    //        return ReturnDto<string>.QuickReturn(guid.ToString(),
    //            ReturnCode.Exception, _outMsg);
    //    return ReturnDto<string>.QuickReturn(guid.ToString(),
    //        ReturnCode.Success, _outMsg);
    //}
    /// <summary>
    ///     增加或编辑实体
    /// </summary>
    /// <param name="model"></param>
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<string?> EditModel([FromBody] dynamic model)
    {
        Guid? guid = model.guid; //主键
        string sjxt = model.sjxt; //工单号 
        string bz = model.bz;
        string sclx = model.sclx;
        var _outMsg = "";
        var _outSum = -1;
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd = new SqlCommand("[prc_wom_daa_edt]", conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inOrderGuid",UtilityHelper.CheckGuid(guid)? guid : DBNull.Value),
                        new("@inSjxt", sjxt),
                        new("@inBz", bz),
                        new("@inSclx", sclx),
                        new("@inEdtUserGuid", _userGuid),
                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);
                    cmd.ExecuteNonQuery();
                    _outMsg = parameters[0].Value.ToString();
                    _outSum = int.Parse(parameters[1].Value.ToString());
                }
                catch (Exception ex)
                {
                    LogHelper.Debug(ToString(),
                        "prc_wom_daa_edt error：" + ex.Message);
                    _outMsg = ex.Message;
                    _outSum = -1;
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        if (_outSum <= 0)
            return ReturnDto<string>.QuickReturn(guid.ToString(),
                ReturnCode.Exception, _outMsg);
        return ReturnDto<string>.QuickReturn(guid.ToString(),
            ReturnCode.Success, _outMsg);
    }


    /// <summary>
@@ -470,58 +478,56 @@
    /// </summary>
    /// <param name="model"></param>
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<int?> DeleteBarcode([FromBody] dynamic model)
    {
        int? rtnInt = (int)ReturnCode.Default;
        string mxGuid = model.mxGuid;
        string inType = model.inType;
        var _outMsg = "";
        var _outSum = -1;
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd = new SqlCommand("[prc_wom_daatm_del]", conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inEdtUserGuid", _userGuid),
                        new("@inMxGuid", mxGuid),
                        new("@inType", inType)
                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);
                    cmd.ExecuteNonQuery();
                    _outMsg = parameters[0].Value.ToString();
                    _outSum = int.Parse(parameters[1].Value.ToString());
                }
                catch (Exception ex)
                {
                    LogHelper.Debug(ToString(),
                        "prc_wom_daatm_del error：" + ex.Message);
                    _outMsg = ex.Message;
                    _outSum = -1;
                }
                finally
                {
                    conn.Close();
                }
            }
        }
        if (_outSum <= 0)
            return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception,
                _outMsg);
        return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg);
    }


    //[RequestMethod(RequestMethods.POST)]
    //public ReturnDto<int?> DeleteBarcode([FromBody] dynamic model)
    //{
    //    int? rtnInt = (int)ReturnCode.Default;
    //    string mxGuid = model.mxGuid;
    //    string inType = model.inType;
    //    var _outMsg = "";
    //    var _outSum = -1;
    //    using (var conn = new SqlConnection(DbHelperSQL.strConn))
    //    {
    //        using (var cmd = new SqlCommand("[prc_wom_daatm_del]", conn))
    //        {
    //            try
    //            {
    //                conn.Open();
    //                cmd.CommandType = CommandType.StoredProcedure;
    //                SqlParameter[] parameters =
    //                {
    //                    new("@outMsg", SqlDbType.NVarChar, 300),
    //                    new("@outSum", SqlDbType.Int),
    //                    new("@inEdtUserGuid", _userGuid),
    //                    new("@inMxGuid", mxGuid),
    //                    new("@inType", inType)
    //                };
    //                parameters[0].Direction = ParameterDirection.Output;
    //                parameters[1].Direction = ParameterDirection.Output;
    //                foreach (var parameter in parameters)
    //                    cmd.Parameters.Add(parameter);
    //                cmd.ExecuteNonQuery();
    //                _outMsg = parameters[0].Value.ToString();
    //                _outSum = int.Parse(parameters[1].Value.ToString());
    //            }
    //            catch (Exception ex)
    //            {
    //                LogHelper.Debug(ToString(),
    //                    "prc_wom_daatm_del error：" + ex.Message);
    //                _outMsg = ex.Message;
    //                _outSum = -1;
    //            }
    //            finally
    //            {
    //                conn.Close();
    //            }
    //        }
    //    }
    //    if (_outSum <= 0)
    //        return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception,
    //            _outMsg);
    //    return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg);
    //}


    /// <summary>
@@ -580,111 +586,37 @@
        }

        if (_outSum <= 0)
            return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception,_outMsg);
            return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg);
        return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg);
    }

    /// <summary>
    ///     根据线体或车间id，读取工单
    /// 工艺变更
    /// </summary>
    /// <param name="model"></param>
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<PageList<dynamic>> SelectDaa([FromBody] dynamic model)
    public ReturnDto<ExpandoObject> EditGy([FromBody] dynamic model)
    {
        int currentPage = model.currentPage;
        int everyPageSize = model.everyPageSize;
        string sortName = model.sortName;
        string keyWhere = model.keyWhere;
        string workId = model.workId;
        string lineId = model.lineId;
        var dset = new DataSet();
        try
        Guid? guid = model.guid; //产品主键
        var _sb = new StringBuilder();
        var _split = "|";
        foreach (var m in model.list)
        {
            using (var conn = new SqlConnection(DbHelperSQL.strConn))
            {
                using (var cmd = new SqlCommand("[prc_wom_daa_select]", conn))
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                        new("@inCurrentPage", currentPage),
                        new("@inEveryPageSize", everyPageSize),
                        new("@inSortName", sortName),
                        new("@inSortOrder", ""),
                        new("@inQueryWhere", keyWhere),
                        new("@workId", workId),
                        new("@inP1", lineId),
                        new("@inP2", "")
                    };
                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);
                    using (var dt = new SqlDataAdapter(cmd))
                    {
                        dt.Fill(dset, "0");
                    }
                }

                conn.Close();
            }
            var _line = m.processNo + _split
                                    + m.frontProcessNo;
            if (_sb.Length > 0)
                _sb.Append("~");
            _sb.Append(_line);
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), "prc_wom_pba_select error：" + ex.Message);
            return ReturnDto<PageList<dynamic>>.QuickReturn(default(PageList<dynamic>), ReturnCode.Exception, "读取失败");
        }

        var _pglist = new PageList<dynamic>
        {
            total = 0,
            everyPageSize = 0,
            pages = 0,
            list = new List<dynamic>()
        };
        if (dset != null && dset.Tables.Count > 0 &&
            dset.Tables[0].Rows.Count > 0) //有数据
        {
            var intTotal =
                int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
            var pages = intTotal % everyPageSize != 0
                ? intTotal / everyPageSize + 1
                : intTotal / everyPageSize;
            _pglist.total = intTotal;
            _pglist.everyPageSize = everyPageSize;
            _pglist.pages = pages;
            var _dy = dset.Tables[0].TableToDynamicList();
            _pglist.list = _dy;
        }

        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
            ReturnCode.Success, "读取成功");
    }

    /// <summary>
    ///     根据用户选择的采购明细guid，读取需要作入库到货单的明细
    /// </summary>
    /// <param name="query"></param>
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<List<dynamic>> SelectDaaToView(
        JArray guidList)
    {
        var intArray = guidList.ToObject<string[]>();
        var sbLine = new StringBuilder();
        foreach (var str in intArray)
        {
            if (sbLine.Length > 0)
                sbLine.Append(",");
            sbLine.Append(str);
        }

        var lst = new List<dynamic>();
        var dset = new DataSet();
        dynamic mObj = new ExpandoObject();
        mObj.outMsg = "";
        mObj.outSum = -1;
        mObj.outGuid = "";
        mObj.outNo = "";
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd =
                   new SqlCommand("[prc_wom_daa_select_to_grid]", conn))
            using (var cmd = new SqlCommand("[prc_wom_daa_technique]", conn))
            {
                try
                {
@@ -692,19 +624,26 @@
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                        new("@inP1", sbLine.ToString())
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inOrderGuid", CheckGuid(guid) ? guid : DBNull.Value),
                        new("@inEdtUserGuid", _userGuid),
                        new("@inLineList", _sb.ToString())
                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);
                    using (var dt = new SqlDataAdapter(cmd))
                    {
                        dt.Fill(dset, "0");
                    }
                    cmd.ExecuteNonQuery();
                    mObj.outMsg = parameters[0].Value.ToString();
                    mObj.outSum = int.Parse(parameters[1].Value.ToString());
                }
                catch (Exception ex)
                {
                    LogHelper.Debug(ToString(),
                        "prc_wom_daa_select_to_grid error：" + ex.Message);
                        "prc_wom_daa_technique error：" + ex.Message);
                    mObj.outMsg = ex.Message;
                    mObj.outSum = -1;
                }
                finally
                {
@@ -712,7 +651,34 @@
                }
            }
        }
        if (mObj.outSum <= 0)
            return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg);
        return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg);
    }


    /// <summary>
    ///     
    /// </summary>
    /// <param name="query"></param>
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<List<dynamic>> GetGyList(
       [FromBody] dynamic model)
    {
        string daaGuid = model.guid;
        var lst = new List<dynamic>();
        var dset = new DataSet();
        System.Text.StringBuilder sbSql = new System.Text.StringBuilder();
        sbSql.Append("   select * from [dbo].[WOMDAA_TECHNIQUE] where daaGuid='" + daaGuid + "' order by processNo asc ");
        try
        {
            dset = Gs.Toolbox.DbHelperSQL.Query(sbSql.ToString());
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), ex.Message);
        }
        if (dset != null && dset.Tables.Count > 0 &&
            dset.Tables[0].Rows.Count > 0) //有数据
            lst = dset.Tables[0].TableToDynamicList();
@@ -720,66 +686,49 @@
            "读取成功！");
    }


    /// <summary>
    ///     撤回报工
    /// 变更内包装数量
    /// </summary>
    /// <param name="mode"></param> 
    /// <param name="model"></param>
    /// <returns></returns>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<ExpandoObject> EditModelChbg([FromBody] dynamic mode)
    public ReturnDto<int?> EditTb([FromBody] dynamic model)
    {
        string _billNo = mode.billNo;
        string _inFieldValue = mode.inFieldValue;
        string _proName = "prc_pda_scbg_withdraw";
        dynamic m = new ExpandoObject();
        m.outSum = -1;
        m.outMsg = "";

        if (!Guid.TryParse(_userGuid, out Guid userGuid))
            throw new ArgumentException("无效的 UserGuid");
        int? rtnInt = (int)ReturnCode.Default;
        Guid? guid = model.guid;
        string sl = model.sl;
        var _outMsg = "";
        var _outSum = -1;
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            using (var cmd = new SqlCommand(_proName, conn))
            using (var cmd = new SqlCommand("[prc_wom_daa_nbz]", conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    // 按照存储过程定义的顺序添加参数
                    SqlParameter[] parameters =
                    {
                // 输入参数（按顺序）
                new SqlParameter("@inEdtUserGuid", SqlDbType.UniqueIdentifier) { Value = userGuid },
                new SqlParameter("@inOrderGuid", SqlDbType.UniqueIdentifier) { Value = DBNull.Value }, // 传入null
                new SqlParameter("@pi_inventoryAppBillNo", SqlDbType.NVarChar, 100) { Value = string.Empty },
                new SqlParameter("@inBarcodeGuids", SqlDbType.NVarChar, -1) { Value = _billNo ?? (object)DBNull.Value },
                new SqlParameter("@in1", SqlDbType.NVarChar, 100) { Value = string.Empty },
                new SqlParameter("@in2", SqlDbType.NVarChar, 100) { Value = string.Empty },
                new SqlParameter("@in3", SqlDbType.NVarChar, 100) { Value = string.Empty },
                
                // 输出参数（最后）
                new SqlParameter("@outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
                new SqlParameter("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output }
            };

                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inOrderGuid", UtilityHelper.CheckGuid(guid) ? guid: DBNull.Value),
                        new("@inEdtUserGuid", _userGuid),
                        new("@inSl", sl)
                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);

                    cmd.ExecuteNonQuery();

                    m.outMsg = parameters[7].Value?.ToString() ?? ""; // @outMsg是第8个参数（索引7）
                    if (parameters[8].Value != DBNull.Value && parameters[8].Value != null)
                    {
                        m.outSum = Convert.ToInt32(parameters[8].Value); // @outSum是第9个参数（索引8）
                    }
                    _outMsg = parameters[0].Value.ToString();
                    _outSum = int.Parse(parameters[1].Value.ToString());
                }
                catch (Exception ex)
                {
                    LogHelper.Debug(ToString(),
                        "prc_pda_scbg_withdraw error：" + ex.Message);
                    m.outMsg = ex.Message;
                    return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
                        ex.Message);
                    LogHelper.Debug(ToString(), "prc_wom_daa_nbz error：" + ex.Message);
                    _outMsg = ex.Message;
                    _outSum = -1;
                }
                finally
                {
@@ -787,7 +736,10 @@
                }
            }
        }
        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！");

        if (_outSum <= 0)
            return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, _outMsg);
        return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg);
    }

}