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