入库检增加检验结果清除

啊鑫

2024-09-26 58787157e2609916c06d3ed7d19b6403e9cd5d31

 MES.Service/service/QC/RKJService.cs

@@ -808,4 +808,29 @@

        return Convert.ToInt32(rkjDto.gid);
    }

    public int cleanReqResult(RKJDto dto)
    {
        if (isRk(dto.gid)) throw new Exception("已有条码入库，不允许清除检验结果");


        return SqlSugarHelper.UseTransactionWithOracle(db =>
        {
            return db.Updateable<QsItemOqcReq>()
                .SetColumns(s => s.FcheckResu == null)
                .Where(s => s.Id == dto.gid).ExecuteCommand();
        });
    }

    private bool isRk(int? gid)
    {
        var db = SqlSugarHelper.GetInstance();
        return db.Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails>(
                (a, b, c) => new JoinQueryInfos(
                    JoinType.Inner, a.BillNo == b.BillNo,
                    JoinType.Inner, b.Id == c.ItemInId
                ))
            .Where((a, b, c) => a.Id == gid)
            .Count() > 0;
    }
}