modifycardlg.cpp

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

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

#include "stdafx.h"
#include "carm.h"
#include "ModifyCarDlg.h"
#include ".\modifycardlg.h"


// CModifyCarDlg 对话框

IMPLEMENT_DYNAMIC(CModifyCarDlg, CDialog)
CModifyCarDlg::CModifyCarDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CModifyCarDlg::IDD, pParent)
	, m_combosrh(_T(""))
	, m_brand(_T(""))
	, m_model(_T(""))
	, m_price(_T(""))
	, m_sales(_T(""))
{
}

CModifyCarDlg::~CModifyCarDlg()
{
}

void CModifyCarDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_CBString(pDX, IDC_COMBO1, m_combosrh);
	DDX_Text(pDX, IDC_EDIT2, m_brand);
	DDX_Text(pDX, IDC_EDIT3, m_model);
	DDX_Text(pDX, IDC_EDIT4, m_price);
	DDX_Text(pDX, IDC_EDIT6, m_sales);
}


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


// CModifyCarDlg 消息处理程序

void CModifyCarDlg::OnCbnDropdownCombo1()
{
	CComboBox *pCombo = (CComboBox *)GetDlgItem(IDC_COMBO1);
	if(pCombo->GetCount() != 0)
		return;
	pCombo->ResetContent();
	_RecordsetPtr pRst = g_ADOConn.GetTableSet("车");

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

}



void CModifyCarDlg::OnCbnCloseupCombo1()
{
	CComboBox *pCombo = (CComboBox *)GetDlgItem(IDC_COMBO1);
	int num; 
	if((num = pCombo->GetCurSel()) == CB_ERR)
		return;
	pCombo->GetLBText(num,m_combosrh);
	CString sql = "select * from 车 where 车编号 = '";
	sql += m_combosrh;
	sql += "'";
	_RecordsetPtr pRst = g_ADOConn.GetRecordSet((_bstr_t)sql);
	
	
	CEdit *pEdit = (CEdit *)GetDlgItem(IDC_EDIT2);
	UpdateData(false);
	if(pRst->GetCollect("品牌").vt != VT_NULL)
		pEdit->SetWindowText(STR(pRst->GetCollect("品牌")));	
	pEdit = (CEdit *)GetDlgItem(IDC_EDIT3);
	if(pRst->GetCollect("型号").vt != VT_NULL)
		pEdit->SetWindowText(STR(pRst->GetCollect("型号")));
	pEdit = (CEdit *)GetDlgItem(IDC_EDIT4);
	if(pRst->GetCollect("车价").vt != VT_NULL)
		pEdit->SetWindowText(STR(pRst->GetCollect("车价")));
	if(pRst->GetCollect("库存").vt != VT_NULL)
		if(pRst->GetCollect("库存") == _variant_t("1"))
		{
			pEdit = (CEdit *)GetDlgItem(IDC_EDIT6);
			pEdit->SetWindowText("未交易");
			
		}
		else if(pRst->GetCollect("库存") == _variant_t("0"))
		{
			pEdit = (CEdit *)GetDlgItem(IDC_EDIT6);
			pEdit->SetWindowText("已交易");
		}
		else 
		{
			pEdit = (CEdit *)GetDlgItem(IDC_EDIT6);
			pEdit->SetWindowText("");
		}
}