Mvc当点击不同的口味时,价格改变(数据库设计)
联合语句:var list = (from n in db.Flavor_Table
join b in db.Goods_Table on n.Gid equals b.Gid
join s in db.Price_Table on n.Pid equals s.Pid
select new Logs
{
Gid = b.Gid,
Goods = b.Goods,
Fid = n.Fid,
Flabor = n.Flavor,
Pid = s.Pid,
Price = s.Price
});
本条联合语句是条件查询:
var list = (from n in db.Flavor_Table
join b in db.Goods_Table on n.Gid equals b.Gid
join s in db.Price_Table on n.Pid equals s.Pid
where b.Goods == id
select new Logs
{
Gid = b.Gid,
Goods = b.Goods,
Fid = n.Fid,
Flabor = n.Flavor,
Pid = s.Pid,
Price = s.Price
});
以下图片为表的设计
蓝色字体Logs为类名:如何建见一下图片,记得要建在类库里面
下面字段Price由于是int类型,也不是Id主键的设置,所以你用的时候注意一下,数据类型可能会有点问题,到时你可能要改成一下的红框中的写法