//依照MenuID.DrinkType.DrinkName取出飲料ID public static int PickDrinkID_UseModel2(Add2_Drinks_detail detail, int MenuID, string DrinkType) { NewDrinkDB db = new NewDrinkDB(); int DrinkID = 0; var query = db.MenuDrinks.Where(m => m.MenuID == MenuID && m.DrinkType == DrinkType && m.DrinkName == detail.DrinkName).Select(m => new { ID = m.ID }); foreach (var item in query) { DrinkID = item.ID; } db.Dispose(); return(DrinkID); }
//依照DrinkID,再用DrinkID.SizeID.Price取SizePID public static int PickSizePID_UseDidSidPrice2(Add2_Drinks_detail detail, int DrinkID) { NewDrinkDB db = new NewDrinkDB(); int SizePID = 0; int SizeID = Int32.Parse(detail.SizeTypeM); var query = db.SizeTables.Where(m => m.DrinkID == DrinkID && m.SizeID == SizeID && m.Price == detail.DrinkPrice).Select(m => new { ID = m.ID }); foreach (var item in query) { SizePID = item.ID; } db.Dispose(); return(SizePID); }
//將甜度,冰度,加料加入陣列(新增飲品用) public static List <int> AddDrink_CheckboxNotEmpty2(Add2_Drinks_detail details, string type) { var addItem = new List <int>(); switch (type) { case "sweet": foreach (var item in details.Sweet) { if (item.Selected) { //加到陣列 var DD = Int32.Parse(item.Value); addItem.Add(DD); } else { //跳過 continue; } } break; case "ice": foreach (var item in details.IceHot) { if (item.Selected) { //加到陣列 var DD = Int32.Parse(item.Value); addItem.Add(DD); } else { //跳過 continue; } } break; case "additem": if (details.AddItem != null) { foreach (var item in details.AddItem) { if (item.Selected) { //加到陣列 var DD = Int32.Parse(item.Value); addItem.Add(DD); } else { //跳過 continue; } } } break; default: break; } return(addItem); }