优化

sjz

2025-11-11 c9ddf07c010e3b3b1bb4169f3ac34f684937d257

优化

 WebApi/Gs.HostIIS/appsettings.json

@@ -7,7 +7,7 @@
  },
  "AllowedHosts": "*",
  /*"ConnectionStrings": "Data Source=192.168.1.146;Initial Catalog=TEST_MES;User ID=testUser;Password =qixi1qaz@WSXtest",*/
  "ConnectionStrings": "Data Source=192.168.8.8;Initial Catalog=GS_MES;User ID=sa;Password =JianHui@2025",
  "ConnectionStrings": "Data Source=192.168.8.8;Initial Catalog=YS_MES;User ID=sa;Password =JianHui@2025",
  "TestErpUrl": "http://60.204.140.168:8080//kingdee/billWriteIn",
  "TestErpUrl2": "http://192.168.1.149:8066/WebService1.asmx/MesToErpUpdateFlag",
  "ProductionErpUrl": "http://192.168.1.149:8066/WebService1.asmx/mesToErpinfoFormal",

 WebApi/Gs.Warehouse/Services/MesInvItemMovesManager.cs

@@ -215,8 +215,7 @@
                }
                catch (Exception ex)
                {
                    LogHelper.Debug(ToString(),
                        "prc_move_edt error：" + ex.Message);
                    LogHelper.Debug(ToString(),"prc_move_edt error：" + ex.Message);
                    mObj.outMsg = ex.Message;
                    mObj.outSum = -1;
                }
@@ -257,26 +256,23 @@
                    {
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inOrderGuid",
                            CheckGuid(guid)
                                ? guid
                                : DBNull.Value),
                        new("@inOrderGuid", CheckGuid(guid)? guid : DBNull.Value),
                        new("@inEdtUserGuid", _userGuid),
                        new("@inMxGuid", mxGuid)
                    };
                    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_move_del error：" + ex.Message);
                    LogHelper.Debug(ToString(),"prc_move_del error：" + ex.Message);
                    _outMsg = ex.Message;
                    _outSum = -1;
                }
@@ -288,8 +284,7 @@
        }

        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);
    }

@@ -317,7 +312,7 @@
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                         new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inEdtUserGuid", _userGuid),
                        new("@inOrderGuid", _guid),
@@ -328,7 +323,9 @@
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
                    foreach (var parameter in parameters)
                    {
                        cmd.Parameters.Add(parameter);
                    }
                    cmd.ExecuteNonQuery();
                    m.outMsg = parameters[0].Value.ToString();
                    m.outSum = int.Parse(parameters[1].Value.ToString());
@@ -337,8 +334,7 @@
                {
                    LogHelper.Debug(ToString(), "prc_move_submit:" + ex.Message);
                    m.outMsg = ex.Message;
                    return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
                        ex.Message);
                    return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,ex.Message);
                }
                finally
                {
@@ -362,6 +358,7 @@
        string sortName = model.sortName;
        string keyWhere = model.keyWhere;
        string workId = model.workId;
        string ftype  = model.ftype;
        var dset = new DataSet();
        try
        {
@@ -375,17 +372,19 @@
                        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", ""),
                        new("@inP2", "")
                    };
                            new("@inCurrentPage", currentPage),
                            new("@inEveryPageSize", everyPageSize),
                            new("@inSortName", sortName),
                            new("@inSortOrder", ""),
                            new("@inQueryWhere", keyWhere),
                            new("@workId", workId),
                            new("@inP1", ""),
                            new("@inP2", "")
                        };
                        foreach (var parameter in parameters)
                        {
                            cmd.Parameters.Add(parameter);
                        }
                        using (var dt = new SqlDataAdapter(cmd))
                        {
                            dt.Fill(dset, "0");
@@ -401,17 +400,20 @@
                        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", ""),
                        new("@inP2", "")
                    };
                            new("@inCurrentPage", currentPage),
                            new("@inEveryPageSize", everyPageSize),
                            new("@inSortName", sortName),
                            new("@inSortOrder", ""),
                            new("@inQueryWhere", keyWhere),
                            new("@workId", workId),
                            new("@inP1", ""),
                            new("@inP2", "")
                        };
                        foreach (var parameter in parameters)
                        {
                            cmd.Parameters.Add(parameter);
                        }
                           
                        using (var dt = new SqlDataAdapter(cmd))
                        {
                            dt.Fill(dset, "0");
@@ -535,6 +537,7 @@
    {
        var intArray = model.lst.ToObject<string[]>();
        string workId = model.workId;
        string ftype = model.ftype;
        var sbLine = new StringBuilder();
        foreach (var str in intArray)
        {
@@ -548,6 +551,10 @@
        {
            if (workId == "1")
            {
                if (ftype == "委外(WW)")
                {
                    return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Exception, "委外");
                }
                using (var cmd = new SqlCommand("[prc_db_scdd_select_to_grid]", conn))
                {
                    try
@@ -577,6 +584,10 @@
            }
            else
            {
                if (ftype == "标准(NORMAL)")
                {
                    return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Exception, "生产");
                }
                using (var cmd = new SqlCommand("[prc_db_wwdd_select_to_grid]", conn))
                {
                    try