本文整理汇总了C#中DataLayer.GetForumTopicBy_TopicID方法的典型用法代码示例。如果您正苦于以下问题：C# DataLayer.GetForumTopicBy_TopicID方法的具体用法？C# DataLayer.GetForumTopicBy_TopicID怎么用？C# DataLayer.GetForumTopicBy_TopicID使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataLayer的用法示例。
在下文中一共展示了DataLayer.GetForumTopicBy_TopicID方法的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: lbtnQuotePost_Click
protected void lbtnQuotePost_Click(object sender, EventArgs e)
{
if (Request.QueryString["rt"] != null)
{
int iRTPostID = Convert.ToInt32(Request.QueryString["rt"]);
DataLayer dl = new DataLayer();
DataTable dtRTPost = dl.GetForumPostBy_PostID(iRTPostID);
rteBody.Value += "<div style=\"background-color:#ddddee; border: solid 2px #000077;padding:10px;\">";
rteBody.Value += dtRTPost.Rows[0].ItemArray[4].ToString();
rteBody.Value += "<br /><br /><div style=\"font-size: 12px;font-weight:bold;\">Posted by <a href=\"Profile.aspx?member=" + dtRTPost.Rows[0].ItemArray[2].ToString() + "\">";
rteBody.Value += dl.GetFullMemberNameBy_Email(dtRTPost.Rows[0].ItemArray[2].ToString());
rteBody.Value += "</a> on " + dtRTPost.Rows[0].ItemArray[3].ToString() + "</div></div><br />";
}
else
{
int iRTTopicID = Convert.ToInt32(Request.QueryString["topic"]);
DataLayer dl = new DataLayer();
DataTable dtRTTopic = dl.GetForumTopicBy_TopicID(iRTTopicID);
rteBody.Value += "<div style=\"background-color:#ddddee; border: solid 2px #000077;padding:10px;\">";
rteBody.Value += dtRTTopic.Rows[0].ItemArray[5].ToString();
rteBody.Value += "<br /><br /><div style=\"font-size: 12px;font-weight:bold;\">Posted by <a href=\"Profile.aspx?member=" + dtRTTopic.Rows[0].ItemArray[2].ToString() + "\">";
rteBody.Value += dl.GetFullMemberNameBy_Email(dtRTTopic.Rows[0].ItemArray[2].ToString());
rteBody.Value += "</a> on " + dtRTTopic.Rows[0].ItemArray[3].ToString() + "</div></div><br />";
}
}示例2: btnSubmit_Click
protected void btnSubmit_Click(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
if (Request.QueryString["post"] != null)
{
int iPostID = Convert.ToInt32(Request.QueryString["post"]);
int iTopicID = Convert.ToInt32(Request.QueryString["topic"]);
dl.UpdateForumPost(iPostID, rteBody.Value);
Response.Redirect("Topic.aspx?topic=" + iTopicID.ToString(), true);
}
else
{
int iTopicID = Convert.ToInt32(Request.QueryString["topic"]);
DataTable dtTopic = dl.GetForumTopicBy_TopicID(iTopicID);
DateTime dtPostedDate = DateTime.Now;
dl.AddForumPost(iTopicID, User.Identity.Name, dtPostedDate, rteBody.Value);
SmtpMail.SmtpServer = "relay-hosting.secureserver.net";
MailMessage mm;
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = "[email protected];[email protected]";
mm.From = "[email protected]";
mm.Subject = "Someone replied to a forum topic.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " replied to the forum topic titled: " + dtTopic.Rows[0].ItemArray[4].ToString();
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Topic.aspx?topic=" + iTopicID.ToString() + "\">Click to view</a>";
mm.Body += "<br /><br />The post reply is below:<br /><br />" + rteBody.Value;
SmtpMail.Send(mm);
if (User.Identity.Name.ToLower() != dtTopic.Rows[0].ItemArray[2].ToString().ToLower())
{
mm = new MailMessage();
mm.BodyFormat = MailFormat.Html;
mm.To = dtTopic.Rows[0].ItemArray[2].ToString();
mm.From = "[email protected]";
mm.Subject = "Someone replied to your forum topic.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " replied to your forum topic titled: " + dtTopic.Rows[0].ItemArray[4].ToString();
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Topic.aspx?topic=" + iTopicID.ToString() + "\">Click to view</a>";
SmtpMail.Send(mm);
}
Response.Redirect("Topic.aspx?topic=" + iTopicID.ToString(), true);
}
}示例3: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["topic"] != null)
{
int iTopicID = Convert.ToInt32(Request.QueryString["topic"]);
int iPageNumber = 0;
if (Request.QueryString["p"] != null)
{
iPageNumber = Convert.ToInt32(Request.QueryString["p"]);
}
if (!User.Identity.IsAuthenticated)
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Members Only";
Session["resultMessage"] = "This is a members only area.<br />You must log in first.";
Session["resultReturnURL"] = "Topic.aspx?topic=" + iTopicID.ToString();
Response.Redirect("Result.aspx", true);
}
DataLayer dl = new DataLayer();
int iMaxPages = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(dl.GetReplyCountBy_TopicID(iTopicID)) / 15m));
pageNav1.NumPages = iMaxPages;
pageNav2.NumPages = iMaxPages;
DataTable dtTopic = dl.GetForumTopicBy_TopicID(iTopicID);
DataTable dtBoard = dl.GetForumBoardBy_BoardID(Convert.ToInt32(dtTopic.Rows[0].ItemArray[1]));
boardtitle.InnerHtml = "<span style=\"font-size:20px;\"><a href=\"Topics.aspx?board=" + dtBoard.Rows[0].ItemArray[0].ToString() + "\" class=\"titlelink\">-= " + dtBoard.Rows[0].ItemArray[1].ToString() + " =-</a></span>";
topictitle.InnerHtml = dtTopic.Rows[0].ItemArray[4].ToString();
DataTable dtPosts = dl.GetFifteenPostsBy_Page(iPageNumber, iTopicID);
DataTable dtMember = dl.GetMemberBy_Email(dtTopic.Rows[0].ItemArray[2].ToString());
if (iPageNumber == 0)
{
posts.Controls.Add(new LiteralControl("<div style=\"background-color:#CCDDCC;padding:10px;\"><table style=\"width:100%;\"><td rowspan=\"2\" style=\"vertical-align:top;text-align:center;font-size:17px;font-weight:bold;padding-right:15px;border-right:solid 2px #333333;width:150px;\"><a style=\"text-decoration:none;\" href=\"Profile.aspx?member=" + dtMember.Rows[0].ItemArray[0].ToString() + "\"><img style=\"border-width:0px;\" src=\"MakeThumbnail.aspx?size=150&image=images/MemberAvatars/" + dtMember.Rows[0].ItemArray[3].ToString() + "\" /></a><br /><br /><a href=\"Profile.aspx?member=" + dtMember.Rows[0].ItemArray[0].ToString() + "\">" + dtMember.Rows[0].ItemArray[2].ToString() + "</a></td><td style=\"text-align:left;vertical-align:top;padding-left:15px;\">" + dtTopic.Rows[0].ItemArray[5].ToString() + "<br /><br />----------------------------------<br />" + dtMember.Rows[0].ItemArray[18].ToString() + "<td></tr><tr><td style=\"vertical-align:bottom;padding-left:15px;padding-top:15px;\"><table cellpadding=\"0\" cellspacing=\"0\" style=\"width:100%;\"><tr><td style=\"text-align:left;vertical-align:bottom;font-size:12px;font-weight:bold;\">" + dtTopic.Rows[0].ItemArray[3].ToString() + "</td><td style=\"text-align:right;vertical-align:bottom;\">"));
if ((dl.IsMemberAdmin(User.Identity.Name)) || (dl.IsMemberModerator(User.Identity.Name)))
{
if (!Convert.ToBoolean(dtTopic.Rows[0].ItemArray[7]))
{
lbButton = new LinkButton();
lbButton.Text = "Lock";
lbButton.Click += new EventHandler(lbButtonLock_Click);
posts.Controls.Add(lbButton);
}
else
{
lbButton = new LinkButton();
lbButton.Text = "Unlock";
lbButton.Click += new EventHandler(lbButtonUnLock_Click);
posts.Controls.Add(lbButton);
}
posts.Controls.Add(new LiteralControl(" "));
if (!Convert.ToBoolean(dtTopic.Rows[0].ItemArray[6]))
{
lbButton = new LinkButton();
lbButton.Text = "Sticky";
lbButton.Click += new EventHandler(lbButtonSticky_Click);
posts.Controls.Add(lbButton);
}
else
{
lbButton = new LinkButton();
lbButton.Text = "Unsticky";
lbButton.Click += new EventHandler(lbButtonUnSticky_Click);
posts.Controls.Add(lbButton);
}
posts.Controls.Add(new LiteralControl(" <b>|</b> "));
}
if ((User.Identity.Name.ToLower() == dtTopic.Rows[0].ItemArray[2].ToString().ToLower()) || (dl.IsMemberAdmin(User.Identity.Name)) || (dl.IsMemberModerator(User.Identity.Name)))
{
posts.Controls.Add(new LiteralControl("<a href=\"AddEditTopic.aspx?topic=" + iTopicID.ToString() + "\">Edit</a> "));
lbDelete = new LinkButton();
lbDelete.Text = "Delete";
lbDelete.Click += new EventHandler(lbDeleteTopic_Click);
posts.Controls.Add(lbDelete);
posts.Controls.Add(new LiteralControl(" "));
}
if (!Convert.ToBoolean(dtTopic.Rows[0].ItemArray[7]))
{
posts.Controls.Add(new LiteralControl("<a href=\"AddEditPost.aspx?topic=" + iTopicID.ToString() + "\">Reply</a>"));
}
else
{
posts.Controls.Add(new LiteralControl("<span style=\"font-style:italic;color:#ff0000;\">Topic Locked</span>"));
}
posts.Controls.Add(new LiteralControl("</td></tr></table></td></tr></table></div>"));
}
bool bColored = false;
if (iPageNumber > 0)
bColored = true;
bool bFirst = true;
foreach (DataRow dr in dtPosts.Rows)
{
dtMember = dl.GetMemberBy_Email(dr.ItemArray[2].ToString());
posts.Controls.Add(new LiteralControl("<div style=\""));
if (bColored)
{
//.........这里部分代码省略.........
示例4: lbDeleteTopic_Click
void lbDeleteTopic_Click(object sender, EventArgs e)
{
int iTopicID = Convert.ToInt32(Request.QueryString["topic"]);
DataLayer dl = new DataLayer();
DataTable dtTopic = dl.GetForumTopicBy_TopicID(iTopicID);
dl.DeleteForumTopic(iTopicID);
Session["resultColor"] = "#009900";
Session["resultTitle"] = "Topic Deleted";
Session["resultMessage"] = "Topic Deleted Successfully";
Session["resultReturnURL"] = "Topics.aspx?board=" + dtTopic.Rows[0].ItemArray[1].ToString();
Response.Redirect("Result.aspx", true);
}示例5: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
if (Request.QueryString["topic"] != null)
{
int iTopicID = Convert.ToInt32(Request.QueryString["topic"]);
Object[] oTopic = dl.GetForumTopicBy_TopicID(iTopicID).Rows[0].ItemArray;
if (!User.Identity.IsAuthenticated)
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Members Only";
Session["resultMessage"] = "This is a members only area.<br />You must log in first.";
Session["resultReturnURL"] = "AddEditTopic.aspx?topic=" + Request.QueryString["topic"];
Response.Redirect("Result.aspx", true);
}
else if ((User.Identity.IsAuthenticated) && (User.Identity.Name.ToLower() != oTopic[2].ToString().ToLower()) && (!dl.IsMemberAdmin(User.Identity.Name)))
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Not Authorized";
Session["resultMessage"] = "You are not authorized to edit this post.";
Session["resultReturnURL"] = "Topic.aspx?topic=" + Request.QueryString["topic"];
Response.Redirect("Result.aspx", true);
}
else
{
if (!this.IsPostBack)
{
addedit.InnerText = "Edit Topic";
tbxTitle.Text = oTopic[4].ToString();
rteBody.Value = oTopic[5].ToString();
}
cbxLocked.Visible = false;
cbxSticky.Visible = false;
}
}
else if ((Request.QueryString["board"] == null) && (Request.QueryString["topic"] == null))
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Error";
Session["resultMessage"] = "No BoardID was specified for the new topic.";
Session["resultReturnURL"] = "Topics.aspx";
Response.Redirect("Result.aspx", true);
}
else
{
DataTable dtBoard = dl.GetForumBoardBy_BoardID(Convert.ToInt32(Request.QueryString["board"]));
if (Convert.ToBoolean(dtBoard.Rows[0].ItemArray[3]))
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Locked";
Session["resultMessage"] = "You cannot creat a new topic because this board is locked.";
Session["resultReturnURL"] = "Topics.aspx?board=" + dtBoard.Rows[0].ItemArray[0].ToString();
Response.Redirect("Result.aspx", true);
}
addedit.InnerText = "Add New Topic";
if (!User.Identity.IsAuthenticated)
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Members Only";
Session["resultMessage"] = "This is a members only area.<br />You must log in first.";
Session["resultReturnURL"] = "AddEditTopic.aspx?board=" + Request.QueryString["board"];
Response.Redirect("Result.aspx", true);
}
if (!dl.IsMemberAdmin(User.Identity.Name))
{
cbxSticky.Visible = false;
cbxLocked.Visible = false;
}
else
{
cbxSticky.Visible = true;
cbxLocked.Visible = true;
}
}
loggedinpanels.Controls.Add(new LiteralControl("<div style=\"width:250px;\" class=\"contenttitle\">Popular Topics</div><div style=\"font-size:15px;\" class=\"contentpanel\"><ul>"));
DataTable dtTopics = dl.GetFiveTopics();
foreach (DataRow dr in dtTopics.Rows)
{
loggedinpanels.Controls.Add(new LiteralControl("<li><a href=\"Topic.aspx?topic=" + dr.ItemArray[0].ToString() + "\">" + dr.ItemArray[4].ToString() + "</a></li>"));
}
loggedinpanels.Controls.Add(new LiteralControl("</ul></div>"));
loggedinpanels.Controls.Add(new LiteralControl("<div style=\"width:250px;\" class=\"contenttitle\">Featured Member</div><div class=\"contentpanel\">"));
DataTable dtRandomMember = dl.GetRandomMember();
loggedinpanels.Controls.Add(new LiteralControl("<table style=\"width:100%;\"><tr><td style=\"font-size:13px;text-align:center;\"><a href=\"Profile.aspx?member=" + dtRandomMember.Rows[0].ItemArray[0].ToString() + "\"><img style=\"border-width:0px;\" src=\"MakeThumbnail.aspx?size=100&image=images/MemberAvatars/" + dtRandomMember.Rows[0].ItemArray[3].ToString() + "\" /></a><br /><a href=\"Profile.aspx?member=" + dtRandomMember.Rows[0].ItemArray[0].ToString() + "\">View Profile</a></td><td style=\"padding-left:5px;font-size:13px;width:100%;\"><b>Name:</b> " + dtRandomMember.Rows[0].ItemArray[2].ToString() + "<br /><br /><b>Location:</b> " + dtRandomMember.Rows[0].ItemArray[17].ToString() + "<br /><br /><b>Business:</b> " + dtRandomMember.Rows[0].ItemArray[8].ToString() + "<br /><br />"));
if (dtRandomMember.Rows[0].ItemArray[6].ToString() != "")
{
loggedinpanels.Controls.Add(new LiteralControl("<center><a href=\"" + dtRandomMember.Rows[0].ItemArray[6].ToString() + "\">Visit Website</a></center>"));
}
loggedinpanels.Controls.Add(new LiteralControl("</td></tr></table></div>"));
DataTable dtMemberAd = dl.GetRandomAd();
loggedinpanels.Controls.Add(new LiteralControl("<div class=\"contenttitle\">Member Ad</div><div style=\"text-align:center;\" class=\"contentpanel\"><a href=\"" + dtMemberAd.Rows[0].ItemArray[2].ToString() + "\"><img style=\"width:230px; border-width:0px;\" src=\"" + dtMemberAd.Rows[0].ItemArray[1].ToString() + "\" /></a></div>"));
}示例6: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
if (Request.QueryString["post"] != null)
{
int iPostID = Convert.ToInt32(Request.QueryString["post"]);
Object[] oPost = dl.GetForumPostBy_PostID(iPostID).Rows[0].ItemArray;
if (!User.Identity.IsAuthenticated)
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Members Only";
Session["resultMessage"] = "This is a members only area.<br />You must log in first.";
Session["resultReturnURL"] = "AddEditPost.aspx?post=" + Request.QueryString["post"];
Response.Redirect("Result.aspx", true);
}
else if ((User.Identity.IsAuthenticated) && (User.Identity.Name.ToLower() != oPost[2].ToString().ToLower()) && (!dl.IsMemberAdmin(User.Identity.Name)))
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Not Authorized";
Session["resultMessage"] = "You are not authorized to edit this post.";
Session["resultReturnURL"] = "Boards.aspx";
Response.Redirect("Result.aspx", true);
}
else
{
if (!this.IsPostBack)
{
addedit.InnerText = "Edit Post";
rteBody.Value = oPost[4].ToString();
}
}
}
else
{
if (!User.Identity.IsAuthenticated)
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "Members Only";
Session["resultMessage"] = "This is a members only area.<br />You must log in first.";
Session["resultReturnURL"] = "AddEditPost.aspx?topic=" + Request.QueryString["topic"];
Response.Redirect("Result.aspx", true);
}
addedit.InnerText = "Reply To Topic";
}
if (Request.QueryString["rt"] != null)
{
int iRTPostID = Convert.ToInt32(Request.QueryString["rt"]);
DataTable dtRTPost = dl.GetForumPostBy_PostID(iRTPostID);
replyto.InnerHtml = dtRTPost.Rows[0].ItemArray[4].ToString();
postedby.InnerHtml = "Posted by <a href=\"Profile.aspx?member=" + dtRTPost.Rows[0].ItemArray[2].ToString() + "\">" + dl.GetFullMemberNameBy_Email(dtRTPost.Rows[0].ItemArray[2].ToString()) + "</a> on " + dtRTPost.Rows[0].ItemArray[3].ToString();
}
else
{
int iRTTopicID = Convert.ToInt32(Request.QueryString["topic"]);
DataTable dtRTTopic = dl.GetForumTopicBy_TopicID(iRTTopicID);
replyto.InnerHtml = dtRTTopic.Rows[0].ItemArray[5].ToString();
postedby.InnerHtml = "Posted by <a href=\"Profile.aspx?member=" + dtRTTopic.Rows[0].ItemArray[2].ToString() + "\">" + dl.GetFullMemberNameBy_Email(dtRTTopic.Rows[0].ItemArray[2].ToString()) + "</a> on " + dtRTTopic.Rows[0].ItemArray[3].ToString();
}
loggedinpanels.Controls.Add(new LiteralControl("<div style=\"width:250px;\" class=\"contenttitle\">Popular Topics</div><div style=\"font-size:15px;\" class=\"contentpanel\"><ul>"));
DataTable dtTopics = dl.GetFiveTopics();
foreach (DataRow dr in dtTopics.Rows)
{
loggedinpanels.Controls.Add(new LiteralControl("<li><a href=\"Topic.aspx?topic=" + dr.ItemArray[0].ToString() + "\">" + dr.ItemArray[4].ToString() + "</a></li>"));
}
loggedinpanels.Controls.Add(new LiteralControl("</ul></div>"));
loggedinpanels.Controls.Add(new LiteralControl("<div style=\"width:250px;\" class=\"contenttitle\">Featured Member</div><div class=\"contentpanel\">"));
DataTable dtRandomMember = dl.GetRandomMember();
loggedinpanels.Controls.Add(new LiteralControl("<table style=\"width:100%;\"><tr><td style=\"font-size:13px;text-align:center;\"><a href=\"Profile.aspx?member=" + dtRandomMember.Rows[0].ItemArray[0].ToString() + "\"><img style=\"border-width:0px;\" src=\"MakeThumbnail.aspx?size=100&image=images/MemberAvatars/" + dtRandomMember.Rows[0].ItemArray[3].ToString() + "\" /></a><br /><a href=\"Profile.aspx?member=" + dtRandomMember.Rows[0].ItemArray[0].ToString() + "\">View Profile</a></td><td style=\"padding-left:5px;font-size:13px;width:100%;\"><b>Name:</b> " + dtRandomMember.Rows[0].ItemArray[2].ToString() + "<br /><br /><b>Location:</b> " + dtRandomMember.Rows[0].ItemArray[17].ToString() + "<br /><br /><b>Business:</b> " + dtRandomMember.Rows[0].ItemArray[8].ToString() + "<br /><br />"));
if (dtRandomMember.Rows[0].ItemArray[6].ToString() != "")
{
loggedinpanels.Controls.Add(new LiteralControl("<center><a href=\"" + dtRandomMember.Rows[0].ItemArray[6].ToString() + "\">Visit Website</a></center>"));
}
loggedinpanels.Controls.Add(new LiteralControl("</td></tr></table></div>"));
DataTable dtMemberAd = dl.GetRandomAd();
loggedinpanels.Controls.Add(new LiteralControl("<div class=\"contenttitle\">Member Ad</div><div style=\"text-align:center;\" class=\"contentpanel\"><a href=\"" + dtMemberAd.Rows[0].ItemArray[2].ToString() + "\"><img style=\"width:230px; border-width:0px;\" src=\"" + dtMemberAd.Rows[0].ItemArray[1].ToString() + "\" /></a></div>"));
}