public string SetMarReq(MarReqModels model)
{
HttpContext context = HttpContext.Current;
string eseCode = context.Session["ESE_CODE"].ToString();
string estCode = context.Session["EST_CODE"].ToString();
string resultStr = "";
string exeQueryStr = "";
string errorStr = "";
exeQueryStr = " INSERT INTO mar_charge_req ( EST_CODE, ESE_CODE, BANK_NAME , BANK_ACCOUNT, DEPOSIT_NAME, DEPOSIT_AMOUNT , DEPOSIT_CURRENCY, DEPOSIT_DATETIME, MEMO ,STATUS )VALUES( ";
exeQueryStr += "'" + estCode + "'";
exeQueryStr += ", '" + eseCode + "'";
exeQueryStr += ",'" + model.Item.BANK_NAME + "' ";
exeQueryStr += ", '" + model.Item.BANK_ACCOUNT + "' ";
exeQueryStr += ", '" + model.Item.DEPOSIT_NAME + "' ";
exeQueryStr += ", " + model.Item.DEPOSIT_AMOUNT + " ";
exeQueryStr += ", '" + model.Item.DEPOSIT_CURRENCY + "' ";
exeQueryStr += " , DATE_FORMAT(NOW(), '%Y%m%e') ";
exeQueryStr += ", '" + model.Item.MEMO + "' ";
exeQueryStr += ", 10 ";
exeQueryStr += " ) ";
if (exeQuery(exeQueryStr, out errorStr))
{
resultStr = "성공.";
}
else
{
resultStr = "실패.";
}
return(resultStr);
}
public ActionResult MarReq(MarReqModels model)
{
//권한 체크===================================================
if (!chk.chkPermission("MarReq", "PER_UPDATE"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
model.Item.DEPOSIT_CURRENCY = Request.Form["CURRENCY_UNIT"];
string PublicPopupMsg = act.SetMarReq(model);
return(RedirectToAction("MarInOut", new { msg = PublicPopupMsg }));
}
// MAR 충전(이체) ===================================================================
// GET: Mar MAR 충전(이체) mar_charge_req
public ActionResult MarReq()
{
//권한 체크===================================================
if (!chk.chkPermission("MarReq", "PER_UPDATE"))
{
return(RedirectToAction("Index", "Home", new { msg = chk.alertStr }));
}
//===========================================================
MarReqModels model = new MarReqModels();
model = act.GetMarReqBase(model);
model.currencyArray = comModel.GetConfCurrencySelectBox();
return(View(model));
}
// MAR 충전(이체)===========================================================
public MarReqModels GetMarReqBase(MarReqModels model)
{
HttpContext context = HttpContext.Current;
string eseCode = context.Session["ESE_CODE"].ToString();
string estCode = context.Session["EST_CODE"].ToString();
string errorStr = "";
string listQuery = " SELECT BANK_NAME ,BANK_ACCOUNT ,DEPOSIT_NAME ,DEPOSIT_CURRENCY, DEPOSIT_DATETIME FROM mar_charge_req WHERE ESE_CODE = '" + eseCode + "' AND EST_CODE = '" + estCode + "' ORDER BY SEQNO DESC LIMIT 0, 1";
DataTable listDt = getQueryResult(listQuery, out errorStr);
if (listDt != null && listDt.Rows.Count != 0)
{
model.Item.BANK_NAME = listDt.Rows[0]["BANK_NAME"].ToString().Trim();
model.Item.BANK_ACCOUNT = listDt.Rows[0]["BANK_ACCOUNT"].ToString().Trim();
model.Item.DEPOSIT_NAME = listDt.Rows[0]["DEPOSIT_NAME"].ToString().Trim();
model.Item.DEPOSIT_CURRENCY = listDt.Rows[0]["DEPOSIT_CURRENCY"].ToString().Trim();
model.Item.DEPOSIT_DATETIME = listDt.Rows[0]["DEPOSIT_DATETIME"].ToString().Trim();
}
return(model);
}
