/// <summary>
/// 存储/更新实体对象是否成功
/// </summary>
public bool StoredSuccess(object Instance)
{
AccessWebNews aWebNews = Instance as AccessWebNews;
if (aWebNews == null)
{
return(false);
}
string strOp = (aWebNews.NewsID == 0) ? "I" : "U@[NewsID=" + aWebNews.NewsID.ToString() + "]";
string sql = OleDbHelper.BuildSqlIU(OleDbHelper.DbDialect.MsAccess, "Tbl_Articles", strOp,
new string[] { "TypeID", "VirtualPath", "Sort", "IsPrimary",
"Title", "Author", "InnerUserName", "Summary", "Content", "Pubed", "PublishDate", "Hits" },
new object[] {
aWebNews.Channel.ChannelID,
OleDbHelper.EscapeSQL(aWebNews.VirtualPath),
aWebNews.Sort,
aWebNews.IsPrimary,
OleDbHelper.EscapeSQL(aWebNews.Title),
OleDbHelper.EscapeSQL(aWebNews.Author),
OleDbHelper.EscapeSQL(aWebNews.InnerUserName),
OleDbHelper.EscapeSQL(aWebNews.Summary),
OleDbHelper.EscapeSQL(aWebNews.Content),
aWebNews.IsPubed,
"N'Now()", aWebNews.Hits
});
strOp = FanmaquerOleDbModule.GetOleDbInstance(FanmaquarConfig.ConnectionKey).ExecuteNonQuery(sql).ToString();
return(strOp != "0");
}
/// <summary>
/// 存储/更新实体对象是否成功
/// </summary>
public bool StoredSuccess(object Instance)
{
PageTemplet pageTpt = Instance as PageTemplet;
if (pageTpt == null)
{
return(false);
}
string strOp = (pageTpt.TempletID == 0) ? "I" : "U@[TempletID=" + pageTpt.TempletID.ToString() + "]";
string sql = OleDbHelper.BuildSqlIU(OleDbHelper.DbDialect.MsAccess, "Tbl_Templets", strOp,
new string[] { "TempletName", "SiteBaseDir", "FileSaveUrl", "Content", "TimeFlag", "MixedSyntax", "Category" },
new object[] {
OleDbHelper.EscapeSQL(pageTpt.TempletName),
OleDbHelper.EscapeSQL(pageTpt.SiteBaseDir),
OleDbHelper.EscapeSQL(pageTpt.FileSaveUrl),
pageTpt.TempletRawContent,
"N'Now()",
Util.IsMatch(TagBase.TagDefinitionPattern, pageTpt.TempletRawContent),
pageTpt.TptCategory.GetHashCode()
});
strOp = FanmaquerOleDbModule.GetOleDbInstance(FanmaquarConfig.ConnectionKey).ExecuteNonQuery(sql).ToString();
return(strOp != "0");
}
/// <summary>
/// 存储/更新实体对象是否成功
/// </summary>
public bool StoredSuccess(object Instance)
{
AccessWebChannel aWebChannel = Instance as AccessWebChannel;
if (aWebChannel == null)
{
return(false);
}
string strOp = (aWebChannel.ChannelID == 0) ? "I" : "U@[TypeID=" + aWebChannel.ChannelID.ToString() + "]";
string sql = OleDbHelper.BuildSqlIU(OleDbHelper.DbDialect.MsAccess, "Tbl_Type", strOp,
new string[] { "TypeName", "ParentTypeID", "Sort", "GroupID",
"StaticFileDir", "ArchiveDays", "DisplayByPath", "OuterLinkUrl", "GenTempletRule" },
new object[] {
OleDbHelper.EscapeSQL(aWebChannel.ChannelName),
aWebChannel.ParentChannel.ChannelID,
aWebChannel.Sort,
Convert.ToInt32(aWebChannel.GetDefinition("GroupID")),
OleDbHelper.EscapeSQL((aWebChannel.StaticFileGenDir + "/").Replace("//", "/")),
aWebChannel.ArchiveDays,
aWebChannel.IsOuterLink,
OleDbHelper.EscapeSQL(aWebChannel.OuterLinkUrl),
OleDbHelper.EscapeSQL(aWebChannel.GetTempletConfigStoreText(65535))
});
strOp = FanmaquerOleDbModule.GetOleDbInstance(FanmaquarConfig.ConnectionKey).ExecuteNonQuery(sql).ToString();
return(strOp != "0");
}