會(huì)計(jì)信息化課件

AccountingInformation

實(shí)現(xiàn)單表的增加、刪除、保存與檢索功能Single-tabletoadd,delete,saveandretrievefunctions

掌握會(huì)計(jì)軟件簡(jiǎn)單應(yīng)用開(kāi)發(fā)方法Tomasterasimpleaccountingsoftwareapplicationdevelopmentmethodology

學(xué)習(xí)目的與要求LearningObjectivesandRequirements3-5

會(huì)計(jì)軟件簡(jiǎn)單應(yīng)用開(kāi)發(fā)SimpleAccountingSoftwareApplicationDevelopment教學(xué)內(nèi)容5.1數(shù)據(jù)窗口控件簡(jiǎn)介AboutDataWindowcontrols

5.2

數(shù)據(jù)窗口控件函數(shù)DataWindowcontrolfunctions

5.3

工資管理案例簡(jiǎn)介WageManagementCaseIntroduction

5.4固定資產(chǎn)管理案例簡(jiǎn)介FixedAssetsManagementCaseIntroduction3-5

會(huì)計(jì)軟件簡(jiǎn)單應(yīng)用開(kāi)發(fā)3-5.1數(shù)據(jù)窗口控件簡(jiǎn)介數(shù)據(jù)的顯示——數(shù)據(jù)窗口控件Datadisplay-DataWindowControls

數(shù)據(jù)窗口控件是應(yīng)用程序在窗口中展示數(shù)據(jù)窗口對(duì)象中數(shù)據(jù)的唯一手段。數(shù)據(jù)窗口對(duì)象和數(shù)據(jù)窗口控件必須結(jié)合一起使用。

DataWindowcontrol,anapplicationtodisplaythedatainthewindow,astheonlymeansofdata.DataWindowobjectsandDataWindowcontrolsmustbeintegratetogether.3-5.1數(shù)據(jù)窗口控件簡(jiǎn)介數(shù)據(jù)窗口編程的基本過(guò)程數(shù)據(jù)源Connect()SetTransObiect()或SetTrans()打開(kāi)窗口，在窗口上布置數(shù)據(jù)窗口控件創(chuàng)建窗口對(duì)象Retrieve（）數(shù)據(jù)窗口在數(shù)據(jù)窗口控件的DataObject屬性中選擇數(shù)據(jù)窗口對(duì)象創(chuàng)建數(shù)據(jù)窗口對(duì)象定義數(shù)據(jù)庫(kù)與應(yīng)用程序相連接的事物對(duì)象將數(shù)據(jù)窗口控件與事務(wù)對(duì)象關(guān)聯(lián)數(shù)據(jù)庫(kù)中數(shù)據(jù)裝入數(shù)據(jù)窗口將數(shù)據(jù)窗口控件與數(shù)據(jù)對(duì)象相關(guān)聯(lián)3-5.1數(shù)據(jù)窗口控件簡(jiǎn)介在窗口上布置數(shù)據(jù)窗口控件Inthewindowlayoutofdatawindowcontrol2.點(diǎn)擊小三角，展開(kāi)窗口控件Clickthesmalltriangletostartthewindowcontrols

5.在數(shù)據(jù)窗口的邊沿或四角，拖動(dòng)調(diào)整數(shù)據(jù)窗口的大小Inthedatawindowedgesorcorners,dragtoadjustthesizeofthedatawindow

3.點(diǎn)擊數(shù)據(jù)窗口控件ClickDataWindowControl

6.在數(shù)據(jù)窗口內(nèi)部，拖動(dòng)調(diào)整數(shù)據(jù)窗口的位置Inthedatawithinthewindow,dragthewindowtoadjustthelocationofthedata

1.創(chuàng)建或打開(kāi)窗口Tocreateoropenawindow4.在窗口上點(diǎn)擊，出現(xiàn)數(shù)據(jù)窗口控件Inthewindow,clickon,thereDataWindowControl

3-5.1數(shù)據(jù)窗口控件簡(jiǎn)介數(shù)據(jù)窗口控件屬性DataWindowcontrolproperties選擇關(guān)聯(lián)的數(shù)據(jù)窗口對(duì)象Selecttheassociateddatawindow具有控制菜單Hasacontrolmenu具有水平滾動(dòng)條Withthehorizontalscrollbar具有垂直滾動(dòng)條Withaverticalscrollbar分割數(shù)據(jù)窗口控件SplitDataWindowControl數(shù)據(jù)窗口控件的標(biāo)題DataWindowControlTitle

數(shù)據(jù)隨滾動(dòng)條的移動(dòng)而滾動(dòng)DatawiththeRolling具有最小化功能Hasthemaximumfunction具有最大化功能Hasthemaximumfunction具有標(biāo)題欄Withthetitlebar3-5.1數(shù)據(jù)窗口控件簡(jiǎn)介數(shù)據(jù)窗口控件事務(wù)對(duì)象DataWindowControltransactionobject

事務(wù)對(duì)象（TransactionObject）是一個(gè)不可見(jiàn)的對(duì)象，它包含了與數(shù)據(jù)庫(kù)連接的相關(guān)屬性參數(shù)。Transactionobject(TransactionObject)isaninvisibleobjectthatcontainsthedatabaseconnectionassociatedwiththeattributeparameter.

應(yīng)用程序與數(shù)據(jù)庫(kù)的連接通過(guò)事務(wù)對(duì)象來(lái)完成，在建立連接前需要給事務(wù)對(duì)象的相關(guān)屬性賦值，用嵌入式SQL語(yǔ)句CONNECT建立連接。PowerBuilder中缺省事務(wù)對(duì)象是SQLCA。Applicationandthedatabaseconnectionthroughthetransactionobjecttocompletetheconnectiontothetransactionobjectrequiredpriortoassignmentoftherelevantattributes,usingtheembeddedSQLstatementCONNECTtoestablishaconnection.PowerBuilderisthedefaulttransactionobjectSQLCA.

在數(shù)據(jù)庫(kù)連接之后，要使數(shù)據(jù)窗口控件能夠訪問(wèn)數(shù)據(jù)庫(kù)，還必須為數(shù)據(jù)窗口控件指定事務(wù)對(duì)象，使數(shù)據(jù)窗口控件明確究竟使用哪一個(gè)事務(wù)對(duì)象同數(shù)據(jù)庫(kù)進(jìn)行交互。使用函數(shù)SetTransObject進(jìn)行指定。Inthedatabaseconnection,theDataWindowcontroltobeabletomakeaccesstothedatabasemustalsobespecifiedfortheDataWindowcontrol,

transactionobject,sothatthedatawindow,whichcontrolswhethertheuseofaspecifictransactionobjecttointeractwiththedatabase.UsethefunctionSetTransObjecttospecifythat.3-5.1數(shù)據(jù)窗口控件簡(jiǎn)介何時(shí)調(diào)用函數(shù)SetTransObject()1.第一次連接數(shù)據(jù)庫(kù)2.在調(diào)用Retrieve()或Update()之前3.在動(dòng)態(tài)修改了一個(gè)數(shù)據(jù)窗口的數(shù)據(jù)對(duì)象之后何處調(diào)用SetTransObject()1.窗口的open事件2.數(shù)據(jù)窗口控件的事件（如clicked）3-5.1數(shù)據(jù)窗口控件簡(jiǎn)介WhentocallthefunctionSetTransObject()1.Thefirstconnecttothedatabase2.InthecalltoRetrieve()orUpdate()beforethe3.InthedynamicchangesofadatawindowafterthedataobjectWheretocallSetTransObject()1.Thewindowopenevent2.DataWindowcontrolevents(suchasclicked教學(xué)內(nèi)容5.1數(shù)據(jù)窗口控件簡(jiǎn)介AboutDataWindowcontrols

5.2

數(shù)據(jù)窗口控件函數(shù)

DataWindowcontrolfunctions

5.3

工資管理案例簡(jiǎn)介WageManagementCaseIntroduction

5.4固定資產(chǎn)管理案例簡(jiǎn)介FixedAssetsManagementCaseIntroduction3-5

會(huì)計(jì)軟件簡(jiǎn)單應(yīng)用開(kāi)發(fā)3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介檢索數(shù)據(jù)Retrieve()RetrievedataRetrieve()

可以使用檢索參數(shù)，也可以不使用Youcanusethesearchparameters,youcannotuse

例子（Example）:stringls_statels_state=ddlb_state.textdw_list.Retrieve(ls_state)Retrieve()的返回值（returnvalueof）

-1失敗(Fail)0無(wú)數(shù)據(jù)(Nodata)>0檢索到的數(shù)據(jù)行數(shù)(thenumberofrowsofdataretrieved)3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介修改、插入和刪除數(shù)據(jù)行Modify,insertanddeletedatarows

增加和修改列中的數(shù)據(jù)Toincreaseandmodifythedatainthecolumn

插入數(shù)據(jù)行InsertingRows

刪除數(shù)據(jù)行DeletingRows

過(guò)濾和排序Filteringandsorting3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介數(shù)數(shù)據(jù)類(lèi)型是否正確？Thenumberofdatatypescorrect?有效性規(guī)則是否滿足？Effectivenessoftherulessatisfied?是否發(fā)生改動(dòng)？Whethertherehasbeenchange?ItemChanged事件ItemChangedEvent移動(dòng)數(shù)據(jù)到主緩沖區(qū)中（函數(shù)Acceptext（）的使用）Mobiledatatothemainbuffer(FunctionAcceptext()use)修改數(shù)據(jù)Modifydata3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介InsertRow（row）函數(shù)InsertRow(row)function其中參數(shù)Row表示插入行的位置OneargumentRow,saidthelocationofinsertedrow在尾行增加一行(Inthelastlineaddaline:)：dw_1.insertrow(0)在第一行之前插入一行(Insertarowbeforethefirstline

):dw_1.InsertRow(1)在當(dāng)前行的后邊插入一行(Insertarowafterthisline

):dw_1.InsertRow(dw_emp.GetRow()+1)插入（增加）數(shù)據(jù)Insert(increase)data3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介Dw_1.deleterow()刪除指定的行調(diào)用格式：dw_control.DeleteRow(row)1——操作成功刪除行Deleterow-1——出現(xiàn)錯(cuò)誤返回值3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介舉例

Example

刪除當(dāng)前行(Deletethecurrentline):dw_emp.DeleteRow(0)或者dw_emp.DeleteRow(dw_emp.GetRow())

刪除最后一行(Deletethelastlineof)longRowNumRowNum=dw_emp.RowCount()dw_emp.DeleteRow(RowNum)選中數(shù)據(jù)行的高亮度顯示(Selecteddatarowsofhigh-brightnessdisplay)SelectRow()函數(shù)

dw_control.SelectRow(row)IsSelected()函數(shù)

State=dw_control.IsSelected(row)單擊事件的例子Examplesofclickevent高亮度顯示選中的行，原來(lái)高亮度行變?yōu)榉歉吡炼蕊@示(High-brightnessdisplaystheselectedrow,theoriginallineintoanon-high-brightnesshigh-brightnessdisplay):IFrow>0THENdw_1.SelectRow(0,FALSE)dw_1.SelectRow(row,TRUE)ENDIF3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介設(shè)置、獲取當(dāng)前行Setting,accesstothecurrentrowSetRow()使得指定行成為當(dāng)前行(makesthespecifiedrowintothecurrentrow)

調(diào)用格式(Callformat

):dw_control.SetRow(row)GetRow()得到當(dāng)前行的位置(getthelocationofthecurrentrow)返回一個(gè)長(zhǎng)整數(shù)類(lèi)型，說(shuō)明緩沖區(qū)中當(dāng)前行的編號(hào)Returnsalongintegertype,indicatingthebufferinthecurrentrownumber

調(diào)用格式(Callformat):dw_control.GetRow()3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介存取數(shù)據(jù)窗口緩沖區(qū)中數(shù)據(jù)值的方法Accesstodatawindowbuffermethodofdatavalues

使用數(shù)據(jù)窗口對(duì)象的數(shù)據(jù)表達(dá)式Theuseofthedatawindowobjectdataexpression

使用存取單行數(shù)據(jù)值的函數(shù)AccesstosingledatavaluesusingafunctionofGetItem()系列函數(shù)用來(lái)檢索數(shù)據(jù)值GetItem()functionisusedtoretrievethedatavalueseriesSetItem()函數(shù)把指定的值存放在緩沖區(qū)中SetItem()functiontospecifythevaluestoredinthebuffer3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介存取數(shù)據(jù)窗口緩沖區(qū)中數(shù)據(jù)值的方法AccesstodatawindowbuffermethodofdatavaluesGetItem()系列函數(shù)：從數(shù)據(jù)窗口某一行某一列中獲取數(shù)據(jù)(GetItem()familyfunction:alinefromthedatawindowtoobtainthedataofacolumn)

常用(Commonlyused

):GetItemString(行號(hào)，列號(hào)或者“列名”)GetItemString(linenumber,columnnumber,or"columnname")GetItemNumber(行號(hào)，列號(hào)或者“列名”

)GetItemNumber(linenumber,columnnumber,or"columnname"3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介GetItemDecimal()GetItemDate()GetItemDateTime()GetItemTime()其他數(shù)據(jù)類(lèi)型3-5.2數(shù)據(jù)窗口控件簡(jiǎn)介設(shè)置、獲取當(dāng)前行SetItem()存放指定值到數(shù)據(jù)窗口緩沖區(qū)中SetItem()storethespecifiedvaluetothedatawindowbuffer

SetItem(行，列，值):注意：數(shù)據(jù)類(lèi)型的匹配！例子:integerli_empidli_empid=100

dw_data.SetItem(row,"emp_id",li_empid)教學(xué)內(nèi)容5.1數(shù)據(jù)窗口控件簡(jiǎn)介

AboutDataWindowcontrols

5.2

數(shù)據(jù)窗口控件函數(shù)DataWindowcontrolfunctions

5.3

工資管理案例簡(jiǎn)介WageManagementCaseIntroduction

5.4固定資產(chǎn)管理案例簡(jiǎn)介FixedAssetsManagementCaseIntroduction3-5

會(huì)計(jì)軟件簡(jiǎn)單應(yīng)用開(kāi)發(fā)工資管理系統(tǒng)功能結(jié)構(gòu)圖碼表設(shè)置銀行設(shè)置扣稅設(shè)置獎(jiǎng)懲額度設(shè)置職員信息處理考勤信息處理基本工資計(jì)算變動(dòng)工資計(jì)算匯總工資計(jì)算工資匯總表查詢工資費(fèi)用分配表查詢銀行代發(fā)文件查詢個(gè)人所得稅扣繳表查詢生成工資費(fèi)用分配憑證生成扣稅憑證生成福利費(fèi)憑證密碼修改權(quán)限設(shè)置業(yè)務(wù)處理報(bào)表查詢憑證處理系統(tǒng)維護(hù)初始設(shè)置工資管理系統(tǒng)3-5.3工資管理案例簡(jiǎn)介工資管理系統(tǒng)業(yè)務(wù)流程圖其他部門(mén)相關(guān)部門(mén)人事部制定編制編制費(fèi)用分配表個(gè)人所得稅扣繳申請(qǐng)表福利費(fèi)計(jì)提分配表工資分?jǐn)倯{證扣稅憑證計(jì)提福利費(fèi)憑證財(cái)務(wù)處理系統(tǒng)分?jǐn)偣べY扣稅計(jì)提福利填制填制填制計(jì)算考勤信息獎(jiǎng)懲額度標(biāo)準(zhǔn)表職員信息表變動(dòng)工資表基本工資表工資表匯總銀行代發(fā)文件表銀行員工計(jì)算計(jì)算遞交代發(fā)工資計(jì)算3-5.3工資管理案例簡(jiǎn)介3-5.3工資管理案例簡(jiǎn)介工資管理系統(tǒng)數(shù)據(jù)流程圖E1其他部門(mén)P1輸入考勤信息S10考勤表P2繪制變動(dòng)工資表S1變動(dòng)工資表E3相關(guān)部門(mén)E4銀行P7制定獎(jiǎng)懲標(biāo)準(zhǔn)S9獎(jiǎng)懲額度表P4計(jì)算工資S2基本工資表P5編制基本工資表S8職員信息表P3輸入職員信息表E2人事部S3工資匯總表S6工資費(fèi)用分配表S5個(gè)人所得稅申報(bào)表P6憑證處理S4福利費(fèi)計(jì)提分配表S7工資轉(zhuǎn)賬憑證財(cái)務(wù)處理系統(tǒng)D1考勤記錄D2職員基本信息D4工資標(biāo)準(zhǔn)D3銀行代發(fā)文件教學(xué)內(nèi)容5.1數(shù)據(jù)窗口控件簡(jiǎn)介AboutDataWindowcontrols

5.2

數(shù)據(jù)窗口控件函數(shù)DataWindowcontrolfunctions

5.3

工資管理案例簡(jiǎn)介WageManagementC