/// <summary> /// 添加按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { CanteenOrder canteenOrder = new CanteenOrder(); canteenOrder.CanteenOrderKeyID = Guid.NewGuid().ToString(); canteenOrder.CanteenOrderName = txtCanteenName.Text.Trim(); double money = 0; if (!double.TryParse(txtCanteenOrderMoney.Text.Trim(), out money)) { MessageBox.Show("订单价格处请输入数字!"); return; } canteenOrder.CanteenOrderMoney = money; int count = 0; if (!int.TryParse(txtCanteenOrderCount.Text.Trim(), out count)) { MessageBox.Show("订单数量处青输入数字!"); return; } canteenOrder.CanteenOrderCount = count; CanteenOrderBusinessLogic canteenOrderBusinessLogic = new CanteenOrderBusinessLogic(); if (canteenOrderBusinessLogic.Add(canteenOrder)) { loadAllCantenOrderData(); MessageBox.Show("添加成功"); } }
/// <summary> /// 使用ID查询订单 /// </summary> /// <param name="CanteenOrderKeyID">订单ID</param> /// <returns>订单</returns> public CanteenOrder GetCanteenOrderByKeyID(string CanteenOrderKeyID) { CanteenOrder canteenOrder = new CanteenOrder(); canteenOrder = this.canteenOrderDataContextcontext.CanteenOrder.SingleOrDefault(o => o.CanteenOrderKeyID == CanteenOrderKeyID); return(canteenOrder); }
/// <summary> /// 订单修改 /// </summary> /// <param name="canteenOrder">订单对象</param> /// <returns>修改是否成功</returns> public bool Update(CanteenOrder canteenOrder) { try { this.canteenOrderDataContextcontext.SubmitChanges(); return(true); } catch { return(false); } }
public UpdateCantenOrderForm(string KeyID) { InitializeComponent(); CanteenOrderBusinessLogic canteenOrderBusinessLogic = new CanteenOrderBusinessLogic(); CanteenOrderKeyID = KeyID; CanteenOrder canteenOrder = canteenOrderBusinessLogic.GetCanteenOrderByKeyID(KeyID); txtCanteenName.Text = canteenOrder.CanteenOrderName; txtCanteenOrderCount.Text = canteenOrder.CanteenOrderCount.ToString(); txtCanteenOrderMoney.Text = canteenOrder.CanteenOrderMoney.ToString(); }
/// <summary> /// 添加订单 /// </summary> /// <param name="canteenOrder">订单对象</param> /// <returns>添加是否成功</returns> public bool Add(CanteenOrder canteenOrder) { try { if (canteenOrder != null) { this.canteenOrderDataContextcontext.CanteenOrder.InsertOnSubmit(canteenOrder); this.canteenOrderDataContextcontext.SubmitChanges(); return(true); } else { return(false); } } catch { return(false); } }
/// <summary> /// 根据订单ID删除订单 /// </summary> /// <param name="CanteenOrderKeyID">订单ID</param> /// <returns>删除是否成功</returns> public bool delete(string CanteenOrderKeyID) { try { CanteenOrder canteenOrder = this.canteenOrderDataContextcontext.CanteenOrder.SingleOrDefault(o => o.CanteenOrderKeyID == CanteenOrderKeyID); if (canteenOrder != null) { this.canteenOrderDataContextcontext.CanteenOrder.DeleteOnSubmit(canteenOrder); this.canteenOrderDataContextcontext.SubmitChanges(); return(true); } else { return(false); } } catch { return(false); } }
private void btnUpdate_Click(object sender, EventArgs e) { CanteenOrderBusinessLogic canteenOrderBusinessLogic = new CanteenOrderBusinessLogic(); CanteenOrder canteenOrder = canteenOrderBusinessLogic.GetCanteenOrderByKeyID(CanteenOrderKeyID); canteenOrder.CanteenOrderName = txtCanteenName.Text.Trim(); double money = 0; if (double.TryParse(txtCanteenOrderMoney.Text.Trim(), out money)) { canteenOrder.CanteenOrderMoney = money; } else { MessageBox.Show("订单价格处请输入数字!"); return; } int OrderCount = 0; if (int.TryParse(txtCanteenOrderCount.Text.Trim(), out OrderCount)) { canteenOrder.CanteenOrderCount = OrderCount; } else { MessageBox.Show("订单数量处青输入数字!"); return; } if (canteenOrderBusinessLogic.Update(canteenOrder)) { MessageBox.Show("修改成功!"); } }
public bool delete(CanteenOrder canteenOrder) { return(canteenOrderDataAccess.delete(canteenOrder)); }
public bool Update(CanteenOrder canteenOrder) { return(canteenOrderDataAccess.Update(canteenOrder)); }
public bool Add(CanteenOrder canteenOrder) { return(canteenOrderDataAccess.Add(canteenOrder)); }