鸿蒙云数据库开发项目课程表 - IT评测·应用市场-qidao123.com

position(coursesData:YunCourseSchedules[][]){
let x=13
let position:YunCourseSchedules[]=[]
let allposition:YunCourseSchedules[][]=[]
let exactnum:number[]=[] //精确每个课是第几节开始上的
let num:number[]=[]
let selectweekcourseLessons :number[][] = [] //每个星期所有课程是第几节课上课
let courseDuration:number[]=[]//课程时长
for (let index = 0; index < 7; index++) {
for (let y = 0; y < coursesData[index].length; y++) {
x-=coursesData[index][y].courseDuration
num.push(coursesData[index][y].courseLessons)
exactnum.push(coursesData[index][y].courseLessons)
courseDuration.push(coursesData[index][y].courseDuration)
}
selectweekcourseLessons.push(num)
console.log(TAG+JSON.stringify(CourseCommon.TABLEWEEK[index])+" 剩余空数量" + JSON.stringify(x));
console.log(TAG+JSON.stringify(CourseCommon.TABLEWEEK[index])+" 第几节开始上:" + JSON.stringify(exactnum));
console.log(TAG+JSON.stringify(CourseCommon.TABLEWEEK[index])+" 课程时长:" + JSON.stringify(courseDuration));
// 精确课程位置
let s=0
for (let y = 0; y < exactnum.length; y++){
if (exactnum[y]+courseDuration[y]>=exactnum[y+1]){
exactnum[y+1]=exactnum[y]+1-s
}
if (exactnum[y]+courseDuration[y]<exactnum[y+1]){
exactnum[y+1]=exactnum[y+1]-courseDuration[y]+1-s
}
s=courseDuration[y]+s-1 //去掉之前的课程时长
}
for (let z = 0; z < x+exactnum.length; z++) {
position.push(new YunCourseSchedules())
}
for(let z = 0;z<exactnum.length;z++){
position[exactnum[z]-1]=coursesData[index][z]
}
console.log(TAG,"position:" + JSON.stringify(position));
allposition.push(position) //所有课程位置
// 重置相关变量为下一天做准备
position=[]
exactnum=[]
num=[]
courseDuration=[]
x=13
}
CourseDatamodel.getContext().setSelectWeekCourseLessons(selectweekcourseLessons)
console.log( "ScheduleLayout"+JSON.stringify(selectweekcourseLessons));
return allposition
}

复制代码

async addorupdate(className:string,teacher:string,place:string,people:number,courseDuration:number,content:string,classroomtype:number,id:number): Promise<boolean>{
try {
if (className!=''&&teacher!=''&&place!=''&&content!='') {
let ison = false
//判断添加的时长有没有占用其他课程的位置和有没有超出最大时间槽
for (let index = 0; index <= CourseDatamodel.getContext()
.getSelectWeekCourseLessons()[CourseDatamodel.getContext().getselectWeek()]
.length; index++) {
//判断当前日期为不为空
if (CourseDatamodel.getContext()
.getSelectWeekCourseLessons()[CourseDatamodel.getContext().getselectWeek()]
.length != 0) {
//排在其中一个课程的前面
if (CourseDatamodel.getContext().getIndex() < CourseDatamodel.getContext()
.getSelectWeekCourseLessons()[CourseDatamodel.getContext().getselectWeek()][index]) {
if (courseDuration + CourseDatamodel.getContext().getIndex() - 1 >= 13 ||
courseDuration + CourseDatamodel.getContext().getIndex() - 1 >= CourseDatamodel.getContext()
.getSelectWeekCourseLessons()[CourseDatamodel.getContext().getselectWeek()][index]) {
ison = false
break
} else {
ison = true
break
}
}
//排在所有课程后面
if (index == CourseDatamodel.getContext()
.getSelectWeekCourseLessons()[CourseDatamodel.getContext().getselectWeek()]
.length) {
if (courseDuration + CourseDatamodel.getContext().getIndex() - 1 <= 13) {
ison = true
break
} else {
ison = false
break
}
}
} else {
if (courseDuration + CourseDatamodel.getContext().getIndex() - 1 <= 13) {
ison = true
break
} else {
ison = false
break
}
}
}
if (ison == true) {
const courseSchedules = new YunCourseSchedules()
if (id != 0) {
courseSchedules.setId(id)
}
courseSchedules.setClassName(className)
courseSchedules.setTeacher(teacher)
courseSchedules.setClassroom(place)
courseSchedules.setPeople(content)
courseSchedules.setPeople(people)
courseSchedules.setCourseDuration(courseDuration)
courseSchedules.setIntroduction(content)
courseSchedules.setColor(Colors.creatcolors())
courseSchedules.setClassroomtype(classroomtype)
courseSchedules.setWeek(CourseDatamodel.getContext().getWeek())
courseSchedules.setCourseLessons(CourseDatamodel.getContext().getIndex())
await this.database.upsert(courseSchedules)
console.log(this.TAG, "添加数据成功");
promptAction.showToast({
message: '添加成功',
duration: 2000,
});
return true
} else {
AlertDialog.show({
title: "警告",
message: '添加失败，时长过长'
})
console.log(this.TAG, "添加数据失败", "原因：时长过长");
return false
}
}else {
AlertDialog.show({
title:"警告",
message:'不能为空'
})
console.error(this.TAG,"添加数据失败");
return false
}
} catch (e) {
AlertDialog.show({
title:"警告",
message:'添加失败'
})
console.error(this.TAG,"添加数据失败","原因：",JSON.stringify(e));
return false
}
}

复制代码