其他出入库代码修改

kyy

2025-10-17 22af5601e0a619b5032aa7fd07d3a3393efad0f7

其他出入库代码修改

 service/Warehouse/MesItemQtManager.cs

@@ -20,15 +20,15 @@
    /// <returns>退料单号列表</returns>
    public dynamic GetPendingQtList(dynamic RequestInfo)
     {
        var orgId = RequestInfo.OrgId;
        //var orgId = RequestInfo.OrgId;

        if (orgId == null)
            throw new Exception("组织不存在！");
        //if (orgId == null)
        //    throw new Exception("组织不存在！");

        // 获取未完成的退料单号列表
        var parameters = new[]
        {
        new SugarParameter("@pi_orgId", orgId),
        new SugarParameter("@pi_orgId", 1),
        new SugarParameter("@inP1", null),
        new SugarParameter("@inP2", null),
        new SugarParameter("@inP3", null),
@@ -54,15 +54,15 @@
    /// <returns>待处理的退料单明细列表</returns>
    public dynamic GetPendingQtDetailList(dynamic query, dynamic RequestInfo)
    {
        var orgId = RequestInfo.OrgId;
        //var orgId = RequestInfo.OrgId;

        if (orgId == null)
            throw new Exception("组织不存在！");
        //if (orgId == null)
        //    throw new Exception("组织不存在！");

        var parameters = new[]
{
        new SugarParameter("@billNo",query.billNo),
        new SugarParameter("@pi_orgId", orgId),
        new SugarParameter("@pi_orgId", 1),
        new SugarParameter("@inP1", null),
        new SugarParameter("@inP2", null),
        new SugarParameter("@inP3", null),

 service/Warehouse/MesItemQtrkManager.cs

@@ -12,15 +12,15 @@
{
    public dynamic GetQtckList(dynamic RequestInfo)
    {
        var orgId = RequestInfo.OrgId;
        //var orgId = RequestInfo.OrgId;

        if (orgId == null)
            throw new Exception("组织不存在！");
        //if (orgId == null)
        //    throw new Exception("组织不存在！");

        // 获取未完成的退料单号列表
        var parameters = new[]
        {
        new SugarParameter("@pi_orgId", orgId),
        new SugarParameter("@pi_orgId", 1),
        new SugarParameter("@inP1", null),
        new SugarParameter("@inP2", null),
        new SugarParameter("@inP3", null),
@@ -41,15 +41,15 @@

    public dynamic GetQtckDetailList(dynamic query, dynamic RequestInfo)
    {
        var orgId = RequestInfo.OrgId;
        //var orgId = RequestInfo.OrgId;

        if (orgId == null)
            throw new Exception("组织不存在！");
        //if (orgId == null)
        //    throw new Exception("组织不存在！");

        var parameters = new[]
{
        new SugarParameter("@billNo",query.billNo),
        new SugarParameter("@pi_orgId", orgId),
        new SugarParameter("@pi_orgId", 1),
        new SugarParameter("@inP1", null),
        new SugarParameter("@inP2", null),
        new SugarParameter("@inP3", null),
@@ -190,7 +190,7 @@
                    FROM MES_ITEM_QTRR_DETAIL A
                    LEFT JOIN MES_ITEM_QTRK B ON A.qtrkGuid = B.guid
                    LEFT JOIN MES_ITEMS C ON A.itemId = C.item_id
                    WHERE B.qtck = @billNo AND QT015 = 1 AND QT028 = 1 AND QT032 = 1 AND QT014 = 0 ";
                    WHERE B.qtck = @billNo AND QT015 = 1 AND QT014 = 0 ";
        //AND QT014 = 0

        var sqlParams1 = new List<SugarParameter> {