ryxxcxdlg.cpp

图书馆信息管理系统

// RyxxcxDlg.cpp : implementation file
//

#include "stdafx.h"
#include "GG.h"
#include "RyxxcxDlg.h"
#include "adoconn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRyxxcxDlg dialog


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


void CRyxxcxDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRyxxcxDlg)
	DDX_Control(pDX, IDC_COMBO2, m_CRYCX);
	DDX_CBString(pDX, IDC_COMBO2, m_RYCX);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CRyxxcxDlg message handlers





void CRyxxcxDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(true);
//	MessageBox(m_RYCX);
	
/*	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
    
	m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{	
		CString strSql;
		CString str;
		//strSql.Format("SELECT * FROM 读者信息 WHERE 读者类别=%s",);
	str="SELECT * FROM 读者信息 WHERE 读者类别=";
	strSql=str+"'"+m_RYCX+"'";
		//MessageBox(strSql);
	/*m_strFilter=fieldInfo.m_strName+" = "+"'"+searchDlg.m_strEnglish+"'";
	*/
		//rSql="SELECT DateA,Sum(MoneyA) as MoneySum FROM Budget group by DateA having DateA>=#2004-8-1# and DateA<=#2004-8-2#";
	//strSql.Format("SELECT * FROM 读者信息 WHERE 读者类别='教授'");
	/*	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());
	}  

	m_list_rycx.DeleteAllItems();
	
	
	///////////////////////////////////////////////
	if(!m_AdoConn.m_pRecordset->BOF)
		m_AdoConn.m_pRecordset->MoveFirst();
	else
	{
		AfxMessageBox("表内数据为空");
		return;
	}

	CString s;
	int iIndex=0;
	m_AdoConn.m_pRecordset->MoveFirst();
	while(!m_AdoConn.m_pRecordset->adoEOF)
	{
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("读者姓名"));	
		}
		catch(...)
		{
			s="      ";
		}
		m_list_rycx.InsertItem(iIndex,s,0);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("读者编号"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,1,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("性别"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,2,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("读者类别"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,3,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("工作单位"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,4,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("家庭地址"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,5,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("电话号码"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,6,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("登记日期"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,7,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("已借书数量"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rycx.SetItemText(iIndex,8,s);
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;
		
	}

	//////////////////////////////////////////
	m_AdoConn.ExitConnect();*/

	
	CDialog::OnOK();
}

BOOL CRyxxcxDlg::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_CRYCX.AddString(s);
		
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
	}


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