固定资产管理系统

1、PAGE PAGE 77 目录TOC o 1-3 h u HYPERLINK l _Toc352183431 一摘要 PAGEREF _Toc352183431 h 2 HYPERLINK l _Toc352183432 1.背景说明 PAGEREF _Toc352183432 h 2 HYPERLINK l _Toc352183433 2.设计目的 PAGEREF _Toc352183433 h 2 HYPERLINK l _Toc352183434 3.需求分析 PAGEREF _Toc352183434 h 2 HYPERLINK l _Toc352183435 二固定资产管管理系统概述

2、述 PAGEREF _Toc352183435 h 3 HYPERLINK l _Toc352183436 1.设计内容 PAGEREF _Toc352183436 h 3 HYPERLINK l _Toc35221834337 2.设计特点点 PAGEREF _Toc352183437 h 3 HYPERLINK l _Toc352183438 三固定资产管管理系统数据据库分析与设设计 PAGEREF _Toc352183438 h 3 HYPERLINK l _Toc352183439 1.系统的功能能模块图 PAGEREF _Toc352183439 h 3 HYPERLINK l _T

3、oc352183440 2.数据库结构构设计 PAGEREF _Toc352183440 h 4 HYPERLINK l _Toc352183441 3.概念模型设设计（E-RR图） PAGEREF _Toc352183441 h 6 HYPERLINK l _Toc352183442 四窗体实现与与设计8 HYPERLINK l _Toc352183443 1.登陆界面8 HYPERLINK l _Toc352183444 2.主界面 PAGEREF _Toc352183444 h 110 HYPERLINK l _Toc352183445 3.部门信息管管理界面 PAGEREF _Toc3

4、52183445 h 15 HYPERLINK l _Toc352183446 4.资产类别管管理界面 PAGEREF _Toc352183446 h 18 HYPERLINK l _Toc352183447 5.固定资产信信息编辑界面面 PAGEREF _Toc352183447 h 20 HYPERLINK l _Toc352183448 6.固定资产信信息管理界面面 PAGEREF _Toc352183448 h 24 HYPERLINK l _Toc352183449 7.固定资产分分配界面 PAGEREF _Toc352183449 h 28 HYPERLINK l _Toc3521

5、83450 8.固定资产变变更界面 PAGEREF _Toc352183450 h 30 HYPERLINK l _Toc33521833451 9.固定资产产折旧界面 PAGEREF _Toc352183451 h 32 HYPERLINK l _Toc352183452 10.固定资产产报废界面 PAGEREF _Toc352183452 h 35 HYPERLINK l _Toc352183453 11.用户管理理界面 PAGEREF _Toc352183453 h 37 HYPERLINK l _Toc352183454 12.修改密码码界面39 HYPERLINK l _Toc352

6、183455 五结论与体会会 PAGEREF _Toc352183455 h 41一摘要背景说明随着社会经济的的不断发展，企企业规模越来来越大，资产产越来越多，资资产管理就显显得非常困难难。固定资产产成为每个企企业不可缺少少的重要部分分，加强固定定资产管理，可可以优化企业业资源配置，本本系统适用与与中小型企业业及政府机关关、学校等。主主要维护固定定资产的登记记、清理、借借出和还入、维维修、折旧等等信息，实现现设备的日常常管理功能，通通过一系列查查询功能，可可方便获知每每一件固定资资产的状态及及当前所处位位置，具有操操作简单，界界面友善，灵灵活性好，系系统安全性高高，运行稳定定等特点，保保证了企

7、业中中的每一件物物品发挥其最最大效力。2.设计目的 在程序设计中，可可以用两种方方法解决问题题：一是传统统的结构化程程序设计方法法，二是更先先进的面向对对象程序设计计方法。在结构化程序设设计中关键是是如何将问题题域中的行为为（即操作）抽抽取出来，作作为C+程序中中的函数。由由于多个函数数均需要访问问某些数据，这这些数据常被被设计为全局局变量。而在面向对象程程序设计中关关键是如何将将问题域中的的实体（即日日常所见的概概念）抽取出出来，作为CC+程序中中的类，而属属性与行为作作为类的两类类要素通常是是必不可少的的，甚至还应应考虑类必须须满足的约束束。3.需求分析基本信息的添加加、修改、删删除和查询

8、。基基本信息包括括部门信息和和固定资产类类型信息。 资产产信息管理包包括固定资产产的录入、分分配、变更、折折旧和报废等等功能。统计查询功能包包括部门资产产统计表和分分类资产统计计表。二固定资产管管理系统概述述1.设计内容 (1) 系统信信息设置模块块：包括部门门管理，类别别管理和退出出系统 (2) 固定资资产管理模块块理模块，包包括信息编辑辑，资产分配配，资产变更更，资产折旧旧，资产报废废等(3) 系统用用户管理模块块，包括用户户管理和修改改密码2.设计特点后台数据库使用用SQL SServerr，前台开发发工具使用VVisuall C+。本系统采用目前比较流行的ADO数据访问技术，并将每个数

9、据库表的字段和操作 封装到类中，从而成功地将面向对象的程序设计思想应用到数据库应用程序设计中。这也是本系统的特色和优势。三固定资产管理系统数据库分析与设计1.系统的功能能模块图 图2.11 固定定资产管理系系统功能模块块示意图 2.数据库结构构设计 数据库中包含66个表，即部部门信息表DDeparttmentss、资产分类类信息表Tyypes、资资产信息表AAssetss、资产分配配表Disttributte、设备报报废表Disscard和和用户信息表表Userss等。 表Assetss列名数据类型允许为空Aidvarcharr(30)不允许Anamevarcharr(50)不允许TypeId

10、int允许Modelvarcharr(30)允许Produceervarcharr(100)允许UseDateevarcharr(20)允许UsedYeaarint允许OrgPriccedecimall(15,22)允许Ratiodecimall(7,5)允许Statusvarcharr(30)允许AddWayvarcharr(30)允许IsAudittint允许PostDatteVarcharr(20)允许IsDiscoounttinyintt允许 表Departtmentss列名数据类型允许为空DepIdint不允许DepNameevarcharr(40)不允许 表Discarrd列名数据

11、类型允许为空Aidvarcharr(30)允许DSumfloat允许Reasonvarcharr(200)允许CreateDDatevarcharr(30)允许EmpNameevarcharr(40)允许Checkerrvarcharr(40)允许CheckDaatevarcharr(40)允许StatusChar(4)允许表Distriibute列名数据类型允许为空Aidvarcharr(30)允许DepIdint允许EmpNameevarcharr(50)允许CreateDDatevarcharr(30)允许表Types列名数据类型允许为空TypeIdint不允许TypeNammevarc

12、harr(30)不允许表Users列名数据类型允许为空UseraNaame varcharr(40)不允许EmpNameevarcharr(40)允许UserPwddvarcharr(40)允许UserTyppevarcharr(20)允许3.概念模型设设计（E-RR图）资产编号资产编号固定资产固定资产资产名称类型状态型号生产厂商使用日期使用年限用户用户名用户密码用户用户名用户密码用户类别部门部门名称负责人部门固定资产管理1m固定资产变更固定资产变更分配折旧报废部门用户创建日期残值率使用月份报废原因状态mnmnmn四窗体实现与与设计1.登陆界面代码设计#includde stdaffx.h#i

13、ncludde AsseetsMann.h#includde LogiinDlg.h#includde Userrs.h#ifdef _DEBUUG#definee new DEEBUG_NNEW#undef THIS_FILEstatic char TTHIS_FFILE = _FILE_;#endifCLoginDDlg:CCLoginnDlg(CCWnd* pPareent /*=NULLL*/): CDiaalog(CCLoginnDlg:IDD, pPareent)count = 0;m_Pwd = _T();m_UserrName = _T();void CLLoginDDlg:D

14、DoDataaExchaange(CCDataEExchannge* ppDX)CDialoog:DooDataEExchannge(pDDX);DDX_TText(ppDX, IIDC_PWWD_EDIIT, m_Pwd);DDX_Teext(pDDX, IDDC_USEERNAMEE_EDITT, m_UUserNaame);BEGIN_MMESSAGGE_MAPP(CLogginDlgg, CDiialog)ON_EN_CHANGGE(IDCC_USERRNAME_EDIT, &CLooginDllg:OnnEnChaangeUssernammeEditt)ON_EN_CHANGGE(I

15、DCC_PWD_EDIT, &CLooginDllg:OnnEnChaangePwwdEditt)END_MESSSAGE_MAP()void CLLoginDDlg:OOnOK() UpdateeData(TRUE);if (m_UserNName = )MessaageBoxx(请输入用户户名?);returrn;if (m_Pwd = )MessaageBoxx(请输入密码码);returrn;CUserss userr;user.GGetDatta(m_UUserNaame);if (usser.UsserPwdd != mm_Pwd)MessaageBoxx(用户信息不不正确，无法法

16、登录！);countt+;if(coount = 3)MesssageBoox(已经连续3次登录失败败，将退出系系统);OnCaancel();returrn;CDialoog:OnnOK();void CLLoginDDlg:OOnEnChhangeUUsernaameEdiit()void CLLoginDDlg:OOnEnChhangePPwdEdiit()2.主界面代码设计#includde stdaafx.h#includde AsseetsMann.h#includde Asseets.h#includde ADOCConn.hh#ifdef _DEBUUG#undef THIS_

17、FILEstatic char TTHIS_FFILE=_FIILE_;#definee new DEEBUG_NNEW#endifCAssetss:CAsssets()Aid = ;Aname = ;Model = ;Produccer = ;UsedYeear = 1;OrgPriice = 0;Ratio = 0;Statuss = 未使用;AddWayy = ;IsAudiit = 00;IsDisccount = 0;CAssetss:CAAssetss()void CCAssetts:sqql_Inssert()tryADOCoonn m_AdoCoonn;CStriing cSS

18、ql,cDDate,ccOrgPrrc,cRaatio,ccTypeIId,cYeear;_bstrr_t bSSql;cOrgPPrc.Foormat(%f,OOrgPriice);cRatiio.Forrmat(%f,RRatio);cTypeeId.Foormat(%d,TTypeIdd);cYearr.Formmat(%d,UssedYeaar);CTimee t = CTimee:GettCurreentTimme();cDatee.Formmat(_TT(%044d-%022d-%022d),tt.GetYYear(),t.GeetMontth(),tt.GetDDay();cSq

19、ql = Inserrt Intto Asssets(AAid,Anname,TTypeIdd,Modeel,Prooducerr,;cSql += UUseDatte,UseedYearr,OrgPPrice,Ratioo,;cSql += SStatuss,AddWWay,IssAuditt,PosttDate, IsDiiscounnt) Vaalues(;cSql += Aiid+,+Anname+,+ccTypeIId+,+Moddel+,+PProduccer+,;cSql += UsseDatee+,+cYeaar+,+cOrggPrc+,;cSql += cRRatio+,未使

20、用用,+AAddWayy+,00,+ccDate+, 00);bSql = (LPPCTSTRR)(_bsstr_t)cSql;m_AdooConn.ExecuuteSQLL(bSqll);m_AAdoConnn.ExiitConnnect();catchh(_comm_erroor e)AfxxMessaageBoxx(e.Deescripption();void CAAssetss:sqll_Updaate(CSStringg cId)tryADOOConn m_AdooConn;CSttring cDatee,cOrggPrc,ccRatioo,cTyppeId,ccYear;_bstr

21、r_t bSSql;cOrgPPrc.Foormat(%f,OOrgPriice);cRatiio.Forrmat(%f,RRatio);cTypeeId.Foormat(%d,TTypeIdd);cYearr.Formmat(%d,UssedYeaar);CTiime t = CTiime:GGetCurrrentTTime();cDatee.Formmat(_TT(%044d-%022d-%022d),tt.GetYYear(),t.GeetMontth(),tt.GetDDay();bSqql = Updatte Asssets SSet Aiid=+Aid+,Anaame=+Anamm

22、e+,+TyypeId=+cTyypeId+,Moddel=+Modeel+,Produucer=+Prooducerr+,+UsseDatee=+UUseDatte+,UsedYYear=+cYeaar+,OOrgPriice=+cOrgPPrc+,+Raatio=+cRattio+, AddWWay=+AddWWay+,+PoostDatte=+cDatee+ WWhere Aid=+cIdd + ;m_AdooConn.ExecuuteSQLL(bSqll);m_AddoConnn.ExittConneect();catchh(_comm_erroor e)AfxMMessaggeBox

23、(e.Desscripttion();void CAAssetss:sqll_Deleete(CSStringg cId)tryADOOConn m_AdooConn;_bsstr_t bSql;bSql = Deelete From Assetts Wheere Aiid= + cIdd + ;m_AdooConn.ExecuuteSQLL(bSqll);m_AAdoConnn.ExiitConnnect();catchh(_comm_erroor e)AfxxMessaageBoxx(e.Deescripption();void CAAssetss:sqll_Channge(CSStrin

24、gg cId)tryADOOConn m_AdooConn;CSttring cRatiio, cYYear;_bstrr_t bSSql;cRatiio.Forrmat(%f,RRatio);cYearr.Formmat(%d,UssedYeaar);bSqql = Updatte Asssets SSet UssedYeaar= + cYeaar + , Rattio= + cRaatio + , + IsAuudit=22 Wherre Aidd= + cId + ;m_AdooConn.ExecuuteSQLL(bSqll);m_AAdoConnn.ExiitConnnect();ca

25、tch(_com_errorr e)AfxMeessageeBox(ee.Desccriptiion();void CAAssetss:sqll_Audiit(CSttring cId)tryADOCConn mm_AdoCConn;_bstrr_t bSSql;bSqql = Updatte Asssets SSet IssAuditt=1 Whhere AAid=+cId+;m_AdooConn.ExecuuteSQLL(bSqll);m_AAdoConnn.ExiitConnnect();catchh(_comm_erroor e)AfxMMessaggeBox(e.Desscriptt

26、ion();void CAAssetss:sqll_Stattus(CSStringg cId)tryADOOConn m_AdooConn;_bstrr_t bSSql;bSqql = Updatte Asssets SSet Sttatus= + Statuus + Wheere Aiid=+cId+;m_AdooConn.ExecuuteSQLL(bSqll);m_AddoConnn.ExittConneect();catchh(_comm_erroor e)AfxMeessageeBox(ee.Desccriptiion();int CAsssets:HaveeAid(CCStrinn

27、g cAiid)trylong lRscnnt = 00;_RecoordsettPtr mm_pReccordseet;ADOOConn m_AdooConn;_bstrr_t bSSQL;bSQL = Seelect * Froom Asssets WWhere Aid= + ccAid + ;m_ppRecorrdset = m_AAdoConnn.GettRecorrdSet(bSQL);if (m_pRRecorddset-adoEOOF)retuurn -11;elseretuurn 1;m_AddoConnn.ExittConneect();catchh(_comm_erroor

28、 e)AfxxMessaageBoxx(e.Deescripption();returnn -1;int CAsssets:HaveeName(CStriing cAAname)trylong lRscnnt = 00;_RecoordsettPtr mm_pReccordseet;ADOOConn m_AdooConn;_bstrr_t bSSQL;bSQL = Seelect * Froom Asssets WWhere Anamee= + cAnaame + ;m_pReecordsset = m_AdooConn.GetReecordSSet(bSSQL);if (m_pReecord

29、sset-aadoEOFF)retuurn -11;elseretuurn 1;m_AAdoConnn.ExiitConnnect();catchh(_comm_erroor e)AfxMMessaggeBox(e.Desscripttion();returnn -1;void CAAssetss:BegginDisscountt(CStrring ccId)tryADOCoonn m_AdoCoonn;_bstrr_t bSSql;bSqql = Updatte Asssets SSet IssDiscoount=11 Wherre Aidd=+ccId+;m_AdooConn.Execuu

30、teSQLL(bSqll);m_AAdoConnn.ExiitConnnect();catchh(_comm_erroor e)AfxMMessaggeBox(e.Desscripttion();3.部门信息管管理界面代码设计#includde stdaafx.h#includde AsseetsMann.h#includde DepttDlg.hh#includde Depaartmennts.h#ifdef _DEBUUG#definee new DEEBUG_NNEW#undef THIS_FILEstatic char TTHIS_FFILE = _FILE_;#endifCDeptD

31、llg:CDDeptDllg(CWnnd* pPParentt /*=NNULL*/): CDiaalog(CCDeptDDlg:IIDD, ppParennt)m_DepttName = _T();void CDDeptDllg:DooDataEExchannge(CDDataExxchangge* pDDX)CDialoog:DooDataEExchannge(pDDX);DDX_Coontroll(pDX, IDC_ADODCC1, m_AdoDeept);DDX_Teext(pDDX, IDDC_EDIIT1, mm_DepttName);DDX_Coontroll(pDX, IDC_

32、DATALLIST1, m_DaataDeppt);BEGIN_MMESSAGGE_MAPP(CDepptDlg, CDiaalog)ON_BN_CLICKKED(IDDC_ADDD_BUTTTON, OOnAddBButtonn)ON_BN_CLICKKED(IDDC_MODDI_BUTTTON, OnModdiButtton)ON_BN_CLICKKED(IDDC_DELL_BUTTTON, OOnDelBButtonn)ON_EN_CHANGGE(IDCC_EDITT1, &CCDeptDDlg:OOnEnChhangeEEdit1)END_MESSSAGE_MAP()BEGIN_EEV

33、ENTSSINK_MMAP(CDDeptDllg, CDDialogg)ON_EVEENT(CDDeptDllg, IDDC_DATTALISTT1, -6600 /* Clicck */, OnCllickDaatalisst1, VVTS_NOONE)END_EVVENTSIINK_MAAP()void CDDeptDllg:OnnClickkDatallist1() m_DeptNName = m_DaataDeppt.GettText();cDepId = m_DDataDeept.GeetBounndTextt();cDepNammeOld = m_DDataDeept.GeetTe

34、xtt();UpdateDData(FFALSE);void CDDeptDllg:OnnAddBuutton() UpdatteDataa(TRUEE);if (mm_DepttName = )MessaageBoxx(请输入部门门名称);returrn;CDepaartmennts cDDep;cDep.DDepNamme = mm_DepttName;if (ccDep.HHaveNaame(m_DeptNName) = 1)MessaageBoxx(已经存在此此部门信息!);elsecDep.sql_IInsertt();m_AdooDept.Refreesh();void CDDep

35、tDllg:OnnModiBButtonn() UpdateeData(TRUE);if (mm_DataaDept.GetTeext() = )MessaageBoxx(请选择要修修改的部门名名称);returrn;if (mm_DepttName = )MessaageBoxx(请输入部门门名称);returrn;if(cDeepNameeOld != m_DDeptNaame)CDepaartmennts cDDept;cDeptt.DepNName = m_DeeptNamme;if (ccDept.HaveNName(mm_DepttName) = 11)MesssageBoox(新

36、的部门名名称已经存在在);elsecDeppt.sqll_Updaate(cDDepId);m_AddoDeptt.Refrresh();void CDDeptDllg:OnnDelBuutton() if (m_DataDDept.GGetTexxt() = )MessaageBoxx(请选择要删删除的部门名名称);returrn;CDepaartmennts cDDep;cDep.ssql_Deelete(cDepIId);m_AdoDDept.RRefressh();void CDDeptDllg:OnnEnChaangeEddit1()4.资产类别管管理界面代码设计#includde

37、stdaafx.h#includde AsseetsMann.h#includde TypeeDlg.hh#includde Typees.h#ifdef _DEBUUG#definee new DEEBUG_NNEW#undef THIS_FILEstatic char TTHIS_FFILE = _FILE_;#endifCTypeDllg:CTTypeDllg(CWnnd* pPParentt /*=NNULL*/): CDiaalog(CCTypeDDlg:IIDD, ppParennt)m_TypeeName = _T();void CTTypeDllg:DooDataEExchan

38、nge(CDDataExxchangge* pDDX)CDialoog:DooDataEExchannge(pDDX);DDX_Coontroll(pDX, IDC_ADODCC1, m_AdoTyype);DDX_Coontroll(pDX, IDC_DATALLIST1, m_DaataTyppe);DDX_Teext(pDDX, IDDC_EDIIT1, mm_TypeeName);BEGIN_MMESSAGGE_MAPP(CTyppeDlg, CDiaalog)ON_BNN_CLICCKED(IIDC_ADDD_BUTTTON, OnAdddButtoon)ON_BN_CLICKKED

39、(IDDC_MODDI_BUTTTON, OnModdiButtton)ON_BN_CLICKKED(IDDC_DELL_BUTTTON, OOnDelBButtonn)END_MESSSAGE_MAP()BEGIN_EEVENTSSINK_MMAP(CTTypeDllg, CDDialogg)ON_EVEENT(CTTypeDllg, IDDC_DATTALISTT1, -6600 /* Clicck */, OnCllickDaatalisst1, VVTS_NOONE)END_EVEENTSINNK_MAPP()void CTTypeDllg:OnnClickkDatallist1()

40、m_TypeeName = m_DDataTyype.GeetTextt();cTypeIId = mm_DataaType.GetBooundTeext();cTypeNNameOlld = mm_DataaType.GetTeext();UpdateeData(FALSEE);void CTTypeDllg:OnnAddBuutton() UpdatteDataa(TRUEE);if (m_TypeNName = )MessaageBoxx(请输入类别别名称);returrn;CTypees objj;obj.TyypeNamme = mm_TypeeName;if(objj.HaveeN

41、ame(m_TyppeNamee) = 1)MessaageBoxx(此类别名称称已经存在！);elseobj.ssql_Innsert();m_AdooType.Refreesh();void CTTypeDllg:OnnModiBButtonn() UpdateeData(TRUE);if (m_DataTType.GGetTexxt() = )MessaageBoxx(请选择要修修改的类别名名称);returrn;if (mm_TypeeName = )MessaageBoxx(请输入类别别名称);returrn;if(cTyypeNammeOld!=m_TyypeNamme)CType

42、es objj;obj.TTypeNaame = m_TyppeNamee;if (oobj.HaaveNamme(m_TTypeNaame) = 1)MesssageBoox(此类别名称称已经存在！);elseobj.sql_UUpdatee(cTyppeId);m_AddoTypee.Refrresh();void CTTypeDllg:OnnDelBuutton() CTypess obj;obj.sqql_Dellete(ccTypeIId);m_AdoTType.RRefressh();5.固定资产信信息编辑界面面代码设计#includde stdaafx.h#includde As

43、seetsMann.h#includde AsseetsEdiitDlg.h#includde Asseets.h#ifdef _DEBUUG#definee new DEEBUG_NNEW#undef THIS_FILEstatic char TTHIS_FFILE = _FILE_;#endifCAssetssEditDDlg:CCAssettsEdittDlg(CCWnd* pPareent /*=NULLL*/): CDiaalog(CCAssettsEdittDlg:IDD, pPareent)m_Aid = _T();m_Anamme = _T();m_Modeel = _T();

44、m_Prodducer = _T();m_RepPPersonn = _TT();m_UseYYear = 0;m_OrgPPrice = 0.00f;m_Ratiio = 00.0f;m_PosttDate = _T();m_UseDDate = COleeDateTTime:GetCuurrenttTime();m_Stattus = _T();void CAAssetssEditDDlg:DDoDataaExchaange(CCDataEExchannge* ppDX)CDialoog:DooDataEExchannge(pDDX);DDX_Coontroll(pDX, IDC_ADDW

45、AAY_COMMBO, mm_AddWWay);DDX_Coontroll(pDX, IDC_ADODCC1, m_adodcc1);DDX_Teext(pDDX, IDDC_AIDD_EDITT, m_AAid);DDX_Teext(pDDX, IDDC_ANAAME_EDDIT, mm_Anamme);DDX_Coontroll(pDX, IDC_TYPE_DATACCOMBO, m_Tyype);DDX_Teext(pDDX, IDDC_MODDEL_EDDIT, mm_Modeel);DDX_Teext(pDDX, IDDC_PROODUCERR_EDITT, m_PProduccer

46、);DDX_Teext(pDDX, IDDC_USEEYEAR_EDIT, m_UsseYearr);DDX_Teext(pDDX, IDDC_ORGGPRICEE_EDITT, m_OOrgPriice);DDX_Teext(pDDX, IDDC_RATTIO_EDDIT, mm_Ratiio);DDX_Teext(pDDX, IDDC_POSSTDATEE_STATTIC, mm_PosttDate);DDX_DaateTimmeCtrll(pDX, IDC_USEDAATE, mm_UseDDate);DDX_Teext(pDDX, IDDC_STAATUS_EEDIT, m_Staat

47、us);BEGIN_MMESSAGGE_MAPP(CAsssetsEdditDlgg, CDiialog)ON_EN_CHANGGE(IDCC_AID_EDIT, &CAsssetsEEditDllg:OnnEnChaangeAiidEditt)END_MESSSAGE_MAP()BOOL CAAssetssEditDDlg:OOnInittDialoog() CDialoog:OnnInitDDialogg();if(cAiid = )CTiime t = CTiime:GGetCurrrentTTime();CStriing cDDate;cDatee.Formmat(_TT(%044d-

48、%022d-%022d),tt.GetYYear(),t.GeetMontth(),tt.GetDDay();m_PosstDatee = cDDate;m_UseeDate.SetDaate(t.GetYeear(),t.GettMonthh(),t.GetDaay();m_AdddWay.SSetCurrSel(00);elseCStriing cIItem;cItemm = ;for(iint i = 0; i ShhowWinndow(SSW_HIDDE);RefreeshDatta();returnn TRUEE; /void CAAssetssSelecctDlg:OnSeelch

49、anngeTyppeCombbo() int iSSel;iSel = m_tyype.GeetCurSSel(); m_searrch.SeetTextt();if (iSSel = 1)m_Adoodc2.SSetReccordSoource(SELEECT * FROM Typess);m_Adoodc2.RRefressh();m_ssearchh.SetLListFiield(TypeNName);m_seaarch.SSetBouundCollumn(TypeIId);m_seaarch.RRefressh();GettDlgIttem(IDDC_SEAARCH_DDATACOOM

50、BO)-ShowwWindoow(SW_SHOW);elseGettDlgIttem(IDDC_SEAARCH_DDATACOOMBO)-ShowwWindoow(SW_HIDE);UpdateeData(FALSEE);RefresshDataa();BEGIN_EEVENTSSINK_MMAP(CAAssetssSelecctDlg, CDiaalog) ON_EEVENT(CAsseetsSellectDllg, IDDC_SEAARCH_DDATACOOMBO, -600 /* Cllick */, OnnClickkSearcchDataacomboo, VTSS_I2)END_EV

51、EENTSINNK_MAPP()void CAAssetssSelecctDlg:OnCllickSeearchDDatacoombo(sshort Area) cSearrchVallue = m_seaarch.GGetBouundTexxt();RefresshDataa();void CAAssetssSelecctDlg:OnOKK() AssetssId = m_DattaGridd.GetIItem(00);AssetssName = m_DDataGrrid.GeetItemm(1);CDialoog:OnnOK();7.固定资产分分配界面代码设计#includde stdaa

52、fx.h#includde AsseetsMann.h#includde DisttributteEdittDlg.hh#includde AsseetsSellectDllg.h#includde Disttributte.h#includde Asseets.h#ifdef _DEBUUG#definee new DEEBUG_NNEW#undef THIS_FILEstatic char TTHIS_FFILE = _FILE_;#endifCDistriibuteEEditDllg:CDDistriibuteEEditDllg(CWnnd* pPParentt /*=NNULL*/):

53、 CDiaalog(CCDistrributeeEditDDlg:IIDD, ppParennt)m_asseets = _T();m_namee = _TT();m_datee = COOleDatteTimee:GettCurreentTimme();m_aid = _T();void CDDistriibuteEEditDllg:DooDataEExchannge(CDDataExxchangge* pDDX)CDialoog:DooDataEExchannge(pDDX);DDX_Coontroll(pDX, IDC_ADODCC1, m_adodcc);DDX_Teext(pDDX,

54、 IDDC_ASSSETS_EEDIT, m_asssets);DDX_Coontroll(pDX, IDC_DATACCOMBO11, m_ddep);DDX_Teext(pDDX, IDDC_NAMME_EDIIT, m_name);DDX_DaateTimmeCtrll(pDX, IDC_DATETTIMEPIICKER11, m_ddate);DDX_Teext(pDDX, IDDC_AIDD_EDITT, m_aaid);BEGIN_MMESSAGGE_MAPP(CDisstribuuteEdiitDlg, CDiaalog)ON_BN_CLICKKED(IDDC_BUTTTON1,

55、 OnBuutton11)ON_EN_CHANGGE(IDCC_NAMEE_EDITT, &CDDistriibuteEEditDllg:OnnEnChaangeNaameEdiit)END_MESSSAGE_MAP()BOOL CDDistriibuteEEditDllg:OnnInitDDialogg() CDialoog:OnnInitDDialogg();if(cAiid = )CTiime t = CTiime:GGetCurrrentTTime();m_datte.SettDate(t.GettYear(),t.GGetMonnth(),t.GettDay();elsem_depp

56、.SetBBoundTText(ccDepIdd);COlleVariiant vvtime(cDatee);vtimee.ChanngeTyppe(VT_DATE);COleDDateTiime tiime4(vvtime);m_datte.SettDate(time44.GetYYear(),timee4.GettMonthh(),tiime4.GGetDayy();GettDlgIttem(IDDC_BUTTTON1)-EnaableWiindow(FALSEE);UpdateeData(FALSEE);returnn TRUEE; void CDDistriibuteEEditDllg

57、:OnnButtoon1() UpdateeData(TRUE);CAssettsSeleectDlgg dlg;dlg.fllag = 1;if(dlgg.DoMoodal() = IIDOK)m_asssets = dlg.AssettsNamee;m_aidd = dllg.AsssetsIdd;UpdatteDataa(FALSSE);void CDDistriibuteEEditDllg:OnnOK() UpdateeData(TRUE);if(m_ddep.GeetBounndTextt() = )MessaageBoxx(请选择部门门);returrn;if(m_aaid = )

58、MessaageBoxx(请选择固定定资产);returrn;if(m_nname = )MessaageBoxx(请输入负责责人);returrn;CDistrributee dis;dis.DeepId = atoii(m_deep.GettBounddText();dis.EmmpNamee = m_name;dis.Aiid = mm_aid;dis.CrreateDDate = m_daate.Foormat(%Y-%m-%d);if(cAiid = )dis.ssql_Innsert();elsedis.ssql_Uppdate(cAid);CDialoog:OnnOK();voi

59、d CDDistriibuteEEditDllg:OnnEnChaangeNaameEdiit()8.固定资产变变更界面代码设计#includde stdaafx.h#includde AsseetsMann.h#includde AsseetsChggEditDDlg.h#includde Asseets.h#includde Disttributte.h#ifdef _DEBUUG#definee new DEEBUG_NNEW#undef THIS_FILEstatic char TTHIS_FFILE = _FILE_;#endifCAssetssChgEdditDlgg:CAssse

60、tsCChgEdiitDlg(CWnd* pParrent /*=NULLL*/): CDiaalog(CCAssettsChgEEditDllg:IDDD, pPParentt)m_aidd = _TT();m_anamme = _T();m_namee = _TT();m_ratiio = _T();m_useyyear = _T();void CAAssetssChgEdditDlgg:DoDDataExxchangge(CDaataExcchangee* pDXX)CDialoog:DooDataEExchannge(pDDX);DDX_Coontroll(pDX, IDC_ADODC