jsgldlg.cpp

图书馆信息管理系统

// JsglDlg.cpp : implementation file
//

#include "stdafx.h"
#include "GG.h"
#include "JsglDlg.h"
#include "ADOCONN.H"

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

/////////////////////////////////////////////////////////////////////////////
// CJsglDlg dialog


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


void CJsglDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CJsglDlg)
	DDX_Control(pDX, IDC_LIST_YJTS, m_list_yjts);
	DDX_Control(pDX, IDC_COMBO1, m_CJSR);
	DDX_Control(pDX, IDC_LIST_KJTS, m_list_jsgl);
	DDX_CBString(pDX, IDC_COMBO1, m_JSR);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CJsglDlg, CDialog)
	//{{AFX_MSG_MAP(CJsglDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST_KJTS, OnClickListKjts)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CJsglDlg message handlers

BOOL CJsglDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_list_jsgl.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
	m_list_jsgl.SetBkColor(RGB(247,247,255));
	m_list_jsgl.SetTextColor(RGB(0,0,255));
	m_list_jsgl.SetTextBkColor(RGB(247,247,255));
	m_list_jsgl.InsertColumn(0, "书籍编号", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(1, "书名", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(2, "类别", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(3, "作者", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(4, "出版社", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(5, "出版日期", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(6, "登记日期", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(7, "是否已借出", LVCFMT_LEFT, 80);
	m_list_jsgl.InsertColumn(8, "价格", LVCFMT_LEFT, 60);
	///////////////////////////////////////////////////////////////
	m_list_yjts.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
	m_list_yjts.SetBkColor(RGB(247,247,255));
	m_list_yjts.SetTextColor(RGB(0,0,255));
	m_list_yjts.SetTextBkColor(RGB(247,247,255));
	m_list_yjts.InsertColumn(0, "读者编号", LVCFMT_LEFT, 80);
	m_list_yjts.InsertColumn(1, "读者", LVCFMT_LEFT, 80);
	m_list_yjts.InsertColumn(2, "书籍编号", LVCFMT_LEFT, 80);
	m_list_yjts.InsertColumn(3, "书名", LVCFMT_LEFT, 80);
	m_list_yjts.InsertColumn(4, "出借日期", LVCFMT_LEFT, 180);

	///////////////////////////////////////////////////////////////
	ShowKjts();
/////////////////////////////////////////////////////////
	ADOConn m_AdoConn1;
	m_AdoConn1.OnInitADOConn();
    
	m_AdoConn1.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_AdoConn1.m_pRecordset->Open(_variant_t(strSql),                // 查询DemoTable表中所有字段
		m_AdoConn1.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
			adOpenDynamic,
			adLockOptimistic,
			adCmdText);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}  
	
	///////////////////////////////////////////////
	if(!m_AdoConn1.m_pRecordset->BOF)
		m_AdoConn1.m_pRecordset->MoveFirst();
	else
	{
		AfxMessageBox("表内数据为空");
		return 0;
	}


	
	m_AdoConn1.m_pRecordset->MoveFirst();
	while(!m_AdoConn1.m_pRecordset->adoEOF)
	{
		try
		{
			s1=(LPCSTR)_bstr_t(m_AdoConn1.m_pRecordset->GetCollect("读者姓名"));	
		}
		catch(...)
		{
			s1="      ";
		}
		m_CJSR.AddString(s1);
		try
		{
			s1=(LPCSTR)_bstr_t(m_AdoConn1.m_pRecordset->GetCollect("读者编号"));	
		}
		catch(...)
		{
			s1="      ";
		}
		m_DZBH=s1;
		
		UpdateData(false);
		m_AdoConn1.m_pRecordset->MoveNext();
	}
	ShowYjts();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
	
	
}



void CJsglDlg::OnClickListKjts(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString s;
    
	m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		CString strSql;
		strSql.Format("SELECT * FROM 书籍信息 WHERE 是否被借出='否'");
		//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());
	}  

	POSITION pos=m_list_jsgl.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_jsgl.GetNextSelectedItem(pos);
	m_AdoConn.m_pRecordset->Move(nItem);
	
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书籍编号"));	
		}
	catch(...)
		{
			s="      ";
		}
		m_SJBH=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书名"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_SHUMIN=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_TSLB=s;
	
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("作者"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_ZUOZ=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版社"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_CBS=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版日期"));
			//AfxMessageBox(s);
		}
	catch(...)
		{
			s="      ";
		}				
	m_CBRQ=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("登记日期"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_DJRQ=s;
	
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("是否被借出"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_SHIFOU=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("价格"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_JIAGE=s;
	UpdateData(true);
	m_AdoConn.ExitConnect();
	//CString m_SJBH,m_SHUMIN,m_TSLB,m_ZUOZ,m_CBS,m_CBRQ,m_DJRQ,m_SHIFOU,m_JIAGE;
//	CString str;
//	str=m_SJBH+m_SHUMIN+m_TSLB;
	//MessageBox(str);
	
	*pResult = 0;
}

void CJsglDlg::OnOK() 
{
	UpdateData();
	// TODO: Add extra validation here
	if (""==m_JSR)
	{	MessageBox("请输入借书人姓名!","",MB_ICONASTERISK);
		return;
	}
	if (""==m_SHUMIN)
	{	MessageBox("请选择要借的书籍!","",MB_ICONASTERISK);
		return;
	}
	if(""==m_JSR&""==m_SHUMIN)
	{	MessageBox("请输入必要信息!","",MB_ICONASTERISK);
		return;
	}

	CString M=m_JSR+"确定借"+m_SHUMIN;
	//MessageBox(M,"",MB_YESNO|MB_ICONQUESTION);
	if(IDNO==MessageBox(M,"",MB_YESNO|MB_ICONQUESTION))
	return;

	////////////////////////////////////////
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		CString strSql;
		strSql.Format("SELECT * FROM 借阅信息");
		//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());
	}  
	CString DateTime;   
	CTime t=CTime::GetCurrentTime();