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