|
![]() |
#1 |
Участник
|
Код: //ЗАПРОС ПО ТАБЛИЦЕ МОДЕЛЕЙ УЧЕТА qbds = this.query().dataSourceTable(tablenum(RAssetStandards)); qry = new Query(); qbds=qry.addDataSource(tablenum(RAssetStandards),'lbdt2'); //инв номер ОС qbr=qbds.addRange(fieldnum(RAssetStandards,AssetId)); strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,AssetId)).value(); qbr.value(strRangeValue); //срок жизни qbrLife=qbds.addRange(fieldnum(RAssetStandards,Lifetime)); strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,Lifetime)).value(); qbrLife.value(strRangeValue); //профиль разноски qbrProfile=qbds.addRange(fieldnum(RAssetStandards,PostingProfile)); strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,PostingProfile)).value(); qbrProfile.value(strRangeValue); //группа амортизации qbrGroup=qbds.addRange(fieldnum(RAssetStandards,AssetGroup)); strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,AssetGroup)).value(); qbrGroup.value(strRangeValue); //модель учета qbrStandard=qbds.addRange(fieldnum(RAssetStandards,assetStandardId)); strRangeValue = element.query().dataSourceTable(tablenum(RAssetStandards)).findRange(fieldnum(RAssetStandards,assetStandardId)).value(); qbrStandard.value(strRangeValue); excelDocument.InsertValue(ComExcelDocument_RU::numToNameCell(3,4), strRangeValue); //ЗАПРОС ПО ТАБЛИЦЕ ПРОВОДОК ОС qbdsAT = qbds.addDataSource(tablenum(RAssetTrans)); qbdsAT.fetchMode(JoinMode::INNERJOIN); qbdsAT.relations(true); qbdsAT.addLink(fieldnum(RAssetTrans, accountNum), fieldnum(RAssetStandards, assetId)); qbdsAT.addSortField(fieldnum(RAssetTrans, Voucher)); |
|