private async void Sync_upAction(object sender, RoutedEventArgs e) { /* if (WordList.Substring(0, 4) == "false") { var dialog = new ContentDialog() { Title = "Info", Content = "WordList is Null!", PrimaryButtonText = "OK", SecondaryButtonText = "Cancel", FullSizeDesired = false, }; dialog.PrimaryButtonClick += (_s, _e) => { }; await dialog.ShowAsync(); }*/ // Clear Erro message // Create proxy instance String Userid = "ljp"; pdf.ServiceReference1.Service1Client serviceClient_f = new pdf.ServiceReference1.Service1Client(); // async call WCF method to get returned data pdf.ServiceReference1.querySqlRequest request_f = new pdf.ServiceReference1.querySqlRequest(Userid, "123", true); pdf.ServiceReference1.querySqlResponse ds_f = await serviceClient_f.querySqlAsync(request_f); if (ds_f.queryParam) { // Convert Xml to List<Article> //String a = ds_f.querySqlResult.Nodes[1].ToString(); XDocument xdoc = XDocument.Parse(ds_f.querySqlResult.Nodes[1].ToString(), LoadOptions.None); var data = from query in xdoc.Descendants("Table") select new Article_ { userid = query.Element("userid").Value, wordlist = query.Element("wordlist").Value, }; Task.Run(() => { ImportWordList(); }); while (bgetword == false) ; bgetword = false; string WordList = ""; for (int i = 0; i < Wordlist.Length; i++) { WordList += Wordlist[i]; } //string WordList = "name01名称"; pdf.ServiceReference2.Service2Client serviceClient = new pdf.ServiceReference2.Service2Client(); // WordList = "afcafnohsauauahiubcinskjiwejksbndfuihsdiusdfhajksdbcvnmxbcjhdhsfjhisahfiuafhasjkhfisahfhsajkfhajkajk"; bool IsInsert = false; if (data.Count() == 0) { IsInsert = true; } pdf.ServiceReference2.querySqlRequest request = new pdf.ServiceReference2.querySqlRequest(Userid, WordList, IsInsert); pdf.ServiceReference2.querySqlResponse ds = await serviceClient.querySqlAsync(request); if (ds.queryParam) { var dialog = new ContentDialog() { Title = "wordlist", Content = "Sync Success!", PrimaryButtonText = "OK", SecondaryButtonText = "Cancel", FullSizeDesired = false, }; dialog.PrimaryButtonClick += (_s, _e) => { }; await dialog.ShowAsync(); } else { var dialog = new ContentDialog() { Title = "wordlist", Content = "Insert Error occurs. Please make sure the database has been attached to SQL Server!", PrimaryButtonText = "OK", SecondaryButtonText = "Cancel", FullSizeDesired = false, }; dialog.PrimaryButtonClick += (_s, _e) => { }; await dialog.ShowAsync(); } } else { var dialog = new ContentDialog() { Title = "wordlist", Content = "Insert Error occurs. Please make sure the database has been attached to SQL Server!", PrimaryButtonText = "OK", SecondaryButtonText = "Cancel", FullSizeDesired = false, }; dialog.PrimaryButtonClick += (_s, _e) => { }; await dialog.ShowAsync(); } }
private async void Sync_downAction(object sender, RoutedEventArgs e) { // Clear Erro message // Create proxy instance String Userid = "ljp"; pdf.ServiceReference1.Service1Client serviceClient_f = new pdf.ServiceReference1.Service1Client(); // async call WCF method to get returned data pdf.ServiceReference1.querySqlRequest request_f = new pdf.ServiceReference1.querySqlRequest(Userid, "123", true); pdf.ServiceReference1.querySqlResponse ds_f = await serviceClient_f.querySqlAsync(request_f); if (ds_f.queryParam) { // Convert Xml to List<Article> String a = ds_f.querySqlResult.Nodes[1].ToString(); XDocument xdoc = XDocument.Parse(ds_f.querySqlResult.Nodes[1].ToString(), LoadOptions.None); var data = from query in xdoc.Descendants("Table") select new Article_ { userid = query.Element("userid").Value, wordlist = query.Element("wordlist").Value, }; if (data.Count() == 0) { var dialog = new ContentDialog() { Title = "wordlist", Content = "user doesn't exist!", PrimaryButtonText = "OK", SecondaryButtonText = "Cancel", FullSizeDesired = false, }; dialog.PrimaryButtonClick += (_s, _e) => { }; await dialog.ShowAsync(); } else { String WordList = xdoc.Root.Value.ToString(); WordList = WordList.Replace(Userid, ""); var dialog = new ContentDialog() { Title = "wordlist", Content = "download success!", PrimaryButtonText = "OK", SecondaryButtonText = "Cancel", FullSizeDesired = false, }; dialog.PrimaryButtonClick += (_s, _e) => { }; await dialog.ShowAsync(); } } }