菜品资料编辑
菜品资料编辑汇聚了菜品大类和菜品小类的每个菜品,每个菜品都有归属的菜品类别,左边在用树状形态图归类类别。
菜品资料信息:
private void Selectfood()
{
var food = from tbDishesfood in myModel.B_Dishesfood
join tbcuisinesmall in myModel.B_cuisinesmall on tbDishesfood.cuisinesmallID equals tbcuisinesmall.cuisinesmallID
join tbcuisinebig in myModel.B_cuisinebig on tbDishesfood.cuisineID equals tbcuisinebig.cuisineID
join tbDishesunit in myModel.B_Dishesunit on tbDishesfood.dishesunitID equals tbDishesunit.dishesunitID orderby tbDishesfood.dishesfoodID descending
select new foodVo
{
Dishcoding = tbDishesfood.dishcoding,
Dishesfoodname = tbDishesfood.dishesfoodname,
Dishcode = tbDishesfood.dishcode,
Priceone = tbDishesfood.priceone,
Pricetwo = tbDishesfood.pricetwo,
Pricethree = tbDishesfood.pricethree,
CuisineSname = tbcuisinesmall.cuisineSname,
CuisineBname = tbcuisinebig.cuisineBname,
Dishesunitname = tbDishesunit.dishesunitname,
};
foodVos = food.ToList();
}