adotestview.cpp

一个完整的教务管理系统。利用MFC开发

// AdoTestView.cpp : implementation of the CAdoTestView class
//

#include "stdafx.h"
#include "AdoTest.h"
#include  "DEL_NUM.h"
#include "AdoTestDoc.h"
#include "AdoTestView.h"
#include "mydia.h"
#include  "DELNAME.h"
#include "DiaSch_Sp.h"
#include "MODIFY.h"


#include"DiaA.h"
#include"SEARCH.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CAdoTestView

IMPLEMENT_DYNCREATE(CAdoTestView, CView)

BEGIN_MESSAGE_MAP(CAdoTestView, CView)
	//{{AFX_MSG_MAP(CAdoTestView)
	ON_WM_DESTROY()
	ON_COMMAND(ID_NEW, OnNew)
	ON_COMMAND(ID_INPUT, OnInput)
	ON_COMMAND(ID_DELETE, OnDelete)
	ON_COMMAND(ID_updata, Onupdata)
	ON_COMMAND(ID_NUM, OnNum)
	ON_COMMAND(ID_NAME, OnName)
	ON_COMMAND(ID_SEARCH, OnSearch)
	ON_COMMAND(ID_SEARCH_SP, OnSearchSp)
	ON_COMMAND(ID_MODIFY, OnModify)
	//}}AFX_MSG_MAP
	// Standard printing commands
	ON_COMMAND(ID_FILE_PRINT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_DIRECT, CView::OnFilePrint)
	ON_COMMAND(ID_FILE_PRINT_PREVIEW, CView::OnFilePrintPreview)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAdoTestView construction/destruction

CAdoTestView::CAdoTestView()
{
	sqlchoice=true;
	// TODO: add construction code here

}

CAdoTestView::~CAdoTestView()
{
}

BOOL CAdoTestView::PreCreateWindow(CREATESTRUCT& cs)
{
	// TODO: Modify the Window class or styles here by modifying
	//  the CREATESTRUCT cs

	return CView::PreCreateWindow(cs);
}

/////////////////////////////////////////////////////////////////////////////
// CAdoTestView drawing

void CAdoTestView::OnDraw(CDC* pDC)
{
  	CAdoTestDoc* pDoc = GetDocument();
	ASSERT_VALID(pDoc);
	// TODO: add draw code for native data here

	int i=0;
	CString a="";
	CString aa="55";
	CString  kk="";

	long b=0;


	if(sqlchoice)
		adomana.SQL="select * from student";

	adomana.OpenRecordSet();
	while(!adomana.m_recordset->adoEOF){
		a="";
		_variant_t value;
		value=adomana.m_recordset->GetCollect("id");
	    a+="id: ";
		a+=(char*)_bstr_t(value);
		kk=(char*)_bstr_t(value);
		b=atol(kk);//把字符串转换成整数

		
		value=adomana.m_recordset->GetCollect("name");		
		a+="    name: ";
		a+=(char*)_bstr_t(value);
		
        	value=adomana.m_recordset->GetCollect("sex");		
		a+="   性别: ";
		a+=(char*)_bstr_t(value);
	

		value=adomana.m_recordset->GetCollect("age");
		a+="   年龄: ";
		a+=(char*)_bstr_t(value);
	
		
		value=adomana.m_recordset->GetCollect("kind");
		a+="   职工分类: ";
		a+=(char*)_bstr_t(value);

        value=adomana.m_recordset->GetCollect("duty");
		a+="   职务: ";
		a+=(char*)_bstr_t(value);

		value=adomana.m_recordset->GetCollect("party");
		a+="   政治面貌: ";
		a+=(char*)_bstr_t(value);

		value=adomana.m_recordset->GetCollect("study");
		a+="   学历: ";
		a+=(char*)_bstr_t(value);
   
        value=adomana.m_recordset->GetCollect("college");
		a+="   学院: ";
		a+=(char*)_bstr_t(value);
		
	
		pDC->TextOut(50,30*(i++),a);


		adomana.m_recordset->MoveNext();

	}


	adomana.CloseRecordSet();
	
}

/////////////////////////////////////////////////////////////////////////////
// CAdoTestView printing

BOOL CAdoTestView::OnPreparePrinting(CPrintInfo* pInfo)
{
	// default preparation
	return DoPreparePrinting(pInfo);
}

void CAdoTestView::OnBeginPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add extra initialization before printing
}

void CAdoTestView::OnEndPrinting(CDC* /*pDC*/, CPrintInfo* /*pInfo*/)
{
	// TODO: add cleanup after printing
}

/////////////////////////////////////////////////////////////////////////////
// CAdoTestView diagnostics

#ifdef _DEBUG
void CAdoTestView::AssertValid() const
{
	
	CView::AssertValid();
}

void CAdoTestView::Dump(CDumpContext& dc) const
{
	CView::Dump(dc);
}

CAdoTestDoc* CAdoTestView::GetDocument() // non-debug version is inline
{
	ASSERT(m_pDocument->IsKindOf(RUNTIME_CLASS(CAdoTestDoc)));
	return (CAdoTestDoc*)m_pDocument;
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CAdoTestView message handlers


void CAdoTestView::OnDestroy() 
{
	CView::OnDestroy();	
	// TODO: Add your message handler code here
	
}


void CAdoTestView::OnNew() 
{
	
	
	// TODO: Add your command handler code here
}

void CAdoTestView::OnInput() 
{
	
	mydia dia;
	int i=1;

	CString ii="";
	ii.Format("%d",i);


	if(dia.DoModal()==IDOK){
		
		adomana.SQL="select * from student";	//1

		adomana.OpenRecordSet();    //2
		
		adomana.m_recordset->AddNew();	//3
		
		adomana.m_recordset->PutCollect("id",_variant_t(dia.m_id));   //4
		adomana.m_recordset->PutCollect("name",_variant_t(dia.m_name));
		adomana.m_recordset->PutCollect("sex",_variant_t(dia.m_sex));
		adomana.m_recordset->PutCollect("age",_variant_t(dia.m_age));
		adomana.m_recordset->PutCollect("kind",_variant_t(dia.m_kind));		
        adomana.m_recordset->PutCollect("duty",_variant_t(dia.m_duty));
		adomana.m_recordset->PutCollect("party",_variant_t(dia.m_party));
		adomana.m_recordset->PutCollect("study",_variant_t(dia.m_study));
		adomana.m_recordset->PutCollect("college",_variant_t(dia.m_college));
		adomana.m_recordset->Update();  //5


		adomana.CloseRecordSet();	 //2
	}	


	CAdoTestDoc* pDoc = GetDocument();
	pDoc->UpdateAllViews(NULL);
	// TODO: Add your command handler code here
	
}


void CAdoTestView::OnDelete() 
{ 

	
	adomana.SQL="select * from student where id='1'";  //1
	
	
	adomana.OpenRecordSet();  //2

	while(!adomana.m_recordset->adoEOF){  //3

		adomana.m_recordset->Delete(adAffectCurrent);  //4
		adomana.m_recordset->MoveNext();
	}
				
	adomana.CloseRecordSet();	//2	
	
	
	
	CAdoTestDoc* pDoc = GetDocument();
	pDoc->UpdateAllViews(NULL);

	// TODO: Add your command handler code here
	
}


void CAdoTestView::Onupdata() 
{


	//CString ii="124";

	
	adomana.SQL="select * from student ";	//1
	adomana.OpenRecordSet();    //2

	//adomana.m_recordset->PutCollect("id",_variant_t(ii));   //3



	adomana.m_recordset->Update();  //4

	adomana.CloseRecordSet();	 //2


	CAdoTestDoc* pDoc = GetDocument();


	pDoc->UpdateAllViews(NULL);
	// TODO: Add your command handler code here
	
}

void CAdoTestView::OnNum() 
{

    DEL_NUM a;
	if(a.DoModal()==IDOK){
	
		CString name;

		adomana.SQL.Format("select * from student where id='%s'",a.m_DELNUMBER);  
		
		adomana.OpenRecordSet(); 

	while(!adomana.m_recordset->adoEOF){  

		adomana.m_recordset->Delete(adAffectCurrent);  
		adomana.m_recordset->MoveNext();
	}
				
	adomana.CloseRecordSet();	
	}
	
	CAdoTestDoc* pDoc = GetDocument();
	pDoc->UpdateAllViews(NULL);
}

void CAdoTestView::OnName() 
{
	// TODO: Add your command handler code here
     DELNAME a;
	if(a.DoModal()==IDOK){
	
		CString name;

		adomana.SQL.Format("select * from student where name='%S'",a.m_NAME);  
		
		adomana.OpenRecordSet(); 

	while(!adomana.m_recordset->adoEOF){  

		adomana.m_recordset->Delete(adAffectCurrent);  
		adomana.m_recordset->MoveNext();
	}
				
	adomana.CloseRecordSet();	
	}
	
	CAdoTestDoc* pDoc = GetDocument();
	pDoc->UpdateAllViews(NULL);
	
}

void CAdoTestView::OnSearch() 
{
	// TODO: Add your command handler code here
	SEARCH a;
	a.DoModal();
}

void CAdoTestView::OnSearchSp() 
{

	DiaSch_Sp dia;
	if(dia.DoModal()==IDOK){	
		if(dia.m_name.IsEmpty())
			adomana.SQL.Format("select * from student");  //1
		else
			adomana.SQL.Format("select * from student where name='%s'",dia.m_name);  //1		
	}
	sqlchoice=false;

	CAdoTestDoc* pDoc = GetDocument();
	pDoc->UpdateAllViews(NULL);

	// TODO: Add your command handler code here
	
}

void CAdoTestView::OnModify() 
{
	sqlchoice=false;
	bool flag=false;
	// TODO: Add your command handler code here
    DiaSch_Sp dia;
	mydia  dias;


	if(dia.DoModal()==IDOK){	
		if(dia.m_name.IsEmpty())
			adomana.SQL.Format("select * from student");  //1
		else
		{
			adomana.SQL.Format("select * from student where name='%s'",dia.m_name);		
		}//1		
	}

	_variant_t value;
	adomana.OpenRecordSet(); 

	CString a="";
	if(!adomana.m_recordset->adoEOF){  		
		flag=true;

	
		value=adomana.m_recordset->GetCollect("ID");
		a=(char*)_bstr_t(value);
		dias.m_id=a;


	}
	adomana.CloseRecordSet();

	if(dias.DoModal()==IDOK){	
		
		adomana.OpenRecordSet();    //2		
		adomana.m_recordset->PutCollect("id",_variant_t(dias.m_id));   //4
		adomana.m_recordset->Update();  //4		
		adomana.CloseRecordSet(); 
	}
	sqlchoice=true;

	CAdoTestDoc* pDoc = GetDocument();
	pDoc->UpdateAllViews(NULL);

	// TODO: Add your command handler code here
	
}