//复制一条订单; 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; } } }