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