public List <BoardBean> TOTALBBS_BOARD_NOTICE_INFO_SEL(int PagePerData, string GET_TYPE)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@PagePerData", PagePerData),
new SqlParameter("@GET_TYPE", GET_TYPE)
};
List <BoardBean> GetList = new List <BoardBean>();
using (SqlDataReader dr = SQLHelper.ExecuteReader(Global.DataBaseConnection, "[dbo].[UP_TOTALBBS_BOARD_NOTICE_INFO_SEL_SP]", parameters))
{
while (dr.Read())
{
BoardBean Bean = new BoardBean();
Bean.intIdx = Convert.ToInt32(dr["intIdx"]);
Bean.intBoardCategory = Convert.ToInt32(dr["intBoardCategory"]);
Bean.intWriteCategory = Convert.ToInt32(dr["intWriteCategory"]);
Bean.strUserId = dr["strUserId"].ToString();
Bean.strWriter = dr["strWriter"].ToString();
Bean.strSubject = dr["strSubject"].ToString();
Bean.intViewCount = Convert.ToInt32(dr["intViewCount"]);
Bean.dateRegDate = dr["dateRegDate"].ToString();
Bean.intReplyCount = Convert.ToInt32(dr["intReplyCount"]);
GetList.Add(Bean);
}
return(GetList);
}
}
public List <BoardBean> selectBoard()
{
//DB접속 문자열 취득
string connectionString = ConfigurationManager.ConnectionStrings["TestDB"].ConnectionString;//App.config에서 작성한 DB정보
List <BoardBean> list = new List <BoardBean>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
//DB에 접속
connection.Open();
//커맨드 생성
SqlCommand command = connection.CreateCommand();
//SQL 준비
command.CommandText = @"SELECT *
FROM examsite
WHERE boardId = @boardID";//커맨드 입력
//파라메터 정의
command.Parameters.AddWithValue("@boardId", "free");
using (SqlDataReader reader = command.ExecuteReader()) //다중 레코드를 반환하는 쿼리
{
while (reader.Read() == true) //다음 레코드를 읽음, 레코드가 존재하지 않을때까지 반복
{
BoardBean bean = new BoardBean(); //빈 생성
bean.BoardNum = Convert.ToInt32(reader["boardNum"]); //빈에 정보 입력
bean.BoardId = reader["boardId"] as string;
list.Add(bean); //리스트에 추가
}
}
}
catch (Exception e)
{
Console.WriteLine("Error : " + e);
throw;
}
}
return(list);
}
protected void rptGetList_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Header)
{
Literal ltThChkBoxAll = (Literal)e.Item.FindControl("ltThChkBoxAll");
LinkButton lbtThIdx = (LinkButton)e.Item.FindControl("lbtThIdx");
LinkButton lbtThBoardCate = (LinkButton)e.Item.FindControl("lbtThBoardCate");
LinkButton lbtThWriteCate = (LinkButton)e.Item.FindControl("lbtThWriteCate");
LinkButton lbtThSubject = (LinkButton)e.Item.FindControl("lbtThSubject");
LinkButton lbtThViewCount = (LinkButton)e.Item.FindControl("lbtThViewCount");
LinkButton lbtThWriter = (LinkButton)e.Item.FindControl("lbtThWriter");
LinkButton lbtThRegdate = (LinkButton)e.Item.FindControl("lbtThRegdate");
ltThChkBoxAll.Text = "<input type=\"checkbox\" onclick=\"SelectAllCheckBoxes(this);\" id=\"SelectAllCheckBox\" />";
lbtThIdx.Text = "일련번호";
lbtThIdx.OnClientClick = "if(!FrmSort('IDX')) return false;";
lbtThBoardCate.Text = "게시판 카테고리";
lbtThBoardCate.OnClientClick = "if(!FrmSort('BCD')) return false;";
lbtThWriteCate.Text = "게시글 카테고리";
lbtThWriteCate.OnClientClick = "if(!FrmSort('WCD')) return false;";
lbtThSubject.Text = "제목";
lbtThSubject.OnClientClick = "if(!FrmSort('SUB')) return false;";
lbtThViewCount.Text = "조회수";
lbtThViewCount.OnClientClick = "if(!FrmSort('VCT')) return false;";
lbtThWriter.Text = "작성자";
lbtThWriter.OnClientClick = "if(!FrmSort('WRT')) return false;";
lbtThRegdate.Text = "등록일";
lbtThRegdate.OnClientClick = "if(!FrmSort('REG')) return false;";
}
// 데이타 처리
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
BoardBean GetItems = (BoardBean)e.Item.DataItem;
Literal ltChkBoxList = (Literal)e.Item.FindControl("ltChkBoxList");
Literal ltIdx = (Literal)e.Item.FindControl("ltIdx");
Literal ltBoardCate = (Literal)e.Item.FindControl("ltBoardCate");
Literal ltWriteCate = (Literal)e.Item.FindControl("ltWriteCate");
LinkButton lbtSubject = (LinkButton)e.Item.FindControl("lbtSubject");
Literal ltViewCount = (Literal)e.Item.FindControl("ltViewCount");
Literal ltWriter = (Literal)e.Item.FindControl("ltWriter");
Literal ltRegdate = (Literal)e.Item.FindControl("ltRegdate");
ltChkBoxList.Text = "<input type=\"checkbox\" name=\"ChkBoxList\" id=\"ChkBoxList\" value=\"" + GetItems.intIdx.ToString() + "\" />";
ltIdx.Text = Convert.ToString(TotalCnt--);
lbtSubject.Text = GetItems.strSubject + " (" + GetItems.intReplyCount + ")";
lbtSubject.OnClientClick = "if(!FrmModify('" + GetItems.intIdx.ToString() + "','')) return false;";
//lbtSubject.PostBackUrl = "/BackOffice/Board/BoardWrite.aspx";
Common_NTx_Dac ddlSet = new Common_NTx_Dac();
DataTable AllCategorydt = ddlSet.TOTALBBS_ALL_CATEGORY_INFO_SEL(-1);
string strBoardCategory = (AllCategorydt.AsEnumerable().Where(p => (p["intIdx"].ToString() == Convert.ToString(GetItems.intBoardCategory)) && (p["chrCateGubun"].ToString() == "B")).Select(p => p["strCateName"].ToString())).FirstOrDefault();
string strWriteCategory = (AllCategorydt.AsEnumerable().Where(p => (p["intIdx"].ToString() == Convert.ToString(GetItems.intWriteCategory)) && (p["chrCateGubun"].ToString() == "W")).Select(p => p["strCateName"].ToString())).FirstOrDefault();
//ltBoardCate.Text = Convert.ToString(GetItems.intBoardCategory);
ltBoardCate.Text = strBoardCategory;
//ltWriteCate.Text = Convert.ToString(GetItems.intWriteCategory);
ltWriteCate.Text = strWriteCategory;
ltWriter.Text = GetItems.strWriter;
ltViewCount.Text = Convert.ToString(GetItems.intViewCount);
ltRegdate.Text = GetItems.dateRegDate;
}
if (e.Item.ItemType == ListItemType.Footer)
{
if (NoDataTotalCnt == 0)
{
Literal ltNoData = (Literal)e.Item.FindControl("ltNoData"); //데이타가 없는경우
ltNoData.Text = string.Format("<tr><td colspan=\"{ 0}\">{1}</td></tr>", "7", "조회된 데이터가 없습니다.");
}
}
}
