addrecord.cpp

实现电脑销售系统实现电脑销售管理系统分多个部门

// AddRecord.cpp : 实现文件
//

#include "stdafx.h"
#include "ComSales.h"
#include "AddRecord.h"
#include "ComSales.h"

// CAddRecord 对话框

IMPLEMENT_DYNAMIC(CAddRecord, CDialog)

CAddRecord::CAddRecord(CWnd* pParent /*=NULL*/)
	: CDialog(CAddRecord::IDD, pParent)
	, m_strTime(_T(""))
	, m_strComId(_T(""))
	, m_strPrice(_T(""))
	, m_strNum(_T(""))
{

}

CAddRecord::~CAddRecord()
{
}

void CAddRecord::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_TIME_ADD, m_strTime);
	DDX_Text(pDX, IDC_COMID_ADD, m_strComId);
	DDX_Text(pDX, IDC_PRICE_ADD, m_strPrice);
	DDX_Text(pDX,IDC_NUM_ADD , m_strNum);
}


BEGIN_MESSAGE_MAP(CAddRecord, CDialog)
	ON_BN_CLICKED(ID_ADD_ADD, &CAddRecord::OnBnClickedAddAdd)
END_MESSAGE_MAP()


// CAddRecord 消息处理程序

BOOL CAddRecord::OnInitDialog()
{
	CDialog::OnInitDialog();

	// TODO:  在此添加额外的初始化
	CTime time = CTime::GetCurrentTime();
	m_strTime = time.Format("%Y-%m-%d");
	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}

void CAddRecord::OnBnClickedAddAdd()
{
	UpdateData();
	 if(m_strTime.Trim().IsEmpty() ||m_strComId.Trim().IsEmpty() ||
		 m_strPrice.Trim().IsEmpty() || m_strNum.Trim().IsEmpty())
	 {
		 MessageBox("必须填写所有内容!");
		 return;
	 }
	CString str;
// 	str.Format(" insert into sales (computerID  ,salesDATE  ,perPrice , num) \
// 			   values ('%s' , '%s' ,'%s' ,'%s' ) "  , m_strComId ,m_strTime  ,m_strPrice , m_strNum);
 	CComSalesApp* app =(CComSalesApp*) AfxGetApp();
// 	app->m_pConnection.Execute(str , NULL , adCmdText);
	 _RecordsetPtr rs;
	 rs.CreateInstance("ADODB.Recordset");		
	str.Format("select * from computer where computerID = '%s' " , m_strComId );
	rs->Open((_variant_t)str,
		_variant_t((IDispatch *)app->m_pConnection,true),
		adOpenStatic,
		adLockOptimistic,
		adCmdText);			
	
	if (rs->adoEOF)
	{
		MessageBox(_T("电脑的编号不存在，请重新输入!"));
		return;
	}

	str.Format("select * from sales " );
	m_pRecordset.CreateInstance("ADODB.Recordset");		

	m_pRecordset->Open((_variant_t)str,
		_variant_t((IDispatch *)app->m_pConnection,true),
		adOpenStatic,
		adLockOptimistic,
		adCmdText);			

	m_pRecordset->AddNew();
	m_pRecordset->Fields->GetItem("computerID")->PutValue((_variant_t)(m_strComId));
	m_pRecordset->Fields->GetItem("salesDATE")->PutValue((_variant_t)(m_strTime));
	m_pRecordset->Fields->GetItem("perPrice")->PutValue(_variant_t(m_strPrice));
	m_pRecordset->Fields->GetItem("num")->PutValue(_variant_t(m_strNum));

	m_pRecordset->Update();
}

bool CAddRecord::InitADO()
{
// 	::CoInitialize(NULL);
// 	HRESULT hr;
// 		//m_pConnection.CreateInstance("ADODB.Connection");
// 		try
// 		{
// 			hr = m_pConnection.CreateInstance("ADODB.Connection");//注释在书上4.2.5节
// 			if(SUCCEEDED(hr))
// 			{
// 				CHAR HD[]="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=computerSales.mdb;Persist security info=False";
// 				hr = m_pConnection->Open(HD,"","",adModeUnknown);
// 			}
// 		}
// 		catch(_com_error e)///捕捉异常
// 		{
// 			CString errormessage;
// 			errormessage.Format("连接数据库失败!\r\n错误信息:%s",e.ErrorMessage());
// 			AfxMessageBox(errormessage);///显示错误信息
// 			return false;
// 		}
	return true;
	
}