public void UpdateAutoPageContent(string tableName, PublishmentSystemInfo publishmentSystemInfo)
{
if (publishmentSystemInfo.Additional.IsAutoPageInTextEditor)
{
string sqlString =
$"SELECT ID, [{BackgroundContentAttribute.Content}] FROM [{tableName}] WHERE ([PublishmentSystemID] = {publishmentSystemInfo.PublishmentSystemId})";
using (var rdr = ExecuteReader(sqlString))
{
while (rdr.Read())
{
var contentId = GetInt(rdr, 0);
var content = GetString(rdr, 1);
if (!string.IsNullOrEmpty(content))
{
content = ContentUtility.GetAutoPageContent(content, publishmentSystemInfo.Additional.AutoPageWordNum);
string updateString =
$"UPDATE [{tableName}] SET [{BackgroundContentAttribute.Content}] = '{content}' WHERE ID = {contentId}";
try
{
ExecuteNonQuery(updateString);
}
catch
{
// ignored
}
}
}
rdr.Close();
}
}
}
public void Update(string tableName, PublishmentSystemInfo publishmentSystemInfo, ContentInfo contentInfo)
{
if (publishmentSystemInfo.Additional.IsAutoPageInTextEditor && contentInfo.ContainsKey(BackgroundContentAttribute.Content))
{
contentInfo.SetExtendedAttribute(BackgroundContentAttribute.Content, ContentUtility.GetAutoPageContent(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.Content), publishmentSystemInfo.Additional.AutoPageWordNum));
}
BaiRongDataProvider.ContentDao.Update(tableName, contentInfo);
}
public int Insert(string tableName, PublishmentSystemInfo publishmentSystemInfo, ContentInfo contentInfo, bool isUpdateContentNum, int taxis)
{
var contentId = 0;
if (!string.IsNullOrEmpty(tableName))
{
if (publishmentSystemInfo.Additional.IsAutoPageInTextEditor && contentInfo.ContainsKey(BackgroundContentAttribute.Content))
{
contentInfo.SetExtendedAttribute(BackgroundContentAttribute.Content, ContentUtility.GetAutoPageContent(contentInfo.GetExtendedAttribute(BackgroundContentAttribute.Content), publishmentSystemInfo.Additional.AutoPageWordNum));
}
contentInfo.BeforeExecuteNonQuery();
contentInfo.Taxis = taxis;
contentId = BaiRongDataProvider.ContentDao.Insert(tableName, contentInfo);
if (isUpdateContentNum)
{
new Action(() =>
{
DataProvider.NodeDao.UpdateContentNum(PublishmentSystemManager.GetPublishmentSystemInfo(contentInfo.PublishmentSystemId), contentInfo.NodeId, true);
}).BeginInvoke(null, null);
}
}
return(contentId);
}