本文整理汇总了C#中DataLayer.GetArticleBy_ArticleID方法的典型用法代码示例。如果您正苦于以下问题：C# DataLayer.GetArticleBy_ArticleID方法的具体用法？C# DataLayer.GetArticleBy_ArticleID怎么用？C# DataLayer.GetArticleBy_ArticleID使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataLayer的用法示例。
在下文中一共展示了DataLayer.GetArticleBy_ArticleID方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: btnSubmit_Click
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (lbxArticles.SelectedIndex == -1)
{
DataLayer dl = new DataLayer();
DateTime dtPostTime = DateTime.Now;
dl.AddArticle(dtPostTime, tbxTitle.Text, rteBody.Value, User.Identity.Name, ddlCategory.SelectedValue);
SqlCommand sc = new SqlCommand("SELECT ArticleID FROM rnxArticles WHERE [email protected] AND [email protected]");
sc.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc.Parameters.Add(new SqlParameter("Date", dtPostTime));
DataSet ds = dl.CustomQuery(sc);
try
{
WebRequest wrGETURL;
wrGETURL = WebRequest.Create("http://tinyurl.com/api-create.php?url=http://www.ReferralNetworX.com/Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString());
Stream objStream;
objStream = wrGETURL.GetResponse().GetResponseStream();
StreamReader objReader = new StreamReader(objStream);
string sURL = objReader.ReadToEnd();
Yedda.Twitter t = new Yedda.Twitter();
t.Update("ReferralNetworX", "1million!", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("Chevex", "Ch3vyF0rd!", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
t.Update("WALTatRNX", "robinwalt98", "New RNX Article: " + tbxTitle.Text + " " + sURL, Yedda.Twitter.OutputFormatType.XML);
}
catch
{ }
if (cbxDiscussionThread.Checked)
{
dl.AddForumTopic(14, User.Identity.Name, tbxTitle.Text, "<a href=\"Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view article</a><br /><br />Discuss this article below.", dtPostTime, false, false);
SqlCommand sc2 = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE [email protected] AND [email protected]");
sc2.Parameters.Add(new SqlParameter("Title", tbxTitle.Text));
sc2.Parameters.Add(new SqlParameter("Date", dtPostTime));
DataSet ds2 = dl.CustomQuery(sc2);
string sTopicID = ds2.Tables[0].Rows[0].ItemArray[0].ToString();
dl.UpdateArticle(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]), tbxTitle.Text, rteBody.Value + "<br /><br /><a href=\"Topic.aspx?topic=" + sTopicID + "\">Click to discuss this article</a>");
}
SmtpClient smtp = new SmtpClient("localhost");
MailMessage mm;
mm = new MailMessage();
mm.IsBodyHtml = true;
mm.To.Add("[email protected]");
mm.To.Add("[email protected]");
mm.From = new MailAddress("[email protected]");
mm.Subject = "Someone posted an article.";
mm.Body = dl.GetFullMemberNameBy_Email(User.Identity.Name) + " posted an article titled: " + tbxTitle.Text;
mm.Body += "<br /><a href=\"http://www.referralnetworx.com/Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString() + "\">Click to view</a>";
mm.Body += "<br /><br />The article is below:<br /><br />" + rteBody.Value;
smtp.Send(mm);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Added";
Session["resultMessage"] = "Article Added Successfuly";
Session["resultReturnURL"] = "Article.aspx?aid=" + ds.Tables[0].Rows[0].ItemArray[0].ToString();
Response.Redirect("Result.aspx");
}
else
{
if (cbxDeleteArticle.Checked)
{
DataLayer dl = new DataLayer();
DataTable dtArticle = dl.GetArticleBy_ArticleID(Convert.ToInt32(lbxArticles.SelectedValue));
try
{
SqlCommand sc = new SqlCommand("SELECT TopicID FROM rnxForumTopics WHERE [email protected] AND [email protected]");
sc.Parameters.Add(new SqlParameter("Title", dtArticle.Rows[0].ItemArray[2].ToString()));
sc.Parameters.Add(new SqlParameter("Date", Convert.ToDateTime(dtArticle.Rows[0].ItemArray[1])));
DataSet ds = dl.CustomQuery(sc);
dl.DeleteForumTopic(Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]));
}
catch
{
}
dl.DeleteArticle(Convert.ToInt32(lbxArticles.SelectedValue));
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Deleted";
Session["resultMessage"] = "Article Deleted Successfuly";
Session["resultReturnURL"] = "ManageArticles.aspx";
Response.Redirect("Result.aspx");
}
else
{
DataLayer dl = new DataLayer();
dl.UpdateArticle(Convert.ToInt32(lbxArticles.SelectedValue), tbxTitle.Text, rteBody.Value);
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Article Updated";
Session["resultMessage"] = "Article Updated Successfuly";
Session["resultReturnURL"] = "ManageArticles.aspx";
Response.Redirect("Result.aspx");
}
}
}示例2: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
//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"] = "Articles.aspx";
// Response.Redirect("Result.aspx", true);
//}
int iAID = 0;
if (Request.QueryString["aid"] == null)
{
Session["resultColor"] = "#ff0000";
Session["resultTitle"] = "No Article";
Session["resultMessage"] = "No Article Specified";
Session["resultReturnURL"] = "Articles.aspx";
Response.Redirect("Result.aspx", true);
}
else
{
iAID = Convert.ToInt32(Request.QueryString["aid"]);
}
DataLayer dl = new DataLayer();
if (User.Identity.IsAuthenticated)
{
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>"));
if (User.Identity.IsAuthenticated)
{
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>"));
}
DataTable dtArticle = dl.GetArticleBy_ArticleID(iAID);
if (dtArticle.Rows.Count == 0)
{
this.Title = "No Article Found";
articletitle.InnerText = "No Article Found";
}
else
{
this.Title = dtArticle.Rows[0].ItemArray[2].ToString();
articletitle.InnerText = dtArticle.Rows[0].ItemArray[2].ToString();
postedby.InnerHtml = "Posted by <a href=\"Profile.aspx?member=" + dtArticle.Rows[0].ItemArray[4].ToString() + "\">" + dl.GetFullMemberNameBy_Email(dtArticle.Rows[0].ItemArray[4].ToString()) + "</a>";
articlebody.InnerHtml = "<!-- AddThis Button BEGIN --><script type=\"text/javascript\">var addthis_pub=\"chevex\"; var addthis_hide_embed = true;</script><a href=\"http://www.addthis.com/bookmark.php?v=20\" onmouseover=\"return addthis_open(this, '', '[URL]', '[TITLE]')\" onmouseout=\"addthis_close()\" onclick=\"return addthis_sendto()\"><img src=\"http://s7.addthis.com/static/btn/sm-share-en.gif\" width=\"83\" height=\"16\" alt=\"Bookmark and Share\" style=\"border:0;\"/></a><script type=\"text/javascript\" src=\"http://s7.addthis.com/js/200/addthis_widget.js\"></script><!-- AddThis Button END --><br /><br />" + dtArticle.Rows[0].ItemArray[3].ToString();
DataTable dtMember = dl.GetMemberBy_Email(dtArticle.Rows[0].ItemArray[4].ToString());
articlebody.InnerHtml += "<br /><br />------------------------------------------------------<br />" + dtMember.Rows[0].ItemArray[18].ToString();
}
}示例3: lbxArticles_SelectedIndexChanged
protected void lbxArticles_SelectedIndexChanged(object sender, EventArgs e)
{
checklist.Visible = false;
cbxDeleteArticle.Checked = false;
cbxDeleteArticle_CheckedChanged(null, null);
addedit.InnerText = "Edit Article";
DataLayer dl = new DataLayer();
DataTable dtArticle = dl.GetArticleBy_ArticleID(Convert.ToInt32(lbxArticles.SelectedValue));
cbxDeleteArticle.Visible = true;
spanAuthor.InnerText = dl.GetFullMemberNameBy_Email(dtArticle.Rows[0].ItemArray[4].ToString());
tbxTitle.Text = dtArticle.Rows[0].ItemArray[2].ToString();
rteBody.Value = dtArticle.Rows[0].ItemArray[3].ToString();
postedby.Visible = true;
cbxDiscussionThread.Checked = false;
cbxDiscussionThread.Visible = false;
}