public ActionResult RoleSetting(int?offset, string keyWords)
{
if (isLogin("RoleSetting"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var roles = db.adminRole.Where(s => s.adminId != "sysAdmin").ToList();
if (keyWords == null || keyWords == "")
{
roles = db.adminRole.Where(s => s.adminId != "sysAdmin").ToList();
}
else
{
offset = 1;
roles = db.adminRole.Where(s => s.adminId != "sysAdmin" && s.adminId.Contains(keyWords)).ToList();
}
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (roles.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel()
{
ControllerName = "Manage", ActionName = "RoleSetting", CurrentIndex = (int)offset, TotalCount = roles.Count, PageSize = 14
};
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = roles.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return(View(bookspageList));
}
else
{
return(View(roles));
}
}
else
{
return(RedirectToAction("Error", "Manage"));
}
}
public ActionResult OrderAudit(int?offset)
{
if (isLogin("OrderAudit"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var orderResult = db.orderInfo.Where(e => e.orderState == "等待系统处理").OrderByDescending(e => e.orderId).ToList();
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
ViewData["orderCount"] = orderResult.Count;
if (orderResult.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel()
{
ControllerName = "Manage", ActionName = "MyDesktop", CurrentIndex = (int)offset, TotalCount = orderResult.Count, PageSize = 10
};
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = orderResult.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return(View(bookspageList));
}
else
{
return(View(orderResult));
}
}
else
{
return(RedirectToAction("Error", "Manage"));
}
}
public ActionResult Index(int?offset)
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var books = db.bookInfo.Where(a => a.isDel != "Y").ToList();
var newsinfo = db.newsInfo.OrderByDescending(m => m.newsId).ToList().Take(5);
ViewData["newsData"] = newsinfo;
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (books.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel()
{
ControllerName = "Home", ActionName = "index", CurrentIndex = (int)offset, TotalCount = books.Count, PageSize = 12
};
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = books.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return(View(bookspageList));
}
else
{
return(View());
}
}
public ActionResult userAdmin(int? offset, string typeValue, string userKEY, string newAdminName, string newAdminPwd, string keyWords,string adminNick)
{
if (isLogin("userAdmin"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin").ToList();
switch (typeValue)
{
case "search":
adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin" && a.adminName.Contains(keyWords)).ToList();
break;
case "deleteUser":
int keys = Convert.ToInt16(MyBookShop.Models.EncryptHandler.Decrypt(userKEY));
MyBookShop.Models.adminInfo ai = db.adminInfo.Where(a => a.adminID == keys).FirstOrDefault();
string uname = ai.adminName;
if (ai != null)
{
db.adminInfo.Remove(ai);
}
var allData = from a in db.adminRole
where a.adminId == uname
select a;
db.adminRole.RemoveRange(allData);
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('删除用户成功',function (){location='/Manage/userAdmin'});}</script>");
adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin").ToList();
break;
case "addUser":
MyBookShop.Models.adminInfo se = db.adminInfo.Where(a => a.adminName == newAdminName).FirstOrDefault();
if (se != null)
{
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('该用户名已经存在，请勿重复',function (){location='/Manage/userAdmin'});}</script>");
}
else if (adminNick == "" || newAdminName==""||newAdminPwd=="")
{
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('相应值不能为空，请输入',function (){location='/Manage/userAdmin'});}</script>");
}
else
{
Models.adminInfo newAdd = new Models.adminInfo()
{
adminNick=adminNick,
adminName = newAdminName,
adminPwd = newAdminPwd,
adminSkin = "navbar navbar-default"
};
db.adminInfo.Add(newAdd);
string[] myMenu =
{ "订单总览","订单审核","订单状态更新","新增动态","管理动态","商品入库","商品库存更新",
"商品资料修改","会员信息查看","会员信息更新","会员状态调整" ,"用户管理","用户权限设定","修改密码"};
string[] myMenuAction =
{ "AllOrder","OrderAudit","UpdateStatus","NewsEditor?type=addNews","NewsAdmin","商品入库","商品库存更新",
"商品资料修改","会员信息查看","会员信息更新","会员状态调整" ,"userAdmin","RoleSetting","changePwd"};
for (int i = 0; i < myMenu.Length; i++)
{
Models.adminRole ar = new Models.adminRole()
{
adminId = newAdminName,
functionName = myMenu[i],
actionName = myMenuAction[i],
isLogin = "******"
};
db.adminRole.Add(ar);
}
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新增用户成功',function (){location='/Manage/userAdmin'});}</script>");
adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin").ToList();
}
break;
case "resetPwd":
int Nkey = Convert.ToInt16(MyBookShop.Models.EncryptHandler.Decrypt(userKEY));
MyBookShop.Models.adminInfo newai = db.adminInfo.Where(a => a.adminID == Nkey).FirstOrDefault();
if (newAdminPwd == "")
{
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新密码不能为空',function (){location='/Manage/userAdmin'});}</script>");
}
else
{
newai.adminPwd = newAdminPwd;
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('重置用户密码成功',function (){location='/Manage/userAdmin'});}</script>");
}
break;
}
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (adminInfo.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel() { ControllerName = "Manage", ActionName = "userAdmin", CurrentIndex = (int)offset, TotalCount = adminInfo.Count, PageSize = 10 };
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = adminInfo.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return View(bookspageList);
}
return View(adminInfo);
}
else
{
return RedirectToAction("Error", "Manage");
}
}
public ActionResult AllOrder(int? offset, string keyWords, string searchType)
{
if (isLogin("AllOrder"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var orderResult = db.orderInfo.OrderByDescending(e => e.orderId).ToList();
if (keyWords != null && searchType != null)
{
switch (searchType)
{
case "orderid":
Int64 newword;
try
{
newword = Convert.ToInt64(keyWords);
}
catch
{
newword = 00;
}
orderResult = db.orderInfo.Where(e => e.orderId == newword).ToList();
break;
case "userName":
orderResult = db.orderInfo.Where(e => e.buyUser.Contains(keyWords)).ToList();
break;
case "toName":
orderResult = db.orderInfo.Where(e => e.toName.Contains(keyWords)).ToList();
break;
case "toPhone":
orderResult = db.orderInfo.Where(e => e.toPhone.Contains(keyWords)).ToList();
break;
}
ViewBag.stype = searchType;
ViewBag.swords = keyWords;
}
else
{
orderResult = db.orderInfo.OrderByDescending(e => e.orderId).ToList();
}
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
ViewData["orderCount"] = orderResult.Count;
if (orderResult.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel() { ControllerName = "Manage", ActionName = "MyDesktop", CurrentIndex = (int)offset, TotalCount = orderResult.Count, PageSize = 10 };
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = orderResult.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return View(bookspageList);
}
else
{
return View(orderResult);
}
}
else
{
return RedirectToAction("Error", "Manage");
}
}
public ActionResult RoleSetting(int? offset, string keyWords)
{
if (isLogin("RoleSetting"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var roles =db.adminRole.Where(s => s.adminId != "sysAdmin").ToList();
if (keyWords == null||keyWords=="")
{
roles = db.adminRole.Where(s => s.adminId != "sysAdmin").ToList();
}
else
{
offset = 1;
roles = db.adminRole.Where(s => s.adminId != "sysAdmin"&&s.adminId.Contains(keyWords)).ToList();
}
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (roles.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel() { ControllerName = "Manage", ActionName = "RoleSetting", CurrentIndex = (int)offset, TotalCount = roles.Count, PageSize = 14 };
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = roles.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return View(bookspageList);
}
else
{
return View(roles);
}
}
else
return RedirectToAction("Error", "Manage");
}
public ActionResult OrderAudit(int? offset)
{
if (isLogin("OrderAudit"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var orderResult = db.orderInfo.Where(e => e.orderState == "等待系统处理").OrderByDescending(e => e.orderId).ToList();
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
ViewData["orderCount"] = orderResult.Count;
if (orderResult.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel() { ControllerName = "Manage", ActionName = "MyDesktop", CurrentIndex = (int)offset, TotalCount = orderResult.Count, PageSize = 10 };
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = orderResult.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return View(bookspageList);
}
else
{
return View(orderResult);
}
}
else
{
return RedirectToAction("Error", "Manage");
}
}
public ActionResult UpdateStatus(int?offset, string keyWords, string searchType)
{
if (isLogin("UpdateStatus"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var orderResult = db.orderInfo.OrderByDescending(e => e.orderId).ToList();
if (keyWords != null && searchType != null)
{
switch (searchType)
{
case "orderid":
Int64 newword;
try
{
newword = Convert.ToInt64(keyWords);
}
catch
{
newword = 00;
}
orderResult = db.orderInfo.Where(e => e.orderId == newword).ToList();
break;
case "userName":
orderResult = db.orderInfo.Where(e => e.buyUser.Contains(keyWords)).ToList();
break;
case "toName":
orderResult = db.orderInfo.Where(e => e.toName.Contains(keyWords)).ToList();
break;
case "toPhone":
orderResult = db.orderInfo.Where(e => e.toPhone.Contains(keyWords)).ToList();
break;
}
ViewBag.stype = searchType;
ViewBag.swords = keyWords;
}
else
{
orderResult = db.orderInfo.OrderByDescending(e => e.orderId).ToList();
}
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
ViewData["orderCount"] = orderResult.Count;
if (orderResult.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel()
{
ControllerName = "Manage", ActionName = "MyDesktop", CurrentIndex = (int)offset, TotalCount = orderResult.Count, PageSize = 10
};
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = orderResult.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return(View(bookspageList));
}
else
{
return(View(orderResult));
}
}
else
{
return(RedirectToAction("Error", "Manage"));
}
}
public ActionResult userAdmin(int?offset, string typeValue, string userKEY, string newAdminName, string newAdminPwd, string keyWords, string adminNick)
{
if (isLogin("userAdmin"))
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin").ToList();
switch (typeValue)
{
case "search":
adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin" && a.adminName.Contains(keyWords)).ToList();
break;
case "deleteUser":
int keys = Convert.ToInt16(MyBookShop.Models.EncryptHandler.Decrypt(userKEY));
MyBookShop.Models.adminInfo ai = db.adminInfo.Where(a => a.adminID == keys).FirstOrDefault();
string uname = ai.adminName;
if (ai != null)
{
db.adminInfo.Remove(ai);
}
var allData = from a in db.adminRole
where a.adminId == uname
select a;
db.adminRole.RemoveRange(allData);
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('删除用户成功',function (){location='/Manage/userAdmin'});}</script>");
adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin").ToList();
break;
case "addUser":
MyBookShop.Models.adminInfo se = db.adminInfo.Where(a => a.adminName == newAdminName).FirstOrDefault();
if (se != null)
{
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('该用户名已经存在，请勿重复',function (){location='/Manage/userAdmin'});}</script>");
}
else if (adminNick == "" || newAdminName == "" || newAdminPwd == "")
{
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('相应值不能为空，请输入',function (){location='/Manage/userAdmin'});}</script>");
}
else
{
Models.adminInfo newAdd = new Models.adminInfo()
{
adminNick = adminNick,
adminName = newAdminName,
adminPwd = newAdminPwd,
adminSkin = "navbar navbar-default"
};
db.adminInfo.Add(newAdd);
string[] myMenu =
{ "订单总览", "订单审核", "订单状态更新", "新增动态", "管理动态", "商品入库", "商品库存更新",
"商品资料修改", "会员信息查看", "会员信息更新", "会员状态调整", "用户管理", "用户权限设定", "修改密码" };
string[] myMenuAction =
{ "AllOrder", "OrderAudit", "UpdateStatus", "NewsEditor?type=addNews", "NewsAdmin", "商品入库", "商品库存更新",
"商品资料修改", "会员信息查看", "会员信息更新", "会员状态调整", "userAdmin", "RoleSetting", "changePwd" };
for (int i = 0; i < myMenu.Length; i++)
{
Models.adminRole ar = new Models.adminRole()
{
adminId = newAdminName,
functionName = myMenu[i],
actionName = myMenuAction[i],
isLogin = "******"
};
db.adminRole.Add(ar);
}
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新增用户成功',function (){location='/Manage/userAdmin'});}</script>");
adminInfo = db.adminInfo.Where(a => a.adminName != "sysAdmin").ToList();
}
break;
case "resetPwd":
int Nkey = Convert.ToInt16(MyBookShop.Models.EncryptHandler.Decrypt(userKEY));
MyBookShop.Models.adminInfo newai = db.adminInfo.Where(a => a.adminID == Nkey).FirstOrDefault();
if (newAdminPwd == "")
{
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新密码不能为空',function (){location='/Manage/userAdmin'});}</script>");
}
else
{
newai.adminPwd = newAdminPwd;
db.SaveChanges();
Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('重置用户密码成功',function (){location='/Manage/userAdmin'});}</script>");
}
break;
}
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (adminInfo.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel()
{
ControllerName = "Manage", ActionName = "userAdmin", CurrentIndex = (int)offset, TotalCount = adminInfo.Count, PageSize = 10
};
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = adminInfo.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return(View(bookspageList));
}
return(View(adminInfo));
}
else
{
return(RedirectToAction("Error", "Manage"));
}
}
public ActionResult Index(int? offset)
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
var books = db.bookInfo.Where(a =>a.isDel!="Y").ToList();
var newsinfo = db.newsInfo.OrderByDescending(m => m.newsId).ToList().Take(5);
ViewData["newsData"] = newsinfo;
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (books.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel() { ControllerName="Home",ActionName = "index", CurrentIndex = (int)offset, TotalCount = books.Count ,PageSize=12};
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = books.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return View(bookspageList);
}
else
return View();
}
public ActionResult MyOrder(int?offset)
{
if (Session["userLogin"] != null)
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
string uName = Session["userLogin"].ToString();
var orderResult = db.orderInfo.Where(e => e.buyUser == uName).OrderByDescending(e => e.orderId).ToList();
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
{
offset = 1;
}
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (orderResult.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel()
{
ControllerName = "My", ActionName = "MyOrder", CurrentIndex = (int)offset, TotalCount = orderResult.Count, PageSize = 3
};
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = orderResult.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return(View(bookspageList));
}
else
{
return(View(orderResult));
}
//var toData = from a in db.orderInfo
// join b in db.orderDetails on a.orderId equals b.orderId
// into temp
// from r in temp.DefaultIfEmpty()
// join s in db.bookInfo on r.bookId equals s.bookID
// where a.buyUser == uName
// select new
// {
// a.buyUser,
// a.orderId,
// a.orderState,
// a.toName,
// a.submitTime,
// a.payType,
// s.bookImg
// };
//var toData = from a in db.orderInfo
// from b in db.orderDetails
// from r in db.bookInfo
// where a.buyUser == uName &b.bookId==r.bookID &a.orderId==b.orderId
// orderby a.submitTime descending
// select new
// {
// a.buyUser,
// a.orderId,
// a.orderState,
// a.toName,
// a.submitTime,
// a.payType,
// r.bookImg,
// b.bookPrice,
// b.buyNum,
// b.bookId,
// r.bookName
// };
//ViewData["orderInfo"] = toData.ToList();
}
else
{
return(RedirectToAction("otherLogin", "Login", new { m = "My", a = "MyOrder" }));
}
}
public ActionResult MyOrder(int? offset)
{
if (Session["userLogin"] != null)
{
Models.BookShopEntities4 db = new Models.BookShopEntities4();
string uName = Session["userLogin"].ToString();
var orderResult = db.orderInfo.Where(e => e.buyUser == uName).OrderByDescending(e=>e.orderId).ToList();
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (offset == null)
offset = 1;
//通过指定路径将查询结果返回给指定视图（指定不同控制器的路径中必须包括View文件的后缀cshtml）
if (orderResult.Count > 0)
{
//创建分页模型类对象
Models.BasePageModel page =
new Models.BasePageModel() { ControllerName = "My", ActionName = "MyOrder", CurrentIndex = (int)offset, TotalCount = orderResult.Count, PageSize = 3 };
//获取指定页码的图书数据集合（Ship是跳过指定数量的元素，返回剩余的元素，Take是返回指定数量的连续元素
var bookspageList = orderResult.Skip((page.CurrentIndex - 1) * page.PageSize).Take(page.PageSize).ToList();
//向视图传递分页对象
ViewData["pagemodel"] = page;
//返回视图，传递当前页图书数据
return View(bookspageList);
}
else {
return View(orderResult);
}
//var toData = from a in db.orderInfo
// join b in db.orderDetails on a.orderId equals b.orderId
// into temp
// from r in temp.DefaultIfEmpty()
// join s in db.bookInfo on r.bookId equals s.bookID
// where a.buyUser == uName
// select new
// {
// a.buyUser,
// a.orderId,
// a.orderState,
// a.toName,
// a.submitTime,
// a.payType,
// s.bookImg
// };
//var toData = from a in db.orderInfo
// from b in db.orderDetails
// from r in db.bookInfo
// where a.buyUser == uName &b.bookId==r.bookID &a.orderId==b.orderId
// orderby a.submitTime descending
// select new
// {
// a.buyUser,
// a.orderId,
// a.orderState,
// a.toName,
// a.submitTime,
// a.payType,
// r.bookImg,
// b.bookPrice,
// b.buyNum,
// b.bookId,
// r.bookName
// };
//ViewData["orderInfo"] = toData.ToList();
}
else
{
return RedirectToAction("otherLogin", "Login", new { m = "My", a = "MyOrder" });
}
}
