// 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(); }