public static bool CreateHelp(HelpInfo help)
{
if (null == help)
{
return false;
}
Globals.EntityCoding(help, true);
return CommentsProvider.Instance().AddHelp(help);
}
public override bool AddHelp(HelpInfo help)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO Hishop_Helps(CategoryId, Title, Meta_Description, Meta_Keywords, Description, Content, AddedDate, IsShowFooter) VALUES (@CategoryId, @Title, @Meta_Description, @Meta_Keywords, @Description, @Content, @AddedDate, @IsShowFooter)");
database.AddInParameter(sqlStringCommand, "CategoryId", DbType.Int32, help.CategoryId);
database.AddInParameter(sqlStringCommand, "Title", DbType.String, help.Title);
database.AddInParameter(sqlStringCommand, "Meta_Description", DbType.String, help.MetaDescription);
database.AddInParameter(sqlStringCommand, "Meta_Keywords", DbType.String, help.MetaKeywords);
database.AddInParameter(sqlStringCommand, "Description", DbType.String, help.Description);
database.AddInParameter(sqlStringCommand, "Content", DbType.String, help.Content);
database.AddInParameter(sqlStringCommand, "AddedDate", DbType.DateTime, help.AddedDate);
database.AddInParameter(sqlStringCommand, "IsShowFooter", DbType.Boolean, help.IsShowFooter);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
private void btnAddHelp_Click(object sender, EventArgs e)
{
HelpInfo target = new HelpInfo();
if (!this.dropHelpCategory.SelectedValue.HasValue)
{
this.ShowMsg("请选择帮助分类", false);
}
else
{
target.AddedDate = DateTime.Now;
target.CategoryId = this.dropHelpCategory.SelectedValue.Value;
target.Title = this.txtHelpTitle.Text;
target.MetaDescription = this.txtMetaDescription.Text;
target.MetaKeywords = this.txtMetaKeywords.Text;
target.Description = this.txtShortDesc.Text;
target.Content = this.fcContent.Text;
target.IsShowFooter = this.radioShowFooter.SelectedValue;
ValidationResults results = Hishop.Components.Validation.Validation.Validate<HelpInfo>(target, new string[] { "ValHelpInfo" });
string msg = string.Empty;
if (!results.IsValid)
{
foreach (ValidationResult result in (IEnumerable<ValidationResult>) results)
{
msg = msg + Formatter.FormatErrorMessage(result.Message);
}
this.ShowMsg(msg, false);
}
else if (!(!this.radioShowFooter.SelectedValue || SubsiteCommentsHelper.GetHelpCategory(target.CategoryId).IsShowFooter))
{
this.ShowMsg("当选中的帮助分类设置不在底部帮助显示时，此分类下的帮助主题就不能设置在底部帮助显示", false);
}
else if (SubsiteCommentsHelper.CreateHelp(target))
{
this.txtHelpTitle.Text = string.Empty;
this.txtShortDesc.Text = string.Empty;
this.fcContent.Text = string.Empty;
this.ShowMsg("成功添加了一个帮助主题", true);
}
else
{
this.ShowMsg("添加帮助主题错误", false);
}
}
}
public override bool UpdateHelp(HelpInfo help)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_Helps SET CategoryId = @CategoryId, AddedDate = @AddedDate, Title = @Title, Meta_Description = @Meta_Description, Meta_Keywords = @Meta_Keywords, Description = @Description, Content = @Content, IsShowFooter = @IsShowFooter WHERE HelpId = @HelpId");
database.AddInParameter(sqlStringCommand, "CategoryId", DbType.Int32, help.CategoryId);
database.AddInParameter(sqlStringCommand, "Title", DbType.String, help.Title);
database.AddInParameter(sqlStringCommand, "Meta_Description", DbType.String, help.MetaDescription);
database.AddInParameter(sqlStringCommand, "Meta_Keywords", DbType.String, help.MetaKeywords);
database.AddInParameter(sqlStringCommand, "Description", DbType.String, help.Description);
database.AddInParameter(sqlStringCommand, "Content", DbType.String, help.Content);
database.AddInParameter(sqlStringCommand, "AddedDate", DbType.DateTime, help.AddedDate);
database.AddInParameter(sqlStringCommand, "IsShowFooter", DbType.Boolean, help.IsShowFooter);
database.AddInParameter(sqlStringCommand, "HelpId", DbType.Int32, help.HelpId);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
public static HelpInfo PopulateHelp(IDataReader reader)
{
if (null == reader)
{
return null;
}
HelpInfo info = new HelpInfo();
info.CategoryId = (int) reader["CategoryId"];
info.HelpId = (int) reader["HelpId"];
info.Title = (string) reader["Title"];
if (reader["Meta_Description"] != DBNull.Value)
{
info.MetaDescription = (string) reader["Meta_Description"];
}
if (reader["Meta_Keywords"] != DBNull.Value)
{
info.MetaKeywords = (string) reader["Meta_Keywords"];
}
if (reader["Description"] != DBNull.Value)
{
info.Description = (string) reader["Description"];
}
info.Content = (string) reader["Content"];
info.AddedDate = (DateTime) reader["AddedDate"];
info.IsShowFooter = (bool) reader["IsShowFooter"];
return info;
}
public abstract bool AddHelp(HelpInfo help);
public abstract bool UpdateHelp(HelpInfo help);
