cnf
8 天以前 1b3db8f5683373dd8e179b006e7314783dd1f9db
WebApi/Gs.QiTaCk/MesCgthSqManager.cs
@@ -11,14 +11,13 @@
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;
@@ -119,6 +118,7 @@
                m = dr.RowToDynamic();
                var _tb = dset.Tables[1].TableToDynamicList();
                m.list = _tb;
            }
        }
        catch (Exception ex)
@@ -133,6 +133,7 @@
    }
    /// <summary>
        ///
    /// </summary>
    /// <param name="mode"></param>
    /// <returns></returns>
@@ -141,7 +142,7 @@
    {
        string _guid = mode.guid;
        string _inFieldValue = mode.inFieldValue;
        var _proName = "prc_cgthsq_submit";
            string _proName = "prc_cgthsq_submit";
        dynamic m = new ExpandoObject();
        m.outSum = -1;
        m.outMsg = "";
@@ -185,7 +186,6 @@
                }
            }
        }
        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功!");
    }
@@ -199,17 +199,11 @@
    {
        Guid? guid = model.Guid; //主键
        string bz = model.Remark; //备注
        string thOrgId = model.thOrgId; //退货组织
        string gysId = model.SuppId; //供应商
        string Fmrmode = model.Fmrmode; //方式
        string Reason = model.Reason; //原因
        string fHasLink = model.fHasLink;
        string fRequireOrgId = model.fRequireOrgId;
        string fPurchaseDeptId = model.fPurchaseDeptId;
        string fPurchaserId = model.fPurchaserId;
        string fOwnerIdHead = model.fOwnerIdHead;
        var _sb = new StringBuilder();
        var _split = "|";
            StringBuilder _sb = new StringBuilder();
            string _split = "|";
        foreach (var m in model.list)
        {
            string _guid = m.Guid.ToString();
@@ -217,15 +211,11 @@
                                    + m.Quantity + _split
                                    + m.Bz + _split
                                    + m.DepotId + _split
                                    + m.ItemId + _split
                                    + (CheckGuid(_guid)
                                        ? _guid
                                        : Guid.Empty.ToString());
                    + (UtilityHelper.CheckGuid(_guid) ? _guid : Guid.Empty.ToString());
            if (_sb.Length > 0)
                _sb.Append("~");
            _sb.Append(_line);
        }
        dynamic mObj = new ExpandoObject();
        mObj.outMsg = "";
        mObj.outSum = -1;
@@ -245,19 +235,12 @@
                        new("@outSum", SqlDbType.Int),
                        new("@outGuid", SqlDbType.UniqueIdentifier),
                        new("@outNo", SqlDbType.NVarChar, 300),
                        new("@inOrderGuid",
                            CheckGuid(guid) ? guid : DBNull.Value),
                        new("@inOrderGuid",UtilityHelper.CheckGuid(guid) ? guid: DBNull.Value),
                        new("@inBz", bz),
                        new("@inGysId", gysId),
                        new("@Fmrmode", Fmrmode),
                        new("@Reason", Reason),
                        new("@inEdtUserGuid", _userGuid),
                        new("@thOrgId", thOrgId),
                        new("@fHasLink", fHasLink),
                        new("@fRequireOrgId", fRequireOrgId),
                        new("@fPurchaseDeptId", fPurchaseDeptId),
                        new("@fPurchaserId", fPurchaserId),
                        new("@fOwnerIdHead", fOwnerIdHead),
                        new("@inLineList", _sb.ToString())
                    };
                    parameters[0].Direction = ParameterDirection.Output;
@@ -285,12 +268,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);
    }
    /// <summary>
@@ -319,7 +299,7 @@
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inOrderGuid",
                            CheckGuid(guid)
                            UtilityHelper.CheckGuid(guid)
                                ? guid
                                : DBNull.Value),
                        new("@inEdtUserGuid", _userGuid),
@@ -403,12 +383,9 @@
        }
        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,
@@ -430,13 +407,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>
@@ -452,7 +429,6 @@
                sbLine.Append(",");
            sbLine.Append(str);
        }
        var lst = new List<dynamic>();
        var dset = new DataSet();
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
@@ -493,4 +469,6 @@
        return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Success,
            "读取成功!");
    }
    }
}