private PlanFood ToPlanFood(DataRow row) { PlanFood food = new PlanFood(); food.id = (int)row["id"]; food.planName = (string)row["planName"]; food.planFoodid = (int)row["planFoodid"]; food.planFoodname = (string)row["planFoodname"]; food.planFoodCount = (int)row["planFoodCount"]; food.planFoodPrice = (float)row["planFoodPrice"]; food.planFoodUnit = (string)row["planFoodUnit"]; return food; }
public void AddPlanFood(PlanFood planFood) { try { string sql = "INSERT INTO `foodplan`(`planName`,`planFoodid`,`planFoodname`,`planFoodCount`,`planFoodPrice`,`planFoodUnit`)VALUES (@planName,@planFoodid,@planFoodname,@planFoodCount,@planFoodPrice,@planFoodUnit)"; DbUtil.ExecuteNonQuery(sql, new MySqlParameter("@planName", planFood.planName), new MySqlParameter("@planFoodCount", planFood.planFoodCount), new MySqlParameter("@planFoodname", planFood.planFoodname), new MySqlParameter("@planFoodid", planFood.planFoodid), new MySqlParameter("@planFoodPrice", planFood.planFoodPrice), new MySqlParameter("@planFoodUnit", planFood.planFoodUnit)); } catch (Exception ex) { throw new Exception("新增套餐信息失败"+ex.Message); } }
private void AddFood() { string cnName = tbCnName.Text.Trim(); string enName = tbEnName.Text.Trim(); float price = 0.0f; try { price = float.Parse(tbPrice.Text.Trim()); } catch { MessageBox.Show("价格必须是数字"); return; } string unit = cbUnit.Text; string category = cbCategory.Text; if (cnName == "" || enName == "" || unit == "") { MessageBox.Show("餐点名称和单位不能为空"); return; } Food food = new Food(); food.canDiscount = "否"; if (rbCanDiscount.Checked) food.canDiscount = "能"; food.category = category; food.cnName = cnName; food.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); food.delTime = ""; food.des = tbDes.Text.Trim(); food.enName = enName; food.imageUpdateTime = ""; food.isHot = "否"; food.isPlan = "否"; if (cbIsPlan.Checked) { food.isPlan = "是"; // 添加套餐详情 foreach (DataGridViewRow row in dvPlanInfo.Rows) { PlanFood planFood = new PlanFood(); planFood.planFoodCount = Convert.ToInt32(row.Cells["foodcount"].Value); planFood.planFoodid = Convert.ToInt32(row.Cells["foodid"].Value); planFood.planFoodname = row.Cells["name"].Value.ToString(); planFood.planFoodPrice = float.Parse(row.Cells["foodprice"].Value.ToString()); planFood.planName = cnName; planFood.planFoodUnit = row.Cells["foodUnit"].Value.ToString(); PlanFoodService planService = new PlanFoodService(); planService.AddPlanFood(planFood); } } food.needKC = "否"; if (cbKC.Checked) { food.needKC = "是"; // 添加库存信息 } food.needMaterials = "否"; if (cbMaterials.Checked) { food.needMaterials = "是"; // 添加原材料信息 } food.price = price; food.status = "库存"; food.unit = unit; food.updateTime = ""; FoodService service = new FoodService(); int id = service.AddFood(food); if (imagePath != "") { string savePath = @".\image\" + id + ".jpg"; ImageUtil.MakeThumbnail(imagePath, savePath, 500, 350, "H"); } MessageBox.Show("新增餐点信息成功"); this.DialogResult = System.Windows.Forms.DialogResult.OK; }
public FormAddPlan(string planName) { InitializeComponent(); this.planName = planName; planFood = new PlanFood(); }