?? addmodifyassets.cpp
字號:
// AddModifyAssets.cpp : implementation file
//
#include "stdafx.h"
#include "FixedAssets.h"
#include "AddModifyAssets.h"
#include "CRACK.h"
#include "PromptDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CAddModifyAssets dialog
CAddModifyAssets::CAddModifyAssets(CWnd* pParent /*=NULL*/)
: CDialog(CAddModifyAssets::IDD, pParent)
{
//{{AFX_DATA_INIT(CAddModifyAssets)
m_InDate = -1;
m_strInterID = _T("");
m_LFDate = -1;
m_strName = _T("");
m_strRemark = _T("");
m_strType = _T("");
m_strFactory = _T("");
m_strUseInfo = _T("");
m_strAssetID = _T("");
m_LeftValue = 0.0;
m_dOrigValue = 0.0;
m_dLRatio = 0.0;
m_nYearNum = 0;
//}}AFX_DATA_INIT
m_ID=_T("");
}
void CAddModifyAssets::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CAddModifyAssets)
DDX_Control(pDX, IDC_AM_AssetID, m_CtrlEditAssetID);
DDX_Control(pDX, IDC_AM_TYPE, m_CtrlEditType);
DDX_Control(pDX, IDC_AM_NAME, m_CtrlEditName);
DDX_Control(pDX, IDC_AM_USEINFO, m_CtrlCBUseInfo);
DDX_Control(pDX, IDC_AM_SORT, m_CtrlCBSort);
DDX_Control(pDX, IDC_AM_LIST, m_CtrlList);
DDX_Control(pDX, IDC_AM_KEEPER, m_CtrlCBKeeper);
DDX_Control(pDX, IDC_AM_FACTORY, m_CtrlCBFactory);
DDX_Control(pDX, IDC_AM_DEPRECIATION, m_CtrlCBDepreciation);
DDX_Control(pDX, IDC_AM_DEPOSITARY, m_CtrlCBDepositary);
DDX_Control(pDX, IDC_AM_DEPARTMENT, m_CtrlCBDepartment);
DDX_Control(pDX, IDC_AM_ADDTYPE, m_CtrlCBAddType);
DDX_DateTimeCtrl(pDX, IDC_AM_INDATE, m_InDate);
DDX_Text(pDX, IDC_AM_INTERID, m_strInterID);
DDX_DateTimeCtrl(pDX, IDC_AM_LFDATE, m_LFDate);
DDX_Text(pDX, IDC_AM_NAME, m_strName);
DDX_Text(pDX, IDC_AM_REMARK, m_strRemark);
DDX_Text(pDX, IDC_AM_TYPE, m_strType);
DDX_CBString(pDX, IDC_AM_FACTORY, m_strFactory);
DDX_CBString(pDX, IDC_AM_USEINFO, m_strUseInfo);
DDX_Text(pDX, IDC_AM_AssetID, m_strAssetID);
DDX_Text(pDX, IDC_AM_LEFTVALUE, m_LeftValue);
DDX_Text(pDX, IDC_AM_ORIGVALUE, m_dOrigValue);
DDV_MinMaxDouble(pDX, m_dOrigValue, 0., 9.e+030);
DDX_Text(pDX, IDC_LRATIO, m_dLRatio);
DDV_MinMaxDouble(pDX, m_dLRatio, 0., 1.);
DDX_Text(pDX, IDC_AM_YEARNUM, m_nYearNum);
DDV_MinMaxInt(pDX, m_nYearNum, 0, 1000);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CAddModifyAssets, CDialog)
//{{AFX_MSG_MAP(CAddModifyAssets)
ON_BN_CLICKED(IDD_ADD, OnAddModify)
ON_BN_CLICKED(IDD_REFRESH, OnRefreshDelet)
ON_NOTIFY(LVN_ITEMCHANGED, IDC_AM_LIST, OnItemchangedAmList)
ON_EN_CHANGE(IDC_AM_ORIGVALUE, OnChangeAmOrigvalue)
ON_EN_CHANGE(IDC_AM_LEFTVALUE, OnChangeAmLeftvalue)
ON_EN_CHANGE(IDC_LRATIO, OnChangeLratio)
ON_EN_CHANGE(IDC_AM_YEARNUM, OnChangeAmYearnum)
ON_CBN_SELCHANGE(IDC_AM_ADDTYPE, OnSelchangeAmAddtype)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CAddModifyAssets message handlers
int CAddModifyAssets::DoModal()
{
// TODO: Add your specialized code here and/or call the base class
return CDialog::DoModal();
}
BOOL CAddModifyAssets::OnInitDialog()
{
CDialog::OnInitDialog();
//設置列表框控件屬性為可整行選擇，各項間畫線區分
m_CtrlList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
if(AddModify)//添加
{
//按鈕上的字
SetDlgItemText(IDD_ADD,"添加"); //第一個按鈕
SetDlgItemText(IDD_REFRESH,"刷新"); //第二個按鈕
SetWindowText("添加固定資產"); //對話框標題
}
else//修改
{
//按鈕上的字
SetDlgItemText(IDD_ADD,"修改"); //第一個按鈕
SetDlgItemText(IDD_REFRESH,"刪除"); //第二個按鈕
SetWindowText("變更固定資產信息"); //對話框標題
//調用函數SetEditable，該函數用于使對話框中的控件處于不可用態
SetEditable(0);
}
//連接數據庫
m_pDatabase=new CDaoDatabase;
try{
m_pDatabase->Open("FixedAssets");
m_pRecordset=new CDaoRecordset(m_pDatabase);
}
catch(CDaoException *e)
{
e->ReportError();
delete m_pDatabase;
m_pDatabase=NULL;
e->Delete();
}
//初始化變量
if(!m_pDatabase->IsOpen()) return 0;
if(!m_pRecordset) return 0;
if(m_pRecordset->IsOpen()) m_pRecordset->Close();
CString strSelect;
try
{ //保管人員
strSelect = _T("Select 保管人員ID,保管人員 From 保管人員");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_uaKeeper.Add(var.lVal);
var = m_pRecordset->GetFieldValue(1);
m_saKeeper.Add(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
// 部門
strSelect = _T("Select 部門ID,部門名稱 From 部門");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_uaDepartment.Add(var.lVal);
var = m_pRecordset->GetFieldValue(1);
m_saDepartment.Add(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
// 存放地點
strSelect = _T("Select 存放地點ID,存放地點 From 存放地點");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_uaDepositary.Add(var.lVal);
var = m_pRecordset->GetFieldValue(1);
m_saDepositary.Add(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
// 增加方式
strSelect = _T("Select 增加方式ID,增加方式 From 增加方式");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_uaAddType.Add(var.lVal);
var = m_pRecordset->GetFieldValue(1);
m_saAddType.Add(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
// 資產類別
strSelect = _T("Select 資產類別ID,資產類別 From 資產類別");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_uaSort.Add(var.lVal);
var = m_pRecordset->GetFieldValue(1);
m_saSort.Add(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
//生產廠家
strSelect = _T("Select DISTINCT 生產廠家 From 資產信息");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_CtrlCBFactory.AddString(CCrack::strVARIANT(var));
m_pRecordset->MoveNext();
}
m_pRecordset->Close();
}
catch (CDaoException* e)
{
e->ReportError();
e->Delete();
return 0;
}
int nIndex,i;
for(i=0;i<m_saKeeper.GetSize();i++) //初始化 保管人員
{
nIndex =m_CtrlCBKeeper.InsertString(i,m_saKeeper.GetAt(i));
m_CtrlCBKeeper.SetItemData(nIndex, m_uaKeeper.GetAt(i));
}
for(i=0;i<m_saDepartment.GetSize();i++) //初始化 部門
{
nIndex =m_CtrlCBDepartment.InsertString(i,m_saDepartment.GetAt(i));
m_CtrlCBDepartment.SetItemData(nIndex, m_uaDepartment.GetAt(i));
}
for(i=0;i<m_saDepositary.GetSize();i++) //初始化 存放地點
{
nIndex =m_CtrlCBDepositary.InsertString(i,m_saDepositary.GetAt(i));
m_CtrlCBDepositary.SetItemData(nIndex, m_uaDepositary.GetAt(i));
}
for(i=0;i<m_saAddType.GetSize();i++) //初始化 增加方式
{
nIndex =m_CtrlCBAddType.InsertString(i,m_saAddType.GetAt(i));
m_CtrlCBAddType.SetItemData(nIndex, m_uaAddType.GetAt(i));
}
for(i=0;i<m_saSort.GetSize();i++) //初始化 類別
{
nIndex =m_CtrlCBSort.InsertString(i,m_saSort.GetAt(i));
m_CtrlCBSort.SetItemData(nIndex, m_uaSort.GetAt(i));
}
m_CtrlCBDepreciation.InsertString(0,"平均年限法"); //初始化折舊方法
m_CtrlCBDepreciation.InsertString(1,"工作量法");
m_CtrlCBDepreciation.InsertString(2,"雙倍余額遞減法");
m_CtrlCBDepreciation.InsertString(3,"年數總和法");
m_CtrlCBDepreciation.InsertString(4,"不折舊");
m_CtrlCBUseInfo.InsertString(0,"使用中"); //初始化使用情況
m_CtrlCBUseInfo.InsertString(1,"不使用");
m_CtrlCBUseInfo.InsertString(2,"不需要");
m_CtrlCBUseInfo.InsertString(3,"經營性出租");
Refresh(); //刷新list控件
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CAddModifyAssets::SetEditable(bool label)
{
(CButton*)GetDlgItem(IDD_ADD)->EnableWindow(label);
(CButton*)GetDlgItem(IDD_REFRESH)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_NAME)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_AssetID)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_TYPE)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_INTERID)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_LEFTVALUE)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_ORIGVALUE)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_LRATIO)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_YEARNUM)->EnableWindow(label);
(CEdit*)GetDlgItem(IDC_AM_REMARK)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_FACTORY)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_DEPRECIATION)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_DEPARTMENT)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_DEPOSITARY)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_SORT)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_USEINFO)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_ADDTYPE)->EnableWindow(label);
(CComboBox*)GetDlgItem(IDC_AM_KEEPER)->EnableWindow(label);
(CDateTimeCtrl*)GetDlgItem(IDC_AM_LFDATE)->EnableWindow(label);
(CDateTimeCtrl*)GetDlgItem(IDC_AM_INDATE)->EnableWindow(label);
}
void CAddModifyAssets::Refresh()//刷新
{
m_strTableName = _T("資產信息");
if(!m_pDatabase->IsOpen()) return;
if(!m_pRecordset) return;
if(m_pRecordset->IsOpen()) m_pRecordset->Close();
//清空list控件
m_CtrlList.DeleteAllItems();
while(m_CtrlList.DeleteColumn(0));
CDaoFieldInfo fieldInfo;
int nFields;
CDaoTableDef td(m_pDatabase);
try
{
td.Open(m_strTableName);
nFields = td.GetFieldCount();
for (int j=0; j < nFields; j++)
{
td.GetFieldInfo(j,fieldInfo);
int nWidth = m_CtrlList.GetStringWidth(fieldInfo.m_strName) + 15;
m_CtrlList.InsertColumn(j,fieldInfo.m_strName, LVCFMT_LEFT, nWidth);
}
}
catch (CDaoException* e)
{
e->ReportError();
e->Delete();
return;
}
td.Close();
int nItem = 0,i;
try
{
CString strSelect(_T("Select * From ["));
strSelect += m_strTableName;
strSelect += _T("]");
m_pRecordset->Open(dbOpenDynaset,strSelect);
while (!m_pRecordset->IsEOF())
{
COleVariant var;
var = m_pRecordset->GetFieldValue(0);
m_CtrlList.InsertItem(nItem,CCrack::strVARIANT(var));
for (i=0; i < nFields; i++)
{
var = m_pRecordset->GetFieldValue(i);
if(i==3||i==15||i==16||i==17||i==18)
{
CString item;
item=IdToString(atoi(CCrack::strVARIANT(var)),i);
m_CtrlList.SetItemText( nItem,i,item);
continue;
}
m_CtrlList.SetItemText( nItem,i,CCrack::strVARIANT(var));
}
nItem++;
m_pRecordset->MoveNext();
}
}
catch (CDaoException* e)
{
e->ReportError();
e->Delete();
return;
}
}
void CAddModifyAssets::Empty()
{
m_ID=_T("");
m_strInterID = _T("");
m_LeftValue =0;
m_strName = _T("");
m_strAssetID = _T("");
m_dOrigValue =0;
m_strRemark = _T("");
m_strType = _T("");
m_nYearNum =0;
m_dLRatio = 0;
m_strFactory=_T("");
m_CtrlCBKeeper.SetCurSel(-1);
m_CtrlCBDepartment.SetCurSel(-1);
m_CtrlCBDepositary.SetCurSel(-1);
m_CtrlCBUseInfo.SetCurSel(-1);
m_CtrlCBAddType.SetCurSel(-1);
m_CtrlCBSort.SetCurSel(-1);
m_CtrlCBDepreciation.SetCurSel(-1);
m_LFDate=CTime::GetCurrentTime();
m_InDate=CTime::GetCurrentTime();
UpdateData(0);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -