countmoneydlg.cpp

基于VB的数据库教材管理系统设计 有源码

// CountmoneyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookManager.h"
#include "CountmoneyDlg.h"
#include "CountbookSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCountmoneyDlg dialog


CCountmoneyDlg::CCountmoneyDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CCountmoneyDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCountmoneyDlg)
	m_str_stid = _T("");
	m_totalmoney = 0.0f;
	//}}AFX_DATA_INIT
}


void CCountmoneyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCountmoneyDlg)
	DDX_Control(pDX, IDC_Countall, m_bnt_Countall);
	DDX_Control(pDX, IDC_Moneylist, m_Moneylist);
	DDX_Control(pDX, IDC_Stid, m_ctr_stid);
	DDX_Text(pDX, IDC_Stid, m_str_stid);
	DDX_Text(pDX, IDC_totalmoney, m_totalmoney);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCountmoneyDlg, CDialog)
	//{{AFX_MSG_MAP(CCountmoneyDlg)
	ON_BN_CLICKED(IDC_Lookup, OnLookup)
	ON_BN_CLICKED(IDC_Countall, OnCountall)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCountmoneyDlg message handlers

BOOL CCountmoneyDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_Moneylist.InsertColumn(0,"编号");
	m_Moneylist.InsertColumn(1,"书籍条码");
	m_Moneylist.InsertColumn(2,"书籍名称");
	m_Moneylist.InsertColumn(3,"领取数量");
	m_Moneylist.InsertColumn(4,"书籍单价(元)");
	m_Moneylist.InsertColumn(5,"单项总价(元)");
	m_Moneylist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_Moneylist.SetColumnWidth(0,60);
	m_Moneylist.SetColumnWidth(1,100);
	m_Moneylist.SetColumnWidth(2,140);
	m_Moneylist.SetColumnWidth(3,80);
	m_Moneylist.SetColumnWidth(4,100);
	m_Moneylist.SetColumnWidth(5,100);
	m_bnt_Countall.EnableWindow(TRUE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCountmoneyDlg::OnLookup() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_str_stid.IsEmpty())
	{
	   MessageBox("请先输入你的学号！");
	   m_ctr_stid.SetFocus();
	}
	else{
	CString strSQL;
	CCountbookSet recordset;
	strSQL.Format("select * from \
	 bookIM,bookout where bookIM.book_id=bookout.book_id and st_id='%s'",m_str_stid); 
	if(!recordset.Open(CRecordset::snapshot,strSQL))
	{
      
	   MessageBox("打开数据库失败！","数据库错误",MB_OK);
	   return;
	}
	 else if(recordset.GetRecordCount()==0)
	 {
	    MessageBox("数据库没有你要的记录！");
		return;
	 }
	 else{
	    m_Moneylist.DeleteAllItems();
	  m_Moneylist.SetRedraw(FALSE);
	  int i=0;
	 
	  while(!recordset.IsEOF())
	  {
		m_Moneylist.InsertItem(i," ");
	    CString str;
		str.Format("%d",i+1);
		m_Moneylist.SetItemText(i,0,str);
		m_Moneylist.SetItemText(i,1,recordset.m_book_id);
		m_Moneylist.SetItemText(i,2,recordset.m_book_name);
		CString str2;
		CString str3;
		str2.Format("%d",recordset.m_number);
		str3.Format("%f",recordset.m_price);
		m_Moneylist.SetItemText(i,3,str2);
		m_Moneylist.SetItemText(i,4,str3);
		CString str4;
		str4.Format("%f",recordset.m_number*recordset.m_price);
		m_Moneylist.SetItemText(i,5,str4);
		recordset.MoveNext();
		i++;
	  }
	  temp=i;
	  m_totalmoney=0;
	  m_bnt_Countall.EnableWindow(TRUE);
      recordset.Close(); 
	  m_Moneylist.SetRedraw(TRUE);
	  m_Moneylist.Invalidate();
	  
	  
	 }
	 
	}
}

void CCountmoneyDlg::OnCountall() 
{
	// TODO: Add your control notification handler code here
	while(temp>=0)
	{
	   CString temp1;
	   temp1=m_Moneylist.GetItemText(temp,5);
	   float temp2=atof(temp1);
	   m_totalmoney+=temp2;
       temp--;
	   CString st;
	   st.Format("%f",temp2);
	   
	}
	UpdateData(FALSE);
	MessageBox("统计成功！");
	m_bnt_Countall.EnableWindow(FALSE);
}