目錄一．摘要21.背景說明22.設(shè)計(jì)目的23.需求分析2二．固定資產(chǎn)管理系統(tǒng)概述31.設(shè)計(jì)內(nèi)容32.設(shè)計(jì)特點(diǎn)3三．固定資產(chǎn)管理系統(tǒng)數(shù)據(jù)庫分析與設(shè)計(jì)31.系統(tǒng)的功能模塊圖32.數(shù)據(jù)庫結(jié)構(gòu)設(shè)計(jì)43.概念模型設(shè)計(jì)（E-R圖）6四．窗體實(shí)現(xiàn)與設(shè)計(jì)81.登陸界面82.主界面103.部門信息管理界面154.資產(chǎn)類別管理界面185.固定資產(chǎn)信息編輯界面206.固定資產(chǎn)信息管理界面247.固定資產(chǎn)分配界面288.固定資產(chǎn)變更界面309.固定資產(chǎn)折舊界面3210.固定資產(chǎn)報(bào)廢界面3511.用戶管理界面3712.修改密碼界面39五．結(jié)論與體會41一．摘要1.背景說明精品文檔放心下載感謝閱讀謝謝閱讀謝謝閱讀感謝閱讀感謝閱讀證了企業(yè)中的每一件物品發(fā)揮其最大效力。2.設(shè)計(jì)目的謝謝閱讀二是更先進(jìn)的面向?qū)ο蟪绦蛟O(shè)計(jì)方法。感謝閱讀為C++謝謝閱讀全局變量。謝謝閱讀C++精品文檔放心下載少的，甚至還應(yīng)考慮類必須滿足的約束。3.需求分析精品文檔放心下載型信息。資產(chǎn)信息管理包括固定資產(chǎn)的錄入、分配、變更、折舊和報(bào)廢等功能。精品文檔放心下載統(tǒng)計(jì)查詢功能包括部門資產(chǎn)統(tǒng)計(jì)表和分類資產(chǎn)統(tǒng)計(jì)表。二．固定資產(chǎn)管理系統(tǒng)概述1.設(shè)計(jì)內(nèi)容(1)系統(tǒng)信息設(shè)置模塊：包括部門管理，類別管理和退出系統(tǒng)謝謝閱讀(2)固定資產(chǎn)管理模塊理模塊，包括信息編輯，資產(chǎn)分配，資產(chǎn)變更，資產(chǎn)感謝閱讀折舊，資產(chǎn)報(bào)廢等(3)系統(tǒng)用戶管理模塊，包括用戶管理和修改密碼2.設(shè)計(jì)特點(diǎn)后臺數(shù)據(jù)庫使用SQLServer，前臺開發(fā)工具使用VisualC++。謝謝閱讀本系統(tǒng)采用目前比較流行的ADO數(shù)據(jù)訪問技術(shù)，并將每個(gè)數(shù)據(jù)庫表的字段精品文檔放心下載謝謝閱讀序設(shè)計(jì)中。這也是本系統(tǒng)的特色和優(yōu)勢。三．固定資產(chǎn)管理系統(tǒng)數(shù)據(jù)庫分析與設(shè)計(jì)1.系統(tǒng)的功能模塊圖圖2.1固定資產(chǎn)管理系統(tǒng)功能模塊示意圖2.數(shù)據(jù)庫結(jié)構(gòu)設(shè)計(jì)數(shù)據(jù)庫中包含6DepartmentsTypes、謝謝閱讀資產(chǎn)信息表Assets、資產(chǎn)分配表Distribute、設(shè)備報(bào)廢表Discard和用戶信息感謝閱讀表Users等。表Assets列名數(shù)據(jù)類型允許為空Aidvarchar(30)不允許Anamevarchar(50)不允許TypeIdint允許Modelvarchar(30)允許Producervarchar(100)允許UseDatevarchar(20)允許UsedYearint允許OrgPricedecimal(15,2允許)Ratiodecimal(7,5)允許Statusvarchar(30)允許AddWayvarchar(30)允許IsAuditint允許PostDateVarchar(20)允許IsDiscountinyint允許t表Departments列名數(shù)據(jù)類型允許為空DepIdint不允許DepNamevarchar(40)不允許表Discard列名數(shù)據(jù)類型允許為空Aidvarchar(30)允許DSumfloat允許Reasonvarchar(200允許)CreateDatevarchar(30)允許EmpNamevarchar(40)允許Checkervarchar(40)允許CheckDatevarchar(40)允許StatusChar(4)允許表Distribute列名數(shù)據(jù)類型允許為空Aidvarchar(30)允許DepIdint允許EmpNamevarchar(50)允許CreateDatevarchar(30)允許表Types列名數(shù)據(jù)類型允許為空TypeIdint不允許TypeNamevarchar(30)不允許表Users列名數(shù)據(jù)類型允許為空UseraNamevarchar(40)不允許EmpNamevarchar(40)允許UserPwdvarchar(40)允許UserTypevarchar(20)允許3.概念模型設(shè)計(jì)（E-R圖）資產(chǎn)編號資產(chǎn)名稱類型狀態(tài)使用日期型號生產(chǎn)廠商使用年限負(fù)責(zé)人部門名稱四．窗體實(shí)現(xiàn)與設(shè)計(jì)1.登陸界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"LoginDlg.h"#include"Users.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;謝謝閱讀#endifCLoginDlg::CLoginDlg(CWnd*pParent/*=NULL*/)精品文檔放心下載:CDialog(CLoginDlg::IDD,pParent)精品文檔放心下載{count=0;m_Pwd=_T("");m_UserName=_T("");voidCLoginDlg::DoDataExchange(CDataExchange*pDX)謝謝閱讀{CDialog::DoDataExchange(pDX);感謝閱讀DDX_Text(pDX,IDC_PWD_EDIT,m_Pwd);精品文檔放心下載DDX_Text(pDX,IDC_USERNAME_EDIT,m_UserName);謝謝閱讀}BEGIN_MESSAGE_MAP(CLoginDlg,CDialog)精品文檔放心下載ON_EN_CHANGE(IDC_USERNAME_EDIT,&CLoginDlg::OnEnChangeUsernameEdit)謝謝閱讀ON_EN_CHANGE(IDC_PWD_EDIT,&CLoginDlg::OnEnChangePwdEdit)精品文檔放心下載END_MESSAGE_MAP()voidCLoginDlg::OnOK(){UpdateData(TRUE);if(m_UserName==""){MessageBox("請輸入用戶名?");return;}if(m_Pwd==""){MessageBox("請輸入密碼");return;}CUsersuser;user.GetData(m_UserName);if(user.UserPwd!=m_Pwd){MessageBox("用戶信息不正確，無法登錄！");謝謝閱讀count++;if(count>=3){MessageBox("已經(jīng)連續(xù)3次登錄失敗，將退出系統(tǒng)");感謝閱讀OnCancel();}return;}CDialog::OnOK();}voidCLoginDlg::OnEnChangeUsernameEdit()

{精品文檔放心下載}voidCLoginDlg::OnEnChangePwdEdit()感謝閱讀{}2.主界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"Assets.h"#include"ADOConn.h"#ifdef_DEBUG#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;感謝閱讀#definenewDEBUG_NEW#endifCAssets::CAssets(){Aid="";Aname="";Model="";Producer="";UsedYear=1;OrgPrice=0;Ratio=0;Status="未使用";AddWay="";IsAudit=0;IsDiscount=0;}CAssets::~CAssets(){}voidCAssets::sql_Insert(){try{ADOConnm_AdoConn;CStringcSql,cDate,cOrgPrc,cRatio,cTypeId,cYear;精品文檔放心下載_bstr_tbSql;cOrgPrc.Format("%f",OrgPrice);精品文檔放心下載cRatio.Format("%f",Ratio);精品文檔放心下載cTypeId.Format("%d",TypeId);感謝閱讀cYear.Format("%d",UsedYear);謝謝閱讀CTimet=CTime::GetCurrentTime();謝謝閱讀cDate.Format(_T("%04d-%02d-%02d"),t.GetYear(),t.GetMonth(),t.GetDay());謝謝閱讀cSql="InsertIntoAssets(Aid,Aname,TypeId,Model,Producer,";謝謝閱讀cSql+="UseDate,UsedYear,OrgPrice,Ratio,";精品文檔放心下載cSql+="Status,AddWay,IsAudit,PostDate,IsDiscount)Values('";精品文檔放心下載cSql+=Aid+"','"+Aname+"',"+cTypeId+",'"+Model+"','"+Producer+"','";精品文檔放心下載cSql+=UseDate+"',"+cYear+","+cOrgPrc+",";謝謝閱讀cSql+=cRatio+",'未使用','"+AddWay+"',0,'"+cDate+"',0)";精品文檔放心下載bSql=(LPCTSTR)(_bstr_t)cSql;謝謝閱讀m_AdoConn.ExecuteSQL(bSql);感謝閱讀m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());謝謝閱讀}}voidCAssets::sql_Update(CStringcId)謝謝閱讀{try{ADOConnm_AdoConn;CStringcDate,cOrgPrc,cRatio,cTypeId,cYear;感謝閱讀_bstr_tbSql;cOrgPrc.Format("%f",OrgPrice);謝謝閱讀cRatio.Format("%f",Ratio);感謝閱讀cTypeId.Format("%d",TypeId);感謝閱讀cYear.Format("%d",UsedYear);精品文檔放心下載CTimet=CTime::GetCurrentTime();謝謝閱讀cDate.Format(_T("%04d-%02d-%02d"),t.GetYear(),t.GetMonth(),t.GetDay());精品文檔放心下載bSql="UpdateAssetsSetAid='"+Aid+"',Aname='"+Aname+"',"感謝閱讀+"TypeId="+cTypeId+",Model='"+Model+"',Producer='"+Producer+"',"謝謝閱讀+"UseDate='"+UseDate+"',UsedYear="+cYear+",OrgPrice="+cOrgPrc+","感謝閱讀+"Ratio="+cRatio+",AddWay='"+AddWay+"',"感謝閱讀+"PostDate='"+cDate+"'WhereAid='"+cId+"'";感謝閱讀m_AdoConn.ExecuteSQL(bSql);謝謝閱讀m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());感謝閱讀}}voidCAssets::sql_Delete(CStringcId)謝謝閱讀{try{ADOConnm_AdoConn;_bstr_tbSql;bSql="DeleteFromAssetsWhereAid='"+cId+"'";感謝閱讀m_AdoConn.ExecuteSQL(bSql);精品文檔放心下載m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());謝謝閱讀}}voidCAssets::sql_Change(CStringcId)精品文檔放心下載{try{ADOConnm_AdoConn;CStringcRatio,cYear;_bstr_tbSql;cRatio.Format("%f",Ratio);感謝閱讀cYear.Format("%d",UsedYear);謝謝閱讀bSql="UpdateAssetsSetUsedYear="+cYear+",Ratio="+cRatio+","精品文檔放心下載+"IsAudit=2WhereAid='"+cId+"'";精品文檔放心下載m_AdoConn.ExecuteSQL(bSql);精品文檔放心下載m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());精品文檔放心下載}}voidCAssets::sql_Audit(CStringcId)精品文檔放心下載{try{ADOConnm_AdoConn;_bstr_tbSql;bSql="UpdateAssetsSetIsAudit=1WhereAid='"+cId+"'";謝謝閱讀m_AdoConn.ExecuteSQL(bSql);感謝閱讀m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());精品文檔放心下載}}voidCAssets::sql_Status(CStringcId)精品文檔放心下載{try{ADOConnm_AdoConn;_bstr_tbSql;bSql="UpdateAssetsSetStatus='"+Status+"'WhereAid='"+cId+"'";謝謝閱讀m_AdoConn.ExecuteSQL(bSql);感謝閱讀m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());謝謝閱讀}}intCAssets::HaveAid(CStringcAid)感謝閱讀{try{longlRscnt=0;_RecordsetPtrm_pRecordset;精品文檔放心下載ADOConnm_AdoConn;_bstr_tbSQL;bSQL="Select*FromAssetsWhereAid='"+cAid+"'";謝謝閱讀m_pRecordset=m_AdoConn.GetRecordSet(bSQL);感謝閱讀if(m_pRecordset->adoEOF)return-1;elsereturn1;m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());感謝閱讀}return-1;}intCAssets::HaveName(CStringcAname)感謝閱讀{try{longlRscnt=0;_RecordsetPtrm_pRecordset;感謝閱讀ADOConnm_AdoConn;_bstr_tbSQL;bSQL="Select*FromAssetsWhereAname='"+cAname+"'";精品文檔放心下載m_pRecordset=m_AdoConn.GetRecordSet(bSQL);感謝閱讀if(m_pRecordset->adoEOF)return-1;elsereturn1;m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());感謝閱讀}return-1;}voidCAssets::BeginDiscount(CStringcId)精品文檔放心下載{try{ADOConnm_AdoConn;_bstr_tbSql;bSql="UpdateAssetsSetIsDiscount=1WhereAid='"+cId+"'";精品文檔放心下載m_AdoConn.ExecuteSQL(bSql);感謝閱讀m_AdoConn.ExitConnect();}catch(_com_errore){AfxMessageBox(e.Description());謝謝閱讀}}3.部門信息管理界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"DeptDlg.h"#include"Departments.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;謝謝閱讀#endifCDeptDlg::CDeptDlg(CWnd*pParent/*=NULL*/)謝謝閱讀:CDialog(CDeptDlg::IDD,pParent)謝謝閱讀{m_DeptName=_T("");}voidCDeptDlg::DoDataExchange(CDataExchange*pDX)謝謝閱讀{CDialog::DoDataExchange(pDX);精品文檔放心下載DDX_Control(pDX,IDC_ADODC1,m_AdoDept);感謝閱讀DDX_Text(pDX,IDC_EDIT1,m_DeptName);精品文檔放心下載DDX_Control(pDX,IDC_DATALIST1,m_DataDept);感謝閱讀}BEGIN_MESSAGE_MAP(CDeptDlg,CDialog)感謝閱讀ON_BN_CLICKED(IDC_ADD_BUTTON,OnAddButton)精品文檔放心下載ON_BN_CLICKED(IDC_MODI_BUTTON,OnModiButton)謝謝閱讀ON_BN_CLICKED(IDC_DEL_BUTTON,OnDelButton)謝謝閱讀ON_EN_CHANGE(IDC_EDIT1,&CDeptDlg::OnEnChangeEdit1)謝謝閱讀END_MESSAGE_MAP()BEGIN_EVENTSINK_MAP(CDeptDlg,CDialog)精品文檔放心下載ON_EVENT(CDeptDlg,IDC_DATALIST1,-600/*Click*/,OnClickDatalist1,VTS_NONE)謝謝閱讀END_EVENTSINK_MAP()voidCDeptDlg::OnClickDatalist1()感謝閱讀{m_DeptName=m_DataDept.GetText();精品文檔放心下載cDepId=m_DataDept.GetBoundText();感謝閱讀cDepNameOld=m_DataDept.GetText();謝謝閱讀UpdateData(FALSE);}voidCDeptDlg::OnAddButton()精品文檔放心下載{UpdateData(TRUE);if(m_DeptName==""){MessageBox("請輸入部門名稱");return;}CDepartmentscDep;cDep.DepName=m_DeptName;if(cDep.HaveName(m_DeptName)==1)精品文檔放心下載MessageBox("已經(jīng)存在此部門信息!");else{cDep.sql_Insert();m_AdoDept.Refresh();}}voidCDeptDlg::OnModiButton()精品文檔放心下載{UpdateData(TRUE);if(m_DataDept.GetText()=="")精品文檔放心下載{MessageBox("請選擇要修改的部門名稱");精品文檔放心下載return;}if(m_DeptName==""){MessageBox("請輸入部門名稱");return;}if(cDepNameOld!=m_DeptName)謝謝閱讀{CDepartmentscDept;cDept.DepName=m_DeptName;if(cDept.HaveName(m_DeptName)==1)精品文檔放心下載MessageBox("新的部門名稱已經(jīng)存在");else{cDept.sql_Update(cDepId);m_AdoDept.Refresh();}}}voidCDeptDlg::OnDelButton()謝謝閱讀{if(m_DataDept.GetText()=="")精品文檔放心下載{MessageBox("請選擇要刪除的部門名稱");感謝閱讀return;}CDepartmentscDep;cDep.sql_Delete(cDepId);m_AdoDept.Refresh();}voidCDeptDlg::OnEnChangeEdit1()謝謝閱讀{}4.資產(chǎn)類別管理界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"TypeDlg.h"#include"Types.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;精品文檔放心下載#endifCTypeDlg::CTypeDlg(CWnd*pParent/*=NULL*/)感謝閱讀:CDialog(CTypeDlg::IDD,pParent)精品文檔放心下載{m_TypeName=_T("");}voidCTypeDlg::DoDataExchange(CDataExchange*pDX)感謝閱讀{CDialog::DoDataExchange(pDX);謝謝閱讀DDX_Control(pDX,IDC_ADODC1,m_AdoType);精品文檔放心下載DDX_Control(pDX,IDC_DATALIST1,m_DataType);精品文檔放心下載DDX_Text(pDX,IDC_EDIT1,m_TypeName);精品文檔放心下載}BEGIN_MESSAGE_MAP(CTypeDlg,CDialog)精品文檔放心下載ON_BN_CLICKED(IDC_ADD_BUTTON,OnAddButton)感謝閱讀ON_BN_CLICKED(IDC_MODI_BUTTON,OnModiButton)感謝閱讀ON_BN_CLICKED(IDC_DEL_BUTTON,OnDelButton)感謝閱讀END_MESSAGE_MAP()BEGIN_EVENTSINK_MAP(CTypeDlg,CDialog)精品文檔放心下載ON_EVENT(CTypeDlg,IDC_DATALIST1,-600/*Click*/,OnClickDatalist1,VTS_NONE)精品文檔放心下載END_EVENTSINK_MAP()voidCTypeDlg::OnClickDatalist1()感謝閱讀{m_TypeName=m_DataType.GetText();精品文檔放心下載cTypeId=m_DataType.GetBoundText();精品文檔放心下載cTypeNameOld=m_DataType.GetText();謝謝閱讀UpdateData(FALSE);}voidCTypeDlg::OnAddButton()感謝閱讀{UpdateData(TRUE);if(m_TypeName==""){MessageBox("請輸入類別名稱");return;}CTypesobj;obj.TypeName=m_TypeName;if(obj.HaveName(m_TypeName)==1)感謝閱讀MessageBox("此類別名稱已經(jīng)存在！");else{obj.sql_Insert();m_AdoType.Refresh();}}voidCTypeDlg::OnModiButton()感謝閱讀{UpdateData(TRUE);if(m_DataType.GetText()=="")精品文檔放心下載{MessageBox("請選擇要修改的類別名稱");感謝閱讀return;}if(m_TypeName==""){MessageBox("請輸入類別名稱");return;}if(cTypeNameOld!=m_TypeName)感謝閱讀{CTypesobj;obj.TypeName=m_TypeName;if(obj.HaveName(m_TypeName)==1)精品文檔放心下載MessageBox("此類別名稱已經(jīng)存在！");else{obj.sql_Update(cTypeId);m_AdoType.Refresh();}}}voidCTypeDlg::OnDelButton()感謝閱讀{CTypesobj;obj.sql_Delete(cTypeId);m_AdoType.Refresh();}5.固定資產(chǎn)信息編輯界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"AssetsEditDlg.h"#include"Assets.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;精品文檔放心下載#endifCAssetsEditDlg::CAssetsEditDlg(CWnd*pParent/*=NULL*/)謝謝閱讀:CDialog(CAssetsEditDlg::IDD,pParent)精品文檔放心下載{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("");}voidCAssetsEditDlg::DoDataExchange(CDataExchange*pDX)謝謝閱讀{CDialog::DoDataExchange(pDX);精品文檔放心下載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);感謝閱讀}BEGIN_MESSAGE_MAP(CAssetsEditDlg,CDialog)謝謝閱讀ON_EN_CHANGE(IDC_AID_EDIT,&CAssetsEditDlg::OnEnChangeAidEdit)精品文檔放心下載END_MESSAGE_MAP()BOOLCAssetsEditDlg::OnInitDialog()謝謝閱讀{CDialog::OnInitDialog();if(cAid==""){CTimet=CTime::GetCurrentTime();精品文檔放心下載CStringcDate;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{CStringcItem;cItem="";for(inti=0;i<m_AddWay.GetCount();i++)感謝閱讀{m_AddWay.GetLBText(i,cItem);謝謝閱讀if(cItem==strAddWay){m_AddWay.SetCurSel(i);break;}}COleVariantvtime(strUseDate);謝謝閱讀vtime.ChangeType(VT_DATE);精品文檔放心下載COleDateTimetime4(vtime);m_UseDate.SetDate(time4.GetYear(),time4.GetMonth(),time4.GetDay());謝謝閱讀m_Type.SetBoundText(strTypeId);謝謝閱讀}UpdateData(FALSE);returnTRUE;}voidCAssetsEditDlg::OnOK()精品文檔放心下載{CStringcDate,cAddWay,cStatus;感謝閱讀UpdateData(TRUE);if(m_Aid==""){MessageBox("請輸入固定資產(chǎn)編號");return;}if(m_Aname==""){MessageBox("請輸入固定資產(chǎn)名稱");return;}if(m_Type.GetBoundText()=="")謝謝閱讀{MessageBox("請選擇固定資產(chǎn)類別");return;}CAssetscAst;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;CStringcstrDate;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("資產(chǎn)編號已經(jīng)存在");return;}if(cAst.HaveName(m_Aname)==1)感謝閱讀{MessageBox("資產(chǎn)名稱已經(jīng)存在");return;}cAst.sql_Insert();}else{if(cAid!=m_Aid&&cAst.HaveAid(m_Aid)==1)精品文檔放心下載{MessageBox("資產(chǎn)編號已經(jīng)存在¨2");return;}if(cAname!=m_Aname&&cAst.HaveName(m_Aname)==1)感謝閱讀{MessageBox("資產(chǎn)名稱已經(jīng)存在");return;}cAst.sql_Update(cAid);}CDialog::OnOK();}voidCAssetsEditDlg::OnEnChangeAidEdit()感謝閱讀{}6.固定資產(chǎn)信息管理界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"AssetsSelectDlg.h"精品文檔放心下載#include"Assets.h"#include"columns.h"#include"column.h"#include"COMDEF.H"#include"_recordset.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;感謝閱讀#endifCAssetsSelectDlg::CAssetsSelectDlg(CWnd*pParent/*=NULL*/)感謝閱讀:CDialog(CAssetsSelectDlg::IDD,pParent)精品文檔放心下載{}voidCAssetsSelectDlg::DoDataExchange(CDataExchange*pDX)感謝閱讀{CDialog::DoDataExchange(pDX);謝謝閱讀DDX_Control(pDX,IDC_TYPE_COMBO,m_type);感謝閱讀DDX_Control(pDX,IDC_ADODC1,m_Adodc1);謝謝閱讀DDX_Control(pDX,IDC_ADODC2,m_Adodc2);謝謝閱讀DDX_Control(pDX,IDC_DATAGRID1,m_DataGrid);謝謝閱讀DDX_Control(pDX,IDC_SEARCH_DATACOMBO,m_search);感謝閱讀}BEGIN_MESSAGE_MAP(CAssetsSelectDlg,CDialog)精品文檔放心下載ON_CBN_SELCHANGE(IDC_TYPE_COMBO,OnSelchangeTypeCombo)感謝閱讀END_MESSAGE_MAP()voidCAssetsSelectDlg::RefreshData()感謝閱讀{CStringcsql;csql="SELECTa.AidAS資產(chǎn)編號資名稱,a.TypeId,";感謝閱讀csql+="t.TypeNameAS類型,a.StatusAS狀態(tài),a.ModelAS型號a.ProducerAS生產(chǎn)廠商";謝謝閱讀csql+="a.UseDateAS使用日期,a.UsedYearAS使用年限T,a.OrgPriceAS原值|a.RatioAS殘率,";感謝閱讀csql+="a.AddWayAS增加方式,a.PostDateAS提交日期,";感謝閱讀csql+="a.IsAudit,(CASEWHENa.IsAudit=0THEN'WHENa.IsAudit=1THEN''END)AS?";謝謝閱讀csql+="FROMAssetsa,Typest";精品文檔放心下載csql+="WHEREa.TypeId=t.TypeId";謝謝閱讀if(cSearchValue=="")cSearchValue="0";if(m_type.GetCurSel()==1)csql=csql+"ANDa.TypeId="+cSearchValue;感謝閱讀if(flag==1)csql=csql+"ANDa.IsAudit=1ANDa.AidNOTIN(SELECTAidFROMDistribute)";精品文檔放心下載elsecsql=csql+"ANDa.Status='使o1用??中D'";感謝閱讀//MessageBox(csql);m_Adodc1.SetRecordSource(csql);

m_Adodc1.Refresh();_variant_tvIndex;vIndex=long(0);謝謝閱讀m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);

vIndex=long(1);謝謝閱讀m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);

vIndex=long(2);感謝閱讀m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);

vIndex=long(3);精品文檔放心下載m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(80);

vIndex=long(4);精品文檔放心下載m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);

vIndex=long(5);謝謝閱讀m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);

vIndex=long(6);謝謝閱讀m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);

vIndex=long(7);謝謝閱讀m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(100);

vIndex=long(8);精品文檔放心下載m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(70);精品文檔放心下載vIndex=long(9);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);謝謝閱讀vIndex=long(10);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);謝謝閱讀vIndex=long(11);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);精品文檔放心下載vIndex=long(12);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);謝謝閱讀vIndex=long(13);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(0);謝謝閱讀vIndex=long(14);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);精品文檔放心下載}BOOLCAssetsSelectDlg::OnInitDialog()感謝閱讀{CDialog::OnInitDialog();m_type.SetCurSel(0);GetDlgItem(IDC_SEARCH_DATACOMBO)->ShowWindow(SW_HIDE);謝謝閱讀RefreshData();returnTRUE;/}voidCAssetsSelectDlg::OnSelchangeTypeCombo()謝謝閱讀{intiSel;iSel=m_type.GetCurSel();m_search.SetText("");if(iSel==1){m_Adodc2.SetRecordSource("SELECT*FROMTypes");感謝閱讀m_Adodc2.Refresh();m_search.SetListField("TypeName");精品文檔放心下載m_search.SetBoundColumn("TypeId");精品文檔放心下載m_search.Refresh();GetDlgItem(IDC_SEARCH_DATACOMBO)->ShowWindow(SW_SHOW);感謝閱讀}else{GetDlgItem(IDC_SEARCH_DATACOMBO)->ShowWindow(SW_HIDE);感謝閱讀}UpdateData(FALSE);RefreshData();}BEGIN_EVENTSINK_MAP(CAssetsSelectDlg,CDialog)感謝閱讀ON_EVENT(CAssetsSelectDlg,IDC_SEARCH_DATACOMBO,-600/*Click*/,OnClickSearchDatacombo,VTS感謝閱讀_I2)END_EVENTSINK_MAP()voidCAssetsSelectDlg::OnClickSearchDatacombo(shortArea)謝謝閱讀{cSearchValue=m_search.GetBoundText();感謝閱讀RefreshData();}voidCAssetsSelectDlg::OnOK()感謝閱讀{AssetsId=m_DataGrid.GetItem(0);謝謝閱讀AssetsName=m_DataGrid.GetItem(1);感謝閱讀CDialog::OnOK();}7.固定資產(chǎn)分配界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"DistributeEditDlg.h"感謝閱讀#include"AssetsSelectDlg.h"精品文檔放心下載#include"Distribute.h"#include"Assets.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;感謝閱讀#endifCDistributeEditDlg::CDistributeEditDlg(CWnd*pParent/*=NULL*/)感謝閱讀:CDialog(CDistributeEditDlg::IDD,pParent)謝謝閱讀{m_assets=_T("");m_name=_T("");m_date=COleDateTime::GetCurrentTime();謝謝閱讀m_aid=_T("");}voidCDistributeEditDlg::DoDataExchange(CDataExchange*pDX)感謝閱讀{CDialog::DoDataExchange(pDX);精品文檔放心下載DDX_Control(pDX,IDC_ADODC1,m_adodc);精品文檔放心下載DDX_Text(pDX,IDC_ASSETS_EDIT,m_assets);謝謝閱讀DDX_Control(pDX,IDC_DATACOMBO1,m_dep);感謝閱讀DDX_Text(pDX,IDC_NAME_EDIT,m_name);感謝閱讀DDX_DateTimeCtrl(pDX,IDC_DATETIMEPICKER1,m_date);精品文檔放心下載DDX_Text(pDX,IDC_AID_EDIT,m_aid);謝謝閱讀}BEGIN_MESSAGE_MAP(CDistributeEditDlg,CDialog)謝謝閱讀ON_BN_CLICKED(IDC_BUTTON1,OnButton1)謝謝閱讀ON_EN_CHANGE(IDC_NAME_EDIT,&CDistributeEditDlg::OnEnChangeNameEdit)精品文檔放心下載END_MESSAGE_MAP()BOOLCDistributeEditDlg::OnInitDialog()精品文檔放心下載{CDialog::OnInitDialog();if(cAid==""){CTimet=CTime::GetCurrentTime();精品文檔放心下載m_date.SetDate(t.GetYear(),t.GetMonth(),t.GetDay());精品文檔放心下載}else{m_dep.SetBoundText(cDepId);感謝閱讀COleVariantvtime(cDate);vtime.ChangeType(VT_DATE);精品文檔放心下載COleDateTimetime4(vtime);m_date.SetDate(time4.GetYear(),time4.GetMonth(),time4.GetDay());謝謝閱讀GetDlgItem(IDC_BUTTON1)->EnableWindow(FALSE);感謝閱讀}UpdateData(FALSE);returnTRUE;}voidCDistributeEditDlg::OnButton1()謝謝閱讀{UpdateData(TRUE);CAssetsSelectDlgdlg;dlg.flag=1;if(dlg.DoModal()==IDOK){m_assets=dlg.AssetsName;m_aid=dlg.AssetsId;UpdateData(FALSE);}}voidCDistributeEditDlg::OnOK()精品文檔放心下載{UpdateData(TRUE);if(m_dep.GetBoundText()=="")精品文檔放心下載{MessageBox("請選擇部門");return;}if(m_aid==""){MessageBox("請選擇固定資產(chǎn)");return;}if(m_name==""){MessageBox("請輸入負(fù)責(zé)人");return;}CDistributedis;dis.DepId=atoi(m_dep.GetBoundText());謝謝閱讀dis.EmpName=m_name;dis.Aid=m_aid;dis.CreateDate=m_date.Format("%Y-%m-%d");感謝閱讀if(cAid=="")dis.sql_Insert();elsedis.sql_Update(cAid);CDialog::OnOK();}voidCDistributeEditDlg::OnEnChangeNameEdit()感謝閱讀{

}8.固定資產(chǎn)變更界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"AssetsChgEditDlg.h"謝謝閱讀#include"Assets.h"#include"Distribute.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;精品文檔放心下載#endifCAssetsChgEditDlg::CAssetsChgEditDlg(CWnd*pParent/*=NULL*/)謝謝閱讀:CDialog(CAssetsChgEditDlg::IDD,pParent)謝謝閱讀{m_aid=_T("");m_aname=_T("");m_name=_T("");m_ratio=_T("");m_useyear=_T("");}voidCAssetsChgEditDlg::DoDataExchange(CDataExchange*pDX)精品文檔放心下載{CDialog::DoDataExchange(pDX);

DDX_Control(pDX,IDC_ADODC1,m_adodc);

DDX_Text(pDX,IDC_AID_EDIT,m_aid);

DDX_Text(pDX,IDC_ANAME_EDIT,m_aname);

DDX_Control(pDX,IDC_DATACOMBO1,m_dep);

DDX_Text(pDX,IDC_NAME_EDIT,m_name);

DDX_Text(pDX,IDC_RATIO_EDIT,m_ratio);

DDX_Text(pDX,IDC_USEYEAR_EDIT,m_useyear);

}精品文檔放心下載BEGIN_MESSAGE_MAP(CAssetsChgEditDlg,CDialog)

ON_EN_CHANGE(IDC_USEYEAR_EDIT,&CAssetsChgEditDlg::OnEnChangeUseyearEdit)

END_MESSAGE_MAP()BOOLCAssetsChgEditDlg::OnInitDialog()

{精品文檔放心下載CDialog::OnInitDialog();if(cDepId!="0")m_dep.SetBoundText(cDepId);

returnTRUE;感謝閱讀}voidCAssetsChgEditDlg::OnOK()精品文檔放心下載{UpdateData(TRUE);if(m_aid==""){MessageBox("請輸入固定資產(chǎn)編號");return;}if(m_aname==""){MessageBox("請輸入固定資產(chǎn)名稱");return;}if(m_dep.GetBoundText()=="")感謝閱讀{MessageBox("請選擇固定資產(chǎn)類別");return;}CAssetsast;ast.UsedYear=atoi(m_useyear);感謝閱讀ast.Ratio=atof(m_ratio);ast.sql_Change(m_aid);CDistributedis;dis.DepId=atoi(m_dep.GetBoundText());謝謝閱讀dis.EmpName=m_name;CTimet=CTime::GetCurrentTime();感謝閱讀dis.CreateDate.Format(_T("%04d-%02d-%02d"),t.GetYear(),t.GetMonth(),t.GetDay());精品文檔放心下載dis.sql_Update(m_aid);CDialog::OnOK();}voidCAssetsChgEditDlg::OnEnChangeUseyearEdit()感謝閱讀{

}9.固定資產(chǎn)折舊界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"DiscountDlg.h"#include"columns.h"#include"column.h"#include"COMDEF.H"#include"_recordset.h"#include"Assets.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;謝謝閱讀#endifCDiscountDlg::CDiscountDlg(CWnd*pParent/*=NULL*/)感謝閱讀:CDialog(CDiscountDlg::IDD,pParent)精品文檔放心下載{}voidCDiscountDlg::DoDataExchange(CDataExchange*pDX)感謝閱讀{CDialog::DoDataExchange(pDX);感謝閱讀DDX_Control(pDX,IDC_TYPE_COMBO,m_type);謝謝閱讀DDX_Control(pDX,IDC_ADODC1,m_Adodc);感謝閱讀DDX_Control(pDX,IDC_DATAGRID1,m_DataGrid);精品文檔放心下載}BEGIN_MESSAGE_MAP(CDiscountDlg,CDialog)精品文檔放心下載ON_CBN_SELCHANGE(IDC_TYPE_COMBO,OnSelchangeTypeCombo)精品文檔放心下載ON_BN_CLICKED(IDC_DISCOUNT_BUTTON,OnDiscountButton)謝謝閱讀END_MESSAGE_MAP()voidCDiscountDlg::DisInMonth()感謝閱讀{CStringcsql;csql="SelectAIdAS資產(chǎn)編號ANameAS資產(chǎn)名稱,OrgPriceAS原值RatioAS殘值率,";精品文檔放心下載csql+="UsedYear*12AS使用月份Y,OrgPrice*RatioAS凈殘值";感謝閱讀csql+="FromAssetsWhereIsAudit=1ANDStatus='使用中D'ANDUseDate<=GetDate()";感謝閱讀csql+="ANDIsDiscount=0";m_Adodc.SetRecordSource(csql);精品文檔放心下載m_Adodc.Refresh();_variant_tvIndex;vIndex=long(0);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(120);謝謝閱讀vIndex=long(1);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(120);精品文檔放心下載vIndex=long(2);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(100);精品文檔放心下載vIndex=long(3);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(80);感謝閱讀vIndex=long(4);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(80);感謝閱讀vIndex=long(5);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(80);感謝閱讀}voidCDiscountDlg::AllDiscountRecords()感謝閱讀{CStringcsql;csql="SELECTAIdAS資產(chǎn)編號,ANameAS資產(chǎn)名稱,OrgPriceAS原-值,RatioAS殘值率,";精品文檔放心下載csql+="UseDateAS使用時(shí)間,UsedYearAS使用年限T,UseMonthAS使用月份Y,";精品文檔放心下載csql+="CcMonthAS計(jì)提月份Y,RatioMonthAS月折?舊率,DisPerMonthAS月折舊額,";感謝閱讀csql+="LastPriceAS凈殘值,DisPriceAS已折金額?FROMv_DisCount";感謝閱讀m_Adodc.SetRecordSource(csql);精品文檔放心下載m_Adodc.Refresh();_variant_tvIndex;vIndex=long(0);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(50);精品文檔放心下載vIndex=long(1);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(70);感謝閱讀vIndex=long(2);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(50);精品文檔放心下載vIndex=long(3);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(35);感謝閱讀vIndex=long(4);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(60);謝謝閱讀vIndex=long(5);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(45);感謝閱讀vIndex=long(6);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(45);精品文檔放心下載vIndex=long(7);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(45);感謝閱讀vIndex=long(8);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(45);感謝閱讀vIndex=long(9);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(45);精品文檔放心下載vIndex=long(10);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(50);謝謝閱讀vIndex=long(11);m_DataGrid.GetColumns().GetItem(vIndex).SetWidth(50);謝謝閱讀}BOOLCDiscountDlg::OnInitDialog()感謝閱讀{CDialog::OnInitDialog();

m_type.SetCurSel(0);

DisInMonth();returnTRUE;精品文檔放心下載}voidCDiscountDlg::OnSelchangeTypeCombo()感謝閱讀{if(m_type.GetCurSel()==0){DisInMonth();GetDlgItem(IDC_Discount)->EnableWindow(TRUE);精品文檔放心下載}else{AllDiscountRecords();GetDlgItem(IDC_Discount)->EnableWindow(FALSE);精品文檔放心下載}}voidCDiscountDlg::OnDiscountButton()謝謝閱讀{CAssetscAst;cAst.BeginDiscount(m_DataGrid.GetItem(0));謝謝閱讀DisInMonth();}10.固定資產(chǎn)報(bào)廢界面代碼設(shè)計(jì)#include"stdafx.h"#include"AssetsMan.h"#include"DiscardEditDlg.h"精品文檔放心下載#include"Discard.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;感謝閱讀#endifCDiscardEditDlg::CDiscardEditDlg(CWnd*pParent/*=NULL*/)精品文檔放心下載:CDialog(CDiscardEditDlg::IDD,pParent)謝謝閱讀{m_aid=_T("");m_aname=_T("");m_createdate=_T("");m_dsum=0.0f;m_empname=_T("");m_reason=_T("");}voidCDiscardEditDlg::DoDataExchange(CDataExchange*pDX)精品文檔放心下載{CDialog::DoDataExchange(pDX);謝謝閱讀DDX_Text(pDX,IDC_AID_EDIT,m_aid);謝謝閱讀DDX_Text(pDX,IDC_ANAME_EDIT,m_aname);精品文檔放心下載DDX_Text(pDX,IDC_CREATEDATE_EDIT,m_createdate);感謝閱讀DDX_Text(pDX,IDC_DSUM_EDIT,m_dsum);謝謝閱讀DDX_Text(pDX,IDC_EMPNAME_EDIT,m_empname);謝謝閱讀DDX_Text(pDX,IDC_REASON_EDIT,m_reason);謝謝閱讀}BEGIN_MESSAGE_MAP(CDiscardEditDlg,CDialog)謝謝閱讀ON_EN_CHANGE(IDC_DSUM_EDIT,&CDiscardEditDlg::OnEnChangeDsumEdit)感謝閱讀END_MESSAGE_MAP()voidCDiscardEditDlg::OnOK()感謝閱讀{UpdateData(TRUE);if(m_dsum<0){MessageBox("請輸入折算金額");return;}if(m_reason==""){MessageBox("請輸入報(bào)廢原因");return;}CDiscarddis;dis.Aid=m_aid;dis.DSum=m_dsum;dis.Reason=m_reason;dis.EmpName=m_empname;dis.CreateDate=m_createdate;謝謝閱讀dis.sql_Insert();CDialog::OnOK();}voidCDiscardEditDlg::OnEnChangeDsumEdit()謝謝閱讀{

}11.用戶管理界面代碼設(shè)計(jì)#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;謝謝閱讀#endifCUserManDlg::CUserManDlg(CWnd*pParent/