quoteeditdlg.cpp

VC做的一个电脑报价管理系统,有源码和说明文档.

// QuoteEditDlg.cpp : implementation file
//

#include "stdafx.h"
#include "QuoteManage.h"
#include "QuoteEditDlg.h"
#include "DetailQuote.h"
#include "FittingInfo.h"
#include "ProviderInfo.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQuoteEditDlg dialog


CQuoteEditDlg::CQuoteEditDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQuoteEditDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQuoteEditDlg)
	m_provider = _T("");
	m_maintain = _T("");
	m_num = 0;
	m_Subtotal = 0.0;
	m_UnitPrice = 0.0;
	//}}AFX_DATA_INIT
}


void CQuoteEditDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQuoteEditDlg)
	DDX_Text(pDX, IDC_PROVIDER_EDIT, m_provider);
	DDX_Text(pDX, IDC_MAINTAIN_EDIT, m_maintain);
	DDX_Text(pDX, IDC_NUM_EDIT, m_num);
	DDX_Text(pDX, IDC_SUBTOTAL_EDIT, m_Subtotal);
	DDX_Text(pDX, IDC_UNIT_PRICE_EDIT, m_UnitPrice);
	DDX_Control(pDX, IDC_ADODC1, m_AdoType);
	DDX_Control(pDX, IDC_ADODC2, m_AdoMark);
	DDX_Control(pDX, IDC_ADODC3, m_AdoStd);
	DDX_Control(pDX, IDC_FIT_DATACOMBO, m_Std);
	DDX_Control(pDX, IDC_MARK_DATACOMBO, m_Mark);
	DDX_Control(pDX, IDC_TYPE_DATACOMBO, m_Type);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQuoteEditDlg, CDialog)
	//{{AFX_MSG_MAP(CQuoteEditDlg)
	ON_EN_CHANGE(IDC_NUM_EDIT, OnChangeNumEdit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQuoteEditDlg message handlers

BOOL CQuoteEditDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
 	if(cDId != "")
	{
		m_Type.SetText(cTypeName);
		m_Mark.SetText(cMark);
		m_Std.SetText(cStd);
		UpdateData(FALSE);
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
// 确定按钮
void CQuoteEditDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);

	// 有效性判断
	if(m_Type.GetText() == "")
	{
		MessageBox("请选择配件类型");
		return;
	}
	if(m_Mark.GetText() == "")
	{
		MessageBox("请选择品牌名");
		return;
	}
	if(m_Std.GetText() == "")
	{
		MessageBox("请选择型号规格");
		return;
	}
	if(m_num == 0)
	{
		MessageBox("请输入数量");
		return;
	}

	// 将用户输入的数据赋值到对象cur中，为更新数据库做准备
	CDetailQuote cur;
	cur.TId = atol(cTId);
	cur.FittingId = atol(m_Std.GetBoundText());
	cur.Num = m_num;
	cur.SubTotal = m_Subtotal;

	if (cDId == "")  //表示插入数据
	{
		if(cur.HaveFitting(cTId, m_Std.GetBoundText()) == 1)
		{
			MessageBox("已有此配件信息，请重新选择");
			return;
		}
		cur.SqlInsert();
	}
	else
		//根据cDId的值更新记录
		cur.SqlUpdate(cDId);
	
	CDialog::OnOK();
}

BEGIN_EVENTSINK_MAP(CQuoteEditDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CQuoteEditDlg)
	ON_EVENT(CQuoteEditDlg, IDC_FIT_DATACOMBO, -600 /* Click */, OnClickFitDatacombo, VTS_I2)
	ON_EVENT(CQuoteEditDlg, IDC_MARK_DATACOMBO, -600 /* Click */, OnClickMarkDatacombo, VTS_I2)
	ON_EVENT(CQuoteEditDlg, IDC_TYPE_DATACOMBO, -600 /* Click */, OnClickTypeDatacombo, VTS_I2)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CQuoteEditDlg::OnClickFitDatacombo(short Area) 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_Std.GetText() != "")
	{
		CFittingInfo cfit;
		cfit.GetInfo(m_Std.GetBoundText());
		m_maintain = cfit.Maintain ;
		m_UnitPrice = cfit.UnitPrice ;
		CString cProId;
		cProId.Format("%ld",cfit.ProviderId);
		CProviderInfo cpro;
		cpro.GetInfo(cProId);
		m_provider = cpro.Name  ;
		m_Subtotal = m_UnitPrice * m_num;
		UpdateData(FALSE);
	}
}

void CQuoteEditDlg::OnClickMarkDatacombo(short Area) 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_Mark.GetText() != "")
	{
		CString cSource ;
		cSource = "Select * From FittingInfo Where TypeId="+m_Type.GetBoundText()
			+ " And MarkId=" + m_Mark.GetBoundText();
		m_AdoStd.SetRecordSource(cSource);
		m_AdoStd.Refresh();
		m_Std.SetText("");
		m_provider = "";
		m_maintain = "";
		m_UnitPrice = 0;
		UpdateData(FALSE);
	}
}

void CQuoteEditDlg::OnClickTypeDatacombo(short Area) 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(m_Type.GetText() != "")
	{
		// 显示类型存在的品牌信息
		CString cSource ;
		cSource = "Select distinct t.TypeId,t.TypeName From Type t,FittingInfo f"
			" Where f.MarkId=t.TypeId And f.TypeId="+m_Type.GetBoundText();	
		//刷新ADO Data控件的记录源
		m_AdoMark.SetRecordSource(cSource);
		m_AdoMark.Refresh();
		cSource = "Select * From FittingInfo Where TypeId="+m_Type.GetBoundText();
		m_AdoStd.SetRecordSource(cSource);
		m_AdoStd.Refresh();
		m_Mark.SetText("");
		m_Std.SetText("");
		m_provider = "";
		m_maintain = "";
		m_UnitPrice = 0;
		UpdateData(FALSE);
	}
}

void CQuoteEditDlg::OnChangeNumEdit() 
{
	// TODO: If this is a RICHEDIT control, the control will not
	// send this notification unless you override the CDialog::OnInitDialog()
	// function and call CRichEditCtrl().SetEventMask()
	// with the ENM_CHANGE flag ORed into the mask.
	
	// TODO: Add your control notification handler code here

	UpdateData(TRUE);
	m_Subtotal = m_UnitPrice * m_num;
	UpdateData(FALSE);
}