给用户做出展示用户只知道当前账户提现扣款并不知道回收金的去向这一节我们就要实现回收金记录的查询添加、查询、展示

功能分析

要实现这些功能我们需要新建一张表根据当前用户绑定的信息去填充对应的信息把提现的银行卡提现状态提现时间提现金额都先添加到表里在用户进入提现记录页面之后通过userid去查询当前用户的记录然后在列表里进行展示

代码实现

[{fieldName:id,sortType:ASC}]}],permissions:

[{role:

}我们生成对应的实体和db类之后在提现成功的提交记录里把我们表需要的信息添加进去

let

withdrawal_record()record.idMath.floor(Math.random()

1000000)record.user_idthis.user!.user_idrecord.bank_namethis.bankList[0].bank_namerecord.bank_numthis.bankList[0].bank_cardrecord.creat_timethis.year-this.month-this.day

this.timerecord.type_str0record.moneythis.moneyNumlet

status

databaseZone.upsert(record);添加完成之后我们新建一个提现记录展示页面

Entry

,backButton:true})}.backgroundColor(#F1F3F5).height(100%).width(100%)}

State

withdrawalRecordList:WithdrawalRecord[][]async

aboutToAppear():

cloudDatabase.zone(default);let

condition

cloudDatabase.DatabaseQuery(withdrawal_record);condition.equalTo(user_id,

listData

databaseZone.query(condition);let

json

{this.withdrawalRecordListdata}}然后把我们查询到的数据展示到列表组件中

List({space:10}){ForEach(this.withdrawalRecordList,(item:WithdrawalRecord,index:number){ListItem(){Column({space:10}){Row(){Text(item.type_str0?提现成功:提现中).fontColor(item.type_str0?Color.Green:Color.Black).fontSize(16).fontWeight(FontWeight.Bold)Text(¥item.money).fontSize(16).fontWeight(FontWeight.Bold).fontColor(Color.Black)}.width(100%).justifyContent(FlexAlign.SpaceBetween)Row(){Text(item.bank_name

(item.bank_num)).fontColor(Color.Black).fontSize(14).fontWeight(FontWeight.Bold)Text(item.creat_time).fontSize(14).fontWeight(FontWeight.Bold).fontColor(Color.Grey)}.width(100%).justifyContent(FlexAlign.SpaceBetween)}.padding(10).width(100%).borderRadius(10).backgroundColor(Color.White)}})}.padding(10)现在让我们运行代码查看效果