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