工单查询逻辑优化

快乐的昕的电脑

2025-10-17 c134c9458fbbdd832db93c2e16fe55ff038fcc13

工单查询逻辑优化

 Entites/DbModels/VOrderBycl.cs

@@ -172,6 +172,12 @@
    public string? StaffName { get; set; }

    /// <summary>
    /// 报工时间
    /// </summary>
    [SugarColumn(ColumnName = "BG_DATE")]
    public string? BgDate { get; set; }

    /// <summary>
    /// 工序名称
    /// </summary>
    [SugarColumn(ColumnName = "PROC_NAME")]

 Services/WomdaaManager.cs

@@ -173,7 +173,7 @@
                decimals.Contains(c.ID) &&
                (c.EditDate == date || c.EditDate == null))
            .OrderBy(c => c.EditDate, OrderByType.Desc)
            //.Take(1)
            .Take(1)
            .ToList();

        foreach (var order in orders)
@@ -329,7 +329,7 @@

        var totalCount = query.Count();

        var tbBillList = query.OrderBy((r, s) => r.Id, OrderByType.Desc)
        var tbBillList = query.OrderBy((r, s) => r.BgDate, OrderByType.Desc)
            .Select((r, s) => new MesReportingBgDto
            {
                Id = (long)r.Id,