//获取地址 public Order Detail(string orderNum) { string ordersql = "select * from [Order] where OrderID='{0}'"; DAO.Order order = db.Database.SqlQuery <DAO.Order>(string.Format(ordersql, orderNum)).FirstOrDefault(); return(order); }
/// <summary> /// 订单详情 /// </summary> /// <param name="uid"></param> /// <param name="orderNum"></param> /// <returns></returns> public OrderDetail OrderDetail(string orderNum) { OrderDetail order = new OrderDetail(); string orderSql = " select * from [Order] where OrderId={0}"; DAO.Order o = db.Database.SqlQuery <DAO.Order>(string.Format(orderSql, orderNum)).FirstOrDefault(); string opSql = " SELECT * FROM [OrderProList] where [OrderId] ={0}"; List <DAO.OrderProList> opList = db.Database.SqlQuery <DAO.OrderProList>(string.Format(opSql, orderNum)).ToList(); string imgSql = "select * from imgstock where partID in (select ProductID from orderProList where orderID={0})"; List <DAO.ImgStock> imgList = db.Database.SqlQuery <DAO.ImgStock>(string.Format(imgSql, orderNum)).ToList(); order.order = o; order.opList = opList; order.pimgList = imgList; return(order); }
/// <summary> /// 发货 /// </summary> /// <param name="bm"></param> /// <returns></returns> public bool SendOrder(SendOrderBM bm) { //asNoTracking DAO.Order order = db.Order.Where(m => m.OrderId == bm.OrderNumber).First();//db.Database.SqlQuery<DAO.Order>(string.Format(sql,bm.OrderNumber)).FirstOrDefault(); if (order != null) { order.SendName = bm.SendName; order.SendNum = bm.SandNumber; if (string.IsNullOrEmpty(bm.SandNumber) && string.IsNullOrEmpty(bm.SendName)) { order.OrderStatus = "未处理"; } else { order.OrderStatus = "已发货"; } var entry = db.Entry(order); if (entry.State == EntityState.Detached) { db.Entry(order).CurrentValues.SetValues(order); } else { db.Entry(order).State = System.Data.EntityState.Modified; } int result = db.SaveChanges(); if (result > 0) { return(true); } else { return(false); } } else { return(false); } }
/// <summary> /// 订单是否存在 /// </summary> /// <param name="model">订单是否存在</param> /// <returns></returns> public DAO.Order selOrderId(string orderId) { DAO.Order order = db.Order.Where(m => m.OrderId == orderId).FirstOrDefault(); return(order); }