fronttoolview.cpp

方便的数据库连接调试程序

// frontToolView.cpp : implementation of the CFrontToolView class
//

#include "stdafx.h"
#include "frontTool.h"

#include "frontToolDoc.h"
#include "frontToolView.h"

#include "mainFrm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFrontToolView

IMPLEMENT_DYNCREATE(CFrontToolView, CView)

BEGIN_MESSAGE_MAP(CFrontToolView, CView)
	//{{AFX_MSG_MAP(CFrontToolView)
	ON_WM_CREATE()
	ON_WM_SIZE()
	ON_COMMAND(IDM_FRESH_TAB, OnFreshTab)
	ON_COMMAND(IDM_FRESH_COL, OnFreshCol)
	ON_COMMAND(IDM_CONN_DRV, OnConnDrv)
	ON_COMMAND(IDM_EXPORT_TAB, OnExportTab)
	ON_COMMAND(IDM_IMPORT_TAB, OnImportTab)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFrontToolView construction/destruction

CFrontToolView::CFrontToolView():m_ed(&m_db),m_id(&m_db)
{
	// TODO: add construction code here
	m_pCurShowWnd=NULL;
	m_iCurShowWnd=-1;
}

CFrontToolView::~CFrontToolView()
{
}

BOOL CFrontToolView::CloseCurForm(void)
{
	if(m_pCurShowWnd)
	{
		m_pCurShowWnd->ShowWindow(SW_HIDE);
		m_iCurShowWnd=-1;
		m_pCurShowWnd=NULL;
		return TRUE;
	}
	return FALSE;
}

BOOL CFrontToolView::SetCurForm(int iID)
{
	if(iID==m_iCurShowWnd)
		return FALSE;
	CloseCurForm();
	m_iCurShowWnd=iID;
	switch(iID)
	{
	case(0):
		m_pCurShowWnd=&m_bl;
		break;
	case(1):
		m_pCurShowWnd=&m_ed;
		break;
	case(2):
		m_pCurShowWnd=&m_id;
		break;
	}
	if(m_pCurShowWnd)
	{
		CRect rcC;
		GetClientRect(rcC);
		m_pCurShowWnd->ShowWindow(SW_SHOW);
		m_pCurShowWnd->MoveWindow(rcC);
	}
	return TRUE;
}

BOOL CFrontToolView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CView::PreCreateWindow(cs);
}

/////////////////////////////////////////////////////////////////////////////
// CFrontToolView drawing

void CFrontToolView::OnDraw(CDC* pDC)
{
	CFrontToolDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);

	// TODO: add draw code for native data here
}

/////////////////////////////////////////////////////////////////////////////
// CFrontToolView diagnostics

#ifdef _DEBUG
void CFrontToolView::AssertValid() const
{
	CView::AssertValid();
}

void CFrontToolView::Dump(CDumpContext& dc) const
{
	CView::Dump(dc);
}

CFrontToolDoc* CFrontToolView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CFrontToolDoc)));
	return (CFrontToolDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CFrontToolView message handlers

int CFrontToolView::OnCreate(LPCREATESTRUCT lpCreateStruct) 
{
	if (CView::OnCreate(lpCreateStruct) == -1)
		return -1;
	
	CRect rcC(0,50,300,400);
	m_bl.Create(WS_CHILD|WS_VISIBLE,rcC,this,0X5010);
	m_pCurShowWnd=&m_bl;
	m_iCurShowWnd=0;

	m_ed.CreateWnd(this,rcC);
	m_ed.ShowWindow(SW_HIDE);
	m_id.CreateWnd(this,rcC);
	m_id.ShowWindow(SW_HIDE);
	/*char szC[100]="c1\0c2\0c3\0\0";
	int iW[3]={100,130,50};
	m_bl.ResetColInfo(szC,iW);*/


	return 0;
}

void CFrontToolView::OnSize(UINT nType, int cx, int cy) 
{
	CView::OnSize(nType, cx, cy);
	
	CRect rc(0,0,cx,cy);
	if(m_pCurShowWnd)
		m_pCurShowWnd->MoveWindow(rc);
}

void CFrontToolView::OnFreshTab() 
{
	SetCurForm(0);
	CMainFrame* pF=(CMainFrame*)(((CFrontToolApp*)AfxGetApp())->m_pMainWnd);
	pF->m_wndToolBar.m_cb.ListTable(&m_db);
}

void CFrontToolView::OnFreshCol() 
{
	SetCurForm(0);
	CMainFrame* pF=(CMainFrame*)(((CFrontToolApp*)AfxGetApp())->m_pMainWnd);
	int iSel=pF->m_wndToolBar.m_cb.GetCurSel();
	if(iSel<0)
		return ;
	TRACE("select No%d\n",iSel);
	if(m_db.DescTable(iSel))
	{
		m_bl.ResetColInfo(&m_db);
	}
	/*CString szTxt;
	pF->m_wndToolBar.m_cb.GetWindowText(szTxt);
	if(szTxt.GetLength())
	{
		return ;
	}
	if(m_db.DescTable(szTxt))
	{
		m_bl.ResetColInfo(&m_db);
	}*/

/*	CStringArray arrRes;
	m_db.GenerateDescString(arrRes);
	m_bl.ResetColInfo(arrRes);*/
	//m_bl.ResetColInfo(m_db.m_arrColFull);
}

void CFrontToolView::OnConnDrv() 
{
	if(!m_db.Open())
		AfxMessageBox("连接失败");
	else
		AfxMessageBox("连接成功");
}

void CFrontToolView::OnExportTab() 
{
//	char szSQL[]="select to_char(xh),nvl(zdnr,' '), nvl(rgnr,' '),nvl(fjnr,' '),nvl(qtnr,' '),nvl(hwy,' '), nvl(to_char(lrrq,'YYYYMMDDHH24MI'),' ') from tkf_bbhc order by xh";
//	CExpTab et(&m_db);
//	et.ExportTab(szSQL,"c:\\temp\\bbhc");
	SetCurForm(1);
}

void CFrontToolView::OnImportTab() 
{
	SetCurForm(2);
//	char szSQL[]="insert into hd1(name,id,birth) values(?,?,to_date(?,'YYYYMMDDHH24MI'))";
//	CImpTab it(&m_db);
//	it.ImportTab(szSQL,"c:\\temp\\hd1",3,3);
}