tsxxdlg.cpp

图书馆信息管理系统

// TsxxDlg.cpp : implementation file
//

#include "stdafx.h"
#include "GG.h"
#include "TsxxDlg.h"
#include "adoconn.h"
#include "TsxxcxDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTsxxDlg dialog


CTsxxDlg::CTsxxDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTsxxDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTsxxDlg)
	m_SJBH = _T("");
	m_JIAGE = _T("");
	m_SHIFOU = _T("");
	m_SHUMIN = _T("");
	m_ZUOZ = _T("");
	m_CBS = _T("");
	m_TSLB = _T("");
	m_CBRQ = _T("");
	m_DJRQ = _T("");
	//}}AFX_DATA_INIT
	i=true;
}


void CTsxxDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTsxxDlg)
	DDX_Control(pDX, IDC_COMBO1, m_Ctlsb);
	DDX_Control(pDX, IDC_LIST_TSXX, m_list_tsxx);
	DDX_Text(pDX, IDC_EDIT4, m_SJBH);
	DDX_Text(pDX, IDC_EDIT3, m_JIAGE);
	DDX_CBString(pDX, IDC_COMBO2, m_SHIFOU);
	DDX_Text(pDX, IDC_EDIT5, m_SHUMIN);
	DDX_Text(pDX, IDC_EDIT2, m_ZUOZ);
	DDX_Text(pDX, IDC_EDIT1, m_CBS);
	DDX_CBString(pDX, IDC_COMBO1, m_TSLB);
	DDX_Text(pDX, IDC_EDIT6, m_CBRQ);
	DDX_Text(pDX, IDC_EDIT7, m_DJRQ);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTsxxDlg, CDialog)
	//{{AFX_MSG_MAP(CTsxxDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST_TSXX, OnClickListTsxx)
	ON_BN_CLICKED(IDC_TSXX_ADD, OnTsxxAdd)
	ON_BN_CLICKED(IDC_TSXX_DEL, OnTsxxDel)
	ON_BN_CLICKED(IDC_TSXX_EDIT, OnTsxxEdit)
	ON_BN_CLICKED(IDC_TSXX_QUERY, OnTsxxQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTsxxDlg message handlers

BOOL CTsxxDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_list_tsxx.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
	m_list_tsxx.SetBkColor(RGB(247,247,255));
	m_list_tsxx.SetTextColor(RGB(0,0,255));
	m_list_tsxx.SetTextBkColor(RGB(247,247,255));
	m_list_tsxx.InsertColumn(0, "书籍编号", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(1, "书名", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(2, "类别", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(3, "作者", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(4, "出版社", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(5, "出版日期", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(6, "登记日期", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(7, "是否已借出", LVCFMT_LEFT, 80);
	m_list_tsxx.InsertColumn(8, "价格", LVCFMT_LEFT, 60);
	ShowDate();
	/////////////////////////////////////////////
	//连接数据库
	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_Ctlsb.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
}

void CTsxxDlg::ShowDate()
{
//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
    CString strSql;
	m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		if(i)
		{
			//CString strSql;
			strSql.Format("SELECT * FROM %s","书籍信息");
		}
		else
		{
		//	CString strSql;
			CString str1,str2;
			if(tsxxcxdlg_m_1 & tsxxcxdlg_m_2)
			{
				str1="SELECT * FROM 书籍信息 WHERE 类别=";
				str2="AND 书名=";
				strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'"+str2+"'"+tsxxcxdlg_m_SMCX+"'";
			}
			else if(tsxxcxdlg_m_1)
			{
				str1="SELECT * FROM 书籍信息 WHERE 类别=";
				strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'";
			}
			else if(tsxxcxdlg_m_2)
			{
				str1="SELECT * FROM 书籍信息 WHERE 书名=";
				strSql=str1+"'"+tsxxcxdlg_m_SMCX+"'";
			}
			else
			{
			MessageBox("请输入查询条件！");
			}
		}
		//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());
	}  
	m_list_tsxx.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_tsxx.InsertItem(iIndex,s,0);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书名"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,1,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,2,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("作者"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,3,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版社"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,4,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版日期"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,5,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("登记日期"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,6,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("是否被借出"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,7,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("价格"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tsxx.SetItemText(iIndex,8,s);
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;

}
}

void CTsxxDlg::OnClickListTsxx(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString s;
	CString strSql;
    
	m_AdoConn.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		if(i)
		{
			//CString strSql;
			strSql.Format("SELECT * FROM %s","书籍信息");
		}
		else
		{
		//	CString strSql;
			CString str1,str2;
			if(tsxxcxdlg_m_1 & tsxxcxdlg_m_2)
			{
				str1="SELECT * FROM 书籍信息 WHERE 类别=";
				str2="AND 书名=";
				strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'"+str2+"'"+tsxxcxdlg_m_SMCX+"'";
			}
			else if(tsxxcxdlg_m_1)
			{
				str1="SELECT * FROM 书籍信息 WHERE 类别=";
				strSql=str1+"'"+tsxxcxdlg_m_TSLBCX+"'";
			}
			else if(tsxxcxdlg_m_2)
			{
				str1="SELECT * FROM 书籍信息 WHERE 书名=";
				strSql=str1+"'"+tsxxcxdlg_m_SMCX+"'";
			}
			else
			{
			MessageBox("请输入查询条件！");
			}
		}
		//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_tsxx.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_tsxx.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