public ActionResult EseAccount(EseAccountModels model)
{
//권한 체크===================================================
if (!chk.chkPermission("EseAccount", "PER_SELECT"))
{
return(RedirectToAction("EseAccount", "Home", new { msg = chk.alertStr }));
}
//===========================================================
if (!ModelState.IsValid)
{
return(View(model));
}
string message = "성공";
model.viewEseCode = (string)Session["ESE_CODE"];
if (act.SetEseAccountModel(model))
{
return(RedirectToAction("EseAccount", "Ese", new { msg = message }));
}
message = "실패";
ViewBag.result = message;
return(View(model));
}
public ActionResult EseIframeAccount(EseAccountModels viewModel)
{
//권한 체크===================================================
if (!chk.chkPermission("EseInfo", "PER_SELECT"))
{
return(RedirectToAction("EseIframeAccount", "Home", new { msg = chk.alertStr }));
}
//===========================================================
if (!ModelState.IsValid)
{
return(View(viewModel));
}
string message = "성공";
if (act.SetEseAccountModel(viewModel))
{
return(RedirectToAction("EseIframeAccount", "Ese", new { eseCode = viewModel.viewEseCode, msg = message }));
}
message = "실패";
ViewBag.result = message;
return(View(viewModel));
}
public EseAccountModels GetEseAccountModel(string eseCode)
{
string errorStr = "";
EseAccountModels result = new EseAccountModels();
string sqlQueryStr = "SELECT SET_KEY, SET_VALUE, ESE_CODE FROM ese_settings WHERE ESE_CODE = '" + eseCode + "' AND SET_KEY in ('" + string.Join("','", EseActOPT_KEY) + "')";
DataTable dt = getQueryResult(sqlQueryStr, out errorStr);
if (dt == null || dt.Rows.Count == 0)
{
List <string> queryList = new List <string>();
for (int i = 0; i < EseActOPT_KEY.Length; i++)
{
queryList.Add("INSERT INTO ese_settings (SET_KEY, SET_VALUE, EST_CODE) VALUES ('" + EseActOPT_KEY[i] + "', '', '" + eseCode + "') ");
}
exeQuery(queryList, out errorStr);
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["SET_KEY"].ToString() == "setting_SwiftCode")
{
result.setting_SwiftCode = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "setting_BankAddr")
{
result.setting_BankAddr = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "setting_AccountNum")
{
result.setting_AccountNum = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "setting_ReceiverName_en")
{
result.setting_ReceiverName_en = dt.Rows[i]["SET_VALUE"].ToString();
}
if (dt.Rows[i]["SET_KEY"].ToString() == "setting_Memo")
{
result.setting_Memo = dt.Rows[i]["SET_VALUE"].ToString();
}
}
}
return(result);
}
public bool SetEseAccountModel(EseAccountModels model)
{
string errorStr = "";
bool result = false;
List <string> queryList = new List <string>();
queryList.Add("UPDATE ese_settings SET SET_VALUE ='" + model.setting_SwiftCode + "' WHERE SET_KEY ='setting_SwiftCode' AND ESE_CODE= '" + model.viewEseCode + "' ");
queryList.Add("UPDATE ese_settings SET SET_VALUE ='" + model.setting_BankAddr + "' WHERE SET_KEY ='setting_BankAddr'AND ESE_CODE= '" + model.viewEseCode + "' ");
queryList.Add("UPDATE ese_settings SET SET_VALUE ='" + model.setting_AccountNum + "' WHERE SET_KEY ='setting_AccountNum' AND ESE_CODE='" + model.viewEseCode + "' ");
queryList.Add("UPDATE ese_settings SET SET_VALUE ='" + model.setting_ReceiverName_en + "' WHERE SET_KEY ='setting_ReceiverName_en'AND ESE_CODE= '" + model.viewEseCode + "' ");
queryList.Add("UPDATE ese_settings SET SET_VALUE ='" + model.setting_Memo + "' WHERE SET_KEY ='setting_Memo'AND ESE_CODE= '" + model.viewEseCode + "' ");
result = exeQuery(queryList, out errorStr);
return(result);
}
// GET:ESE 관리자 설정 ESE 계좌 관리
public ActionResult EseAccount(string msg)
{
//권한 체크===================================================
if (!chk.chkPermission("EseAccount", "PER_SELECT"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
EseAccountModels model = new EseAccountModels();
model.viewEseCode = (string)Session["ESE_CODE"];
model = act.GetEseAccountModel(model);
return(View(model));
}
//계좌 관리 =========================================================================================================
// GET: Ese ESE STATION Ese 정보 관리 -> 계좌정보
public ActionResult EseIframeAccount(string msg, string eseCode)
{
//권한 체크===================================================
if (!chk.chkPermission("EseInfo", "PER_SELECT"))
{
return(RedirectToAction("EseIframeAccount", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
EseAccountModels model = act.GetEseAccountModel(eseCode);
model.viewEseCode = eseCode;
return(View(model));
}
