62,047
社区成员
发帖
与我相关
我的任务
分享
public partial class Operator //管理员
{
[Key]
public int OperatorID { get; set; }
public string OperatorName { get; set; }//登录名
public virtual ICollection<Module> modules { get; set; }
public virtual ICollection<Warehouse> warehouses { get; set; }
}
public partial class Warehouse //仓库
{
[Key]
public int WarehouseID { get; set; }
public string WarehouseName { get; set; }
public int WarehouseStatus { get; set; }//1正常 0禁用
public virtual ICollection<Operator> operators { get; set; }
}
LogisticsDbContext db = new LogisticsDbContext();
var ww = db.operators
.Where(p => p.OperatorID == CurrentOperatorInfo.OperatorID)
.Select(z=>z.warehouses);
List<Warehouse> qq = (List<Warehouse>)ww;
ViewBag.warehouselist = qq;
List<Warehouse> list = new List<Warehouse>(); //创建集合对象
foreach (var item in ww)
{
Warehouse w = new Warehouse(); //创建实体类对象
w.WarehouseID = item["WarehouseID "];
w.WarehouseName = item["WarehouseName "];
list.add(w);
}
ViewBag.warehouselist = list;
List<Warehouse> list = new List<Warehouse>(); //创建集合对象
foreach (var item in ww)
{
Warehouse w = new Warehouse(); //创建实体类对象
w.WarehouseID = ww["WarehouseID "];
w.WarehouseName = ww["WarehouseName "];
list.add(w);
}
ViewBag.warehouselist = list;
这样可以吗 试试 var ww = db.operators
.Where(p => p.OperatorID == CurrentOperatorInfo.OperatorID)
.Select(z=>z.warehouses);
这里面返回的是Warehouse集合吗? 你就强转?