入库检新增销售订单号

zyf

2025-08-22 90e42f99c2b3a4b8226e9a6951c2b7b9a968df10

 MES.Service/service/QC/SJService.cs

@@ -43,6 +43,8 @@

        string[]? lineNo = null;

        int totalCount = 0;

        //if (StringUtil.IsNotNullOrEmpty(queryObj.StatusUser))
        //    lineNo = _baseService.getUserLineNo(queryObj.StatusUser);

@@ -55,14 +57,13 @@
            .WhereIF(
                StringUtil.IsNotNullOrEmpty(queryObj.Result) &&
                "未完成".Equals(queryObj.Result),
                a => a.FSubmit == null)
                a => a.FSubmit == "0")
            .WhereIF(
                StringUtil.IsNotNullOrEmpty(queryObj.Result) &&
                !"未完成".Equals(queryObj.Result),
                a => a.FSubmit != null)
                a => a.FSubmit == "1")
            .OrderBy(a => a.CreateTime, OrderByType.Desc);
             var totalCount = data.Count();
        var items = data.ToPageList(queryObj.PageIndex, queryObj.Limit);
        var items = data.ToPageList(queryObj.PageIndex, queryObj.Limit,ref totalCount);

        return (items, totalCount);
    }
@@ -425,6 +426,20 @@
                .ExecuteCommand();
        });
    }
    
     
    //NOTES
    public int saveNotesPid(QsItem dto)
    {
        return SqlSugarHelper.UseTransactionWithOracle(db =>
        {
            return db.Updateable<QsItemIpiItem>()
                .SetColumns(it =>
                    it.Notes == dto.Remarks) //SetColumns是可以叠加的 写2个就2个字段赋值
                .Where(it => it.Id == dto.pid)
                .ExecuteCommand();
        });
    }

    //孙表修改备注字段
    public int saveRemarksById(QsItem dto)