直接查询所有字段

快乐的昕的电脑

2025-09-29 17bda0a9c38e1db95f443901a048adf2c5dfc0ee

直接查询所有字段

 Services/WomdaaManager.cs

@@ -42,27 +42,12 @@
    {
        var list = Db.Queryable<VOrdreBycl>()
            .Where(s => s.Daa018 != "完工" &&
                        s.MachineNo == query.machineNo
            )
            .Select(s => new VOrdreBycl
            {
                ID = s.ID,
                cutterId = s.cutterId,
                cutterName = s.cutterName,
                cutterModel = s.cutterModel
            })
                        s.MachineNo == query.machineNo)
            .ToList();

        // 查询指定机器的工单
        var orders = Db.Queryable<VOrderABycl>()
            .Where(s => s.MachineNo == query.machineNo)
            .Select<VOrdreBycl>(s => new VOrdreBycl
            {
                ID = s.ID,
                cutterId = s.cutterId,
                cutterName = s.cutterName,
                cutterModel = s.cutterModel
            })
            .Select<VOrdreBycl>()
            .ToList();

        list.AddRange(orders);