protected void Page_Load(object sender, EventArgs e)
{
log = MainMasterPage.InitPage(this);
int forumTopicId = RequestUtils.GetForumTopicId(this);
this.SqlDataSource1.SelectParameters["ForumTopicId"].DefaultValue = forumTopicId.ToString();
try
{
string cmdText = "SELECT Forums.Id AS ForumId, Forums.Name AS ForumName, ForumTopics.Name AS ForumTopicName FROM Forums INNER JOIN ForumTopics ON Forums.Id = ForumTopics.ForumId WHERE (ForumTopics.Id = @ForumTopicId)";
using (GmConnection conn = Global.CreateConnection())
{
GmCommand cmd = conn.CreateCommand(cmdText);
cmd.AddInt("ForumTopicId", forumTopicId);
using (GmDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
forumId = dr.GetInt();
forumName = dr.GetString();
forumTopicName = dr.GetString();
}
else
{
return;
}
}
}
}
catch (Exception ex)
{
log.Exception(ex);
}
}
public static Article GetArticle(GmConnection conn, string tag)
{
GmCommand cmd = conn.CreateCommand("select * from Articles where Tag=@Tag");
cmd.AddString("Tag", tag);
using (GmDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
return(new Article(dr));
}
}
return(null);
}
public static void GetArticleParams(GmConnection conn, int articleId, System.Collections.Specialized.StringDictionary sd)
{
GmCommand cmd = conn.CreateCommand("select [Key], [Value] from ArticleParams where ArticleId=@ArticleId");
cmd.AddInt("ArticleId", articleId);
using (GmDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var key = dr.GetString();
var val = dr.GetString();
sd[key] = val;
}
}
}
public static Candidate GetCandidate(GmConnection conn, int id)
{
if (id == 0)
{
return(null);
}
GmCommand cmd = conn.CreateCommand("select * from Candidates where Id=@Id");
cmd.AddInt("Id", id);
using (GmDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
return(new Candidate(dr));
}
}
return(null);
}
public static ArticleParam GetArticleParam(GmConnection conn, int id)
{
if (id == 0)
{
return(null);
}
GmCommand cmd = conn.CreateCommand("select * from ArticleParams where Id=@Id");
cmd.AddInt("Id", id);
using (GmDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
return(new ArticleParam(dr));
}
}
return(null);
}
