?? dadd.cpp
字號:
// 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_BueDele.EnableWindow(!bEnabled);
m_ButChange.EnableWindow(!bEnabled);
m_ButAdd.EnableWindow(!bEnabled);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -