public void BuBuGao_cWordList(View.BuBuGao.Question question)
{
foreach (View.BuBuGao.Word item in question.Words)
{
item.QuestionID = question.ID;
mDatabase.InsertAsync(item).Wait(); // 重要 // 批量插入时不加上 Wait() 会取不到 Word id, 从而被后面插入的数据覆盖
}
}
private void InsertWordList(View.BuBuGao.Question question)
{
foreach (View.BuBuGao.Word item in question.Words)
{
item.QuestionID = question.ID;
mDatabase.InsertAsync(item).Wait(); // 重要
}
}
public void BuBuGao_uQuestion(View.BuBuGao.Question question)
{
mDatabase.UpdateAsync(question);
}
public async System.Threading.Tasks.Task <int> BuBuGao_cQuestion(View.BuBuGao.Question question)
{
return(await mDatabase.InsertAsync(question));
}
public void initBuBuGaoStructure()
{
mDatabase.CreateTableAsync <View.BuBuGao.Word>().Wait();
mDatabase.CreateTableAsync <View.BuBuGao.Question>().Wait();
#region 基本数据
DateTime now = DateTime.Now;
View.BuBuGao.Question a1 = new View.BuBuGao.Question();
a1.Name = "天空";
a1.Words = new List <View.BuBuGao.Word>()
{
new View.BuBuGao.Word()
{
Content = "天空"
},
new View.BuBuGao.Word()
{
Content = "空气"
},
new View.BuBuGao.Word()
{
Content = "气体"
},
new View.BuBuGao.Word()
{
Content = "体力"
},
new View.BuBuGao.Word()
{
Content = "力度"
},
new View.BuBuGao.Word()
{
Content = "度过"
},
new View.BuBuGao.Word()
{
Content = "过去"
},
new View.BuBuGao.Word()
{
Content = "去年"
},
new View.BuBuGao.Word()
{
Content = "年轻"
},
new View.BuBuGao.Word()
{
Content = "轻松"
},
new View.BuBuGao.Word()
{
Content = "松树"
},
new View.BuBuGao.Word()
{
Content = "树木"
}
};
a1.CreateDateTimeValue = now.Ticks;
View.BuBuGao.Question a2 = new View.BuBuGao.Question();
a2.Name = "大人";
a2.Words = new List <View.BuBuGao.Word>()
{
new View.BuBuGao.Word()
{
Content = "大人"
},
new View.BuBuGao.Word()
{
Content = "人生"
},
new View.BuBuGao.Word()
{
Content = "生命"
},
new View.BuBuGao.Word()
{
Content = "命运"
},
new View.BuBuGao.Word()
{
Content = "运货"
},
new View.BuBuGao.Word()
{
Content = "货物"
},
new View.BuBuGao.Word()
{
Content = "物品"
},
new View.BuBuGao.Word()
{
Content = "品尝"
},
new View.BuBuGao.Word()
{
Content = "尝试"
},
new View.BuBuGao.Word()
{
Content = "试验"
},
new View.BuBuGao.Word()
{
Content = "验证"
},
new View.BuBuGao.Word()
{
Content = "证明"
}
};
a2.CreateDateTimeValue = now.Ticks;
View.BuBuGao.Question a3 = new View.BuBuGao.Question();
a3.Name = "红豆";
a3.Words = new List <View.BuBuGao.Word>()
{
new View.BuBuGao.Word()
{
Content = "红豆"
},
new View.BuBuGao.Word()
{
Content = "豆沙"
},
new View.BuBuGao.Word()
{
Content = "沙子"
},
new View.BuBuGao.Word()
{
Content = "子女"
},
new View.BuBuGao.Word()
{
Content = "女巫"
},
new View.BuBuGao.Word()
{
Content = "巫师"
},
new View.BuBuGao.Word()
{
Content = "师父"
},
new View.BuBuGao.Word()
{
Content = "父亲节"
},
new View.BuBuGao.Word()
{
Content = "节约"
},
new View.BuBuGao.Word()
{
Content = "约见"
},
new View.BuBuGao.Word()
{
Content = "见面"
},
new View.BuBuGao.Word()
{
Content = "面粉"
}
};
a3.CreateDateTimeValue = now.Ticks;
View.BuBuGao.Question a4 = new View.BuBuGao.Question();
a4.Name = "太黑";
a4.Words = new List <View.BuBuGao.Word>()
{
new View.BuBuGao.Word()
{
Content = "太黑"
},
new View.BuBuGao.Word()
{
Content = "黑白"
},
new View.BuBuGao.Word()
{
Content = "白饭"
},
new View.BuBuGao.Word()
{
Content = "饭菜"
},
new View.BuBuGao.Word()
{
Content = "菜园"
},
new View.BuBuGao.Word()
{
Content = "园丁"
},
new View.BuBuGao.Word()
{
Content = "丁香花"
},
new View.BuBuGao.Word()
{
Content = "花生"
},
new View.BuBuGao.Word()
{
Content = "生气"
},
new View.BuBuGao.Word()
{
Content = "气球"
},
new View.BuBuGao.Word()
{
Content = "球体"
},
new View.BuBuGao.Word()
{
Content = "体检"
}
};
a4.CreateDateTimeValue = now.Ticks;
View.BuBuGao.Question a5 = new View.BuBuGao.Question();
a5.Name = "上面";
a5.Words = new List <View.BuBuGao.Word>()
{
new View.BuBuGao.Word()
{
Content = "上面"
},
new View.BuBuGao.Word()
{
Content = "面条"
},
new View.BuBuGao.Word()
{
Content = "条件"
},
new View.BuBuGao.Word()
{
Content = "件数"
},
new View.BuBuGao.Word()
{
Content = "数学"
},
new View.BuBuGao.Word()
{
Content = "学习"
},
new View.BuBuGao.Word()
{
Content = "习惯"
},
new View.BuBuGao.Word()
{
Content = "惯性"
},
new View.BuBuGao.Word()
{
Content = "性格"
},
new View.BuBuGao.Word()
{
Content = "格子"
},
new View.BuBuGao.Word()
{
Content = "子孙"
},
new View.BuBuGao.Word()
{
Content = "孙悟空"
}
};
a5.CreateDateTimeValue = now.Ticks;
#endregion 基本数据
mDatabase.InsertAsync(a1);
mDatabase.InsertAsync(a2);
mDatabase.InsertAsync(a3);
mDatabase.InsertAsync(a4);
mDatabase.InsertAsync(a5).Wait(); // 等待的原因 - 等待 a1 ~ a5 插入完毕, 并且取回插入到 Sqlite后 由系统自动生成的ID
BuBuGao_cWordList(a1);
BuBuGao_cWordList(a2);
BuBuGao_cWordList(a3);
BuBuGao_cWordList(a4);
BuBuGao_cWordList(a5);
}
private void updateExternalDBStruct_v2(DBVersion dbVersion)
{
dbVersion.Loaction = LocationEnum.External;
dbVersion.Version = 2;
mDatabase.InsertOrReplaceAsync(dbVersion);
// 执行数据库升级脚本
//mDatabase.CreateTableAsync<View.BuBuGao.Word>().Wait();
//mDatabase.InsertAsync(new View.BuBuGao.Word() { Content = "天空" });
mDatabase.CreateTableAsync <View.BuBuGao.Word>().Wait();
mDatabase.CreateTableAsync <View.BuBuGao.Question>().Wait();
View.BuBuGao.Question a1 = new View.BuBuGao.Question();
a1.Name = "天空";
a1.Words = new List <View.BuBuGao.Word>();
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "天空"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "空气"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "气体"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "体力"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "力度"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "度过"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "过去"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "去年"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "年轻"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "轻松"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "松树"
});
a1.Words.Add(new View.BuBuGao.Word()
{
Content = "树木"
});
View.BuBuGao.Question a2 = new View.BuBuGao.Question();
a2.Name = "大人";
a2.Words = new List <View.BuBuGao.Word>();
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "大人"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "人生"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "生命"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "命运"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "运货"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "货物"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "物品"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "品尝"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "尝试"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "试验"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "验证"
});
a2.Words.Add(new View.BuBuGao.Word()
{
Content = "证明"
});
View.BuBuGao.Question a3 = new View.BuBuGao.Question();
a3.Name = "红豆";
a3.Words = new List <View.BuBuGao.Word>();
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "红豆"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "豆沙"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "沙子"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "子女"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "女巫"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "巫师"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "师父"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "父亲节"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "节约"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "约见"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "见面"
});
a3.Words.Add(new View.BuBuGao.Word()
{
Content = "面粉"
});
View.BuBuGao.Question a4 = new View.BuBuGao.Question();
a4.Name = "太黑";
a4.Words = new List <View.BuBuGao.Word>();
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "太黑"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "黑白"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "白饭"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "饭菜"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "菜园"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "园丁"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "丁香花"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "花生"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "生气"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "气球"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "球体"
});
a4.Words.Add(new View.BuBuGao.Word()
{
Content = "体检"
});
View.BuBuGao.Question a5 = new View.BuBuGao.Question();
a5.Name = "上面";
a5.Words = new List <View.BuBuGao.Word>();
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "上面"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "面条"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "条件"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "件数"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "数学"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "学习"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "习惯"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "惯性"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "性格"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "格子"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "子孙"
});
a5.Words.Add(new View.BuBuGao.Word()
{
Content = "孙悟空"
});
mDatabase.InsertAsync(a1);
mDatabase.InsertAsync(a2);
mDatabase.InsertAsync(a3);
mDatabase.InsertAsync(a4);
mDatabase.InsertAsync(a5).Wait();
InsertWordList(a1);
InsertWordList(a2);
InsertWordList(a3);
InsertWordList(a4);
InsertWordList(a5);
}
private List <View.BuBuGao.Word> getWordsByQuestionID(View.BuBuGao.Question q)
{
return(mDatabase.Table <View.BuBuGao.Word>().Where(i => i.QuestionID == q.ID).ToListAsync().Result);
}
