异常单回滚

啊鑫

7 天以前 5707781039b9d902ce1d2d6727fba65bbab14574

 WebApi/Gs.Wom/Service/WompbaGxManager.cs

@@ -19,7 +19,6 @@
    private readonly IHttpContextAccessor _http;

    private readonly string _userCode, _userGuid, _orgFids;

    public WompbaGxManager(IHttpContextAccessor httpContextAccessor)
    {
        _http = httpContextAccessor;
@@ -82,7 +81,7 @@
        {
            LogHelper.Debug(ToString(), ex.Message);
            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
                ReturnCode.Exception, ex.Message);
          ReturnCode.Exception, ex.Message);
        }

        return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
@@ -112,8 +111,7 @@
        var dset = new DataSet();
        try
        {
            dset = DbHelperSQL.RunProcedure("[prc_wom_pbagx_mx]", parameters,
                "0");
            dset = DbHelperSQL.RunProcedure("[prc_wom_pbagx_mx]", parameters, "0");
            if (dset != null && dset.Tables.Count > 0 &&
                dset.Tables[0].Rows.Count > 0)
            {
@@ -145,8 +143,8 @@
        Guid? guid = model.guid; //主键
        string bz = model.bz; //备注
        string cjId = model.cjId; //车间
        var cxId = ""; //产线,用不到了
        var jhrs = ""; //计划人数,用不到了
        string cxId = ""; //产线,用不到了
        string jhrs = ""; //计划人数,用不到了
        var _sb = new StringBuilder();
        var _split = "|";
        foreach (var m in model.list)
@@ -169,7 +167,6 @@
                _sb.Append("~");
            _sb.Append(_line);
        }

        dynamic mObj = new ExpandoObject();
        mObj.outMsg = "";
        mObj.outSum = -1;
@@ -189,8 +186,7 @@
                        new("@outSum", SqlDbType.Int),
                        new("@outGuid", SqlDbType.UniqueIdentifier),
                        new("@outNo", SqlDbType.NVarChar, 300),
                        new("@inOrderGuid",
                            CheckGuid(guid) ? guid : DBNull.Value),
                        new("@inOrderGuid", CheckGuid(guid) ? guid : DBNull.Value),
                        new("@inBz", bz),
                        new("@inCjId", cjId),
                        new("@inCxId", cxId),
@@ -223,12 +219,9 @@
                }
            }
        }

        if (mObj.outSum <= 0)
            return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception,
                mObj.outMsg);
        return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success,
            mObj.outMsg);
            return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg);
        return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg);
    }


@@ -246,16 +239,16 @@
        string keyWhere = model.Paging.keyWhere;
        string itemid = model.ItemInfo.itemid;
        SqlParameter[] parameters =
        {
            new("@inCurrentPage", currentPage),
            new("@inEveryPageSize", everyPageSize),
            new("@inSortName", sortName),
            new("@inSortOrder", ""),
            new("@inQueryWhere", keyWhere),
            new("@itemID", itemid),
            new("@inP1", ""),
            new("@inP2", "")
        };
                  {
                        new("@inCurrentPage", currentPage),
                        new("@inEveryPageSize", everyPageSize),
                        new("@inSortName", sortName),
                        new("@inSortOrder", ""),
                        new("@inQueryWhere", keyWhere),
                        new("@itemID", itemid),
                        new("@inP1", ""),
                        new("@inP2", "")
                    };
        var dset = new DataSet();
        var _pglist = new PageList<dynamic>
        {
@@ -266,10 +259,9 @@
        };
        try
        {
            dset = DbHelperSQL.RunProcedure("prc_wom_pba_selectGX", parameters,
                "0");
            dset = DbHelperSQL.RunProcedure("prc_wom_pba_selectGX", parameters, "0");
            if (dset != null && dset.Tables.Count > 0 &&
                dset.Tables[0].Rows.Count > 0) //有数据
                    dset.Tables[0].Rows.Count > 0) //有数据
            {
                var intTotal =
                    int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
@@ -287,12 +279,13 @@
        {
            LogHelper.Debug(ToString(), ex.Message);
            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
                ReturnCode.Exception, ex.Message);
          ReturnCode.Exception, ex.Message);
        }

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



    /// <summary>
@@ -341,10 +334,8 @@
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(),
                "prc_wom_pba_select error：" + ex.Message);
            return ReturnDto<PageList<dynamic>>.QuickReturn(
                default(PageList<dynamic>), ReturnCode.Exception, "读取失败");
            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>
@@ -497,7 +488,7 @@


    /// <summary>
    ///     审核
    ///   审核
    /// </summary>
    /// <param name="mode"></param>
    /// <returns></returns>
@@ -553,7 +544,7 @@
    }

    /// <summary>
    ///     反审核
    ///   反审核
    /// </summary>
    /// <param name="mode"></param>
    /// <returns></returns>
@@ -578,7 +569,7 @@
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inEdtUserGuid", _userGuid),
                        new("@PI_ID", _guid)
                        new("@PI_ID", _guid),
                        //new("@inFieldValue", 1),
                        //new("@in1", ""),
                        //new("@in2", "")
@@ -605,7 +596,6 @@
                }
            }
        }

        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！");
    }
}