public ActionResult MyOrder()
{
string uid = Session["memberID"].ToString();
OrderBuss oBll = new OrderBuss();
MyOrderInfo info = oBll.GetMyorder(uid);
return(View(info));
}
/// <summary>
/// 我的订单
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public MyOrderInfo GetMyorder(string uid)
{
MyOrderInfo info = new MyOrderInfo();
string orderSql = " select * from [Order] where Uid={0} order by OrderTime desc";
List <DAO.Order> oList = db.Database.SqlQuery <DAO.Order>(string.Format(orderSql, uid)).ToList();
string opSql = " SELECT * FROM [OrderProList] where [OrderId] in (select [OrderId] from [order] where Uid={0})";
List <DAO.OrderProList> opList = db.Database.SqlQuery <DAO.OrderProList>(string.Format(opSql, uid)).ToList();
string imgSql = "select * from [ImgStock] where id in ( SELECT id FROM [ImgStock] where [PartID] in (select ProductID from OrderProList where [OrderId] in (select [OrderId] from [order] where Uid={0})))";
List <DAO.ImgStock> imgList = db.Database.SqlQuery <DAO.ImgStock>(string.Format(imgSql, uid)).ToList();
info.orderList = oList;
info.opList = opList;
info.pimgList = imgList;
return(info);
}
