/// <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;
}
}
}
