bookinmanydlg.cpp

mysql+visual C++编写的mini图书馆数据库管理系统

// BookInManyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "BookRS1.h"
#include "BookInManyDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookInManyDlg dialog


CBookInManyDlg::CBookInManyDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBookInManyDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBookInManyDlg)
	m_path = _T("");
	//}}AFX_DATA_INIT
}


void CBookInManyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBookInManyDlg)
	DDX_Text(pDX, IDC_FILEPATH, m_path);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBookInManyDlg, CDialog)
	//{{AFX_MSG_MAP(CBookInManyDlg)
	ON_BN_CLICKED(IDC_VIEW, OnView)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBookInManyDlg message handlers

void CBookInManyDlg::OnOK() 
{
	int   year,month,day,kindnum,totalnum;
	kindnum=totalnum=0;
	UpdateData();
	if(!m_bookSet.IsOpen()){
		m_bookSet.Open();
	}
	FILE * fp=fopen(m_path,"r+");
	while(fscanf(fp,"%s",m_BookNum.GetBuffer(256))!=EOF)
	{
		m_BookNum.ReleaseBuffer();
        fscanf(fp,"%s",m_BookKind.GetBuffer(256));
		m_BookKind.ReleaseBuffer();
        fscanf(fp,"%s",m_BookTitle.GetBuffer(256));
		m_BookTitle.ReleaseBuffer();
        fscanf(fp,"%s",m_BookPress.GetBuffer(256));
		m_BookPress.ReleaseBuffer();
	    fscanf(fp,"%s",m_BookAuthor.GetBuffer(256));
		m_BookAuthor.ReleaseBuffer();
        fscanf(fp,"%d-%d-%d",&year,&month,&day);
		fscanf(fp,"%lf",&m_BookPrice);
		fscanf(fp,"%d",&m_BookTotal);
	    m_bookSet.m_strFilter.Format("ISBN='%s'",m_BookNum);
	    m_bookSet.Requery();
	    if(!m_bookSet.IsEOF()){
            m_bookSet.Edit();
		    m_bookSet.m_total_num+=m_BookTotal;
		    m_bookSet.m_stock_num+=m_BookTotal;
	     	m_bookSet.Update();
			totalnum+=m_BookTotal;
		}
    	else{
	    	m_bookSet.AddNew();
		    m_bookSet.m_ISBN=m_BookNum;
	    	m_bookSet.m_kind=m_BookKind;
	    	m_bookSet.m_title=m_BookTitle;
	    	m_bookSet.m_press=m_BookPress;
	    	m_bookSet.m_authors=m_BookAuthor;
			CTime date(year,month,day,0,0,0);
            m_bookSet.m_pub_date=date;
    		m_bookSet.m_price=m_BookPrice;
    		m_bookSet.m_total_num=m_BookTotal;
	    	m_bookSet.m_stock_num=m_BookTotal;
	    	m_bookSet.Update();
			kindnum++;
            totalnum+=m_BookTotal;
		}
	}
	CString s="批量图书入库成功\n此次共新入库图书";
	CString s1;
	s1.Format("%d",kindnum);   
	s+=s1;
	s1="种，合计";
    s+=s1;
	s1.Format("%d",totalnum);
	s+=s1;
	s1="本!";
	s+=s1;
	AfxMessageBox(s);
	CDialog::OnOK();
}

void CBookInManyDlg::OnView() 
{
	// TODO: Add your control notification handler code here
	//CString m_strDlgPath;
	CFileDialog dlg(TRUE, _T("*.in"), _T("*.in"), OFN_HIDEREADONLY |OFN_OVERWRITEPROMPT,_T("入库文件(*.in)|*.in|文本文件(*.txt)|*.txt|数据文件(*.dat)|*.dat|所有文件(*.*)|*.*|"));   
	if (IDOK== dlg.DoModal())
    {
		//m_strDlgPath = dlg.GetPathName();
		m_path = dlg.GetPathName();  //带路径的文件名
		UpdateData(FALSE);
    }
	
}