tsxxcxdlg.cpp

图书馆信息管理系统

// TsxxcxDlg.cpp : implementation file
//

#include "stdafx.h"
#include "GG.h"
#include "TsxxcxDlg.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTsxxcxDlg dialog


CTsxxcxDlg::CTsxxcxDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTsxxcxDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTsxxcxDlg)
	m_TSLBCX = _T("");
	m_SMCX = _T("");
	m_1 = FALSE;
	m_2 = FALSE;
	//}}AFX_DATA_INIT
}


void CTsxxcxDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTsxxcxDlg)
	DDX_Control(pDX, IDC_COMBO1, m_CTSLBCX);
	DDX_CBString(pDX, IDC_COMBO1, m_TSLBCX);
	DDX_Text(pDX, IDC_EDIT1, m_SMCX);
	DDX_Check(pDX, IDC_CHECK1, m_1);
	DDX_Check(pDX, IDC_CHECK2, m_2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTsxxcxDlg, CDialog)
	//{{AFX_MSG_MAP(CTsxxcxDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTsxxcxDlg message handlers

BOOL CTsxxcxDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
    
	m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		CString strSql;
		strSql.Format("SELECT * FROM %s","图书类别");
		//rSql="SELECT DateA,Sum(MoneyA) as MoneySum FROM Budget group by DateA having DateA>=#2004-8-1# and DateA<=#2004-8-2#";
		m_AdoConn.m_pRecordset->Open(_variant_t(strSql),                // 查询DemoTable表中所有字段
		m_AdoConn.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
			adOpenDynamic,
			adLockOptimistic,
			adCmdText);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}  
	
	///////////////////////////////////////////////
	if(!m_AdoConn.m_pRecordset->BOF)
		m_AdoConn.m_pRecordset->MoveFirst();
	else
	{
		AfxMessageBox("表内数据为空");
		return 0;
	}

	CString s;
	
	m_AdoConn.m_pRecordset->MoveFirst();
	while(!m_AdoConn.m_pRecordset->adoEOF)
	{
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别名称"));	
		}
		catch(...)
		{
			s="      ";
		}
		m_CTSLBCX.AddString(s);
		
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
	}

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

void CTsxxcxDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	
	CDialog::OnOK();
}