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