//ESE SENDER ESE 정보 관리 -> ESE 기본 정보 public EseUser GetEstIframeInfo(EseIframeInfoModels getModel, string eseCode) { string errorStr = ""; EseUser model = new EseUser(); string listQuery = " SELECT SEQNO , " + string.Join(",", selectColumn_EseInfo) + " FROM ese_user WHERE ESE_CODE = '" + eseCode + "' "; 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.EMAIL = listDt.Rows[0]["EMAIL"].ToString().Trim(); model.PASSWD = listDt.Rows[0]["PASSWD"].ToString().Trim(); model.USERNAME = listDt.Rows[0]["USERNAME"].ToString().Trim(); model.TELNO = listDt.Rows[0]["TELNO"].ToString().Trim(); model.GROUP_ID = int.Parse(listDt.Rows[0]["GROUP_ID"].ToString().Trim()); model.CREATETIME = listDt.Rows[0]["CREATETIME"].ToString().Trim(); model.DEPARTMENT = listDt.Rows[0]["DEPARTMENT"].ToString().Trim(); model.POSITION = listDt.Rows[0]["POSITION"].ToString().Trim(); model.MEMO = listDt.Rows[0]["MEMO"].ToString().Trim(); model.STATUS = int.Parse(listDt.Rows[0]["STATUS"].ToString().Trim()); } return(model); }
//ESE 기본정보 ==================================================================================================== // GET: Ese ESE SENDER Ese 정보 관리 -> ESE 기본정보 public ActionResult EseIframeInfo(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; } EseIframeInfoModels model = new EseIframeInfoModels(); model.viewEseCode = eseCode; model.Item = act.GetEstIframeInfo(model, eseCode); //라디오버튼 쓰기 if (model.RadioBoxPop == "0") { model.Item.STATUS = 0; } else if (model.RadioBoxPop == "1") { model.Item.STATUS = 1; } else { model.Item.STATUS = 2; } model.RadioBoxPop = "2"; if (model.Item.STATUS == 1) { model.RadioBoxPop = "1"; } else if (model.Item.STATUS == 0) { model.RadioBoxPop = "0"; } return(View(model)); }