public ActionResult Add() { var name = Request.Form["name"]; var id = Request.Form["gid"]; 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不存在" })); } HttpCookie authCookie = Request.Cookies["a"]; // 获取cookie FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value); // 解密 var user = SerializeHelper.FromJson <Tab_User>(ticket.UserData); Tab_MHCatalog m = new Tab_MHCatalog(); m.F_Catalog = name; m.F_GZHId = gid; m.F_CreateUser = user.F_Id; int i = _ms.AddMH(m); // 0:没执行;1:执行成功;2:漫画目录名称重复; 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 AddMH(Tab_MHCatalog m) { var sql = @"INSERT INTO [Tab_MHCatalog] ([F_Catalog] ,[F_GZHId] ,[F_CreateUser] ,[F_CreateDate]) VALUES (@F_Catalog ,@F_GZHId ,@F_CreateUser ,@F_CreateDate)"; var sql1 = "SELECT COUNT(*) FROM[Tab_MHCatalog] WHERE[F_Catalog] = @F_Catalog"; using (SqlConnection conn = new SqlConnection(MHConncetionString)) { conn.Open(); using (SqlTransaction tran = conn.BeginTransaction(IsolationLevel.RepeatableRead)) { var a = conn.ExecuteScalar(sql1, new { F_Catalog = m.F_Catalog }, tran); if (0 == Convert.ToInt32(a)) { int r = conn.Execute(sql, new { F_Catalog = m.F_Catalog, F_GZHId = m.F_GZHId, F_CreateUser = m.F_CreateUser, F_CreateDate = DateTime.Now, }, tran); if (r == 1) { tran.Commit(); return(1); } } if (Convert.ToInt32(a) > 0) { tran.Rollback(); return(2); } } } return(0); }
public int UpdateMH(Tab_MHCatalog m) { StringBuilder sql = new StringBuilder(); sql.Append("UPDATE [Tab_MHCatalog]"); sql.Append(" SET [F_Catalog] = @F_Catalog"); sql.Append(" ,[F_GZHId] = @F_GZHId"); if (m.F_Logo != null) { sql.Append(" ,[F_Logo] = @F_Logo"); } sql.Append(" WHERE [F_Id] = @F_Id"); using (SqlConnection conn = new SqlConnection(MHConncetionString)) { return(conn.Execute(sql.ToString(), new { F_Catalog = m.F_Catalog, F_GZHId = m.F_GZHId, F_Id = m.F_Id, F_Logo = m.F_Logo })); } }
public Tab_MHCatalog GetMHGZH(int mhid) { var sql = "SELECT a.F_Id, a.F_Catalog, a.F_GZHId, b.F_GZHName GZHName FROM dbo.Tab_MHCatalog a JOIN dbo.Tab_GongZhongHao b ON a.F_GZHId = b.F_Id WHERE a.F_Id = @F_Id"; using (SqlConnection conn = new SqlConnection(MHConncetionString)) { var list = conn.Query <Tab_MHCatalog>(sql, new { F_Id = mhid }).ToList(); if (list != null && list.Count > 0) { Tab_MHCatalog g = new Tab_MHCatalog(); g.F_Id = list[0].F_Id; g.F_Catalog = list[0].F_Catalog; g.F_GZHId = list[0].F_GZHId; g.GZHName = list[0].GZHName; return(g); } } return(null); }
public Tab_MHCatalog GetMH(int mhid) { var sql = "SELECT [F_Id], [F_Catalog], [F_GZHId], [F_CreateUser], [F_CreateDate] FROM [Tab_MHCatalog] WHERE [F_Id] = @F_Id"; using (SqlConnection conn = new SqlConnection(MHConncetionString)) { var list = conn.Query <Tab_MHCatalog>(sql, new { F_Id = mhid }).ToList(); if (list != null && list.Count > 0) { Tab_MHCatalog g = new Tab_MHCatalog(); g.F_Id = list[0].F_Id; g.F_Catalog = list[0].F_Catalog; g.F_GZHId = list[0].F_GZHId; g.F_CreateUser = list[0].F_CreateUser; g.F_CreateDate = list[0].F_CreateDate; return(g); } } return(null); }
public int UpdateMH(Tab_MHCatalog m) { return(mr.UpdateMH(m)); }
public ActionResult Edit() { var name = Request.Form["name"]; var id1 = Request.Form["gid"]; var id2 = Request.Form["id"]; var about = Request.Form["about"]; if (name == null || name.Length < 1 || name.Length > 50) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "长度必须大于1个字符小于50字符" })); } var gid = 0; if (!int.TryParse(id1, out gid) || gid == 0) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "公众号不存在" })); } var id = 0; if (!int.TryParse(id2, out id) || id == 0) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "漫画不存在" })); } if (about == null || about.Length > 2000) { return(View(new DWZJson() { statusCode = (int)DWZStatusCode.ERROR, message = "漫画简介必须小于2000字符" })); } 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.MHLogo(gid, id); 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_MHCatalog m = new Tab_MHCatalog(); m.F_Catalog = name; m.F_GZHId = gid; m.F_Logo = logo != "" ? logo : null; m.F_Id = id; m.F_About = about; int i = _ms.UpdateMH(m); if (i == 1) { return(View(new DWZJson { statusCode = (int)DWZStatusCode.OK, message = "成功" })); } else { return(View(new DWZJson { statusCode = (int)DWZStatusCode.ERROR, message = "失败" })); } }
/// <summary> /// 0:没执行;1:执行成功;2:目录名称重复; /// </summary> public int AddMH(Tab_MHCatalog m) { return(mr.AddMH(m)); }