public ActionResult EstIframeAccount(EstAccountModels viewModel)
{
//권한 체크===================================================
if (!chk.chkPermission("EstInfo", "PER_SELECT"))
{
return(RedirectToAction("EstIframeAccount", "Home", new { msg = chk.alertStr }));
}
//===========================================================
if (!ModelState.IsValid)
{
return(View(viewModel));
}
string message = "성공";
if (act.SetEstAccountModel(viewModel))
{
return(RedirectToAction("EstIframeAccount", "Est", new { estCode = viewModel.viewEstCode, msg = message }));
}
message = "실패";
ViewBag.result = message;
return(View(viewModel));
}
public EstAccountModels GetEstAccountModel(string estCode)
{
string errorStr = "";
EstAccountModels result = new EstAccountModels();
//string sqlQueryStr = "SELECT SET_KEY, SET_VALUE, EST_CODE FROM est_settings WHERE SET_KEY in ('" + string.Join("','", EstActOPT_KEY) + "')";
string sqlQueryStr = "SELECT SET_KEY, SET_VALUE, EST_CODE FROM est_settings WHERE EST_CODE = '" + estCode + "' AND SET_KEY in ('" + string.Join("','", EstActOPT_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 < EstActOPT_KEY.Length; i++)
{
queryList.Add("INSERT INTO est_settings (SET_KEY, SET_VALUE, EST_CODE) VALUES ('" + EstActOPT_KEY[i] + "', '', '" + estCode + "') ");
}
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 SetEstAccountModel(EstAccountModels model)
{
string errorStr = "";
bool result = false;
List <string> queryList = new List <string>();
queryList.Add("UPDATE est_settings SET SET_VALUE ='" + model.setting_SwiftCode + "' WHERE SET_KEY ='setting_SwiftCode' AND EST_CODE= '" + model.viewEstCode + "' ");
queryList.Add("UPDATE est_settings SET SET_VALUE ='" + model.setting_BankAddr + "' WHERE SET_KEY ='setting_BankAddr'AND EST_CODE= '" + model.viewEstCode + "' ");
queryList.Add("UPDATE est_settings SET SET_VALUE ='" + model.setting_AccountNum + "' WHERE SET_KEY ='setting_AccountNum' AND EST_CODE= '" + model.viewEstCode + "' ");
queryList.Add("UPDATE est_settings SET SET_VALUE ='" + model.setting_ReceiverName_en + "' WHERE SET_KEY ='setting_ReceiverName_en'AND EST_CODE= '" + model.viewEstCode + "' ");
queryList.Add("UPDATE est_settings SET SET_VALUE ='" + model.setting_Memo + "' WHERE SET_KEY ='setting_Memo'AND EST_CODE= '" + model.viewEstCode + "' ");
result = exeQuery(queryList, out errorStr);
return(result);
}
//계정 관리 =========================================================================================================
// GET: Est EST STATION Est 정보 관리 -> 계좌정보
public ActionResult EstIframeAccount(string msg, string estCode)
{
//권한 체크===================================================
if (!chk.chkPermission("EstInfo", "PER_SELECT"))
{
return(RedirectToAction("EstIframeAccount", "Home", new { msg = chk.alertStr }));
}
//===========================================================
TempData["PublicMsg"] = null;
if (!string.IsNullOrEmpty(msg))
{
TempData["PublicMsg"] = msg;
}
EstAccountModels model = act.GetEstAccountModel(estCode);
model.viewEstCode = estCode;
return(View(model));
}
