jjljdlg.cpp

工资表数据库系统

// jjljdlg.cpp : implementation file
//

#include "stdafx.h"
#include "工资表.h"
#include "jjljdlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// Cjjljdlg dialog


Cjjljdlg::Cjjljdlg(CWnd* pParent /*=NULL*/)
	: CDialog(Cjjljdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cjjljdlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void Cjjljdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cjjljdlg)
	DDX_Control(pDX, IDC_LIST1, m_list);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cjjljdlg, CDialog)
	//{{AFX_MSG_MAP(Cjjljdlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cjjljdlg message handlers

BOOL Cjjljdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_list.InsertColumn(0,"号",LVCFMT_LEFT,20);
	m_list.InsertColumn(1,"一月",LVCFMT_LEFT,60);
	m_list.InsertColumn(2,"二月",LVCFMT_LEFT,60);
	m_list.InsertColumn(3,"三月",LVCFMT_LEFT,60);
	m_list.InsertColumn(4,"四月",LVCFMT_LEFT,60);
	m_list.InsertColumn(5,"五月",LVCFMT_LEFT,60);
	m_list.InsertColumn(6,"六月",LVCFMT_LEFT,60);
	m_list.InsertColumn(7,"七月",LVCFMT_LEFT,60);
	m_list.InsertColumn(8,"八月",LVCFMT_LEFT,60);
	m_list.InsertColumn(9,"九月",LVCFMT_LEFT,60);
	m_list.InsertColumn(10,"十月",LVCFMT_LEFT,60);
	m_list.InsertColumn(11,"十一月",LVCFMT_LEFT,60);
	m_list.InsertColumn(12,"十二月",LVCFMT_LEFT,60);
    //给列表加上表格
	LONG lStyle = m_list.SendMessage(LVM_GETEXTENDEDLISTVIEWSTYLE);
    lStyle |= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES |LVS_EX_HEADERDRAGDROP;
    m_list.SendMessage(LVM_SETEXTENDEDLISTVIEWSTYLE, 0,(LPARAM)lStyle);
	ReadRecord();	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void Cjjljdlg::ReadRecord()
{
	//读出纪录
    CStdioFile mFile; 
	CFileException mExcept;
	CString readstr;
	CString IDstr;
	int i=0;
	if(!mFile.Open("基金累积表.txt",CFile::modeRead,&mExcept))
        mFile.Open("基金累积表.txt",CFile::modeCreate|CFile::modeRead,&mExcept);
	while(mFile.ReadString(readstr))
	{
		IDstr.Format("%d",(i+1));
		m_list.InsertItem(i,IDstr);
	    m_list.SetItemText(i,1,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,2,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,3,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,4,readstr);	
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,5,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,6,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,7,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,8,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,9,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,10,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,11,readstr);
        mFile.ReadString(readstr);
     	m_list.SetItemText(i,12,readstr);

		i++;		
	}
}

void Cjjljdlg::OnButton1() 
{

	CString str;
	CString IDstr;
	CString m_list;
	int i=0;
    CStdioFile mFile; 
	CFileException mExcept;
	if(!mFile.Open("基金累积表.xls",CFile::modeWrite,&mExcept))
        mFile.Open("基金累积表.xls",CFile::modeCreate|CFile::modeWrite,&mExcept);

}