reg.cpp

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

// Reg.cpp : implementation file
//

#include "stdafx.h"
#include "Toolmangne.h"
#include "Reg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReg dialog

extern CString        UserId;
extern CToolmangneApp theApp;
CReg::CReg(CWnd* pParent /*=NULL*/)
	: CDialog(CReg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReg)
	m_style = _T("");
	m_name = _T("");
	m_pass = _T("");
	m_addr = _T("");
	m_tell = _T("");
	m_info = _T("");
	flag = false;
	m_id = _T("");
	//}}AFX_DATA_INIT
}


void CReg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReg)
	DDX_CBString(pDX, IDC_COMBO1, m_style);
	DDX_Text(pDX, IDC_EDIT1, m_name);
	DDX_Text(pDX, IDC_EDIT2, m_pass);
	DDX_Text(pDX, IDC_EDIT3, m_addr);
	DDX_Text(pDX, IDC_EDIT4, m_tell);
	DDX_Text(pDX, IDC_EDIT5, m_info);
	DDX_Text(pDX, IDC_EDIT6, m_id);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReg, CDialog)
	//{{AFX_MSG_MAP(CReg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReg message handlers

void CReg::OnOK() 
{
	// TODO: Add extra validation here
	//CDialog::OnOK();
	init();
	if(flag)
	 AfxMessageBox("确认成功");
}

void CReg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	if(flag)
	{	
	 UpdateData();
	 CString m_table;
	if(m_style =="" ||  m_name =="" || m_pass == "" || m_id =="")
	{
		AfxMessageBox("请先选择注册类型，或者添完整注册信息");
		flag = false;
		return ;
	}
	CString sql;
	if(m_style == "供应商")
	{
		m_table = "Provider";
		sql = "insert into "+m_table+" values('"+m_id+"','"+m_name+"','"+m_pass+"','"+m_addr+"','"+m_tell+"','"+m_info+"')";
	}
	else
	{
		m_table = "Customer";
		sql = "insert into "+m_table+" values('"+m_id+"','"+m_name+"','"+m_pass+"','"+m_addr+"','"+m_tell+"')";
	}
	 _RecordsetPtr	m_pRecordset;	 
	 m_pRecordset.CreateInstance(__uuidof(Recordset));
	 try
	 {
		 m_pRecordset->Open(_variant_t(sql),                // 查询DemoTable表中所有字段
			 theApp.m_pConnection.GetInterfacePtr(),	  // 获取库接库的IDispatch指针
			 adOpenDynamic,
			 adLockOptimistic,
			 adCmdText);
	 
	 }
	 catch(...)
	 {
		 AfxMessageBox("注册失败");
		 return ;
	 }
	 AfxMessageBox("注册成功");
		flag = false;
	}
	else
	{
		AfxMessageBox("请先确认数据");
	}
}

void CReg::init()
{
	UpdateData();
	CString m_table;
	if(m_style =="" ||  m_name =="" || m_pass == "" || m_id =="")
	{
		AfxMessageBox("请先选择注册类型，或者添完整注册信息");
		flag = false;
		return ;
	}
	if(m_style == "供应商")
	{
		m_table = "Provider";
	}
	else
	{
		m_table = "Customer";
	}
	CString sql = "select * from "+m_table+" where ID ="+m_id;
	// TODO: Add extra validation here
	_RecordsetPtr	m_pRecordset;
	 m_pRecordset.CreateInstance(__uuidof(Recordset));
	 try
	 {
		 m_pRecordset->Open(_variant_t(sql),                // 查询DemoTable表中所有字段
			 theApp.m_pConnection.GetInterfacePtr(),	  // 获取库接库的IDispatch指针
			 adOpenDynamic,
			 adLockOptimistic,
			 adCmdText);
	 
	 _variant_t var;
	 if(!m_pRecordset->BOF)
		 m_pRecordset->MoveFirst();
	 else
	 {
		 //AfxMessageBox("没有你查找的数据");
		 flag = true;
		 return ;
	 }			
	 // 读入库中各字段并加入列表框中
	 while(!m_pRecordset->adoEOF)
	 {
		 //
		 m_pRecordset->MoveNext();
		 flag = false;
	 }
	 }
	 catch(_com_error *e)
	 {
		 AfxMessageBox(e->ErrorMessage());
	 }   	
	 AfxMessageBox("请重新选择注册用户名");
}