public static bool delUploadFromSqlite(string guid)
{
string sql = string.Format("DELETE FROM UploadData WHERE Guid='{0}'", guid);
int result = SqliteDBHelp.ExecuteSql(sql);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool SetUploaded(string guid)
{
//string sql = string.Format("UPDATE UploadData SET IsUpload=1 WHERE Guid='{0}'", guid);
string sql = string.Format("DELETE FROM UploadData WHERE Guid='{0}'", guid);
int result = SqliteDBHelp.ExecuteSql(sql);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public static void updateMsgToSqlite(string guid, string msg)
{
string sql = string.Format("update UploadData set MSG='{0}',IsUpload=1 WHERE GUID='{1}'", msg, guid);
SqliteDBHelp.ExecuteSql(sql);
}
public static bool DeleteUploaded(string guid)
{
string sql = string.Format("DELETE FROM UploadData WHERE Guid='{0}'", guid);
return(SqliteDBHelp.ExecuteSql(sql) > 0);
}