public ActionResult EditArticleType()
{
try
{
var ArticleID = ZNRequest.GetInt("ArticleID");
var TypeID = ZNRequest.GetInt("ArticleType");
if (TypeID <= 0)
{
return(Json(new { result = false, message = "参数异常" }, JsonRequestBehavior.AllowGet));
}
var articleType = AppHelper.GetArticleType().FirstOrDefault <ArticleType>(x => x.ID == TypeID);
if (articleType == null)
{
return(Json(new { result = false, message = "不存在当前类型" }, JsonRequestBehavior.AllowGet));
}
var result = new SubSonic.Query.Update <Article>(provider).Set("TypeID").EqualTo(TypeID).Set("TypeIDList").EqualTo(articleType.ParentIDList).Where <Article>(x => x.ID == ArticleID).Execute() > 0;
if (result)
{
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_EditArticleType:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditArticleTemp()
{
try
{
var ArticleID = ZNRequest.GetInt("ArticleID");
var Template = ZNRequest.GetInt("Template");
var result = new SubSonic.Query.Update <Article>(provider).Set("Template").EqualTo(Template).Where <Article>(x => x.ID == ArticleID).Execute() > 0;
if (result)
{
//取消自定义模板启用
string ArticleNumber = ZNRequest.GetString("ArticleNumber");
if (!string.IsNullOrWhiteSpace(ArticleNumber) && Template != 1)
{
var list = db.Find <Background>(x => x.ArticleNumber == ArticleNumber && x.IsUsed == Enum_Used.Approved).ToList();
if (list.Count > 0)
{
list.ForEach(x =>
{
x.IsUsed = Enum_Used.Audit;
});
db.UpdateMany <Background>(list);
}
}
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_EditArticleTemp:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除
/// </summary>
public ActionResult Delete()
{
try
{
User user = GetUserInfo();
if (user == null)
{
return(Json(new { result = false, message = "用户信息验证失败", code = Enum_ErrorCode.UnLogin }, JsonRequestBehavior.AllowGet));
}
var id = ZNRequest.GetInt("ArticleID");
Article article = db.Single <Article>(x => x.ID == id);
if (article == null)
{
return(Json(new { result = false, message = "文章信息异常" }, JsonRequestBehavior.AllowGet));
}
if (article.CreateUserNumber != user.Number)
{
return(Json(new { result = false, message = "没有权限", code = Enum_ErrorCode.NoPower }, JsonRequestBehavior.AllowGet));
}
var result = new SubSonic.Query.Update <Article>(provider).Set("Status").EqualTo(Enum_Status.Delete).Set("Submission").EqualTo(Enum_Submission.TemporaryApproved).Where <Article>(x => x.ID == article.ID).Execute() > 0;
if (result)
{
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_Delete:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Recommend()
{
try
{
var UserNumber = ZNRequest.GetString("UserNumber");
var ArticleNumber = ZNRequest.GetString("ArticleNumber");
var ArticlePower = ZNRequest.GetInt("ArticlePower");
if (string.IsNullOrWhiteSpace(UserNumber) || string.IsNullOrWhiteSpace(ArticleNumber))
{
return(Json(new { result = false, message = "参数异常" }, JsonRequestBehavior.AllowGet));
}
//判断文章权限,公开的才可以投稿
var article = db.Single <Article>(x => x.Number == ArticleNumber);
if (article == null)
{
return(Json(new { result = false, message = "文章信息异常" }, JsonRequestBehavior.AllowGet));
}
if (article.TypeID == 0)
{
return(Json(new { result = false, message = "请选择文章分类" }, JsonRequestBehavior.AllowGet));
}
if (article.ArticlePower != Enum_ArticlePower.Public)
{
if (ArticlePower != Enum_ArticlePower.Public)
{
return(Json(new { result = false, message = "公开文章才可以投稿哦" }, JsonRequestBehavior.AllowGet));
}
}
var time = DateTime.Now.AddDays(-1);
var log = db.Single <ArticleRecommend>(x => x.CreateUserNumber == UserNumber && x.ArticleNumber == ArticleNumber && x.CreateDate > time);
if (log != null)
{
return(Json(new { result = false, message = "每天只有1次投稿机会，上次投稿时间为：" + log.CreateDate.ToString("yyyy-MM-dd hh:mm:ss") }, JsonRequestBehavior.AllowGet));
}
//修改文章投稿记录
var result = new SubSonic.Query.Update <Article>(provider).Set("Submission").EqualTo(Enum_Submission.Audit).Set("ArticlePower").EqualTo(Enum_ArticlePower.Public).Where <Article>(x => x.ID == article.ID).Execute() > 0;
ArticleRecommend model = new ArticleRecommend();
model.ArticleNumber = ArticleNumber;
model.CreateUserNumber = UserNumber;
model.CreateDate = DateTime.Now;
model.CreateIP = Tools.GetClientIP;
model.Status = Enum_Status.Audit;
result = Tools.SafeInt(db.Add <ArticleRecommend>(model)) > 0;
if (result)
{
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_Recommend:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 文章恢复
/// </summary>
public ActionResult Revoke()
{
try
{
var ArticleNumber = ZNRequest.GetString("ArticleNumber");
var result = new SubSonic.Query.Update <Article>(provider).Set("Status").EqualTo(Enum_Status.Approved).Set("UpdateDate").EqualTo(DateTime.Now).Where <Article>(x => x.Number == ArticleNumber).Execute() > 0;
if (result)
{
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("Article_Revoke:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditBackground()
{
try
{
var ArticleID = ZNRequest.GetInt("ArticleID");
var background = ZNRequest.GetString("Background");
var result = new SubSonic.Query.Update <Article>(provider).Set("Background").EqualTo(background).Where <Article>(x => x.ID == ArticleID).Execute() > 0;
if (result)
{
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_EditBackground:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditShare()
{
try
{
var ArticleID = ZNRequest.GetInt("ArticleID");
var ArticleNumber = ZNRequest.GetString("ArticleNumber");
var TypeID = ZNRequest.GetInt("ArticleType");
var ArticlePower = ZNRequest.GetInt("ArticlePower", Enum_ArticlePower.Myself);
var ArticlePowerPwd = ZNRequest.GetString("ArticlePowerPwd");
if (ArticlePower < 0)
{
return(Json(new { result = false, message = "请选择文章权限" }, JsonRequestBehavior.AllowGet));
}
if (TypeID <= 0)
{
return(Json(new { result = false, message = "请选择文章类别" }, JsonRequestBehavior.AllowGet));
}
var articleType = AppHelper.GetArticleType().FirstOrDefault <ArticleType>(x => x.ID == TypeID);
if (articleType == null)
{
return(Json(new { result = false, message = "不存在当前类型" }, JsonRequestBehavior.AllowGet));
}
var result = new SubSonic.Query.Update <Article>(provider)
.Set("TypeID").EqualTo(TypeID)
.Set("TypeIDList").EqualTo(articleType.ParentIDList)
.Set("ArticlePower").EqualTo(ArticlePower)
.Set("ArticlePowerPwd").EqualTo(ArticlePowerPwd)
.Where <Article>(x => x.ID == ArticleID).Execute() > 0;
if (result)
{
//用户相册是否展示
var status = ArticlePower == Enum_ArticlePower.Public ? Enum_Status.Approved : Enum_Status.Audit;
new SubSonic.Query.Update <ArticlePart>(provider).Set("Status").EqualTo(status).Where <ArticlePart>(x => x.ArticleNumber == ArticleNumber).Execute();
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_EditShare:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditArticleCover()
{
try
{
var ArticleID = ZNRequest.GetInt("ArticleID");
var Cover = ZNRequest.GetString("Cover");
if (string.IsNullOrWhiteSpace(Cover))
{
return(Json(new { result = false, message = "参数异常" }, JsonRequestBehavior.AllowGet));
}
var result = new SubSonic.Query.Update <Article>(provider).Set("Cover").EqualTo(Cover).Where <Article>(x => x.ID == ArticleID).Execute() > 0;
if (result)
{
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_EditArticleCover:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 编辑
/// ShareType（0：文章,1：用户,2：新手红包,3：banner）
/// </summary>
public ActionResult Edit()
{
try
{
var UserNumber = ZNRequest.GetString("UserNumber");
var Number = ZNRequest.GetString("Number");
var ShareType = ZNRequest.GetInt("ShareType");
ShareLog model = new ShareLog();
model.CreateDate = DateTime.Now;
model.CreateUserNumber = UserNumber;
model.CreateIP = Tools.GetClientIP;
model.ArticleNumber = ShareType == 0 ? Number : "";
model.UserNumber = ShareType == 1 ? Number : "";
model.Source = ZNRequest.GetString("Source");
var result = false;
result = Tools.SafeInt(db.Add <ShareLog>(model)) > 0;
if (result)
{
if (ShareType == 0 && !string.IsNullOrWhiteSpace(Number))
{
Article article = new SubSonic.Query.Select(provider, "ID", "Shares", "Number").From <Article>().Where <Article>(x => x.Number == Number).ExecuteSingle <Article>();
if (article != null)
{
result = new SubSonic.Query.Update <Article>(provider).Set("Shares").EqualTo(article.Shares + 1).Where <Article>(x => x.ID == article.ID).Execute() > 0;
}
}
}
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ShareLogController_Edit:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
public ActionResult EditArticlePower()
{
try
{
var ArticleID = ZNRequest.GetInt("ArticleID");
Article article = db.Single <Article>(x => x.ID == ArticleID);
var ArticlePower = ZNRequest.GetInt("ArticlePower", Enum_ArticlePower.Myself);
var ArticlePowerPwd = ZNRequest.GetString("ArticlePowerPwd");
var result = new SubSonic.Query.Update <Article>(provider).Set("ArticlePower").EqualTo(ArticlePower).Set("ArticlePowerPwd").EqualTo(ArticlePowerPwd).Where <Article>(x => x.ID == ArticleID).Execute() > 0;
if (result)
{
//用户相册是否展示
var status = ArticlePower == Enum_ArticlePower.Public ? Enum_Status.Approved : Enum_Status.Audit;
new SubSonic.Query.Update <ArticlePart>(provider).Set("Status").EqualTo(status).Where <ArticlePart>(x => x.ArticleNumber == article.Number).Execute();
return(Json(new { result = true, message = "成功" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.ErrorLoger.Error("ArticleController_EditArticlePower:" + ex.Message);
}
return(Json(new { result = false, message = "失败" }, JsonRequestBehavior.AllowGet));
}
