toolmangne.cpp

零件交易系统 零件交易中心管理系统主要提供顾客和供应商之间完成零件交易的功能

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

#include "stdafx.h"
#include "Toolmangne.h"
#include "ToolmangneDlg.h"
#include "UserLogin.h"

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

/////////////////////////////////////////////////////////////////////////////
// CToolmangneApp

struct LoginStyle
{
	CString style;
	CString     id;
};

BEGIN_MESSAGE_MAP(CToolmangneApp, CWinApp)
	//{{AFX_MSG_MAP(CToolmangneApp)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG
	ON_COMMAND(ID_HELP, CWinApp::OnHelp)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CToolmangneApp construction

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

/////////////////////////////////////////////////////////////////////////////
// The one and only CToolmangneApp object

CToolmangneApp theApp;
CString        Login;
CString        UserId;
/////////////////////////////////////////////////////////////////////////////
// CToolmangneApp initialization

BOOL CToolmangneApp::InitInstance()
{
	
	int flag = 0;
	if(!init()){
		return false;
	}
	_RecordsetPtr	m_pRecordset;
	m_pRecordset.CreateInstance(__uuidof(Recordset));
	CUserLogin UserDialog;
	if(UserDialog.DoModal()==IDOK)
	{
		//Login.style = UserDialog.m_style;
		if( UserDialog.m_style == "交易员")
		{
			try
			{
				m_pRecordset->Open("SELECT * From Admin ",                // 查询DemoTable表中所有字段
					m_pConnection.GetInterfacePtr(),	  // 获取库接库的IDispatch指针
					adOpenDynamic,
					adLockOptimistic,
					adCmdText);
			}
			catch(_com_error *e)
			{
				AfxMessageBox(e->ErrorMessage());
			}
		}
		else if(UserDialog.m_style == "供应商")
		{
			try
			{
				m_pRecordset->Open("SELECT * From Provider ",              
					m_pConnection.GetInterfacePtr(),	  // 获取库接库的IDispatch指针
					adOpenDynamic,
					adLockOptimistic,
					adCmdText);
			}
			catch(_com_error *e)
			{
				AfxMessageBox(e->ErrorMessage());
			}   
		}
		else if(UserDialog.m_style == "顾客")
		{
			try
			{
				m_pRecordset->Open("SELECT * From Customer ",       
					m_pConnection.GetInterfacePtr(),	  // 获取库接库的IDispatch指针
					adOpenDynamic,
					adLockOptimistic,
					adCmdText);
			}
			catch(_com_error *e)
			{
				AfxMessageBox(e->ErrorMessage());
			}   
		}
		CString user,pass,style;
		user = UserDialog.m_user;
		pass = UserDialog.m_password;
		style= UserDialog.m_style; 
		Login = style;
		if(style == "交易员")
		{
			try
			{
				CString strName,strPass;
				_variant_t var;
				if(!m_pRecordset->BOF)
					m_pRecordset->MoveFirst();
				else
				{
					AfxMessageBox("登陆失败");
					return false;
				}			
				// 读入库中各字段并加入列表框中
				while(!m_pRecordset->adoEOF)
				{
					var = m_pRecordset->GetCollect("Name");
					if(var.vt != VT_NULL)
						strName = (LPCSTR)_bstr_t(var);
					var = m_pRecordset->GetCollect("PassWord");
					if(var.vt != VT_NULL)
						strPass = (LPCSTR)_bstr_t(var);
					if(user == strName && strPass ==pass )
					{
						AfxMessageBox("登陆成功");
						flag = 1;
						goto loop;
						//break;
					}	
					m_pRecordset->MoveNext();
				}
			}
			catch(_com_error *e)
			{
				AfxMessageBox(e->ErrorMessage());
			}   	
		}	
		else if(style != "")
		{
			try
			{
				CString strName,strPass;
				_variant_t var;
				if(!m_pRecordset->BOF)
					m_pRecordset->MoveFirst();
				else
				{
					AfxMessageBox("登陆失败");
					return false;
				}			
				// 读入库中各字段并加入列表框中
				while(!m_pRecordset->adoEOF)
				{
					var = m_pRecordset->GetCollect("ID");
					if(var.vt != VT_NULL)
						UserId= (LPCSTR)_bstr_t(var);

					var = m_pRecordset->GetCollect("Name");
					if(var.vt != VT_NULL)
						strName = (LPCSTR)_bstr_t(var);
					var = m_pRecordset->GetCollect("PassWord");
					if(var.vt != VT_NULL)
						strPass = (LPCSTR)_bstr_t(var);
					if(user ==UserId && strPass ==pass )
					{
						AfxMessageBox("登陆成功");
						flag = 1;
						goto loop;
						//break;
					}	
					m_pRecordset->MoveNext();
				}
			}
			catch(_com_error *e)
			{
				AfxMessageBox(e->ErrorMessage());
			}   	
		}	
		if(!flag)
		{
			AfxMessageBox("登陆失败");
			return false;
		}
	//	return true;
	}
	else
		return  false;

loop:	
	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

	CToolmangneDlg dlg;
	m_pMainWnd = &dlg;
	int nResponse = dlg.DoModal();
	if (nResponse == IDOK)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with OK
	}
	else if (nResponse == IDCANCEL)
	{
		// TODO: Place code here to handle when the dialog is
		//  dismissed with Cancel
	}

	// Since the dialog has been closed, return FALSE so that we exit the
	//  application, rather than start the application's message pump.
	return FALSE;
}

int CToolmangneApp::ExitInstance()
{
	// 关闭ADO连接状态
	if(m_pConnection->State)
		m_pConnection->Close();
	m_pConnection= NULL;

	return CWinApp::ExitInstance();
}

bool CToolmangneApp::init()
{
	// 设置对话框背景和文本颜色
	//SetDialogBkColor(RGB(117,73,190),RGB(3,212,85));
	//SetDialogBkColor(RGB(205,205,205),RGB(100,0,0));
	//SetDialogBkColor(RGB(72,83,183),RGB(13,0,3));

	SetDialogBkColor(RGB(160,180,220),RGB(0,0,0));

	// ------------------------------------------------------------------------------------------------
	// 初始化COM,创建ADO连接等操作
	CoInitialize(NULL);
	m_pConnection.CreateInstance(__uuidof(Connection));

	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	// 因为它有时会经常出现一些想不到的错误。jingzhou xu
	try                 
	{	
		// 打开本地Access库Demo.mdb
		m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=LJBus.mdb","","",adModeUnknown);
		
	}
	catch(_com_error e)
	{
		AfxMessageBox("数据库连接失败，确认数据库LJBus.mdb是否在当前路径下!");
		return FALSE;
	}
	//m_pRecordset.CreateInstance(__uuidof(Recordset));
	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	// 因为它有时会经常出现一些意想不到的错误。jingzhou xu
	return TRUE;
}