public ActionResult Index(string openId, int articleId) { try { WX_Article article = WXArticleServices.QueryById(articleId); if (article == null) { return(RedirectToAction("NotPage", "ErrorPrompt", new { message = "获取微信基础信息失败" })); } return(View(article)); } catch (Exception ex) { ExceptionsServices.AddExceptionToDbAndTxt("WeiXinPageError", "Index方法处理异常", ex, LogFrom.WeiXin); return(RedirectToAction("NotPage", "ErrorPrompt", new { message = "获取数据异常" })); } }
public bool Update(WX_Article model, DbOperator dbOperator) { StringBuilder strSql = new StringBuilder(); strSql.Append("update WX_Article set Title=@Title,ImagePath=@ImagePath,Description=@Description,Url=@Url,[Text]=@Text"); strSql.Append(",ArticleType=@ArticleType,Sort=@Sort,GroupID=@GroupID where ID=@ID"); dbOperator.ClearParameters(); dbOperator.AddParameter("ID", model.ID); dbOperator.AddParameter("Title", model.Title); dbOperator.AddParameter("ImagePath", model.ImagePath); dbOperator.AddParameter("Description", model.Description); dbOperator.AddParameter("Url", model.Url); dbOperator.AddParameter("Text", model.Text); dbOperator.AddParameter("ArticleType", (int)model.ArticleType); dbOperator.AddParameter("Sort", model.Sort); dbOperator.AddParameter("GroupID", model.GroupID); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public bool Create(WX_Article model, DbOperator dbOperator) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into WX_Article(Title,ImagePath,Description,Url,[Text],ArticleType,Sort,GroupID,DataStatus,CreateTime,CompanyID)"); strSql.Append(" values(@Title,@ImagePath,@Description,@Url,@Text,@ArticleType,@Sort,@GroupID,@DataStatus,@CreateTime,@CompanyID)"); dbOperator.ClearParameters(); dbOperator.AddParameter("Title", model.Title); dbOperator.AddParameter("ImagePath", model.ImagePath); dbOperator.AddParameter("Description", model.Description); dbOperator.AddParameter("Url", model.Url); dbOperator.AddParameter("Text", model.Text); dbOperator.AddParameter("ArticleType", (int)model.ArticleType); dbOperator.AddParameter("Sort", model.Sort); dbOperator.AddParameter("GroupID", model.GroupID); dbOperator.AddParameter("DataStatus", (int)model.DataStatus); dbOperator.AddParameter("CreateTime", DateTime.Now); dbOperator.AddParameter("CompanyID", model.CompanyID); return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0); }
public JsonResult SaveArticle(string groupId, int itemnum, string jsonData) { try { string newGroupId = string.Empty; if (string.IsNullOrWhiteSpace(groupId)) { newGroupId = GuidGenerator.GetGuidString(); } var dyArticles = JsonHelper.Parse(jsonData); List <WX_Article> models = new List <WX_Article>(); for (var i = 0; i < itemnum; i++) { WX_Article model = new WX_Article(); model.ID = int.Parse(dyArticles[i].id); if (string.IsNullOrWhiteSpace(dyArticles[i].title)) { throw new MyException(string.Format("获取第{0}个图文的标题失败", i + 1)); } model.Title = dyArticles[i].title; model.ImagePath = dyArticles[i].pic; if (string.IsNullOrWhiteSpace(dyArticles[i].pic)) { throw new MyException(string.Format("获取第{0}个图文的封面图片失败", i + 1)); } model.Description = dyArticles[i].desc; if (!string.IsNullOrWhiteSpace(groupId)) { List <WX_Article> oldArticles = WXArticleServices.QueryByGroupID(groupId); if (oldArticles.Count == 0) { throw new MyException("获取单位编号失败"); } model.CompanyID = oldArticles.First().CompanyID; } else { model.CompanyID = dyArticles[i].companyid; } model.Text = dyArticles[i].text; model.ArticleType = (ArticleType)int.Parse(dyArticles[i].type); if (model.ArticleType == ArticleType.Url && string.IsNullOrWhiteSpace(dyArticles[i].url)) { throw new MyException(string.Format("获取第{0}个图文的链接地址失败", i + 1)); } if (model.ArticleType == ArticleType.Module && string.IsNullOrWhiteSpace(dyArticles[i].moduleid)) { throw new MyException(string.Format("获取第{0}个图文的模块失败", i + 1)); } switch (model.ArticleType) { case ArticleType.Url: { model.Url = dyArticles[i].url; break; } case ArticleType.Module: { model.Url = dyArticles[i].moduleid; break; } default: { model.Url = string.Empty; break; } } model.Sort = (int)dyArticles[i].sort; model.GroupID = string.IsNullOrWhiteSpace(groupId)?newGroupId:groupId; model.CreateTime = DateTime.Now; models.Add(model); } bool result = WXArticleServices.Create(models); if (!result) { throw new MyException("保存图文失败"); } return(Json(MyResult.Success())); } catch (MyException ex) { return(Json(MyResult.Error(ex.Message))); } catch (Exception ex) { ExceptionsServices.AddExceptions(ex, "保存图文失败"); return(Json(MyResult.Error("保存图文失败"))); } }