private void CBoxKeyWord_TextChanged(object sender, EventArgs e) { ComboBox cb = sender as ComboBox; string InputKeyword = cb.Text; if (InputKeyword == "") { return; } MealDTO Mdto = mBll.GetMeals(InputKeyword); if (Mdto.Meals.Count == 0) { return; } foreach (var m in Mdto.Meals) { cb.Items.Add(m); cb.DisplayMember = "Name"; cb.ValueMember = "ID"; } cb.DroppedDown = true; cb.Text = ""; }
public void ShowMeals() { bll = new MealBLL(); if(isSearch) dto = bll.GetMeals(keyword); else dto = bll.GetMeals(); //dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.DataSource = dto.Meals; dataGridView1.Columns["ID"].HeaderText = "餐點編號"; dataGridView1.Columns["Name"].HeaderText = "餐點名稱"; dataGridView1.Columns["Calories"].HeaderText = "卡路里"; dataGridView1.Columns["Image"].Visible = false; dataGridView1.Columns["Nutrient"].Visible = false; dataGridView1.Columns["NutrientID"].HeaderText = "營養ID"; dataGridView1.Columns["Fat"].Visible = false; dataGridView1.Columns["Protein"].Visible = false; dataGridView1.Columns["Carbs"].Visible = false; dataGridView1.Columns["Sugar"].Visible = false; dataGridView1.Columns["VitA"].Visible = false; dataGridView1.Columns["VitB"].Visible = false; dataGridView1.Columns["VitC"].Visible = false; dataGridView1.Columns["VitD"].Visible = false; dataGridView1.Columns["VitE"].Visible = false; dataGridView1.Columns["Na"].Visible = false; dataGridView1.Columns["K"].Visible = false; if (dataGridView2.DataSource != null) { dataGridView2.Columns["ID"].HeaderText = "標籤編號"; dataGridView2.Columns["Name"].HeaderText = "標籤名稱"; } isSearch = false; }
public void ShowNutrient() { NutrientDTO Nutdto = new NutrientDTO(); MealDTO dto = new MealDTO(); MealDetailDTO MDdto = new MealDetailDTO(); //dto = mbll.GetMeals(); if (isSearch) { dto = mbll.GetMeals(keyword); } else { dto = mbll.GetMeals(); } dataGridView1.DataSource = dto.Meals; dataGridView1.Columns["ID"].HeaderText = "餐點編號"; dataGridView1.Columns["Name"].HeaderText = "食物名稱"; dataGridView1.Columns["Calories"].HeaderText = "卡路里"; dataGridView1.Columns["Nutrient"].Visible = false; dataGridView1.Columns["Image"].Visible = false; dataGridView1.Columns["NutrientID"].HeaderText = "營養編號"; dataGridView1.Columns["Fat"].HeaderText = "脂肪"; dataGridView1.Columns["Protein"].HeaderText = "蛋白質"; dataGridView1.Columns["Carbs"].HeaderText = "碳水化合物"; dataGridView1.Columns["Sugar"].HeaderText = "醣"; dataGridView1.Columns["VitA"].HeaderText = "維生素A"; dataGridView1.Columns["VitB"].HeaderText = "維生素B"; dataGridView1.Columns["VitC"].HeaderText = "維生素C"; dataGridView1.Columns["VitD"].HeaderText = "維生素D"; dataGridView1.Columns["VitE"].HeaderText = "維生素E"; dataGridView1.Columns["Na"].HeaderText = "鈉"; dataGridView1.Columns["K"].HeaderText = "鉀"; }
private void btnDelete_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("你確定欲刪除該餐點 " + detail.Name + " ?" , "警告", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { if (bll.HasTags(detail.ID)) { bll.RemoveTags(detail.ID); // Delete tags first. MessageBox.Show("附帶餐點標籤已刪除"); } if (bll.Delete(detail.ID)) // Then delete meals. { nbll.Delete(detail.NutrientID); MessageBox.Show("餐點已刪除"); bll = new MealBLL(); dto = bll.GetMeals(); ShowMeals(); this.textBox1.Clear(); } } }
private void LoadComboBox() { mealDTO = mealBLL.GetMeals(); cmbMeals.DataSource = mealDTO.Meals; cmbMeals.DisplayMember = "Name"; cmbMeals.ValueMember = "ID"; }
private void btnTag_Click(object sender, EventArgs e) { BSFrmTag frm = new BSFrmTag(); this.Hide(); frm.ShowDialog(); this.Visible = true; bll = new MealBLL(); dto = bll.GetMeals(); ShowMeals(); }
private void LoadComboBox() { categoryDTO.CommentCategories = categoryBLL.GetCommentCategories(); cmbCategory.DataSource = categoryDTO.CommentCategories; cmbCategory.DisplayMember = "Name"; cmbCategory.ValueMember = "ID"; mealDTO = mealBLL.GetMeals(); cmbMeals.DataSource = mealDTO.Meals; cmbMeals.DisplayMember = "Name"; cmbMeals.ValueMember = "ID"; }
public void ShowMeals() { bll = new MealBLL(); if (isSearch) { dto = bll.GetMeals(keyword); } else { dto = bll.GetMeals(); } dataGridView1.DataSource = dto.Meals; dataGridView1.Columns["ID"].HeaderText = "餐點編號"; dataGridView1.Columns["Name"].HeaderText = "餐點名稱"; dataGridView1.Columns["Calories"].HeaderText = "卡路里"; if (dataGridView2.DataSource != null) { dataGridView2.Columns["ID"].HeaderText = "標籤編號"; dataGridView2.Columns["Name"].HeaderText = "標籤名稱"; } isSearch = false; }