protected void btnAddTopic_Click(object sender, EventArgs e)
{
if (ReplyHelper.HasReplyKey(this.txtKeys.Text.Trim()))
{
this.ShowMsg("关键字重复!", false);
}
else
{
string str = string.Empty;
if (this.fileUpload.HasFile)
{
try
{
str = VShopHelper.UploadTopicImage(this.fileUpload.PostedFile);
}
catch
{
this.ShowMsg("图片上传失败，您选择的不是图片类型的文件，或者网站的虚拟目录没有写入文件的权限", false);
return;
}
}
TopicInfo target = new TopicInfo {
Title = this.txtTopicTitle.Text.Trim(),
Keys = this.txtKeys.Text.Trim(),
IconUrl = str,
Content = this.fcContent.Text,
AddedDate = DateTime.Now,
IsRelease = true
};
ValidationResults results = Hishop.Components.Validation.Validation.Validate<TopicInfo>(target, new string[] { "ValTopicInfo" });
string msg = string.Empty;
if (results.IsValid)
{
int num;
if (VShopHelper.Createtopic(target, out num) && (num > 0))
{
base.Response.Redirect("SetTopicProducts.aspx?topicid=" + num);
}
else
{
this.ShowMsg("添加专题错误", false);
}
}
else
{
foreach (ValidationResult result in (IEnumerable<ValidationResult>) results)
{
msg = msg + Formatter.FormatErrorMessage(result.Message);
}
this.ShowMsg(msg, false);
}
}
}
public int AddTopic(TopicInfo topicinfo)
{
int num;
StringBuilder builder = new StringBuilder();
builder.Append("insert into Vshop_Topics(Title,IconUrl,Content,AddedDate,IsRelease,DisplaySequence)");
builder.Append(" values (@Title,@IconUrl,@Content,@AddedDate,@IsRelease,@DisplaySequence);");
builder.Append(" select @@IDENTITY");
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
this.database.AddInParameter(sqlStringCommand, "Title", DbType.String, topicinfo.Title);
this.database.AddInParameter(sqlStringCommand, "IconUrl", DbType.String, topicinfo.IconUrl);
this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, topicinfo.Content);
this.database.AddInParameter(sqlStringCommand, "AddedDate", DbType.DateTime, topicinfo.AddedDate);
this.database.AddInParameter(sqlStringCommand, "IsRelease", DbType.Boolean, topicinfo.IsRelease);
this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.Int32, topicinfo.DisplaySequence);
this.database.AddInParameter(sqlStringCommand, "Keys", DbType.String, topicinfo.Keys);
int.TryParse(this.database.ExecuteScalar(sqlStringCommand).ToString(), out num);
return num;
}
public static bool Createtopic(TopicInfo topic, out int id)
{
id = 0;
if (null == topic)
{
return false;
}
Globals.EntityCoding(topic, true);
id = new TopicDao().AddTopic(topic);
ReplyInfo reply = new TextReplyInfo {
Keys = topic.Keys,
MatchType = MatchType.Equal,
MessageType = MessageType.Text,
ReplyType = ReplyType.Topic,
ActivityId = id
};
return new ReplyDao().SaveReply(reply);
}
public static TopicInfo PopulateTopic(IDataReader reader)
{
TopicInfo info = new TopicInfo {
TopicId = (int) reader["TopicId"],
Title = (string) reader["Title"]
};
if (reader["IconUrl"] != DBNull.Value)
{
info.IconUrl = (string) reader["IconUrl"];
}
info.Content = (string) reader["Content"];
info.AddedDate = (DateTime) reader["AddedDate"];
info.IsRelease = (bool) reader["IsRelease"];
return info;
}
public bool UpdateTopic(TopicInfo topic)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Vshop_Topics set ");
builder.Append("Title=@Title,");
builder.Append("IconUrl=@IconUrl,");
builder.Append("Content=@Content,");
builder.Append("AddedDate=@AddedDate,");
builder.Append("DisplaySequence=@DisplaySequence,");
builder.Append("IsRelease=@IsRelease");
builder.Append(" where TopicId=@TopicId ");
builder.Append(" UPDATE vshop_Reply SET Keys = @Keys WHERE ActivityId = @TopicId AND [ReplyType] = @ReplyType");
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
this.database.AddInParameter(sqlStringCommand, "TopicId", DbType.Int32, topic.TopicId);
this.database.AddInParameter(sqlStringCommand, "Title", DbType.String, topic.Title);
this.database.AddInParameter(sqlStringCommand, "IconUrl", DbType.String, topic.IconUrl);
this.database.AddInParameter(sqlStringCommand, "Content", DbType.String, topic.Content);
this.database.AddInParameter(sqlStringCommand, "AddedDate", DbType.DateTime, topic.AddedDate);
this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.Int32, topic.DisplaySequence);
this.database.AddInParameter(sqlStringCommand, "IsRelease", DbType.Boolean, topic.IsRelease);
this.database.AddInParameter(sqlStringCommand, "Keys", DbType.String, topic.Keys);
this.database.AddInParameter(sqlStringCommand, "ReplyType", DbType.Int32, 0x200);
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public static bool Updatetopic(TopicInfo topic)
{
if (null == topic)
{
return false;
}
Globals.EntityCoding(topic, true);
return new TopicDao().UpdateTopic(topic);
}
