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