namespace SubscriptionWebsite.PlaceHolders
{
public class TreeData
{
public int ID { get; set; }
public int? ParentLocationID { get; set; }
public string name { get; set; }
public int? Locationlevel { get; set; }
public string participation { get; set; }
}
}
namespace SubscriptionWebsite.Managers
{
public class TreeDataManager
{
SubscriptionWebsite.Entities.acc_core_dbEntities db = new SubscriptionWebsite.Entities.acc_core_dbEntities();
public List<TreeData> GetTreeData()
{
List<TreeData> Location = db.frm_location.Where(x => !x.Removed && x.Revision == 0).Select(loc => new TreeData
{
ID = loc.ID,
ParentLocationID = loc.ParentLocationID,
name = loc.frm_location_level.SystemId.Equals(5) ? loc.frm_location_address.FirstOrDefault(c => !c.Removed && c.Revision == 0).Street1 : loc.Name,
Locationlevel = loc.frm_location_level.SystemId,
participation = loc.IsActive ? "Yes" : "No",
}).ToList();
List<TreeData> Meters = db.frm_connection_meter.Where(x => !x.Removed && x.Revision == 0).Select(l => new TreeData
{
Locationlevel = 6,
ID = l.ID,
ParentLocationID = l.frm_location.ID,
name = l.MeterNumber,
participation = l.IsMain ? "Yes" : "No",// change to IsActive after db update
}).ToList();
return Location.AddRange(Meters));
}
}
}
如果我尝试将树数据的两个列表放在一起
return Location.AddRange(Meters));
我收到以下错误:无法将类型"void"隐式转换为System.Collections.Generic.List
我知道的返回类型。添加范围为空(空)但是我怎样才能把这两个列表放在一起呢?
List.AddRange
不返回任何内容,因为它直接修改列表:
Location.AddRange(Meters);
return Location;
如果不想修改它,可以使用 LINQ:
return Location.Concat(Meters).ToList();
但是我不会创建其他两个列表,这更有效:
public List<TreeData> GetTreeData()
{
var locations = db.frm_location
.Where(x => !x.Removed && x.Revision == 0)
.Select(loc => new TreeData
{
ID = loc.ID,
ParentLocationID = loc.ParentLocationID,
name = loc.frm_location_level.SystemId.Equals(5) ? loc.frm_location_address.FirstOrDefault(c => !c.Removed && c.Revision == 0).Street1 : loc.Name,
Locationlevel = loc.frm_location_level.SystemId,
participation = loc.IsActive ? "Yes" : "No",
});
var meters = db.frm_connection_meter
.Where(x => !x.Removed && x.Revision == 0)
.Select(l => new TreeData
{
Locationlevel = 6,
ID = l.ID,
ParentLocationID = l.frm_location.ID,
name = l.MeterNumber,
participation = l.IsMain ? "Yes" : "No",// change to IsActive after db update
});
return locations.Concat(meters).ToList();
}
我遇到了这个问题,因为再次设置结果:
result = result.AddRange(listTestReaders); // wrong
但是我应该只使用 AddRange 方法而不使用 = 赋值
result.AddRange(listTestReaders); // correct