啊鑫
2025-09-09 f2b71fe1d3c2b7651d525a5b5bbe66fad602ea06
WebApi/Gs.QiTaCk/MesCgthSqManager.cs
@@ -11,13 +11,14 @@
using Newtonsoft.Json.Linq;
using static Gs.Toolbox.UtilityHelper;
namespace Gs.QiTaCk
{
namespace Gs.QiTaCk;
    [ApiGroup(ApiGroupNames.QTCK)]
    public class MesCgthSqManager : IRomteService
    {
        private readonly IHttpContextAccessor _http;
        private readonly string _userCode, _userGuid, _orgFids;
        public MesCgthSqManager(IHttpContextAccessor httpContextAccessor)
        {
            _http = httpContextAccessor;
@@ -118,7 +119,6 @@
                    m = dr.RowToDynamic();
                    var _tb = dset.Tables[1].TableToDynamicList();
                    m.list = _tb;
                }
            }
            catch (Exception ex)
@@ -133,7 +133,6 @@
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="mode"></param>
        /// <returns></returns>
@@ -142,7 +141,7 @@
        {
            string _guid = mode.guid;
            string _inFieldValue = mode.inFieldValue;
            string _proName = "prc_cgthsq_submit";
        var _proName = "prc_cgthsq_submit";
            dynamic m = new ExpandoObject();
            m.outSum = -1;
            m.outMsg = "";
@@ -174,9 +173,11 @@
                    }
                    catch (Exception ex)
                    {
                        LogHelper.Debug(ToString(), "prc_cgthsq_submit error:" + ex.Message);
                    LogHelper.Debug(ToString(),
                        "prc_cgthsq_submit error:" + 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
                    {
@@ -184,6 +185,7 @@
                    }
                }
            }
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功!");
        }
@@ -206,8 +208,8 @@
            string fPurchaseDeptId = model.fPurchaseDeptId;
            string fPurchaserId = model.fPurchaserId;
            string fOwnerIdHead = model.fOwnerIdHead;
            StringBuilder _sb = new StringBuilder();
            string _split = "|";
        var _sb = new StringBuilder();
        var _split = "|";
            foreach (var m in model.list)
            {
                string _guid = m.Guid.ToString();
@@ -216,11 +218,14 @@
                    + m.Bz + _split
                    + m.DepotId + _split
                    + m.ItemId + _split
                    + (UtilityHelper.CheckGuid(_guid) ? _guid : Guid.Empty.ToString());
                                    + (CheckGuid(_guid)
                                        ? _guid
                                        : Guid.Empty.ToString());
                if (_sb.Length > 0)
                    _sb.Append("~");
                _sb.Append(_line);
            }
            dynamic mObj = new ExpandoObject();
            mObj.outMsg = "";
            mObj.outSum = -1;
@@ -240,7 +245,8 @@
                        new("@outSum", SqlDbType.Int),
                        new("@outGuid", SqlDbType.UniqueIdentifier),
                        new("@outNo", SqlDbType.NVarChar, 300),
                        new("@inOrderGuid",UtilityHelper.CheckGuid(guid) ? guid: DBNull.Value),
                        new("@inOrderGuid",
                            CheckGuid(guid) ? guid : DBNull.Value),
                        new("@inBz", bz),
                        new("@inGysId", gysId),
                        new("@Fmrmode", Fmrmode),
@@ -279,9 +285,12 @@
                    }
                }
            }
            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);
        }
        /// <summary>
@@ -310,7 +319,7 @@
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inOrderGuid",
                            UtilityHelper.CheckGuid(guid)
                            CheckGuid(guid)
                                ? guid
                                : DBNull.Value),
                        new("@inEdtUserGuid", _userGuid),
@@ -394,9 +403,12 @@
            }
            catch (Exception ex)
            {
                LogHelper.Debug(ToString(), "prc_cgthsq_select error:" + ex.Message);
                return ReturnDto<PageList<dynamic>>.QuickReturn(default(PageList<dynamic>), ReturnCode.Exception, "读取失败");
            LogHelper.Debug(ToString(),
                "prc_cgthsq_select error:" + ex.Message);
            return ReturnDto<PageList<dynamic>>.QuickReturn(
                default(PageList<dynamic>), ReturnCode.Exception, "读取失败");
            }
            var _pglist = new PageList<dynamic>
            {
                total = 0,
@@ -418,13 +430,13 @@
                var _dy = dset.Tables[0].TableToDynamicList();
                _pglist.list = _dy;
            }
            return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
                ReturnCode.Success, "读取成功");
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
@@ -440,6 +452,7 @@
                    sbLine.Append(",");
                sbLine.Append(str);
            }
            var lst = new List<dynamic>();
            var dset = new DataSet();
            using (var conn = new SqlConnection(DbHelperSQL.strConn))
@@ -479,7 +492,5 @@
                lst = dset.Tables[0].TableToDynamicList();
            return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Success,
                "读取成功!");
        }
    }
}