public int UpdateImg(Tab_MHImg m)
{
var sql = new StringBuilder();
sql.Append("UPDATE [Tab_MHImg]");
sql.Append(" SET [F_Name] = @F_Name");
if (m.F_Img != null)
{
sql.Append(" ,[F_Img] = @F_Img");
}
sql.Append(" ,[F_Sort] = @F_Sort");
sql.Append(" ,[F_UserId] = @F_UserId");
sql.Append(" WHERE [F_Id] = @F_Id");
sql.Append(" AND [F_MHId] = @F_MHId");
using (SqlConnection conn = new SqlConnection(MHConncetionString))
{
return(conn.Execute(sql.ToString(), new
{
F_Name = m.F_Name,
F_Img = m.F_Img,
F_Sort = m.F_Sort,
F_UserId = m.F_UserId,
F_Id = m.F_Id,
F_MHId = m.F_MHId,
}));
}
}
public Tab_MHImg GetImg(int img)
{
var sql = @"SELECT [F_Id]
,[F_Name]
,[F_Img]
,[F_MHId]
,[F_Sort]
,[F_IsEnable]
,[F_UserId]
,[F_CreateDate]
FROM [Tab_MHImg]
WHERE [F_Id] = @F_Id";
using (SqlConnection conn = new SqlConnection(MHConncetionString))
{
var list = conn.Query <Tab_MHImg>(sql, new { F_Id = img }).ToList();
if (list != null && list.Count > 0)
{
Tab_MHImg m = new Tab_MHImg();
m.F_Id = list[0].F_Id;
m.F_Name = list[0].F_Name;
m.F_Img = list[0].F_Img;
m.F_MHId = list[0].F_MHId;
m.F_Sort = list[0].F_Sort;
m.F_IsEnable = list[0].F_IsEnable;
m.F_UserId = list[0].F_UserId;
m.F_CreateDate = list[0].F_CreateDate;
return(m);
}
}
return(null);
}
public int AddImg(Tab_MHImg m)
{
var sql = @"INSERT INTO [Tab_MHImg]
([F_Name]
,[F_Img]
,[F_MHId]
,[F_Sort]
,[F_IsEnable]
,[F_UserId]
,[F_CreateDate])
VALUES
(@F_Name
,@F_Img
,@F_MHId
,@F_Sort
,@F_IsEnable
,@F_UserId
,@F_CreateDate)";
var sql1 = "SELECT COUNT(*) FROM [Tab_MHImg] WHERE [F_MHId] = @F_MHId AND [F_Sort] = @F_Sort";
using (SqlConnection conn = new SqlConnection(MHConncetionString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction(IsolationLevel.RepeatableRead))
{
var a = conn.ExecuteScalar(sql1, new { F_MHId = m.F_MHId, F_Sort = m.F_Sort }, tran);
if (0 == Convert.ToInt32(a))
{
int r = conn.Execute(sql, new
{
F_Name = m.F_Name,
F_Img = m.F_Img,
F_MHId = m.F_MHId,
F_Sort = m.F_Sort,
F_IsEnable = true,
F_UserId = m.F_UserId,
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 UpdateImg(Tab_MHImg m)
{
try
{
return(mr.UpdateImg(m));
}
catch (Exception ex)
{
return(2);
}
}
public int AddImg(Tab_MHImg m)
{
return(mr.AddImg(m));
}
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 = "失败"
}));
}
}
