public static dto_Topic GetTopic(int Id) { dto_Topic model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BBSConnString), "select Id, UserId, Invites, Title, TopicContent, TopicText, CreateDate, Good, Hit, ReplyCount, GradeId, SubjectId, Deleted, Blocked, Ip from T_Topic where Id = @Id", "@Id".ToInt32InPara(Id))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_Topic>(dr); } } return(model); }
/// <summary> /// 查看详情 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult detail(int id) { dto_Topic t = B_Topic.GetTopic(id); if (t != null) { T_User u = B_UserRedis.GetUser(t.UserId); t.UserName = u == null ? "" : u.UserName; t.TrueName = u == null ? "" : u.TrueName; string GradeName = "", SubjectName = ""; Const.Grades.TryGetValue(t.GradeId, out GradeName); Const.Subjects.TryGetValue(t.SubjectId, out SubjectName); t.GradeName = GradeName; t.SubjectName = SubjectName; } ViewBag.TopicInfo = t; return(View()); }