private void Usertest() //用户数据库测试
{
using (SQLiteConnection conn = UserDatabase.GetDbConnection())
{
Debug.WriteLine(conn.DatabasePath.ToString());//找出数据库位置
TableQuery <UserAccount> t = conn.Table <UserAccount>();
var q = from s in t.AsParallel <UserAccount>()
orderby s.user_id
select s;
useracccount.Clear();
foreach (var temp in q)
{
useracccount.Add(temp);
}
//StringBuilder msg = new StringBuilder();
//msg.AppendLine($"数据库中总共 {useracccount.Count()} 个 user 对象。");
/////测试数据库出来的实例location转换
//foreach (var item in useracccount)
//{
// msg.AppendLine($"Id：{item.user_id}；Name：{item.name}");
//}
//new MessageDialog(msg.ToString()).ShowAsync();
}
}
public List <PartOfSpeechStorage> QueryPartOfSpeech(int _entry_id)
{
TableQuery <PartOfSpeechStorage> t = Connection.Table <PartOfSpeechStorage>();
ParallelQuery <PartOfSpeechStorage> q = from s in t.AsParallel()
where s.Entry_ID == _entry_id
select s;
return(q.ToList());
}
public Pos_OfflineSource1 QueryPos(int _pos_id)
{
TableQuery <Pos_OfflineSource1> t = Connection.Table <Pos_OfflineSource1>();
ParallelQuery <Pos_OfflineSource1> q = from s in t.AsParallel()
where s.ID == _pos_id
select s;
return(q.ToList()[0]);
}
public List <MeanStorage> QueryMeans(Guid _definition_id)
{
TableQuery <MeanStorage> t = Connection.Table <MeanStorage>();
ParallelQuery <MeanStorage> q = from s in t.AsParallel()
where s.Definition_ID == _definition_id
select s;
return(q.ToList());
}
public WordNoteBookModel QueryByID(int ID)
{
TableQuery <WordNoteBookModel> t = Connection.Table <WordNoteBookModel>();
ParallelQuery <WordNoteBookModel> q = from s in t.AsParallel()
where s.ID == ID
select s;
return(q.ToList()[0]);
}
public WordNoteModel Query(string _word, int _notebookid)
{
TableQuery <WordNoteModel> t = Connection.Table <WordNoteModel>();
ParallelQuery <WordNoteModel> q = from s in t.AsParallel()
where s.Word == _word & s.WordNoteBookID == _notebookid
select s;
return(q.ToList()[0]);
}
public int FindEntryID(string _word, int _dictionarysource_id)
{
TableQuery <WordsStorageModel> t = Connection.Table <WordsStorageModel>();
ParallelQuery <WordsStorageModel> q = from s in t.AsParallel()
where s.Word == _word & s.DictionarySource_ID == _dictionarysource_id
select s;
return(q.ToList()[0].ID);
}
public WordsStorageModel QueryEntry(int _word_id, int _dictionarysource_id)
{
TableQuery <WordsStorageModel> t = Connection.Table <WordsStorageModel>();
ParallelQuery <WordsStorageModel> q = from s in t.AsParallel()
where s.Word_ID == _word_id & s.DictionarySource_ID == _dictionarysource_id
select s;
return(q.ToList()[0]);
}
public int FindWordID(string _word)
{
TableQuery <Word> t = Connection.Table <Word>();
ParallelQuery <Word> q = from s in t.AsParallel()
where s.Spelling == _word
select s;
return(q.ToList()[0].ID);
}
public List <WordHistoryModel> QueryAllOrderByIDDescending()
{
TableQuery <WordHistoryModel> t = Connection.Table <WordHistoryModel>();
ParallelQuery <WordHistoryModel> q = from s in t.AsParallel()
orderby s.ID descending
select s;
return(q.ToList());
}
public List <Mean_OfflineSource1> QueryMean(int _word_id)
{
TableQuery <Mean_OfflineSource1> t = Connection.Table <Mean_OfflineSource1>();
ParallelQuery <Mean_OfflineSource1> q = from s in t.AsParallel()
where s.wordID == _word_id
select s;
return(q.ToList());
}
public List <WordHistoryModel> QueryByTaskID(Guid taskID)
{
TableQuery <WordHistoryModel> t = Connection.Table <WordHistoryModel>();
ParallelQuery <WordHistoryModel> q = from s in t.AsParallel()
orderby s.ID descending
select s;
return(q.ToList());
}
public List <WordNoteBookModel> Query()
{
TableQuery <WordNoteBookModel> t = Connection.Table <WordNoteBookModel>();
ParallelQuery <WordNoteBookModel> q = from s in t.AsParallel()
orderby s.ID descending
select s;
return(q.ToList());
}
public List <DefinitionStroage> QueryDefinitions(int _entryid)
{
TableQuery <DefinitionStroage> t = Connection.Table <DefinitionStroage>();
ParallelQuery <DefinitionStroage> q = from s in t.AsParallel()
where s.Entry_ID == _entryid
select s;
return(q.ToList());
}
public Words_OfflineSource1 QueryWord(string _word)
{
TableQuery <Words_OfflineSource1> t = Connection.Table <Words_OfflineSource1>();
ParallelQuery <Words_OfflineSource1> q = from s in t.AsParallel()
where s.word == _word
select s;
var l = q.ToList();
return(l.Count > 0 ? l[0] : null);
}
public WordHistoryModel QueryByID(int ID)
{
TableQuery <WordHistoryModel> t = Connection.Table <WordHistoryModel>();
ParallelQuery <WordHistoryModel> q = from s in t.AsParallel()
where s.ID == ID
select s;
var l = q.ToList();
return(l.Count > 0 ? l[0] : null);
}
public List <WordNoteModel> QueryByNoteBookID(int _wordNoteBookID)
{
TableQuery <WordNoteModel> t = Connection.Table <WordNoteModel>();
ParallelQuery <WordNoteModel> q = from s in t.AsParallel()
where s.WordNoteBookID == _wordNoteBookID
orderby s.OrderedIndex ascending
select s;
return(q.ToList());
}
public int Count()
{
try
{
TableQuery <WordNoteBookModel> t = Connection.Table <WordNoteBookModel>();
ParallelQuery <WordNoteBookModel> q = from s in t.AsParallel()
select s;
return(q.ToList().Count);
}
catch
{
return(0);
}
}
public bool IfEntryExist(string _word, int _dictionarysource_id)
{
TableQuery <WordsStorageModel> t = Connection.Table <WordsStorageModel>();
ParallelQuery <WordsStorageModel> q = from s in t.AsParallel()
where s.Word == _word & s.DictionarySource_ID == _dictionarysource_id
select s;
if (q.ToList().Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool IsWordSaved(string _word, int NoteBookID)
{
TableQuery <WordNoteModel> t = Connection.Table <WordNoteModel>();
ParallelQuery <WordNoteModel> q = from s in t.AsParallel()
where s.Word == _word & s.WordNoteBookID == NoteBookID
select s;
if (q.ToList().Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool IfWordExist(string _word)
{
TableQuery <Word> t = Connection.Table <Word>();
ParallelQuery <Word> q = from s in t.AsParallel()
where s.Spelling == _word
select s;
if (q.ToList().Count == 1)
{
return(true);
}
else
{
return(false);
}
}
private void reNameBox_Loaded(object sender, RoutedEventArgs e)
{
using (SQLiteConnection conn = UserDatabase.GetDbConnection())
{
TableQuery <UserAccount> t = conn.Table <UserAccount>();
var q = from s in t.AsParallel <UserAccount>()
orderby s.user_id
where s.user_id == this_account
select s;
///如何将用户登陆后的账户通信到这些页面呢？？这个分支采用导航传参数
foreach (var item in q)
{
reNameBox.Text = item.nickname.ToString();
}
}
}
public static ViewPostHelperClass GetVideoWatchRecord(string id)
{
using (var conn = GetDbConnection())
{
TableQuery <ViewPostHelperClass> t = conn.Table <ViewPostHelperClass>();
var q = from s in t.AsParallel <ViewPostHelperClass>()
where s.epId == id
select s;
if (q.ToList().Count != 0)
{
return(q.ToList()[0]);
}
else
{
return(null);
}
}
}
//private void Ellipse_PointerPressed(object sender, PointerRoutedEventArgs e)
//{
//}
private void dataload() //用于打开页面加载路程数据等方法
{
using (SQLiteConnection conn = UserDatabase.GetDbConnection())
{
TableQuery <UserAccount> t = conn.Table <UserAccount>();
var q = from s in t.AsParallel <UserAccount>()
orderby s.user_id where s.user_id == this_account
select s;
///如何将用户登陆后的账户通信到这些页面呢？？这个分支采用导航传参数
foreach (var item in q)
{
distanceText.Text = item.in_distance.ToString();
savecarbonText.Text = item.carbon_save.ToString();
calText.Text = item.calorie_cousume.ToString();
numberText.Text = item.phonenumber.ToString();
}
}
}
public static HistoryClass GetHistory(string id)
{
using (var conn = GetDbConnection())
{
//var dbPerson = conn.Table<CommicHistoryClass>();
TableQuery <HistoryClass> t = conn.Table <HistoryClass>();
var q = from s in t.AsParallel <HistoryClass>()
where s._aid == id
select s;
// 绑定
if (q.ToList().Count != 0)
{
return(q.ToList()[0]);
}
else
{
return(null);
}
}
}
private void dataload() //用于打开页面加载路程数据等方法
{
using (SQLiteConnection conn = UserDatabase.GetDbConnection())
{
TableQuery <UserAccount> t = conn.Table <UserAccount>();
var q = from s in t.AsParallel <UserAccount>()
orderby s.user_id
where s.user_id == this_account
select s;
foreach (var item in q)
{
nicknameText.Text = item.nickname.ToString();
nameText.Text = item.name.ToString();
phoneText.Text = item.phonenumber.ToString();
//headpictureE 如何设置头像？
}
}
}
public int QueryMaxID()
{
int maxid = 0;
TableQuery <WordNoteModel> t = Connection.Table <WordNoteModel>();
ParallelQuery <WordNoteModel> q = from s in t.AsParallel()
select s;
var list = q.ToList();
if (list != null)
{
foreach (var item in list)
{
while (item.ID >= maxid)
{
maxid++;
}
}
return(maxid);
}
else
{
return(0);
}
}
private void Bicycletest() //单车数据库测试
{
using (SQLiteConnection conn = BicycleDatabase.GetDbConnection())
{
TableQuery <Bicycle> t = conn.Table <Bicycle>();
var q = from s in t.AsParallel <Bicycle>()
orderby s.bicycle_id
select s;
// 绑定
bicycle.Clear();
map.MapElements.Clear();
foreach (var temp in q)
{
bicycle.Add(temp);
}
foreach (var temp in bicycle.Select(temp => current_location_parse(temp.current_location))
.Select(temp => new Geopoint(new BasicGeoposition()
{
Latitude = temp.x,
Longitude = temp.y,
})).Select(temp => new MapIcon()
{
Location = temp,
Image = RandomAccessStreamReference.
CreateFromUri(new Uri("ms-appx:///Assets/Bicycle.png")),
}))
{
map.MapElements.Add(temp);
}
#region
//List<List<string>> lat_lon = new List<List<string>>();
////将现在位置存入
//foreach (var item in bicycle)
//{
// lat_lon.Add(item.current_location.Split(',').ToList());
//}
//List<Geopoint> bikepoint = new List<Geopoint>();
//foreach (var item in lat_lon)
//{
// bikepoint.Add(new Geopoint(new BasicGeoposition()
// {
// Latitude = double.Parse(item[0]),
// Longitude = double.Parse(item[1]),
// }));
//}
//List<MapIcon> bikeicon = new List<MapIcon>();
//foreach (var item in bikepoint)
//{
// bikeicon.Add(new MapIcon() { Location = item }); //单车图标未定
//}
//foreach (var item in bikeicon)
//{
// map.MapElements.Add(item);
//}
#endregion
}
(double x, double y) current_location_parse(string current_location)
{
var str = current_location.Split(',');
double.TryParse(str[0], out var x);
double.TryParse(str[1], out var y);
return(x, y);
}
}