ASP.NET核中基于Linq的动态滤波

Question

我是Linq查询中的新手。如果附带的图像中有一个或更多字段为空/为null，我只想使我的过滤动态：

​

​

因为我已经习惯了硬编码查询，所以如果我只选择上面的3项，我就无法导出代码。如何使下面的代码变得动态？

var query = db1.sub_project.Where
            (x =>
                (
                
                (x.sub_project_id == Geotagging_SP_ID && x.sub_project_id != null) &&
                (x.sub_project_name == sub_project_name && x.sub_project_name != null) &&
                (x.cycle_id == Cycle && x.cycle_id != null) &&
                (x.prov_code == Province && x.prov_code != null) &&
                (x.region_code == Region && x.lib_regions.region_code != null) &&
                (x.city_code == Municipality && x.city_code != null) &&
                (x.brgy_code == Barangay && x.brgy_code != null) &&
                (x.lib_project_type.major_classification_id == major_classification_id && x.lib_project_type.major_classification_id != null) &&
                ((x.final_physical_accomplishment >= final_physical_accomplishment_From && x.final_physical_accomplishment != null) && (x.final_physical_accomplishment <= final_physical_accomplishment_To && x.final_physical_accomplishment != null)) &&
                (x.mode_id == mode_ids && x.mode_id != null) &&
                (x.project_type_id == Project_Type && x.project_type_id != null)

                )
                

            ).Select(x => new 
            {
                PkID = x.ID,
                Geotagging_SP_ID = x.sub_project_id, 
                sub_project_name = x.sub_project_name, 
                Project_Type = x.lib_project_type.Name,
                Project = x.lib_modality.name,
                last_updated_date = x.last_updated_date, 
                created_date = x.created_date, 
                sql_Tuning_Final_physical = x.lib_physical_status.Name,
                sql_Tuning_Final_Physical_Accomplishment = x.final_physical_accomplishment,
                Cycle = x.lib_cycle.cycle_name, 
                Region = x.lib_regions.region_name, 
                Province = x.lib_provinces.prov_name, 
                Municipality = x.lib_cities.city_name,
                Barangay = x.lib_brgy.brgy_name
            }).ToList();

            result = query; 

谢谢。

Answer 1

若要执行筛选，请将所有输入参数定义为可空，例如：

public class FilteringParameters
{
   public int? Geotagging_SP_ID { get; set; }
   public string sub_project_name { get; set; }

   //other properties
 }

然后在您的方法中检查筛选器的所有参数，如下所示:如果反对派为空或空，则根据它筛选查询。最后，调用ToList或ToListAsync方法。

public async Task<List<ProjectViewModel>> GetProjectsAsync(FilteringParameters parameters)
{
    var query = db1.sub_project.AsQueryable();

      if (parameters.Geotagging_SP_ID != null)
      {
         query = query.Where(x => x.sub_project_id == parameters.Geotagging_SP_ID);
      }

      if (!string.IsNullOrWhiteSpace(parameters.sub_project_name))
      {
         query = query.Where(x =>x.sub_project_name == parameters.sub_project_name);
      }

     if(parameters.Cycle != null)
      {
         query = query.Where(x => x.cycle_id == parameters.Cycle);
      }


      //etc
      //check other filtering parameters
      //and

   var result = await query.Select(x => new ProjectViewModel
        {
            PkID = x.ID,
            Geotagging_SP_ID = x.sub_project_id,
            sub_project_name = x.sub_project_name,
            Project_Type = x.lib_project_type.Name,
            Project = x.lib_modality.name,
            last_updated_date = x.last_updated_date,
            created_date = x.created_date,
            sql_Tuning_Final_physical = x.lib_physical_status.Name,
            sql_Tuning_Final_Physical_Accomplishment = x.final_physical_accomplishment,
            Cycle = x.lib_cycle.cycle_name,
            Region = x.lib_regions.region_name,
            Province = x.lib_provinces.prov_name,
            Municipality = x.lib_cities.city_name,
            Barangay = x.lib_brgy.brgy_name
        }).ToListAsync();

   return result;
}