public static int UpdateDaoGouArticle(SqlDbHelper dbhelper, YouXuanArticle article)
{
const string sql = @"
UPDATE Marketing..tbl_Article
SET SmallTitle = @SmallTitle ,
BigTitle = @BigTitle ,
Brief = @Brief ,
Content = @Content ,
PublishDateTime = @PublishDateTime ,
IsShow = @IsShow ,
Status = @Status ,
ContentHTML = @ContentHTML ,
CoverImage = @CoverImage ,
CoverTag = @CoverTag ,
LastUpdateDateTime = GETDATE()
WHERE PKID = @PKID;";
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@SmallTitle", article.SmallTitle);
cmd.Parameters.AddWithValue("@BigTitle", article.SmallTitle);
cmd.Parameters.AddWithValue("@Brief", article.Brief);
cmd.Parameters.AddWithValue("@Content", article.ContentHtml);
cmd.Parameters.AddWithValue("@PublishDateTime", article.PublishDateTime);
cmd.Parameters.AddWithValue("@LastUpdateDateTime", DateTime.Now);
cmd.Parameters.AddWithValue("@IsShow", article.IsShow);
cmd.Parameters.AddWithValue("@Status", article.Status);
cmd.Parameters.AddWithValue("@ContentHTML", article.ContentHtml);
cmd.Parameters.AddWithValue("@CoverImage", article.CoverImage);
cmd.Parameters.AddWithValue("@CoverTag", article.CoverTag);
cmd.Parameters.AddWithValue("@PKID", article.PKID);
return(dbhelper.ExecuteNonQuery(cmd));
};
}
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);
}
public static bool UpsertDaoGouArticle(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.UpdateDaoGouArticle(dbhelper, article);
}
else
{
articleId = ArticleDal.InsertDaoGouArticle(dbhelper, article);
}
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);
}
public static int InsertYxArticle(SqlDbHelper dbhelper, YouXuanArticle article)
{
const string sql = @"
INSERT INTO Marketing..tbl_Article
( Image ,
ShowImages ,
IsDescribe ,
SmallImage ,
SmallTitle ,
BigTitle ,
Brief ,
Content ,
ContentUrl ,
PublishDateTime ,
CreateDateTime ,
LastUpdateDateTime ,
CategoryTags ,
Type ,
IsShow ,
IsDelete ,
Status ,
CoverTag ,
IsTopMost ,
ContentHTML ,
IsShowTouTiao ,
QRCodeImg
)
OUTPUT Inserted.PKID
VALUES ( '' ,
'' ,
1 ,
'' ,
@SmallTitle ,
@BigTitle ,
@Brief ,
@Content ,
'' ,
@PublishDateTime ,
GETDATE() ,
GETDATE() ,
@CategoryTags ,
9 ,
@IsShow ,
0 ,
@Status ,
@CoverTag ,
0 ,
@ContentHTML ,
0 ,
@QRCodeImg
);";
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@SmallTitle", article.SmallTitle);
cmd.Parameters.AddWithValue("@BigTitle", article.SmallTitle);
cmd.Parameters.AddWithValue("@Brief", article.Brief);
cmd.Parameters.AddWithValue("@Content", article.ContentHtml);
cmd.Parameters.AddWithValue("@PublishDateTime", article.PublishDateTime);
cmd.Parameters.AddWithValue("@LastUpdateDateTime", DateTime.Now);
cmd.Parameters.AddWithValue("@CategoryTags", article.CategoryTags);
cmd.Parameters.AddWithValue("@IsShow", article.IsShow);
cmd.Parameters.AddWithValue("@Status", article.Status);
cmd.Parameters.AddWithValue("@CoverTag", article.CoverTag);
cmd.Parameters.AddWithValue("@ContentHTML", article.ContentHtml);
cmd.Parameters.AddWithValue("@QRCodeImg", article.QRCodeImg);
return(Convert.ToInt32(dbhelper.ExecuteScalar(cmd)));
};
}
