lxy.cpp

（1）学生信息的输入

// LXY.cpp : Defines the class behaviors for the application.
//

#include "stdafx.h"
#include "LXY.h"
#include "odbcinst.h"
#include "MainFrm.h"
#include "LXYDoc.h"
#include "LXYView.h"
#include "PASSDLG.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
 CString users,powers,pass;
/////////////////////////////////////////////////////////////////////////////
// CLXYApp

BEGIN_MESSAGE_MAP(CLXYApp, CWinApp)
	//{{AFX_MSG_MAP(CLXYApp)
	ON_COMMAND(ID_APP_ABOUT, OnAppAbout)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG_MAP
	// Standard file based document commands
	ON_COMMAND(ID_FILE_NEW, CWinApp::OnFileNew)
	ON_COMMAND(ID_FILE_OPEN, CWinApp::OnFileOpen)
	// Standard print setup command
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLXYApp construction

CLXYApp::CLXYApp()
{
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}
CLXYApp::~CLXYApp()		//程序结束，自动备分数据库
{		CString str,ConnectString;
		DeleteFile(filename);
		ConnectString="DSN=成绩管理;SERVER=127.0.0.1;DATABASE=master;UID=sa;PWD=";  
	    db.OpenEx(ConnectString,CDatabase::noOdbcDialog);
		str.Format("USE MASTER backup database XXX to Disk ='%s'",filename);
		db.ExecuteSQL(str);
      	db.IsOpen();
	    db.Close();
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CLXYApp object

CLXYApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CLXYApp initialization

BOOL CLXYApp::InitInstance()
{
	AfxEnableControlContainer();
		////////////////////////////////////////////////////////////////////////////////
		::AfxOleInit();
		////////////////////////////////////////////////////////////////////皮肤文件调用
	m_skin.LoadSkinFile("corona.smf"); 
    m_skin.SetDialogSkin("Dialog");
///////////////////////////////////////////////////////////////////////////
	BOOL bODBC=SQLConfigDataSource( 
		NULL, ODBC_ADD_DSN,"SQL Server",
		"DSN=成绩管理\0"
		"DATABASE=master\0"
		"SERVER=127.0.0.1\0");   
  if(!bODBC)       
	{   AfxMessageBox("创建数据源失败");
	    return false;
	}
///////////////////////////////////////////////////////////////////////////
    CString sqlstr,str,str1;
	CString ConnectString;
	CFileDialog filedlg(true,"txt",NULL,OFN_HIDEREADONLY,"文本文件(*.txt)|*.txt|");
	CString sPath;
	GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);
	sPath.ReleaseBuffer();
	int nPos;
	nPos=sPath.ReverseFind('\\');
	sPath=sPath.Left(nPos);
	filename=sPath+"\\fxy";
	ConnectString="DSN=成绩管理;SERVER=127.0.0.1;DATABASE=master;UID=sa;PWD=";  
	db.OpenEx(ConnectString,CDatabase::noOdbcDialog);
	str1.Format("USE MASTER  restore database xxx from Disk = '%s' with move 'XXX_data' to '%s\\xxx.mdf',  move   'XXX_log'   to '%s\\xxx_log.ldf' ",filename,sPath,sPath);
	db.ExecuteSQL(str1);
	db.IsOpen();
	db.Close();

///////////////////////////////////////////////////////////////////////////
 bODBC=SQLConfigDataSource( 
		NULL, ODBC_ADD_DSN,"SQL Server",
		"DSN=成绩管理\0"
		"DATABASE=xxx\0"
		"SERVER=127.0.0.1\0");   
  if(!bODBC)       
	{   AfxMessageBox("创建数据源失败");
	    return false;
	}
///////////////////////////////////////////////////////////////////////////

    pdb=new CDatabase;
	m_pSet=new PASSSet(pdb);

	PASSDLG mydlg;
	if(mydlg.DoModal()==IDOK)
		{CString str;
			str.Format("select *from pass where users='%s' and pass='%s'",mydlg.m_users,mydlg.m_pass);
			m_pSet->Open(AFX_DB_USE_DEFAULT_TYPE,str);
			 if(m_pSet->GetRecordCount()>0)
				{
					users=m_pSet->m_users;
				    powers=m_pSet->m_powers;
					pass=m_pSet->m_pass;
					powers.TrimRight();
				 
				 }
			 else  {AfxMessageBox("登陆失败！");return false;}

		}	
    else {AfxMessageBox("登陆失败！");return false;	}		


///////////////////////////////////////////////////////////////////////////
	// Standard initialization
	// If you are not using these features and wish to reduce the size
	//  of your final executable, you should remove from the following
	//  the specific initialization routines you do not need.

#ifdef _AFXDLL
	Enable3dControls();			// Call this when using MFC in a shared DLL
#else
	Enable3dControlsStatic();	// Call this when linking to MFC statically
#endif

	// Change the registry key under which our settings are stored.
	// TODO: You should modify this string to be something appropriate
	// such as the name of your company or organization.
	SetRegistryKey(_T("Local AppWizard-Generated Applications"));

	LoadStdProfileSettings();  // Load standard INI file options (including MRU)

	// Register the application's document templates.  Document templates
	//  serve as the connection between documents, frame windows and views.

	CSingleDocTemplate* pDocTemplate;
	pDocTemplate = new CSingleDocTemplate(
		IDR_MAINFRAME,
		RUNTIME_CLASS(CLXYDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CLXYView));
	AddDocTemplate(pDocTemplate);

	// Parse command line for standard shell commands, DDE, file open
	CCommandLineInfo cmdInfo;
	ParseCommandLine(cmdInfo);

	// Dispatch commands specified on the command line
	if (!ProcessShellCommand(cmdInfo))
		return FALSE;

	// The one and only window has been initialized, so show and update it.
	m_pMainWnd->ShowWindow(SW_SHOW);
	m_pMainWnd->UpdateWindow();


	return TRUE;
}


/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
		// No message handlers
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

// App command to run the dialog
void CLXYApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CLXYApp message handlers