【文章內(nèi)容簡(jiǎn)介】
否結(jié)算號(hào)VchSettleCode字符型可讀可寫(xiě)否結(jié)算方式編號(hào)VchTransID字符型可讀可寫(xiě)否往來(lái)業(yè)務(wù)編號(hào)ItemID字符型可讀可寫(xiě)否核算項(xiàng)目ID:如果科目有多個(gè)核算項(xiàng)目,則核算項(xiàng)目ID用逗號(hào)隔開(kāi)傳入,例如:212,552ExchangeRate雙精度型可讀可寫(xiě)否對(duì)應(yīng)傳入幣別的匯率:如果傳入?yún)R率則必須大于0,不傳入則從KIS系統(tǒng)取傳入幣別對(duì)應(yīng)的匯率三、clsDataBase類(lèi)屬性和方法說(shuō)明(1)clsDataBase類(lèi)屬性列表屬性名稱(chēng)類(lèi)型讀寫(xiě)性必填備注Conn可讀不可寫(xiě)否數(shù)據(jù)庫(kù)連接對(duì)象(2)clsDataBase類(lèi)方法列表函數(shù)或者過(guò)程名稱(chēng)返回類(lèi)型參數(shù)說(shuō)明備注BeginTrans無(wú)無(wú)參數(shù)開(kāi)始一個(gè)事務(wù)InitConnection無(wú)strConnectionString為數(shù)據(jù)庫(kù)連接字符串初始化數(shù)據(jù)庫(kù)連接對(duì)象CommitTrans無(wú)無(wú)參數(shù)提交一個(gè)事務(wù)RollBackTrans無(wú)無(wú)參數(shù)回滾一個(gè)事務(wù)調(diào)用示列Private sub cmdSave_Click()Dim objCn As Object Dim strConn As String Dim i As Integer Dim strErrorNum As StringDim strErrorD