jclist.cpp

图书管理系统

// Jclist.cpp : implementation file
//

#include "stdafx.h"
#include "jeah_data.h"
#include "Jclist.h"

#include "sqltypes.h"
#include "sql.h"
#include "sqlext.h"
extern HENV henv;
extern HDBC hdbc;

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

/////////////////////////////////////////////////////////////////////////////
// Jclist dialog


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


void Jclist::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Jclist)
	DDX_Control(pDX, IDCANCEL, m_jc);
	DDX_Control(pDX, IDC_LIST1, m_jchulist);
	DDX_Text(pDX, IDC_EDIT1, m_num);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Jclist message handlers

BOOL Jclist::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
		RETCODE rc=0;
	int i,j;
	int count;
	HSTMT FAR * phstmt;
	char* a;
	CString sql;
	char* rgbValue;
	SDWORD FAR *pcbValue;
	pcbValue=(SDWORD FAR*)malloc(sizeof(SDWORD FAR));
	rgbValue=(char*)malloc(100);
	phstmt=(HSTMT FAR *)malloc(sizeof(HSTMT FAR));
	a=(char*)malloc(100);
	m_jchulist.InsertColumn(1,(char*)"卡号",LVCFMT_LEFT,100);
	m_jchulist.InsertColumn(2,(char*)"姓名",LVCFMT_LEFT,100);
	m_jchulist.InsertColumn(3,(char*)"书号",LVCFMT_LEFT,100);
	m_jchulist.InsertColumn(4,(char*)"书名",LVCFMT_LEFT,180);
	m_jchulist.InsertColumn(5,(char*)"借出时间",LVCFMT_LEFT,121);
	m_jchulist.InsertColumn(6,(char*)"最后限期",LVCFMT_LEFT,121);
	sql="select count(*) from 借书表"; 
	strcpy(a,sql.GetBuffer(sql.GetLength()));
	SQLAllocStmt(hdbc,phstmt);
	SQLExecDirect(*phstmt,(UCHAR FAR*)a,SQL_NTS);
	SQLFetch(*phstmt);
	SQLGetData(*phstmt,1,SQL_C_CHAR,rgbValue,10,pcbValue);
	m_num=rgbValue;
	UpdateData(false);

	sql="select 卡号,姓名,书号,书名,借出时间,最后限期 from 借书表"; 
	strcpy(a,sql.GetBuffer(sql.GetLength()));
	SQLAllocStmt(hdbc,phstmt);
	SQLExecDirect(*phstmt,(UCHAR FAR*)a,SQL_NTS);
	count=atoi(rgbValue);
	for(i=0;i<count;i++)
	{
		SQLFetch(*phstmt);
		if(rc==SQL_NO_DATA_FOUND)
			break;
		if(rc==SQL_SUCCESS||SQL_SUCCESS_WITH_INFO)
		{
			m_jchulist.InsertItem(i,"");
			for(j=1;j<=6;j++)
			{
				SQLGetData(*phstmt,j,SQL_C_CHAR,rgbValue,100,pcbValue);
				m_jchulist.SetItemText(i,j-1,rgbValue);
			}
		}
	}

	free(rgbValue);
	free(pcbValue);
	free(a);
	free(phstmt);



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