dadd.cpp

c++制作固定资产管理系统

// DAdd.cpp : implementation file
//

#include "stdafx.h"
#include "gdzc.h"
#include "DAdd.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
#include "externDllHeader.h"
/////////////////////////////////////////////////////////////////////////////
// CDAdd dialog


CDAdd::CDAdd(CWnd* pParent /*=NULL*/)
	: CDialog(CDAdd::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDAdd)
	//}}AFX_DATA_INIT
	m_font.CreatePointFont(200,"黑体",NULL);
}


void CDAdd::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDAdd)
	DDX_Control(pDX, IDC_STAICOTEXT, m_StaIcoText);
	DDX_Control(pDX, IDC_STAICO, m_StaICo);
	DDX_Control(pDX, IDC_STAID, m_StaID);
	DDX_Control(pDX, IDC_EDTUSETIME, m_EdtUseTime);
	DDX_Control(pDX, IDC_EDTUNIT, m_EdtUnit);
	DDX_Control(pDX, IDC_EDTSPEC, m_EdtSpec);
	DDX_Control(pDX, IDC_EDTREMAINSRATE, m_EdtReMainsRate);
	DDX_Control(pDX, IDC_EDTREMAINS, m_EdtReMains);
	DDX_Control(pDX, IDC_EDTOVALUE, m_EdtOvalue);
	DDX_Control(pDX, IDC_EDTNUMBER, m_EdtNumber);
	DDX_Control(pDX, IDC_EDTNETVALUE, m_EdtNetValue);
	DDX_Control(pDX, IDC_EDTNAME, m_EdtName);
	DDX_Control(pDX, IDC_EDTESTIMATEUSETIME, m_EdtEstimateUseTime);
	DDX_Control(pDX, IDC_EDTDEPRECITIONRATE, m_EdtDepreciationRate);
	DDX_Control(pDX, IDC_EDTDEPRECITIONMONEY, m_EdtDepreciationMoney);
	DDX_Control(pDX, IDC_EDTDEPRECIATION, m_EdtDepreciation);
	DDX_Control(pDX, IDC_DTDATE, m_DtDate);
	DDX_Control(pDX, IDC_COMUSESTATUS, m_ComUseStatus);
	DDX_Control(pDX, IDC_COMSTYLE, m_ComStyle);
	DDX_Control(pDX, IDC_COMMEANS, m_ComMeans);
	DDX_Control(pDX, IDC_COMADDSTYLE, m_ComAddStyle);
	DDX_Control(pDX, IDC_BUTUNDO, m_ButUndo);
	DDX_Control(pDX, IDC_BUTSAVE, m_ButSave);
	DDX_Control(pDX, IDC_BUTEXIT, m_ButExit);
	DDX_Control(pDX, IDC_BUTDELETE, m_BueDele);
	DDX_Control(pDX, IDC_BUTCHANGE, m_ButChange);
	DDX_Control(pDX, IDC_BUTADD, m_ButAdd);
	DDX_Control(pDX, IDC_STACAPTION, m_StaCaption);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDAdd, CDialog)
	//{{AFX_MSG_MAP(CDAdd)
	ON_WM_CTLCOLOR()
	ON_BN_CLICKED(IDC_BUTADD, OnButadd)
	ON_BN_CLICKED(IDC_BUTCHANGE, OnButchange)
	ON_BN_CLICKED(IDC_BUTDELETE, OnButdelete)
	ON_BN_CLICKED(IDC_BUTSAVE, OnButsave)
	ON_BN_CLICKED(IDC_BUTUNDO, OnButundo)
	ON_BN_CLICKED(IDC_BUTEXIT, OnButexit)
	ON_EN_CHANGE(IDC_EDTDEPRECIATION, OnChangeEdtdepreciation)
	ON_EN_CHANGE(IDC_EDTOVALUE, OnChangeEdtovalue)
	ON_EN_CHANGE(IDC_EDTREMAINSRATE, OnChangeEdtremainsrate)
	ON_CBN_KILLFOCUS(IDC_COMMEANS, OnKillfocusCommeans)
	ON_CBN_SETFOCUS(IDC_COMMEANS, OnSetfocusCommeans)
	ON_CBN_EDITCHANGE(IDC_COMUSESTATUS, OnEditchangeComusestatus)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDAdd message handlers

void CDAdd::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

BOOL CDAdd::OnInitDialog() 
{
	CDialog::OnInitDialog();
	rst.Open("使用状况表");
	this->m_ComUseStatus.SetRecordset(rst,"名称");
	rst.Open("增加方式表");
	this->m_ComAddStyle.SetRecordset(rst,"名称");
	rst.Open("类别表");
	this->m_ComStyle.SetRecordset(rst,"名称");
	rst.Open("折旧算法表");
	this->m_ComMeans.SetRecordset(rst,"名称");

	if(m_sID.IsEmpty())
	{

		m_ButChange.EnableWindow(false);
		m_BueDele.EnableWindow(false);
		return true;
	}
	this->Display(m_sID);
	CString js=ado.FieldToOtherField("固定资产信息表","编号",m_sID,"减少否",1);
	if(js=="1")
	{
		this->m_StaICo.ShowWindow(SW_SHOW);
		this->m_StaIcoText.ShowWindow(SW_SHOW);
	}
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

HBRUSH CDAdd::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	if(pWnd->GetSafeHwnd()==m_StaCaption.GetSafeHwnd())
		pDC->SelectObject(&m_font);
	if(pWnd->GetSafeHwnd()==this->m_StaIcoText.GetSafeHwnd())
		pDC->SetTextColor(RGB(255,0,0));
	// TODO: Return a different brush if the default is not desired
	return hbr;
}

BOOL CDAdd::DestroyWindow() 
{
	m_font.DeleteObject();	
	return CDialog::DestroyWindow();
}

void CDAdd::Display(CString sID)
{
	RxRecordset DspRst;
	CString sSQL;
	sSQL.Format("SELECT * FROM 固定资产信息视图 WHERE 编号='%s'",sID);
	DspRst.Open(sSQL,adCmdText);
	CString sName,sSpec,sUnit,sNumber,sStyle,sAddStyle,sUseStatus,sOvalue,sDepreciation,sNetValue,sReMainsRate,sReMains,sMeans,sEstimateUseTime,sUseTime,sDepreciationRate,sDepreciationMoney,sDate;
	sName=DspRst.GetFieldValue("名称");
	sSpec=DspRst.GetFieldValue("规格型号");
	sUnit=DspRst.GetFieldValue("单位");
	sNumber=DspRst.GetFieldValue("数量");
	sStyle=DspRst.GetFieldValue("类别");
	sAddStyle=DspRst.GetFieldValue("增加方式");
	sUseStatus=DspRst.GetFieldValue("使用状况");
	sOvalue=DspRst.GetFieldValue("入账原值");
	sDepreciation=DspRst.GetFieldValue("累计折旧");
	sNetValue=DspRst.GetFieldValue("净值");
	sReMainsRate=DspRst.GetFieldValue("预计净残值率");
	sReMains=DspRst.GetFieldValue("预计净残值");
	sMeans=DspRst.GetFieldValue("折旧方法");
	sEstimateUseTime=DspRst.GetFieldValue("预计使用月份");
	sUseTime=DspRst.GetFieldValue("已计提月份");
	sDepreciationRate=DspRst.GetFieldValue("月折旧率");
	sDepreciationMoney=DspRst.GetFieldValue("月折旧额");
	sDate=DspRst.GetFieldValue("入账日期");
	sID=DspRst.GetFieldValue("编号");
	float nDepreciationRate,nReMainsRate;
	nDepreciationRate=atof(sDepreciationRate)*1000;
	nReMainsRate=atof(sReMainsRate)*1000;
	sDepreciationRate.Format("%d",(int)nDepreciationRate);
	sReMainsRate.Format("%d",(int)nReMainsRate);

	m_EdtUseTime.SetWindowText(sUseTime);
	m_EdtUnit.SetWindowText(sUnit);
	m_EdtSpec.SetWindowText(sSpec);
	m_EdtReMainsRate.SetWindowText(sReMainsRate);
	m_EdtReMains.SetWindowText(sReMains);
	m_EdtOvalue.SetWindowText(sOvalue);
	m_EdtNumber.SetWindowText(sNumber);
	m_EdtNetValue.SetWindowText(sNetValue);
	m_EdtName.SetWindowText(sName);
	m_EdtEstimateUseTime.SetWindowText(sEstimateUseTime);
	m_EdtDepreciationRate.SetWindowText(sDepreciationRate);
	m_EdtDepreciationMoney.SetWindowText(sDepreciationMoney);
	m_EdtDepreciation.SetWindowText(sDepreciation);
	m_ComUseStatus.SetWindowText(sUseStatus);
	m_ComStyle.SetWindowText(sStyle);
	m_ComMeans.SetWindowText(sMeans);
	m_ComAddStyle.SetWindowText(sAddStyle);
	m_StaID.SetWindowText(sID);
	CTime time;
	time=CStringTOCTime(sDate);
	m_DtDate.SetTime(&time);
}

void CDAdd::Enabled(bool bEnabled)
{
	m_EdtUseTime.EnableWindow(bEnabled);
	m_EdtUnit.EnableWindow(bEnabled);
	m_EdtSpec.EnableWindow(bEnabled);
	m_EdtReMainsRate.EnableWindow(bEnabled);
	//m_EdtReMains.EnableWindow(bEnabled);
	m_EdtOvalue.EnableWindow(bEnabled);
	m_EdtNumber.EnableWindow(bEnabled);
	//m_EdtNetValue.EnableWindow(bEnabled);
	m_EdtName.EnableWindow(bEnabled);
	m_EdtEstimateUseTime.EnableWindow(bEnabled);
	//m_EdtDepreciationRate.EnableWindow(bEnabled);
	//m_EdtDepreciationMoney.EnableWindow(bEnabled);
	m_EdtDepreciation.EnableWindow(bEnabled);
	m_ComUseStatus.EnableWindow(bEnabled);
	m_ComStyle.EnableWindow(bEnabled);
	m_ComMeans.EnableWindow(bEnabled);
	m_ComAddStyle.EnableWindow(bEnabled);
	m_DtDate.EnableWindow(bEnabled);
	m_ButUndo.EnableWindow(bEnabled);
	m_ButSave.EnableWindow(bEnabled);
	m_ButExit.EnableWindow(!bEnabled);
	m_BueDele.EnableWindow(!bEnabled);
	m_ButChange.EnableWindow(!bEnabled);
	m_ButAdd.EnableWindow(!bEnabled);