quotemandlg.cpp

这是一个功能相对完善的电脑报价管理系统 的一个例子

// QuoteManDlg.cpp : implementation file
//

#include "stdafx.h"
#include "QuoteManage.h"
#include "QuoteManDlg.h"
#include "QuoteEditDlg.h"
#include "DetailQuote.h"
#include "TotalQuote.h"
#include "RecommendInfo.h"
#include "COMDEF.H"
#include "Columns.h"
#include "Column.h"
#include "_Recordset.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQuoteManDlg dialog

extern CUserInfo curUser;

CQuoteManDlg::CQuoteManDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQuoteManDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQuoteManDlg)
	m_tel = _T("");
	m_num = _T("");
	m_Id = _T("");
	m_price = _T("");
	m_FitTime = _T("");
	m_user = _T("");
	m_customer = _T("");
	//}}AFX_DATA_INIT
}


void CQuoteManDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQuoteManDlg)
	DDX_Control(pDX, IDC_TYPE_COMBO, m_type);
	DDX_Control(pDX, IDC_DATAGRID1, m_Datagrid);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Text(pDX, IDC_TEL_STATIC, m_tel);
	DDX_Text(pDX, IDC_NUM_STATIC, m_num);
	DDX_Text(pDX, IDC_ID_STATIC, m_Id);
	DDX_Text(pDX, IDC_PRICE_STATIC, m_price);
	DDX_Text(pDX, IDC_FIT_TIME_STATIC, m_FitTime);
	DDX_Text(pDX, IDC_USER_STATIC, m_user);
	DDX_Text(pDX, IDC_CUSTOMER_STATIC, m_customer);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQuoteManDlg, CDialog)
	//{{AFX_MSG_MAP(CQuoteManDlg)
	ON_BN_CLICKED(IDC_ADD_BUTTON, OnAddButton)
	ON_BN_CLICKED(IDC_MODI_BUTTON, OnModiButton)
	ON_BN_CLICKED(IDC_DEL_BUTTON, OnDelButton)
	ON_BN_CLICKED(IDC_RECOMMEND_BUTTON, OnRecommendButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQuoteManDlg message handlers

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

	// TODO: Add extra initialization here

	// 初始化信息
	m_type.SetCurSel(0);
	if(IsSubmit)
	{
		GetDlgItem(IDC_TYPE_COMBO)->EnableWindow(FALSE);
		GetDlgItem(IDC_RECOMMEND_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_ADD_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_MODI_BUTTON)->EnableWindow(FALSE);
		GetDlgItem(IDC_DEL_BUTTON)->EnableWindow(FALSE);
	}
	RefreshData();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CQuoteManDlg::RefreshData()
{
	UpdateData(TRUE);
	
	// 设置Select语句
	CString cSource ;
	cSource = "SELECT d.DId,d.TId,t.TypeName AS 配件类型,t1.TypeName AS 品牌名, "
		" f.Std AS 型号规格, f.UnitPrice AS 单价,f.Maintain AS 保修期, p.Name AS 供应商,"
		" d.Num AS 数量, d.SubTotal AS 小计"
		" FROM FittingInfo f, DetailQuote d, Type t,Type t1, ProviderInfo p "
		" WHERE d.FittingId = f.FittingId AND f.TypeId = t.TypeId And f.MarkId=t1.TypeId"
		" AND f.ProviderId = p.ProviderId AND d.TId = " + m_Id;
	
	//刷新ADO Data控件的记录源
	m_Adodc.SetRecordSource(cSource);
	m_Adodc.Refresh();

	//设置列宽度
	_variant_t vIndex;
	vIndex = long(0);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(1);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	vIndex = long(2);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(3);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(4);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(60);
	vIndex = long(5);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(6);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(7);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
	vIndex = long(8);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
	vIndex = long(9);
	m_Datagrid.GetColumns().GetItem(vIndex).SetWidth(50);
}

// 添加按钮
void CQuoteManDlg::OnAddButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);

	//初始化变量
	CQuoteEditDlg dlg;
	dlg.cTId = m_Id;
	dlg.m_UnitPrice = 0;
	dlg.m_num = 1;
	dlg.m_Subtotal = 0;

	// 返回
	if(dlg.DoModal() == IDOK)
	{
		// 设置其他信息
		CDetailQuote det;
		m_num.Format("%d", det.GetNum(m_Id));
		m_price.Format("%.2f", det.GetTotal(m_Id));
		UpdateData(FALSE);
		// 刷新
		RefreshData();
	}
}

// 修改按钮
void CQuoteManDlg::OnModiButton() 
{
	// TODO: Add your control notification handler code here
	if (m_Adodc.GetRecordset().GetEof()) 
	{
		MessageBox("请选择要修改的记录");
		return;
	}
	
	// 设置QuoteEditDlg对话框中的变量
	CQuoteEditDlg dlg;
	dlg.cDId = m_Datagrid.GetItem(0);
	dlg.cTId = m_Datagrid.GetItem(1);
	dlg.cTypeName = m_Datagrid.GetItem(2);
	dlg.cMark = m_Datagrid.GetItem(3);
	dlg.cStd = m_Datagrid.GetItem(4);
	dlg.m_UnitPrice = atof(m_Datagrid.GetItem(5));
	dlg.m_maintain = m_Datagrid.GetItem(6);
	dlg.m_provider = m_Datagrid.GetItem(7);
	dlg.m_num = atoi(m_Datagrid.GetItem(8));
	dlg.m_Subtotal = atof(m_Datagrid.GetItem(9));

	// 打开QuoteEditDlg对话框
	if (dlg.DoModal() == IDOK)
	{
		// 设置其他信息
		CDetailQuote det;
		m_num.Format("%d", det.GetNum(cTId));
		m_price.Format("%.2f", det.GetTotal(cTId));
		UpdateData(FALSE);
		// 刷新
		RefreshData();
	}

}

// 删除按钮
void CQuoteManDlg::OnDelButton()
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if (m_Adodc.GetRecordset().GetEof())
	{
		MessageBox("请选择要删除的记录!");
		return;
	}
	if (MessageBox("是否删除当前记录？","请确认", MB_YESNO + MB_ICONQUESTION) == IDYES)
	{
		// 删除
		CDetailQuote cur;
		cur.SqlDelete(m_Datagrid.GetItem(0));
		// 更新其他信息
		m_num.Format("%d", cur.GetNum(m_Id));
		m_price.Format("%.2f", cur.GetTotal(m_Id));
		UpdateData(FALSE);
		// 刷新
		RefreshData();
	}
}
// 推荐配置
void CQuoteManDlg::OnRecommendButton()
{
	// TODO: Add your control notification handler code here
	//判断是否存在此推荐配置信息
	UpdateData(TRUE);
	CString cFlag;
	cFlag.Format("%d",m_type.GetCurSel());
	CRecommendInfo cre;
	if(cre.HaveRecommend(cFlag)==0)
	{
		MessageBox("不存在此类型的推荐配置信息");
		return;
	}
	if((MessageBox("当加载推荐信息时，原选中配置将会丢失\n是否继续？","请确认", MB_YESNO + MB_ICONQUESTION) == IDYES))
	{
		CDetailQuote det;
		// 删除DetailQuote表中的数据
		if(!(m_Adodc.GetRecordset().GetEof()))		
			det.SqlDelAll(cTId);	// 删除此装机单下所有记录

		// 向DetailQuote表中插入数据
		det.TId = atol(m_Id);
		cre.LoadRecommend(cFlag);  // 载入此推荐类型的配件信息
		for(int i=0; i<cre.a_RecommendId.GetSize(); i++)
		{
			det.FittingId = atol(cre.a_FittingId.GetAt(i));
			det.Num = atoi(cre.a_Num.GetAt(i));
			det.SubTotal = atof(cre.a_SubTotal.GetAt(i));
			det.SqlInsert(); // 将推荐配置的配件信息插入明细表
			
			// 更新数量与总价
			m_num.Format("%d", det.GetNum(m_Id));
			m_price.Format("%.2f", det.GetTotal(m_Id));
			UpdateData(FALSE);
		}
		// 刷新DataGrid列表
		RefreshData();
	}
}