public static int InsertUnitConstraintFromExcel(DataTable dataTable)
{
using (var context = new AnnonContext())
{
try
{
foreach (DataRow dataRow in dataTable.Rows)
{
var accessory = new Accessory
{
Unit = dataRow["Unit"].ToString(),
PartNo = dataRow["PartNo"].ToString(),
PartDescription = dataRow["PartDescription"].ToString(),
Model = dataRow["Model"].ToString(),
Heat = dataRow["Heat"].ToString(),
Cool = dataRow["Cool"].ToString(),
SystemSwitching = dataRow["SystemSwitching"].ToString(),
FanSwitching = dataRow["FanSwitching"].ToString(),
Application = dataRow["Application"].ToString(),
ChangeOver = dataRow["ChangeOver"].ToString(),
Use = dataRow["Use"].ToString(),
ListPrice = Convert.ToDecimal(dataRow["ListPrice"].ToString()),
Type = dataRow["Type"].ToString()
};
context.Accessories.Add(accessory);
}
return context.SaveChanges();
}
catch (Exception e)
{
return -1;
}
}
}
/// <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;
}
}
}