protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { HtmlForm form1 = (HtmlForm)Master.FindControl("form1"); form1.Method = "post"; form1.Enctype = "multipart/form-data"; //form1.Action = "Test.aspx"; Common_NTx_Dac ddlSet = new Common_NTx_Dac(); // 게시판 카테고리 필드 DataTable BoardCategorydt = null; BoardCategorydt = ddlSet.TOTALBBS_BOARD_CATEGORY_INFO_SEL(0); int ddlBoardCategorySeletedValue = IntegerUtil.intValid(this.ddlBoardCategory.SelectedValue, 0); // 게시판 카테고리 필드 - DropDownList if (BoardCategorydt.Rows.Count == 0) { this.ddlWriteCategory.Items.Clear(); this.ddlBoardCategory.Items.Add(new ListItem("등록된 카테고리가 없습니다.", "")); this.ddlBoardCategory.Enabled = false; } else { this.ddlBoardCategory.Items.Clear(); //this.ddlBoardCategory.Items.Add(new ListItem("선택하세요", "0")); // 기본값 //DropDownListUtil.SetDropDownList(BoardCategorydt, this.ddlBoardCategory, "strCateName", "intIdx"); DropDownListUtil.SetDropDownListValue(BoardCategorydt, this.ddlBoardCategory, this.ddlBoardCategory.SelectedValue, DropDownListUtil.DropDownFlag.Select); } } }
protected void ddlBoardCaregory_itemSelected(object sender, EventArgs e) { try { int ddlBoardCategorySeletedValue = IntegerUtil.intValid(this.ddlBoardCategory.SelectedValue, 0); this.ddlWriteCategory.Enabled = true; Common_NTx_Dac ddlSet = new Common_NTx_Dac(); DataTable WriteCategorydt = null; WriteCategorydt = ddlSet.TOTALBBS_WRITE_CATEGORY_INFO_SEL(ddlBoardCategorySeletedValue); // 게시글 카테고리 필드 - DropDownList if (WriteCategorydt.Rows.Count == 0) { this.ddlWriteCategory.Items.Clear(); this.ddlWriteCategory.Items.Add(new ListItem("등록된 카테고리가 없습니다.", "")); this.ddlWriteCategory.Enabled = false; } else { this.ddlWriteCategory.Items.Clear(); this.ddlWriteCategory.Items.Add(new ListItem("선택하세요", "0")); // 기본값 DropDownListUtil.SetDropDownList(WriteCategorydt, this.ddlWriteCategory, "strCateName", "intIdx"); } } catch (Exception ex) { #region [Error Logger] 로그인을 한경우 //ErrorLogger_Tx_Dac.GetErrorLogger_Tx_Dac().TB_TOTABBS_ERROR_LOGGER_INFO_INS_SP(ex); #endregion } }
private void GetPageDefaultSetting() { this.ltTitle.Text = "게시글 관리"; this.ltTotalPosts.Text = "전체 게시글 수"; #region [버튼 설정] this.lbtnCreate.Text = "<span>등록</span>"; this.lbtnSearch.Text = "<span>검색</span>"; #endregion #region [DropDownList 설정] this.FIELD.Items.Clear(); this.FIELD.Items.Add(new ListItem("작성자", "WRITER")); this.FIELD.Items.Add(new ListItem("제목", "SUBJECT")); Common_NTx_Dac ddlSet = new Common_NTx_Dac(); // 게시판 카테고리 필드 BoardCategorydt = ddlSet.TOTALBBS_BOARD_CATEGORY_INFO_SEL(-1); int ddlBoardCategorySeletedValue = IntegerUtil.intValid(this.ddlBoardCategory.SelectedValue, -1); // 게시판 카테고리 필드 - DropDownList if (BoardCategorydt.Rows.Count == 0) { this.ddlBoardCategory.Items.Add(new ListItem("등록된 카테고리가 없습니다.", "")); this.ddlBoardCategory.Enabled = false; } else { this.ddlBoardCategory.Items.Clear(); DropDownListUtil.SetDropDownListValue(BoardCategorydt, this.ddlBoardCategory, this.ddlBoardCategory.SelectedValue, DropDownListUtil.DropDownFlag.Select); } #endregion }
private void GetPageSetting(int Idx, DataSet ds, string CMD) { if (CMD.Equals("V")) { this.lbtnCancel.Text = "<span>목록</span>"; this.lbtnCancel.CssClass = "buttons fl_l"; DataTable dt1 = ds.Tables[0]; DataTable dt2 = ds.Tables[1]; Common_NTx_Dac ddlSet = new Common_NTx_Dac(); DataTable AllCategorydt = ddlSet.TOTALBBS_ALL_CATEGORY_INFO_SEL(-1); this.ltBoardCategory.Text = (AllCategorydt.AsEnumerable().Where(p => (p["intIdx"].ToString() == dt1.Rows[0]["intBoardCatrgory"].ToString()) && (p["chrCateGubun"].ToString() == "B")).Select(p => p["strCateName"].ToString())).FirstOrDefault(); this.ltWriteCategory.Text = (AllCategorydt.AsEnumerable().Where(p => (p["intIdx"].ToString() == dt1.Rows[0]["intWriteCategory"].ToString()) && (p["chrCateGubun"].ToString() == "W")).Select(p => p["strCateName"].ToString())).FirstOrDefault(); this.ltUserId.Text = dt1.Rows[0]["strUserId"].ToString(); this.ltWriter.Text = dt1.Rows[0]["strWriter"].ToString(); this.ltSubject.Text = dt1.Rows[0]["strSubject"].ToString(); this.ltContent.Text = dt1.Rows[0]["strContent"].ToString(); this.ltRegiDateValue.Text = dt1.Rows[0]["dateRegDate"].ToString(); this.ltViewCntValue.Text = dt1.Rows[0]["intViewCount"].ToString(); //첨부파일 세팅 if (dt2.Rows.Count == 0) { this.rptBoard_Attached.DataSource = dt2; this.rptBoard_Attached.DataBind(); } else { AttachedFileCnt = 1; this.rptBoard_Attached.DataSource = dt2; this.rptBoard_Attached.DataBind(); } } this.hdfIdx.Value = Idx.ToString(); this.hdfCMD.Value = CMD; }
private void GetPageInfoSetting(string ParamBoardCategory, string ParamField, string ParamKey, int Idx, int PageNo, string CMD) { //페이지 HTML 언어 세팅 this.ltBoardCategory.Text = "게시판 카테고리"; this.ltWriteCategory.Text = "게시글 카테고리"; this.ltUserId.Text = "작성자 아이디"; this.ltWriter.Text = "작성자 이름"; this.ltSubject.Text = "제목"; this.ltContent.Text = "내용"; this.ltRegiDate.Text = "등록일"; this.ltViewCnt.Text = "조회수"; #region [DropDownList 설정] Common_NTx_Dac ddlSet = new Common_NTx_Dac(); // 게시판 카테고리 필드 DataTable BoardCategorydt = null; BoardCategorydt = ddlSet.TOTALBBS_BOARD_CATEGORY_INFO_SEL(-1); int ddlBoardCategorySeletedValue = IntegerUtil.intValid(this.ddlBoardCategory.SelectedValue, -1); // 게시판 카테고리 필드 - DropDownList if (BoardCategorydt.Rows.Count == 0) { this.ddlWriteCategory.Items.Clear(); this.ddlBoardCategory.Items.Add(new ListItem("등록된 카테고리가 없습니다.", "")); this.ddlBoardCategory.Enabled = false; } else { this.ddlBoardCategory.Items.Clear(); DropDownListUtil.SetDropDownListValue(BoardCategorydt, this.ddlBoardCategory, this.ddlBoardCategory.SelectedValue, DropDownListUtil.DropDownFlag.Select); } // 게시글 카테고리 필드 DataTable WriteCategorydt = null; WriteCategorydt = ddlSet.TOTALBBS_WRITE_CATEGORY_INFO_SEL(ddlBoardCategorySeletedValue); // 게시글 카테고리 필드 - DropDownList if (WriteCategorydt.Rows.Count == 0) { this.ddlWriteCategory.Items.Clear(); this.ddlWriteCategory.Items.Add(new ListItem("등록된 카테고리가 없습니다.", "")); this.ddlWriteCategory.Enabled = false; } else { this.ddlWriteCategory.Items.Clear(); DropDownListUtil.SetDropDownListValue(WriteCategorydt, this.ddlWriteCategory, this.ddlWriteCategory.SelectedValue, DropDownListUtil.DropDownFlag.Select); } #endregion DataSet ds = null; if (CMD.Equals("M")) { Board_NTx_Dac oWS = new Board_NTx_Dac(); ds = oWS.TOTALBBS_BOARD_VIEW_SEL(Idx); } else { this.trVisible_2.Attributes.Add("style", "display:none"); this.trVisible_2.Visible = false; } this.GetPageSetting(Idx, ds, CMD); }
private void GetPageSetting(int Idx, DataSet ds, string CMD) { if (CMD.Equals("C")) { this.lbtnValidationSave.Text = "<span class='btn btn-default'>확인</span>"; this.lbtnValidationSave.CssClass = "buttons"; this.lbtnCancel.Text = "<span class='btn btn-default'>취소</span>"; this.lbtnCancel.CssClass = "buttons mg_l5"; this.lbtnValidationDelete.Visible = false; if (!admin.MemberId.Equals(null) || !admin.MemberId.Equals("")) { this.txtUserId.Text = admin.MemberId.ToString(); } if (!admin.MemberNm.Equals(null) || !admin.MemberNm.Equals("")) { this.txtWriter.Text = admin.MemberNm.ToString(); } this.ifrmReply.Visible = false; } else if (CMD.Equals("M")) { this.lbtnValidationModify.Text = "<span class='btn btn-primary'>수정</span>"; this.lbtnValidationModify.CssClass = "buttons fl_r"; this.lbtnCancel.Text = "<span class='btn btn-default'>목록</span>"; this.lbtnCancel.CssClass = "buttons fl_l"; this.lbtnValidationDelete.Text = "<span class='btn btn-success'>삭제</span>"; this.lbtnValidationDelete.CssClass = "buttons mg_l5 fl_r"; this.lbtnValidationDelete.OnClientClick = "return fnDelConfirm();"; DataTable dt1 = ds.Tables[0]; DataTable dt2 = ds.Tables[1]; this.ddlBoardCategory.SelectedValue = dt1.Rows[0]["intBoardCategory"].ToString(); Common_NTx_Dac ddlSet = new Common_NTx_Dac(); // 게시판 카테고리 필드 int ddlBoardCategorySeletedValue = IntegerUtil.intValid(this.ddlBoardCategory.SelectedValue, -1); // 게시글 카테고리 필드 DataTable WriteCategorydt = null; WriteCategorydt = ddlSet.TOTALBBS_WRITE_CATEGORY_INFO_SEL(ddlBoardCategorySeletedValue); // 게시글 카테고리 필드 - DropDownList if (WriteCategorydt.Rows.Count == 0) { this.ddlWriteCategory.Items.Clear(); this.ddlWriteCategory.Items.Add(new ListItem("등록된 카테고리가 없습니다.", "")); this.ddlWriteCategory.Enabled = false; } else { this.ddlWriteCategory.Enabled = true; this.ddlWriteCategory.Items.Clear(); DropDownListUtil.SetDropDownListValue(WriteCategorydt, this.ddlWriteCategory, dt1.Rows[0]["intWriteCategory"].ToString(), DropDownListUtil.DropDownFlag.Select); } this.ddlWriteCategory.SelectedValue = dt1.Rows[0]["intWriteCategory"].ToString(); this.txtUserId.Text = dt1.Rows[0]["strUserId"].ToString(); this.txtWriter.Text = dt1.Rows[0]["strWriter"].ToString(); this.txtSubject.Text = dt1.Rows[0]["strSubject"].ToString(); this.txtContent.Text = TextControl.Delete_Tag(dt1.Rows[0]["strContent"].ToString()); this.ltRegiDateValue.Text = dt1.Rows[0]["dateRegDate"].ToString(); this.ltViewCntValue.Text = dt1.Rows[0]["intViewCount"].ToString(); //this.ifrmReply.Src = "/BackOffice/Board/BoardReplyList.aspx?intIdx=" + dt1.Rows[0]["intIdx"]; ifrmReply.Attributes["src"] = "/BackOffice/Board/BoardReplyList?intIdx=" + dt1.Rows[0]["intIdx"]; this.ifrmReply.Visible = true; //첨부파일 세팅 if (dt2.Rows.Count == 0) { this.rptBoard_Attached.DataSource = dt2; this.rptBoard_Attached.DataBind(); } else { AttachedFileCnt = 1; this.rptBoard_Attached.DataSource = dt2; this.rptBoard_Attached.DataBind(); } } this.hdfIdx.Value = Idx.ToString(); this.hdfCMD.Value = CMD; }
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", "조회된 데이터가 없습니다."); } } }