/// <summary>
/// 根据ID查访客
/// </summary>
/// <param name="id">访客ID</param>
/// <returns>返回类</returns>
public static Users_M UserByID(string id)
{
Users_M user = new Users_M();
string sql = "select * from Users where UserId=" + id;
SqlDataReader dr = SQLDBHelper.ExecuteReader(sql);
if (dr.HasRows)
{
dr.Read();
if (dr["UserId"] != DBNull.Value)
{
user.UserId = Convert.ToInt32(dr["UserId"]);
}
if (dr["Username"] != DBNull.Value)
{
user.Username = Convert.ToString(dr["Username"]);
}
if (dr["UserEmail"] != DBNull.Value)
{
user.UserEmail = Convert.ToString(dr["UserEmail"]);
}
if (dr["UserIP"] != DBNull.Value)
{
user.UserIP = Convert.ToString(dr["UserIP"]);
}
}
dr.Close();
return(user);
}
protected void CommentList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
HiddenField UserId = e.Item.FindControl("UserId") as HiddenField;
Label userName = e.Item.FindControl("userName") as Label;
if (!string.IsNullOrWhiteSpace(UserId.Value))
{
Users_M user = Users_B.UserByID(UserId.Value);
userName.Text = user.Username;
}
HiddenField PostId = e.Item.FindControl("PostId") as HiddenField;
Label PostTitle = e.Item.FindControl("PostTitle") as Label;
if (!string.IsNullOrWhiteSpace(PostId.Value))
{
Posts_M post = Posts_B.PostByID(PostId.Value);
PostTitle.Text = post.Title;
}
}
