舍入值在LINQ MVC ASP.NET中

Question

我在存档中做了一个查询，想知道如何截断值列以进行比较:

跟随脚本查询:

var query = from ies in db.TB_LV
            where ies.rod_id == nmRod &&
                (ies.km_i) >= vlrkmI &&
                ies.km_f <= vlrkmF &&
                ies.dt_levant == ultLev
            select ies.ies;

， km_i、km_f列的值为十进制值，vlrKmI、vlrKmF列的值为整数值。

我需要截断km_i和km_f列的值到查询。有人有解决办法吗?

Answer 1

要截断km_i和km_f的值，您需要像这样更改查询:

  var query = from ies in db.TB_LV
                where ies.rod_id == nmRod &&
                    (int) ies.km_i >= vlrkmI &&
                    (int) ies.km_f <= vlrkmF &&
                    ies.dt_levant == ultLev
                select ies.ies;