fee.cpp

来自「VC6.0环境下编写的一个交换机计费程序。」· C++ 代码 · 共 309 行

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

#include "stdafx.h"
#include "fee.h"

#include "MainFrm.h"
#include "feeDoc.h"
#include "feeView.h"
#include "feepub.h"

#include "loginDlg.h"


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




/////////////////////////////////////////////////////////////////////////////
// CFeeApp

BEGIN_MESSAGE_MAP(CFeeApp, CWinApp)
	//{{AFX_MSG_MAP(CFeeApp)
	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()

/////////////////////////////////////////////////////////////////////////////
// CFeeApp construction

CFeeApp::CFeeApp()
{
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CFeeApp object

CFeeApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CFeeApp initialization

BOOL CFeeApp::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

	//初始化com环境
	::CoInitialize(NULL);
	//创建连接对象和记录集对象
	HRESULT hr;
	try
	{
		hr = m_pjifeiConnection.CreateInstance("ADODB.Connection");//创建Connection对象
		if(SUCCEEDED(hr))
		{
			hr = m_pjifeiConnection->Open(
				"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\twdfee\\mdb\\jifei.mdb",
				"","",adModeUnknown);///连接数据库
			///上面一句中连接字串中的Provider是针对ACCESS2000环境的，
			//对于ACCESS97,需要改为:Provider=Microsoft.Jet.OLEDB.3.51
		}
	}
	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		errormessage.Format("fail to connect database!\r\nerror message:%s",e.ErrorMessage());
		AfxMessageBox(errormessage);///显示错误信息
	}
	m_pjifeiRecordset.CreateInstance(__uuidof(Recordset));

	try
	{
		hr = m_pjifei2Connection.CreateInstance("ADODB.Connection");//创建Connection对象
		if(SUCCEEDED(hr))
		{
			hr = m_pjifei2Connection->Open(
				"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\twdfee\\mdb\\jifei.mdb",
				"","",adModeUnknown);///连接数据库
			///上面一句中连接字串中的Provider是针对ACCESS2000环境的，
			//对于ACCESS97,需要改为:Provider=Microsoft.Jet.OLEDB.3.51
		}
	}
	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		errormessage.Format("fail to connect database !\r\n error message:%s",e.ErrorMessage());
		AfxMessageBox(errormessage);///显示错误信息
	}
	m_pjifei2Recordset.CreateInstance(__uuidof(Recordset));


	try
	{
		hr = m_pjifei3Connection.CreateInstance("ADODB.Connection");//创建Connection对象
		if(SUCCEEDED(hr))
		{
			hr = m_pjifei3Connection->Open(
				"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\twdfee\\mdb\\jifei.mdb",
				"","",adModeUnknown);///连接数据库
			///上面一句中连接字串中的Provider是针对ACCESS2000环境的，
			//对于ACCESS97,需要改为:Provider=Microsoft.Jet.OLEDB.3.51
		}
	}
	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		errormessage.Format("fail to connect database !\r\n error message:%s",e.ErrorMessage());
		AfxMessageBox(errormessage);///显示错误信息
	}
	m_pjifei3Recordset.CreateInstance(__uuidof(Recordset));


	try
	{
		hr = m_pspcConnection.CreateInstance("ADODB.Connection");//创建Connection对象
		if(SUCCEEDED(hr))
		{
			hr = m_pspcConnection->Open(
				"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\twdfee\\mdb\\spc.mdb",
				"","",adModeUnknown);///连接数据库
			///上面一句中连接字串中的Provider是针对ACCESS2000环境的，
			//对于ACCESS97,需要改为:Provider=Microsoft.Jet.OLEDB.3.51
		}
	}
	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		errormessage.Format("fail to connect database!\r\nerror message:%s",e.ErrorMessage());
		AfxMessageBox(errormessage);///显示错误信息
	}
	m_pspcRecordset.CreateInstance(__uuidof(Recordset));

	CloginDlg loginDlg;

	unsigned char flag,flagnum;
	int nResponse;
	HRESULT result;
	CString strSql;


	flag=0;
	flagnum=0;
	while(flag==0)
	{
		userLoginName="";
		userLoginPwd="";
		nResponse=loginDlg.DoModal();
		if (nResponse==IDOK)
		{
			//CJifeiApp* pApp=(CJifeiApp *)AfxGetApp();

			strSql.Format("select * from loginid where UserName = '%s' and UserPwd = '%s'"
				,userLoginName,userLoginPwd);
			/*
			result=pApp->m_pjifeiRecordset->Open(strSql.AllocSysString(),
				pApp->m_pjifeiConnection.GetInterfacePtr(),
				adOpenDynamic,adLockOptimistic,adCmdText);
				*/
			result=m_pjifeiRecordset->Open(strSql.AllocSysString(),
				m_pjifeiConnection.GetInterfacePtr(),
				adOpenDynamic,adLockOptimistic,adCmdText);
			if (!SUCCEEDED(result))
			{
				AfxMessageBox("can open loginid table");
			}
			if (!m_pjifeiRecordset->adoEOF)
			{
				userLoginPower=(char*)(_bstr_t)m_pjifeiRecordset->GetCollect(_variant_t("UserPower"));
				flag=1;	
			}
			else
			{
				flagnum++;
			}
			m_pjifeiRecordset->Close();

		}
		else
		{
			flag=2;
		}
		if (flagnum>=3)
		{
			flag=2;
		}
	}
	
	if (flag==2)
	{
		return FALSE;
	}


	// 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(CFeeDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CFeeView));
	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 CFeeApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CFeeApp message handlers