public ActionResult Create(Tab_User Sql) { if (ModelState.IsValid) { try { // TODO: Add insert logic here var db = new DB(); var tab_user = new Tab_User { user_num = Sql.user_num, user_name = Sql.user_name, user_password = md5.MD5Encrypt(Sql.user_password), user_permission = Sql.user_permission, phone = Sql.phone, address = Sql.address }; db.Tab_User.InsertOnSubmit(tab_user); db.SubmitChanges(); return(RedirectToAction("Index")); } catch { return(View(Sql)); } } else { return(View(Sql)); } }
public ActionResult IndexView() { Tab_User u = null; HttpCookie authCookie = Request.Cookies["a"]; // 获取cookie if (authCookie != null) { try { FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value); // 解密 var user = SerializeHelper.FromJson <Tab_User>(ticket.UserData); u = _us.GetUser(user.F_Name, user.F_Password); if (u != null) { } else { return(RedirectToAction("SignOut", "Home")); } } catch (Exception ex) { return(RedirectToAction("SignOut", "Home")); } } var gzh = _gzhs.GetGZH(u.F_Id); ViewBag.gzh = gzh; ViewBag.msg = gzh == null ? "账号没有关联公众号" : ""; return(View()); }
public ActionResult Add() { var id = Request.Form["gid"]; var name = Request.Form["name"]; if (name == null || name.Length < 1 || name.Length > 50) { return(Json(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "长度必须大于1个字符小于50字符" })); } var gid = 0; if (!int.TryParse(id, out gid) || gid == 0) { return(Json(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "公众号ID不存在" })); } Tab_User m = new Tab_User(); m.F_Name = name; m.F_Password = Tools.MD5Encrypt32("123456"); m.GZHId = gid; m.RoleId = 2; // 公众号管理员 var i = _us.AddUser(m); if (i == 1) { return(Json(new DWZJson { statusCode = (int)DWZStatusCode.OK, message = "成功" })); } else if (i == 2) { return(Json(new DWZJson { statusCode = (int)DWZStatusCode.ERROR, message = "登录名已存在" })); } else { return(Json(new DWZJson { statusCode = (int)DWZStatusCode.ERROR, message = "失败" })); } }
public Tab_User GetUser(int uid) { var sql = "SELECT [F_Id], [F_Name], [F_Password], [F_CreateDate] FROM [Tab_User] WHERE F_Id = @F_Id"; using (SqlConnection conn = new SqlConnection(MHConncetionString)) { var list = conn.Query <Tab_User>(sql, new { F_Id = uid }).ToList(); if (list != null && list.Count > 0) { Tab_User u = new Tab_User(); u.F_Id = list[0].F_Id; u.F_Name = list[0].F_Name; u.F_Password = list[0].F_Password; return(u); } else { return(null); } } }
public ActionResult DirView() { var option = new int[] { 20, 50, 100, 200 }; var pageNum = Request.Form["pageNum"]; var numPerPage = Request.Form["numPerPage"]; var id = Request["id"]; var pageIndex = 0; var pageSize = 0; var totalPage = 0; var totalRecord = 0; var mhid = 0; int.TryParse(pageNum, out pageIndex); int.TryParse(numPerPage, out pageSize); int.TryParse(id, out mhid); pageIndex = pageIndex == 0 ? 1 : pageIndex; pageSize = pageSize == 0 ? 50 : pageSize; Tab_User u = null; HttpCookie authCookie = Request.Cookies["a"]; // 获取cookie if (authCookie != null) { try { FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value); // 解密 var user = SerializeHelper.FromJson <Tab_User>(ticket.UserData); u = _us.GetUser(user.F_Name, user.F_Password); if (u != null) { } else { return(RedirectToAction("SignOut", "Home")); } } catch (Exception ex) { return(RedirectToAction("SignOut", "Home")); } } var gzh = _gzhs.GetGZH(u.F_Id); ViewBag.gzh = gzh; var list = _mhs.GetMHImgList(mhid, pageIndex, pageSize, out totalPage, out totalRecord); VM_Page <Tab_MHImg> vm = new VM_Page <Tab_MHImg>(); vm.pageNum = pageIndex; vm.numPerPage = pageSize; vm.totalcount = totalRecord; vm.option = option; vm.list = list; ViewBag.ca = vm; var mh = _ms.GetMH(mhid); ViewBag.mh = mh; ViewBag.ul = _us.GetUserLis(); return(View()); }
public ActionResult Add() { var id = Request.Form["mhid"]; var sort = Request.Form["sort"]; // 章节ID var name = Request.Form["name"]; var gid = 0; Tab_User u = null; HttpCookie authCookie = Request.Cookies["a"]; // 获取cookie if (authCookie != null) { try { FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value); // 解密 var user = SerializeHelper.FromJson <Tab_User>(ticket.UserData); u = _us.GetUser(user.F_Name, user.F_Password); if (u != null) { } else { return(RedirectToAction("SignOut", "Home")); } } catch (Exception ex) { return(RedirectToAction("SignOut", "Home")); } } var gzh = _gzhs.GetGZH(u.F_Id); if (gzh != null) { gid = gzh.F_Id; } if (gid == 0) { // IE浏览器对非ajax请求Content-Type:是json的不友好所以使用View而非Json return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "账号没有关联公众号" })); } int mhid = 0; if (id == null || !int.TryParse(id, out mhid) || mhid == 0) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "漫画ID无效" })); } int zjid = 0; if (sort == null || !int.TryParse(sort, out zjid) || zjid == 0) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "章节ID无效" })); } if (name == null || name.Length > 50) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "章节名称长度必须小于50字符" })); } var img = ""; if (Request.Files.Count > 0 && Request.Files[0].ContentLength > 0 && new string[] { ".gif", ".jpeg", ".jpg", ".png" }.Contains(System.IO.Path.GetExtension(Request.Files[0].FileName.ToLower()))) { var key = QN.MHimg(gid, mhid); var token = QN.GetUploadToken(QN.BUCKET, key); FormUploader fu = new FormUploader(); HttpResult result = fu.UploadStream(Request.Files[0].InputStream, key, token); if (result.Code == 200) { img = key; } } else { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "请为章节内容添加图片" })); } Tab_MHImg m = new Tab_MHImg(); m.F_Name = name; m.F_Img = img != "" ? img : null; m.F_MHId = mhid; m.F_Sort = zjid; m.F_UserId = u.F_Id; var i = _mhs.AddImg(m); if (i == 1) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.OK, message = "成功" })); } else if (i == 2) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "章节重复" })); } else { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "失败" })); } }
public int AddUser(Tab_User m) { var sql = @"INSERT INTO [Tab_User] ([F_Name] ,[F_Password] ,[F_CreateDate]) VALUES (@F_Name ,@F_Password ,@F_CreateDate); SELECT SCOPE_IDENTITY();"; var sql1 = @"INSERT INTO [Tab_User_GZH_Relation] ([F_UserId] ,[F_GZHId]) VALUES (@F_UserId ,@F_GZHId)"; var sql2 = @"INSERT INTO [Tab_User_Role_Relation] ([F_UserId] ,[F_RoleId]) VALUES (@F_UserId ,@F_RoleId)"; var sql3 = "SELECT COUNT(*) FROM Tab_User WHERE F_Name = @F_Name;"; using (SqlConnection conn = new SqlConnection(MHConncetionString)) { conn.Open(); using (SqlTransaction tran = conn.BeginTransaction(IsolationLevel.RepeatableRead)) { var n = conn.ExecuteScalar(sql3, new { F_Name = m.F_Name }, tran); if (Convert.ToInt32(n) > 0) { tran.Rollback(); return(2); } var r = conn.ExecuteScalar(sql, new { F_Name = m.F_Name, F_Password = m.F_Password, F_CreateDate = DateTime.Now }, tran); int uid = 0; if (r != null && int.TryParse(r.ToString(), out uid) && uid > 0) { var a = conn.Execute(sql1, new { F_UserId = uid, F_GZHId = m.GZHId }, tran); var b = conn.Execute(sql2, new { F_UserId = uid, F_RoleId = m.RoleId }, tran); if (a == 1 && b == 1) { tran.Commit(); return(1); } else { tran.Rollback(); return(3); } } else { tran.Rollback(); return(3); } } } }
public ActionResult Add() { var name = Request.Form["name"]; var id = Request.Form["rid"]; if (name == null || name.Length > 50) { return(Json(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "用户名必须小于50个字符" })); } int rid = 0; if (id == null || !int.TryParse(id, out rid) || !new int[] { 2, 3, 4 }.Contains(rid)) { return(Json(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "章节ID无效" })); } Tab_User u = null; HttpCookie authCookie = Request.Cookies["a"]; // 获取cookie if (authCookie != null) { try { FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value); // 解密 var user = SerializeHelper.FromJson <Tab_User>(ticket.UserData); u = _us.GetUser(user.F_Name, user.F_Password); if (u != null) { } else { return(RedirectToAction("SignOut", "Home")); } } catch (Exception ex) { return(RedirectToAction("SignOut", "Home")); } } var gzh = _gzhs.GetGZH(u.F_Id); var gid = 0; if (gzh != null) { gid = gzh.F_Id; } else { return(Json(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "你没有关联公众号不能添加账号" })); } Tab_User uu = new Tab_User(); uu.F_Name = name; uu.F_Password = Tools.MD5Encrypt32("123456"); uu.GZHId = gid; uu.RoleId = rid; var i = _us.AddUser(uu); if (i == 1) { return(Json(new DWZJson { statusCode = (int)DWZStatusCode.OK, message = "成功" })); } else if (i == 2) { return(Json(new DWZJson { statusCode = (int)DWZStatusCode.ERROR, message = "登录名已存在" })); } else { return(Json(new DWZJson { statusCode = (int)DWZStatusCode.ERROR, message = "失败" })); } }
public int AddUser(Tab_User m) { return(ur.AddUser(m)); }
public ActionResult Edit() { var name = Request.Form["name"]; var about = Request.Form["about"]; var gid = 0; Tab_User u = null; HttpCookie authCookie = Request.Cookies["a"]; // 获取cookie if (authCookie != null) { try { FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value); // 解密 var user = SerializeHelper.FromJson <Tab_User>(ticket.UserData); u = _us.GetUser(user.F_Name, user.F_Password); if (u != null) { } else { return(RedirectToAction("SignOut", "Home")); } } catch (Exception ex) { return(RedirectToAction("SignOut", "Home")); } } var gzh = _gzhs.GetGZH(u.F_Id); if (gzh != null) { gid = gzh.F_Id; } if (gid == 0) { // IE浏览器对非ajax请求Content-Type:是json的不友好所以使用View而非Json return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "账号没有关联公众号" })); } if (name != null && name.Length > 200) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "公号名称长度必须小于200字符" })); } if (about != null && about.Length > 4000) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "公号简介长度必须小于4000字符" })); } var logo = ""; if (Request.Files.Count > 0 && Request.Files[0].ContentLength > 0 && new string[] { ".gif", ".jpeg", ".jpg", ".png" }.Contains(System.IO.Path.GetExtension(Request.Files[0].FileName.ToLower()))) { var key = QN.GZHLogo(gid); var token = QN.GetUploadToken(QN.BUCKET, key); FormUploader fu = new FormUploader(); HttpResult result = fu.UploadStream(Request.Files[0].InputStream, key, token); if (result.Code == 200) { logo = key; } } Tab_GongZhongHao g = new Tab_GongZhongHao(); g.F_About = (about != null && about.Length > 0) ? about : null; g.F_Logo = logo != "" ? logo : null; g.F_Id = gid; var i = _gzhs.UpdateGZHInfo(g); if (i == 1) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.OK, message = "成功" })); } else { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "失败" })); } }