lassfeepage.cpp

大学班务管理系统

// lassfeepage.cpp : implementation file
//

#include "stdafx.h"
#include "教学管理信息系统.h"
#include "lassfeepage.h"
#include "feeset.h"
#include "Public.h"

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

/////////////////////////////////////////////////////////////////////////////
// Classfeepage property page

IMPLEMENT_DYNCREATE(Classfeepage, CPropertyPage)

Classfeepage::Classfeepage() : CPropertyPage(Classfeepage::IDD)
{
	//{{AFX_DATA_INIT(Classfeepage)
	m_feein = _T("");
	m_feename = _T("");
	m_feeout = _T("");
	m_feestu = _T("");
	m_feetime = _T("");
	//}}AFX_DATA_INIT
}

Classfeepage::~Classfeepage()
{
}

void Classfeepage::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Classfeepage)
	DDX_Control(pDX, IDC_LISTclassfee, m_lstclassfee);
	DDX_Text(pDX, IDC_EDITfeein, m_feein);
	DDX_Text(pDX, IDC_EDITfeename, m_feename);
	DDX_Text(pDX, IDC_EDITfeeout, m_feeout);
	DDX_Text(pDX, IDC_EDITfeestu, m_feestu);
	DDX_Text(pDX, IDC_EDITfeetime, m_feetime);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Classfeepage, CPropertyPage)
	//{{AFX_MSG_MAP(Classfeepage)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_NOTIFY(NM_CLICK, IDC_LISTclassfee, OnClickLISTclassfee)
	ON_BN_CLICKED(IDC_BUTTONupdate, OnBUTTONupdate)
	ON_NOTIFY(LVN_COLUMNCLICK, IDC_LISTclassfee, OnColumnclickLISTclassfee)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Classfeepage message handlers
//添加班级的收费记录
void Classfeepage::OnButton1() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE); 
try{
	if(m_feeset.IsOpen())
		m_feeset.Close();
	 m_feeset.Open(CRecordset::dynaset,NULL,CRecordset::none);

     m_feeset.AddNew();


    m_feeset.m_feetime=m_feetime;
    m_feeset.m_feename=m_feename;
	m_feeset.m_feein=m_feein;
	m_feeset.m_feeout=m_feeout;
	m_feeset.m_feestu=m_feestu;
	
    m_feeset.Update();
    m_feeset.Requery();
    m_feeset.Close();
     m_lstclassfee.DeleteAllItems();
     initctrldata();
	 SetDlgItemText(IDC_EDITfeetime,""); 
	 SetDlgItemText(IDC_EDITfeename,"");
	 SetDlgItemText(IDC_EDITfeein,"");
	 SetDlgItemText(IDC_EDITfeeout,"");
	 SetDlgItemText(IDC_EDITfeestu,"");

}
catch(CDBException*e)
	{
		e->ReportError();
		return;
	}
}

BOOL Classfeepage::OnInitDialog() 
{
	CPropertyPage::OnInitDialog();
   if(CPublic::or==2)
    {
	GetDlgItem(IDC_BUTTON1)->EnableWindow(FALSE);
	GetDlgItem(IDC_BUTTONupdate)->EnableWindow(FALSE);
   }
	int i;
	DWORD dwNewStyle= LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES | LVS_EX_HEADERDRAGDROP |
		LVS_EX_ONECLICKACTIVATE | LVS_EX_UNDERLINEHOT;
	m_lstclassfee.SetExtendedStyle(dwNewStyle);
	m_lstclassfee.InsertColumn(0,"收费时间",LVCFMT_CENTER);
	m_lstclassfee.InsertColumn(1,"收支项目",LVCFMT_CENTER);
	m_lstclassfee.InsertColumn(2,"收入",LVCFMT_CENTER);
	m_lstclassfee.InsertColumn(3,"支出",LVCFMT_CENTER);
	m_lstclassfee.InsertColumn(4,"经手人",LVCFMT_CENTER);

	for(i=0;i<5;i++)
	m_lstclassfee.SetColumnWidth(i,80);
	initctrldata();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void Classfeepage::insertclassfeeinfo(CString feetime,CString feename,CString 
								feein,CString feeout,CString feestu)
								
{
	int index=m_lstclassfee.GetItemCount();
	LV_ITEM lvitem;
	lvitem.mask=LVIF_TEXT;
	lvitem.iItem=index;
	lvitem.iSubItem=0;
	CString temp;
	temp.Format("%d");
    lvitem.pszText=(char*)(LPCTSTR)temp;
	m_lstclassfee.InsertItem(&lvitem);
    m_lstclassfee.SetItemText(index,0,feetime);
	m_lstclassfee.SetItemText(index,1,feename);
	m_lstclassfee.SetItemText(index,2,feein);
	m_lstclassfee.SetItemText(index,3,feeout);

	m_lstclassfee.SetItemText(index,4,feestu);

}




void Classfeepage::initctrldata()
{
	 CDatabase m_database;
	   
	if(!m_database.Open(NULL,FALSE,FALSE,"ODBC;DSN=教务课程信息管理数据库"))
	{
		AfxMessageBox("连接数据库失败");
	}

	try{
        m_feeset.Open(CRecordset::dynaset,NULL,CRecordset::none);
		while(!m_feeset.IsEOF())
		{
		CString feetime,feename,feein,feeout,feestu;

		m_feeset.GetFieldValue((short)0,feetime);
        m_feeset.GetFieldValue(1,feename);
		m_feeset.GetFieldValue(2,feein);
		m_feeset.GetFieldValue(3,feeout);
		m_feeset.GetFieldValue(4,feestu);

		
        insertclassfeeinfo(feetime,feename,feein,feeout,feestu);
		m_feeset.MoveNext();
	}
	m_feeset.Close();
	}
	catch(CDBException*e)
	{
		e->ReportError();
	return;
	}

}


void Classfeepage::OnClickLISTclassfee(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
		 nitem=m_lstclassfee.GetNextItem(-1,LVNI_SELECTED);
	if(nitem!=-1)
	{
		m_feetime=m_lstclassfee.GetItemText(nitem,0);
        m_feename=m_lstclassfee.GetItemText(nitem,1);
		m_feein=m_lstclassfee.GetItemText(nitem,2);
		m_feeout=m_lstclassfee.GetItemText(nitem,3);
		m_feestu=m_lstclassfee.GetItemText(nitem,4);

	
         UpdateData(FALSE);
	}
	*pResult = 0;
}

void Classfeepage::OnBUTTONupdate() 
{
	// TODO: Add your control notification handler code here
	 if(m_feeset.IsOpen())
	   m_feeset.Close();
	 m_feeset.Open(CRecordset::dynaset,NULL,CRecordset::none);
     m_feeset.MoveFirst();
	 for(int i=0;i<=nitem;i++)
	 {
		 if(i==nitem)
		 {
    UpdateData(TRUE); 
	m_feeset.Edit();
    m_feeset.m_feetime=m_feetime;
    m_feeset.m_feename=m_feename;
	m_feeset.m_feein=m_feein;
	m_feeset.m_feeout=m_feeout;
	m_feeset.m_feestu=m_feestu;
    m_feeset.Update();
    m_feeset.Requery();
    m_feeset.Close();
    m_lstclassfee.DeleteAllItems();
    initctrldata(); 
	}
		 else
		 {
			m_feeset.MoveNext();
			 
		 }
 }
}

void Classfeepage::OnColumnclickLISTclassfee(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
	// TODO: Add your control notification handler code here
	int i=pNMListView->iSubItem;
    if(m_feeset.IsOpen())
	m_feeset.Close();
	m_feeset.Open(CRecordset::dynaset,NULL,CRecordset::none);
	if(i==0)
	{
	m_feeset.m_strSort="feetime";
	m_feeset.Close();
    m_lstclassfee.DeleteAllItems();
	initctrldata();
	}
    if(i==1)
	{
	m_feeset.m_strSort="feename";
	m_feeset.Close();
    m_lstclassfee.DeleteAllItems();
	initctrldata();
	}
	if(i==2)
	{
	m_feeset.m_strSort="feein";
	m_feeset.Close();
    m_lstclassfee.DeleteAllItems();
	initctrldata();
	}
	if(i==3)
	{
	m_feeset.m_strSort="feeout";
	m_feeset.Close();
    m_lstclassfee.DeleteAllItems();
	initctrldata();
	}
	if(i==4)
	{
	m_feeset.m_strSort="feestu";
	m_feeset.Close();
    m_lstclassfee.DeleteAllItems();
	initctrldata();
	}
	*pResult = 0;
}