显式转换类型

快乐的昕的电脑

2025-10-16 02d60b1885ae6b27822e01c95ff2e19fb3b6ac22

 Services/WomdaaManager.cs

@@ -160,7 +160,6 @@

        VOrdrerBycl.wjQty = VOrdrerBycl.Daa008 - VOrdrerBycl.Daa011;

        //DevMachine
        var devMachine = Db.Queryable<DevMacBycl>()
            .Where(s => s.MachineNo == VOrdrerBycl.MachineNo)
            .First();
@@ -170,9 +169,21 @@
            devMachine.UniqueBarcode);

        var sqlQuerySingle = Db.Ado.SqlQuerySingle<string>(sql);

        VOrdrerBycl.finalResult = sqlQuerySingle;

        // 新增：查询最早与最新数采记录
        var baseQuery = Db.Queryable<MesNumericalBycl>()
            .Where(n => n.OrderId == Convert.ToDecimal(query.OrderId) && n.MachineNo == VOrdrerBycl.MachineNo);

        var startCjNum = baseQuery.OrderBy(n => n.Id)
            .Select(n => n.CjNum).First();

        var currentCjNum = baseQuery.OrderBy(n => n.Id, OrderByType.Desc)
            .Select(n => n.CjNum).First();

        VOrdrerBycl.StartCjNum = startCjNum ?? 0;
        VOrdrerBycl.CurrentCjNum = currentCjNum ?? 0;

        return VOrdrerBycl;
    }