11

啊鑫

2025-08-08 6f717c723b89fa21d4eae181a62697cbe799c250

 MES.Service/service/QC/SJService.cs

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

@@ -394,7 +394,7 @@

        detail.CreateBy = detail.UpdateBy;

        withOracle += autoResult(detail);
        // withOracle += autoResult(detail);

        return withOracle;
    }
@@ -511,4 +511,21 @@
        }
    }

    /// <summary>
    /// 更新QsItemIpiItem的IsPass值
    /// </summary>
    /// <param name="id">QsItemIpiItem的ID</param>
    /// <param name="isPass">IsPass的值(0表示不合格,1表示合格)</param>
    /// <returns>更新影响的行数</returns>
    public int UpdateQsItemIpiItemIsPass(decimal id, decimal isPass)
    {
        return SqlSugarHelper.UseTransactionWithOracle(db =>
        {
            return db.Updateable<QsItemIpiItem>()
                .SetColumns(s => s.IsPass == isPass)
                .Where(s => s.Id == id)
                .ExecuteCommand();
        });
    }

}