// SBHM.cpp : implementation file
//

#include "stdafx.h"
#include "SMS.h"
#include "SBHM.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSBHM dialog


CSBHM::CSBHM(CWnd* pParent /*=NULL*/)
	: CDialog(CSBHM::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSBHM)
	m_sbcode = _T("");
	//}}AFX_DATA_INIT
}


void CSBHM::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	//{{AFX_DATA_MAP(CSBHM)
	DDX_Text(pDX, IDC_EDIT1, m_sbcode);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSBHM, CDialog)
	//{{AFX_MSG_MAP(CSBHM)
		// NOTE: the ClassWizard will add message map macros here
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSBHM message handlers

BOOL CSBHM::OnInitDialog()
{
  _variant_t Holder, strQuery;
 
    CString mobile[45];
    strQuery = "select * from reportp";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	int icount = theApp.m_pADOSet->GetRecordCount();
     theApp.m_pADOSet->MoveFirst();
	for (int i=0;i<icount;i++)
	{
	
	Holder = theApp.m_pADOSet->GetCollect("code");
	
   mobile[i] = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
   theApp.m_pADOSet->MoveNext();
	}
for (int j=0;j<icount;j++)
{
m_sbcode=m_sbcode+mobile[j].Mid(2,11)+" ";
}
UpdateData(false);
	return TRUE;  
}