首检巡检入库检验优化

如洲 陈

2025-09-30 af8a3bd6decd62c60993fa2a4d51866eb4d255de

 MES.Service/service/QC/RKJService.cs

@@ -373,6 +373,11 @@
                v => v.Fsubmit == 1)
            .WhereIF(queryObj.fsubmit.HasValue && queryObj.fsubmit.Value == 0,
                v => SqlFunc.IsNull(v.Fsubmit, 0) != 1)
            .WhereIF(!string.IsNullOrEmpty(queryObj.SearchValue),
                v => v.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()) ||
                     v.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) ||
                     v.ReleaseNo.ToLower().Contains(queryObj.SearchValue.ToLower()) ||
                     v.BillNo.ToLower().Contains(queryObj.SearchValue.ToLower()))
            .Select(v => new QsItemOqcReq
            {
                Id = v.Id,
@@ -397,6 +402,7 @@
                Quantity = v.Quantity
            })
            .OrderBy(v => v.CreateDate, OrderByType.Desc)
            .OrderBy(v => v.FcheckDate, OrderByType.Desc)
            .ToPageList(queryObj.PageIndex, queryObj.Limit);
    }

@@ -422,6 +428,11 @@
                v => v.Fsubmit == 1)
            .WhereIF(queryObj.fsubmit.HasValue && queryObj.fsubmit.Value == 0,
                v => SqlFunc.IsNull(v.Fsubmit, 0) != 1)
            .WhereIF(!string.IsNullOrEmpty(queryObj.SearchValue),
                v => v.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()) ||
                     v.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) ||
                     v.ReleaseNo.ToLower().Contains(queryObj.SearchValue.ToLower()) ||
                     v.BillNo.ToLower().Contains(queryObj.SearchValue.ToLower()))
            .Select(v => new QsItemOqcReq
            {
                Id = v.Id,
@@ -446,6 +457,7 @@
                Quantity = v.Quantity
            })
            .OrderBy(v => v.CreateDate, OrderByType.Desc)
            .OrderBy(v => v.FcheckDate, OrderByType.Desc)
            .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);

        return (data, totalCount);