yqlist.cpp

图书管理系统

// Yqlist.cpp : implementation file
//

#include "stdafx.h"
#include "jeah_data.h"
#include "Yqlist.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
#include "XPButton.h"

/////////////////////////////////////////////////////////////////////////////
// Yqlist dialog


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


void Yqlist::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Yqlist)
	DDX_Control(pDX, IDOK, m_ok);
	DDX_Control(pDX, IDC_LIST1, m_yqlist);
	DDX_Text(pDX, IDC_EDIT1, m_num);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// Yqlist message handlers

BOOL Yqlist::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	RETCODE rc;
	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(400);
	m_yqlist.InsertColumn(1,(char*)"卡号",LVCFMT_LEFT,75);
	m_yqlist.InsertColumn(2,(char*)"姓名",LVCFMT_LEFT,75);
	m_yqlist.InsertColumn(3,(char*)"书号",LVCFMT_LEFT,75);
	m_yqlist.InsertColumn(4,(char*)"书名",LVCFMT_LEFT,195);
	m_yqlist.InsertColumn(5,(char*)"借出时间",LVCFMT_LEFT,100);
	m_yqlist.InsertColumn(6,(char*)"最后限期",LVCFMT_LEFT,100);
	m_yqlist.InsertColumn(7,(char*)"工作单位",LVCFMT_LEFT,154);
	m_yqlist.InsertColumn(8,(char*)"联系电话",LVCFMT_LEFT,101);	
	sql="SELECT COUNT(*) AS Expr1 FROM 借书表 INNER JOIN 读者表 ON 借书表.卡号 = 读者表.卡号 WHERE (借书表.最后限期 < GETDATE())"; 
	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 借书表,读者表 WHERE (借书表.卡号 = 读者表.卡号) and (借书表.最后限期<getdate())"; 
	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_yqlist.InsertItem(i,"");
			for(j=1;j<=8;j++)
			{
				rc=SQLGetData(*phstmt,j,SQL_C_CHAR,rgbValue,100,pcbValue);
				m_yqlist.SetItemText(i,j-1,rgbValue);				
			}
			
		}

	}

				




	free(rgbValue);
	free(pcbValue);
	free(a);
	free(phstmt);
//	free(rgbValue1);
//	free(pcbValue1);
//	free(b);
//	free(phstmt1);


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