public bool DeleteCollect(CollectStruct info)
{
bool isSuccess = true;
string sql = "delete from collect where name='" + info.Name + "' and url='" + info.Href + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_connect);
command.ExecuteNonQuery();
return(isSuccess);
}
public CollectStruct SearchCollectByName(string name, string url)
{
CollectStruct collectInfo;
collectInfo = new CollectStruct();
string sql = "select * from collect where name='" + name + "' and url='" + url + "'";
SQLiteCommand command = new SQLiteCommand(sql, m_connect);
var reader = command.ExecuteReader();
collectInfo = new CollectStruct();
while (reader.Read())
{
collectInfo.Href = reader["url"].ToString();
collectInfo.Name = reader["name"].ToString();
collectInfo.ImagePath = reader["imagePath"].ToString();
}
return(collectInfo);
}
public List <CollectStruct> GetCollet()
{
CollectStruct collectInfo;
List <CollectStruct> list;
list = new List <CollectStruct>();
string commandText = "select * from collect";
SQLiteCommand command = m_connect.CreateCommand();
command.CommandText = commandText;
var reader = command.ExecuteReader();
while (reader.Read())
{
collectInfo = new CollectStruct();
collectInfo.Href = reader["url"].ToString();
collectInfo.Name = reader["name"].ToString();
collectInfo.ImagePath = reader["imagePath"].ToString();
list.Add(collectInfo);
}
return(list);
}
