优化首检巡检生成检验

zyf

2025-10-30 7a783a92137f59a02041d71dcdc8bca7e5a3a0b4

 MES.Service/service/QC/XJService.cs

@@ -186,7 +186,8 @@
                CheckResult = s.CheckResult,
                Remarks = s.Remarks,
                SaleOrder = ca.Caa015,
                DepartName = d.Departmentname
                DepartName = d.Departmentname,
                PlanName = s.PlanName

            }).OrderBy(s => s.CreateDate, OrderByType.Desc);
        var items = query.ToPageList(queryObj.PageIndex, queryObj.Limit,
@@ -777,6 +778,18 @@
        return reason;
    }

    public decimal SavePlan(decimal pid, string PlanName)
    {
        var db = SqlSugarHelper.GetInstance();
        var res = db.Updateable<QsQaItemXj>()
                          .SetColumns(a => a.PlanName == PlanName)
                          .Where(a => a.Id == pid)
                          .ExecuteCommand();

        return res;

    }

    public (decimal?, string?, string?) CreateNew(string? DaaNo, string? userNo, string? planName)
    {
        var db = SqlSugarHelper.GetInstance();