第五章代码.zip

import dataRdb from '@ohos.data.rdb' import router from '@system.router'; export default { data: { points: [], lineData: [], lineOps: { xAxis: { min: 0, max: 12, axisTick: 13, display: true, color: '#ffff0000' }, yAxis: { min: 0, max: 10000, axisTick: 5, display: true, color: '#ffff0000' }, series: { lineStyle: { width: "2px", smooth: true, }, headPoint: { shape: "circle", size: 10, strokeWidth: 2, fillColor: '#ffffff', strokeColor: '#007aff', display: true, }, loop: { margin: 2, gradient: true, } } }, txtTips: ['月账汇总', '收入管理', '支出管理', '记账设置'], noteType: ['收入', '支出'], info: '月账汇总', cIndex: 0, rtypes: [ { mainName: '职业收入', subName: '工资收入' }, { mainName: '职业收入', subName: '资金收入' }, { mainName: '职业收入', subName: '劳务收入' }, { mainName: '其他收入', subName: '礼金收入' }, { mainName: '其他收入', subName: '投资收入' }, ], //保存收入类别设置信息 ztypes: [ { mainName: '衣服饰品', subName: '衣服裤子' }, { mainName: '衣服饰品', subName: '鞋帽包包' }, { mainName: '衣服饰品', subName: '化妆饰品' }, { mainName: '食品酒水', subName: '菜品调料' }, { mainName: '食品酒水', subName: '早午晚餐' }, { mainName: '食品酒水', subName: '烟酒茶水' }, { mainName: '食品酒水', subName: '水果零食' }, { mainName: '居家物业', subName: '日常用品' }, { mainName: '居家物业', subName: '房租水电' }, { mainName: '居家物业', subName: '维修保养' }, { mainName: '其他杂项', subName: '人情送往' }, { mainName: '其他杂项', subName: '其他支出' }, ], //保存支出类别信息设置 mainName: '', //保存输入的一级类别 subName: '', //保存输入的二级类别 flag: false, notepadDB: '', //保存打开的数据库 rmanager: [], //保存收入管理页面一级类别 rmanagerdetail: [], //保存收入管理页面一级类别和二级类别信息 ramount: '', //保存输入的金额 rdate: '2020-09-09', //保存输入的金额 rmemo: '', //保存输入的备注 index: 0, //当前类别下标 ramounts: [50000, 5000, 4000, 6000, 7000, 5670, 3420, 8760, 7600, 8900, 7600, 3450], //月收入汇总 }, /*定义创建表方法*/ createTB(rdbStore, SQL_CREATE_TABLE) { rdbStore.executeSql(SQL_CREATE_TABLE, null).then(() => { console.info("创建表成功") }).catch((err) => { console.info("创建表失败" + err) }) }, /*定义插入表记录方法*/ insertRecord(db, tbName, valueBucket) { db.insert(tbName, valueBucket).then((ret) => { console.info("当前插入的记录ID: " + ret) }).catch((err) => { console.info("插入记录失败: " + err) }) }, //初始化线形图数据 initData(mamounts) { this.points = [] for (var i = 0;i < 12; i++) { var pvalue = mamounts[i] this.points.push( { value: pvalue, pointStyle: { shape: "circle", size: 10, strokeWidth: 2, fillColor: '#ffffff', strokeColor: '#007aff', display: true, }, description: pvalue + '', textLocation: 'top', textColor: '#ffff00ff' }) } this.lineData = [ { strokeColor: '#0081ff', fillColor: '#cce5ff', data: this.points, gradient: true } ] }, async onInit() { this.initData(this.ramounts) var date = new Date() //获取当前日期 this.rdate = date.getFullYear() + "-" + (date.getMonth() + 1) + "-" + date.getDate() //按年-月-日格式显示当前日期 var that = this const MALES_CONFIG = { name: "notepad.db" //数据库名称 } await dataRdb.getRdbStore(MALES_CONFIG, 1).then((rdbStore) => { console.info("创建数据库成功：") //创建收入类别表rtable var SQL_CREATE_TABLE = "create table if not exists rtable(id integer primary key autoincrement,mainName text not null,subName text not null)" that.createTB(rdbStore, SQL_CREATE_TABLE) //创建收入类别表 //创建支出类别表ztable SQL_CREATE_TABLE = "create table if not exists ztable(id integer primary key autoincrement,mainName text not null,subName text not null)" that.createTB(rdbStore, SQL_CREATE_TABLE) //创建支出类别表 SQL_CREATE_TABLE = "create table if not exists rdetail(id integer primary key autoincrement,mainName text not null,subName text not null,amount float,rq text,memo text)" that.createTB(rdbStore, SQL_CREATE_TABLE) //创建收入明细表 SQL_CREATE_TABLE = "create table if not exists zdetail(id integer primary key autoincrement,mainName text not null,subName text not null,amount float,rq text,memo text)" that.createTB(rdbStore, SQL_CREATE_TABLE) //创建支出明细表 that.notepadDB = rdbStore }).catch((err) => { console.info("创建数据库失败：" + err) }); }, /*定义切换tab事件*/ async changeTab(value) { this.rmanager = [] this.rmanagerdetail = [] this.info = this.txtTips[value] this.cIndex = value switch (value) { case 0: var detail = [] var amounts = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] await this.viewDetail("rDetail", detail) for (var i = 0;i < detail.length; i++) { var month = new Date(detail[i].rq).getMonth() amounts[month] = amounts[month] + detail[i].amount } for (var i = 0;i < amounts.length; i++) { console.info("amounts" + i + ":" + amounts[i]) } this.initData(amounts) break case 1: //从入账类别表中读出一级类别信息 await this.viewMarray('rtable', this.rmanager) for (var i = 0;i < this.rmanager.length; i++) { console.info("一级类别" + this.rmanager[i]) } //从入账类别表中读出一级类别、二级类别信息 await this.viewRecord('