private void LoadRecipe(int SelectrecipeID) { var s = Delicious.Recipe_Table.Where(A => A.RecipeID == SelectrecipeID).Select(A => new { MemberName = Delicious.Member_Table.Where(B => B.MemberID == A.MemberID).Select(C => C.MemberName).FirstOrDefault(), A.PostTime, A.RecipeName, A.Picture, A.ForHowMany, A.TimeNeed, A.RecipeDescription, A.Views, Ingredients = Delicious.Ingredient_Record_Table.Where(E => E.RecipeID == SelectrecipeID).Select(D => new { IngredientsName = Delicious.Ingredient_Table.Where(G => G.IngredientID == D.IngredientID).Select(H => H.Ingredient).FirstOrDefault(), ForUse = Delicious.Ingredient_Record_Table.Select(I => I.IngredientAmountForUse).FirstOrDefault(), Unt = Delicious.Ingredient_Record_Table.Select(J => J.Unt).FirstOrDefault() }), Steps = Delicious.Steps_Table.Where(K => K.RecipeID == SelectrecipeID).Select(L => new { StepNumber = L.StepsNumber, Step = L.Steps }) }).FirstOrDefault(); if (s.Picture != null) { MemoryStream memory = new MemoryStream(s.Picture); pb_RecipeIMG.Image = Image.FromStream(memory); } lb_Recipename.Text = s.RecipeName; lb_member.Text = s.MemberName; lb_Posttime.Text = $"{s.PostTime}"; lb_Howmany.Text = $"{s.ForHowMany}"; lb_Time.Text = $"{(s.TimeNeed / 60)}分"; tb_RecipeDescription.Text = $"{s.RecipeDescription}"; tb_Ingredients.Text = ""; foreach (var item in s.Ingredients) { tb_Ingredients.Text += $"{item.IngredientsName}{item.ForUse}{item.Unt} "; } dgv_Step.DataSource = s.Steps.ToList(); Delicious.Recipe_Table.Single(r => r.RecipeID == SelectrecipeID).Views++; Delicious.SaveChanges(); lb_View.Text = $"👁{s.Views}"; CCustomerMsg Img = new CCustomerMsg(); //給予Picturebox拖拉 Img.setPicturebox(pb_UploadIMG); }
private void LoadElement() { var RecipeCategoryName = from n in Delicious.RecipeCategory_Table select n.RecipeCategory; var Now = Delicious.Recipe_Table.Where(A => A.RecipeID == NowID).Select(A => A.RecipeCategory_Table.RecipeCategory).FirstOrDefault(); this.cb_RecipeCategory.DataSource = RecipeCategoryName.ToList(); //食譜類別欄資料 this.cb_RecipeCategory.SelectedItem = Now; var IngredientCategoryName = Delicious.IngredientCategory_Table.Select(N => N.IngredientCategory); this.cb_IngredientCategory.DataSource = IngredientCategoryName.ToList(); //食材類別欄 this.cb_IngredientCategory.SelectedItem = 1; CCustomerMsg Img = new CCustomerMsg(); CCustomerMsg Img2 = new CCustomerMsg();//給予Picturebox拖拉 Img.setPicturebox(pb_RecipeIMG); Img2.setPicturebox(pb_StepIMG); }