平板纠正措施单（推送部分暂未完成）

zyf

2025-09-29 263e0e39c18a4ade744b4d1111fe8dc9de7875e8

 MES.Service/service/QC/XJService.cs

@@ -364,6 +364,17 @@
        var items = xjDto.items;
        var userNo = xjDto.userNo;

        var db = SqlSugarHelper.GetInstance();

        var del = db.Deleteable<QsQaItemXj01>()
            .Where(s => s.Pid == xjDto.gid)
            .ExecuteCommand();

        //QsItemIpiItemDetail
        var del1 = db.Deleteable<QsQaItemXj02>()
            .Where(s => s.Gid == xjDto.gid)
            .ExecuteCommand();

        // 数据验证
        var validationResult = ValidateItemsData(items);
        if (!validationResult.isValid)
@@ -726,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;
    }
}