public ActionResult orderDetails(string key)
{
if (isLogin("OrderAudit") || isLogin("AllOrder") || isLogin("UpdateStatus"))
{
Int64 OrderId = Convert.ToInt64(MyBookShop.Models.EncryptHandler.Decrypt(key));
float n = OrderId;
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.orderInfo exitUser = db.orderInfo.Where(b => b.orderId == OrderId).FirstOrDefault();
if (exitUser != null)
{
var orderData = from a in db.orderDetails
join b in db.bookInfo
on a.bookId equals b.bookID
where a.orderId == OrderId
select new
{
b.bookID,
b.bookImg,
b.bookName,
a.bookPrice,
a.buyNum,
};
ViewData["payType"] = exitUser.payType;
ViewData["toAddress"] = exitUser.toAddress;
ViewData["toName"] = exitUser.toName;
ViewData["toPhone"] = exitUser.toPhone;
ViewData["submitTime"] = exitUser.submitTime;
ViewData["orderId"] = exitUser.orderId;
ViewData["statue"] = exitUser.orderState;
ViewData["orderData"] = orderData.ToList();
//var lst1 = db.orderDetails.Where(e => e.orderId == orderId);
return(View());
}
else
{
return(View());
}
}
else
{
return(RedirectToAction("Error", "Manage"));
}
}
public ActionResult OrderProcessing(string toName, string toAddress, string toPhone, string userPay)
{
if (Session["userLogin"] != null)
{
string uName = Session["userLogin"].ToString();
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.orderInfo oi = new Models.orderInfo()
{
submitTime = System.DateTime.Now.ToString(),
toAddress = toAddress,
toName = toName,
toPhone = toPhone,
buyUser = uName,
orderState = "等待系统处理",
payType = userPay
};
db.orderInfo.Add(oi);
db.SaveChanges();
var deleteQuery = db.buyCar.Where(e => e.buyUser == uName);
// var orderId = db.buyCar.Where(e => e.buyUser == uName);
//Models. bCar = db.buyCar.Where(b => b.booksID == id && b.buyUser == uname).FirstOrDefault();
foreach (var item in deleteQuery)
{
Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == item.booksID).FirstOrDefault();
Models.orderDetails od = new Models.orderDetails()
{
orderId = oi.orderId,
bookId = item.booksID,
bookPrice = binfo.bookPrice,
buyNum = item.buyNum
};
db.orderDetails.Add(od);
db.buyCar.Remove(item);
}
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('订单提交成功',function (){location='/My/MyOrder'});}</script>");
return(View());
}
else
{
return(RedirectToAction("otherLogin", "Login", new { m = "My", a = "Settlement" }));
}
}
public ActionResult orderDetails(long orderId)
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
string uName = Session["userLogin"].ToString();
Models.orderInfo exitUser = db.orderInfo.Where(b => b.orderId == orderId && b.buyUser == uName).FirstOrDefault();
if (exitUser != null)
{
var orderData = from a in db.orderDetails
join b in db.bookInfo
on a.bookId equals b.bookID
where a.orderId == orderId
select new
{
b.bookID,
b.bookImg,
b.bookName,
a.bookPrice,
a.buyNum,
};
ViewData["payType"] = exitUser.payType;
ViewData["toAddress"] = exitUser.toAddress;
ViewData["toName"] = exitUser.toName;
ViewData["toPhone"] = exitUser.toPhone;
ViewData["submitTime"] = exitUser.submitTime;
ViewData["orderId"] = exitUser.orderId;
ViewData["statue"] = exitUser.orderState;
ViewData["orderData"] = orderData.ToList();
//var lst1 = db.orderDetails.Where(e => e.orderId == orderId);
return(View());
}
else
{
return(View());
}
}
public ActionResult processOrder(string key)
{
if (isLogin("UpdateStatus"))
{
try
{
string oid = key.Substring(1, key.Length - 1);
Int64 passid = Convert.ToInt64(oid);
string type = key.Substring(0, 1);
string state = "";
switch (type)
{
case "A":
state = "审核通过，等待仓库发货";
break;
case "B":
state = "已取消(用户主动取消)";
break;
case "C":
state = "已取消(后台系统取消)";
break;
case "D":
state = "已完成";
break;
case "E":
state = "状态异常，等待处理";
break;
case "F":
state = "订单作废";
break;
case "G":
state = "其他，等待处理";
break;
case "H":
state = "等待系统处理";
break;
case "I":
state = "已发货，等待用户收货";
break;
case "X":
state = "已退货";
break;
}
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.orderInfo oi = db.orderInfo.Where(e => e.orderId == passid).FirstOrDefault();
string oldState = "";
if (oi != null)
{
oldState = oi.orderState;
oi.orderState = state;
}
db.SaveChanges();
return(Content("状态已成功从【" + oldState + "】变更为【" + state + "】"));
}
catch
{
return(Content("系统错误"));
}
}
else if (isLogin("OrderAudit"))
{
try
{
string oid = key.Substring(1, key.Length - 1);
Int64 passid = Convert.ToInt64(oid);
string type = key.Substring(0, 1);
string state = "";
switch (type)
{
case "A":
state = "审核通过，等待仓库发货";
break;
case "E":
state = "状态异常，等待处理";
break;
}
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.orderInfo oi = db.orderInfo.Where(e => e.orderId == passid).FirstOrDefault();
string oldState = "";
if (oi != null)
{
oldState = oi.orderState;
oi.orderState = state;
}
db.SaveChanges();
return(Content("状态已成功从【" + oldState + "】变更为【" + state + "】"));
}
catch
{
return(Content("系统错误"));
}
}
else
{
return(RedirectToAction("Error", "Manage"));
}
}
public ActionResult OrderProcessing(string toName, string toAddress, string toPhone, string userPay)
{
if (Session["userLogin"] != null)
{
string uName = Session["userLogin"].ToString();
Models.BookShopEntities4 db = new Models.BookShopEntities4();
Models.orderInfo oi=new Models.orderInfo ()
{
submitTime=System.DateTime.Now.ToString(),
toAddress=toAddress,
toName=toName,
toPhone=toPhone,
buyUser=uName,
orderState="等待系统处理",
payType = userPay
};
db.orderInfo.Add(oi);
db.SaveChanges();
var deleteQuery = db.buyCar.Where(e => e.buyUser == uName);
// var orderId = db.buyCar.Where(e => e.buyUser == uName);
//Models. bCar = db.buyCar.Where(b => b.booksID == id && b.buyUser == uname).FirstOrDefault();
foreach (var item in deleteQuery)
{
Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == item.booksID).FirstOrDefault();
Models.orderDetails od = new Models.orderDetails()
{
orderId = oi.orderId,
bookId=item.booksID,
bookPrice=binfo.bookPrice,
buyNum=item.buyNum
};
db.orderDetails.Add(od);
db.buyCar.Remove(item);
}
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('订单提交成功',function (){location='/My/MyOrder'});}</script>");
return View();
}
else
{
return RedirectToAction("otherLogin", "Login", new { m = "My", a = "Settlement" });
}
}
