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