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();
}
