public int Update(int collectId, CollectTaskStatus oldStatus, CollectTaskStatus newStatus)
{
var sql = $"UPDATE CollectTasks SET Status = {(int)newStatus} WHERE CollectId = {collectId} AND Status = {(int)oldStatus}";
return(SqliteProxy.Execute(sql));
}
public CollectTaskInfo SelectSingle(int collectId, CollectTaskStatus status)
{
var sql = $"SELECT * FROM CollectTasks WHERE CollectId = {collectId} AND Status = {(int)status}";
return(SqliteProxy.SelectSingle(sql, this.Convert));
}
