qkdyxcfz.cpp

连接oracle

// QKDYXCFZ.cpp : implementation file
//

#include "stdafx.h"
#include "drawcli.h"
#include "QKDYXCFZ.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQKDYXCFZ dialog

IMPLEMENT_DYNCREATE(CQKDYXCFZ, CDialog)

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


void CQKDYXCFZ::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQKDYXCFZ)
	DDX_Control(pDX, IDC_QK_XCFZMC, m_listxcfzmc);
	DDX_Control(pDX, IDC_QK_LISTQKDY, m_listqkdy);
	DDX_Text(pDX, IDC_QK_FZNUM, m_fznum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQKDYXCFZ, CDialog)
	//{{AFX_MSG_MAP(CQKDYXCFZ)
	ON_WM_SIZE()
	ON_LBN_SELCHANGE(IDC_QK_LISTQKDY, OnSelchangeQkListqkdy)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQKDYXCFZ message handlers

void CQKDYXCFZ::OnSize(UINT nType, int cx, int cy) 
{
	CDialog::OnSize(nType, cx, cy);
	
	// TODO: Add your message handler code here
	if(NULL   !=   m_listxcfzmc.GetSafeHwnd())   
	{   
		int   bx,by;   
		int   nWidht,nHeight;   
		CRect   r;   
		//得到起点横坐标和宽度   
		GetWindowRect(&r);   
		bx   =   0   ;   
		nWidht   =   r.Width() -10  ;///2   ;   
		
		CRect   rect;   
		GetClientRect(&rect);
		
		//得到取点纵坐标和高度   
		m_listxcfzmc.GetWindowRect(&r);   
		ScreenToClient(&r);   
		by   =   r.top   ;   
		nHeight   =   rect.bottom-r.top;//r.Height();   
		
		//CRect   rList(bx,by,bx   +   nWidht,by   +   nHeight);   
		CRect   rList(bx,by,bx   +   nWidht,by   +   nHeight);   
		m_listxcfzmc.MoveWindow(rList);
		
		CRect	rQkdy(0,0, bx + nWidht,161);
		m_listqkdy.MoveWindow(rQkdy);
	}   	
}

//DEL void CQKDYXCFZ::OnSelcancelQkListqkdy() 
//DEL {
//DEL 	// TODO: Add your control notification handler code here
//DEL 	GetListFZMC();
//DEL }

BOOL CQKDYXCFZ::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "select distinct qkdy from daa01";//查询出所有区块
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	
	//返回各列的值
	if (m_pRecordset->ADOEOF)
		return FALSE;
	//CWnd * m_LsCWnd;
	//m_LsCWnd = GetDlgItem(IDC_LW_LISTQKDY);
	//m_listqkdy.SetCurSel( 0 )
	while (!m_pRecordset->ADOEOF)
	{
		m_listqkdy.AddString((char*)_bstr_t(m_pRecordset->GetCollect("qkdy")));
		m_pRecordset->MoveNext() ;
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
	m_listqkdy.SetCurSel(0);
	
	UpdateData(FALSE);
	GetListFZMC();
	return FALSE; // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CQKDYXCFZ::GetListFZMC()
{
	UpdateData(TRUE);
	m_listxcfzmc.ResetContent();
	int i = m_listqkdy.GetCurSel();
	CString str = "";
	m_listqkdy.GetText(i,str );
	str.TrimRight();
	if (!str.IsEmpty() && "" != str)
	{
		_bstr_t vSQL;
		//select DISTINCT B.XCFZMC from daa01 A , daa071 B where trim(Upper(A.JH)) = '8' || trim(Upper(B.JH)) and trim(A.qkdy)='QZZ19'		
		vSQL = "select DISTINCT B.XCFZMC from daa01 A , daa071 B where trim(Upper(A.JH)) = '8' || trim(Upper(B.JH)) and trim(A.qkdy)='"+ str +"' order by B.XCFZMC";//查询出区块内的所有井的小层分组　
		_RecordsetPtr m_pRecordset;
		
		m_AdoConn.OnInitADOConn();
		m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
		
		//返回各列的值
		if (m_pRecordset->ADOEOF)
		{
			m_AdoConn.ExitConnect();
			return ;
		}
		
		int iCnt = 0;
		while (!m_pRecordset->ADOEOF)
		{
			iCnt++;
			m_listxcfzmc.AddString((char*)_bstr_t(m_pRecordset->GetCollect("XCFZMC")));
			m_pRecordset->MoveNext() ;
		}
		//str.Format（＂%d＂,i）
		m_fznum.Format("[%d]组",iCnt);
		//断开与数据库的连接
		m_AdoConn.ExitConnect();
	}
	
	UpdateData(FALSE);
}

void CQKDYXCFZ::OnSelchangeQkListqkdy() 
{
	// TODO: Add your control notification handler code here
	GetListFZMC();
}