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); }