private void GetPreNextData()
{
string qryString;
qryString = "SELECT bNews_id,bnsGroup,bnsTitle,bnsOrder,bnsStatus"
+ " FROM t_BoardNews WHERE bnsStatus > 1 "
+ " ORDER BY bnsOrder DESC,bNews_id DESC";
DataTable dTable = dbUtil.MyFillTable(qryString);
int i;
for (i = 0; i < dTable.Rows.Count - 1; i++)
{
if (dTable.Rows[i]["bNews_id"].ToString() == bnsID)
{
break;
}
//Response.Write("cccccccccc = " + dTable.Rows[i]["bNews_id"].ToString() + "<br>");
}
//Response.Write("i = " + i.ToString() + "<br>");
string strTemp;
DataRow dRow;
//이전글 가져오기
if (i < dTable.Rows.Count - 1)
{
dRow = dTable.Rows[i + 1];
strTemp = "[" + dRow["bnsGroup"].ToString() + "] " + Text.ShortenString(dRow["bnsTitle"].ToString(), 40);
this.hlPreData.Text = strTemp;
this.hlPreData.NavigateUrl = Request.Url.AbsolutePath.ToString() + "?bnsID=" + dRow["bNews_id"].ToString();
if (bnsG != null)
{
this.hlPreData.NavigateUrl += "&bnsG=" + bnsG;
}
}
else
{
this.hlPreData.Text = "이전글이 없습니다";
this.hlPreData.ForeColor = Color.Gray;
}
//다음글 가져오기
if (i > 0)
{
dRow = dTable.Rows[i - 1];
strTemp = "[" + dRow["bnsGroup"].ToString() + "] " + Text.ShortenString(dRow["bnsTitle"].ToString(), 40);
this.hlNextData.Text = strTemp;
this.hlNextData.NavigateUrl = Request.Url.AbsolutePath.ToString() + "?bnsID=" + dRow["bNews_id"].ToString();
if (bnsG != null)
{
this.hlNextData.NavigateUrl += "&bnsG=" + bnsG;
}
}
else
{
this.hlNextData.Text = "다음글이 없습니다";
this.hlNextData.ForeColor = Color.Gray;
}
// foreach (DataRow drow in dTable.Rows)
// {
//
// Response.Write("cccccccccc = " + drow["bNews_id"] + " : " + drow["bnsTitle"] + ":" + drow["bnsOrder"] + "<br>");
// this.bnsContent.Text += "dddd = " + drow["bNews_id"] + " : " + drow["bnsTitle"] + ":" + drow["bnsOrder"] + "<br>";
// }
}
