// GET: MyOrder
public ActionResult Index(decimal cur_page = 1)
{
userMes = Session["UserMessage"] as UserMessage;
//userMes.id = 35;
if (UserOrder == null)
{
UserOrder = new UserAndOrder();
foreach (TB_ORDER myorder in dbOrd.TB_ORDER)
{
if (myorder.U_ID == userMes.id)
{
OrderAndContains new_order = new OrderAndContains();
new_order.Order = myorder;
new_order.Products = (from a in dbCon.TB_CONTAINS where a.O_ID == myorder.ID select a).ToList();
new_order.Date = myorder.TIME.ToString();
if (new_order.Order.STATE >= 2)
{
UserOrder.Order.Add(new_order);
}
}
}
}
List <OrderMessage> this_page = new List <OrderMessage>();
int allPtr = (int)(cur_page - 1) * 5 + 1;
int thisPtr = 0;
foreach (OrderAndContains myorder in UserOrder.Order)
{
if (allPtr <= UserOrder.Order.Count && thisPtr < 5)
{
this_page.Add(new OrderMessage());
//序号
this_page[thisPtr].index = thisPtr + 1;
//订单号
this_page[thisPtr].order_id = "9000" + myorder.Date.Substring(2, 2) +
("000" + myorder.Order.ID.ToString()).Remove(0, myorder.Order.ID.ToString().Length - 1);
//商铺号
this_page[thisPtr].store_name = dbSto.Database.SqlQuery <string>(
"SELECT NAME FROM TB_STORE WHERE ID = " + myorder.Order.S_ID).ToList().FirstOrDefault();
//商品名
this_page[thisPtr].product_name = dbPro.Database.SqlQuery <string>(
"SELECT NAME FROM TB_PRODUCT WHERE ID = " + myorder.Products[0].P_ID).ToList().FirstOrDefault();
int number = myorder.Products.Count;
if (number > 1)
{
this_page[thisPtr].product_name += "等";
}
//商品图
//总价
this_page[thisPtr].total_price = (decimal)myorder.Order.TOTAL_PRICE;
//状态
if (myorder.Order.STATE == 2)
{
this_page[thisPtr].state = "未支付";
this_page[thisPtr].state_color = "";
}
else if (myorder.Order.STATE == 3)
{
this_page[thisPtr].state = "已付款";
this_page[thisPtr].state_color = "";
}
else if (myorder.Order.STATE == 4)
{
this_page[thisPtr].state = "已发货";
this_page[thisPtr].state_color = "";
}
else if (myorder.Order.STATE == 5)
{
this_page[thisPtr].state = "待评论";
this_page[thisPtr].state_color = "danger";
}
else if (myorder.Order.STATE == 6)
{
this_page[thisPtr].state = "已完成";
this_page[thisPtr].state_color = "success";
}
//创建时间
this_page[thisPtr].time = myorder.Date;
//循环变量
allPtr++;
thisPtr++;
}
}
if (this_page.Count != 0)
{
this_page.FirstOrDefault().page_btn = new List <string>();
for (int i = 0; i < 5; i++)
{
if (i == cur_page - 1)
{
this_page.FirstOrDefault().page_btn.Add("active");
}
else
{
this_page.FirstOrDefault().page_btn.Add("");
}
}
return(View(this_page));
}
else
{
return(RedirectToAction("Index", new { cur_page = 1 }));
}
}
// GET: MyOrder
public ActionResult Index(decimal cur_page = 1)
{
userMes = Session["UserMessage"] as UserMessage;
//userMes.id = 35;
if (UserOrder == null)
{
UserOrder = new UserAndOrder();
foreach (TB_ORDER myorder in dbOrd.TB_ORDER)
{
if (myorder.U_ID == userMes.id)
{
OrderAndContains new_order = new OrderAndContains();
new_order.Order = myorder;
new_order.Products = (from a in dbCon.TB_CONTAINS where a.O_ID == myorder.ID select a).ToList();
new_order.Date = myorder.TIME.ToString();
if (new_order.Order.STATE >= 2)
{
UserOrder.Order.Add(new_order);
}
}
}
}
List<OrderMessage> this_page = new List<OrderMessage>();
int allPtr = (int)(cur_page - 1) * 5 + 1;
int thisPtr = 0;
foreach (OrderAndContains myorder in UserOrder.Order)
{
if (allPtr <= UserOrder.Order.Count && thisPtr < 5)
{
this_page.Add(new OrderMessage());
//序号
this_page[thisPtr].index = thisPtr + 1;
//订单号
this_page[thisPtr].order_id = "9000" + myorder.Date.Substring(2, 2) +
("000" + myorder.Order.ID.ToString()).Remove(0, myorder.Order.ID.ToString().Length - 1);
//商铺号
this_page[thisPtr].store_name = dbSto.Database.SqlQuery<string>(
"SELECT NAME FROM TB_STORE WHERE ID = " + myorder.Order.S_ID).ToList().FirstOrDefault();
//商品名
this_page[thisPtr].product_name = dbPro.Database.SqlQuery<string>(
"SELECT NAME FROM TB_PRODUCT WHERE ID = " + myorder.Products[0].P_ID).ToList().FirstOrDefault();
int number = myorder.Products.Count;
if (number > 1)
{
this_page[thisPtr].product_name += "等";
}
//商品图
//总价
this_page[thisPtr].total_price = (decimal)myorder.Order.TOTAL_PRICE;
//状态
if (myorder.Order.STATE == 2)
{
this_page[thisPtr].state = "未支付";
this_page[thisPtr].state_color = "";
}
else if (myorder.Order.STATE == 3)
{
this_page[thisPtr].state = "已付款";
this_page[thisPtr].state_color = "";
}
else if (myorder.Order.STATE == 4)
{
this_page[thisPtr].state = "已发货";
this_page[thisPtr].state_color = "";
}
else if (myorder.Order.STATE == 5)
{
this_page[thisPtr].state = "待评论";
this_page[thisPtr].state_color = "danger";
}
else if (myorder.Order.STATE == 6)
{
this_page[thisPtr].state = "已完成";
this_page[thisPtr].state_color = "success";
}
//创建时间
this_page[thisPtr].time = myorder.Date;
//循环变量
allPtr++;
thisPtr++;
}
}
if (this_page.Count != 0)
{
this_page.FirstOrDefault().page_btn = new List<string>();
for (int i = 0; i < 5; i++)
{
if (i == cur_page - 1)
{
this_page.FirstOrDefault().page_btn.Add("active");
}
else
{
this_page.FirstOrDefault().page_btn.Add("");
}
}
return View(this_page);
}
else
{
return RedirectToAction("Index", new { cur_page = 1 });
}
}
