public ActionResult BuyCar() { if (Session["userLogin"] != null) { string uName = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); var data = from a in db.buyCar join b in db.bookInfo on a.booksID equals b.bookID where a.buyUser == uName select new { a.sysID, b.bookID, b.bookImg, b.bookName, b.bookPrice, a.buyNum }; //var data = db.buyCar.Where(b => b.buyUser == uName); ViewData["pe"] = data.ToList(); return(View()); } else { return(View()); } }
public ActionResult BuyCar() { if (Session["userLogin"] != null) { string uName = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); var data = from a in db.buyCar join b in db.bookInfo on a.booksID equals b.bookID where a.buyUser == uName select new { a.sysID, b.bookID, b.bookImg, b.bookName, b.bookPrice, a.buyNum }; //var data = db.buyCar.Where(b => b.buyUser == uName); ViewData["pe"] = data.ToList(); return View(); } else { return View(); } }
public ActionResult UpdateRole(string keys, string type) { if (isLogin("RoleSetting")) { try { int key = Convert.ToInt16(Models.EncryptHandler.Decrypt(keys)); Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.adminRole anr = db.adminRole.Where(e => e.sysID == key).FirstOrDefault(); if (anr != null) { if (type == "allow") { anr.isLogin = "******"; } else { anr.isLogin = "******"; } } db.SaveChanges(); return(Content("操作成功")); } catch { return(Content("系统错误")); } } else { return(Content("权限不足")); } }
public static bool isLogin(string aName) { try { string userName = System.Web.HttpContext.Current.Session["adminLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); MyBookShop.Models.adminRole jiance = db.adminRole.Where(a => a.adminId == userName && a.actionName == aName).FirstOrDefault(); if (jiance != null) { if (jiance.isLogin == "允许访问") { return(true); } else { return(false); } } else { return(false); } } catch { return(false); } }
public static bool isLogin(string aName) { try { string userName = System.Web.HttpContext.Current.Session["adminLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); MyBookShop.Models.adminRole jiance = db.adminRole.Where(a => a.adminId == userName && a.actionName == aName).FirstOrDefault(); if (jiance != null) { if (jiance.isLogin == "允许访问") { return true; } else { return false; } } else { return false; } } catch { return false; } }
public ActionResult getNewsContent(int newsId) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); var newsinfo = db.newsInfo.Where(m => m.newsId == newsId).FirstOrDefault(); ViewData["title"] = newsinfo.newsTitle; ViewData["content"] = newsinfo.newsContent; ViewData["time"] = newsinfo.sumitTime; return(View()); }
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 MyDesktop() { if (Session["adminLogin"] != null) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); var orderResult = db.orderInfo.Where(e => e.orderState == "等待系统处理").OrderByDescending(e => e.orderId).ToList(); ViewData["orderCount"] = orderResult.Count; return(View()); } else { return(RedirectToAction("Index", "Manage")); } }
public ActionResult BookDetails(string bookId) { try { int newBookId = Convert.ToInt16(bookId); Models.BookShopEntities4 db = new Models.BookShopEntities4(); var bookDetail = db.bookInfo.Where(a => a.bookID == newBookId).ToList(); return View(bookDetail); } catch { return Content("非法访问"); } }
public ActionResult BookDetails(string bookId) { try { int newBookId = Convert.ToInt16(bookId); Models.BookShopEntities4 db = new Models.BookShopEntities4(); var bookDetail = db.bookInfo.Where(a => a.bookID == newBookId).ToList(); return(View(bookDetail)); } catch { return(Content("非法访问")); } }
public ActionResult addToBuyCar(int id) { if (Session["userLogin"] != null) { string uname = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.bookInfo bi = db.bookInfo.Where(a => a.bookID == id && a.isDel != "Y").FirstOrDefault(); if (bi != null) { Models.buyCar bCar = db.buyCar.Where(b => b.booksID == id && b.buyUser == uname).FirstOrDefault(); string output = ""; if (bCar == null) { Models.buyCar newAdd = new Models.buyCar() { booksID = id, buyNum = 1, buyUser = Session["userLogin"].ToString() }; db.buyCar.Add(newAdd); output = "加入购物车成功"; } else { Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == id).FirstOrDefault(); if (binfo.onlyBuy != null && bCar.buyNum >= binfo.onlyBuy) { bCar.buyNum = binfo.onlyBuy.Value; output = "该商品有限购规则,仅允许购买" + binfo.onlyBuy.Value + "个,已将购物车中该商品数量调整为最大购买数量"; } else { bCar.buyNum += 1; output = "购物车中已存在该商品,商品数量加1"; } } db.SaveChanges(); return(Content(output)); } else { return(Content("该商品已经下架或者商品不存在,无法加入购物车")); } } else { return(Content("尚未登录,无法加入购物车,请先登录")); } }
public ActionResult addToBuyCar(int id) { if (Session["userLogin"] != null) { string uname=Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.bookInfo bi = db.bookInfo.Where(a => a.bookID == id && a.isDel != "Y").FirstOrDefault(); if (bi != null) { Models.buyCar bCar = db.buyCar.Where(b => b.booksID == id && b.buyUser == uname).FirstOrDefault(); string output = ""; if (bCar == null) { Models.buyCar newAdd = new Models.buyCar() { booksID = id, buyNum = 1, buyUser = Session["userLogin"].ToString() }; db.buyCar.Add(newAdd); output = "加入购物车成功"; } else { Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == id).FirstOrDefault(); if (binfo.onlyBuy != null && bCar.buyNum >= binfo.onlyBuy) { bCar.buyNum = binfo.onlyBuy.Value; output = "该商品有限购规则,仅允许购买" + binfo.onlyBuy.Value + "个,已将购物车中该商品数量调整为最大购买数量"; } else { bCar.buyNum += 1; output = "购物车中已存在该商品,商品数量加1"; } } db.SaveChanges(); return Content(output); } else { return Content("该商品已经下架或者商品不存在,无法加入购物车"); } } else { return Content("尚未登录,无法加入购物车,请先登录"); } }
public ActionResult Settlement() { if (Session["userLogin"] != null) { string uName = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); var data = from a in db.buyCar join b in db.bookInfo on a.booksID equals b.bookID where a.buyUser == uName select new { a.sysID, b.bookID, b.bookImg, b.bookName, b.bookPrice, a.buyNum }; var toData = from a in db.toInfo where a.userName == uName select new { a.toTitle, a.toName, a.toAddress, a.toPhone }; double allSum = 0.00; //var data = db.buyCar.Where(b => b.buyUser == uName); foreach (var item in data.ToList()) { allSum += Convert.ToDouble(item.bookPrice) * Convert.ToDouble(item.buyNum); } ViewData["todata"] = toData.ToList(); ViewData["pe"] = data.ToList(); if (allSum <= 0) { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('购物车是空的,无需结算',function (){location='/My/buyCar'});}</script>"); } return(View()); } else { return(RedirectToAction("otherLogin", "Login", new { m = "My", a = "Settlement" })); } }
public ActionResult newBuyCar() { if (Session["userLogin"] != null) { string uName = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); // var data = from b in db.buyCar where b.buyUser =Session["userLogin"].ToString() select b; //db.buyCar; var data = db.buyCar.Where(b => b.buyUser == uName); return(View(data.ToList())); } else { return(View()); } }
public ActionResult adminLogin(string adminName, string adminPwd) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.adminInfo ain = db.adminInfo.Where(e => e.adminName == adminName && e.adminPwd == adminPwd).FirstOrDefault(); if (ain != null) { Session["adminNick"] = ain.adminNick; Session["adminLogin"] = adminName; Session["adminLoginError"] = null; Session["adminSkin"] = ain.adminSkin; return(RedirectToAction("MyDesktop", "Manage")); } else { Session["adminLoginError"] = "账号密码不匹配,请重新尝试"; return(RedirectToAction("Index", "Manage")); } }
public ActionResult adminLogin(string adminName,string adminPwd) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.adminInfo ain = db.adminInfo.Where(e => e.adminName == adminName && e.adminPwd == adminPwd).FirstOrDefault(); if (ain != null) { Session["adminNick"] = ain.adminNick; Session["adminLogin"] = adminName; Session["adminLoginError"] = null; Session["adminSkin"] = ain.adminSkin; return RedirectToAction("MyDesktop", "Manage"); } else { Session["adminLoginError"] = "账号密码不匹配,请重新尝试"; return RedirectToAction("Index", "Manage"); } }
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 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 userReg(string userName, string userPwd, string trueName, string userMail) { Models.BookShopEntities4 db2 = new Models.BookShopEntities4(); Models.userInfo newAdd2 = new Models.userInfo() { userName = userName, userPwd = userPwd, userMail = userMail, userTureName = trueName }; db2.userInfo.Add(newAdd2); int result = db2.SaveChanges(); if (result > 0) { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.msg('注册成功,6秒之后转向登录', {icon: 1,time: 6000}, function(){window.location.href = '/My/Account';})}</script>"); } else { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.msg('注册失败,5秒之后转向首页', {icon: 1,time: 5000}, function(){window.location.href = '/Home/Index';})}</script>"); } return(View()); }
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 changeSkin() { if (Session["adminLogin"] != null) { if (Session["adminSkin"].ToString() == "navbar navbar-default") { Session["adminSkin"] = "navbar navbar-inverse"; } else { Session["adminSkin"] = "navbar navbar-default"; } Models.BookShopEntities4 db = new Models.BookShopEntities4(); string uName = Session["adminLogin"].ToString(); Models.adminInfo admini = db.adminInfo.Where(e => e.adminName == uName).FirstOrDefault(); admini.adminSkin = Session["adminSkin"].ToString(); db.SaveChanges(); return(RedirectToAction("MyDesktop", "Manage")); } else { return(RedirectToAction("Index", "Manage")); } }
public ActionResult updateCartNum(int sysID, int newNum) { if (Session["userLogin"] != null) { string uname = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.buyCar bCar = db.buyCar.Where(b => b.sysID == sysID && b.buyUser == uname).FirstOrDefault(); int id = bCar.booksID; string output = "okay"; Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == id).FirstOrDefault(); if (binfo.isDel != "Y") { if (binfo.onlyBuy != null && newNum >= binfo.onlyBuy) { bCar.buyNum = binfo.onlyBuy.Value; output = "该商品有限购规则,仅允许购买" + binfo.onlyBuy.Value + "个,已将购物车中该商品数量调整为最大购买数量"; } else { bCar.buyNum = newNum; output = "okay"; } } else { bCar.buyNum = 0; output = "该商品已经下架或者不存在,数量自动调整为0个"; } db.SaveChanges(); return(Content(output)); } else { return(Content("会话已失效,请重新登陆后再操作")); } }
public ActionResult NewsEditor(string type, int?newsID) { if (type == "addNews") { if (isLogin("NewsEditor?type=addNews")) { ViewBag.type = type; return(View()); } else { return(RedirectToAction("Error", "Manage")); } } else if (type == "updateNews") { if (isLogin("NewsAdmin")) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); var Result = db.newsInfo.Where(e => e.newsId == newsID).FirstOrDefault(); ViewBag.newsTitle = Result.newsTitle; ViewBag.newsContent = Result.newsContent; ViewBag.NEWSID = Result.newsId; ViewBag.type = type; return(View()); } else { return(RedirectToAction("Error", "Manage")); } } else { return(RedirectToAction("Error", "Manage")); } }
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 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 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 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 NewsOperation(string type,string content,string newsTitle,int? newsID) { if (type == "addNews") { if (isLogin("NewsEditor?type=addNews")) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.newsInfo ni = new Models.newsInfo() { submitId = Session["adminLogin"].ToString(), submitor = Session["adminNick"].ToString(), newsContent = content, newsTitle = newsTitle, sumitTime = DateTime.Now }; db.newsInfo.Add(ni); db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新增动态成功,页面跳转到动态管理',function (){location='/Manage/NewsAdmin'});}</script>"); return View(); } else { return RedirectToAction("Error", "Manage"); } } else { if (isLogin("NewsAdmin")) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); switch (type) { case "deleteNews": try { var dele = db.newsInfo.Where(a => a.newsId == newsID).FirstOrDefault(); db.newsInfo.Remove(dele); db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('删除动态成功',function (){location='/Manage/NewsAdmin'});}</script>"); } catch { } break; case "updateNews": var up = db.newsInfo.Where(a => a.newsId == newsID).FirstOrDefault(); up.newsTitle = newsTitle; up.newsContent = content; db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('动态修改成功',function (){location='/Manage/NewsAdmin'});}</script>"); break; } return View(); } else { return RedirectToAction("Error", "Manage"); } } }
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 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 UpdateRole(string keys,string type) { if (isLogin("RoleSetting")) { try { int key = Convert.ToInt16(Models.EncryptHandler.Decrypt(keys)); Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.adminRole anr = db.adminRole.Where(e => e.sysID == key).FirstOrDefault(); if (anr != null) { if (type == "allow") { anr.isLogin = "******"; } else { anr.isLogin = "******"; } } db.SaveChanges(); return Content("操作成功"); } catch { return Content("系统错误"); } } else { return Content("权限不足"); } }
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 Settlement() { if (Session["userLogin"] != null) { string uName = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); var data = from a in db.buyCar join b in db.bookInfo on a.booksID equals b.bookID where a.buyUser == uName select new { a.sysID, b.bookID, b.bookImg, b.bookName, b.bookPrice, a.buyNum }; var toData = from a in db.toInfo where a.userName == uName select new { a.toTitle, a.toName, a.toAddress, a.toPhone }; double allSum = 0.00; //var data = db.buyCar.Where(b => b.buyUser == uName); foreach (var item in data.ToList()) { allSum += Convert.ToDouble(item.bookPrice) *Convert.ToDouble( item.buyNum); } ViewData["todata"] = toData.ToList(); ViewData["pe"] = data.ToList(); if (allSum<=0) { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('购物车是空的,无需结算',function (){location='/My/buyCar'});}</script>"); } return View(); } else { return RedirectToAction("otherLogin", "Login", new { m = "My", a = "Settlement" }); } }
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 updateCartNum(int sysID,int newNum) { if (Session["userLogin"] != null) { string uname = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.buyCar bCar = db.buyCar.Where(b => b.sysID == sysID && b.buyUser == uname).FirstOrDefault(); int id = bCar.booksID; string output = "okay"; Models.bookInfo binfo = db.bookInfo.Where(b => b.bookID == id).FirstOrDefault(); if (binfo.isDel != "Y") { if (binfo.onlyBuy != null && newNum >= binfo.onlyBuy) { bCar.buyNum = binfo.onlyBuy.Value; output = "该商品有限购规则,仅允许购买" + binfo.onlyBuy.Value + "个,已将购物车中该商品数量调整为最大购买数量"; } else { bCar.buyNum = newNum; output = "okay"; } } else { bCar.buyNum = 0; output = "该商品已经下架或者不存在,数量自动调整为0个"; } db.SaveChanges(); return Content(output); } else { return Content("会话已失效,请重新登陆后再操作"); } }
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 getNewsContent(int newsId) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); var newsinfo = db.newsInfo.Where(m => m.newsId == newsId).FirstOrDefault(); ViewData["title"]=newsinfo.newsTitle; ViewData["content"]=newsinfo.newsContent; ViewData["time"] = newsinfo.sumitTime; 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 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 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 MyDesktop() { if (Session["adminLogin"] != null) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); var orderResult = db.orderInfo.Where(e => e.orderState == "等待系统处理").OrderByDescending(e => e.orderId).ToList(); ViewData["orderCount"] = orderResult.Count; return View(); } else { return RedirectToAction("Index", "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 NewsEditor(string type,int? newsID) { if (type == "addNews") { if (isLogin("NewsEditor?type=addNews")) { ViewBag.type = type; return View(); } else { return RedirectToAction("Error", "Manage"); } } else if (type == "updateNews") { if (isLogin("NewsAdmin")) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); var Result = db.newsInfo.Where(e => e.newsId == newsID).FirstOrDefault(); ViewBag.newsTitle = Result.newsTitle; ViewBag.newsContent = Result.newsContent; ViewBag.NEWSID = Result.newsId; ViewBag.type = type; return View(); } else { return RedirectToAction("Error", "Manage"); } } 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 userReg(string userName, string userPwd, string trueName, string userMail) { Models.BookShopEntities4 db2 = new Models.BookShopEntities4(); Models.userInfo newAdd2 = new Models.userInfo() { userName=userName, userPwd=userPwd, userMail=userMail, userTureName=trueName }; db2.userInfo.Add(newAdd2); int result =db2.SaveChanges(); if (result > 0) { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.msg('注册成功,6秒之后转向登录', {icon: 1,time: 6000}, function(){window.location.href = '/My/Account';})}</script>"); } else { Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.msg('注册失败,5秒之后转向首页', {icon: 1,time: 5000}, function(){window.location.href = '/Home/Index';})}</script>"); } return View(); }
public ActionResult changeSkin() { if (Session["adminLogin"] != null) { if (Session["adminSkin"].ToString() == "navbar navbar-default") { Session["adminSkin"] = "navbar navbar-inverse"; } else { Session["adminSkin"] = "navbar navbar-default"; } Models.BookShopEntities4 db = new Models.BookShopEntities4(); string uName = Session["adminLogin"].ToString(); Models.adminInfo admini = db.adminInfo.Where(e => e.adminName == uName).FirstOrDefault(); admini.adminSkin = Session["adminSkin"].ToString(); db.SaveChanges(); return RedirectToAction("MyDesktop", "Manage"); } else { return RedirectToAction("Index", "Manage"); } }
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 NewsOperation(string type, string content, string newsTitle, int?newsID) { if (type == "addNews") { if (isLogin("NewsEditor?type=addNews")) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); Models.newsInfo ni = new Models.newsInfo() { submitId = Session["adminLogin"].ToString(), submitor = Session["adminNick"].ToString(), newsContent = content, newsTitle = newsTitle, sumitTime = DateTime.Now }; db.newsInfo.Add(ni); db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('新增动态成功,页面跳转到动态管理',function (){location='/Manage/NewsAdmin'});}</script>"); return(View()); } else { return(RedirectToAction("Error", "Manage")); } } else { if (isLogin("NewsAdmin")) { Models.BookShopEntities4 db = new Models.BookShopEntities4(); switch (type) { case "deleteNews": try { var dele = db.newsInfo.Where(a => a.newsId == newsID).FirstOrDefault(); db.newsInfo.Remove(dele); db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('删除动态成功',function (){location='/Manage/NewsAdmin'});}</script>"); } catch { } break; case "updateNews": var up = db.newsInfo.Where(a => a.newsId == newsID).FirstOrDefault(); up.newsTitle = newsTitle; up.newsContent = content; db.SaveChanges(); Response.Write("<script language='javaScript' type='text/javaScript'>window.onload=function(){layer.alert('动态修改成功',function (){location='/Manage/NewsAdmin'});}</script>"); break; } return(View()); } else { return(RedirectToAction("Error", "Manage")); } } }
public ActionResult newBuyCar() { if (Session["userLogin"] != null) { string uName = Session["userLogin"].ToString(); Models.BookShopEntities4 db = new Models.BookShopEntities4(); // var data = from b in db.buyCar where b.buyUser =Session["userLogin"].ToString() select b; //db.buyCar; var data = db.buyCar.Where(b => b.buyUser == uName); return View(data.ToList()); } else { return View(); } }