// gridView에 data bind 해주는 부분
protected void Page_Load(object sender, EventArgs e)
{
BoardDAO boarddao = new BoardDAO();
this.dateOrderSQL = "";
this.writerOrderSQL = "";
this.titleOrderSQL = "";
if (!IsPostBack)
{
this.dateOrderSQL = "board_date DESC";
this.writerOrderSQL = "";
this.titleOrderSQL = "";
this.isSelectDelete = false;
this.numberPage = 10;
this.pageNum = 1;
reader = (DataTable)ViewState["boards"];
if (reader == null)
{
reader = boarddao.selectAll();
ViewState["boards"] = reader;
}
setBoardList();
}
}
// 글 작성시 실행 되는 함수
// 수정일 경우와 수정이 아닐 경우에 따라 처리해주는 함수
protected void Page_Load(object sender, EventArgs e)
{
title = "";
writer = "";
pw = "";
date = "";
content = "";
writerDisabled = "";
pwDisabled = "";
String update = Request.QueryString["update"];
boardid = Request.QueryString["boardid"];
BoardDAO boarddao = new BoardDAO();
//수정
if (update == "1")
{
Boards board = boarddao.Select(boardid);
title = board.getBoardTitle();
pw = board.getBoardPw();
writer = board.getBoardWriter();
date = board.getBoardDate().ToString();
content = board.getBoardContent();
btnboardWrite.Text = "수정";
isUpdate = "true";
writerDisabled = "readonly";
pwDisabled = "readonly";
}
}
// 데이터베이스에 저장해주는 함수
protected void Page_Load(object sender, EventArgs e)
{
string boardTitle = Request.Form["boardTitle"] == null ? "" : Request.Form["boardTitle"].ToString();
string boardWriter = Request.Form["boardWriter"] == null ? "" : Request.Form["boardWriter"].ToString();
string boardPw = Request.Form["boardPw"] == null ? "" : Request.Form["boardPw"].ToString();
string boardContent = Request.Form["boardContent"] == null ? "" : Request.Form["boardContent"].ToString();
string isboardUpdate = Request.Form["isboardUpdate"] == null ? "" : Request.Form["isboardUpdate"].ToString();
string boardId = Request.Form["BoardId"] == null ? "" : Request.Form["BoardId"].ToString();
BoardDAO boarddao = new BoardDAO();
// 수정이 아닐 경우
if (isboardUpdate != "true")
{
boarddao.Insert(boardTitle, boardWriter, boardContent, boardPw);
}
// 수정일 경우
else if (isboardUpdate == "true")
{
boarddao.Update(boardTitle, boardWriter, boardContent, boardId);
}
ErrorGo("완료되었습니다", "Board_Main.aspx");
}
// gridView의 databind해주는 함수
protected void setBoardList()
{
BoardDAO boarddao = new BoardDAO();
boardList.DataSource = reader;
boardList.DataBind();
lblPageDetail.Text = "전체 " + reader.Rows.Count + " 건 / " + (boardList.PageIndex + 1) + " 페이지";
}
// 페이지에 보여지는 글 수 선택하면 실행되는 함수
// gridView의 사이즈 조정해주는 함수
protected void ddlPageNumPerPage_SelectedIndexChanged(object sender, EventArgs e)
{
BoardDAO boarddao = new BoardDAO();
this.numberPage = int.Parse(ddlPageNumPerPage.SelectedValue);
boardList.PageSize = numberPage;
reader = (DataTable)ViewState["boards"];
setBoardList();
}
// 삭제해주는 함수
protected void delete(object sender, EventArgs e)
{
if (btnDelete.Text == "삭제")
{
isSelectDelete = !isSelectDelete;
boardList.Columns[0].Visible = isSelectDelete;
txtPw.Visible = true;
txtPw.Text = "";
btnDelete.Text = "확인";
}
else if (btnDelete.Text == "확인")
{
BoardDAO boarddao = new BoardDAO();
int deleteNum = 0;
ArrayList deleteBoardNum = new ArrayList();
String deleteBoardPw = "";
// 체크된 체크박스 확인해주는 부분
for (int i = 0; i < boardList.Rows.Count; i++)
{
if (((CheckBox)boardList.Rows[i].FindControl("board_checkbox")).Checked)
{
deleteBoardNum.Add(boardList.Rows[i].Cells[1].Text);
deleteBoardPw = boardList.Rows[i].Cells[5].Text;
deleteNum++;
}
}
// 삭제하려는 게시글 수가 한 개일경우
if (deleteNum == 1 && isDelete(txtPw.Text, deleteBoardPw))
{
if (boarddao.Delete(((string)deleteBoardNum[0])))
{
ErrorGo("삭제하였습니다", "Board_Main.aspx");
}
}
// 삭제하려는 게시글 수가 여러개인 경우
// 관리자 비밀번호는 1220
else if (deleteNum > 1 && isDelete(txtPw.Text, "1220"))
{
foreach (object boardId in deleteBoardNum)
{
string boardnum = (string)boardId;
Boolean result = boarddao.Delete(boardnum);
}
ErrorGo("삭제하였습니다", "Board_Main.aspx");
}
}
}
// 검색 버튼이 눌렀을 때 수행되는 함수
protected void search(object sender, EventArgs e)
{
String searchoption = ddlSearchOption.SelectedValue;
String search_keyword = txtSearchOptionDetail.Text;
BoardDAO boarddao = new BoardDAO();
switch (searchoption)
{
// 제목
case "0":
{
reader = boarddao.SelectTitle(search_keyword);
ViewState["boards"] = reader;
setBoardList();
break;
}
// 작성자명
case "1":
{
reader = boarddao.SelectWriter(search_keyword);
ViewState["boards"] = reader;
setBoardList();
break;
}
// 내용
case "2":
{
reader = boarddao.SelectContent(search_keyword);
ViewState["boards"] = reader;
setBoardList();
break;
}
// 전체
case "3":
{
reader = boarddao.SelectSum(search_keyword);
ViewState["boards"] = reader;
setBoardList();
break;
}
default:
{
ErrorGo("다시 한 번 확인해주세요", "Board_Main.aspx");
break;
}
}
}
// 제목 정렬 선택하면 수행되는 함수
protected void ddlTitleOrder_SelectedIndexChanged(object sender, EventArgs e)
{
String titleOption = ddlTitleOrder.SelectedValue;
// 제목
if (titleOption == "-1")
{
this.titleOrderSQL = "";
}
// 가나다순
if (titleOption == "0")
{
BoardDAO boarddao = new BoardDAO();
this.titleOrderSQL = "board_title ASC";
String order = setOrder();
reader = boarddao.selectAll(order);
ViewState["boards"] = reader;
setBoardList();
}
}
// board 상세 데이터 가져와서 화면에 보여주는 함수
protected void Page_Load(object sender, EventArgs e)
{
boardid = Request.QueryString["boardid"];
isUpdated = Request.QueryString["update"];
BoardDAO boarddao = new BoardDAO();
if (boardid == "")
{
JustGo("Board_Main.aspx");
return;
}
board = boarddao.Select(boardid);
txtBoardTitle.Text = board.getBoardTitle();
txtBoardWriter.Text = board.getBoardWriter();
txtBoardPw.Text = "****";
txtBoardContent.Text = board.getBoardContent();
}
// 날짜 정렬 선택하면 수행되는 함수
protected void ddlDateOrder_SelectedIndexChanged(object sender, EventArgs e)
{
String dateOption = ddlDateOrder.SelectedValue;
// 날짜
if (dateOption == "-1")
{
this.dateOrderSQL = "";
}
// 최신순
if (dateOption == "0")
{
BoardDAO boarddao = new BoardDAO();
this.dateOrderSQL = "board_date DESC";
String order = setOrder();
reader = boarddao.selectAll(order);
ViewState["boards"] = reader;
setBoardList();
}
//오래된 순
if (dateOption == "1")
{
BoardDAO boarddao = new BoardDAO();
this.dateOrderSQL = "board_date ASC";
String order = setOrder();
reader = boarddao.selectAll(order);
ViewState["boards"] = reader;
setBoardList();
}
}
public BoardService()
{
BoardDao = new BoardDAO();
ColumnService = new ColumnService();
}
