public ActionResult PutVerify([FromBody] Model.WorkInfo workInfo) //修改活动审核情况
{
try
{
var n = DAL.WorkInfo.Instance.UpdateVerify(workInfo);
if (n != 0)
{
return(Json(Result.Ok("审核活动成功", workInfo.workId)));
}
else
{
return(Json(Result.Err("workId不存在")));
}
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("null"))
{
return(Json(Result.Err("作品审核情况不能为空")));
}
else
{
return(Json(Result.Err(ex.Message)));
}
}
}
public ActionResult Put([FromBody] Model.WorkInfo workInfo) //发布活动(添加新活动)，并将src的网站路径删除，防止服务器地址变化时，客户端无法访问
{
workInfo.recommend = "否";
workInfo.workVerify = "待审核";
workInfo.uploadTime = DateTime.Now;
try
{
var n = DAL.WorkInfo.Instance.Update(workInfo);
if (n != 0)
{
return(Json(Result.Ok("修改作品成功", workInfo.workId)));
}
else
{
return(Json(Result.Err("workId不存在")));
}
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("foreign key"))
{
return(Json(Result.Err("作品名称、作品图片、作品审核情况、用户名、是否推荐不能为空")));
}
else
{
return(Json(Result.Err(ex.Message)));
}
}
}
public ActionResult upImg(string id, List<IFormFile> files)
{
var path = System.IO.Path.Combine(_hostingEnvironment.WebRootPath, "img", "Work");
var fileName = $"{path}/{id}";
try
{
var ext = DAL.Upload.Instance.UpImg(files[0], fileName);
if (ext == null)
return Json(Result.Err("请上传图片文件"));
else
{
var file = $"img/Work/{id}{ext}";
Model.WorkInfo workInfo = new Model.WorkInfo();
if (id.StartsWith("i"))
{
workInfo.workId = int.Parse(id.Substring(1));
workInfo.workIntroduction = file;
}
else
{
workInfo.workId = int.Parse(id);
workInfo.workIntroduction = file;
}
var n = DAL.WorkInfo.Instance.UpdateImg(workInfo);
if (n > 0)
return Json(Result.Ok("上传成功"));
else
return Json(Result.Err("请输入正确的作品id"))l
}
}
catch(Exception ex)
{
return Json(Result.Err(ex.Message));
}
}
public ActionResult Post([FromBody] Model.WorkInfo workInfo)
{
workInfo.recommend = "否";
workInfo.workVerify = "待审核";
workInfo.uploadTime = DateTime.Now;
try
{
int n = DAL.WorkInfo.Instance.Add(workInfo);
return(Json(Result.Ok("发布作品成功", n)));
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("foreign key"))
{
if (ex.Message.ToLower().Contains("username"))
{
return(Json(Result.Err("合法用户才能添加记录")));
}
else
{
return(Json(Result.Err("作品所属活动不存在")));
}
}
else if (ex.Message.ToLower().Contains("null"))
{
return(Json(Result.Err("作品名称、作品图片、上传作品时间、作品审核情况、用户名、是否推荐不能为空")));
}
else
{
return(Json(Result.Err(ex.Message)));
}
}
}
public ActionResult Put([FromBody] Model.WorkInfo workInfo)
{
workInfo.recommend = "否";
workInfo.workVerify = "待审核";
workInfo.uploadTime = DateTime.Now;
try
{
var n = DAL.WorkInfo.Instance.Update(workInfo);
if (n != 0)
{
return(Json(Result.Ok("修改作品成功", workInfo.workId)));
}
else
{
return(Json(Result.Err("workId不存在")));
}
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("null"))
{
return(Json(Result.Err("作品名称、作品图片、上传作品时间、作品审核、用户名、是否推荐不能为空")));
}
else
{
return(Json(Result.Err(ex.Message)));
}
}
}
public ActionResult PutRecommend([FromBody] Model.WorkInfo workInfo) //修改活动推荐情况
{
workInfo.recommendTime = DateTime.Now;
try
{
var re = "";
if (workInfo.recommend == "否")
{
re = "取消";
}
var n = DAL.WorkInfo.Instance.UpdateRecommend(workInfo);
if (n != 0)
{
return(Json(Result.Ok($"{re}推荐作品成功", workInfo.workId)));
}
else
{
return(Json(Result.Err("workId不存在")));
}
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("null"))
{
return(Json(Result.Err("推荐作品情况不能为空")));
}
else
{
return(Json(Result.Err(ex.Message)));
}
}
}
public int UpdateRecommend(Model.WorkInfo workInfo)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "update workinfo set recommend=@recommend,recommendTime=@recommendTime where workId=@workId";
return(cn.Execute(sql, workInfo));
}
}
public int UpdateVerify(Model.WorkInfo workInfo)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "update workinfo set workVerify=@workVerify where workId=@workId";
return(cn.Execute(sql, workInfo));
}
}
public int Update(Model.WorkInfo workInfo)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "update workinfo set workName=@workName,workPicture=@workPicture,uploadTime,workIntroduction=@workIntroduction,workVerify=@workVerify," + "userName=@userName,recommend=@recommend,recommendTime=@recommendTime where workId=@workId";
return(cn.Execute(sql, workInfo));
}
}
public int Update(Model.WorkInfo workinfo)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "update workinfo set workName=@workName,workPicture=@workPicture";
return(cn.Execute(sql, workinfo));
}
}
public int Add(Model.WorkInfo workInfo)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "insert into workinfo(workId,workName,workPicture,uploadTime,workIntroduction,workVerify,userName,activityId,recommend,recommendTime)" + "values(@workId,@workName,@workPicture,@uploadTime,@workIntroduction,@workVerify,@userName,@activityId,@recommend,@recommendTime);";
sql += "SELECT @@TDENTITY";
return(cn.ExecuteScalar <int>(sql, workInfo));
}
}
public int UpdateImg(Model.WorkInfo workInfo)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "update workinfo set workPicture=@workPicture where workId=@workId";
if (workInfo.workPicture == null)
{
sql = "update workinfo set workIntroduction=@workIntroduction where workId=@workId";
}
return(cn.Execute(sql, workInfo));
}
}
public ActionResult getPage([FromBody] Model.WorkInfo page)
{
var result = DAL.WorkInfo.Instance.GetPage(page);
if (result.Count() == 0)
{
return(Json(Result.Err("返回记录数为0")));
}
else
{
return(Json(Result.Ok(result)));
}
}
public ActionResult Post([FromBody]Model.WorkInfo workInfo)
{
workInfo.recommend = "否";
workInfo.workVerify = "待审核";
workInfo.uploadTime = DateTime.Now;
try
{
int n = DAL.WorkInfo.Instance.Add(workInfo);
return Json(Result.Ok("发布作品成功", n));
}
catch(Exception ex)
{
if (ex.Message.ToLower().Contains("foreign key"))
if (ex.Message.ToLower().Contains("username"))
return Json(Result.Err("合法用户才能添加记录");
public ActionResult getMyPage([FromBody] Model.WorkInfo page)
{
if (page.userName == null)
{
page.userName = "";
}
var result = DAL.WorkInfo.Instance.GetMyPage(page);
if (result.Count() == 0)
{
return(Json(Result.Err("返回记录数为0")));
}
else
{
return(Json(Result.Ok(result)));
}
}
public ActionResult Put([FromBody] Model.WorkInfo workInfo)
{
workInfo.recommend = "否";
workInfo.workVerify = "待审核";
workInfo.uploadTime = DateTime.Now;
try
{
int n = DAL.WorkInfo.Instance.Add(workInfo);
if (n != 0)
return Json(Result.Ok("修改作品成功", workInfo.workId));
else
return Json(Result.Err("workId不存在"));
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("foreign key"))
return Json(Result.Err("作品名称，作品图片，上传时间、作品审核情况、用户名、是否推荐不能为空"));
else
return Json(Result.Err(ex.Message));
}
}
public ActionResult Put([FromBody]Model.WorkInfo workInfo)
{
workInfo.recommend = "否";
workInfo.workVerify = "待审核";
workInfo.uploadTime = DateTime.Now;
try
{
var n = DAL.WorkInfo.Instance.Update(workInfo);
if (n != 0)
return Json(Result.Ok("修改活动成功", workInfo.activityId));
else
return Json(Result.Err("workId不存在"));
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("null"))
return Json(Result.Err("活动名称、结束时间、活动图片、活动审核情况不能为空"));
else
return Json(Result.Err(ex.Message));
}
}
public int UpdateImg(Model.WorkInfo workinfo)
{
using ()
{
}
}