public static bool UpsertYxArticle(YouXuanArticle article, string user) { var result = false; var articleId = 0; try { var conn = ConfigurationManager.ConnectionStrings["Tuhu_Discovery_Db"].ConnectionString; if (SecurityHelp.IsBase64Formatted(conn)) { conn = SecurityHelp.DecryptAES(conn); } using (var dbhelper = new SqlDbHelper(conn)) { dbhelper.BeginTransaction(); if (article.PKID > 0) { articleId = article.PKID; ArticleDal.UpdateYxArticle(dbhelper, article); } else { articleId = ArticleDal.InsertYxArticle(dbhelper, article); } article.CoverConfig.ArticleId = articleId; ArticleDal.DeleteYxArticleCoverConfig(dbhelper, articleId); ArticleDal.DeleteArticleCategoryTag(dbhelper, articleId); if (!string.IsNullOrEmpty(article.CategoryTags)) { var categoryIds = JsonConvert.DeserializeObject <List <JObject> >(article.CategoryTags).Select(t => t.Value <int>("key")); foreach (var id in categoryIds) { ArticleDal.InsertArticleCategoryTag(dbhelper, articleId, id); } } ArticleDal.InsertYxArticleCoverConfig(dbhelper, article.CoverConfig); dbhelper.Commit(); result = true; } } catch (Exception ex) { logger.Error(ex); } if (result) { if (article.PKID > 0) { LoggerManager.InsertOplog(user, "ArticleTblNew", articleId, "新增优选文章,文章状态:" + article.Status); } else { LoggerManager.InsertOplog(user, "ArticleTblNew", articleId, "修改优选文章,文章状态:" + article.Status); } } return(result); }