public ActionResult EseInfo(EseInfoModels model, string viewEseCode) { //권한 체크=================================================== if (!chk.chkPermission("EseInfo", "PER_UPDATE")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== // 중복체크를 사용을 위해 act_key, schTxt2 model.act_key = 1; model.schTxt2 = "updt"; if (model.Item.ESE_NAME == "") { model.act_key = 0; model.schTxt2 = "ins"; } string chkDupl = act.ChkUpdtEseInfo(model); if (chkDupl != "") { return(RedirectToAction("EseInfo", new { msg = chkDupl })); } model.viewEseCode = (string)Session["ESE_CODE"]; string PublicPopupMsg = act.SetUpdtEseInfo(model); return(RedirectToAction("EseInfo", new { msg = PublicPopupMsg })); }
public ActionResult EseInfo(EseInfoModels model) { //권한 체크=================================================== if (!chk.chkPermission("EseInfo", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== model = act.GetEseInfoList(model); //리스트 가져오기 if (TempData["PublicMsg"] != null) { ViewBag.PublicMsg = TempData["PublicMsg"].ToString(); } ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기 //셀렉트박스 model.nationArray = act.GetNationCodeSelectBox(); model.stationArray = act.GetNationCodeSelectBox(); //model.senderArray = act.GetSenderSelectBox(); return(View(model)); }
public string ChkUpdtEseInfo(EseInfoModels model) { string errorStr = ""; string result = ""; string listQuery = " SELECT count(*) as cnt FROM est_sender WHERE ESE_NAME = '" + model.Item.ESE_NAME + "' "; int reCnt = getQueryCnt(listQuery, out errorStr); if (model.act_type != null && model.schTxt2 == "ins") { if (reCnt > 0 && model.Item.ESE_NAME != null) { result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_SenderName + "]"; } else { listQuery = " SELECT count(*) as cnt FROM est_sender WHERE BIZNO = '" + model.Item.BIZNO + "' "; reCnt = getQueryCnt(listQuery, out errorStr); if (reCnt > 0) { result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_BIZNO + "]"; } } } else if (model.act_type != null && model.schTxt2 == "updt") { if (reCnt > 1 && model.Item.ESE_NAME != null) { result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_SenderName + "]"; } else { listQuery = " SELECT count(*) as cnt FROM est_sender WHERE BIZNO = '" + model.Item.BIZNO + "' "; reCnt = getQueryCnt(listQuery, out errorStr); if (reCnt > 1) { result = @comm_global.Language.Resources.ESE_RETURN_DuplicatedInfo + "[" + @comm_global.Language.Resources.ESE_EseInfo_BIZNO + "]"; } } } return(result); }
public string SetUpdtEseInfo(EseInfoModels model) { string result = ""; string errorStr = ""; string exeQueryStr = ""; if (model.act_type == "USER") { exeQueryStr = " UPDATE est_sender SET "; exeQueryStr += " TASKMAN = '" + model.Item.TASKMAN + "' "; exeQueryStr += ", TELNO_TASK = '" + model.Item.TELNO_TASK + "' "; exeQueryStr += ", EMAIL_TASK = '" + model.Item.EMAIL_TASK + "' "; exeQueryStr += " WHERE ESE_CODE = '" + model.viewEseCode + "' "; } if (model.act_type == "BASE") { exeQueryStr = " UPDATE est_sender SET "; exeQueryStr += " ESE_NAME = '" + model.Item.ESE_NAME + "' "; exeQueryStr += ", ZIPCODE = '" + model.Item.ZIPCODE + "' "; exeQueryStr += ", ADDR = '" + model.Item.ADDR + "' "; exeQueryStr += ", BIZNO = '" + model.Item.BIZNO + "' "; exeQueryStr += ", REPRESENTATIVE = '" + model.Item.REPRESENTATIVE + "' "; exeQueryStr += ", TELNO_REP = '" + model.Item.TELNO_REP + "' "; exeQueryStr += ", EMAIL_REP = '" + model.Item.EMAIL_REP + "' "; exeQueryStr += ", MEMO = '" + model.Item.MEMO + "' "; exeQueryStr += ", HOMEPAGE = '" + model.Item.HOMEPAGE + "' "; exeQueryStr += ", API_KEY = '" + model.Item.API_KEY + "' "; exeQueryStr += " WHERE ESE_CODE = '" + model.viewEseCode + "' "; } if (exeQuery(exeQueryStr, out errorStr)) { result = "성공."; } else { result = "실패."; } return(result); }
// GET: Est EST STATION EST 정보 관리 뷰 팝업 public ActionResult EseInfoView(string msg, string eseCode) { //권한 체크=================================================== if (!chk.chkPermission("EseInfo", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== TempData["PublicMsg"] = null; if (!string.IsNullOrEmpty(msg)) { TempData["PublicMsg"] = msg; } EseInfoModels model = new EseInfoModels(); model.viewEseCode = eseCode; return(View(model)); }
//WEB_ESE 계정관리 => 기본 정보 public EseInfoModels GetEseInfo(EseInfoModels getModel) { string errorStr = ""; EstSender model = new EstSender(); string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EseInfo) + " FROM est_sender WHERE ESE_CODE = '" + getModel.viewEseCode + "' "; DataTable listDt = getQueryResult(listQuery, 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.ESE_NAME = listDt.Rows[0]["ESE_NAME"].ToString().Trim(); model.ZIPCODE = listDt.Rows[0]["ZIPCODE"].ToString().Trim(); model.ADDR = listDt.Rows[0]["ADDR"].ToString().Trim(); model.BIZNO = listDt.Rows[0]["BIZNO"].ToString().Trim(); model.REPRESENTATIVE = listDt.Rows[0]["REPRESENTATIVE"].ToString().Trim(); model.TELNO_REP = listDt.Rows[0]["TELNO_REP"].ToString().Trim(); model.EMAIL_REP = listDt.Rows[0]["EMAIL_REP"].ToString().Trim(); model.TASKMAN = listDt.Rows[0]["TASKMAN"].ToString().Trim(); model.TELNO_TASK = listDt.Rows[0]["TELNO_TASK"].ToString().Trim(); model.EMAIL_TASK = listDt.Rows[0]["EMAIL_TASK"].ToString().Trim(); model.MAR = double.Parse(listDt.Rows[0]["MAR"].ToString().Trim()); model.CREATEDATE = listDt.Rows[0]["CREATEDATE"].ToString().Trim(); model.STATUS = int.Parse(listDt.Rows[0]["STATUS"].ToString().Trim()); model.MEMO = listDt.Rows[0]["MEMO"].ToString().Trim(); model.HOMEPAGE = listDt.Rows[0]["HOMEPAGE"].ToString().Trim(); model.API_KEY = listDt.Rows[0]["API_KEY"].ToString().Trim(); getModel.Item = model; } return(getModel); }
// GET: Ese SENDER ESE 정보 관리 public ActionResult EseInfo(string searchString, string msg, string NATION_CODE) { //권한 체크=================================================== if (!chk.chkPermission("EseInfo", "PER_SELECT")) { return(RedirectToAction("Index", "Home", new { msg = chk.alertStr })); } //=========================================================== TempData["PublicMsg"] = null; if (!string.IsNullOrEmpty(msg)) { TempData["PublicMsg"] = msg; } EseInfoModels model = new EseInfoModels(); //페이징 설정 초기화 model.Paging.page = 1; model.Paging.pageNum = 10; model.sortKey = "SEQNO"; //리스트 가져오기 model = act.GetEseInfoList(model); ViewData["pageing"] = comM.setPaging(model.Paging); //페이징 HTML 만들기 //셀렉트박스 model.nationArray = act.GetNationCodeSelectBox(); model.Item.EST_CODE = model.station; model.Item.ESE_CODE = model.sender; model.stationArray = act.GetNationCodeSelectBox(); model.senderArray = act.GetSenderSelectBox(NATION_CODE); return(View(model)); }
public EseInfoModels GetEseInfoList(EseInfoModels model) { string errorStr = ""; string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EseInfo); string cntQuery = " SELECT count(*) as cnt "; string baseQuery = " FROM ese_user WHERE 1=1 "; if (!String.IsNullOrEmpty(model.schType)) //국가 { baseQuery += " AND NATION_CODE = " + model.schType.Trim(); } if (!String.IsNullOrEmpty(model.station)) //STATION { baseQuery += " AND EST_CODE = " + model.station.Trim(); } if (!String.IsNullOrEmpty(model.station)) //SENDER { baseQuery += " AND ESE_CODE = " + model.station.Trim(); } if (!String.IsNullOrEmpty(model.schSdt)) //생성날짜 (시작일) { baseQuery += " AND CREATETIME >= '" + model.schSdt.Trim() + "'"; } if (!String.IsNullOrEmpty(model.schEdt)) //생성날짜 (종료일) { baseQuery += " AND CREATETIME <= '" + 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.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++) { EseUser temp = new EseUser(); 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.EMAIL = listDt.Rows[i]["EMAIL"].ToString().Trim(); temp.PASSWD = listDt.Rows[i]["PASSWD"].ToString().Trim(); temp.USERNAME = listDt.Rows[i]["USERNAME"].ToString().Trim(); temp.TELNO = listDt.Rows[i]["TELNO"].ToString().Trim(); temp.GROUP_ID = int.Parse(listDt.Rows[i]["GROUP_ID"].ToString().Trim()); temp.CREATETIME = listDt.Rows[i]["CREATETIME"].ToString().Trim(); temp.DEPARTMENT = listDt.Rows[i]["DEPARTMENT"].ToString().Trim(); temp.POSITION = listDt.Rows[i]["POSITION"].ToString().Trim(); temp.MEMO = listDt.Rows[i]["MEMO"].ToString().Trim(); temp.STATUS = int.Parse(listDt.Rows[i]["STATUS"].ToString().Trim()); //Comnation 에서 국가 목록을 다 긁어와서 넣어줘야 한다. model.Items.Add(temp); } } return(model); }