rylbdlg.cpp

图书馆信息管理系统

// RylbDlg.cpp : implementation file
//

#include "stdafx.h"
#include "GG.h"
#include "RylbDlg.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRylbDlg dialog


CRylbDlg::CRylbDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRylbDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRylbDlg)
	m_ZLMC = _T("");
	m_JSSL = _T("");
	m_JSQX = _T("");
	m_YXQX = _T("");
	//}}AFX_DATA_INIT
}


void CRylbDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRylbDlg)
	DDX_Control(pDX, IDC_LIST_RYLB, m_list_rylb);
	DDX_Text(pDX, IDC_EDIT1, m_ZLMC);
	DDX_Text(pDX, IDC_EDIT2, m_JSSL);
	DDX_Text(pDX, IDC_EDIT3, m_JSQX);
	DDX_Text(pDX, IDC_EDIT4, m_YXQX);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRylbDlg, CDialog)
	//{{AFX_MSG_MAP(CRylbDlg)
	ON_BN_CLICKED(IDC_RYLB_ADD, OnRylbAdd)
	ON_NOTIFY(NM_CLICK, IDC_LIST_RYLB, OnClickListRylb)
	ON_BN_CLICKED(IDC_RYLB_EDIT, OnRylbEdit)
	ON_BN_CLICKED(IDC_RYLB_DEL, OnRylbDel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRylbDlg message handlers



void CRylbDlg::OnRylbAdd() 
{
	// 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 %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());
	}  
	UpdateData(true);
	if(m_ZLMC== "" ||m_JSSL== "")
		{
			AfxMessageBox("种类名称和借书数量不能为空!");
			return;
		}
	////////////////////////////////////////////////////////////////////////

		CString s1;

		m_AdoConn.m_pRecordset->MoveFirst();
	while(!m_AdoConn.m_pRecordset->adoEOF)
	{
		try
		{
			s1=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("种类名称"));	
		}
		catch(...)
		{
			s1="      ";
		}
		if (s1==m_ZLMC)
		{
			MessageBox("不能添加相同类别!",NULL,MB_ICONEXCLAMATION);
			return;
		}
		m_AdoConn.m_pRecordset->MoveNext();
	}
	///////////////////////////////////////////////////////////////////////
	try
	{
		m_AdoConn.m_pRecordset->AddNew();
		m_AdoConn.m_pRecordset->PutCollect("种类名称", _variant_t(m_ZLMC));
		m_AdoConn.m_pRecordset->PutCollect("借书数量", _variant_t(m_JSSL));
		m_AdoConn.m_pRecordset->PutCollect("借书期限", _variant_t(m_JSQX));
		m_AdoConn.m_pRecordset->PutCollect("有效期限", _variant_t(m_YXQX));
				
		m_AdoConn.m_pRecordset->Update();

		
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	MessageBox("插入成功！");


	m_AdoConn.ExitConnect();
	ShowDate();



	
}

void CRylbDlg::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());
	}  
	m_list_rylb.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_rylb.InsertItem(iIndex,s,0);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书数量"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rylb.SetItemText(iIndex,1,s);
			try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书期限"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rylb.SetItemText(iIndex,2,s);
			try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("有效期限"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_rylb.SetItemText(iIndex,3,s);



		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;
		
	}

	//////////////////////////////////////////
	m_AdoConn.ExitConnect();

}

BOOL CRylbDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

	m_list_rylb.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
	m_list_rylb.SetBkColor(RGB(247,247,255));
	m_list_rylb.SetTextColor(RGB(0,0,255));
	m_list_rylb.SetTextBkColor(RGB(247,247,255));
	m_list_rylb.InsertColumn(0, "种类名称", LVCFMT_LEFT, 90);
	m_list_rylb.InsertColumn(1, "借书数量", LVCFMT_LEFT, 90);
	m_list_rylb.InsertColumn(2, "借书期限", LVCFMT_LEFT, 90);
	m_list_rylb.InsertColumn(3, "有效期限", LVCFMT_LEFT,90);
	
	// TODO: Add extra initialization here
	CRylbDlg::ShowDate();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CRylbDlg::OnClickListRylb(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 %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());
	}  

	POSITION pos=m_list_rylb.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_rylb.GetNextSelectedItem(pos);
	m_AdoConn.m_pRecordset->Move(nItem);
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("种类名称"));	
		}
	catch(...)
		{
			s="      ";
		}
		m_ZLMC=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书期限"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_JSQX=s;
try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("有效期限"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_YXQX=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书数量"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_JSSL=s;



	UpdateData(false);
	m_AdoConn.ExitConnect();
	*pResult = 0;
}

void CRylbDlg::OnRylbEdit() 
{
	// TODO: Add your control notification handler code here

	//////////////////////////////////////////////
	ADOConn m_AdoConn1;
	m_AdoConn1.OnInitADOConn();
	CString s1;
    
	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());
	}  




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


	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString s;
    
	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());
	}  

	POSITION pos=m_list_rylb.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_rylb.GetNextSelectedItem(pos);
	m_AdoConn.m_pRecordset->Move(nItem);
/*	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("种类名称"));	
		}
	catch(...)
		{
			s="      ";
		}
		m_ZLMC=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书期限"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_JSQX=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("有效期限"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_YXQX=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书数量"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_JSSL=s;*/
	UpdateData(false);
//	UpdateData(true);
	//////////////////////////////////////////////////////////////////////////
		

		m_AdoConn1.m_pRecordset->MoveFirst();
	while(!m_AdoConn1.m_pRecordset->adoEOF)
	{
		try
		{
			s1=(LPCSTR)_bstr_t(m_AdoConn1.m_pRecordset->GetCollect("读者类别"));	
		}
		catch(...)
		{
			s1="      ";
		}
		if (s1==m_ZLMC)
		{
			MessageBox("不能修改该类别!",NULL,MB_ICONEXCLAMATION);
			return;
		}
		m_AdoConn1.m_pRecordset->MoveNext();
	}	
	m_AdoConn1.ExitConnect();
	UpdateData(true);
	/////////////////////////////////////////////////////////////////////////
	try
	{
		
		m_AdoConn.m_pRecordset->PutCollect("种类名称", _variant_t(m_ZLMC));
		m_AdoConn.m_pRecordset->PutCollect("借书数量", _variant_t(m_JSSL));
		m_AdoConn.m_pRecordset->PutCollect("借书期限", _variant_t(m_JSQX));
		m_AdoConn.m_pRecordset->PutCollect("有效期限", _variant_t(m_YXQX));
				
		m_AdoConn.m_pRecordset->Update();

		
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	MessageBox("修改成功！");
	m_AdoConn.ExitConnect();
	ShowDate();
	
}

void CRylbDlg::OnRylbDel() 
{
	// TODO: Add your control notification handler code here
	ADOConn m_AdoConn1;
	m_AdoConn1.OnInitADOConn();
    
	m_AdoConn1.m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{		CString str,str1;
		str="SELECT * FROM 读者信息 WHERE 读者类别=";
		str1=str+"'"+m_ZLMC+"'";
		m_AdoConn1.m_pRecordset->Open(_variant_t(str1),                // 查询DemoTable表中所有字段
		m_AdoConn1.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
			adOpenDynamic,
			adLockOptimistic,
			adCmdText);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}  

	if(!m_AdoConn1.m_pRecordset->BOF)
	{
		MessageBox("该类别中有相关记录,不能删除",NULL,MB_ICONEXCLAMATION);
		return;
	}
	m_AdoConn1.ExitConnect;




	////////////////////////////////////////////////////////////////
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString s;
    
	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());
	}  
     
	POSITION pos=m_list_rylb.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_rylb.GetNextSelectedItem(pos);
	m_AdoConn.m_pRecordset->Move(nItem);
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("种类名称"));	
		}
	catch(...)
		{
			s="      ";
		}
		m_ZLMC=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书期限"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_JSQX=s;
try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("有效期限"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_YXQX=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("借书数量"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_JSSL=s;

	CString str1,str2;
	str1="你确定要删除记录";
	//str2.LoadString(IDS_WARN_2);
	str1=str1+m_ZLMC+": "+m_JSSL+str2;
	if(AfxMessageBox(str1,MB_YESNO|MB_ICONEXCLAMATION)==IDYES)
	{
		m_AdoConn.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
		UpdateData(false);
	}

	ShowDate();
	m_AdoConn.ExitConnect();
	
}