public ActionResult CsNoticeView(string seqNo, string Msg) { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== CsNoticeModels model = new CsNoticeModels(); int pSeqNo = 0; if (int.TryParse(seqNo, out pSeqNo)) { model.act_type = "updt"; model.act_key = pSeqNo; } else { model.act_type = "ins"; model.Item.SEQNO = 0; } model.Item = act.GetCsNoticeView(model); model.RadioBoxPop = false; if (model.Item.POPUP_DISPLAY == 1) { model.RadioBoxPop = true; } return(View(model)); }
// GET: Cs C/S 공지사항 관리 public ActionResult CsNotice(string searchString, string msg) { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== TempData["PublicMsg"] = null; if (!string.IsNullOrEmpty(msg)) { TempData["PublicMsg"] = msg; } CsNoticeModels model = new CsNoticeModels(); //페이징 설정 초기화 model.Paging.page = 1; model.Paging.pageNum = 10; model.sortKey = "SEQNO"; //리스트 가져오기 model = act.GetCsNoticeList(model); ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기 return(View(model)); }
public BdNotice GetCsNoticeView(CsNoticeModels getModel) { string errorStr = ""; BdNotice model = new BdNotice(); if (getModel.act_type != null && getModel.act_type == "updt") { string ViewQuery = " SELECT bn.SEQNO , esmU.EMAIL , " + string.Join(",", selectColoum_CsNotice) + " FROM bd_notice bn left outer join esm_user esmU on bn.WRITER_ID = esmU.SEQNO WHERE bn.SEQNO = " + getModel.act_key; DataTable listDt = getQueryResult(ViewQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { model.SEQNO = int.Parse(listDt.Rows[0]["SEQNO"].ToString().Trim()); model.EST_CODE = listDt.Rows[0]["EST_CODE"].ToString().Trim(); model.WRITER_ID = int.Parse(listDt.Rows[0]["WRITER_ID"].ToString().Trim()); model.TITLE_CN = listDt.Rows[0]["TITLE_CN"].ToString().Trim(); model.TITLE_EN = listDt.Rows[0]["TITLE_EN"].ToString().Trim(); model.TITLE_KR = listDt.Rows[0]["TITLE_KR"].ToString().Trim(); model.CONTENTS_CN = listDt.Rows[0]["CONTENTS_CN"].ToString().Trim(); model.CONTENTS_EN = listDt.Rows[0]["CONTENTS_EN"].ToString().Trim(); model.CONTENTS_KR = listDt.Rows[0]["CONTENTS_KR"].ToString().Trim(); model.REGDATE = listDt.Rows[0]["REGDATE"].ToString().Trim(); model.UP_DATE = listDt.Rows[0]["UP_DATE"].ToString().Trim(); model.READ_NUM = int.Parse(listDt.Rows[0]["READ_NUM"].ToString().Trim()); model.POPUP_DISPLAY = int.Parse(listDt.Rows[0]["POPUP_DISPLAY"].ToString().Trim()); model.POPUP_START = listDt.Rows[0]["POPUP_START"].ToString().Trim(); model.POPUP_END = listDt.Rows[0]["POPUP_END"].ToString().Trim(); model.WEB_DISPLAY = int.Parse(listDt.Rows[0]["WEB_DISPLAY"].ToString().Trim()); model.BD_TYPE = int.Parse(listDt.Rows[0]["BD_TYPE"].ToString().Trim()); model.WRITER_NAME = listDt.Rows[0]["EMAIL"].ToString().Trim(); } } return(model); }
public ActionResult CsNoticeView(CsNoticeModels model) { if (model.act_type == "ins") { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_INSERT")) { return(RedirectToAction("CsNoticeView", new { msg = chk.alertStr })); } //=========================================================== } if (model.act_type == "updt") { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_UPDATE")) { return(RedirectToAction("CsNoticeView", new { msg = chk.alertStr })); } //=========================================================== } if (!ModelState.IsValid) { return(View(model)); } if (model.RadioBoxPop == true) { model.Item.POPUP_DISPLAY = 1; } else { model.Item.POPUP_DISPLAY = 0; } model.RadioBoxPop = false; if (model.Item.POPUP_DISPLAY == 1) { model.RadioBoxPop = true; } if (!String.IsNullOrEmpty(Session["MANAGE_NO"] as string)) { model.Item.WRITER_ID = (int)Session["MANAGE_NO"]; } //권한 관련과 같이 갈 것들 이걸 적용시키면 Radio 버튼이 안된다.추후 같이 갈 수 있는 방식을 찾아야 한다. //string PublicPopupMsg = act.setCsNotice(model); //return RedirectToAction("CsNoticeView", new { seqNo = model.act_key, Msg = PublicPopupMsg }); ViewBag.PublicPopupMsg = act.setCsNotice(model); return(View(model)); }
public string setCsNotice(CsNoticeModels model) { string errorStr = ""; string result = ""; string exeQueryStr = ""; model.Item.BD_TYPE = int.Parse(model.schType); if (model.act_type != null && model.act_type == "ins") { exeQueryStr = " INSERT INTO bd_notice(" + string.Join(",", insertColoum_CsNotice) + " )VALUES( "; exeQueryStr += " " + model.Item.WRITER_ID + ""; exeQueryStr += ", '" + model.Item.TITLE_CN + "' "; exeQueryStr += ", '" + model.Item.TITLE_EN + "' "; exeQueryStr += ", '" + model.Item.TITLE_KR + "' "; exeQueryStr += ", '" + model.Item.CONTENTS_CN + "' "; exeQueryStr += ", '" + model.Item.CONTENTS_EN + "' "; exeQueryStr += ", '" + model.Item.CONTENTS_KR + "' "; exeQueryStr += ", " + model.Item.POPUP_DISPLAY + ""; exeQueryStr += ", '" + model.Item.POPUP_START + "' "; exeQueryStr += ", '" + model.Item.POPUP_END + "' "; exeQueryStr += ", " + model.Item.WEB_DISPLAY + ""; exeQueryStr += ", " + model.Item.BD_TYPE + ""; exeQueryStr += " ) "; } else if (model.act_type != null && model.act_type == "updt") { exeQueryStr = " UPDATE bd_notice SET "; exeQueryStr += "TITLE_CN = '" + model.Item.TITLE_CN + "'"; exeQueryStr += ",TITLE_EN = '" + model.Item.TITLE_EN + "'"; exeQueryStr += ",TITLE_KR = '" + model.Item.TITLE_KR + "'"; exeQueryStr += ",CONTENTS_CN = '" + model.Item.CONTENTS_CN + "'"; exeQueryStr += ",CONTENTS_EN = '" + model.Item.CONTENTS_EN + "'"; exeQueryStr += ",CONTENTS_KR = '" + model.Item.CONTENTS_KR + "'"; exeQueryStr += ",UP_DATE = CURRENT_TIMESTAMP"; exeQueryStr += ",POPUP_DISPLAY =" + model.Item.POPUP_DISPLAY + ""; exeQueryStr += ",POPUP_START = '" + model.Item.POPUP_START + "'"; exeQueryStr += ",POPUP_END = '" + model.Item.POPUP_END + "'"; exeQueryStr += ",WEB_DISPLAY =" + model.Item.WEB_DISPLAY + ""; exeQueryStr += ",BD_TYPE =" + model.Item.BD_TYPE + ""; exeQueryStr += " WHERE SEQNO = " + model.Item.SEQNO; } else { result = "잘못된 접근입니다."; return(result); } if (exeQuery(exeQueryStr, out errorStr)) { result = "성공."; } else { result = "실패."; } return(result); }
public ActionResult CsNoticeView(CsNoticeModels model) { if (model.act_type == "ins") { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_INSERT")) { return(RedirectToAction("CsNoticeView", new { msg = chk.alertStr })); } //=========================================================== } if (model.act_type == "updt") { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_UPDATE")) { return(RedirectToAction("CsNoticeView", new { msg = chk.alertStr })); } //=========================================================== } // 유효성 검사 if (!ModelState.IsValid) { return(View(model)); } // 라디오 버튼 if (model.RadioBoxPop == true) { model.Item.POPUP_DISPLAY = 1; } else { model.Item.POPUP_DISPLAY = 0; } model.RadioBoxPop = false; if (model.Item.POPUP_DISPLAY == 1) { model.RadioBoxPop = true; } ViewBag.PublicPopupMsg = act.setCsNotice(model); return(View(model)); }
public ActionResult CsNotice(CsNoticeModels model) { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== //삭제일 경우 if (model.act_type == "del") { //권한 체크=================================================== if (!chk.chkPermission("CsNotice", "PER_DELETE")) { return(RedirectToAction("CsNotice", new { msg = chk.alertStr })); } //=========================================================== TempData["PublicMsg"] = act.delCsNotice(model.act_key); //삭제 model.act_type = "list"; model.act_key = 0; return(RedirectToAction("csnotice", model)); } model = act.GetCsNoticeList(model); //리스트 가져오기 if (TempData["PublicMsg"] != null) { ViewBag.PublicMsg = TempData["PublicMsg"].ToString(); } ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기 return(View(model)); }
public CsNoticeModels GetCsNoticeList(CsNoticeModels model) { string errorStr = ""; string listQuery = " SELECT bn.SEQNO , esmU.EMAIL , " + string.Join(",", selectColoum_CsNotice); string cntQuery = " SELECT count(*) as cnt "; string baseQuery = " FROM bd_notice bn left outer join esm_user esmU on bn.WRITER_ID = esmU.SEQNO WHERE 1=1 "; if (!String.IsNullOrEmpty(model.schType)) //공지유형 { baseQuery += " AND bn.BD_TYPE = " + model.schType.Trim(); } if (!String.IsNullOrEmpty(model.schSdt)) //등록일자 (시작일) { baseQuery += " AND bn.REGDATE >= '" + model.schSdt.Trim() + "'"; } if (!String.IsNullOrEmpty(model.schEdt)) //등록일자 (종료일) { baseQuery += " AND bn.REGDATE <= '" + model.schEdt.Trim() + " 23:59:59'"; } if (!String.IsNullOrEmpty(model.schTypeTxt) && !String.IsNullOrEmpty(model.schTxt)) //검색조건 검색어 { baseQuery += " AND bn." + model.schTypeTxt.Trim() + " like '%" + model.schTxt.Trim() + "%' "; } string endQuery = " ORDER BY " + model.sortKey.ToString().Trim() + " DESC limit " + ((model.Paging.page - 1) * model.Paging.pageNum) + " , " + model.Paging.pageNum; //정렬 cntQuery += baseQuery; //토탈 카운트 쿼리 listQuery += baseQuery + endQuery; //리스트 쿼리 int totCnt = getQueryCnt(cntQuery, out errorStr); //전체 리스트 갯수 구하기 model.Paging.pageTotNum = (totCnt / model.Paging.pageNum) + 1; //총 페이징 갯수 구하기 DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { for (int i = 0; i < listDt.Rows.Count; i++) { BdNotice temp = new BdNotice(); temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim()); temp.EST_CODE = listDt.Rows[i]["EST_CODE"].ToString().Trim(); temp.WRITER_ID = int.Parse(listDt.Rows[i]["WRITER_ID"].ToString().Trim()); temp.TITLE_CN = listDt.Rows[i]["TITLE_CN"].ToString().Trim(); temp.TITLE_EN = listDt.Rows[i]["TITLE_EN"].ToString().Trim(); temp.TITLE_KR = listDt.Rows[i]["TITLE_KR"].ToString().Trim(); temp.CONTENTS_CN = listDt.Rows[i]["CONTENTS_CN"].ToString().Trim(); temp.CONTENTS_EN = listDt.Rows[i]["CONTENTS_EN"].ToString().Trim(); temp.CONTENTS_KR = listDt.Rows[i]["CONTENTS_KR"].ToString().Trim(); temp.REGDATE = listDt.Rows[i]["REGDATE"].ToString().Trim(); temp.UP_DATE = listDt.Rows[i]["UP_DATE"].ToString().Trim(); temp.READ_NUM = int.Parse(listDt.Rows[i]["READ_NUM"].ToString().Trim()); temp.POPUP_DISPLAY = int.Parse(listDt.Rows[i]["POPUP_DISPLAY"].ToString().Trim()); temp.POPUP_START = listDt.Rows[i]["POPUP_START"].ToString().Trim(); temp.POPUP_END = listDt.Rows[i]["POPUP_END"].ToString().Trim(); temp.WEB_DISPLAY = int.Parse(listDt.Rows[i]["WEB_DISPLAY"].ToString().Trim()); //(msh)추가 temp.BD_TYPE = int.Parse(listDt.Rows[i]["BD_TYPE"].ToString().Trim()); foreach (schTypeArray tempS in model.schTypeArray) { if (tempS.opt_value == listDt.Rows[i]["BD_TYPE"].ToString().Trim()) { temp.BD_TYPE = int.Parse(listDt.Rows[i]["BD_TYPE"].ToString().Trim()); temp.BD_TYPE_txt = tempS.opt_key; } } temp.WRITER_NAME = listDt.Rows[i]["EMAIL"].ToString().Trim(); model.Items.Add(temp); } } return(model); }