assetseditdlg.cpp

固定资产管理系统,VC++做的,很有参考价值,源码也说明文档都有.

// AssetsEditDlg.cpp : implementation file
//

#include "stdafx.h"
#include "AssetsMan.h"
#include "AssetsEditDlg.h"
#include "Assets.h"

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

/////////////////////////////////////////////////////////////////////////////
// CAssetsEditDlg dialog


CAssetsEditDlg::CAssetsEditDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAssetsEditDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAssetsEditDlg)
	m_Aid = _T("");
	m_Aname = _T("");
	m_Model = _T("");
	m_Producer = _T("");
	m_RepPerson = _T("");
	m_UseYear = 0;
	m_OrgPrice = 0.0f;
	m_Ratio = 0.0f;
	m_PostDate = _T("");
	m_UseDate = COleDateTime::GetCurrentTime();
	m_Status = _T("");
	//}}AFX_DATA_INIT
}


void CAssetsEditDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAssetsEditDlg)
	DDX_Control(pDX, IDC_ADDWAY_COMBO, m_AddWay);
	DDX_Control(pDX, IDC_ADODC1, m_adodc1);
	DDX_Text(pDX, IDC_AID_EDIT, m_Aid);
	DDX_Text(pDX, IDC_ANAME_EDIT, m_Aname);
	DDX_Control(pDX, IDC_TYPE_DATACOMBO, m_Type);
	DDX_Text(pDX, IDC_MODEL_EDIT, m_Model);
	DDX_Text(pDX, IDC_PRODUCER_EDIT, m_Producer);
	DDX_Text(pDX, IDC_USEYEAR_EDIT, m_UseYear);
	DDX_Text(pDX, IDC_ORGPRICE_EDIT, m_OrgPrice);
	DDX_Text(pDX, IDC_RATIO_EDIT, m_Ratio);
	DDX_Text(pDX, IDC_POSTDATE_STATIC, m_PostDate);
	DDX_DateTimeCtrl(pDX, IDC_USEDATE, m_UseDate);
	DDX_Text(pDX, IDC_STATUS_EDIT, m_Status);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAssetsEditDlg, CDialog)
	//{{AFX_MSG_MAP(CAssetsEditDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAssetsEditDlg message handlers

BOOL CAssetsEditDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	if(cAid == "")
	{
		// 设置添加时间和使用时间为当前日期
		CTime t = CTime::GetCurrentTime();
		CString cDate;
		cDate.Format(_T("%04d-%02d-%02d"),t.GetYear(),t.GetMonth(),t.GetDay());
		m_PostDate = cDate;
		// 日期设置
		m_UseDate.SetDate(t.GetYear(),t.GetMonth(),t.GetDay());		
		// 设置下拉框默认值为第一个值
		m_AddWay.SetCurSel(0);
	}
	else
	{
		// 给Combo box赋值，状态和增加方式
		CString cItem;
		cItem = "";
		for(int i = 0; i < m_AddWay.GetCount(); i++)
		{ 
			m_AddWay.GetLBText(i,cItem);
			if(cItem == strAddWay)
			{
				m_AddWay.SetCurSel(i);
				break;
			}
		}
		// 使用时间变量赋值,CString--->COleDateTime
		COleVariant vtime(strUseDate);
		vtime.ChangeType(VT_DATE);

		COleDateTime time4(vtime);
		m_UseDate.SetDate(time4.GetYear(),time4.GetMonth(),time4.GetDay());

		// DataCombo类型控件赋值
		m_Type.SetBoundText(strTypeId);
	}
	UpdateData(FALSE);	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CAssetsEditDlg::OnOK() 
{
	CString cDate,cAddWay,cStatus;
	// 取得对话框数据
	UpdateData(TRUE);
	
	if (m_Aid == "")
	{
		MessageBox("请输入固定资产编号");
		return;
	}
	if (m_Aname == "")
	{
		MessageBox("请输入固定资产名称");
		return;
	}
	if (m_Type.GetBoundText() == "")
	{
		MessageBox("请选择固定资产类别");
		return;
	}

	// 定义固定资产操作对象
	CAssets cAst;
	cAst.Aid = m_Aid;
	cAst.Aname = m_Aname;
	cAst.Model = m_Model;
	cAst.OrgPrice = m_OrgPrice;
	cAst.PostDate = m_PostDate;
	cAst.Producer = m_Producer;
	cAst.Ratio = m_Ratio;
	cAst.UsedYear = m_UseYear;
	// 时间类型转换
	CString cstrDate;
	cstrDate = m_UseDate.Format("%Y-%m-%d");
	cAst.UseDate = cstrDate;
	// 获得增加方式
	m_AddWay.GetLBText(m_AddWay.GetCurSel(),cAddWay);
	cAst.AddWay = cAddWay;
	cAst.TypeId = atoi(m_Type.GetBoundText());
	// 保存数据
	if(cAid=="") //插入新记录
	{
		if (cAst.HaveAid(m_Aid) == 1)
		{
			MessageBox("资产编号已经存在");
			return;
		}
		if (cAst.HaveName(m_Aname) == 1)
		{
			MessageBox("资产名称已经存在");
			return;
		}
		cAst.sql_Insert();
	}
	else		//修改记录
	{	
		//对于修改记录，只有当编号和名称发生变化时，才判断新编号/名称是否存在
		if (cAid != m_Aid && cAst.HaveAid(m_Aid) == 1)
		{
			MessageBox("资产编号已经存在");
			return;
		}
		if (cAname != m_Aname && cAst.HaveName(m_Aname) == 1)
		{
			MessageBox("资产名称已经存在");
			return;
		}
		cAst.sql_Update(cAid);
	}
	//关闭对话框
	CDialog::OnOK();
}