public void DeleteWork (int lane_id, int revision_id, int host_id)
{
using (IDbCommand cmd = CreateCommand ()) {
// cmd.CommandText = "DELETE FROM Work WHERE lane_id = @lane_id AND revision_id = @revision_id AND host_id = @host_id;";
cmd.CommandText = @"
DELETE FROM Work
WHERE Work.revisionwork_id =
(SELECT id
FROM RevisionWork
WHERE lane_id = @lane_id
AND revision_id = @revision_id
AND host_id = @host_id
);
UPDATE RevisionWork SET state = 10 WHERE lane_id = @lane_id AND host_id = @host_id AND revision_id = @revision_id;";
DB.CreateParameter (cmd, "lane_id", lane_id);
DB.CreateParameter (cmd, "revision_id", revision_id);
DB.CreateParameter (cmd, "host_id", host_id);
cmd.ExecuteNonQuery ();
}
//TODO: Directory.Delete(Configuration.GetDataRevisionDir(lane, revision), true);
}