public List <BoardReplyBean> TOTALBBS_BOARD_REPLY_INFO_SEL(int PagePerData, int CurrentPage, string GET_TYPE, int Idx)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PagePerData", PagePerData),
new SqlParameter("@CurrentPage", CurrentPage),
new SqlParameter("@GET_TYPE", GET_TYPE),
new SqlParameter("@intIdx", Idx)
};
List <BoardReplyBean> GetList = new List <BoardReplyBean>();
using (SqlDataReader dr = SQLHelper.ExecuteReader(Global.DataBaseConnection, "[dbo].[UP_TOTALBBS_BOARD_REPLY_INFO_SEL_SP]", parameters))
{
while (dr.Read())
{
BoardReplyBean Bean = new BoardReplyBean();
Bean.intIdx = Convert.ToInt32(dr["intIdx"]);
Bean.intParentIdx = Convert.ToInt32(dr["intParentIdx"]);
Bean.intBBSIdx = Convert.ToInt32(dr["intBBSIdx"]);
Bean.intDepth = Convert.ToInt32(dr["intDepth"]);
Bean.strUserId = dr["strUserId"].ToString();
Bean.strWriter = dr["strWriter"].ToString();
Bean.strContent = dr["strContent"].ToString();
Bean.dateRegDate = dr["dateRegDate"].ToString();
GetList.Add(Bean);
}
return(GetList);
}
}
protected void rptGetList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
// 데이타 처리
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
BoardReplyBean GetItems = (BoardReplyBean)e.Item.DataItem;
Literal ltThWriter = (Literal)e.Item.FindControl("ltThWriter");
Literal ltContent = (Literal)e.Item.FindControl("ltContent");
Literal lbtThRegDate = (Literal)e.Item.FindControl("lbtThRegDate");
ltThWriter.Text = GetItems.strWriter;
ltContent.Text = GetItems.strContent;
lbtThRegDate.Text = GetItems.dateRegDate;
}
if (e.Item.ItemType == ListItemType.Footer)
{
if (NoDataTotalCnt == 0)
{
Literal ltNoData = (Literal)e.Item.FindControl("ltNoData"); //데이타가 없는경우
ltNoData.Text = "<tr><td colspan=2>조회된 데이터가 없습니다.</td></tr>";
}
}
}
