首检排序

kyy

2025-07-24 799a463b41e84aa265f109035c08892614ea9fd8

首检排序

 MES.Service/Dto/service/SJPageResult.cs

@@ -112,4 +112,5 @@

    [SugarColumn(ColumnName = "FSUBMIT_BY")] //审核人
    public string? SongJ { get; set; }
    public string? Cjr { get; set; } //创建人
}

 MES.Service/Modes/MesQualityStandard.cs

@@ -202,4 +202,9 @@
 /// </summary>
 [SugarColumn(ColumnName = "MEMO")]
    public string Memo { get; set; }
    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "XH")]
    public string Xh { get; set; }
}

 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();