本文整理汇总了C#中DataLayer.GetTPEntryBy_UserAndDate方法的典型用法代码示例。如果您正苦于以下问题：C# DataLayer.GetTPEntryBy_UserAndDate方法的具体用法？C# DataLayer.GetTPEntryBy_UserAndDate怎么用？C# DataLayer.GetTPEntryBy_UserAndDate使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataLayer的用法示例。
在下文中一共展示了DataLayer.GetTPEntryBy_UserAndDate方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: btnUpdate_Click
protected void btnUpdate_Click(object sender, EventArgs e)
{
DataLayer dl = new DataLayer();
DataTable dtTomorrowsPlan = dl.GetTPEntryBy_UserAndDate(User.Identity.Name, DateTime.Now.AddDays(1).Date);
if (dtTomorrowsPlan.Rows.Count > 0)
{
int iEntryID = Convert.ToInt32(dtTomorrowsPlan.Rows[0].ItemArray[0]);
dl.UpdateTPEntry(iEntryID, tbxTomorrowsPlan.Text);
Session["resultMessage"] = "Your plan for tomorrow was updated successfuly!";
}
else
{
dl.AddTPEntry(User.Identity.Name, DateTime.Now.AddDays(1).Date, tbxTomorrowsPlan.Text);
Session["resultMessage"] = "Your plan for tomorrow was created successfully!";
}
Session["resultColor"] = "#007700";
Session["resultTitle"] = "Success";
Session["resultReturnURL"] = "TomorrowPlanner.aspx";
Response.Redirect("Result.aspx", true);
}示例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"] = "SuccessMeter.aspx";
Response.Redirect("Result.aspx", true);
}
DataLayer dl = new DataLayer();
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 (!this.IsPostBack)
{
DataTable dtTomorrowsPlan = dl.GetTPEntryBy_UserAndDate(User.Identity.Name, DateTime.Now.AddDays(1).Date);
if (dtTomorrowsPlan.Rows.Count > 0)
{
tbxTomorrowsPlan.Text = dtTomorrowsPlan.Rows[0].ItemArray[3].ToString();
btnUpdate.Text = "Save Changes";
}
else
{
btnUpdate.Text = "Save";
}
}
}示例3: 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"] = "SuccessMeter.aspx";
Response.Redirect("Result.aspx", true);
}
DataLayer dl = new DataLayer();
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 (!this.IsPostBack)
{
DataTable dtPlannedForToday = dl.GetTPEntryBy_UserAndDate(User.Identity.Name, DateTime.Now.Date);
if (dtPlannedForToday.Rows.Count > 0)
{
plannedfortoday.Visible = true;
todaysplan.InnerHtml = dtPlannedForToday.Rows[0].ItemArray[3].ToString().Replace("\r", "<br />").Replace("\n", "");
}
else
{
plannedfortoday.Visible = false;
}
DataTable dtDidToday = dl.GetSMEntryBy_UserAndDate(User.Identity.Name, DateTime.Now.Date);
if (dtDidToday.Rows.Count > 0)
{
tbxDidToday.Text = dtDidToday.Rows[0].ItemArray[3].ToString();
btnUpdate.Text = "Save Changes";
int iRating = Convert.ToInt32(dtDidToday.Rows[0].ItemArray[4]);
if (iRating == 1)
{
btnStar1.ImageUrl = "images/ratingstar.gif";
btnStar2.ImageUrl = "images/ratingstar_light.gif";
btnStar3.ImageUrl = "images/ratingstar_light.gif";
btnStar4.ImageUrl = "images/ratingstar_light.gif";
btnStar5.ImageUrl = "images/ratingstar_light.gif";
}
else if (iRating == 2)
{
btnStar1.ImageUrl = "images/ratingstar.gif";
btnStar2.ImageUrl = "images/ratingstar.gif";
btnStar3.ImageUrl = "images/ratingstar_light.gif";
btnStar4.ImageUrl = "images/ratingstar_light.gif";
btnStar5.ImageUrl = "images/ratingstar_light.gif";
}
else if (iRating == 3)
{
btnStar1.ImageUrl = "images/ratingstar.gif";
btnStar2.ImageUrl = "images/ratingstar.gif";
btnStar3.ImageUrl = "images/ratingstar.gif";
btnStar4.ImageUrl = "images/ratingstar_light.gif";
btnStar5.ImageUrl = "images/ratingstar_light.gif";
}
else if (iRating == 4)
{
btnStar1.ImageUrl = "images/ratingstar.gif";
btnStar2.ImageUrl = "images/ratingstar.gif";
btnStar3.ImageUrl = "images/ratingstar.gif";
btnStar4.ImageUrl = "images/ratingstar.gif";
btnStar5.ImageUrl = "images/ratingstar_light.gif";
}
else if (iRating == 5)
{
btnStar1.ImageUrl = "images/ratingstar.gif";
btnStar2.ImageUrl = "images/ratingstar.gif";
btnStar3.ImageUrl = "images/ratingstar.gif";
btnStar4.ImageUrl = "images/ratingstar.gif";
btnStar5.ImageUrl = "images/ratingstar.gif";
}
}
else
{
btnUpdate.Text = "Save";
}
}
}