www.pudn.com > ODBC.rar > AutoStuMis.cpp

// AutoStuMis.cpp : Defines the class behaviors for the application. 
// 
 
#include "stdafx.h" 
#include "AutoStuMis.h" 
 
#include "MainFrm.h" 
#include "AutoStuMisDoc.h" 
#include "AutoStuMisView.h" 
#include "RstKeyID.h" 
 
#ifdef _DEBUG 
#define new DEBUG_NEW 
#undef THIS_FILE 
static char THIS_FILE[] = __FILE__; 
#endif 
 
///////////////////////////////////////////////////////////////////////////// 
// CAutoStuMisApp 
 
BEGIN_MESSAGE_MAP(CAutoStuMisApp, CWinApp) 
	//{{AFX_MSG_MAP(CAutoStuMisApp) 
	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 print setup command 
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup) 
END_MESSAGE_MAP() 
 
///////////////////////////////////////////////////////////////////////////// 
// CAutoStuMisApp construction 
 
CAutoStuMisApp::CAutoStuMisApp() 
{ 
	// TODO: add construction code here, 
	// Place all significant initialization in InitInstance 
} 
 
///////////////////////////////////////////////////////////////////////////// 
// The one and only CAutoStuMisApp object 
 
CAutoStuMisApp theApp; 
 
///////////////////////////////////////////////////////////////////////////// 
// CAutoStuMisApp initialization 
 
BOOL CAutoStuMisApp::InitInstance() 
{ 
	AfxEnableControlContainer(); 
 
	// 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(0);  // Load standard INI file options (including MRU) 
 
 
	//获取主程序所在路径,存在sPath中 
	GetModuleFileName(NULL,m_sAppPath.GetBufferSetLength(MAX_PATH+1),MAX_PATH); 
	m_sAppPath.ReleaseBuffer (); 
    int nPos; 
	nPos=m_sAppPath.ReverseFind ('\\'); 
	m_sAppPath=m_sAppPath.Left(nPos); 
	m_sSystemSetupFile = m_sAppPath + "\\HyConfig.dat"; 
	 
	try 
	{ 
		if(!m_db.IsOpen()) 
		{ 
			//读取使用的数据库类型 
			m_nDBType = atoi(GetStrFromMyIni("NetWork","DBDriver","0")); 
			 
			m_sDBServer = GetStrFromMyIni("NetWork","DBServer",m_sDBServer); 
			m_sDBN = GetStrFromMyIni("NetWork","DBN",m_sDBN); 
			m_sUID = GetStrFromMyIni("NetWork","UID",m_sUID); 
			m_sPassword = GetStrFromMyIni("NetWork","PSW",m_sPassword); 
 
			CString strCon;			 
			switch(m_nDBType) 
			{ 
			case 0://Access 
				strCon.Format("DSN=MS Access 97 Database;DBQ=%s;DefaultDir=%s;DriverId=281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;", 
					m_sDBN, 
					m_sAppPath); 
				m_nOpenType = dynaset; 
				m_chrDateSplit = '#'; 
				m_chrCommChar = '*'; 
				break; 
			case 1://SQL SERVER 7.0 
				strCon.Format("PROVIDER=MSDASQL;driver={SQL Server};server=%s;uid=sa;pwd=;database=%s;", 
					m_sDBServer, 
					m_sDBN); 
				m_nOpenType = dynamic; 
				m_chrDateSplit = '\''; 
				m_chrCommChar = '%'; 
				break; 
			case 2: 
				strCon.Format("DSN=MS Access Database;DBQ=%s;DefaultDir=%s;DriverId=281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;", 
					m_sDBN, 
					m_sAppPath); 
				m_nOpenType = dynaset; 
				m_chrDateSplit = '#'; 
				m_chrCommChar = '*'; 
				break; 
			default: 
				return false; 
			} 
			m_db.OpenEx(strCon,CDatabase::noOdbcDialog);				 
		} 
	} 
	catch(CException e) 
	{ 
		e.ReportError(); 
		e.Delete(); 
	} 
 
	// 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(CAutoStuMisDoc), 
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window 
		RUNTIME_CLASS(CAutoStuMisView)); 
	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_SHOWMAXIMIZED); 
	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 CAutoStuMisApp::OnAppAbout() 
{ 
	CAboutDlg aboutDlg; 
	aboutDlg.DoModal(); 
} 
 
///////////////////////////////////////////////////////////////////////////// 
// CAutoStuMisApp message handlers 
 
 
CString CAutoStuMisApp::GetStrFromMyIni(CString sAppName, CString sKey, CString sDefault) 
{ 
	char ss[MAX_PATH];  
	DWORD dwLen=GetPrivateProfileString(sAppName,sKey, 
		"", 
		ss, 
		MAX_PATH, 
		m_sSystemSetupFile); 
	CString sR(ss); 
	sR.TrimLeft(); 
	sR.TrimRight(); 
	return sR; 
 
} 
 
long CAutoStuMisApp::GetCurMaxKeyID(CString sTableName, BOOL bUpdateNow) 
{ 
	CRstKeyID rst; 
	long ID=1; 
	CString sql; 
	rst.m_strFilter.Format("F_TableName='%s'",sTableName); 
	rst.Open(); 
	if(rst.GetRecordCount()>0) 
	{ 
        ID = rst.m_F_CurMaxID; 
        if(bUpdateNow) 
		{ 
            rst.Edit(); 
            rst.m_F_CurMaxID = ID + 1; 
            rst.Update(); 
        } 
    } 
	else 
	{ 
        rst.AddNew(); 
        rst.m_F_TableName = sTableName; 
        rst.m_F_CurMaxID = ID + 1; 
        rst.Update(); 
    } 
    rst.Close(); 
	return ID; 
}