/// <summary> /// 插入附件订单 /// </summary> /// <param name="aaonPart"></param> /// <param name="description"></param> /// <param name="quantity"></param> /// <param name="listPrice"></param> /// <returns></returns> public static int insertIntoAccessoryOrder(int orderId,string aaonPart, string description, int quantity, decimal listPrice) { using (var context = new AnnonContext()) { try { var accessoryOrder = new AccessoryOrder { OrderId=orderId, Quantity = quantity, PartNo = aaonPart, PartDescription = description, ListPrice=listPrice, Price = quantity * listPrice }; context.AccessoryOrders.Add(accessoryOrder); return context.SaveChanges(); } catch (Exception e) { return -1; } } }
private void button5_Click(object sender, EventArgs e) { if (dataGridView2.Rows.Count > 0) { List<AccessoryOrder> accessoryOrderList = new List<AccessoryOrder>(); for (int i = 0; i < dataGridView2.Rows.Count; i++) { string accOrderId = dataGridView2.Rows[i].Cells["TAccessoryOrderID"].Value.ToString(); string torderId = dataGridView2.Rows[i].Cells["TorderID"].Value.ToString(); string quantity = dataGridView2.Rows[i].Cells["Quantity"].Value.ToString(); string partNo = dataGridView2.Rows[i].Cells["PartNo"].Value.ToString(); string partDescription = dataGridView2.Rows[i].Cells["PartDescription"].Value.ToString(); string listPrice = dataGridView2.Rows[i].Cells["ListPrice"].Value.ToString(); string price = dataGridView2.Rows[i].Cells["Price"].Value.ToString(); AccessoryOrder accessoryOrder = new AccessoryOrder(); accessoryOrder.AccessoryOrderID = Convert.ToInt32(accOrderId); accessoryOrder.OrderId = Convert.ToInt32(torderId); accessoryOrder.Quantity = Convert.ToInt32(quantity); accessoryOrder.PartNo = partNo; accessoryOrder.PartDescription = partDescription; accessoryOrder.ListPrice = Convert.ToDecimal(listPrice); accessoryOrder.Price = Convert.ToDecimal(price); accessoryOrderList.Add(accessoryOrder); } AccessoryBLL.insertAccessories(accessoryOrderList, orderID); } this.Close(); }
/// <summary> /// 插入一条附件记录 /// </summary> /// <param name="accessory"></param> /// <param name="quantity"></param> /// <returns></returns> public static int insertIntoAccessoryOrder(Accessory accessory,int quantity) { using (var context = new AnnonContext()) { try { var accessoryOrder = new AccessoryOrder { Quantity = quantity, PartNo = accessory.PartNo, PartDescription = accessory.PartDescription, ListPrice=accessory.ListPrice, Price = accessory.ListPrice * quantity }; context.AccessoryOrders.Add(accessoryOrder); return context.SaveChanges(); } catch (Exception e) { return -1; } } }