purchasecardlg.cpp

一个汽车销售系统(分期付款,车辆管理,客户管理)

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

#include "stdafx.h"
#include "carm.h"
#include "PurchaseCarDlg.h"
#include ".\purchasecardlg.h"


// CPurchaseCarDlg 对话框

IMPLEMENT_DYNAMIC(CPurchaseCarDlg, CDialog)
CPurchaseCarDlg::CPurchaseCarDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CPurchaseCarDlg::IDD, pParent)
	, m_carID(_T(""))
{
}

CPurchaseCarDlg::~CPurchaseCarDlg()
{
}

void CPurchaseCarDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_CBString(pDX, IDC_COMBO1, m_carID);
	DDX_Control(pDX, IDC_LIST1, m_Lcarinfo);
}


BEGIN_MESSAGE_MAP(CPurchaseCarDlg, CDialog)
	ON_CBN_DROPDOWN(IDC_COMBO1, OnCbnDropdownCombo1)
	ON_CBN_CLOSEUP(IDC_COMBO1, OnCbnCloseupCombo1)
END_MESSAGE_MAP()



// CPurchaseCarDlg 消息处理程序

void CPurchaseCarDlg::OnCbnDropdownCombo1()
{
	CComboBox *pCombo = (CComboBox *)GetDlgItem(IDC_COMBO1);
	if(pCombo->GetCount() != 0)
		return;
	pCombo->ResetContent();
	CString sql = "select * from 车 where 库存 = '1'";
	_RecordsetPtr pRst = g_ADOConn.GetRecordSet(_bstr_t(sql));

	while (!pRst -> adoEOF)
	{
		pCombo->AddString(STR(pRst->GetCollect("车编号")));
		pRst ->MoveNext();
	}
	pCombo->SelectString(-1,m_carID);
}

void CPurchaseCarDlg::OnCbnCloseupCombo1()
{
	CComboBox *pCombo = (CComboBox *)GetDlgItem(IDC_COMBO1);
	int num; 
	if((num = pCombo->GetCurSel()) == CB_ERR)
		return;
	pCombo->GetLBText(num,m_carID);

	CString sql = "select * from 车 where 车编号 = '";
	sql += m_carID;
	sql += "'";
	_RecordsetPtr pRst = g_ADOConn.GetRecordSet((_bstr_t)sql);
	long limit = pRst->GetFields()->Count;

	if(pRst->adoEOF)
	{
		::AfxMessageBox("未找到相符的项");
		return;
	}
	if(m_Lcarinfo.GetItemCount() != 0)
	{
		m_Lcarinfo.DeleteAllItems();
		for(long x = 0;x < 5;x++)
		{
			m_Lcarinfo.DeleteColumn(0);
		}
	}
			
		
	for (long x = 0; x < limit; x++)
	{
		m_Lcarinfo.InsertColumn(x,(char *) pRst->GetFields()->Item[x]->Name,LVCFMT_LEFT,100,-1);
	}		
	int i = 0;
	while(!pRst->adoEOF)
	{	
			
		m_Lcarinfo.InsertItem(i,"");
		for(long x = 0;x < limit;x++)
		{
			_variant_t var = pRst->GetCollect(_variant_t(long(x)));
			CString str = "";
			if(var.vt != VT_NULL)
				str = STR(var);
			m_Lcarinfo.SetItemText(i,x,str);
				
		}
		pRst->MoveNext();
		i++;
	}
}