jsgldlg.cpp

图书馆信息管理系统

	DateTime=t.Format(_T("%Y-%m-%d   %H:%M:%S"));   

	try
	{
		m_AdoConn.m_pRecordset->AddNew();
		m_AdoConn.m_pRecordset->PutCollect("读者姓名", _variant_t(m_JSR));
		m_AdoConn.m_pRecordset->PutCollect("书籍名称", _variant_t(m_SHUMIN));
		m_AdoConn.m_pRecordset->PutCollect("出借日期", _variant_t(DateTime));
		m_AdoConn.m_pRecordset->PutCollect("书籍编号", _variant_t(m_SJBH));
		m_AdoConn.m_pRecordset->PutCollect("读者编号", _variant_t(m_DZBH));
		m_AdoConn.m_pRecordset->Update();

		
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
		m_AdoConn.ExitConnect();
/////////////////////////////////////////////////////////////
	ADOConn m_AdoConn1;
	m_AdoConn1.OnInitADOConn();
	m_AdoConn1.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		CString strSql;
		strSql=("SELECT * FROM 读者信息 WHERE 读者姓名=");
		strSql=strSql+"'"+m_JSR+"'";
		//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());
	}  
	CString n;
	int m;
	n=(LPCSTR)_bstr_t(m_AdoConn1.m_pRecordset->GetCollect("已借书数量"));
	m=atoi(n);
	m=m+1;
	n.Format("%d",m);
	
	m_AdoConn1.m_pRecordset->PutCollect("已借书数量", _variant_t(n));
	
	m_AdoConn1.m_pRecordset->Update();
	m_AdoConn1.ExitConnect();

/////////////////////////////////////////////////////////////

	ADOConn m_AdoConn2;
	m_AdoConn2.OnInitADOConn();
	m_AdoConn2.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		CString strSql;
		strSql=("SELECT * FROM 书籍信息 WHERE 书籍编号=");
		strSql=strSql+"'"+m_SJBH+"'";
		//rSql="SELECT DateA,Sum(MoneyA) as MoneySum FROM Budget group by DateA having DateA>=#2004-8-1# and DateA<=#2004-8-2#";
		m_AdoConn2.m_pRecordset->Open(_variant_t(strSql),                // 查询DemoTable表中所有字段
		m_AdoConn2.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
			adOpenDynamic,
			adLockOptimistic,
			adCmdText);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}  


	m_AdoConn2.m_pRecordset->PutCollect("是否被借出", _variant_t("是"));
	m_AdoConn2.m_pRecordset->Update();
	m_AdoConn2.ExitConnect();
	CString c;
	c="借阅成功"+m_JSR+"已借"+n+"本";
	MessageBox(c);


	ShowKjts();
	ShowYjts();

//	CDialog::OnOK();
}

void CJsglDlg::ShowKjts()
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
    
	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());
	}  
	m_list_jsgl.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_jsgl.InsertItem(iIndex,s,0);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书名"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,1,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,2,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("作者"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,3,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版社"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,4,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出版日期"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,5,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("登记日期"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,6,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("是否被借出"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,7,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("价格"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_jsgl.SetItemText(iIndex,8,s);
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;
		

}
	m_AdoConn.ExitConnect();
}

void CJsglDlg::ShowYjts()
{
	//MessageBox("hello");
	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());
	}  
	m_list_yjts.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_yjts.InsertItem(iIndex,s,0);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("读者姓名"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_yjts.SetItemText(iIndex,1,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书籍编号"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_yjts.SetItemText(iIndex,2,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("书籍名称"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_yjts.SetItemText(iIndex,3,s);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("出借日期"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_yjts.SetItemText(iIndex,4,s);
		
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;
		

}
	m_AdoConn.ExitConnect();
}