/// <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; } }