public OrderService() { try { using (var DB = new OrderServiceDB()) { var OrderQuery = DB.MyOrders.Include("OrderDetails").Include("User").Where(m => true); foreach (var o in OrderQuery) { orders.Add(o); } } }catch (Exception e) { Console.WriteLine(e.Message); } }
public void Import(String url) { XmlSerializer xmlImport = new XmlSerializer(typeof(List <Order>)); List <Order> temp; using (FileStream fis = new FileStream(url, FileMode.Open, FileAccess.Read)) temp = (List <Order>)xmlImport.Deserialize(fis); temp.ForEach(p => { this.AddOrder(p); using (var DB = new OrderServiceDB()) { DB.MyOrders.Add(p); DB.MyClients.Add(p.Client); p.OrderDetails.ForEach(m => DB.MyDetails.Add(m)); DB.SaveChanges(); } }); }
public bool AddOrder(Order p) { foreach (Order o in orders) { if (o.Id == p.Id) { Console.WriteLine("已存在编号,添加失败"); return(false); } } orders.Add(p); using (var DB = new OrderServiceDB()) { DB.MyOrders.Add(p); DB.MyClients.Add(p.Client); p.OrderDetails.ForEach(m => DB.MyDetails.Add(m)); DB.SaveChanges(); } Console.WriteLine("添加成功"); IdCount = IdCount > p.Id ? IdCount : p.Id + 1; return(true); }