public ActionResult CsQnaView(CsQnaModels model) { //if (!ModelState.IsValid) //return View(model); if (model.act_type == "ins") { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_INSERT")) { return(RedirectToAction("CsQnaView", new { msg = chk.alertStr })); } //=========================================================== } if (model.act_type == "updt") { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_UPDATE")) { return(RedirectToAction("CsQnaView", new { msg = chk.alertStr })); } //=========================================================== } if (!String.IsNullOrEmpty(Session["MANAGE_NO"] as string)) { model.Item.WRITER_ID = (int)Session["MANAGE_NO"]; } string PublicPopupMsg = act.setCsQnaModels(model); return(RedirectToAction("CsQnaView", new { seqNo = model.act_key, Msg = PublicPopupMsg })); }
// GET: Cs C/S 문의 사항 관리 public ActionResult CsQna(string searchString, string msg) { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== TempData["PublicMsg"] = null; if (!string.IsNullOrEmpty(msg)) { TempData["PublicMsg"] = msg; } CsDbModels act = new CsDbModels(); CsQnaModels model = new CsQnaModels(); //페이징 설정 초기화 model.Paging.page = 1; model.Paging.pageNum = 10; model.sortKey = "SEQNO"; //리스트 가져오기 model = act.GetCsQnaList(model); ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기 return(View(model)); }
public ActionResult CsQnaView(string seqNo, string Msg) { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== CsQnaModels model = new CsQnaModels(); 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; } if (!String.IsNullOrEmpty(Msg)) { ViewBag.PublicPopupMsg = Msg; } model.Item = act.GetCsQnaView(model); return(View(model)); }
public ActionResult CsQna(CsQnaModels model) { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== model = act.GetCsQnaList(model); //리스트 가져오기 ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기 return(View(model)); }
public ActionResult CsQnaView(CsQnaModels model) { if (model.act_type == "ins") { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_INSERT")) { return(RedirectToAction("CsQna", new { msg = chk.alertStr })); } //=========================================================== } if (model.act_type == "updt") { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_UPDATE")) { return(RedirectToAction("CsQna", new { msg = chk.alertStr })); } //=========================================================== } if (model.act_type == "view") { //권한 체크=================================================== if (!chk.chkPermission("CsQna", "PER_UPDATE")) { return(RedirectToAction("CsQna", new { msg = chk.alertStr })); } //=========================================================== } model.Item.QNA_TYPE = int.Parse(model.schType); // 유효성 검사 if (!ModelState.IsValid) { return(View(model)); } model.Item.ESE_CODE = (string)Session["ESE_CODE"]; model.Item.WRITER_ID = (int)Session["MANAGE_NO"]; string PublicPopupMsg = act.setCsQnaModels(model); return(RedirectToAction("CsQnaView", new { seqNo = model.act_key, Msg = PublicPopupMsg })); }
public string setCsQnaModels(CsQnaModels model) { string result = ""; string errorStr = ""; string exeQueryStr = ""; if (model.act_type != null && model.act_type == "ins") { exeQueryStr = " INSERT INTO bd_qna (ESE_CODE , TITLE, QUESTION, QNA_TYPE, WRITER_ID) VALUES ( "; exeQueryStr += " '" + model.Item.ESE_CODE + "' "; exeQueryStr += " ,'" + model.Item.TITLE + "' "; exeQueryStr += " ,'" + model.Item.QUESTION + "' "; exeQueryStr += " , " + model.schType + " "; exeQueryStr += " , " + model.Item.WRITER_ID + " "; exeQueryStr += " ) "; } else if (model.act_type != null && model.act_type == "updt") { exeQueryStr = " UPDATE bd_qna SET "; exeQueryStr += "ESE_CODE = '" + model.Item.ESE_CODE + "'"; exeQueryStr += ",TITLE = '" + model.Item.TITLE + "'"; exeQueryStr += ",QUESTION = '" + model.Item.QUESTION + "'"; exeQueryStr += " ,QNA_TYPE= " + model.schType + " "; exeQueryStr += " , WRITER_ID=" + model.Item.WRITER_ID + " "; exeQueryStr += " WHERE SEQNO = " + model.Item.SEQNO; } if (exeQuery(exeQueryStr, out errorStr)) { result = "성공."; } else { result = "실패."; } return(result); }
public BdQna GetCsQnaView(CsQnaModels getModel) { string errorStr = ""; BdQna model = new BdQna(); if (getModel.act_type != null && getModel.act_type == "updt") { string ViewQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_CsQna) + " FROM bd_qna WHERE 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.ESE_CODE = listDt.Rows[0]["ESE_CODE"].ToString().Trim(); model.WRITER_ID = int.Parse(listDt.Rows[0]["WRITER_ID"].ToString().Trim()); model.REGDATE = listDt.Rows[0]["REGDATE"].ToString().Trim(); model.QNA_TYPE = int.Parse(listDt.Rows[0]["QNA_TYPE"].ToString().Trim()); model.TITLE = listDt.Rows[0]["TITLE"].ToString().Trim(); model.QUESTION = listDt.Rows[0]["QUESTION"].ToString().Trim(); model.ANSWER = listDt.Rows[0]["ANSWER"].ToString().Trim(); model.REGDATE = listDt.Rows[0]["REGDATE"].ToString().Trim(); model.ANSWER_ID = int.Parse(listDt.Rows[0]["ANSWER_ID"].ToString().Trim()); model.ANSWER_DATE = listDt.Rows[0]["ANSWER_DATE"].ToString().Trim(); foreach (schTypeArray tempS in getModel.schTypeArray) { if (tempS.opt_value == listDt.Rows[0]["QNA_TYPE"].ToString().Trim()) { model.QNA_TYPE = int.Parse(listDt.Rows[0]["QNA_TYPE"].ToString().Trim()); model.QNA_TYPE_txt = tempS.opt_key; } } } } if (getModel.act_type != null && getModel.act_type == "view") { string ViewQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_CsQna) + " FROM bd_qna WHERE 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.ESE_CODE = listDt.Rows[0]["ESE_CODE"].ToString().Trim(); model.WRITER_ID = int.Parse(listDt.Rows[0]["WRITER_ID"].ToString().Trim()); model.REGDATE = listDt.Rows[0]["REGDATE"].ToString().Trim(); model.QNA_TYPE = int.Parse(listDt.Rows[0]["QNA_TYPE"].ToString().Trim()); model.TITLE = listDt.Rows[0]["TITLE"].ToString().Trim(); model.QUESTION = listDt.Rows[0]["QUESTION"].ToString().Trim(); model.ANSWER = listDt.Rows[0]["ANSWER"].ToString().Trim(); model.REGDATE = listDt.Rows[0]["REGDATE"].ToString().Trim(); model.ANSWER_ID = int.Parse(listDt.Rows[0]["ANSWER_ID"].ToString().Trim()); model.ANSWER_DATE = listDt.Rows[0]["ANSWER_DATE"].ToString().Trim(); foreach (schTypeArray tempS in getModel.schTypeArray) { if (tempS.opt_value == listDt.Rows[0]["QNA_TYPE"].ToString().Trim()) { model.QNA_TYPE = int.Parse(listDt.Rows[0]["QNA_TYPE"].ToString().Trim()); model.QNA_TYPE_txt = tempS.opt_key; } } } } return(model); }
public CsQnaModels GetCsQnaList(CsQnaModels model) { string errorStr = ""; //string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_CsQna); string listQuery = " SELECT bq.SEQNO , esmU.EMAIL , " + string.Join(",", selectColumn_CsQna); string cntQuery = " SELECT count(*) as cnt "; //string baseQuery = " FROM bd_qna WHERE 1=1 "; string baseQuery = " FROM bd_qna bq left outer join esm_user esmU on bq.WRITER_ID = esmU.SEQNO WHERE 1=1 "; if (!String.IsNullOrEmpty(model.schType)) //문의유형 { baseQuery += " AND bq.QNA_TYPE = " + model.schType.Trim(); } if (!String.IsNullOrEmpty(model.schSdt)) //등록일자 (시작일) { baseQuery += " AND bq.REGDATE >= '" + model.schSdt.Trim() + "'"; } if (!String.IsNullOrEmpty(model.schEdt)) //등록일자 (종료일) { baseQuery += " AND bq.REGDATE <= '" + model.schEdt.Trim() + " 23:59:59'"; } if (!String.IsNullOrEmpty(model.schTypeTxt) && !String.IsNullOrEmpty(model.schTxt)) //검색조건 검색어 { baseQuery += " AND " + 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.totCnt = totCnt; //전체 갯수 세팅 model.Paging.startCnt = totCnt - (model.Paging.pageNum * (model.Paging.page - 1)); //리스트 첫번째 시작 번호 model.Paging.pageTotNum = (totCnt / model.Paging.pageNum) + 1; //총 페이징 갯수 구하기 if ((totCnt % model.Paging.pageNum) == 0) { model.Paging.pageTotNum -= 1; } DataTable listDt = getQueryResult(listQuery, out errorStr); if (listDt != null && listDt.Rows.Count != 0) { for (int i = 0; i < listDt.Rows.Count; i++) { BdQna temp = new BdQna(); temp.SEQNO = int.Parse(listDt.Rows[i]["SEQNO"].ToString().Trim()); temp.EST_CODE = listDt.Rows[i]["EST_CODE"].ToString().Trim(); temp.ESE_CODE = listDt.Rows[i]["ESE_CODE"].ToString().Trim(); temp.WRITER_ID = int.Parse(listDt.Rows[i]["WRITER_ID"].ToString().Trim()); temp.REGDATE = listDt.Rows[i]["REGDATE"].ToString().Trim(); temp.QNA_TYPE = int.Parse(listDt.Rows[i]["QNA_TYPE"].ToString().Trim()); temp.TITLE = listDt.Rows[i]["TITLE"].ToString().Trim(); temp.QUESTION = listDt.Rows[i]["QUESTION"].ToString().Trim(); temp.ANSWER = listDt.Rows[i]["ANSWER"].ToString().Trim(); temp.ANSWER_ID = int.Parse(listDt.Rows[i]["ANSWER_ID"].ToString().Trim()); temp.ANSWER_DATE = listDt.Rows[i]["ANSWER_DATE"].ToString().Trim(); foreach (schTypeArray tempS in model.schTypeArray) { if (tempS.opt_value == listDt.Rows[i]["QNA_TYPE"].ToString().Trim()) { temp.QNA_TYPE = int.Parse(listDt.Rows[i]["QNA_TYPE"].ToString().Trim()); temp.QNA_TYPE_txt = tempS.opt_key; } } model.Items.Add(temp); } } return(model); }