uwp连接mysql数据库_c# – UWP – 比较JSON和数据库的数据

我有一个名为ebookstore.db的数据库,如下所示：

和JSON如下：

我想当JSON上的slug与数据库中的标题不同时,它将显示带有JSON上的slug的数据量,这与ukomikText中数据库中的标题不同.

码：

string judulbuku;

try

{

string urlPath1 = "https://...";

var httpClient1 = new HttpClient(new HttpClientHandler());

httpClient1.DefaultRequestHeaders.TryAddWithoutValidation("KIAT-API-KEY", "....");

var values1 = new List>

{

new KeyValuePair("halaman", 1),

new KeyValuePair("limit", 100),

};

var response1 = await httpClient1.PostAsync(urlPath1, new FormUrlEncodedContent(values1));

response1.EnsureSuccessStatusCode();

if (!response1.IsSuccessStatusCode)

{

MessageDialog messageDialog = new MessageDialog("Memeriksa update Komik gagal", "Gangguan Server");

await messageDialog.ShowAsync();

}

string jsonText1 = await response1.Content.ReadAsStringAsync();

JsonObject jsonObject1 = JsonObject.Parse(jsonText1);

JsonArray jsonData1 = jsonObject1["data"].GetArray();

foreach (JsonValue groupValue in jsonData1)

{

JsonObject groupObject = groupValue.GetObject();

string id = groupObject["id"].GetString();

string judul = groupObject["judul"].GetString();

string slug = groupObject["slug"].GetString();

BukuUpdate file1 = new BukuUpdate();

file1.ID = id;

file1.Judul = judul;

file1.Slug = slug;

List title = sqlhelp.GetKomikData();

foreach (string juduldb in title)

{

judulbuku = juduldb.Substring(juduldb.IndexOf('.') + 1);

if (judulbuku != file1.Slug.Replace("-", "_") + ".pdf")

{

BukuData.Add(file1);

ListBuku.ItemsSource = BukuData;

}

else

{

ukomikText.Text = "belum tersedia komik yang baru";

ukomikText.Visibility = Visibility.Visible;

}

}

}

if (ListBuku.Items.Count > 0)

{

ukomikText.Text = BukuData.Count + " komik baru";

ukomikText.Visibility = Visibility.Visible;

jumlahbuku = BukuData.Count;

}

else

{

ukomikText.Text = "belum tersedia komik yang baru";

ukomikText.Visibility = Visibility.Visible;

}

public static List GetKomikData()

{

List entries = new List();

using (SqliteConnection db =

new SqliteConnection("Filename=ebookstore.db"))

{

db.Open();

SqliteCommand selectCommand = new SqliteCommand

("SELECT title FROM books where folder_id = 67", db);

SqliteDataReader query = selectCommand.ExecuteReader();

while (query.Read())

{

entries.Add(query.GetString(0));

}

db.Close();

}

return entries;

}

BukuUpdate.cs：

public string ID { get; set; }

public string Judul { get; set; }

public string Slug { get; set; }

我有一个问题,就是当检查JSON上的slu,然后显示的slug是第一个slug在数据库中重复显示尽可能多的数据,之后在数据库上反复显示第二个slug,等等, 如下：

如何解决它,以便不重复显示JSON上的slug(根据JSON上的数据量)？