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)); }