//获取地址
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);
}
