Пример #1
0
    ///----------------------------------------------------------------------
    /// <summary>
    /// 회원정보 조회
    /// </summary>
    ///----------------------------------------------------------------------
    private void userInfoGet(int userNo)
    {
        int intRetVal = 0;

        BOQv7Das_Net.IDas objDas = null;

        ResParam objResParam = null;
        string   strErrMsg   = string.Empty;

        int totalCash = 0;

        try
        {
            objDas = new BOQv7Das_Net.IDas();

            objDas.Open(DAS_HOST);
            objDas.CommandType = CommandType.StoredProcedure;
            objDas.CodePage    = DAS_CODEPAGE;

            objDas.AddParam("@pi_intUserNo", DBType.adInteger, userNo, 0, ParameterDirection.Input);

            //프로시져 호출
            objDas.SetQuery("dbo.UP_USER_INFO_AR_LST"); //Execute Query

            if (!objDas.LastErrorCode.Equals(0))
            {
                intRetVal = objDas.LastErrorCode;
                strErrMsg = objDas.LastErrorMessage;
            }

            objResParam       = new ResParam();
            objResParam.objDT = objDas.objDT;
            DataRow row = objDas.objDT.Rows[0];
            totalCash = Convert.ToInt32(row["TOTALCASH"]);

            amount.Value = totalCash.ToString();


            Response.Write("<script>window.opener.fnOrderSuccess();</script>");
            Response.Write("<script>window.close();</script>");
        }
        catch
        {
        }
        finally
        {
            //Close
            if (objDas != null)
            {
                objDas.Close();
                objDas = null;
            }
        }
    }
Пример #2
0
    ///----------------------------------------------------------------------
    /// <summary>
    /// 회원정보 조회
    /// </summary>
    ///----------------------------------------------------------------------
    protected string userInfoGet(int userNo)
    {
        string userId = "";

        BOQv7Das_Net.IDas objDas = null;

        objResParam = null;
        strErrMsg   = string.Empty;

        try
        {
            objDas = new BOQv7Das_Net.IDas();

            objDas.Open(DAS_HOST);
            objDas.CommandType = CommandType.StoredProcedure;
            objDas.CodePage    = DAS_CODEPAGE;

            objDas.AddParam("@pi_intUserNo", DBType.adInteger, userNo, 0, ParameterDirection.Input);

            //프로시져 호출
            objDas.SetQuery("dbo.UP_USER_INFO_AR_LST"); //Execute Query

            if (!objDas.LastErrorCode.Equals(0))
            {
                intRetVal = objDas.LastErrorCode;
                strErrMsg = objDas.LastErrorMessage;
                return(strErrMsg);
            }

            DataTable dt  = objDas.objDT;
            DataRow   row = dt.Rows[0];

            userId = row["userId"].ToString();
        }
        catch
        {
        }
        finally
        {
            //Close
            if (objDas != null)
            {
                objDas.Close();
                objDas = null;
            }
        }

        return(userId);
    }