---

pr_country_list.h

Go to the documentation of this file.

/*
 * $Id: pr_country_list.h,v 1.2 2002/12/10 13:38:12 dsamersoff Exp $
 *
 */

#ifndef pr_country_list_h 
#define pr_country_list_h

using namespace std;
#include <list>
#include <dsSQLWrapper.h>

class pr_country_list_rset : public dsSQLRset
{
public:
    
    char country_tag[4];
    char country_name[71];  
    char A2_code[3];
    char A3_code[4];
    long NUM_code;
    
    
    virtual void Dump(ostream& os)
    {
        os <<  "country_tag:   '"  << country_tag   << endl;
        os <<  "country_name:  '"  << country_name  << endl;
        os <<  "A2_code:       '"  << A2_code       << endl;
        os <<  "A3_code:       '"  << A3_code       << endl;
        os <<  "NUM_code:      '"  << NUM_code      << endl;
    }
    
    void Define(dsSQLAccessor *pg, void *cursor)
    {
        dsOCI *oraPg = static_cast<dsOCI *>(pg);
        OCIStmt *oraCursor = (OCIStmt *) cursor;

        oraPg->DefineByPos(cursor,1,SQLT_STR, country_tag,  sizeof(country_tag)  );
        oraPg->DefineByPos(cursor,2,SQLT_STR, country_name, sizeof(country_name) );
        oraPg->DefineByPos(cursor,3,SQLT_STR, A2_code,      sizeof(A2_code)      );
        oraPg->DefineByPos(cursor,4,SQLT_STR, A3_code,      sizeof(A3_code)      );
        oraPg->DefineByPos(cursor,5,SQLT_INT, &NUM_code,    sizeof(NUM_code)     );
    }

    pr_country_list_rset(pr_country_list_rset *rs)
    {
        strcpy(country_tag,   rs->country_tag);
        strcpy(country_name, rs->country_name);
        
        strcpy(A2_code,  rs->A2_code);
        strcpy(A3_code,  rs->A3_code);
        NUM_code  = rs->NUM_code;
    }
    
    pr_country_list_rset()
    { memset(country_tag,  0 , sizeof(country_tag)  );
      memset(country_name, 0 , sizeof(country_name) );
      memset(A2_code,      0 , sizeof(A2_code)      );
      memset(A3_code,      0 , sizeof(A3_code)      );
      NUM_code = 0;
    }

};



class pr_country_list : public dsSPListWrapper<pr_country_list_rset>
{

public:

  void combo_body(ostream& os)
   {
        list<pr_country_list_rset *>::iterator iter;

        os << "<OPTION value='USA' SELECTED>United States</OPTION>" << endl;
        os << "<OPTION value='CAN'>Canada</OPTION>" << endl;

         for (iter = _lst.begin(); iter != _lst.end(); ++iter)
          {
            os << "<OPTION value='" <<  (*iter)->country_tag << "'>" << (*iter)->country_name << "</OPTION>" << endl;
          }
   }


  virtual void execute(dsOCI *pg)
    {
        _fl->log(0xFF, "PR_COUNTRY_LIST");

         const char query[] = 
                      "BEGIN PK_SIGNUP.PR_COUNTRY_LIST(:cursor); END;" );

        OCIStmt *cursor;

        OCIStmt *stmt = pg->PrepareCall(query);
        pg->BindCursor(stmt, "cursor", &cursor);

           pg->Execute( stmt );

        rs.define(pg, cursor);

        while ( OCI_SUCCESS == pg->fetch( cursor ) )
         { 
           _lst.push_back( new pr_country_list_rset(rs) );
         }

         pg->ReleaseCall(stmt);
    }

};


#endif

---