//复制一条订单;
public static int CopyOrder(int orderID)
{
using (var context = new AnnonContext())
{
try
{
var ois = context.ordersinfoes
.Where(s => s.ordersinfoID == orderID)
.First();
ordersinfo oi = new ordersinfo
{
OrderNo=ReturnLastNum()+1,
JobNum = ois.JobNum,
JobName = ois.JobName,
JobDes = ois.JobDes,
Site = ois.Site,
Customer = ois.Customer,
Activity = ois.Activity,
AAonCon = ois.AAonCon,
};
context.ordersinfoes.Add(oi);
return context.SaveChanges();
}
catch (Exception e)
{
return -1;
}
}
}
//插入订单数据;
public static int InsertIntoOrder(int OrderNO, string jobNum, string jobName, string jobDes, int site, string customer, string activity, string aaonCon)
{
using (var context = new AnnonContext())
{
try
{
ordersinfo oi = new ordersinfo
{
OrderNo=OrderNO,
JobNum = jobNum,
JobName = jobName,
JobDes = jobDes,
Site = site,
Customer = customer,
Activity = activity,
AAonCon = aaonCon,
};
context.ordersinfoes.Add(oi);
return context.SaveChanges();
}
catch (Exception e)
{
return -1;
}
}
}
/// <summary>
/// 插入一条订单信息，并且返回其最新orderId
/// </summary>
/// <param name="ordersInfo"></param>
/// <returns></returns>
public static int ImportIntoOrdersInfo(ordersinfo ordersInfo)
{
using (var context = new AnnonContext())
{
try
{
context.ordersinfoes.Add(ordersInfo);
context.SaveChanges();
return ordersInfo.ordersinfoID;
}
catch (Exception e)
{
return -1;
}
}
}
