示例#1
0
        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);
        }
示例#2
0
        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 }));
        }
示例#3
0
        // 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));
        }
示例#4
0
        // 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);
        }