public async Task CreatTable() { if (await isDataBaseExist() == false) { SQLiteAsyncConnection conn = GetConn(); await conn.CreateTableAsync <DB_TimePeriodList>(); await conn.CreateTableAsync <DB_TimePointList>(); await conn.CreateTableAsync <DB_Friend>(); await conn.CreateTableAsync <DB_More>(); insert_TimePeriodList(new DB_TimePeriodList("游戏", 1, false)); insert_TimePeriodList(new DB_TimePeriodList("微博", 15, false)); insert_TimePointList(new DB_TimePointList("睡觉", new TimeSpan(20, 30, 30), false)); insert_TimePointList(new DB_TimePointList("学习", new TimeSpan(20, 30, 30), false)); DB_More_Controll moreControll = new DB_More_Controll(); moreControll.insertUpdate_More(new DB_More("Asuka", "anta baka?", 1, "\\more\\avatar.jpg")); } await _get_timePeriodList(); await _get_timePointList(); }
private async void Test_More() { StorageFolder applicationFolder = ApplicationData.Current.LocalFolder; await applicationFolder.CreateFolderAsync("more", CreationCollisionOption.ReplaceExisting); StorageFolder imageFolder = await applicationFolder.GetFolderAsync("more"); await imageFolder.CreateFileAsync("avatar.jpg", CreationCollisionOption.ReplaceExisting); StorageFile imageFile = await imageFolder.GetFileAsync("avatar.jpg"); StorageFile inFile = await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///Resource/avatar_test.jpg")); await inFile.CopyAndReplaceAsync(imageFile); DB_More_Controll moreControll = new DB_More_Controll(); DB_More more = await moreControll.get_more(); more_nickName.Text = more.nickName; more_sex.SelectedIndex = more.sex; avatar_img.Source = new BitmapImage(new Uri(applicationFolder.Path + more.avatarPath)); more_declaration.Text = more.declaration; }