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", "조회된 데이터가 없습니다.");
}
}
}