public void DeleteIcon(string url)
{
if (string.IsNullOrWhiteSpace(url))
{
return;
}
this.DoNonQuery("DELETE FROM bzt_app_bomg_icons WHERE ico_key='" + SQLiteDatabase2.EscapeValue(url) + "';");
}
/* public bool AddIcon(string url, Image image)
* {
* if (string.IsNullOrWhiteSpace(url))
* {
* return false;
* }
*
* if (image == null)
* {
* return false;
* }
*
* if (this.HasIcon(url))
* {
* return this.DoNonQuery("UPDATE bzt_app_bomg_icons SET='" + imageToSQLString(image) + "' WHERE ico_key='" + SQLiteDatabase2.escapeValue(url) + "';") >= 0;
* }
* else
* {
* return this.DoNonQuery("INSERT INTO bzt_app_bomg_icons (ico_key, ico_content) VALUES ('" + SQLiteDatabase2.escapeValue(url) + "', '" + imageToSQLString(image) + "');") >= 0;
* }
* }*/
public bool AddIcon(string url, byte[] image)
{
if (string.IsNullOrWhiteSpace(url))
{
return(false);
}
if (image == null)
{
return(false);
}
if (this.HasIcon(url))
{
return(this.DoNonQuery("UPDATE bzt_app_bomg_icons SET='" + bytesToSQLString(image) + "' WHERE ico_key='" + SQLiteDatabase2.EscapeValue(url) + "';") >= 0);
}
else
{
return(this.DoNonQuery("INSERT INTO bzt_app_bomg_icons (ico_key, ico_content) VALUES ('" + SQLiteDatabase2.EscapeValue(url) + "', '" + bytesToSQLString(image) + "');") >= 0);
}
}
public Image GetIcon(string url)
{
if (!this.HasIcon(url))
{
return(null);
}
string rs = this.DoQuerySingle("SELECT ico_content FROM bzt_app_bomg_icons WHERE ico_key='" + SQLiteDatabase2.EscapeValue(url) + "'");
return(sqlStringToImage(rs));
}
public bool HasIcon(string url)
{
return(this.DoQueryExist("SELECT 1 FROM bzt_app_bomg_icons WHERE ico_key='" + SQLiteDatabase2.EscapeValue(url) + "'"));
}