MES.Service/service/QC/XJService.cs
@@ -737,4 +737,23 @@ .ExecuteCommand(); }); } public List<XJBadReason>? GetReason(string billNo) { var db = SqlSugarHelper.GetInstance(); var count = db.Queryable<XJBadReason>().Where(s => s.BillNo == billNo).Count(); if (count <= 0) return null; var reason = db .Queryable<XJBadReason>() .Where(s => s.BillNo == billNo).Select( b => new XJBadReason { Reason = b.Reason }).ToList(); return reason; } }