cjlr.cpp

以班级为单位对每门课程的考试成绩进行评价。

// Cjlr.cpp : implementation file
//

#include "stdafx.h"
#include "sjfx.h"
#include "Cjlr.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCjlr dialog


CCjlr::CCjlr(CWnd* pParent /*=NULL*/)
	: CDialog(CCjlr::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCjlr)
	m_nt9 = _T("");
	m_nt8 = _T("");
	m_nt7 = _T("");
	m_nt6 = _T("");
	m_nt5 = _T("");
	m_nt4 = _T("");
	m_nt3 = _T("");
	m_nt2 = _T("");
	m_nt10 = _T("");
	m_nt1 = _T("");
	m_xh = _T("");
	m_xm = _T("");
	m_zf = _T("");
	m_zrs = _T("");
	//}}AFX_DATA_INIT
}


void CCjlr::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCjlr)
	DDX_Control(pDX, IDC_PREV, m_prev);
	DDX_Control(pDX, IDC_NEXT, m_next);
	DDX_Control(pDX, IDC_LAST, m_last);
	DDX_Control(pDX, IDC_FIRST, m_first);
	DDX_Control(pDX, IDC_MODIFY, m_modify);
	DDX_Control(pDX, IDC_DELETE, m_delete);
	DDX_Control(pDX, IDC_T9, m_ct9);
	DDX_Control(pDX, IDC_T8, m_ct8);
	DDX_Control(pDX, IDC_T7, m_ct7);
	DDX_Control(pDX, IDC_T6, m_ct6);
	DDX_Control(pDX, IDC_T5, m_ct5);
	DDX_Control(pDX, IDC_T4, m_ct4);
	DDX_Control(pDX, IDC_T3, m_ct3);
	DDX_Control(pDX, IDC_T2, m_ct2);
	DDX_Control(pDX, IDC_T10, m_ct10);
	DDX_Control(pDX, IDC_T1, m_ct1);
	DDX_Control(pDX, IDC_S9, m_s9);
	DDX_Control(pDX, IDC_S8, m_s8);
	DDX_Control(pDX, IDC_S7, m_s7);
	DDX_Control(pDX, IDC_S6, m_s6);
	DDX_Control(pDX, IDC_S5, m_s5);
	DDX_Control(pDX, IDC_S4, m_s4);
	DDX_Control(pDX, IDC_S3, m_s3);
	DDX_Control(pDX, IDC_S2, m_s2);
	DDX_Control(pDX, IDC_S10, m_s10);
	DDX_Control(pDX, IDC_S1, m_s1);
	DDX_Text(pDX, IDC_T9, m_nt9);
	DDX_Text(pDX, IDC_T8, m_nt8);
	DDX_Text(pDX, IDC_T7, m_nt7);
	DDX_Text(pDX, IDC_T6, m_nt6);
	DDX_Text(pDX, IDC_T5, m_nt5);
	DDX_Text(pDX, IDC_T4, m_nt4);
	DDX_Text(pDX, IDC_T3, m_nt3);
	DDX_Text(pDX, IDC_T2, m_nt2);
	DDX_Text(pDX, IDC_T10, m_nt10);
	DDX_Text(pDX, IDC_T1, m_nt1);
	DDX_Text(pDX, IDC_XH, m_xh);
	DDX_Text(pDX, IDC_XM, m_xm);
	DDX_Text(pDX, IDC_ZF, m_zf);
	DDX_Text(pDX, IDC_ZRS, m_zrs);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCjlr, CDialog)
	//{{AFX_MSG_MAP(CCjlr)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_MODIFY, OnModify)
	ON_BN_CLICKED(IDC_FIRST, OnFirst)
	ON_BN_CLICKED(IDC_LAST, OnLast)
	ON_BN_CLICKED(IDC_PREV, OnPrev)
	ON_BN_CLICKED(IDC_NEXT, OnNext)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCjlr message handlers

void CCjlr::OnOK() 
{
	// TODO: Add extra validation here
	CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
        pApp->m_pRecordset->Close();

	CDialog::OnOK();
}

void CCjlr::OnCancel() 
{
	// TODO: Add extra cleanup here
	CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
        pApp->m_pRecordset->Close();

	CDialog::OnCancel();
}

BOOL CCjlr::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here

	CString strSql;
	CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
	strSql="SELECT * FROM " + pApp->m_Sj.Cjb;
        AfxMessageBox(strSql);

	HRESULT hr = pApp->m_pRecordset->Open(strSql.AllocSysString(),
		pApp->m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
	if(!SUCCEEDED(hr))
	{  AfxMessageBox("打开成绩表出错!"); return FALSE; }

        AfxMessageBox("打开成绩表成功！");
        
        switch(pApp->m_Sj.Zts) {
           case 10: m_ct10.ShowWindow(SW_SHOW); m_s10.ShowWindow(SW_SHOW);
           case  9: m_ct9.ShowWindow(SW_SHOW); m_s9.ShowWindow(SW_SHOW);
           case  8: m_ct8.ShowWindow(SW_SHOW); m_s8.ShowWindow(SW_SHOW);
           case  7: m_ct7.ShowWindow(SW_SHOW); m_s7.ShowWindow(SW_SHOW);
           case  6: m_ct6.ShowWindow(SW_SHOW); m_s6.ShowWindow(SW_SHOW);
           case  5: m_ct5.ShowWindow(SW_SHOW); m_s5.ShowWindow(SW_SHOW);
           case  4: m_ct4.ShowWindow(SW_SHOW); m_s4.ShowWindow(SW_SHOW);
           case  3: m_ct3.ShowWindow(SW_SHOW); m_s3.ShowWindow(SW_SHOW);
           case  2: m_ct2.ShowWindow(SW_SHOW); m_s2.ShowWindow(SW_SHOW);
           case  1: m_ct1.ShowWindow(SW_SHOW); m_s1.ShowWindow(SW_SHOW);
	}
        Disprecord();

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CCjlr::OnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
        CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
	CString str;
	try {
	    pApp->m_pRecordset->AddNew();
            
            pApp->m_pRecordset->PutCollect("num",_variant_t(m_xh));
	    pApp->m_pRecordset->PutCollect("name",_variant_t(m_xm));
	    pApp->m_pRecordset->PutCollect("zf",_variant_t(m_zf));
	    switch(pApp->m_Sj.Zts)
	    {
	      case 10:  pApp->m_pRecordset->PutCollect("s10",_variant_t(m_nt10));
              case  9:  pApp->m_pRecordset->PutCollect("s9",_variant_t(m_nt9));
              case  8:  pApp->m_pRecordset->PutCollect("s8",_variant_t(m_nt8));
              case  7:  pApp->m_pRecordset->PutCollect("s7",_variant_t(m_nt7));
              case  6:  pApp->m_pRecordset->PutCollect("s6",_variant_t(m_nt6));
              case  5:  pApp->m_pRecordset->PutCollect("s5",_variant_t(m_nt5));
              case  4:  pApp->m_pRecordset->PutCollect("s4",_variant_t(m_nt4));
              case  3:  pApp->m_pRecordset->PutCollect("s3",_variant_t(m_nt3));
              case  2:  pApp->m_pRecordset->PutCollect("s2",_variant_t(m_nt2));
              case  1:  pApp->m_pRecordset->PutCollect("s1",_variant_t(m_nt1));
	    }

	    pApp->m_pRecordset->Update();
	}
	catch(_com_error *e)
	{
           AfxMessageBox(e->ErrorMessage());
	}

	Disprecord();
	return;
}

void CCjlr::OnDelete() 
{
	// TODO: Add your control notification handler code here
	CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
	try {
            pApp->m_pRecordset->Delete(adAffectCurrent);
            pApp->m_pRecordset->Update();
            pApp->m_pRecordset->MoveNext();
	    if(pApp->m_pRecordset->adoEOF)
		pApp->m_pRecordset->MoveLast();
	   // if(pApp->m_pRecordset->BOF) return ; 
        }
	catch(_com_error *e)
	{
           AfxMessageBox(e->ErrorMessage());
	}

        Disprecord();
	return;
}

void CCjlr::OnModify() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
        CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
	CString str;
	try {
            pApp->m_pRecordset->PutCollect("num",_variant_t(m_xh));
	    pApp->m_pRecordset->PutCollect("name",_variant_t(m_xm));
	    pApp->m_pRecordset->PutCollect("zf",_variant_t(m_zf));
	    switch(pApp->m_Sj.Zts)
	    {
	      case 10:  pApp->m_pRecordset->PutCollect("s10",_variant_t(m_nt10));
              case  9:  pApp->m_pRecordset->PutCollect("s9",_variant_t(m_nt9));
              case  8:  pApp->m_pRecordset->PutCollect("s8",_variant_t(m_nt8));
              case  7:  pApp->m_pRecordset->PutCollect("s7",_variant_t(m_nt7));
              case  6:  pApp->m_pRecordset->PutCollect("s6",_variant_t(m_nt6));
              case  5:  pApp->m_pRecordset->PutCollect("s5",_variant_t(m_nt5));
              case  4:  pApp->m_pRecordset->PutCollect("s4",_variant_t(m_nt4));
              case  3:  pApp->m_pRecordset->PutCollect("s3",_variant_t(m_nt3));
              case  2:  pApp->m_pRecordset->PutCollect("s2",_variant_t(m_nt2));
              case  1:  pApp->m_pRecordset->PutCollect("s1",_variant_t(m_nt1));
	    }

	    pApp->m_pRecordset->Update();
	}
	catch(_com_error *e)
	{
           AfxMessageBox(e->ErrorMessage());
	}

        Disprecord();
	return;
}

void CCjlr::OnFirst() 
{
	// TODO: Add your control notification handler code here
        CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();

	pApp->m_pRecordset->MoveFirst();
	Disprecord();      
}

void CCjlr::OnLast() 
{
	// TODO: Add your control notification handler code here
        CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
        
	pApp->m_pRecordset->MoveLast();
	Disprecord();  
}

void CCjlr::OnPrev() 
{
	// TODO: Add your control notification handler code here
        CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();

	pApp->m_pRecordset->MovePrevious();
	if (!pApp->m_pRecordset->BOF)
	{  
           pApp->m_pRecordset->MoveFirst();
	   Disprecord();  
	}
}

void CCjlr::OnNext() 
{
	// TODO: Add your control notification handler code here
        CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();

	pApp->m_pRecordset->MoveNext();
	if ( !pApp->m_pRecordset->adoEOF)
	{  
           pApp->m_pRecordset->MoveLast();
	   Disprecord();  
	}
}

void CCjlr::Disprecord()
{
        CSJFXApp* pApp = (CSJFXApp*)AfxGetApp();
	int zrs;
	CString str;
        zrs=pApp->m_pRecordset->RecordCount;
	m_zrs.Format("%d",zrs);
        if(zrs)
	{
	  m_xh=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("num"));
	  m_xm=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("name"));
          m_zf=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("zf"));

	  switch(pApp->m_Sj.Zts) {
            case 10: m_nt10=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s10"));
            case  9: m_nt9=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s9"));
            case  8: m_nt8=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s8"));
            case  7: m_nt7=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s7"));
            case  6: m_nt6=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s6"));
            case  5: m_nt5=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s5"));
            case  4: m_nt4=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s4"));
            case  3: m_nt3=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s3"));
            case  2: m_nt2=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s2"));
            case  1: m_nt1=(char*)(_bstr_t)pApp->m_pRecordset->GetCollect(_variant_t("s1"));
	  }
          m_modify.EnableWindow();
	  m_delete.EnableWindow();
	  m_first.EnableWindow();
	  m_last.EnableWindow();;
          m_prev.EnableWindow();
	  m_next.EnableWindow();
        }
	else 
        {
          m_xh="";
	  m_xm="";
	  m_zf="";
          switch(pApp->m_Sj.Zts) {
            case 10: m_nt10="";
            case  9: m_nt9="";
            case  8: m_nt8="";
            case  7: m_nt7="";
            case  6: m_nt6="";
            case  5: m_nt5="";
            case  4: m_nt4="";
            case  3: m_nt3="";
            case  2: m_nt2="";
            case  1: m_nt1="";
	  }
          m_modify.EnableWindow(FALSE);
	  m_delete.EnableWindow(FALSE);
	  m_first.EnableWindow(FALSE);
	  m_last.EnableWindow(FALSE);;
          m_prev.EnableWindow(FALSE);
	  m_next.EnableWindow(FALSE);	 
        }

	UpdateData(FALSE);
}