/// <summary>
/// 덧글 리스트를 가져온다.
/// </summary>
/// <param name="articleNo"></param>
/// <returns></returns>
public static CommentBindModel GetCommentList(int articleNo)
{
SqlParameter[] param = { CreateInParam("@ArticleNo", SqlDbType.Int, 4, articleNo) };
SqlCommand cmd = GetSpCommand("UBC_GetCommentList", param);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CommentBindModel bindModel;
try
{
bindModel = new CommentBindModel(articleNo);
while (reader.Read())
{
CommentModel model = new CommentModel();
FillComment(reader, model);
bindModel.Add(model);
model = null;
}
return(bindModel);
}
catch (Exception ex)
{
throw ex;
}
finally
{
ReleaseCommand(cmd);
}
}
/// <summary>
/// 최신 댓글 리스트를 갯수만큼 가져온다.
/// </summary>
/// <param name="count"></param>
/// <returns></returns>
public static CommentBindModel GetRecentCommentList(int count)
{
SqlParameter[] param = { CreateInParam("@Count", SqlDbType.Int, 4, count) };
SqlCommand cmd = GetSpCommand("UBC_GetRecentCommentList", param);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CommentBindModel bindModel = new CommentBindModel();
try
{
while (reader.Read())
{
CommentModel model = new CommentModel();
FillComment(reader, model);
bindModel.Add(model);
model = null;
}
return(bindModel);
}
catch (Exception ex)
{
throw new UmcDataException("UBC_GetRecentCommentList 프로시져 호출중 에러", ex);
}
finally
{
ReleaseCommand(cmd);
}
}
private void bind()
{
int count = BlogManager.GetInstance().BlogBaseModel.BlogModel.RecentCommentListCount;
CommentBindModel bindModel = CommentManager.GetInstance().GetRecentCommentList(count);
DataList dlRecentComment = (DataList)snap_RecentComment.FindControl("panel1").FindControl("dlRecentComment");
dlRecentComment.DataSource = bindModel;
dlRecentComment.DataBind();
}
protected void bind()
{
if (IsLogin)
{
txtUserName.Text = CurrentUserInfo.NickName;
txtUserBlogUrl.Text = CurrentUserInfo.Homepage;
}
CommentBindModel bindModel = CommentManager.GetInstance().GetCommentList(articleNo);
dlCommentList.DataSource = bindModel;
dlCommentList.DataBind();
}
