Update OQC search API functionality

啊鑫

2025-07-29 c53a461aef16902ca78cdb7bd0c62305e2fee809

 MES.Service/service/QC/SJService.cs

@@ -110,6 +110,8 @@
                a => a.ItemCj.Contains(queryObj.ItemCj))
            .WhereIF(!string.IsNullOrEmpty(queryObj.daa001),
                a => a.daa001.Contains(queryObj.daa001))
            .WhereIF(!string.IsNullOrEmpty(queryObj.Cjr),
                a => a.Cjr.Contains(queryObj.Cjr))
            .OrderBy(a => a.BillNo, OrderByType.Desc)
            .ToPageList(queryObj.PageIndex, queryObj.Limit);

@@ -186,7 +188,9 @@

        return db
            .Queryable<MesQualityStandard>()
            .Where(b => b.QsType == "1" && b.ItemId == itemId).Select(b =>
            .Where(b => b.QsType == "1" && b.ItemId == itemId)
            .OrderBy(b => b.Xh) // 按Xh字段升序排序
            .Select(b =>
                new QsItemIpiItem
                {
                    ProjName = b.ProjName,
@@ -448,6 +452,7 @@
                    return db.Updateable<QsItemIpiReq>()
                        .SetColumns(s => s.IsPass == result)
                        .SetColumns(s => s.StatusUser == detail.CreateBy)
                        .SetColumns(s => s.StatusDate== DateTime.Now)
                        .SetColumns(s => s.CompleteTime == DateTime.Now)
                        .Where(s => s.Id == detail.Gid)
                        .ExecuteCommand();