tslbdlg.cpp

图书馆信息管理系统

// TslbDlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CTslbDlg dialog


CTslbDlg::CTslbDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTslbDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTslbDlg)
	m_lbbh = _T("");
	m_lbmc = _T("");
	//}}AFX_DATA_INIT
}


void CTslbDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTslbDlg)
	DDX_Control(pDX, IDC_LIST_TSGL, m_list_tslb);
	DDX_Text(pDX, IDC_EDIT1, m_lbbh);
	DDX_Text(pDX, IDC_EDIT2, m_lbmc);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTslbDlg, CDialog)
	//{{AFX_MSG_MAP(CTslbDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST_TSGL, OnClickListTsgl)
	ON_BN_CLICKED(IDC_TSLB_ADD, OnTslbAdd)
	ON_BN_CLICKED(IDC_TSLB_DEL, OnTslbDel)
	ON_BN_CLICKED(IDC_TSLB_EDIT, OnTslbEdit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTslbDlg message handlers

void CTslbDlg::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_tslb.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_tslb.InsertItem(iIndex,s,0);
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别名称"));
		}
		catch(...)
		{
			s="      ";
		}				
		m_list_tslb.SetItemText(iIndex,1,s);
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;
		
	}

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

BOOL CTslbDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_list_tslb.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
	m_list_tslb.SetBkColor(RGB(247,247,255));
	m_list_tslb.SetTextColor(RGB(0,0,255));
	m_list_tslb.SetTextBkColor(RGB(247,247,255));
	m_list_tslb.InsertColumn(0, "类别编号", LVCFMT_LEFT, 90);
	m_list_tslb.InsertColumn(1, "类别名称", LVCFMT_LEFT, 130);
	
	CTslbDlg::ShowDate();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTslbDlg::OnClickListTsgl(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_tslb.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_tslb.GetNextSelectedItem(pos);
	m_AdoConn.m_pRecordset->Move(nItem);
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别编号"));	
		}
	catch(...)
		{
			s="      ";
		}
		m_lbbh=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别名称"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_lbmc=s;
	UpdateData(false);
	m_AdoConn.ExitConnect();

	*pResult = 0;
}

void CTslbDlg::OnTslbAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	if(m_lbbh == "" || m_lbmc == "")
	{
		AfxMessageBox("类别编号和类别名称不能为空!");
		return;
	}
	//////////////////////////////////////////////////////////////
	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;
	}

	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="      ";
		}
		if (s==m_lbbh)
		{
			MessageBox("不能添加相同编号");
			return;
		}
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别名称"));
		}
		catch(...)
		{
			s="      ";
		}				
		if (s==m_lbmc)
		{
			MessageBox("不能添加相同类别");
			return;
		}
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;
		
	}

	try
	{
		// 写入各字段值
		m_AdoConn.m_pRecordset->AddNew();
		m_AdoConn.m_pRecordset->PutCollect("类别编号", _variant_t(m_lbbh));
		m_AdoConn.m_pRecordset->PutCollect("类别名称", _variant_t(m_lbmc));
		m_AdoConn.m_pRecordset->Update();

		AfxMessageBox("插入成功!");

	/*	// 更新显示其库内容
		int nCurSel = m_AccessList.GetCurSel();
		ListData();
		m_AccessList.SetCurSel(nCurSel);
		// 移动记录指针到新的位置
		OnSelchangeListaccess();*/
		
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	m_AdoConn.ExitConnect();
	ShowDate();

	
}

void CTslbDlg::OnTslbDel() 
{
	// 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_lbmc+"'";

			
		//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(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_tslb.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_tslb.GetNextSelectedItem(pos);
	m_AdoConn.m_pRecordset->Move(nItem);
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别编号"));	
		}
	catch(...)
		{
			s="      ";
		}
		m_lbbh=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别名称"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_lbmc=s;
	CString str1,str2;
	str1="你确定要删除记录";
	//str2.LoadString(IDS_WARN_2);
	str1=str1+m_lbmc+": "+m_lbbh+str2;
	if(AfxMessageBox(str1,MB_YESNO|MB_ICONEXCLAMATION)==IDYES)
	{
		m_AdoConn.m_pRecordset->Delete(adAffectCurrent);///删除当前记录
		m_AdoConn.m_pRecordset->Update();

		UpdateData(false);
	}
	m_AdoConn.ExitConnect();


	//m_pRecordset->Delete(adAffectCurrent);///删除当前记录
	ShowDate();
	
}

void CTslbDlg::OnTslbEdit() 
{
	// 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_tslb.GetFirstSelectedItemPosition();
	if(pos==NULL)
		return;
	int nItem=m_list_tslb.GetNextSelectedItem(pos);
	m_AdoConn.m_pRecordset->Move(nItem);
	/*try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别编号"));	
		}
	catch(...)
		{
			s="      ";
		}
		m_lbbh=s;
	try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别名称"));
		}
	catch(...)
		{
			s="      ";
		}				
	m_lbmc=s;*/
	UpdateData(false);
	///////////////////////////////////
//	UpdateData(true);
	//////////////////////////////////////////////
	
	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="      ";
		}
		if (s==m_lbbh)
		{
			MessageBox("不能修改该类别");
			return;
		}
		try
		{
			s=(LPCSTR)_bstr_t(m_AdoConn.m_pRecordset->GetCollect("类别名称"));
		}
		catch(...)
		{
			s="      ";
		}				
		if (s==m_lbmc)
		{
			MessageBox("不能修改该类别");
			return;
		}
		
		UpdateData(FALSE);
		m_AdoConn.m_pRecordset->MoveNext();
		iIndex++;
		
	}
	//////////////////////////////////////////////////
	UpdateData(true);
	try
	{
		m_AdoConn.m_pRecordset->PutCollect("类别编号", _variant_t(m_lbbh));
		m_AdoConn.m_pRecordset->PutCollect("类别名称", _variant_t(m_lbmc));
		m_AdoConn.m_pRecordset->Update();

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

	
}