/*驗貨情況*/
void prepareProcessCommentList()
{
string sqlstr = "select 0 as Form_No, '' as comment union(select Form_No, comment from Verify) order by Form_No ";
CommentList.DataSource = mydb.GetDataTable(sqlstr);
CommentList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated)
{
RedirectToLoginPage();
}
CommentList.DataSource = AuctionList_GetData();
CommentList.DataBind();
}
protected void ShowComment_Click(object sender, EventArgs e)
{
if (TaskList.SelectedIndex != -1)
{
string cs = ConfigurationManager.ConnectionStrings["LoginConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("Select Comment, CommentedBy, DateTime from TaskComment where TaskName='" + TaskList.SelectedItem.ToString() + "'", conn);
//SqlCommand cmd = new SqlCommand("Select * from TimeTable", con);
conn.Open();
CommentList.DataSource = cmd.ExecuteReader();
CommentList.DataBind();
conn.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Dal.Story story = StoryCache.GetStory(UrlParameters.StoryIdentifier, HostProfile.HostID);
if (story == null || story.IsSpam && !this.KickUserProfile.IsModerator)
{
Response.Redirect("/missingstory");
}
Title = story.Title;
Caption = "";
UsersWhoKicked.DataBind(story.UsersWhoKicked);
StorySummary.DataBind(story);
StorySummary.ShowMoreLink = false;
StorySummary.ShowGetKickImageCodeLink = true;
CommentList.DataBind(StoryCache.GetComments(story.StoryID));
AddComment.DataBind(story.StoryID);
DisplayAds = true;
KickMenu.DisplayAds = true;
KickMenu.DisplayCategories = false;
KickMenu.DisplayWhatElse = false;
KickItImagePersonalization.StoryUrl = story.Url;
if (!String.IsNullOrEmpty(story.AdsenseID))
{
if (KickUserProfile.UserID != story.UserID)
{
//flick a coin
if (ThreadSafeRandom.FlickCoin())
{
System.Diagnostics.Debug.WriteLine("Showing author ads " + story.AdsenseID);
AdSenseID = story.AdsenseID;
}
}
}
//related stories control
RelatedStories.DataBind(SimilarStoriesCache.GetSimilarStoryCollection(this.HostProfile.HostID, story.StoryID));
}
void Bind()
{
CommentList.DataSource = Comments_B.CommentsListPager(CommentPager.PageSize.ToString(), CommentPager.CurrentPageIndex.ToString());
CommentList.DataBind();
}
private void BuildPage()
{
if (Request.QueryString["id"] == null)
{
//CommentCollection cc = new CommentCollection();
Query q = Comment.CreateQuery();
if (!(Request.QueryString["a"] == "d"))
{
q.AndWhere(Comment.Columns.IsPublished, !(Request.QueryString["a"] == "f"));
}
q.AndWhere(Comment.Columns.IsDeleted, (Request.QueryString["a"] == "d"));
if (!String.IsNullOrEmpty(Request.QueryString["pid"]))
{
q.AndWhere(Comment.Columns.PostId, Request.QueryString["pid"]);
}
q.OrderByDesc(Comment.Columns.Id);
CommentCollection tempCC = CommentCollection.FetchByQuery(q);
CommentCollection permissionsFilteredCount = new CommentCollection();
permissionsFilteredCount.AddRange(tempCC);
foreach (Comment c in tempCC)
{
if (!RolePermissionManager.GetPermissions(c.Post.CategoryId, GraffitiUsers.Current).Read)
{
permissionsFilteredCount.Remove(c);
}
}
q.PageIndex = Int32.Parse(Request.QueryString["p"] ?? "1");
q.PageSize = 25;
CommentCollection cc = CommentCollection.FetchByQuery(q);
CommentCollection permissionsFiltered = new CommentCollection();
permissionsFiltered.AddRange(cc);
foreach (Comment c in cc)
{
if (!RolePermissionManager.GetPermissions(c.Post.CategoryId, GraffitiUsers.Current).Read)
{
permissionsFiltered.Remove(c);
}
}
CommentList.DataSource = permissionsFiltered;
CommentList.DataBind();
string qs = Request.QueryString["a"] != null ? "?a=" + Request.QueryString["a"] : "?a=t";
Pager.Text = Util.Pager(q.PageIndex, q.PageSize, permissionsFilteredCount.Count, "navigation", qs);
if (Request.QueryString["a"] == "f")
{
CommentLinks.SetActiveView(PendingComments);
}
else if (Request.QueryString["a"] == "d")
{
CommentLinks.SetActiveView(DeletedComments);
}
}
else
{
the_Views.SetActiveView(Comment_Form);
Comment comment = new Comment(Request.QueryString["id"]);
if (comment.IsNew)
{
throw new Exception("Invalid Comment Id");
}
txtName.Text = Server.HtmlDecode(comment.Name);
txtSite.Text = comment.WebSite;
txtEmail.Text = comment.Email;
CommentEditor.Text = comment.Body;
}
#region build the page title
StringBuilder sb = new StringBuilder();
string page = Request.QueryString["a"] ?? "t";
switch (page)
{
case "t":
sb.Append("Published ");
break;
case "f":
sb.Append("Pending ");
break;
case "d":
sb.Append("Deleted ");
break;
}
sb.Append(" Comments");
lblPageTitle.Text = sb.ToString();
string post = Request.QueryString["pid"];
if (!String.IsNullOrEmpty(post))
{
Post p = new Post(Convert.ToInt32(post));
lblPageTitle.Text += " for \"" + p.Name + "\"";
}
#endregion
}
private void fetchData(List <CommentsView> comments)
{
CommentList.DataSource = comments;
CommentList.DataBind();
}
