tablestrudlg.cpp

用C++写的数据库软件

// TableStruDlg.cpp : implementation file
//

#include "stdafx.h"
#include "fksqxt.h"
#include "TableStruDlg.h"
#include "TableStruDlg2.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTableStruDlg dialog


CTableStruDlg::CTableStruDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTableStruDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTableStruDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CTableStruDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTableStruDlg)
	DDX_Control(pDX, IDC_LIST1, m_ListCtrl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTableStruDlg, CDialog)
	//{{AFX_MSG_MAP(CTableStruDlg)
	ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)
	ON_BN_CLICKED(IDC_CANCEL, OnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTableStruDlg message handlers

BOOL CTableStruDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	// 连接数据库
	m_encaAdo.InitADOConn("","", "", "dbo.FKSQXT"); 

	// 查询记录
	m_rs = m_encaAdo.GetRecordSet("SELECT * FROM TABLEZD"); 

	
	m_ListCtrl.ModifyStyle(0,LVS_REPORT);
	m_ListCtrl.SetExtendedStyle(LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT);


	//title

	m_ListCtrl.InsertColumn(1,"子系统",LVCFMT_LEFT,60);
	m_ListCtrl.InsertColumn(2,"子系统名称",LVCFMT_LEFT,110);
	m_ListCtrl.InsertColumn(3,"二维表代码",LVCFMT_LEFT,100);
	m_ListCtrl.InsertColumn(4,"二维表名称",LVCFMT_LEFT,150);
	m_ListCtrl.InsertColumn(5,"表类别",LVCFMT_LEFT,100);
	m_ListCtrl.InsertColumn(6,"存储位置",LVCFMT_LEFT,90);
	m_ListCtrl.InsertColumn(7,"表已生成",LVCFMT_LEFT,90);

	UpdateData();

	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTableStruDlg::UpdateData()
{
	m_rs = m_encaAdo.GetRecordSet("SELECT * FROM TABLEZD"); 
	int a=-1;
	while(!m_rs->adoEOF)
	{
		a++ ;
		m_rs->MoveNext();
	}

	if(a < 0)
	{
		return;
	}
	m_ListCtrl.DeleteAllItems();
	_variant_t var;
	int iCount = 0;
	m_rs->MoveFirst();
	while( !m_rs->adoEOF )
	{
		if(iCount >= m_ListCtrl.GetItemCount())
		{
			m_ListCtrl.InsertItem(iCount,"");
		}
		m_ListCtrl.InsertItem(iCount,"");
		var = m_rs->GetCollect("ZXT");//子系统
		if(var.vt != VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,0,(LPCSTR)_bstr_t(var));
		}

		var = m_rs->GetCollect("ZXTMC");//子系统名称
		if(var.vt != VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,1,(LPCSTR)_bstr_t(var));
		}

		var = m_rs->GetCollect("BH");//二维表代码
		if(var.vt != VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,2,(LPCSTR)_bstr_t(var));
		}
		
		var = m_rs->GetCollect("MC");//二维表名称
		if(var.vt != VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,3,(LPCSTR)_bstr_t(var));
		}
		var = m_rs->GetCollect("LB");//表类别
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,4,(LPCSTR)_bstr_t(var));
		}
		var = m_rs->GetCollect("ADDR");//存储位置
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,5,(LPCSTR)_bstr_t(var));
		}
		var = m_rs->GetCollect("EXIST");//文件是否存在
		if(var.vt!= VT_NULL)
		{
			m_ListCtrl.SetItemText(iCount,6,(LPCSTR)_bstr_t(var));
		}
		m_rs->MoveNext();
		iCount++;
	}

}

void CTableStruDlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	CString BH = m_ListCtrl.GetItemText(m_ListCtrl.GetSelectionMark(),2);
	CTableStruDlg2 dlg;
	dlg.setTableBH(BH);
	dlg.DoModal();
	
	*pResult = 0;
}

void CTableStruDlg::OnCancel() 
{
	this->EndDialog(0);
}